分类：删除空值

2021
03-07

python 删除空值且合并excel的操作

适用条件1：excel表比较多2：excel的数据量比较大，不然的话excel筛选&手动合并还是很舒服滴~需求取出【电话】列中不为空所对应的行的值并且将几张表给合并起来来来来，放代码了！！importxlrdimportpandasaspdimportopenpyxltarget_xls="合并表1.xlsx"source_xls=["全1.xlsx","全2.xlsx","全3.xlsx",\"全4.xlsx","全5.xlsx","全6.xlsx"]sysptoms=pd.DataFrame()foriinrange(len(source_xls)):print(i)#了解... 继续阅读 >