/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 votes145 views2 answers
Make a nested list flat python
Python
60 votes141 views5 answers
Python arguments
Python
0 vote137 views1 answer
Pyfcm image
Python
0 vote122 views1 answer
;dslaoeidksamclsoeld,cmskadi934lglllfgl;llgldklkkkkjkklllloooofklllflll;=\f]p[
Python
2 votes131 views1 answer
Python read xlsb pandas
Python
68 votes127 views6 answers
Python list files in directory
Python
0 vote119 views1 answer
Pandas head sort by colun name
Python
22 votes131 views4 answers
Python is float
Python
0 vote128 views10 answers
Python generator cheat sheet download
Python
4 votes122 views1 answer
Python make integer into a list
Python