/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

1 vote97 views1 answer
How to find the most similar word in a list in python
Python
23 votes98 views2 answers
Merge on index pandas
Python
0 vote63 views5 answers
Cdf empírica python
Python
0 vote96 views1 answer
Calculate the R^2 for X and Y python
Python
0 vote139 views1 answer
Import numpy as np import matplotlib.pyplot as plt index = 0 missClassifiedIndexes = [] for label, predit in zip(y_test, predictions): if label != predict: missClassifiedIndexes.append(index) index = +1
Python
0 vote104 views1 answer
Python parsing a .srt file with regex - Remove all, keep only text
Python
0 vote108 views1 answer
Bracket balanced or not in python
Python
0 vote102 views1 answer
Python create point from coordinates
Python
4 votes101 views2 answers
Python join array of ints
Python
0 vote95 views1 answer
Python pretty print list of tuples
Python