#!/usr/bin/env python # coding: utf-8 # In[1]: get_ipython().run_line_magic('matplotlib', 'inline') import pandas as pd # In[2]: url='https://raw.githubusercontent.com/zdefne-usgs/Moody-Tidal-Atlas/master/table7_S2.csv' df = pd.read_csv(url,skiprows=7) # In[3]: df = df.fillna('') # In[4]: pd.isnull(df.iloc[:,0]) # In[5]: ind = df.iloc[:,0].str.contains(' N') # In[6]: df.iloc[:,0][ind] # In[ ]: # In[7]: df.iloc[:,0][ind] # In[ ]: