test7.rar (7.97 KB)

程序代码：

if __name__ == '__main__':
    src_data=pd.read_excel('./sample portfolio.xlsx',header=0,nrows=5,usecols=['ETF代码'])
    # print(src_data)
    res_list=[]
    curr_date=time.strftime("%Y-%m-%d", time.localtime())
    for index,gupiao_name in src_data.items():
        for gpname in gupiao_name:
            tem_name=gpname[0:6]
            tem_list=get_news(tem_name,curr_date)
            res_list.append(tem_list)
    # print(res_list)
    df=pd.DataFrame(res_list)
    writer=pd.ExcelWriter('test8.xlsx',engine='xlsxwriter')
    df.to_excel(writer,sheet_name='结果',index=False)
    writer.save()

程序代码：

import pandas as pd
df=pd.read_excel('test.xlsx')
df['收盘价']=df['收盘价'].apply(lambda x: eval(x))
df2=pd.DataFrame(df['收盘价'].to_list(),columns=eval(df.iloc[0,1]))
df2['股票代码']=df['股票代码']
df2.set_index('股票代码',inplace=True)
df2.to_excel('result.xlsx')