Dashboard

[joeflack4]

Overview

@DaveraGabriel would like some kind of dashboard.

Options
a. GitHub pages: (Joe: I imagine a single page that has some tables that show maybe the first 5 rows of each of our CSVs just as an example, with a link to the actual CSV file hosted on GitHub. Or it could be full tables with like 10 rows/page and you can click through different pages. And we can put the visualizations here as well)
b. Excel file: (Joe: This would be easier. Each of our CSVs can be a separate tab in an .xlsx file. Would support clickable URLs and color/text formatting.)
c. Any other way?

@DaveraGabriel can you let us know your preference and flesh out here what you want a bit more?

Additional information

a. If Excel

There's a python package called xlrd I'm familiar w/ that can help with this.

b. If GitHub pages

A full web application would be the nicest, but it is a heavy lift for Rohan to do by himself. What's more, my favorite platform, Heroku, which I often used to host free apps like this, is no longer free.

For visualizations, I think having interactive JavaScript based (i.e. plotly) is the nicest, but I don't think we have time for that. We've already got a way to make visualizations, so we can just attach those images.

One nice feature would be to click a button and have the script re-run, but doing this increases the complexity of the work / time required a lot more. I imagine this involving another GitHub action to build the GitHub page.Then, could have the button call the GitHub API and have it run our action. However, it's not realistic that we could have it reload the data/page when the action is done. I think we'd have to have the user manually refresh the page after like 2-5 minutes.