/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 vote343 views1 answer
Access host database django docker
Python Django
0 vote306 views1 answer
Openpyxl add worksheet
Python
0 vote316 views1 answer
Get next iterator without incrementing python
Python
0 vote309 views1 answer
Remove newline and space characters from start and end of string python
Python
0 vote295 views1 answer
How to parse timestamp in python
Python
11 votes309 views6 answers
How to add to a list python
Python
0 vote306 views1 answer
Python3 send mail
Python
2 votes346 views2 answers
Get Discord guild members discord.py
Python
10 votes289 views1 answer
How to get specific row in pandas
Python
24 votes303 views3 answers
Ignore warnings python
Python