CODEWITHSUNDEEP
python-3.xpandas
Abdullah
Abdullah

Reputation: 57

How to selecting multiple rows and take mean value based on name of the row

From this data frame I like to select rows with same concentration and also almost same name. For example, first three rows has same concentration and also same name except at the end of the name Dig_I, Dig_II, Dig_III. This 3 rows same with same concentration. I like to somehow select this three rows and take mean value of each column. After that I want to create a new data frame.

here is the whole data frame:

import pandas as pd
df = pd.read_csv("https://gist.github.com/akash062/75dea3e23a002c98c77a0b7ad3fbd25b.js")

enter image description here

Upvotes: 0

Views: 133

Answers (1)

Gess123
Gess123

Reputation: 61

import pandas as pd
df = pd.read_csv("https://gist.github.com/akash062/75dea3e23a002c98c77a0b7ad3fbd25b.js")
new_df = df.groupby('concentration').mean()

Note: This will only find the averages for columns with dtype float or int... this will drop the img_name column and will take the averages of all columns... This may be faster...

df = pd.read_csv("https://gist.github.com/akash062/75dea3e23a002c98c77a0b7ad3fbd25b.js").groupby('concentration').mean()

If you would like to preserve the img_name...

df = pd.read_csv("https://gist.github.com/akash062/75dea3e23a002c98c77a0b7ad3fbd25b.js")
new = df.groupby('concentration').mean()
pd.merge(df, new, left_on = 'concentration', right_on = 'concentration', how = 'inner')

Does that help?

Upvotes: 1

Related Questions