You can get the type of the entries of your column with map:
df['ABC'].map(type)
So to filter on all values, which are not stored as str, you can use:
df['ABC'].map(type) != str
If however you just want to check if some of the rows contain a string, that has a special format (like a date), you can check this with a regex like:
df['ABC'].str.match('[0-9]{4}-[0-9]{2}-[0-9]{2}')
But of course, that is no exact date check. E.g. it would also return True
for values like 0000-13-91
, but this was only meant to give you an idea anyways.
No comments:
Post a Comment