/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

2 votes146 views1 answer
How to get module path in python
Python
0 vote181 views1 answer
How to pass parameters in python script
Python
0 vote185 views1 answer
Introduction to sets python3
Python
4 votes165 views1 answer
Try with multiple except python
Python
19 votes161 views1 answer
Python substring from end
Python
1 vote204 views2 answers
SSL: CERTIFICATE_VERIFY_FAILED mongo atlas
Python
0 vote167 views1 answer
Django request.data example
Python
0 vote191 views1 answer
Pyad create user
Python
25 votes162 views6 answers
Python datetime to timestamp
Python
-1 vote169 views4 answers
How to loop over all dates in python
Python