将带时间戳的excel文件转换为python日期和时间

import pandas as pd
from datetime import datetime, timedelta

df = pd.read_excel('文件路径.xlsx')
df['时间戳列名'] = pd.to_datetime(df['时间戳列名'], unit='s') + timedelta(hours=8)

df['年'] = df['时间戳列名'].dt.year
df['月'] = df['时间戳列名'].dt.month
df['日'] = df['时间戳列名'].dt.day
df['时'] = df['时间戳列名'].dt.hour
df['分'] = df['时间戳列名'].dt.minute
df['秒'] = df['时间戳列名'].dt.second

df.to_excel('转换后的文件路径.xlsx', index=False)