I have column 'ABC' which has 5000 rows. Currently, dtype of column is object. Mostly it has string values but some values dtype is not string, I want to find all those rows and modify those rows. Column is as following:
1 abc 2 def 3 ghi 4 23 5 mno 6 null 7 qwe 8 12-11-2019 ... ... ... 4900 ert 5000 tyu
In above case, I can use for loop to find out rows which do not have desired dtype. I just wanted to know, is their better way to solve this issue.
Note: I am using Pandas.