1234567891011121314151617181920212223 |
- import os
- import pandas as pd
- base_dir = '/data/common/北京市科委/result'
- factorys = os.listdir(base_dir)
- factorys.sort()
- factorys=['5U']
- df_all=pd.DataFrame
- for factory in factorys:
- dates = os.listdir(os.path.join(base_dir, factory))
- dates.sort()
- for date in dates:
- files = os.listdir(os.path.join(base_dir, factory, date))
- for f in files:
- if f.endswith(".csv"):
- file_path = os.path.join(base_dir, factory, date, f)
- print(f" 读取文件{file_path}")
- df = pd.read_csv(file_path)
- if len(df_all)==0:
- df_all=df
- else:
- df_all=df_all=df.append(df)
- break
- df_all.to_excel('df_all.xlsx')
|