将datetime索引透视到开始和结束列

import pandas as pd

# 创建一个包含日期时间索引的DataFrame
data = {'datetime': pd.date_range(start='2022-01-01', end='2022-01-10')}
df = pd.DataFrame(data)

# 将datetime索引透视到开始和结束列
df['start'] = df['datetime']
df['end'] = df['datetime'].shift(-1)
df = df[:-1]  # 删除最后一行，因为没有对应的结束时间

# 打印结果
print(df)

    datetime      start        end
0 2022-01-01 2022-01-01 2022-01-02
1 2022-01-02 2022-01-02 2022-01-03
2 2022-01-03 2022-01-03 2022-01-04
3 2022-01-04 2022-01-04 2022-01-05
4 2022-01-05 2022-01-05 2022-01-06
5 2022-01-06 2022-01-06 2022-01-07
6 2022-01-07 2022-01-07 2022-01-08
7 2022-01-08 2022-01-08 2022-01-09
8 2022-01-09 2022-01-09 2022-01-10