To find all lines in DataFrame by substring information

Question

I have a dataframe with number of columns and hundreds lines.

What would be the simple and best performance way to find all lines in DataFrame where cell in columns my_columns has a substring : abc

Welcome to Stack Overflow. Its required here to show what you've tried in order to seek assistance, like a code sample. See more here [How to ask](https://stackoverflow.com/help/how-to-ask) — Moha369, Sep 30 '20 at 12:51

score 0 · Answer 1 · answered Sep 30 '20 at 12:45

0

print(df.loc[df['my_column'] == 'abc'])

answered Sep 30 '20 at 12:45

Tomasz Słowik

Thanks, but 'abc' is a substing. cell can be "xxxabcyyy" – OcMaRUS Sep 30 '20 at 12:55
So than check out @Subasri sridhar answer :) – Tomasz Słowik Sep 30 '20 at 12:56

score 0 · Accepted Answer · answered Sep 30 '20 at 12:48

0

try :

df[df['my_columns'].str.contains('abc')]

answered Sep 30 '20 at 12:48

Subasri sridhar

What if I need any UPPER or lower case strings? As example, we have 'vvAbCvv' in the cell of DataFrame? – OcMaRUS Sep 30 '20 at 18:25
@OcMaRUS, try contains('abc', case=False) – Subasri sridhar Sep 30 '20 at 18:31
Thank you! Really appreciate your help! – OcMaRUS Sep 30 '20 at 19:10

2 Answers2