今天找一个dataframe种抽取多列的方法,没有成功,后来找到 正则表达式,产生多列,然后写入同一个excel file的办法。
pandas分别写入excel的不同sheet方法
(1)单个dataframe (df)写入excel, 直接写,df.to_excel()
(2)多个dataframe (df)写入excel, 可以借用pandas.ExcelWriter来写 ,df.to_excel()
2021-04-28 00:26七巧板子 Python
http://www.zzvips.com/article/159798.html
import pandas as pd
import os
path=r"D:\RADAR\datalog\py_tool" #your path
filename="test0514.xlsx"
fpath1 = os.path.join(path, filename)
writer = pd.ExcelFile(fpath1 )
df1 = pd.DataFrame()
df2 = pd.DataFrame()
df1.to_excel(writer, sheet_name='df_1')
df2.to_excel(writer, sheet_name='df_2')
writer.save()