import pandas as pd pd.set_option('display.max_columns', None) import re # finallist=[] # for i in range(0,len(ISIN)): # DMdata = DM[i] # QBdata = QB[i] # DMdata = DMdata.split(';') # QBdata = QBdata.split(',') # # if sorted(DMdata)!=sorted(QBdata): # finallist.append([ISIN[i],DM[i],QB[i]]) # # # print(len(finallist)) # df = pd.DataFrame(finallist, columns=['ISIN', 'DM','QB']) # df.to_excel(r'C:\Users\Admin\Desktop\final.xlsx',index=False) # QBdata = pd.read_excel(r'C:\Users\Admin\Desktop\trans主承销商.xlsx',sheet_name='qb数据') data= pd.read_excel(r'C:\Users\Admin\Desktop\test.xlsx',sheet_name=0) data=data.fillna('--') data = data.reset_index(drop=True) data = data[['BnD','global_coordinators','lead_managers']] data = data.to_dict('list') BND =data['Bn
pandas操作excel示例
最新推荐文章于 2023-12-26 11:29:20 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)