Week 1: Data Selection

Hello everyone! Since I was out on a trip on Monday and Tuesday, I began working five hours each day from Wednesday to Friday to fulfill my requirement of 15 hours per week. My week 1 goal was to Select two lakes, the focus will be on collecting data through the California Open Data Portal on temperature, dissolved oxygen, pH, and ORP, which will be structured in a database.

On Wednesday, I started working on my senior project by setting up the environment in Python, which included downloading Anaconda and Visual Studio Code (VSCode). This setup will provide me with a designated space and file to process data analysis and visualization for my selected lakes. Additionally, I worked on configuring my GitHub to link with my VSCode. This allowed me to save all progress coding and files I performed locally onto the web. I also spend some time researching how to perform data visualization on Model Goodness of Fit. ,Model Goodness of Fit determines whether the observed values match with the expected data model. This helps later on in my research to gain a better understanding of which specific data parameters I should select.

On Thursday, I continued my research on data visualization focusing on Model Goodness of Fit. I also begin to work on my weekly goals on selecting two lakes focusing on various types of data parameters. To begin this, I set up a local database using DB Browser to store all the specific parameters. This gives me an advantage because even if I miss a column of data, it won’t result in an error during data analysis. So I have to transfer all the data qualities from a CSV file into my local database. I chose Lake Elizabeth, which is just a few minutes away from my school, and Lake Murray in San Diego for my research on an open database website called Hillsborough County Water Atlas to download water quality data, including temperature, dissolved oxygen, pH, and ORP. Currently, I am facing a problem with transferring data into my local database in DB Browser.

On Friday, I started drafting my blog and continued to fix the problem of transferring data into my local database in DB Browser.