In [1]:

    

%matplotlib inline

from jupyterwf.data import get_fremont_data

data =get_fremont_data()


data.resample('W').sum().plot()


    

    
Out[1]:





<matplotlib.axes._subplots.AxesSubplot at 0x7ff19e823320>






    

In [2]:

    

ax=data.resample('D').sum().rolling(365).sum().plot()
ax.set_ylim(0,None);


    

In [3]:

    

data.groupby(data.index.time).mean().plot();


    

In [4]:

    

pivoted = data.pivot_table('Total',index=data.index.time,columns=data.index.date)


    

In [5]:

    

pivoted.iloc[:5,:5]


    

    
Out[5]:






  

    

      

      
2012-10-03
      
2012-10-04
      
2012-10-05
      
2012-10-06
      
2012-10-07
    
  
  

    

      
00:00:00
      
13.0
      
18.0
      
11.0
      
15.0
      
11.0
    
    

      
01:00:00
      
10.0
      
3.0
      
8.0
      
15.0
      
17.0
    
    

      
02:00:00
      
2.0
      
9.0
      
7.0
      
9.0
      
3.0
    
    

      
03:00:00
      
5.0
      
3.0
      
4.0
      
3.0
      
6.0
    
    

      
04:00:00
      
7.0
      
8.0
      
9.0
      
5.0
      
3.0
    
  

In [6]:

    

pivoted.plot(legend=False,alpha=0.01)


    

    
Out[6]:





<matplotlib.axes._subplots.AxesSubplot at 0x7ff19b587d30>






    

In [ ]: