这是我在数据集01/04/2021中的原始日期,格式为日/月/年。当我使用熊猫时间戳将日期转换为月名和日名时,它会将日期转换为m/d/y格式,用于<12天,并将其用作日期> 12的格式。
代码
for attacks in df['Create Date/Time']:
event_date.append(pd.Timestamp(attacks).day)
event_month.append(pd.Timestamp(attacks).month_name())
event_year.append (pd.Timestamp(attacks).year)
event_day.append(pd.Timestamp(attacks).day_name())
combined_time.append(pd.Timestamp(attacks).ctime())发布于 2022-03-08 18:26:18
你可以这样做,以实现我认为你的问题是问(或接近):
import pandas as pd
records = [
{'Create Date/Time': '01/04/2021'},
{'Create Date/Time': '13/04/2021'}
]
df = pd.DataFrame(records)
print(df)
ser = pd.to_datetime(df['Create Date/Time'], dayfirst=True)
print("date series:\n", ser)
ser = ser.apply(lambda dt:' '.join((dt.month_name(), dt.day_name())))
print("month name and day name series:\n", ser)输出:
Create Date/Time
0 01/04/2021
1 13/04/2021
date series:
0 2021-04-01
1 2021-04-13
Name: Create Date/Time, dtype: datetime64[ns]
month name and day name series:
0 April Thursday
1 April Tuesday
Name: Create Date/Time, dtype: objecthttps://stackoverflow.com/questions/71399352
复制相似问题