/Python/Python get column from grouped dataframe

Python get column from grouped dataframe

# You can also reset_index() on your groupby result to get back a dataframe with the name column now accessible.

import pandas as pd
df = pd.DataFrame({"a":[1,1,3], "b":[4,5.5,6], "c":[7,8,9], "name":["hello","hello","foo"]})

df_grouped = df.groupby(["a", "name"]).median().reset_index() # Resetting the index makes the column accessible

df_grouped.name

 #Output:
 0    hello
 1      foo

Source: stackoverflow.com

Similar codes

0 vote268 views3 answers
Discord python send message every minute
Python
0 vote287 views1 answer
Fill a column based on values in another column pandas
Python
-1 vote246 views1 answer
Percent chart seaborn
Python
0 vote293 views1 answer
Python slice second element of list of lists
Python
0 vote268 views1 answer
Rename pandas columns with list of new names
Python
0 vote261 views1 answer
Mechanize python XE #27
Python
1 vote259 views1 answer
How to delete a specific line in a file
Python
0 vote263 views1 answer
Change colour of control maya python
Python
50 votes273 views4 answers
Python get args
Python
4 votes266 views1 answer
Pandas dataframe convert string to float
Python