Data_Time 这一列,按照时间过滤拆分,但是12/14/2021 4:55:40 PM,无法给excel 作为文件名需要改成20211214165540 这个格式,
import os
import pandas as pd
import datetime
file_path=r"D:\CertData_collect\Test python\3066.xlsx"
data=pd.read_excel(file_path,sheet_name= "sheet1")
grouped_df = data.groupby("Date_Time")
for group_name, group_df in grouped_df:
sn = data.iloc[1, 1]
group_name_str = group_name.strftime('%Y%m%d%H%M%S')
file_name = f"{sn}_{group_name_str}"
new_file_path=r"D:\CertData_collect\Test python\ "+ file_name + ".xlsx"
group_df.to_excel(new_file_path,sheet_name=file_name,index=False)