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())
Was alles duidelijk?
Bedankt voor je feedback!
Sectie 4. Hoofdstuk 8
Vraag AI
Vraag AI
Vraag wat u wilt of probeer een van de voorgestelde vragen om onze chat te starten.
Awesome!
Completion rate improved to 3.33Minimum and Maximum
Veeg om het menu te tonen
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())
Was alles duidelijk?
Bedankt voor je feedback!
Sectie 4. Hoofdstuk 8
