pandas Cookbook--Chapter 1

pandas Cookbook–Chapter 1

• 环境设置

  ipython notebook

  %pylab inline
  %matplotlib inline
  matplotlib.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 datetime
  parse = 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)

  ​