python - Pandas Melt Function -


i have dataframe:

df = pd.dataframe([[2, 4, 7, 8, 1, 3, 2013], [9, 2, 4, 5, 5, 6, 2014]], columns=['amy', 'bob', 'carl', 'chris', 'ben', 'other', 'year'])     amy  bob  carl  chris  ben  other  year 0    2    4     7      8    1      3  2013 1    9    2     4      5    5      6  2014

and dictionary:

d = {'a': ['amy'], 'b': ['bob', 'ben'], 'c': ['carl', 'chris']}

i reshape dataframe this:

    group   name  year  value  0         amy  2013      2  1         amy  2014      9  2      b    bob  2013      4  3      b    bob  2014      2  4      b    ben  2013      1  5      b    ben  2014      5  6      c   carl  2013      7  7      c   carl  2014      4  8      c  chris  2013      8  9      c  chris  2014      5 10  other         2013      3 11  other         2014      6

note other doesn't have values in name column , order of rows not matter. think should using melt function examples i've come across aren't clear.

melt gets part way there.

in [29]: m = pd.melt(df, id_vars=['year'], var_name='name')

this has except group. that, need reshape d bit well.

in [30]: d2 = {}  in [31]: k, v in d.items():     item in v:         d2[item] = k    ....:  in [32]: d2 out[32]: {'amy': 'a', 'ben': 'b', 'bob': 'b', 'carl': 'c', 'chris': 'c'}  in [34]: m['group'] = m['name'].map(d2)  in [35]: m out[35]:     year   name  value group 0   2013    amy      2     1   2014    amy      9     2   2013    bob      4     b 3   2014    bob      2     b 4   2013   carl      7     c ..   ...    ...    ...   ... 7   2014  chris      5     c 8   2013    ben      1     b 9   2014    ben      5     b 10  2013  other      3   nan 11  2014  other      6   nan  [12 rows x 4 columns]

and moving 'other' name group

in [8]: mask = m['name'] == 'other'  in [9]: m.loc[mask, 'name'] = ''  in [10]: m.loc[mask, 'group'] = 'other'  in [11]: m out[11]:     year   name  value  group 0   2013    amy      2      1   2014    amy      9      2   2013    bob      4      b 3   2014    bob      2      b 4   2013   carl      7      c ..   ...    ...    ...    ... 7   2014  chris      5      c 8   2013    ben      1      b 9   2014    ben      5      b 10  2013             3  other 11  2014             6  other  [12 rows x 4 columns]

Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more