'Categorical Scatter Plot with Dash/Plotly

I am trying to make a categorical scatter plot like this:

Counts of elements in discrete Locations(Wells) vs Time Points

This is supposed to be a categorical scatter plot with discrete x values represented by counts of elements in locations(Wells) vs Time Point.

I have written this code:

df = pd.read_excel (r'file.xlsx')

fig = go.Figure()
fig.add_trace(
  go.Scatter(
    x = [df['Well A'], df['Well B'],df['Well C'],df['Well D']],
    y = df['Time Point'],
    mode='markers'
  )
)

And I get this as a result:

Result

Which is crazy, I have no idea what is even happening there. Could you please help?..

P.S. My df looks like this:

Dataset

Please, help :(



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source