我目前正在尝试将这些公司的名称与其索引(括号中显示的值)进行匹配。以下是我所拥有的:
company_list
Out[31]:
0 BTECH (0011)ACEBRITE-TECH BERHAD
1 EDEN (7471)MAINEDEN INC. BERHAD
2 GASMSIA (5209)MAINGAS MALAYSIA BERHAD
3 MALAKOF (5264)MAINMALAKOFF CORPORATION BERHAD
4 MFCB (3069)MAINMEGA FIRST CORPORATION BERHAD
5 PBA (5041)MAINPBA HOLDINGS BHD
6 PETGAS (6033)MAINPETRONAS GAS BERHAD
7 RANHILL (5272)MAINRANHILL UTILITIES BERHAD
8 SALCON (8567)MAINSALCON BERHAD
9 TALIWRK (8524)MAINTALIWORKS CORPORATION BERHAD
10 TENAGA (5347)MAINTENAGA NASIONAL BHD
11 YTL (4677)MAINYTL CORPORATION BERHAD
12 YTLPOWR (6742)MAINYTL POWER INTERNATIONAL BHD
Name: Company, dtype: object
现在,当我使用yfinance
检索历史股价时,它帮助我按升序排列公司指数:
import re
import yfinance as yf
def sto_data(start, end, adj_close_fname):
sto_code = []
for i in range(len(company_list)):
temp = re.findall(r'\d+', company_list[i])
res = "".join(temp)
sto_code.append(f'{res}.KL')
stocks_data = yf.download(sto_code,start=start, end=end)
stocks_adj_close = stocks_data['Adj Close']
stocks_adj_close.to_csv(adj_close_fname)
return stocks_adj_close
以下是保存到CSV文件中的内容:
Date,0011.KL,3069.KL,4677.KL,5041.KL,5209.KL,5264.KL,5272.KL,5347.KL,6033.KL,6742.KL,7471.KL,8524.KL,8567.KL
2020-01-02,0.21262522041797638,2.504232406616211,0.9967740178108215,1.0405075550079346,2.516713857650757,0.7837547063827515,0.9970082640647888,12.046622276306152,15.702932357788086,0.7417479157447815,0.2150000035762787,0.7533007264137268,0.23168399930000305
2020-01-03,0.21735022962093353,2.5091044902801514,0.9774190187454224,1.0405075550079346,2.562472105026245,0.7792503833770752,0.959027886390686,12.010391235351562,15.888110160827637,0.769220769405365,0.20499999821186066,0.7575327157974243,0.22695599496364594
2020-01-06,0.21735022962093353,2.504232406616211,0.9435480237007141,1.050053596496582,2.580775499343872,0.7792503833770752,0.9400370717048645,11.865468978881836,15.628861427307129,0.7646419405937195,0.20999999344348907,0.7575327157974243,0.2127709984779358
从上面的结果可以看出,根据索引,公司列表和CSV文件的顺序不同。我希望知道如何将公司与其保存在CSV文件中的索引进行匹配,以便获得以下输出:
0011.KL - ACEBRITE-TECH BERHAD
3069.KL - MAINMEGA FIRST CORPORATION BERHAD
...
快速一看,您的订单可能不是您所期望的,因为您正在添加新的列表STOU代码。另外,你确定你想把股票收回来吗
您可以按如下方式指定列名:
代码:
结果:
相关问题 更多 >
编程相关推荐