/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

39 votes167 views4 answers
Convert datetime to date python
Python
6 votes169 views2 answers
How to find index of maximum value in dataframe in python
Python
2 votes176 views2 answers
Nth root of a number python
Python
3 votes189 views1 answer
Plotly not showing in jupyter
Python
26 votes185 views10 answers
For loop
Python
2 votes186 views3 answers
Python common elements in two arrays
Python
0 vote175 views1 answer
How to print smallest number in python
Python
0 vote212 views4 answers
Convert from python to curl
Python
0 vote168 views1 answer
Python find duplicated zip files
Python
0 vote202 views1 answer
Http://techforcurious.website/simulation-of-pendulum-vpython-tutorial-visual-python/
Python