%matplotlib inline
import pandas as pd
url='https://raw.githubusercontent.com/zdefne-usgs/Moody-Tidal-Atlas/master/table7_S2.csv'
df = pd.read_csv(url,skiprows=7)
df = df.fillna('')
pd.isnull(df.iloc[:,0])
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
ind = df.iloc[:,0].str.contains(' N')
df.iloc[:,0][ind]
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
df.iloc[:,0][ind]
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