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())
War alles klar?
Danke für Ihr Feedback!
Abschnitt 4. Kapitel 8
Fragen Sie AI
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen
Awesome!
Completion rate improved to 3.33
Minimum and Maximum
Swipe um das Menü anzuzeigen
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())
War alles klar?
Danke für Ihr Feedback!
Abschnitt 4. Kapitel 8