Pandas timeseries plot setting x-axis major and minor ticks and labels

by

Both pandas and matplotlib.dates use matplotlib.units for locating the ticks.

But while matplotlib.dates has convenient ways to set the ticks manually, pandas seems to have the focus on auto formatting so far (you can have a look at the code for date conversion and formatting in pandas).

So for the moment it seems more reasonable to use matplotlib.dates (as mentioned by @BrenBarn in his comment).

import numpy as np
import pandas as pd
import matplotlib.pyplot as plt 
import matplotlib.dates as dates

idx = pd.date_range('2011-05-01', '2011-07-01')
s = pd.Series(np.random.randn(len(idx)), index=idx)

fig, ax = plt.subplots()
ax.plot_date(idx.to_pydatetime(), s, 'v-')
ax.xaxis.set_minor_locator(dates.WeekdayLocator(byweekday=(1),
                                                interval=1))
ax.xaxis.set_minor_formatter(dates.DateFormatter('%d\n%a'))
ax.xaxis.grid(True, which="minor")
ax.yaxis.grid()
ax.xaxis.set_major_locator(dates.MonthLocator())
ax.xaxis.set_major_formatter(dates.DateFormatter('\n\n\n%b\n%Y'))
plt.tight_layout()
plt.show()

pandas_like_date_fomatting

(my locale is German, so that Tuesday [Tue] becomes Dienstag [Di])

More Related Contents:

  1. how to do multiple scatter plots with matploatlib
  2. How to plot in multiple subplots
  3. Adding value labels on a matplotlib bar chart
  4. How can I plot separate Pandas DataFrames as subplots?
  5. Pandas Dataframe line plot display date on xaxis
  6. Changing the formatting of a datetime axis in matplotlib
  7. Pandas – Plotting a stacked Bar Chart
  8. Pandas dataframe groupby plot
  9. Seaborn Barplot – Displaying Values
  10. How to give a pandas/matplotlib bar graph custom colors
  11. How can I make a barplot and a lineplot in the same seaborn plot with different Y axes nicely?
  12. Pandas: Bar-Plot with two bars and two y-axis
  13. Matplotlib – fixing x axis scale and autoscale y axis
  14. Plotting pandas timedelta
  15. Stacked bar chart in Seaborn
  16. Background with range on seaborn based on two columns
  17. Improve subplot size/spacing with many subplots
  18. Can Pandas plot a histogram of dates?
  19. How do I make the width of the title box span the entire plot?
  20. How to edit properties of whiskers, fliers, caps, etc. in Seaborn boxplot
  21. Plot multiple columns of pandas DataFrame using Seaborn
  22. Change main plot legend label text
  23. How to plot multiple bars grouped
  24. Pandas and Matplotlib – fill_between() vs datetime64
  25. pandas – scatter plot with different color legend for each point
  26. Discrete legend in seaborn heatmap plot
  27. Seaborn factor plot custom error bars instead of bootstrapping
  28. Color a scatter plot by Column Values
  29. How does one insert statistical annotations (stars or p-values)
  30. Is it possible to add a string as a legend item

Leave a Comment