/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

5 votes237 views2 answers
How to reset username and password in django admin
Python Django
0 vote203 views1 answer
Python read column data from text file
Python
3 votes222 views1 answer
Django admin prefetch_related
Python Django
0 vote175 views1 answer
How to set variable in flask
Python
0 vote172 views1 answer
Python initialise list of lists
Python
46 votes223 views4 answers
How to stop container in docker
Python
79 votes175 views6 answers
String reverse in python
Python
0 vote138 views1 answer
Parallel run of a function with multiple arguments partial
Python
0 vote175 views1 answer
How to make a lis in python
Python
25 votes175 views2 answers
Python convert py file to pyc
Python