苹果股票分析

股票分析"/>

苹果股票分析

```
# -*- coding: utf-8 -*-
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
def quarter_volume():data=pd.read_csv("/Users/liyili2/Downloads/shiyanlou/apple.csv",header=0)print(data.head())# 将 Date 列转换为时间索引data.Date = pd.to_datetime(data['Date'])# 读取 Volume 列数据，并添加索引data_Volume=pd.Series(data['Volume'].values,index=data.Date)# 使用 Offset='Q' 参数，可以直接按季度重采样data_Q=data_Volume.resample('Q').sum()# 对交易数据从大到小排序后，返回第二项数据result=data_Q.sort_values(ascending=False)print(result)second_volume=result[1]# 完善代码return second_volumeif __name__ == "__main__":second_volume=quarter_volume()print("交易第二的季度总量是：",second_volume)
```Date   Open   High    Low  Close     Volume
0  2009-01-02  12.27  13.01  12.17  12.96  188749470
1  2009-01-05  13.31  13.74  13.24  13.51  297211453
2  2009-01-06  13.71  13.88  13.20  13.29  323043903
3  2009-01-07  13.12  13.21  12.89  13.00  189300706
4  2009-01-08  12.92  13.31  12.86  13.24  168365988
Date
2009-03-31    11883325286
2010-06-30    11625428360
2011-09-30     9785249544
2010-03-31     9525718538
2012-12-31     9302392372
2010-09-30     9278493119
2012-06-30     8640892029
2009-06-30     8489954543
2012-03-31     8454128130
2009-12-31     8202240823
2013-03-31     7911378167
2011-03-31     7860484814
2009-09-30     7275334241
2010-12-31     7183137346
2011-12-31     7104708093
2013-06-30     6856687985
2012-09-30     6596663815
2011-06-30     6358325057
2013-09-30     5807850762
2013-12-31     5030481085
2014-03-31     4929100988
2014-06-30     4250437446
2015-09-30     3852541741
2015-03-31     3580441016
2014-09-30     3500426543
2014-12-31     3254527713
2015-06-30     2828894478
2016-03-31     2798550288
2015-12-31     2758062705
2016-06-30     2525159344
2016-09-30     2285537326
2016-12-31     2016573431
dtype: int64
交易第二的季度总量是： 11625428360