Plotly Multicategory X Axis Ordering

user_9815902 0
Viewed 1600

I'm trying to create a multi category x axis with dates, the below code & graph gives me what I want it terms of how it looks but it's just out of order. I've tried using the 'Original x-axis' column instead of month but then the format doesn't appear correctly and I can't seem to change the format of it.

import random
import numpy as np
import plotly.express as px

df = pd.DataFrame({"Year":np.repeat([2018,2019],[8,12]), 
              "Month": ["May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec", "Jan", "Feb", "Mar", "Apr","May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
             "Original x-axis": pd.date_range(start = "2018-05-01", end = "2019-12-01", freq = "MS"),
             "Customer Satisfaction Score": random.sample(range(30,100), 20)})


fig = go.Figure()

fig.add_trace(go.Scatter(
                        #x = cust["Original x-axis"], 
                        x = [df["Year"],df["Month"]],
                      y = df["Customer Satisfaction Score"], mode = "lines"))

fig.update_layout(plot_bgcolor = "white",
                 annotations = [dict(text = "Customer Satisfaction Score",
                                    yref = "paper",
                                    xref = "paper",
                                    x = 0,
                                    y = 1.1,
                                     font = dict(size = 16, color = "#909497"),
                                    showarrow = False)],
                 font = dict(size = 12, color = "#BDC3C7"))
                 #xaxis = dict(tickformat = "%b"))

fig.show()

enter image description here

plotly python
1 Answers

Please check the snippet. You need to sort your date_time column based on year as well as month.

Here I created an extra column for that. Rest all the part is same.

df['month'] = df['Original x-axis'].dt.strftime('%b-%Y')

PLOT

import random
import numpy as np
import plotly.express as px
import pandas as pd
import plotly.offline as py
import plotly.graph_objs as go
df = pd.DataFrame({"Year":np.repeat([2018,2019],[8,12]), 
              "Month": ["May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec", "Jan", "Feb", "Mar", "Apr","May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
             "Original x-axis": pd.date_range(start = "2018-05-01", end = "2019-12-01", freq = "MS"),
             "Customer Satisfaction Score": random.sample(range(30,100), 20)})

df['month'] = df['Original x-axis'].dt.strftime('%b-%Y')
fig = go.Figure()

fig.add_trace(go.Scatter(
                        #x = cust["Original x-axis"], 
                        x = [df["Year"],df["month"]],
                      y = df["Customer Satisfaction Score"], mode = "lines"))

fig.update_layout(plot_bgcolor = "white",
                 annotations = [dict(text = "Customer Satisfaction Score",
                                    yref = "paper",
                                    xref = "paper",
                                    x = 0,
                                    y = 1.1,
                                     font = dict(size = 16, color = "#909497"),
                                    showarrow = False)],
                 font = dict(size = 12, color = "#BDC3C7"))
                 #xaxis = dict(tickformat = "%b"))

fig.show()
user_128705130
Related