Pandas Plotting Display all date values on x-axis (matplolib only displays few values) formatted as MMM-YYYY [duplicate]

by

As mentioned in the comments, you have to set both, the Locator and the Formatter. This is explained well in the matplotlib documentation for graphs in general and separately for datetime axes. See also an explanation of the TickLocators. The formatting codes are derived from Python’s strftime() and strptime() format codes.

from matplotlib import pyplot as plt
import pandas as pd
from matplotlib.dates import MonthLocator, DateFormatter


#fake data
import numpy as np
np.random.seed(123)
n = 100
df = pd.DataFrame({"Dates": pd.date_range("20180101", periods=n, freq="10d"), "A": np.random.randint(0, 100, size=n), "B": np.random.randint(0, 100, size=n),})
df.set_index("Dates", inplace=True)
print(df)

ax = df.plot()

#defines the tick location 
ax.xaxis.set_major_locator(MonthLocator())
#defines the label format
ax.xaxis.set_major_formatter(DateFormatter("%b-%y"))
ax.tick_params(axis="x", labelrotation= 90)

plt.tight_layout()
plt.show()

Sample output:![enter image description here

More Related Contents:

  1. Annotate bars with values on Pandas bar plots
  2. plot different color for different categorical levels using matplotlib
  3. How to plot multiple Seaborn Jointplot in Subplot
  4. Setting Different Bar color in matplotlib Python [duplicate]
  5. how to get ticks every hour?
  6. How to add value labels on a bar chart
  7. Plot a horizontal line on a given plot
  8. How to have clusters of stacked bars
  9. How to plot multiple dataframes in subplots
  10. Plot correlation matrix using pandas
  11. Problem in combining bar plot and line plot (python)
  12. Seaborn showing scientific notation in heatmap for 3-digit numbers
  13. Seaborn: countplot() with frequencies
  14. Modify the legend of pandas bar plot
  15. Bar Chart: How to choose color if value is positive vs value is negative
  16. How to annotate each segment of a stacked bar chart
  17. How to deal with NaN values when plotting a boxplot
  18. Python pandas / matplotlib annotating labels above bar chart columns [duplicate]
  19. How to plot multiple dataframes to the same plot axes
  20. Plotting a stacked Bar Chart
  21. ValueError: view limit minimum -35738.3640567 is less than 1 and is an invalid Matplotlib date value
  22. pandas bar plot combined with line plot shows the time axis beginning at 1970
  23. Pandas plot doesn’t show
  24. Getting vertical gridlines to appear in line plot in matplotlib
  25. plotting a histogram on a Log scale with Matplotlib
  26. Changing width of bars in bar chart created using seaborn.factorplot
  27. Plot two levels of x_ticklabels on a pandas multi-index dataframe [duplicate]
  28. pandas plot value counts barplot in descending manner [duplicate]
  29. Plotting errors bars from dataframe using Seaborn FacetGrid
  30. How to create a scatter plot by category [duplicate]

Leave a Comment