从包含两个日期的字符串的pandas单元格创建日期列表

import pandas as pd

# 假设单元格的值为"2022-01-01 to 2022-01-10"
cell_value = "2022-01-01 to 2022-01-10"

# 拆分起始日期和结束日期
start_date, end_date = cell_value.split(" to ")

# 转换为日期类型
start_date = pd.to_datetime(start_date)
end_date = pd.to_datetime(end_date)

# 创建日期范围
date_range = pd.date_range(start=start_date, end=end_date)

# 打印日期列表
print(date_range)

DatetimeIndex(['2022-01-01', '2022-01-02', '2022-01-03', '2022-01-04',
               '2022-01-05', '2022-01-06', '2022-01-07', '2022-01-08',
               '2022-01-09', '2022-01-10'],
              dtype='datetime64[ns]', freq='D')