/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 vote202 views1 answer
How to install arcade in python
Python
2 votes237 views2 answers
How to get only first record in django
Python Django
1 vote220 views1 answer
How to say hello with name in python
Python
0 vote230 views1 answer
Regex_2/_regex.c:50:10: fatal error: Python.h: No such file or directory
Python
0 vote215 views2 answers
Builtwith python
Python
8 votes206 views2 answers
Python requests header
Python
0 vote214 views1 answer
How to accept invalidfileexception in python
Python
-3 votes243 views1 answer
ImportError: cannot import name 'SGD' from 'keras.optimizers' (/usr/local/lib/python3.7/dist-packages/keras/optimizers.py) site:stackoverflow.com
Python
0 vote212 views1 answer
If query empty print python
Python
0 vote214 views1 answer
Lista to txt python
Python