Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.
Lære 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

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 4. Kapitel 5

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Suggested prompts:

Spørg mig spørgsmål om dette emne

Opsummér dette kapitel

Vis virkelige eksempler

Awesome!

Completion rate improved to 3.33

bookSum and Product

Stryg for at vise menuen

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

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 4. Kapitel 5
some-alt