Difficulty in plotting time series data

📊 Plotly Python
1

This is the data I’m working with. It is weekly sales data

bGZK1
bGZK11152×242 11.6 KB

I’m trying to plot a line chart with dates on x-axis and weekly sales on y-axis and get this plot:

YjUyj
YjUyj1165×368 11.5 KB

Here is the code:

merged['Date'] = pd.to_datetime(merged['Date'])
merged = merged.sort_values('Date')
fig = px.line(merged, x='Date', y='Weekly_Sales)
fig.show()

I’m expecting this kind of result:

nGBjp
nGBjp826×373 47.9 KB

The last plot is plotted using seaborn and relplot.

Thanks in advance

2

hi @Moonis
Welcome to the community :wave:

Can you please share access to the data so we can try to run this locally on our computer.

3

Hi @adamschroeder

Thanks for replying so quickly. I have attached a onedrive link of the csv file

4

hi @Moonis
The trick is to group by Date so you don’t have overlapping lines. I saved and used your excel sheet as a .csv file and I named it mydata.

import plotly.express as px
import pandas as pd

merged = pd.read_csv('mydata.csv')
merged['Date'] = pd.to_datetime(merged['Date'])
merged = merged.sort_values('Date')
merged = merged.groupby('Date')['Weekly_Sales'].sum().reset_index()
print(merged.head(20))

fig = px.line(merged, x='Date', y='Weekly_Sales')
fig.show()```
1 Like
5

That works like a charm. Thank you very much