Scatter Plot With Multi Column Data in Plotly Express

Question

I have a pandas dataframe like below

            x        s       y
Date
2021-06-25  1       red      2
2021-06-28  2       red      3
2021-06-29  3       red      4
2021-06-25  1       blue     2
2021-06-28  2       blue     3
2021-06-29  3       blue     4

How can I create a scatter plot in plotly[express]/cufflinks like

such that plot axes are x and y and red and blue are separate traces in the plot. Any hint ?

Rob Raymond · Accepted Answer · 2021-07-29 19:51:36Z

1

your sample data looks problematic, both red and blue have same values. Have added .5 to blue to demonstrate
simple pandas to structure data first, so colors are columns
then use plotly express scatter()

import pandas as pd
import io
import plotly.express as px

df = pd.read_csv(io.StringIO("""Date            x        s       y
2021-06-25  1       red      2
2021-06-28  2       red      3
2021-06-29  3       red      4
2021-06-25  1       blue     2.5
2021-06-28  2       blue     3.5
2021-06-29  3       blue     4.5"""), sep="\s+").set_index("Date")

df2 = df.set_index(["x","s"]).unstack("s").droplevel(0,1)

px.scatter(df2, x=df2.index, y=df2.columns)

answered Jul 29, 2021 at 19:51

Rob Raymond

31.5k3 gold badges19 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Scatter Plot With Multi Column Data in Plotly Express

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related