Oppiskele 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())

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 4. Luku 8

Kysy tekoälyä

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

Pyyhkäise näyttääksesi valikon

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())

Oliko kaikki selvää?

Kiitos palautteestasi!

Osio 4. Luku 8

Minimum and Maximum

Awesome!

Minimum and Maximum