怎样提取日期每一行的前面七位

img

data = "2021-12-07"
print(str(data)[:7])
你题目的解答代码如下:

import pandas as pd
df=pd.DataFrame({"date":[
    "2021-02-06 00:00:00",
    "2021-02-07 00:00:00",
    "2021-03-16 00:00:00",
    "2021-10-07 00:00:00",
    "2021-12-06 00:00:00",
    "2021-12-11 00:00:00"
]})
s = df["date"].apply(lambda x: str(x)[:7])
print(s)

如有帮助,望采纳!谢谢!

可以这样获取:

import pandas as pd
df=pd.read_csv('t1107.csv')
df['日期']=df['日期'].str[:7]
print(df)
#获取日期
df['日期'] = pd.to_datetime(df['日期']).dt.strftime('%Y-%m-%d')
print(df)

如有帮助,请点采纳。