- +在此添加单个AI新笔记
pandas列级df[""] = df[""].xx数据截取、数据转换日期
![列级 - df[""] = df[""].xx - 数据截取、数据转换日期](/_next/image?url=https%3A%2F%2Fbookchips.com%2Fchips%2F6850eb130b9569655f1202ce%2F%E5%88%97%E7%BA%A7-df%5B__%5D%3Ddf%5B__%5D.xx-%E6%95%B0%E6%8D%AE%E6%88%AA%E5%8F%96%E3%80%81%E6%95%B0%E6%8D%AE%E8%BD%AC%E6%8D%A2%E6%97%A5%E6%9C%9F.png&w=3840&q=85)
数据截取
df['日期按日'] = df['日期按日'].astype("str")df['日期按日'] = df['日期按日'].str[0:10]
可以获得日期，把2024-01-01 00:00:00剪切得到2024-01-01
import numpy as npimport pandas as pddf = pd.DataFrame(data=[{"A":"2024-01-01 00:00:00", "B":"a"}, {"A":"2024-01-01 00:00:00", "B":"b"}])print(df)df['A'] = df['A'].astype("str")df['A'] = df['A'].str[0:10]print(df)
数据转换日期获得星期几
可以获得日期，把2024-01-01 00:00:00获得星期几
df['星期几'] = pd.to_datetime(df['星期几'])df['星期几'] = df['星期几'].dt.dayofweek + 1
import numpy as npimport pandas as pddf = pd.DataFrame(data=[{"A":"2024-01-01 00:00:00", "B":"a"}, {"A":"2024-01-09 00:00:00", "B":"b"}])print(df)df['A'] = pd.to_datetime(df['A'])df['星期几'] = df['A'].dt.dayofweek + 1print(df)
