4

I have a chart of a daily trend over time.

Price Over Time

The year is not relevant here and I want to show only day and month. I know you can show year and month but that is not the case.

I tried to create a new variable called "Day_Month":

import datetime as dt
df['Day'] =  df['date'].dt.day
df['Month'] =  df['date'].dt.month
df['Day_Month'] = df['Day'].astype(str) + "-" +

but it's not possible to plot it as a string nor to convert it to date type.

eventually, I would like my chart to look like this:

Final Price chart

live2
  • 3,771
  • 2
  • 37
  • 46
Efrat Amir-Caspi
  • 121
  • 1
  • 6
  • Have you looked at [matplotlib.dates.DateFormatter](https://matplotlib.org/api/dates_api.html#matplotlib.dates.DateFormatter)? – DavidG Apr 23 '18 at 08:15

1 Answers1

8

The answer I found is:

import matplotlib.dates as mdates
import matplotlib.pyplot as plt 

fig = plt.figure()
ax = fig.add_subplot(111)
plt.plot(date, price , label="Price")
ax.xaxis.set_major_formatter(mdates.DateFormatter('%m-%d'))
Efrat Amir-Caspi
  • 121
  • 1
  • 6