pandas 图-修改日期的主要和次要ticks [英] Pandas plot - modify major and minor xticks for dates

问题描述

我正在策划两个熊猫系列.索引是日期(1-1到12-31)

I am plotting two pandas series. The index is a date (1-1 to 12-31)

s1.plot()
s2.plot()

pd.plot()解释日期并将其分配给轴值，如下所示:

pd.plot() interprets the dates and assigns them to axis values as such:

我想将主要刻度线设置为每月的1号，将次要刻度线设置为之间的日期

I would like to modify the major ticks to be the 1st of every month and minor ticks to be the days in between

这有效:

%matplotlib notebook

import matplotlib as mpl
import matplotlib.dates as mdates
import matplotlib.pyplot as plt
import pandas as pd

df = pd.read_csv('data.csv')

df['Date'] = pd.to_datetime(df['Date']).dt.strftime('%m-%d')
s2014max = df2014.groupby(['Date'], sort=True)['Data_Value'].max()/10
s2014min = df2014.groupby(['Date'], sort=True)['Data_Value'].min()/10

#remove the leap day and convert to datetime for plotting
s2014min = s2014min[s2014min.index != '02-29']
s2014max = s2014max[s2014max.index != '02-29']
dateslist = s2014min.index.tolist()

dates = [pd.datetime.strptime(date, '%m-%d').date() for date in dateslist]

plt.figure()

ax = plt.gca()
ax.xaxis.set_major_locator(mdates.MonthLocator())
ax.xaxis.set_minor_locator(mdates.DayLocator())

monthFmt = mdates.DateFormatter('%b')
dayFmt = mdates.DateFormatter('%d')
ax.xaxis.set_major_formatter(monthFmt) 
ax.xaxis.set_minor_formatter(dayFmt)  
ax.tick_params(direction='out', pad=15)

s2014min.plot()
s2014max.plot()

这不会导致滴答声:

推荐答案

一种可能的方法是使用matplotlib绘制日期而不是熊猫.

A possible way is to use matplotlib for plotting the dates instead of pandas.

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

dates = pd.date_range("2016-01-01", "2016-12-31" )
y = np.cumsum(np.random.normal(size=len(dates)))
df = pd.DataFrame({"Dates" : dates, "y": y})

fig, ax = plt.subplots()
ax.plot_date(df["Dates"], df.y, '-')

ax.xaxis.set_major_locator(mdates.MonthLocator())
ax.xaxis.set_minor_locator(mdates.DayLocator())
monthFmt = mdates.DateFormatter('%b')
ax.xaxis.set_major_formatter(monthFmt)

plt.show()

这篇关于 pandas 图-修改日期的主要和次要ticks的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！