This project aims to arouse public awareness of COVID-19 prevention and control. We hope to find out the similarities and differences between COVID-19 and other infectious diseases, so as to further understand COVID-19.
When I saw covid-19 starting to spread in Washington state in February, I am worried every day about the new coronavirus outbreak and the lack of awareness of protection in the United States.
As a Chinese, I know what has happened in China in January and February. China is recovring right in March but it paid huge. I know the reason of China's recovering was that the whole country was on high alert and everyone attached great importance to epidemic prevention.
But it is happening again. The United States in March, like China at the start of the outbreak, is not taking it seriously. People didn't realize the seriousness until the death rate rose. I don’t want the people to suffered again.I hope to pass on the severity of the new coronavirus and help people live safely during the outbreak.
So I started this data research project on COVID-19. Through data visualization, people's awareness of self-protection is aroused, and they hope to find more directions for the solution of covid-19 from previous outbreak cases.
- Python 2.7/3.7
- Visual Stiduo Code
- Tableau
Due to the ongoing outbreak of novel coronavirus pneumonia. JHU CSSE updates the latest data of the day on a daily basis. I wrote a code in Python to walk through all the data files in the folder and organize them into a complete data set.
With the daily update of JHU CSSE, my total data volume is increasing day by day. The latitude, longitude and country/state data contained in this data can be used in geographic charts, and time-lines accurate to the hour can provide research on trends and future predictions. I found reliable historical data on SARS and Ebola on Kaggle. Since they are no longer updated, I only preprocessed them, and unified the columns type with COVID-19 data. They were also uploaded to the Google Spreadsheet just like the COVID-19 data.
Because of the data format of the daily report, even error types are difficult to unify. I tried using pandas to collate the content and the NLP model to fetch the data I needed. But this part is still being perfected. # Inspiration for Web Design I want the homepage to be as eye-catching as possible. Then, with the introduction of striking visual effects, the severity of covid-19 was conveyed by embedding relevant literature, news, videos and charts. In terms of the interaction method, I hope to have a certain dynamic effect, so that the whole aesthetic effect is lively.