Python pandas dataframe select rows from columns

Question

In an Excel sheet with columns Rainfall / Year / Month, I want to sum rainfall data per year. That is, for instance, for the year 2000, from month 1 to 12, summing all the Rainfall cells into a new one. I tried using pandas in Python but cannot manage (just started coding). How can I proceed? Any help is welcome, thanks!

Here the head of the data (which has been downloaded):

   rainfall (mm)  \tyear   month  country   iso3   iso2
0      120.54000    1990       1      ECU    NaN    NaN
1      231.15652    1990       2      ECU    NaN    NaN
2      136.62088    1990       3      ECU    NaN    NaN
3      203.47653    1990       4      ECU    NaN    NaN
4      164.20956    1990       5      ECU    NaN    NaN

jezrael · Accepted Answer · 2017-04-20 12:17:19Z

1

Use groupby and aggregate sum if need sum of all years:

df = df.groupby('\tyear')['rainfall (mm)'].sum()

But if need only one value:

df.loc[df['\tyear'] == 2000, 'rainfall (mm)'].sum()

edited Apr 20, 2017 at 12:17

answered Apr 20, 2017 at 11:38

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

boot-scootin · Accepted Answer · 2017-04-20 11:43:30Z

1

If you just want the year 2000, use

df[df['\tyear'] == 2000]['rainfall (mm)'].sum()

Otherwise, jezrael's answer is nice because it sums rainfall (mm) for each distinct value of \tyear.

answered Apr 20, 2017 at 11:43

boot-scootin

12.6k10 gold badges73 silver badges118 bronze badges

Collectives™ on Stack Overflow

Python pandas dataframe select rows from columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related