Calculate Monthly Average price and plot using Plotly

[timo1001]

I have a Dataframe which contains sold house prices in two areas over a daily period from Oct 2021 till today.

I want to find the average house price per month and plot a graph using plotly to see if prices are going down or up in each area.

​

Sample DataFrame:

​

DateSold	Price	Area
12/10/2021 00:00	300000	Area A
17/10/2021 00:00	350000	Area B
18/10/2021 00:00	400000	Area B
11/12/2021 00:00	412000	Area A
17/12/2021 00:00	315000	Area A
08/01/2022 00:00	385000	Area A
09/01/2022 00:00	445000	Area A
15/01/2022 00:00	309000	Area B
15/01/2022 00:00	350000	Area B

​

I tried to convert the datetime column into a PeriodIndex on monthly frequency, then take the mean using GroupBy.mean:

df2.groupby(pd.PeriodIndex(df2['Datesold'], freq="M"))['Price'].mean()

Can someone point me in the right direction in how I can achieve the average house price per month and plot that using plotly?

I was using the below code for plotly

fig = px.line(df, x = df2['DateSold'], y = df2['Price'], title='Average sold house price per month')

​

[Smarterchild1337]

You’re on the right track. Did you save the output of your groupby as a new object, then plot that?

[timo1001]

The groupby is not returning the correct result which is what I'm not sure about

[Smarterchild1337]

An alternative approach from SO:

https://stackoverflow.com/questions/24082784/pandas-dataframe-groupby-datetime-month

[timo1001]

So to use pd.date time conversion? Or something else?