StringIO
as i used is not needed when read from a file.It make the string i copied from you post act like a file-like object in memory..
import pandas as pd df = pd.read_csv("data.csv", names=["Date", "Time", "Comment"]) df['DateTime'] = pd.to_datetime(df["Date"] + df["Time"]) mask = (df['DateTime'] >= '2022-03-08 16:15:00') df_new = df.loc[mask] #df_new = df_new.drop(columns=['DateTime']) df_new = df_new.drop(columns=['Date', 'Time']) print(df_new)
Output: Comment DateTime
6 String Value 2022-03-08 16:15:00
7 String Value 2022-03-08 16:15:00
8 String Value 2022-03-08 16:15:00
9 String Value 2022-03-08 16:15:00
10 String Value 2022-03-08 16:17:00
11 String Value 2022-03-08 16:17:00
Line 7 uncomment: Output: Date Time Comment
6 3/8/22 4:15 PM String Value
7 3/8/22 4:15 PM String Value
8 3/8/22 4:15 PM String Value
9 3/8/22 4:15 PM String Value
10 3/8/22 4:17 PM String Value
11 3/8/22 4:17 PM String Value