Visualizing California Water Quality With Python
Interactive Dissolved Oxygen Level Chart using Publically Available Data
Source Data
California Open Data Portal provides water quality data available here. This contains data ranging from 1968 to 2022 and has results for parameters such as dissolved oxygen and chemical levels. In this example, I will be looking at the Dissolved Oxygen Levels in California.
Figure
The graphic below shows the monthly Dissolved Oxygen Level for each station. The stations within each county will share the same shape but have a different color.
Notes
- Hovering over a point will show additional information for the point
- Clicking on a station in the legend will highlight points from that station
- Viewing in landscape mode on mobile devices is advised
Python Modules Used
- Pandas to select a trimmed dataset from the original data
- Altair to create the visualization
- Datapane to host the visualization
Source Code
Source code is available here.