Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Learn Sum and Product | Aggregate Functions
Introduction to pandas [track]

bookSum and Product

To calculate the total sum and product you can use the .sum() and .prod() methods, respectively. These methods can be applied to an entire DataFrame; in that case, the corresponding operation will be performed for each column. For instance, we can calculate the total price of all cars manufactured in 2010.


              
1234567

            
# Importing library
import pandas as pd

# Reading csv file
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv')
# Total price of 2010 cars
print(df.loc[df.year == 2010, 'price'].sum())
copy

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 4. ChapterΒ 5

Ask AI

expand

Ask AI

ChatGPT

Ask anything or try one of the suggested questions to begin our chat

Suggested prompts:

Ask me questions about this topic

Summarize this chapter

Show real-world examples

Awesome!

Completion rate improved to 3.33

bookSum and Product

Swipe to show menu

To calculate the total sum and product you can use the .sum() and .prod() methods, respectively. These methods can be applied to an entire DataFrame; in that case, the corresponding operation will be performed for each column. For instance, we can calculate the total price of all cars manufactured in 2010.


              
1234567

            
# Importing library
import pandas as pd

# Reading csv file
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/67798cef-5e7c-4fbc-af7d-ae96b4443c0a/audi.csv')
# Total price of 2010 cars
print(df.loc[df.year == 2010, 'price'].sum())
copy

Everything was clear?

How can we improve it?

Thanks for your feedback!

SectionΒ 4. ChapterΒ 5
some-alt