My dataframe looks like this
- clients4.google.com
- m.facebook.com
- static.ak.fbcdn.net
- static.ak.fbcdn.net
- static.ak.fbcdn.net
I want to select all the rows where the substring fb is available. In pandas dataframe
You can use StringMethods.contains
:
>>> df = pd.read_clipboard(header=None)
>>> df[df[0].str.contains('fb')]
0
2 static.ak.fbcdn.net
3 static.ak.fbcdn.net
4 static.ak.fbcdn.net