Explore CRWA's Access database
de-la-viz opened this issue · 7 comments
Document the process and the findings in a notebook, so that new members can quickly grasp and understand the data. Unfortunately, there is no data dictionary...
Every (new) member is free to continue the exploration and build on the notebook(s) already produced.
Save notebooks there: https://github.com/codeforboston/safe-water/tree/master/projects/crwa/notebooks
Sub-tasks, explore and plot :
- Trends in water temperature and precipitation
- Heat maps of water temperature and precipitation
Resources: MassGIS , OLIVER
Aim: build knowledge, a prerequisite in order to later connect with CRWA’s Climate Compact group, tackle more complex questions and add climate projections to the data.
The data is there:
https://github.com/codeforboston/safe-water/tree/master/projects/crwa/data
the Access has been updated as .csv too:
https://github.com/codeforboston/safe-water/tree/master/projects/crwa/data/charles_river_samples_csv
you can be inspired by this notebook that is already merging the tables:
https://github.com/codeforboston/safe-water/blob/master/projects/crwa/notebooks/njin-eda.ipynb
New notebook by Lewis, exploring water temperature time trends: https://github.com/codeforboston/safe-water/blob/master/projects/crwa/notebooks/lstaples-eda.ipynb
The list and explanation of testing parameters:
https://www.crwa.org/uploads/1/2/6/7/126781580/testing_parameters.pdf
Questions:
- What's the size of the data?
- MB?
- number of rows? - Most important columns?
- Basic overview of data
- ...