Averaging duplicates values in dataframe

Asked May 06 '20 at 02:26

Active May 06 '20 at 02:26

Viewed 15 times

So I have a dataframe:

However, there are many duplicated values in the dataframe, after I found out which one are duplicated:

Data[Data.duplicated(keep=False)]

I got a list of which entries are duplicated:

My question is as follows: how can I get averaged values of the duplicated entries and compress them into a single entry for each duplicated entry in the original dataframe?

Example: The Maryland entry would have a single Data_Value that is an average of all the Maryland entries etc.

Thank you

edited Jun 20 '20 at 09:12

Community

asked May 06 '20 at 02:26

FateCoreUloom

1

`df.groupby('LocationDesc').mean()`. – Quang Hoang May 06 '20 at 02:28
please replace the images of your data with a textual representation that someone can copy-paste into an interpreter. your post will get more participation and is more likely to get a solution that way. – Haleemur Ali May 06 '20 at 02:29
@HaleemurAli Understood, thank you! – FateCoreUloom May 06 '20 at 02:55

Averaging duplicates values in dataframe

0 Answers0