Pandas 习题

 **import pandas as pd  
**
 import numpy as np
 # visualization
 import matplotlib.pyplot as plt
 %matplotlib inline

 **#从目标路径导入数据集  
**
 **path9 =
'D:/hailong/hailong_download/pandas_exercise/exercise_data/Apple_stock.csv'**

 **apple = pd.read_csv(path9)  
**
 apple.head()

 **apple.dtypes  
**

 **apple.Date = pd.to_datetime(apple.Date)  
**
 apple'Date'.head()

 **apple = apple.set_index('Date')  
**
 apple.head()

 **apple.index.is_unique  
**

 **apple.sort_index(ascending = True).head()  
**

 **apple_month = apple.resample('BM').mean()  
**
 apple_month.head()

 **(apple.index.max() - apple.index.min()).days  
**

 **apple_months = apple.resample('BM').mean()  
**
 len(apple_months.index)
 **输出结果:404  
**

 **# makes the plot and assign it to a variable  
**
 apple_open = apple'Adj Close'.plot(title = "Apple stock")
 # changes the size of the graph
 fig = apple_open.get_figure()
 fig.set_size_inches(13.5,9)