Pandas的corrwith与SPY一起工作正常但与^ 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')
Traceback(最近一次调用最后一次):
文件“”,第1行,in
文件“C:\ Anaconda \ lib \ site-packages \ spyderlib \ widgets \ externalshell \ sitecustomize.py”,第682行,在runfile execfile(filename,namespace)中
文件“C:\ Anaconda \ lib \ site-packages \ spyderlib \ widgets \ externalshell \ sitecustomize.py”,第71行,在execfile exec中(compile(scripttext,filename,'exec'),glob,loc)
文件"D:/@@@pg/yahoo_final_Chang/150830__Revised/test.py",第16行STOCKCORR = np.round(股票['PercentA'] .corrwith(股票['PercentA'] . ^ GSPC),3)
^ SyntaxError:语法无效