/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

10 votes317 views2 answers
Python create file if doesbt exist
Python
18 votes287 views9 answers
Python sort dictionary by value
Python
1 vote384 views1 answer
Flask authentication user without database
Python Flask
0 vote339 views1 answer
Python breadth first search
Python
4 votes333 views1 answer
Python make comparison non case sensitive
Python
0 vote316 views1 answer
Selenium python has no attrirute getText
Python
0 vote324 views1 answer
Add halt for 10 seconds in selenium python
Python
0 vote657 views1 answer
Recurrent neural network pytorch
Python
2 votes287 views1 answer
Upper input python
Python
0 vote318 views2 answers
Doing math in python
Python