思路:
1)用pandas读取excel表格数据(DataFrame格式)
2)把要追加的数据转成DataFrame
3)新旧DataFrame拼接
4)写入excel
import pandas as pd
import os
# 1
data_pth = "E:\\博后工作\\研究\\刘周_MR动态\\数据记录.xlsx"
df = pd.read_excel(data_pth)
# 2
path1 = "D:\\刘周_MR动态参数图像生成_深圳肿瘤\\uteraus_DCE_with_parametric_maps\\2022.5.16niming"
# path1 = "D:\\刘周_MR动态参数图像生成_深圳肿瘤\\UTERUS_2022.5.6"
patients = os.listdir(path1)
patients.sort()
datan = path1.split('\\')[-1]
data = {
"数据批次":[datan]*len(patients),
"病人编号": patients
}
dataF = pd.DataFrame(data)
# 3
ndf = pd.concat([df, dataF], ignore_index=True)
# 4
ndf.to_excel(data_pth, index=False)
拼接前:
拼接后: