✊🏿 Black Lives Matter. Please consider donating to Black Girls Code today.
📊 Dash 2.0 is Arriving. Register here.

Converting Database Table to Plotly interpretable

I have a time-stamped table with 100 rows. There are 5 different categories in one column, I created a line graph with each line as a category. I want to colour these lines but it seems that each line needs to be a separate Trace. Aside from me manually cutting and pasting the values of each category into a new column, is there a way to do this automatically or more quickly then copying and pasting?

I’m a bit of a noob but if I were connecting to a SQL database how would that be done? Not using Plotly2.0 I’m guessing?

Thank you