Revision as of 03:21, 15 October 2017

Vastropolis Epidemic Report

Microblog

Description	Illustration
1. Split of Columns Created_at column is splitted to Date and Time columns. Date column is used in other analytics. Also, Location column is splitted to Latitude and Longitude columns. These data is used to plot in Vastropolis map.
2. Outliers There are 21 items with invalid time format. They are removed from analysis. Also, there are 6 items with Longitude outside of given map range. They are removed as well so that all data are within parameters. Total 27 rows are removed and 1,023,050 rows are used for analysis.

@@ Line 37: / Line 37: @@
 =Microblog=
+==1. Data cleaning==
 {| class="wikitable"
@@ Line 50: / Line 51: @@
 |'''2. Outliers'''<br/>
 *There are 21 items with invalid time format. They are removed from analysis.<br/>
 *Also, there are 6 items with Longitude outside of given map range. They are removed as well so that all data are within parameters.
+*Total 27 rows are removed and 1,023,050 rows are used for analysis.
 |[[file:missing_time.png]][[file:outlier_Longitude.png]]
 |-
 |}