Hi.
I have a file csv (es10.csv) like this:
Now, i would like to get the following output:
My code is:
Is it possible to use operator: > or < or =!?
Thanks
I have a file csv (es10.csv) like this:
Output:Conc. Date I II
8926 18/11/2014 1 22
8927 20/11/2014 2 33
8928 30/11/2014 3 15
8929 18/12/2014 4 80
8930 28/12/2014 8 60
8931 31/12/2014 9 12
Note: Date = day**month**YearNow, i would like to get the following output:
Output:Conc. Date I II
8929 18/12/2014 4 1
8930 28/12/2014 8 0
8931 31/12/2014 9 1
Note: the value of the date must be greater than 30/11/2014My code is:
df=pd.read_csv("esv10.csv",encoding='windows-1252',sep="\t",decimal=',',keep_default_na=False, na_values=[''], converters={"Conc.":str},) pd.options.display.float_format = '{:,.0f}'.format myfilter=df["Date"]>"30/11/2014" df= df.where(myfilter ,axis=1).dropna() print(df)If i use the operator ==, output = 8928 30/11/2014 3 15
Is it possible to use operator: > or < or =!?
Thanks