/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 vote184 views1 answer
Ping with python
Python
1 vote245 views1 answer
Python filter list of int and strings
Python
3 votes158 views1 answer
Modulenotfounderror: no module named 'png'
Python
1 vote272 views2 answers
Json.stringify equivalent in python
Python
10 votes191 views5 answers
Pandas to list of dicts
Python
0 vote206 views2 answers
Push button raspberry pi
Python
6 votes183 views2 answers
Count similar values in list python
Python
0 vote272 views1 answer
Get all different element of both list python
Python
60 votes211 views6 answers
Python list length
Python
16 votes187 views3 answers
Pandas open text file
Python