{"cells":[{"cell_type":"markdown","metadata":{"id":"KSKqpSlqd01O"},"source":["# Analysis of Lake Water Quality Measurements\n","\n","This notebook parses and visualizes water quality data collected by past Environmental Science classes at Lakeshore High School."]},{"cell_type":"markdown","metadata":{"id":"1DZYJ8b8d7Jj"},"source":["## Parse Data\n","\n","We start by parsing the data into Python."]},{"cell_type":"code","execution_count":1,"metadata":{"executionInfo":{"elapsed":2352,"status":"ok","timestamp":1721344590838,"user":{"displayName":"Jill McNabnay","userId":"08402809764172099539"},"user_tz":240},"id":"_b73dSm3dxZQ"},"outputs":[],"source":["# We will use the Pandas library to read the data from the Google Sheet\n","import pandas as pd\n","url = 'https://docs.google.com/spreadsheets/d/1Y_7_AertX2dd86mXmVtc5ju-sbccSAGZYByXZrDT9sw/export?gid=0&format=csv'\n","data = pd.read_csv(url)"]},{"cell_type":"code","execution_count":2,"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":786},"executionInfo":{"elapsed":475,"status":"ok","timestamp":1721344592115,"user":{"displayName":"Jill McNabnay","userId":"08402809764172099539"},"user_tz":240},"id":"cPLTJgw1eQva","outputId":"eaee460c-d0bb-4e93-dc94-137972530816"},"outputs":[{"data":{"text/html":["
\n"," | Year | \n","Lake | \n","Class Hour | \n","Temperature (°C) | \n","Conductivity (μS) | \n","pH | \n","Alkalinity (ppm) | \n","Dissolved Oxygen (ppm) | \n","Copper (mg/L) | \n","Iron (mg/L) | \n","Total Hardness (ppm) | \n","Nitrate (mg/L) | \n","Nitrite (mg/L) | \n","Total Chlorine (ppm) | \n","Phosphate (ppm) | \n","Turbidity (NTUs) | \n","
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n","2020 | \n","Lake Michigan | \n","2nd | \n","19.5 | \n","0.25 | \n","6.5 | \n","80 | \n","4.0 | \n","0.10 | \n","0 | \n","120 | \n","0 | \n","0 | \n","0.1 | \n","0.1 | \n","NaN | \n","
1 | \n","2021 | \n","Lake Michigan | \n","2nd | \n","16.9 | \n","0.32 | \n","7.0 | \n","120 | \n","8.5 | \n","0.10 | \n","0 | \n","180 | \n","0 | \n","0 | \n","0.0 | \n","0.2 | \n","NaN | \n","
2 | \n","2021 | \n","Lake Michigan | \n","3rd | \n","18.0 | \n","0.32 | \n","7.0 | \n","120 | \n","8.5 | \n","0.10 | \n","0 | \n","120 | \n","0 | \n","0 | \n","0.1 | \n","0.2 | \n","NaN | \n","
3 | \n","2022 | \n","Lake Michigan | \n","3rd | \n","22.8 | \n","0.00 | \n","7.5 | \n","120 | \n","8.5 | \n","0.00 | \n","0 | \n","120 | \n","0 | \n","0 | \n","0.1 | \n","NaN | \n","13.0 | \n","
4 | \n","2022 | \n","Lake Michigan | \n","6th | \n","23.9 | \n","0.33 | \n","7.5 | \n","120 | \n","8.5 | \n","0.00 | \n","0 | \n","50 | \n","0 | \n","0 | \n","0.0 | \n","NaN | \n","10.0 | \n","
5 | \n","2023 | \n","Lake Michigan | \n","2nd | \n","21.4 | \n","0.30 | \n","7.0 | \n","240 | \n","7.0 | \n","0.00 | \n","0 | \n","120 | \n","0 | \n","0 | \n","0.3 | \n","0.0 | \n","6.0 | \n","
6 | \n","2023 | \n","Lake Michigan | \n","6th | \n","22.7 | \n","0.27 | \n","7.5 | \n","240 | \n","10.0 | \n","0.00 | \n","0 | \n","120 | \n","0 | \n","0 | \n","0.1 | \n","0.0 | \n","6.0 | \n","
7 | \n","2020 | \n","North Lake | \n","2nd | \n","17.9 | \n","0.50 | \n","6.5 | \n","120 | \n","6.0 | \n","0.10 | \n","0 | \n","120 | \n","0 | \n","0 | \n","0.0 | \n","0.1 | \n","NaN | \n","
8 | \n","2021 | \n","North Lake | \n","2nd | \n","17.6 | \n","0.46 | \n","8.0 | \n","180 | \n","10.0 | \n","0.10 | \n","0 | \n","250 | \n","0 | \n","0 | \n","0.1 | \n","0.2 | \n","NaN | \n","
9 | \n","2021 | \n","North Lake | \n","3rd | \n","19.0 | \n","0.45 | \n","7.5 | \n","180 | \n","10.0 | \n","0.10 | \n","0 | \n","180 | \n","0 | \n","0 | \n","0.1 | \n","0.2 | \n","NaN | \n","
10 | \n","2022 | \n","North Lake | \n","3rd | \n","21.0 | \n","0.40 | \n","7.5 | \n","180 | \n","10.0 | \n","0.05 | \n","0 | \n","180 | \n","0 | \n","0 | \n","0.0 | \n","NaN | \n","24.0 | \n","
11 | \n","2022 | \n","North Lake | \n","6th | \n","22.2 | \n","0.61 | \n","7.5 | \n","180 | \n","10.0 | \n","0.00 | \n","0 | \n","120 | \n","0 | \n","0 | \n","0.0 | \n","NaN | \n","21.0 | \n","
12 | \n","2023 | \n","North Lake | \n","2nd | \n","17.4 | \n","0.55 | \n","7.0 | \n","240 | \n","5.0 | \n","0.00 | \n","0 | \n","250 | \n","0 | \n","0 | \n","0.1 | \n","0.0 | \n","8.0 | \n","
13 | \n","2023 | \n","North Lake | \n","6th | \n","20.8 | \n","0.51 | \n","7.5 | \n","120 | \n","4.5 | \n","0.00 | \n","0 | \n","120 | \n","0 | \n","0 | \n","0.1 | \n","0.0 | \n","8.0 | \n","