Hi,
I'm working on data cleaning for a while (already posted some questions about this ) and this one is really bit "complicated" for me(beginner :p).
So this is how my raw file looks like: csv.file
How can I drop those rows that are not in a dateformat(the column type is still an object NOT datetime64[ns]!!!)
I tried this approach :
Thks
Karlito
I'm working on data cleaning for a while (already posted some questions about this ) and this one is really bit "complicated" for me(beginner :p).
So this is how my raw file looks like: csv.file
How can I drop those rows that are not in a dateformat(the column type is still an object NOT datetime64[ns]!!!)
I tried this approach :
df= pd.read_csv('file.csv', header = None) for index, row in df.iterrows(): if df[df[1].apply(lambda x: type(x)==int)]: df.drop(index, inplace=True)but didnt work
Thks
Karlito