python pandas DataFrame 字符串转日期格式

python pandas DataFrame 字符串转日期格式

import pandas as pd
import numpy as np

df1 = pd.DataFrame(
    {
        '日期': ['2021-7-2', '2021-8-2', '2021-9-2', '2021-10-2'],
        'A': [1, 2, 3, 4],
        'B': [5, 6, 7, 8],
        'C': [9, 10, 11, 12],
        'D': [13, 14, 15, 16]
    },
    index=[0, 1, 2, 3])
print(df1)

         日期  A  B   C   D
0   2021-7-2  1  5   9  13
1   2021-8-2  2  6  10  14
2   2021-9-2  3  7  11  15
3  2021-10-2  4  8  12  16

df1["日期"] = pd.to_datetime(df1["日期"]) # 字符串转日期格式
print(df1)

         日期  A  B   C   D
0 2021-07-02  1  5   9  13
1 2021-08-02  2  6  10  14
2 2021-09-02  3  7  11  15
3 2021-10-02  4  8  12  16