This is a log of all work done on the project. Note: see the commit history for a more detailed and rigorous overview of progress on the project!
| Date | Hours | People | Comments |
|---|---|---|---|
| 25/09/23 | 1.5 | Ryan Moore, Will Durkin | Meeting to discuss project ideas, decided on music analysis, next step is to find datasets |
| 27/09/23 | 1 | Ryan Moore | Research on possible datasets, couln't find charts data but found genius and spotify APIs |
| 03/10/23 | 1.5 | Ryan Moore | Set up GitHub repository and source control workflow |
| 04/10/23 | 2.5 | Ryan Moore, Will Durkin | Meeting to discuss datasets and use of Source Control, helping Will get Jupyter set up |
| 06/10/23 | 2 | Ryan Moore | Got Billboard data into R dataframe format using a Python package called billboard.py |
| 07/10/23 | 1.5 | Ryan Moore | Started working on Spotify API |
| 08/10/23 | 1 | Zheyu Li | Found the dataset of RYM(Top albums of all time) |
| 10/10/23 | 2 | Ryan Moore, Zheyu Li | First meeting with Zheyu to get him up to date on the project. Will work on RYM dataset |
| 10/10/23 | 3 | Will Durkin | Working on Genius API |
| 10/10/23 | 4 | Zheyu Li | Obtained RYM dataset and converted it into a tabular format within an R DataFrame |
| 10/10/23 | 1 | Ryan Moore | Added album-sales.ibynb for downloading historical album sales data |
| 11/10/23 | 2 | Zheyu Li | Update the code and try to find relationship bewteen the data and plot it |
| 11/10/23 | 2.5 | Ryan Moore | Created notebook to interface with Spotify API |
| 11/10/23 | 2 | Will Durkin | Creating Genius data frame |
| 12/10/23 | 3 | Will Durkin | Debugging and research - lyrics are unavailable from Genius API as of 2021 |
| 12/10/23 | 3 | Zheyu Li | Modify the code for scrape all the data on the RYM website. |
| 13/10/23 | 2 | Will Durkin | Finding ways to approach the evolution of most popular genres in various decades |
| 13/10/23 | 5 | Zheyu Li | Scraping 5000 datas in RYM (125 pages) |
| 14/10/23 | 2.5 | Ryan Moore | Relating top 20 albums to Spotify API data |
| 14/10/23 | 2 | Will Durkin | Combining Genius and Billboard datasets |
| 14/10/23 | 4 | Zheyu Li | Ploting some graphs |
| 14/10/23 | 2 | Zheyu Li | Thinking about the relationship between each data and ploting a graph that matches it. |
| 14/10/23 | 4 | Zheyu Li | Ploting some graphs |
| 15/10/23 | 2 | Zheyu Li | Doing ppt |
| 15/10/23 | 5 | Will Durkin | Working on Red Hot Chili Peppers music |
| 16/10/23 | 1 | Ryan Moore | Function for scraping individual rating of a given album using RYM |
| 16/10/23 | 4 | Ryan Moore, Will Durkin, Zheyu Li | Working on presentation |
| 16/10/23 | 2.5 | Ryan Moore | Project.ipynb cleanup, getting ready for final submission |
| 22/10/23 | 4 | Zheyu Li | Writing report,doing data cleaning and collection about RYM part and analyzing graphs |
| 26/10/23 | 6 | Will Durkin | Report writing / conclusion / notebook update |
| 27/10/23 | 6 | Will Durkin | Data compiling, converting data to rds files and debugging |
| 27/10/23 | 1.5 | Ryan Moore | Try to fix some remaining code issues |
| 27/10/23 | 1 | Ryan Moore | Convert report to .md, reorder notebook slightly |
| 27/10/23 | 3 | Ryan Moore | Rewrite report, add comments to notebook, fix graph titles |
| 27/10/23 | 0.5 | Ryan Moore | Finalize repo |