data列の飛び飛びの日付を埋めたい

python

1import pandas as pd 2import io 3 4csv_data = ''' 5id,name,date,timer,count 6123,AAA,2024-06-05,0 days 11:24:50,1 7123,AAA,2024-06-15,2 days 12:24:50,3 8123,AAA,2024-06-20,1 days 09:05:32,3 9456,BBB,2024-06-01,3 days 11:00:00,8 10456,BBB,2024-06-05,3 days 20:20:40,5 11456,BBB,2024-06-10,6 days 11:20:51,8 12456,BBB,2024-06-20,1 days 13:40:13,0 13456,BBB,2024-06-30,0 days 17:24:32,5 14'''15 16df = pd.read_csv(io.StringIO(csv_data), dtype=str)17df['date'] = pd.to_datetime(df['date'])18idx = pd.date_range(start="2024/06/01", end="2024/06/30", freq="D")19df = df.groupby(["id", "name" , "timer", "count"])["date"].apply(lambda s: s.reindex(idx)).explode().reset_index()20df = df.drop("date", axis=1).rename(columns={"level_4": "date"})21df = df[["id", "name" , "date", "timer", "count"]]22print(df)