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())
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 4. Capítulo 8
Pregunte a AI
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla
Awesome!
Completion rate improved to 3.33Minimum and Maximum
Desliza para mostrar el menú
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())
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 4. Capítulo 8
