/Python/How to sum a column in Python csv

How to sum a column in Python csv

Pandas csv sum column

df["column_name"].sum()

How to sum a column in Python csv

import pandas as pd
data = pd.read_csv('pandas.csv')
df = pd.DataFrame(data)
id_sum = 0
data_sum = 0
for i in range(len(df)):
   if(i==len(df)-2 or i==len(df)-1):
      id_sum = id_sum + df.iloc[i][0]
      data_sum = data_sum + df.iloc[i][1]
print("Id",id_sum)
print("Data",data_sum)

Source: tutorialspoint.com

Similar codes

0 vote107 views1 answer
Install apriori package python
Python
0 vote149 views3 answers
Convert unix timestamp to datetime python pandas
Python
0 vote134 views10 answers
EMAIL_BACKEND = 'django.core.mail.backends.console.EmailBackend'
Python Django
1 vote144 views1 answer
What is values_list in django orm
Python Django
1 vote106 views3 answers
Django reverse
Python
1 vote120 views1 answer
How to pick out separate columns from the pandas dataframe object
Python
2 votes114 views2 answers
ValueError: Shapes (None, 1) and (None, 11) are incompatible keras
Python
0 vote176 views2 answers
User logout in django rest framework
Python Django
2 votes229 views3 answers
No such table django
Python Django
2 votes110 views1 answer
How to update pandas
Python