#6.9 批量txt转化excel
import pandas as pd
import os
path = "Z:/Users/86152/Desktop/测试/转换前"
files = os.listdir(path)
data_new = pd.DataFrame()
for i in files:
data = pd.read_table(r'Z:/Users/86152/Desktop/测试/转换前/'+ i,header=None,delimiter='\s+',index_col=0,encoding="gbk")
data.to_excel(r'Z:/Users/86152/Desktop/测试/转换后/'+ i +'.xlsx',sheet_name="sheet1")
python批量txt转化excel
最新推荐文章于 2023-12-11 21:00:00 发布