# 10位时间戳长数字-精确到秒
df = pd.DataFrame({
    'create_time': [1490195826, 1590195905, 1591206212]
})
df['create_time_2'] = pd.to_datetime(df['create_time'], unit='s')
df

# 13位时间戳长数字-精确到毫秒
df = pd.DataFrame({
    'create_time': [1490195826562, 1590195905523, 1591206212486]
})
df['create_time_2'] = pd.to_datetime(df['create_time'], unit='ms')
df

# 16位时间戳长数字-精确到微秒
df = pd.DataFrame({
    'create_time': [1490195826562956, 1590195905523421, 1591206212486365]
})
df['create_time_2'] = pd.to_datetime(df['create_time'], unit='us')
df

# 19位时间戳长数字-精确到纳秒
df = pd.DataFrame({
    'create_time': [1490195826562956523, 1590195905523421653, 1591206212486365475]
})
df['create_time_2'] = pd.to_datetime(df['create_time'], unit='ns')
df

df = pd.DataFrame({
    'create_time': ['20220808', '2022-05-06', '2022/7/9', '2021-10-23 13:20:23']
})
df['create_time_2'] = pd.to_datetime(df['create_time'], infer_datetime_format=True)
df

df = pd.DataFrame({
    'create_time': [datetime.datetime.now(), datetime.datetime.today() - datetime.timedelta(days=3, seconds=1000)]
})
df['create_time_2'] = df['create_time'].dt.strftime('%Y-%m-%d')
df['create_time_3'] = df['create_time'].dt.strftime('%Y-%m')
df

# 往前推3天
df = pd.DataFrame({
    'create_date': pd.date_range('2022-07-29', end='2022-08-03')
})
df['create_date_bef_3_day'] = df['create_date'] - datetime.timedelta(days=3)
df

# 往前推3个月
df = pd.DataFrame({
    'create_date': pd.date_range('2022-07-29', end='2022-08-03')
})
df['create_date_bef_3_month'] = df['create_date'] - pd.DateOffset(months=3)
df

# 所在周
df = pd.DataFrame({
    'create_date': pd.date_range('2022-07-29', end='2022-08-03')
})
df['create_week'] = df['create_date'].dt.to_period('W').dt.start_time
df

# 所在月、所在月的第1天和最后1天
df = pd.DataFrame({
    'create_date': pd.date_range('2022-07-29', end='2022-08-03')
})
df['create_month'] = df['create_date'].dt.strftime('%Y-%m')
df['create_month_start'] = df['create_date'].dt.to_period('M').dt.start_time.dt.date
df['create_month_end'] = df['create_date'].dt.to_period('M').dt.end_time.dt.date
df

# 前3个月的第1天和最后1天
df = pd.DataFrame({
    'create_date': pd.date_range('2022-07-29', end='2022-08-03')
})
df['bef_3_month_end'] = pd.DatetimeIndex(df['create_date']).shift(-3, freq='M')
df['bef_3_month_start'] = df['bef_3_month_end'].dt.to_period('M').dt.start_time
df

# 时间元素的提取
df = pd.DataFrame({
    'create_time': pd.date_range('2022-07-30 10:43:22', periods=3, freq='16H')
})
df['create_date'] = df['create_time'].dt.date
df['create_month1'] = df['create_time'].dt.month
df['create_month2'] = df['create_time'].dt.strftime('%Y-%m')
df['create_year'] = df['create_time'].dt.year
df['create_hour'] = df['create_time'].dt.hour
df

# 将时区转换成柏林时间和北京时间
df = pd.DataFrame({
    'create_date': pd.date_range("2022-01-01", periods=3, freq="D", tz='UTC')
})
df['create_date_2'] = df['create_date'].dt.tz_convert("Europe/Berlin")
df['create_date_3'] = df['create_date'].dt.tz_convert("Asia/Chongqing")
df

# 查看时区枚举值
import pytz
timezones = sorted(list(pytz.all_timezones_set))
[tz for tz in timezones if 'Berlin' in tz]