Difference between revisions of "Wyz-Visualization & Insights"
(2 intermediate revisions by the same user not shown) | |||
Line 94: | Line 94: | ||
</table> | </table> | ||
− | === | + | ===Windborne === |
+ | In this part, we investigated whether the wind might also be a factor in the spread of infectious disease. | ||
<table border='1'> | <table border='1'> | ||
<tr> | <tr> | ||
Line 109: | Line 110: | ||
===Waterborne=== | ===Waterborne=== | ||
+ | Through the discoveries of investigation, we deem that the reports about gastrointestinal problems should be distinguished from respiratory infections cases. We suspected that the health problems due to water contamination caused by a truck accident happened on May 17th 12 pm near the interaction between road 610 and the Vast river. | ||
<table border='1'> | <table border='1'> | ||
<tr> | <tr> | ||
Line 148: | Line 150: | ||
<td><b> Sample messages including word "truck accident" and "610" </b> | <td><b> Sample messages including word "truck accident" and "610" </b> | ||
<br> Then we continued to explore messages containing truck accident and inferred that pollutant carried by the truck was poured into the river where drinking water of residence nearby comes from. | <br> Then we continued to explore messages containing truck accident and inferred that pollutant carried by the truck was poured into the river where drinking water of residence nearby comes from. | ||
+ | </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | <br> | ||
+ | ==Trend of outbreak == | ||
+ | Is the outbreak contained? Is it necessary for emergency management personnel to deploy treatment resources outside the affected area? Explain your reasoning. | ||
+ | <table border='1'> | ||
+ | <tr> | ||
+ | <th>Visualization</th> | ||
+ | <th>Insights</th> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>[[File:Wyz-newcases.png|800px|center]]</td> | ||
+ | <td><b> Number of new cases by symptom, May 17th-May 20th </b> | ||
+ | <br>The line chart shows that the new flu-related cases appeared on each day from 17th to 20th. The number of new cases are actually the number of ID that never showed in the previous dates. From the chart, it is obvious that the flu cases on 18th May reached the peak while GI case meets its highest number on 19th. However, after 18th and 19th, there are declining trends on both symptoms and total new cases are decreasing, which indicates a controllable trend in general. Since the date factor in dataset is limited, more data is needed to evaluate the condition accurately. | ||
+ | </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>[[File:Wyz-20hospital.png|800px|center]]</td> | ||
+ | <td><b> Map of flu-related microblog messages by symptom, May 20th </b> | ||
+ | <br>The points on the map show all the flu-related text messages on 20th. The red cross marks are the location of hospitals where some sick people gathered. However, most of the people with flu symptom are still at home or at work. Since the flu is infectious and the scale of it is relatively large, the government should encourage citizens to see doctors as soon as possible and arrange more medical resources. | ||
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </table> |
Latest revision as of 18:05, 15 October 2017
|
|
|
|
Visualization & Insights
Contents
Origin and Epidemic Spread
Identify approximately where the outbreak started on the map (ground zero location). Outline the affected area. Explain how you arrived at your conclusion.
After a quick browse around the dataset, we can find that the content of over 1M microblog messages contains all aspects of life. So first, we start by extracting flu-related microblog messages. A list of keywords was selected to filter raw data. The list consists of keywords including flu, chill, fever, sweat, ache, pain, fatigue, cough, breath, nausea, vomit, diarrhea, and lymph, which are from observed symptoms and human judgement. After filtering, there are 71939 flu-related microblog messages left.
Visualization | Insights |
---|---|
Infer the disease outbreak date
|
|
Map of flu-related microblog messages on May 17
|
|
Map of flu-related microblog messages on May 18
|
|
Map of flu-related microblog messages on May 17
|
|
Magnification of ground zero location, May 18
|
Epidemic Spread
Mode of transmission
Present a hypothesis on how the infection is being transmitted. For example, is the method of transmission person-to-person, airborne, waterborne, or something else? Identify the trends that support your hypothesis.
Person-to-person
Considering that most of the flu is spread by person-to-person, we will focus on this route of transmission first.
Visualization | Insights |
---|---|
Number of flu-related microblog messages breakdown by hour, May 18 2011
|
|
Map of flu-related microblog messages by work status
|
Windborne
In this part, we investigated whether the wind might also be a factor in the spread of infectious disease.
Visualization | Insights |
---|---|
Changes in human traffic during the day and night
|
Waterborne
Through the discoveries of investigation, we deem that the reports about gastrointestinal problems should be distinguished from respiratory infections cases. We suspected that the health problems due to water contamination caused by a truck accident happened on May 17th 12 pm near the interaction between road 610 and the Vast river.
Visualization | Insights |
---|---|
Number of flu-related microblog messages breakdown by symptom, May 17th-20th
|
|
Wordcloud by term frequency
|
|
Sample messages including word "diarrhea"
|
|
Map of flu-related microblog messages by symptom, May 19th-20th
|
|
Word Frequency table of messages containing "610"
|
|
Sample messages including word "truck accident" and "610"
|
Trend of outbreak
Is the outbreak contained? Is it necessary for emergency management personnel to deploy treatment resources outside the affected area? Explain your reasoning.
Visualization | Insights |
---|---|
Number of new cases by symptom, May 17th-May 20th
|
|
Map of flu-related microblog messages by symptom, May 20th
|