Lære Minimum and Maximum | Aggregate Functions

You can also get the minimum and maximum values of certain column. To get the minimum apply the .min() method, to get the maximum apply the .max() method. For instance,


              123456789
            
# 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')
# Minimal car price with Automatic gear box
print(df.loc[df.transmission == 'Automatic', 'price'].min())
# Maximal mileage of manufactured in 2015 car
print(df.loc[df.year == 2015, 'mileage'].max())

Var alt klart?

Tak for dine kommentarer!

Sektion 4. Kapitel 8

Spørg AI

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

Stryg for at vise menuen

You can also get the minimum and maximum values of certain column. To get the minimum apply the .min() method, to get the maximum apply the .max() method. For instance,


              123456789
            
# 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')
# Minimal car price with Automatic gear box
print(df.loc[df.transmission == 'Automatic', 'price'].min())
# Maximal mileage of manufactured in 2015 car
print(df.loc[df.year == 2015, 'mileage'].max())

Var alt klart?

Tak for dine kommentarer!

Sektion 4. Kapitel 8

Minimum and Maximum

Awesome!

Minimum and Maximum