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

Kurssisisältö

Introduction to pandas [track]

Introduction to pandas [track]

1. Basics
What is pandas?SeriesIndexes and ValuesChallengeDataFramesIndexes and ColumnsChallenge
2. Reading and Exploring Data
Reading CSV FilesReading XLS/XLSX FilesExploring Data [1/3]ChallengeExploring Data [2/3]Exploring Data [3/3]Challenge
3. Accessing DataFrame Values
Accessing Specific ColumnsChallengeAccessing Specific RowsChallengeAccessing Rows and ColumnsAccessing using .loc[] [1/3]Accessing using .loc[] [2/3]Accessing using .loc[] [3/3]
4. Aggregate Functions
Number of ObservationsUnique ObservationsCounting ValuesChallengeSum and ProductMean and MedianChallengeMinimum and Maximum

book
Sum 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

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 4. Luku 5

Kysy tekoälyä

expand
ChatGPT

Kysy mitä tahansa tai kokeile jotakin ehdotetuista kysymyksistä aloittaaksesi keskustelumme

course content

Kurssisisältö

Introduction to pandas [track]

Introduction to pandas [track]

1. Basics
What is pandas?SeriesIndexes and ValuesChallengeDataFramesIndexes and ColumnsChallenge
2. Reading and Exploring Data
Reading CSV FilesReading XLS/XLSX FilesExploring Data [1/3]ChallengeExploring Data [2/3]Exploring Data [3/3]Challenge
3. Accessing DataFrame Values
Accessing Specific ColumnsChallengeAccessing Specific RowsChallengeAccessing Rows and ColumnsAccessing using .loc[] [1/3]Accessing using .loc[] [2/3]Accessing using .loc[] [3/3]
4. Aggregate Functions
Number of ObservationsUnique ObservationsCounting ValuesChallengeSum and ProductMean and MedianChallengeMinimum and Maximum

book
Sum 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

Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 4. Luku 5
Pahoittelemme, että jotain meni pieleen. Mitä tapahtui?
some-alt