We wanted to provide an easy and fast way to be informed about the current state of the pandemic in the United States.
What it does
We've created a Twitter account that automatically posts COVID-19 stats in the US daily. Each day it tweets out the total cases and deaths due to the virus, as well as the daily cases and deaths. The numbers are from the official CDC website. The twitter account is @Coronav53389711.
How we built it
All the automation is done using UiPath's StudioX.
- 1. goes to CDC website to extract data(total cases, total deaths, daily cases, daily deaths)
- 2. creates CSV file
- 3. opens notepad++ and runs macro to change formatting of the gotten data, then copies it to clipboard
- 4. opens twitter and pastes the data into text box, then sends the tweet
Challenges we ran into
Originally we wanted to create a website and an Alexa Skill, but there were too many roadblocks to complete it in time. Plus, if someone was willing to visit a website, they might as well visit the CDC site. So the idea was to have the information simple and easily accessible through Twitter.
Accomplishments that we're proud of
Having an end product to show.
What we learned
Learned how to use UiPath's StudioX, as well as some Alexa Skill knowledge from the research at the beginning.