按datetime列的每个部分生成新列的实用程序函数

import pandas as pd

def generate_datetime_columns(df, column_name):
    # 将datetime列转换为pandas的Datetime类型
    df[column_name] = pd.to_datetime(df[column_name])
    
    # 生成新的列
    df['year'] = df[column_name].dt.year
    df['month'] = df[column_name].dt.month
    df['day'] = df[column_name].dt.day
    df['hour'] = df[column_name].dt.hour
    df['minute'] = df[column_name].dt.minute
    df['second'] = df[column_name].dt.second
    
    return df