Sum different columns with pandas. Python

Question

I have a code to concat 2 dataframes with pandas and sum the totals. The problem is I don't want to sum 'Fecha'and 'hours' because as you can see in the example I have a row with all values of that and I want a empty row there!

df = pd.read_csv('a_AR.csv')
df1 = pd.read_csv('a_US.csv')

frames = [df1, df]
result = pd.concat(frames)
result = result.sort_values(by=['Fecha','hours'])

del result['eCPM']
del result['Importe_a_pagar_a_medio']

result.loc['Total']= result.sum()

result.to_csv('a_AR-US_Days_hours.csv', index=False)

os.remove('a_US.csv')
os.remove('a_AR.csv')

Example results:

Fecha,hours,impressions,revenue
22/01/2018,23hs,1666,0.73
22/01/2018,23hs,67,0.02
00hs00hs01hs01hs02hs02hs03hs03...,01/01/201801/01/201801/01/201801/01...,1733,0.75

jezrael · Accepted Answer · 2018-01-23 13:55:38Z

1

You need difference for all columns without Fecha and hours columns for filtering:

cols = df.columns.difference(['Fecha','hours'])

Another more dynamic solution with select_dtypes for select all numeric columns:

cols = df.select_dtypes(np.number).columns

df.loc['Total']= df[cols].sum()

edited Jan 23, 2018 at 13:55

answered Jan 23, 2018 at 13:39

jezrael

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

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

Collectives™ on Stack Overflow

Sum different columns with pandas. Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related