大Pandas关于间谍与^GSPC的相关用法

2024-09-30 12:12:16 发布

您现在位置:Python中文网/ 问答频道 /正文

熊猫的畜栏和间谍一起工作很好,但与^GSPC不一样。 有人能帮我吗?提前谢谢。在

import pandas.io.data as web                   
import numpy as np
import pandas as pd
import matplotlib as mpl
import matplotlib.pyplot as plt
import csv

Symbol = ['^GSPC','SPY','XLK','XLV','XLY','XLP','XLE','XLF','XLI','XLB','XLU']

STOCK = web.DataReader(name=Symbol,data_source='yahoo',start='2000-1-1',end='2009-3-1')

STOCK['PercentA'] = np.round(np.log(STOCK['Adj Close']/STOCK['Adj Close'].shift(1)),3)

### OK wiht SPY, but not OK wiht ^GSPC
STOCKCORR = np.round(STOCK['PercentA'].corrwith(STOCK['PercentA'].^GSPC),3)     

StockNan = STOCKCORR[~STOCKCORR.isnull()]
StockOrder = StockNan.order().iloc[::-1]
StockRows = StockOrder.iloc[:20]          
print StockRows

错误消息:

runfile('D:/@@@pg/yahoo_final_Chang/150830__Revised/test.py', wdir='D:/@@@pg/yahoo_final_Chang/150830__Revised')

回溯(最近一次呼叫):

文件“”,第1行,输入

文件“C:\Anaconda\lib\site packages\spyderlib\widgets\externalshell\网站自定义.py,第682行,在runfile中 execfile(文件名,命名空间)

文件“C:\Anaconda\lib\site packages\spyderlib\widgets\externalshell\网站自定义.py“,第71行,在execfile中 exec(编译(scripttext,文件名,'exec'),glob,loc)

文件“D:/@@@pg/yahoo\u final\u Chang/150830修订版/测试.py“,第16行 库存校正=np.圆形(库存['PercentA'].corrwith(STOCK['PercentA'].^GSPC),3)
^ 语法错误:语法无效


Tags: 文件pyimportpandasdataasstocknp

热门问题