Matplotlib plot time series graph

Question

I have a pandas dataframe with 2 columns:

Time     Values
07:40         5
08:10         6
08:25         3
08:53         4
...         ...

How can I plot a line chart which x-axis is the time and y-axis is values? I tried:

plt.plot(df["Time"],df["Values"])

But I got an error message: ValueError: invalid literal for float: 18:03. I converted the column to datetime format and tried plot_date, but all failed

How you converted to datetime format ?

Rahul K P
– Rahul K P

2017-07-07 06:56:43 +00:00
Commented Jul 7, 2017 at 6:56 — Rahul K P
– Rahul K P, Commented Jul 7, 2017 at 6:56
pandas to_datetime

ELI
– ELI

2017-07-07 06:57:30 +00:00
Commented Jul 7, 2017 at 6:57 — ELI
– ELI, Commented Jul 7, 2017 at 6:57

Hamuel · Accepted Answer · 2017-07-07 07:17:20Z

1

you need to make sure you use the datetime library properly for example if your time come as a string of the format "HH:MM" you should split it and do the following

import datetime

def process_time(x):
  h, m = x.split(":")
  return datetime.time(hour=int(h), minute=int(m))

df['Time'].apply(process_time)

df.plot(x='Time', y='Values')

pandas have it own plot function which will plot the line for you

answered Jul 7, 2017 at 7:17

Hamuel

6335 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Matplotlib plot time series graph

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