matplotlib折线图、箱线图、散点图、直方图代码
#coding:utf-8
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
plt.rcParams['font.sans-serif'] = ['simhei']
plt.rcParams['font.family']='sans-serif'
df = pd.read_excel("/home/soft/person.xls")
#进入日期
dfin = df.loc[:,['num','in']]
dfin['in'] = pd.to_datetime(dfin['in'])
dfin = dfin.set_index('in')
dfin = dfin.loc['2016-5-1':'2017-5-31',:]
dfin = dfin.resample('M').count().to_period('M')
#出走日期
dfout = df.loc[:,['num','out']]
dfout['out'] = pd.to_datetime(dfout['out'])
dfout = dfout.set_index('out')
dfout = dfout.loc['2016-5-1':'2017-5-31',:]
dfout = dfout.resample('M').count().to_period('M&