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
