In [1]:
%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])
Out[4]:
0      False
1      False
2      False
3      False
4      False
5      False
6      False
7      False
8      False
9      False
10     False
11     False
12     False
13     False
14     False
15     False
16     False
17     False
18     False
19     False
20     False
21     False
22     False
23     False
24     False
25     False
26     False
27     False
28     False
29     False
       ...  
497    False
498    False
499    False
500    False
501    False
502    False
503    False
504    False
505    False
506    False
507    False
508    False
509    False
510    False
511    False
512    False
513    False
514    False
515    False
516    False
517    False
518    False
519    False
520    False
521    False
522    False
523    False
524    False
525    False
526    False
Name: Unnamed: 0, Length: 527, dtype: bool
In [5]:
ind = df.iloc[:,0].str.contains(' N')
In [6]:
df.iloc[:,0][ind]
Out[6]:
3      43 34 N
7      42 52 N
11     42 37 N
15     42 52 N
19     43 22 N
25     43 02 N
29     43 45 N
34     43 15 N
38     44 26 N
42     42 30 N
46     42 35 N
50     42 40 N
58     42 45 N
62     42 49 N
68     43 00 N
73     44 17 N
77     44 25 N
78     63 57 N
81     42 46 N
85     42 42 N
89     43 34 N
93     43 11 N
94     65 43 N
97     42 50 N
103    42 22 N
107    42 18 N
111    42 11 N
117    43 11 N
121    43 40 N
125    43 13 N
        ...   
394    41 27 N
398    39 56 N
402    40 28 N
406    40 56 N
410    41 26 N
416    39 43 N
420    39 55 N
424    40 12 N
433    40 34 N
438    40 47 N
443    39 57 N
447    38 55 N
451    39 27 N
455    39 16 N
459    39 55 N
463    40 29 N
467    38 31 N
471    38 33 N
475    38 44 N
481    39 24 N
485    39 46 N
489    38 59 N
493    39 28 N
497    38 58 N
503    37 55 N
507    36 50 N
511    35 05 N
515    36 59 N
521    42 00 N
525    39 17 N
Name: Unnamed: 0, Length: 120, dtype: object
In [7]:
df.iloc[:,0][ind]
Out[7]:
3      43 34 N
7      42 52 N
11     42 37 N
15     42 52 N
19     43 22 N
25     43 02 N
29     43 45 N
34     43 15 N
38     44 26 N
42     42 30 N
46     42 35 N
50     42 40 N
58     42 45 N
62     42 49 N
68     43 00 N
73     44 17 N
77     44 25 N
78     63 57 N
81     42 46 N
85     42 42 N
89     43 34 N
93     43 11 N
94     65 43 N
97     42 50 N
103    42 22 N
107    42 18 N
111    42 11 N
117    43 11 N
121    43 40 N
125    43 13 N
        ...   
394    41 27 N
398    39 56 N
402    40 28 N
406    40 56 N
410    41 26 N
416    39 43 N
420    39 55 N
424    40 12 N
433    40 34 N
438    40 47 N
443    39 57 N
447    38 55 N
451    39 27 N
455    39 16 N
459    39 55 N
463    40 29 N
467    38 31 N
471    38 33 N
475    38 44 N
481    39 24 N
485    39 46 N
489    38 59 N
493    39 28 N
497    38 58 N
503    37 55 N
507    36 50 N
511    35 05 N
515    36 59 N
521    42 00 N
525    39 17 N
Name: Unnamed: 0, Length: 120, dtype: object