import pandas as pd df = pd.read_csv("Order.csv",dtype='object') df['date'] = pd.to_datetime(df['date'],errors='coerce') df_618 = df[(df['date'].dt.month == 6) & (df['date'].dt.day == 18)] print(df_618[['price','shop_name']])