(May-13-2019, 04:05 PM)frame Wrote: The conversion work, but applying "df.where" to filter df["Date"]>"30/11/2014"", the result does not change. Is valid the operator > or i do to use only operator ==?The code for @Yoriz should work,is that what you have problem with or are doing something else?
Doing
myfilter = df["Date"] == "30/11/2014"
it will only drop.Output: Conc. Date I II
2 8928.0 30/11/2014 3.0 15.0
Test of code:>>> import pandas as pd >>> df = pd.read_clipboard() >>> df['Date'] = pd.to_datetime(df['Date']) >>> df Conc. Date I II 0 8926 2014-11-18 1 22 1 8927 2014-11-20 2 33 2 8928 2014-11-30 3 15 3 8929 2014-12-18 4 80 4 8930 2014-12-28 8 60 5 8931 2014-12-31 9 12 >>> myfilter = df["Date"] > "30/11/2014" >>> df = df.where(myfilter ,axis=1).dropna() >>> df['Date'] = df['Date'].dt.strftime('%d/%m/%Y') >>> df Conc. Date I II 3 8929.0 18/12/2014 4.0 80.0 4 8930.0 28/12/2014 8.0 60.0 5 8931.0 31/12/2014 9.0 12.0