Create plot with color by category/value of a column

I have a tabular data set that have 10 columns and 100K samples.
One of the columns is a weekday - Sunday, Monday …

I want to plot a scatter plot but to color the points according to the weekday column.
If a point was on Wednesday color it green, Sunday will be red etc.

I know that in ggplot2 in R it’s super simple, in Python too.

Please guide me how can I do this here on plotly.

Thanks in advance!