from glob import glob import pandas as pd ##### 電気使用量実績の読込 files = glob("juyo-*.csv") files.sort() df_kw = pd.DataFrame() for f in files: df_kw = pd.concat([df_kw, pd.read_csv(f,encoding="Shift_JIS",skiprows=2)]) df_kw = df_kw.reset_index(drop=True) df_kw["MW"] = df_kw["実績(万kW)"] * 10 df_kw.index = df_kw.index.map(lambda _: pd.to_datetime(df_kw.DATE[_] + " " + df_kw.TIME[_])) ##### 気温データの読込 # 気温デー