python - Pandas - 日期时间转换为当天的名称

Question

我正在使用 Pandas 处理包含不同列的 .csv 文件。其中一列包含记录的日期，我将其处理为日期时间格式。然后，我想添加一列，其中包含每个日期的星期几的名称。这是我的代码：

df["Date"]=pd.to_datetime(df["Date"])
df["Weekday"] = df["Date"].dt.dayofweek
week_days=["Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday"]
df["Weekday"] = str(df["Weekday"]).replace("3",week_days[3])
print(df["Weekday"].head(20))

请注意，我仅在星期四使用 .replace 行作为示例，其想法是在所有不同的日子里创建一个循环。

当我打印 Weekday 的结果时，我注意到转换为字符串以执行 .replace 函数“破坏”了格式，输出如下：

0     0          Thursday\n1          Thursday\n2   ...
1     0          Thursday\n1          Thursday\n2   ...
2     0          Thursday\n1          Thursday\n2   ...
3     0          Thursday\n1          Thursday\n2   ...
4     0          Thursday\n1          Thursday\n2   ...
5     0          Thursday\n1          Thursday\n2   ...
6     0          Thursday\n1          Thursday\n2   ...
7     0          Thursday\n1          Thursday\n2   ...
8     0          Thursday\n1          Thursday\n2   ...
9     0          Thursday\n1          Thursday\n2   ...
10    0          Thursday\n1          Thursday\n2   ...
11    0          Thursday\n1          Thursday\n2   ...
12    0          Thursday\n1          Thursday\n2   ...
13    0          Thursday\n1          Thursday\n2   ...
14    0          Thursday\n1          Thursday\n2   ...
15    0          Thursday\n1          Thursday\n2   ...
16    0          Thursday\n1          Thursday\n2   ...
17    0          Thursday\n1          Thursday\n2   ...
18    0          Thursday\n1          Thursday\n2   ...
19    0          Thursday\n1          Thursday\n2   ...

我想知道如何解决这个问题，或者是否有任何其他方法可供我使用来返回当天的名称。

标签： pythonpandasdataframe