/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

7 votes334 views2 answers
Python string to datetime python
Python
3 votes327 views2 answers
How to fill a list in python
Python
0 vote351 views2 answers
Detect if usb is plugged in python
Python
1 vote351 views1 answer
Get certain columns pandas with string
Python
0 vote316 views1 answer
Sinusoidal regression python
Python
0 vote314 views4 answers
Client network socket disconnected before secure TLS connection was established
Python
0 vote329 views1 answer
Im save to a bytes io python
Python
0 vote371 views3 answers
Assert in python
Python
0 vote327 views1 answer
How to print out even index in python
Python
0 vote353 views1 answer
Drop values in column with single frequency
Python