Lw-questions
Presented by: HUANG Liwei (liwei.huang.2016@mitb.smu.edu.sg)
Visualization tool: Tableau
Contents
Overall Findings
Interactive Report
Questions and Answers
Question 1
Characterize the sensors’ performance and operation. Are they all working properly at all times? Can you detect any unexpected behaviors of the sensors through analyzing the readings they capture? Limit your response to no more than 9 images and 1000 words.
- Record gaps
The sensors may not working properly at all times as there are some missing records for particular sensors/chemicals/time periods, which implies that there might be some issue happening during those time points. For instance, the graph below shows the daily reading records of monitor 4 for chemical Methylosmolene in April 2016, revealing several record gaps on day 12th ,17th and 22nd.
- Descrepant data counts
Theoretically, each sensor should have reading records in every hour within the monitored month, if we group the records by the hour of day, the count of records in each hour should be the same as the number of days in that month. For example, there are 30 days in April, the count of records by hour of day in April should be 30 as well.
In the graph below, we set 30 as the benchmark of record count, if the count is less than 30, there will be represent as a dipped red bar; if the count is more than 30, there will be a spiked green bar instead.
The finding is that for chemical AGOC-3A and Methylosmolene, sensors 3-9 all show some inversion change of counts, which means in some time points, the sensor would likley have additional readings for AGOC-3A and corresponding reading outages for Methylosmolene, which also proves that the sensor may have some issues during the operation such as confounding the chemicals occasionally.
- Anomalous Reading Spikes
There are also some instant spikes existing in reading records that are likely abnormal operation of the sensors. In the graph below, sensor 2 showed relatively small scale of readings across April 2016 except 17th 3am. Since we believe that the chemical generation from factory would likely last for a while, it is reasonable that such reading could be a false message.
Question 2
Now turn your attention to the chemicals themselves. Which chemicals are being detected by the sensor group? What patterns of chemical releases do you see, as being reported in the data? Limit your response to no more than 6 images and 500 words.
- Monthly trend
Some of the chemicals may have a significant increasing in releases as the daily average readings through the days have formed a obvious gradiant from April to December. The two graphs below indicate that the releases of chemical Appluimonia and Chlorodinine are in the trend of growing from April to December.
![Calendar-Days1.png](/1617t3isss608g1/img_auth.php/thumb/1/11/Calendar-Days1.png/500px-Calendar-Days1.png)
![Calendar-Days2.png](/1617t3isss608g1/img_auth.php/thumb/f/fd/Calendar-Days2.png/500px-Calendar-Days2.png)
- Daily trend
The releases of chemicals may also have some patterns in a day. The graphs use the monthly average readings of each chemical as benchmark, then present the percentage of deviation from the benchmark in every hour of the day (average readings). It is evident that chemical AGOC-3A is likely to be released from 6am to 9pm everyday as the readings are much higher beyond the average in that period, on the contrary, chemical Methylosmolene might be released during the late night 10pm to 5am.
![Lw-Calendar-Hours.png](/1617t3isss608g1/img_auth.php/thumb/0/00/Lw-Calendar-Hours.png/500px-Lw-Calendar-Hours.png)
![Lw-Calendar-Hours2.png](/1617t3isss608g1/img_auth.php/thumb/7/7d/Lw-Calendar-Hours2.png/500px-Lw-Calendar-Hours2.png)
Question 3
Which factories are responsible for which chemical releases? Carefully describe how you determined this using all the data you have available. For the factories you identified, describe any observed patterns of operation revealed in the data. Limit your response to no more than 8 images and 1000 words.
![Lw-Map.png](/1617t3isss608g1/img_auth.php/thumb/f/f1/Lw-Map.png/500px-Lw-Map.png)
![Lw-Map2.png](/1617t3isss608g1/img_auth.php/thumb/1/1c/Lw-Map2.png/500px-Lw-Map2.png)