- 文件处理
1.读文件
import pandas as pd
import numpy as np
ExcelFile="upload_data.xlsx"
Data_file = pd.read_excel(ExcelFile,sheet_name='temp',usecols = ['用户名','推荐人'])
df = pd.DataFrame(data= data_file)
df2 = pd.read_excel("test.xlsx",sheet_name=None) #sheet_name=None :一次性读取所有的sheet
pd.concat(df2).to_excel("test02.xlsx")
df1 = [pd.read_excel("test.xlsx",sheet_name=index) for index in range(3)]#读3个sheet
pd.concat(df1).to_excel("test01.xlsx")
2.写文件
df.to_csv('E:/upload_failed_prj.csv',index=None,encoding="utf_8_sig")
df1.to_csv(path + '/' + 'total.csv')
excel_header = ['日期','人数']
df.to_excel(out_xlsx, sheet_name='Sheet1', header=excel_header,index=False)
3. 批量删除文件
import os
import glob
path = r'E:\test'
for infile in glob.glob(os.path.join(path, '*_data_*.csv')):
os.remove(infile)
print(infile)
4.将一个文件内容追加到另一个文件中
with open(r'D:\user.xlsx','ab') as f:
f.write(open(r'E:\新注册用户.xlsx','rb').read())#将新注册用户内容追加到user后面