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())
Tudo estava claro?
Obrigado pelo seu feedback!
Seção 4. Capítulo 8
Pergunte à IA
Pergunte à IA
Pergunte o que quiser ou experimente uma das perguntas sugeridas para iniciar nosso bate-papo
Awesome!
Completion rate improved to 3.33
Minimum and Maximum
Deslize para mostrar o 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())
Tudo estava claro?
Obrigado pelo seu feedback!
Seção 4. Capítulo 8