如何調整成Python的日期格式

首先我們可用pandas的to_datetime函數：

import pandas as pd

data["一般日期_python格式"] = pd.to_datetime(data["一般日期"])

如果是中文日期的話，我們可以這麼做

for i,j in zip(["年","月","日"],["/","/",""]):

data["中文日期"] = list(map(lambda x: x.replace(i,j),data["中文日期"]))

data["中文日期_python格式"] = pd.to_datetime(data["中文日期"])

另外，我們可用datetime模組的date()函數做同樣的事情：

data["一般日期_python格式"] = list(map(lambda x: datetime.date(year = int(x.split("/")[0]),

month = int(x.split("/")[1]),

day = int(x.split("/")[2])),data["一般日期"]))

同樣的也可以轉換中文日期

for i,j in zip(["年","月","日"],["/","/",""]):

data["中文日期"] = list(map(lambda x: x.replace(i,j),data["中文日期"]))

data["中文日期_python格式"] = list(map(lambda x: datetime.date(year = int(x.split("/")[0]),

month = int(x.split("/")[1]),

day = int(x.split("/")[2])),

data["中文日期"]))

如果是「日期時間」格式，也可以用datetime模組的datetime()函數來做轉換

data["日期部分"] = list(map(lambda x: x.split(" ")[0] ,data["日期時間"]))

for i,j in zip(["年","月","日"],[0,1,2]):

data[i] = list(map(lambda x: x.split("/")[j],data["日期部分"]))



data["時間部分"] = list(map(lambda x: x.split(" ")[1] ,data["日期時間"]))

for i,j in zip(["時","分","秒"],[0,1,2]):

data[i] = list(map(lambda x: x.split(":")[j],data["時間部分"]))



data["日期時間_彙整"] = data["年"] + "/" + data["月"]+ "/" + data["日"]+ "/" + data["時"]+ "/" + data["分"]+ "/" + data["秒"]

data["日期時間_python格式"] = list(map(lambda x: datetime.datetime(year = int(x.split("/")[0]),

month = int(x.split("/")[1]),

day = int(x.split("/")[2]),

hour = int(x.split("/")[3]),

minute = int(x.split("/")[4]),

second = int(x.split("/")[5]))

,data["日期時間_彙整"]))