Plotting graph with dates [duplicate]

Question

This question already has answers here:

plot pandas dataframe two columns (5 answers)

Use index in pandas to plot data (6 answers)

Plot pandas dates in matplotlib (2 answers)

Closed 3 years ago.

I'm trying to plot my table into a graph which has dates, from what I've learnt I've changed the date column into recognisable date by

pd.to_datetime(df["Date"], format="%Y%m%d")

My data looks something like this:

	Date	DailyPositive
1	20200101	1
2	20200102	2
3	20200103	4

When I try plotting it, my graphs came out like this, I'm assuming it somehow plotted against the index instead?

How do I plot the date at X axis, and the cases at Y-axis? Also since my date runs across two years, is there a way for to make the X-axis date go in like maybe few months apart?

I've searched around and saw way too many different solutions for me to understand :(

Thank you!!

mnist · Accepted Answer · 2021-11-20 22:05:47Z

0

For a regular plot, you just can use line

DF2.plot.line(x="Date", y="DailyPositive")

For adding some space, you can set the xlim kind of dynamically like this:

DF2.plot.line(x="Date", y="DailyPositive", xlim=[min(DF2["Date"]) + pd.DateOffset(-1), max(DF2["Date"]) + pd.DateOffset(1)])

answered Nov 20, 2021 at 22:05

mnist

7,0242 gold badges20 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Plotting graph with dates [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related