Why the graph doesn't show all data

Dash Python
1

Hello,
When i use the code below the grouped by dataframe shows 14 events in shop A in 2022 en 16 events for shop B. When plotting there is no data in 2022 .
When i change the filtered period to >=2020 it shows data in 2022 but not for the last months.
Sourcefile: Shared Link | File Dropper

#imports
import datetime as dt
import pandas as pd
import numpy as np
import pandas as pd
import plotly.offline as pyo
import plotly.graph_objs as go
#read_file
d = pd.read_excel("q1.xlsx")
#adjust data
d['Event']=pd.to_datetime(d['Event'])
d=d[d['Event']>='2019-01-1']
d['month']=d.Event.dt.month
d['year']=d.Event.dt.year
e=(d.groupby(['Shop','year','month']).agg('count'))
e=e.reset_index()
#plotting
trace1=go.Bar(
    x =[e.year,e.month],
    y = e[e['Shop']=='A']['Event'],
    name='SHOP A', text =e[e['Event']=='A']['Event']
)
trace2=go.Bar(
    x =[e.year,e.month],
    y = e[e['Shop']=='B']['Event'],
    name='SHOP B', text =e[e['Event']=='B']['Event']
)
trace1=go.Bar(
    x =[e.year,e.month],
    y = e[e['Shop']=='A']['Event'],
    name='SHOP A', text =e[e['Event']=='A']['Event']
)
trace2=go.Bar(
    x =[e.year,e.month],
    y = e[e['Shop']=='B']['Event'],
    name='SHOP B', text =e[e['Event']=='B']['Event']
)
data=[trace1,trace2]
layout=go.Layout(title="SOLD P")
fig=go.Figure(data=data,layout=layout)
pyo.plot(fig)

image

image
image697×531 4.3 KB

2

After a quick glance, it looks to me that the problem is a potential mismatch on what you are using for x and y:

trace1=go.Bar(
    x =[e.year,e.month],
    y = e[e[‘Shop’]==‘A’][‘Event’], 
    name=‘SHOP A’, text =e[e[‘Event’]==‘A’][‘Event’]
)

x is a list of two series over all rows of e, while y is filtered by shop value. You should probably apply the same filter in x.

3

Getting close.
I Notice that when there is a month with no data for shop B itdoesn’t jump to the next month.