How do I drop rows with zeros in Panda dataframe?

Question

I want to take the average property assessment value for each zipcode (without counting the zeros). So I would have an average value for 02126 and an average value for 02130. I would like to drop all rows with 0 in AV_LAND. What is the best way to go about that in a pandas dataframe? Thanks in advance!

   ZIPCODE AV_LAND
0   02130   7900
1   02126   0
2   02126   20600
3   02126   520800
4   02126   20800
5   02127   0

piRSquared · Accepted Answer · 2016-10-06T00:10:45.187

2

assuming df is your dataframe

df.loc[df.AV_LAND != 0].groupby('ZIPCODE').mean()

df.loc[df.AV_LAND != 0].groupby('ZIPCODE').mean().reset_index()

edited Oct 06 '16 at 00:10

answered Oct 05 '16 at 22:45

piRSquared

285,575
57
475
624

Oh I should have clarified, I meant the average value pertaining to each each zipcode – dancemc15 Oct 05 '16 at 22:47
Why are the header names in different rows btw? – dancemc15 Oct 05 '16 at 23:04
@dancemc15 `ZIPCODE` is the name of the index in that final dataframe. – piRSquared Oct 06 '16 at 00:10

How do I drop rows with zeros in Panda dataframe?

1 Answers1

Linked