Both the questions are solved in seperate jupyter notebooks.
Plotly makes interactive plots due to which plots aren’t visible when notebooks are viewed through github. Please download the project and then open the notebook.
All the assumptions and reasoning behind the technique are either explained through inline comments or a seperate section right next to the code.
Many techniques have been tried w.r.t. both the questions. Only the best technique that felt sensible has been presented.
Make sure that the spreadsheet is in correct path before running the code. ```