how to visualize columns of a dataframe python as a plot?

Question

I have a dataframe that looks like below:

DateTime               ID          Temperature

2019-03-01 18:36:01    3             21

2019-04-01 18:36:01    3             21

2019-18-01 08:30:01    2             18

2019-12-01 18:36:01    2             12

I would like to visualize this as a plot, where I need the datetime in x-axis, and Temperature on the y axis with a hue of IDs, I tried the below, but i need to see the Temperature distribution for every point more clearly. Is there any other visualization technique?

x= df['DateTime'].values
y= df['Temperature'].values
hue=df['ID'].values
plt.scatter(x, y,hue,color = "red")

no, if there is a line of ID passing through this plot should be ideal. — hakuna_code
– hakuna_code, Commented Sep 3, 2019 at 9:13

kederrac · Accepted Answer · 2019-09-03 09:52:34Z

1

you can try:

df.set_index('DateTime').plot()

output:

or you can use:

df.set_index('DateTime').plot(style="x-", figsize=(15, 10))

output:

edited Sep 3, 2019 at 9:52

answered Sep 3, 2019 at 9:20

kederrac

17.4k6 gold badges36 silver badges58 bronze badges

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

3 Comments

hakuna_code Over a year ago

Is it possible to plot voltage as a bar graph and mark label as points on them?

kederrac Over a year ago

yes, but this plot is fine ? or you want something different?

hakuna_code Over a year ago

yes, but to understand the distribution better I would like to mark labels as points. Can you please show me how to do that?

Collectives™ on Stack Overflow

how to visualize columns of a dataframe python as a plot?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related