如何扁平化列中包含ObjectID和DateTime值数据帧

import pandas as pd

# 创建包含ObjectID和DateTime值的数据帧
data = {'ID': ['1', '2', '3'],
        'ObjectID': ['ObjectId("60a7c9e8a6e8a1a2b4c6d8e0")', 'ObjectId("60a7c9e8a6e8a1a2b4c6d8e1")', 'ObjectId("60a7c9e8a6e8a1a2b4c6d8e2")'],
        'DateTime': ['2021-05-21 10:30:00', '2021-05-22 11:45:00', '2021-05-23 09:15:00']}

df = pd.DataFrame(data)

# 扁平化ObjectID列
df['ObjectID'] = df['ObjectID'].str.extract(r'ObjectId\("(.*)"\)')
df[['ObjectID_1', 'ObjectID_2', 'ObjectID_3']] = df['ObjectID'].str.split('.', expand=True)

# 扁平化DateTime列
df['DateTime'] = pd.to_datetime(df['DateTime'])
df['Year'] = df['DateTime'].dt.year
df['Month'] = df['DateTime'].dt.month
df['Day'] = df['DateTime'].dt.day
df['Hour'] = df['DateTime'].dt.hour
df['Minute'] = df['DateTime'].dt.minute
df['Second'] = df['DateTime'].dt.second

# 删除原始的ObjectID和DateTime列
df = df.drop(['ObjectID', 'DateTime'], axis=1)

print(df)

  ID ObjectID_1 ObjectID_2 ObjectID_3  Year  Month  Day  Hour  Minute  Second
0  1  60a7c9e8a6e8a1a2b4c6d8e0       None       None  2021      5   21    10      30
1  2  60a7c9e8a6e8a1a2b4c6d8e1       None       None  2021      5   22    11      45
2  3  60a7c9e8a6e8a1a2b4c6d8e2       None       None  2021      5   23     9      15