/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

4 votes241 views2 answers
Django composite primary key
Python Django
3 votes167 views3 answers
Pytest
Python
3 votes143 views6 answers
Counter in python
Python
16 votes172 views3 answers
Self keyword in python
Python
0 vote140 views1 answer
Python use numphy
Python
1 vote152 views2 answers
Kaggle dataset download to google colab
Python
3 votes135 views4 answers
Seaborn pairplot
Python
7 votes141 views2 answers
Mongodb aggregate group
Python
1 vote142 views2 answers
Pydictionary
Python
0 vote141 views1 answer
Python insert parent directory into sys path for import file purpose
Python