pandas Cookbook--Chapter 1

pandas Cookbook–Chapter 1

• 环境设置

  ipython notebook

  %pylab inline%matplotlib inlinematplotlib.style.use('ggplot')figsize(15,5)#import pandas as pd#pd.set_option('display.mpl_style','default')#code above will lead to AttributeError: Unknown property color_cycle

  ​

• 数据导入

  导入的2015年的数据，多了00:00这一列，不处理就会出现UnNamed:1这列

  from datetime import datetimeparse = lambda x:datetime.strptime(x+':00', "%d/%m/%Y %X")fixed_df = pd.read_csv('comptagesvelo2015.csv', sep=',', encoding='latin1', parse_dates={'date':[0,1]}, dayfirst=False, index_col='date',date_parser=parse)

  ​