Pandas如何创建具有开始和结束的新数据帧，即使在不同的行上也是如此

import pandas as pd

data = {
    'event': ['A', 'B', 'C'],
    'start_time': ['2023-01-01 10:00:00', '2023-01-01 11:00:00', '2023-01-01 12:00:00'],
    'end_time': ['2023-01-01 10:30:00', '2023-01-01 11:45:00', '2023-01-01 12:30:00']
}

df = pd.DataFrame(data)
df['start_time'] = pd.to_datetime(df['start_time'])
df['end_time'] = pd.to_datetime(df['end_time'])

new_data = []

for index, row in df.iterrows():
    new_data.append({'event': f'{row["event"]} Start', 'time': row['start_time']})
    new_data.append({'event': f'{row["event"]} End', 'time': row['end_time']})

new_df = pd.DataFrame(new_data)
new_df = new_df.sort_values(by='time').reset_index(drop=True)

df['start_time'] = pd.to_datetime(df['start_time'], errors='coerce')
df['end_time'] = pd.to_datetime(df['end_time'], errors='coerce')

df = df.dropna(subset=['start_time', 'end_time'])