使用Pandas dataFrame拆分日期复杂格式

import pandas as pd

# 创建一个包含日期复杂格式的DataFrame
data = {'date': ['2022-01-01 10:30:00', '2022-02-15 15:45:30', '2022-03-20 08:15:00']}
df = pd.DataFrame(data)

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

# 拆分日期时间为年、月、日、小时、分钟、秒
df['year'] = df['date'].dt.year
df['month'] = df['date'].dt.month
df['day'] = df['date'].dt.day
df['hour'] = df['date'].dt.hour
df['minute'] = df['date'].dt.minute
df['second'] = df['date'].dt.second

# 打印拆分后的DataFrame
print(df)

                 date  year  month  day  hour  minute  second
0 2022-01-01 10:30:00  2022      1    1    10      30       0
1 2022-02-15 15:45:30  2022      2   15    15      45      30
2 2022-03-20 08:15:00  2022      3   20     8      15       0