如何在pandas中获取两列之间的日期范围信息

import pandas as pd

# 创建示例DataFrame
data = {
    'start_date': ['2023-01-01', '2023-02-15', '2023-03-20'],
    'end_date': ['2023-01-10', '2023-02-28', '2023-04-05']
}
df = pd.DataFrame(data)

# 将字符串转换为日期时间格式
df['start_date'] = pd.to_datetime(df['start_date'])
df['end_date'] = pd.to_datetime(df['end_date'])

# 计算日期范围
df['date_range'] = df['end_date'] - df['start_date']

print(df)

  start_date   end_date date_range
0 2023-01-01 2023-01-10   9 days
1 2023-02-15 2023-02-28  13 days
2 2023-03-20 2023-04-05  16 days

df['start_date'] = pd.to_datetime(df['start_date'], format='%Y-%m-%d')

df['start_date'] = df['start_date'].dt.tz_localize('UTC')
df['end_date'] = df['end_date'].dt.tz_localize('UTC')

df.dropna(subset=['start_date', 'end_date'], inplace=True)