So there's a DataFrame say:
>>> df = pd.DataFrame({ ... 'A':[1,2,'Three',4], ... 'B':[1,'Two',3,4]}) >>> df A B 0 1 1 1 2 Two 2 Three 3 3 4 4
I want to select the rows whose datatype of particular row of a particular column is of type str
.
For example I want to select the row where type
of data in the column A
is a str
. so it should print something like:
A B 2 Three 3
Whose intuitive code would be like:
df[type(df.A) == str]
Which obviously doesn't works!
Thanks please help!
iloc selects rows based on an integer index. So, if you want to select the 5th row in a DataFrame, you would use df. iloc[[4]] since the first row is at index 0, the second row is at index 1, and so on.
This works:
df[df['A'].apply(lambda x: isinstance(x, str))]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With