Minimum and Maximum
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())
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 4. Capitolo 8
Chieda ad AI
Chieda ad AI
Chieda pure quello che desidera o provi una delle domande suggerite per iniziare la nostra conversazione
Awesome!
Completion rate improved to 3.33
Minimum and Maximum
Scorri per mostrare il 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())
Tutto è chiaro?
Grazie per i tuoi commenti!
Sezione 4. Capitolo 8