python

来源：互联网发布：c语言三日通pdf下载编辑：程序博客网时间：2024/06/06 01:42

# coding: utf-8# In[18]:# pip install pandas_datareaderimport pandas_datareader as pdrdf = pdr.DataReader('BIDU', data_source='yahoo')df.tail()# In[19]:df.columns# In[20]:df['Close'].sum()df['Close'].mean()df['Close'].std()df['Close'].min()df['Close'].max()df['Close'].count()# In[22]:df['diff'] = df['Close'] - df['Open']df.head()# In[25]:df['rise'] = df['diff'] > 0df['fall'] = df['diff'] < 0df.head()# In[26]:df[['rise', 'fall']].sum()# In[34]:# 查看某段时间的股票涨跌情况df.ix[(df.index >= '2017-01-01') & (df.index <= '2017-09-01'), ['rise', 'fall']].sum()# In[38]:# 根据年、月 统计股票涨跌df.groupby([df.index.year, df.index.month])['rise', 'fall'].sum()# In[44]:# 每日报酬df['ret'] = df['Close'].pct_change(1) # 相邻（period）的数据的变换百分比df.head()# In[45]:# 每月报酬df.groupby([df.index.year, df.index.month])['ret'].sum()

pandas_datareader 官方文档

阅读全文

0 0