import pandas as pd
from datetime import datetime
# 创建一个示例DataFrame
data = {'Date': ['2024-03-12', '2024-03-13', '2024-03-14'],
'Value': [10, 20, 30]}
df = pd.DataFrame(data)
# 字符串转换为时间戳
df['Date'] = pd.to_datetime(df['Date'])
# 时间戳转换为字符串
df['Date_str'] = df['Date'].dt.strftime('%Y-%m-%d')
# 时间戳转换为字符串,只显示日期部分
df['Date_date_str'] = df['Date'].dt.date.astype(str)
# 时间戳转换为字符串,只显示时间部分
df['Date_time_str'] = df['Date'].dt.time.astype(str)
# 时间戳转换为字符串,自定义格式
df['Date_custom_str'] = df['Date'].dt.strftime('%Y/%m/%d %H:%M:%S')
# 字符串转换为时间戳
date_str = '2024-03-15'
date_timestamp = pd.to_datetime(date_str)
# 当前时间戳
current_timestamp = pd.Timestamp.now()
# 当前时间戳转换为字符串
current_timestamp_str = current_timestamp.strftime('%Y-%m-%d %H:%M:%S')
# 打印转换后的DataFrame
print(df)
print("String to Timestamp:", date_timestamp)
print("Current Timestamp:", current_timestamp)
print("Current Timestamp String:", current_timestamp_str)
12-23