import pandas as pd
import folium
readings_df = pd.read_excel('2017 LARWMP Swim Bacti Table.xls', header = 3)
station_details_df = pd.read_excel('2017 LARWMP Swim Bacti Table.xls', sheetname=1)
station_details_df.head()
LARWMP Station ID | Agency Station ID | Station Description | Station Source | Sampling Agency | Latitude | Longitude | Previous Station IDs | Comments | |
---|---|---|---|---|---|---|---|---|---|
0 | LALT200 | LALT200 | Bull Creek Sepulveda Basin | LARWMP | ABC/CWH | 34.17869 | -118.49692 | NaN | NaN |
1 | LAUT203 | LAUT203 | Millard Campground | LARWMP | ABC/CWH | 34.21693 | -118.14478 | NaN | NaN |
2 | LALT204 | LALT204 | Eaton Canyon | LARWMP | ABC/CWH | 34.19377 | -118.10360 | NaN | NaN |
3 | LAUT206 | LAUT206 | Big Tujunga Delta Flat | LARWMP | ABC/CWH | 34.30073 | -118.26243 | NaN | NaN |
4 | LAUT208 | LAUT208 | Switzer Canyon | LARWMP | ABC/CWH | 34.26636 | -118.14594 | NaN | NaN |
m = folium.Map(location=[34.0522, -118.2437],
tiles='Stamen Toner',
zoom_start=13)
station_details_df.apply(lambda x: folium.Marker([x.Latitude, x.Longitude], popup=x['Station Description']).add_to(m), axis = 1)
0 <folium.map.Marker object at 0x12070d6a0> 1 <folium.map.Marker object at 0x12071d128> 2 <folium.map.Marker object at 0x12070da90> 3 <folium.map.Marker object at 0x12071f518> 4 <folium.map.Marker object at 0x12070db38> 5 <folium.map.Marker object at 0x120704d30> 6 <folium.map.Marker object at 0x12071f4e0> 7 <folium.map.Marker object at 0x12071ff60> 8 <folium.map.Marker object at 0x12071d6d8> 9 <folium.map.Marker object at 0x12072b438> 10 <folium.map.Marker object at 0x120704eb8> 11 <folium.map.Marker object at 0x120727fd0> 12 <folium.map.Marker object at 0x12071f9e8> 13 <folium.map.Marker object at 0x120745b00> dtype: object
m
readings_df.head()
Date | 200 | 203 | 204 | 206 | 208 | 209 | 210 | 213 | 214 | 215 | 216 | 217 | 218 | 219 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | 2017-04-12 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 41 | 131 | 201 | NaN | NaN |
1 | 2017-04-18 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 318 | 158 | 119 | NaN | NaN |
2 | 2017-04-25 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 471 | 134 | 121 | NaN | NaN |
3 | 2017-05-02 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 175 | 63 | 63 | NaN | NaN |
4 | 2017-05-09 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | >24200 | >24200 | >24200 | NaN | NaN |
station_details_df
LARWMP Station ID | Agency Station ID | Station Description | Station Source | Sampling Agency | Latitude | Longitude | Previous Station IDs | Comments | |
---|---|---|---|---|---|---|---|---|---|
0 | LALT200 | LALT200 | Bull Creek Sepulveda Basin | LARWMP | ABC/CWH | 34.178690 | -118.496920 | NaN | NaN |
1 | LAUT203 | LAUT203 | Millard Campground | LARWMP | ABC/CWH | 34.216930 | -118.144780 | NaN | NaN |
2 | LALT204 | LALT204 | Eaton Canyon | LARWMP | ABC/CWH | 34.193770 | -118.103600 | NaN | NaN |
3 | LAUT206 | LAUT206 | Big Tujunga Delta Flat | LARWMP | ABC/CWH | 34.300730 | -118.262430 | NaN | NaN |
4 | LAUT208 | LAUT208 | Switzer Canyon | LARWMP | ABC/CWH | 34.266360 | -118.145940 | NaN | NaN |
5 | LAUT209 | LAUT209 | Gould Mesa Campground | LARWMP | ABC/CWH | 34.224960 | -118.178630 | NaN | NaN |
6 | LAUT210 | LAUT210 | Sturtevant Falls | LARWMP | ABC/CWH | 34.211450 | -118.020200 | NaN | NaN |
7 | LAUT213 | LAUT213 | Hermit Falls | LARWMP | ABC/CWH | 34.191220 | -118.017180 | NaN | NaN |
8 | LALT214 | LALT214 | Hansen Dam | LARWMP | ABC/CWH | 34.266550 | -118.375820 | NaN | NaN |
9 | LALT218 | HTB2 | Glendale Narrows | Heal the Bay | ABC/CWH | 34.108199 | -118.252743 | NaN | Kayak area |
10 | LALT219 | HTB3 | Glendale Narrows | Heal the Bay | ABC/CWH | 34.086640 | -118.228129 | NaN | Kayak area |
11 | LALT215 | LATT612 | LA River Sepulveda Basin | City of Los Angeles, EMD | CLA | 34.179424 | -118.500126 | I (DCT NPDES Permit); LALT 105 (LARWMP) | Kayak area; Samples may be collected on differ... |
12 | LALT216 | LATT622 | LA River Sepulveda Basin | City of Los Angeles, EMD | CLA | 34.176161 | -118.491478 | D (DCT NPDES Permit) | Kayak area; Samples may be collected on differ... |
13 | LALT217 | LATT628 | LA River Sepulveda Dam | City of Los Angeles, EMD | CLA | 34.167636 | -118.474373 | R-6/W-E (DCT NPDES Permit) | Kayak area; Samples may be collected on differ... |