import pandas as pd df = pd.read_csv('Nowcoder.csv',sep=',',dtype=object) df = df[['Nowcoder_ID','Level','Last_submission_time']] df['Last_submission_time'] = pd.to_datetime(df['Last_submission_time']).dt.strftime('%Y-%m-%d') print(df)