How to select the dataframe between two give values for a column?

Question

Consider the avocado dataset. How to find the mean of 'Total Volume' from 29 dec 2015 to 13 april 2018 of Boston 'region'.

I am trying to calculate it by df.loc()

import pandas as pd
data_new = data.loc[(data['Date']>='2015-12-29')&(data['Date']<='2018-04-13')&(data['region']=='Boston')]
print(data_new.mean())

Is it right or I have to provide the axis for the mean()?

dataset - https://www.kaggle.com/neuromusic/avocado-prices

Consider the avocado dataset. What avocado dataset? Is it right or I have to provide the axis for the mean()? That's pretty easy to figure out, does it produce the correct result? — AMC
– AMC, Commented Jan 12, 2020 at 21:57
this question is from hackerrank. The problem statement was to calculate the mean of 'Total Volume' from 29 dec 2015 to 13 april 2018 of Boston 'region'. the above solution was giving the wrong answer verdict. — Rishi Sahu
– Rishi Sahu, Commented Jan 12, 2020 at 22:00
@RishiSahu you're pretty close my man, just add the column name to the end and add .mean() — Umar.H
– Umar.H, Commented Jan 12, 2020 at 22:37

null · Accepted Answer · 2020-01-12 22:01:47Z

2

If you do not put the column there, then it would return the mean of all columns. Btw one prettier way for convenience would be taking out the condition part if you have many. It would be read easier.

condition = (data['Date']>='2015-12-29')&\
                     (data['Date']<='2018-04-13')&\
                     (data['region']=='Boston')
mean_total_vol = data[condition]['Total Volume'].mean()

answered Jan 12, 2020 at 22:01

null

2,1571 gold badge21 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to select the dataframe between two give values for a column?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related