我尝试运行代码以获取股票数据,但失败,显示以下错误:
'DatetimeProperties' object has no attribute 'weekday_name'
'NoneType' object has no attribute 'to_csv'
from pandas_datareader import data as web
import os
import pandas as pd
from pandas.testing import assert_frame_equal
def get_stock(ticker, start_date, end_date, s_window, l_window):
try:
df = web.get_data_yahoo(ticker, start=start_date, end=end_date)
df['Return'] = df['Adj Close'].pct_change()
df['Return'].fillna(0, inplace = True)
df['Date'] = df.index
df['Date'] = pd.to_datetime(df['Date'])
df['Month'] = df['Date'].dt.month
df['Year'] = df['Date'].dt.year
df['Day'] = df['Date'].dt.day
for col in ['Open', 'High', 'Low', 'Close', 'Adj Close']:
df[col] = df[col].round(2)
df['Weekday'] = df['Date'].dt.weekday_name
df['Week_Number'] = df['Date'].dt.strftime('%U')
df['Year_Week'] = df['Date'].dt.strftime('%Y-%U')
df['Short_MA'] = df['Adj Close'].rolling(window=s_window, min_periods=1).mean()
df['Long_MA'] = df['Adj Close'].rolling(window=l_window, min_periods=1).mean()
col_list = ['Date', 'Year', 'Month', 'Day', 'Weekday',
'Week_Number', 'Year_Week', 'Open',
'High', 'Low', 'Close', 'Volume', 'Adj Close',
'Return', 'Short_MA', 'Long_MA']
num_lines = len(df)
df = df[col_list]
print('read ', num_lines, ' lines of data for ticker: ' , ticker)
return df
except Exception as error:
print(error)
return None
try:
ticker='MSFT'
input_dir = r'/Users/sirishpulijala/Desktop'
output_file = os.path.join(input_dir, ticker + '.csv')
df = get_stock(ticker, start_date='2014-01-01', end_date='2019-12-31',
s_window=14, l_window=50)
df.to_csv(output_file, index=False)
print('wrote ' + str(len(df)) + ' lines to file: ' + output_file)
except Exception as e:
print(e)
print('failed to get Yahoo stock data for ticker: ', ticker)
您的问题如下所示:
将其更改为:
你可以走了
我们可以使用
df['Weekday'] = df['Date'].dt.strftime("%A")
这将给出工作日的名称
更多格式选项包括:
%A
-完整的工作日名称,如星期一、星期二等%w
-工作日作为十进制数字,如1,2,3等%a
-周日的缩写名称,如SUN、MON等%Y
-年%m
-月%d
-天%H
-hours%M
-分钟%S
-秒相关问题 更多 >
编程相关推荐