Pandas: How to average rows with two columns having similar id's?

Question

I have a dataframe like the following:

Then average the rows with similar State and County name such that the dataframe becomes this:

Any kind of help is appreciated.

There are multiple similar rows of different dates. I just added a dummy value — Saiham Rahman, Dec 15 '20 at 15:36

score 0 · Accepted Answer · answered Dec 15 '20 at 15:38

0

Try:

df.groupby(['State Name','County Name']).mean()

answered Dec 15 '20 at 15:38

rhug123

1 Answers1