python 日期字符串转换时间戳

pandas dataframe时间转换时间戳

a = [["a", "2022-11-10 9:30"],
    ["b", "2021-10-10 10:10"]]
df = pd.DataFrame(a, columns=["name", "time"])
# name    object
# time    object
# dtype: object

# 首先将object类型转化为时间
df["time"] = pd.to_datetime(df["time"], utc=True, infer_datetime_format=True)
# name                 object
# time    datetime64[ns, UTC]
# dtype: object
df["time_10**9"] = df["time"].astype("int64") // 10 ** 9
# name                       object
# time          datetime64[ns, UTC]
# time_10**9                  int64
# dtype: object

python 字符串转时间戳

import pandas as pd
a1 = "2019-5-10 23:40"
print(int(pd.to_datetime(a1, utc=True, infer_datetime_format=True).timestamp()))

str1 = "2021/11/1 9:26:00"

import datetime

time1 = datetime.datetime.strptime(str1, "%Y/%m/%d %H:%M:%S")

print(time1.timestamp())  # 1635729960.0```