/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 vote301 views1 answer
Toy dataframe df simple
Python
26 votes300 views5 answers
Display max rows pandas
Python
13 votes438 views1 answer
Flask app starter
Python Flask
1 vote310 views1 answer
How to say hello world
Python
5 votes296 views2 answers
Numpy calculate standard deviation
Python
42 votes290 views5 answers
How to print today's date in python
Python
0 vote298 views2 answers
Sum python
Python
149 votes329 views6 answers
How to make a random number generator in python
Python
0 vote284 views1 answer
Remove percentage in python
Python
0 vote270 views1 answer
How to get the name of an object in python
Python