Python: Line Plot - Formatting Dates on X axis?

Question

I am trying to plot the dates from an excel file for a line chart. It is in Column A labeled "Date" and is in the format 3/1/2019. The type is "short date" on excel. I've managed to pull in the excel data and the columns I needed into a data frame. When i try to plot using:

plt.plot(GQ1_Date, GQ1_WICreated)
plt.plot(GQ1_Date, GQ1_Backlog)
plt.show()

GQ1_Date.head() outputs:  

       Date
0 2019-03-01
1 2019-03-02
2 2019-03-03
3 2019-03-04
4 2019-03-05

the x axis reads 2019-03, 2019-05, etc. How do I get it to display the full date with the day and make the ticks display every single date insetad of every 2 months?

dzakyputra · Accepted Answer · 2020-03-26 03:12:10Z

1

I think that's because your Series is in datetime data type.

Try this.

plt.plot(GQ1_Date['Date'].astype(str), GQ1_WICreated)
plt.plot(GQ1_Date['Date'].astype(str), GQ1_Backlog)
plt.xticks(rotation=90)
plt.show()

answered Mar 26, 2020 at 3:12

dzakyputra

6824 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Python: Line Plot - Formatting Dates on X axis?

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