Mean and Median
pandas also provides calculations of mean values. To calculate an arithmetic mean (total sum of values/number of values) apply the .mean() method.
What is a median? Assume you sort values in ascending order. Then the middle value of new series is called median. This metric is better in terms of resistance to outliers. To get the median value apply the .median() method. For instance, we can get the average and median prices for all cars with Semi-Auto gear box.
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') # Mean price print(df.loc[df.transmission == 'Semi-Auto', 'price'].mean()) # Median price print(df.loc[df.transmission == 'Semi-Auto', 'price'].median())
Merci pour vos commentaires !
Demandez à l'IA
Demandez à l'IA
Posez n'importe quelle question ou essayez l'une des questions suggérées pour commencer notre discussion
Posez-moi des questions sur ce sujet
Résumer ce chapitre
Afficher des exemples du monde réel
Awesome!
Completion rate improved to 3.33Mean and Median
Glissez pour afficher le menu
pandas also provides calculations of mean values. To calculate an arithmetic mean (total sum of values/number of values) apply the .mean() method.
What is a median? Assume you sort values in ascending order. Then the middle value of new series is called median. This metric is better in terms of resistance to outliers. To get the median value apply the .median() method. For instance, we can get the average and median prices for all cars with Semi-Auto gear box.
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') # Mean price print(df.loc[df.transmission == 'Semi-Auto', 'price'].mean()) # Median price print(df.loc[df.transmission == 'Semi-Auto', 'price'].median())
Merci pour vos commentaires !
