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

Tout était clair ?

Merci pour vos commentaires !

Section 4. Chapitre 8

Demandez à l'IA

Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion

Glissez pour afficher le menu

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

Tout était clair ?

Merci pour vos commentaires !

Section 4. Chapitre 8

Minimum and Maximum

Awesome!

Minimum and Maximum