I would have had class today (12/10), but I was on a field trip for one of my other classes. That said, the Weekly Report was not forgotten! Yesterday, I put in a couple hours and fixed Task III (the daily task) to adapt to the new objectives. Now, I need to fix Task IV (the weekly task) to aggregate the updated daily values.
Additionally, I got a grade for my final Coursera assignment, so I received my Course Certificate! Today, we had a short class. I continued work on implementing the new feature (max and min CO2) into the cleaned-up file. Deciding when to merge, and which functions should be aggregated at which times, took quite a bit of logical reasoning. However, I feel I made good progress.
Yesterday, I worked on the Weekly Report, since I had finished Coursera. Looking at my code for task three (daily aggregation), I realized that due to the amount of time and debugging strategies needed to get it working, the code used a lot of unnecessary data frames. In order to resolve this, I drew out a diagram of which tables depended on which. Then, I wrote out another file (task_three_cleanup) in order to whittle it down to the necessary bits, making it cleaner and more understandable. Additionally, I began working on an additional feature that was requested by the facility -- adding in the maximum and minimum CO2 values and the times at which those values occurred.
Andover schools had a very long Thanksgiving break due to snow days! I used this opportunity to work a lot on both Coursera and the mailing list for the weekly report. When I began to update the weekly report, I realized that I had made a mistake - when the server was updated a few days ago, I had forgotten to save the crontab somewhere else! Therefore, I had to rewrite the crontab in class today. Additionally, I worked on deploying and testing the SMTP mail server in order to send the weekly report to the mailing list. Finally, since I had basically finished the Coursera project over the weekend, I made final retouches and submitted it in H-Block.
On Wednesday, due to the half-day, we had a pretty short class. I was able to get through the lectures for week four (because there are only a few), which dealt with a library called seaborn as well as using pandas in conjunction with matplotlib's features. Over the weekend, I intend to both complete the optional practice assignment for Week 3 and get a head-start on the final assignment for Week 4 (the last week of the course!). On completion of the course, I will then focus on tying up the loose ends with the Weekly Report.
Today, I split my time again between Coursera and work on the weekly report. Over the weekend, I had worked a lot on the project, which had four different levels of difficulty (these were just so that we would have options on how much to push ourselves -- not for additional grades or benefits). I had figured out the second hardest level, so after refining and polishing my project, I switched focus to learning how to send e-mails using Python scripts. I drew up a quick script using this tutorial. In the future, I'll need to deploy and test this on the server, as well as start week 4 of the Coursera course!
On Friday, I worked on the data visualizations course. I finished the lecture videos and began working on the project, which commenced with a reading. This was a study on making graphs easier to read when they have margins of error, a topic which is also the focus of the Week 3 project.
Since I had worked a lot at home on the weekly report yesterday, I decided to focus on Coursera today, getting through all but two of the week's videos. The videos covered topics like histograms, box plots, and heatmaps. I'm excited to apply these more advanced visualization techniques to both the weekly projects and to my work with Energize!
Today, having finished Weeks 1 and 2, I started Week 3 of Coursera and watched a video about subplots. Additionally, I continued my work with the weekly report for the latter half of the class. At home, I finished debugging the date/time functionality, testing the new strategy on example data. As of now, the functionality seems to be fixed!
Yesterday, I again tried to split my time between debugging the Weekly Report and Coursera.
This time, however, I got pretty far ahead with Coursera. As of now, I'm really close to having all the data cleaned and ready to be plotted. As for the weekly report, I was able to implement the different timestamp format in my free time, but the current issue is that SQL won't accept the new format. The solution for this problem is in progress. |
AuthorI'm a high school senior and programming enthusiast. Archives
March 2022
Categories |