python - 从 for 循环写入多个 CSV 文件
问题描述
我有一个for loop
获取股票代码和另一个用于获取股票数据的 for 循环。现在我正在尝试创建 csv 文件,该文件将从第一个 for 循环中获取股票名称的数据,并将股票数据添加到 CSV 文件中。
stock_data = []
with open('Nifty 50 Scrapped data.csv') as csvfile:
stockticker_data = csv.reader(csvfile, delimiter=' ')
for row in stockticker_data:
# print(row)
all_data = []
for ticker in row:
stock_data.append(web.get_data_yahoo(ticker, '1/1/2018', '1/1/2019'))
with open(ticker, 'w') as f:
f = open(ticker,'w')
f.write(stock_data)
f.close()
我收到以下错误:
f.write(stock_data)
TypeError: write() argument must be str, not list
的输出 print(stock_data)
:
[ High Low ... Volume Adj Close
Date ...
2018-01-01 1165.000000 1138.099976 ... 591349.0 1127.366211
2018-01-02 1150.000000 1134.050049 ... 516171.0 1126.479004
2018-01-03 1149.000000 1135.300049 ... 593809.0 1125.641235
2018-01-04 1178.000000 1145.900024 ... 729965.0 1155.361816
2018-01-05 1192.000000 1167.449951 ... 1151320.0 1168.373901
... ... ... ... ... ...
2018-12-27 1384.750000 1354.300049 ... 2174090.0 1362.613403
2018-12-28 1383.000000 1359.000000 ... 1705033.0 1356.160278
2018-12-31 1378.000000 1367.300049 ... 698593.0 1363.159546
2019-01-01 1379.699951 1358.599976 ... 664707.0 1361.670410
2019-01-02 1386.849976 1361.599976 ... 1233780.0 1373.335693
[248 rows x 6 columns]]
[ High Low ... Volume Adj Close
Date ...
2018-01-01 1165.000000 1138.099976 ... 591349.0 1127.366211
2018-01-02 1150.000000 1134.050049 ... 516171.0 1126.479004
2018-01-03 1149.000000 1135.300049 ... 593809.0 1125.641235
2018-01-04 1178.000000 1145.900024 ... 729965.0 1155.361816
2018-01-05 1192.000000 1167.449951 ... 1151320.0 1168.373901
... ... ... ... ... ...
2018-12-27 1384.750000 1354.300049 ... 2174090.0 1362.613403
2018-12-28 1383.000000 1359.000000 ... 1705033.0 1356.160278
2018-12-31 1378.000000 1367.300049 ... 698593.0 1363.159546
2019-01-01 1379.699951 1358.599976 ... 664707.0 1361.670410
2019-01-02 1386.849976 1361.599976 ... 1233780.0 1373.335693
解决方案
此错误告诉您stock_data
is alist
并且write()
方法需要 a str
。如何解决知道返回的数据web.get_data_yahoo()
是 a 的问题pd.DataFrame
?我们可以这样pd.to_csv
做:
stock_data = []
with open('Nifty 50 Scrapped data.csv') as csvfile:
stockticker_data = csv.reader(csvfile, delimiter=' ')
for row in stockticker_data:
# print(row)
all_data = []
for ticker in row:
stock_data.append(web.get_data_yahoo(ticker, '1/1/2018', '1/1/2019'))
for df in stock_data:
df.to_csv(ticker, header=None, index=None, sep=' ', mode='a')
推荐阅读
- reactjs - 是否有更好的方法来实现 Google 表格的类似单元格功能?
- java - 我的 JCheckBox 程序只显示一个框。这是为什么?
- chart.js - ChartJS 旋转 90' 但保持文本笔直
- python - 给框架尺寸
- java - 在 MySQL DB 中的表更新上刷新 Spring Boot 应用程序中的 bean
- javascript - 通过比较两个数组获得总和
- perl - 解析命令行参数,但不验证
- sql - 如何计算 postgreSQL 中两天的时间差并以天数返回?
- javascript - 如何将 ExtJS“复选框”(按钮)与 Javascript/JQuery 同步?
- flutter - Flutter:Flutter Video Player 无法播放视频文件 TWICE [视频控制器处理后无法使用]~