Difference between revisions of "ISS608 2017-18 T1 Assign KyonghwanKim Data Preparation"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 47: Line 47:
 
*Also, Location column is splitted to Latitude and Longitude columns. These data is used to plot in Vastropolis map.
 
*Also, Location column is splitted to Latitude and Longitude columns. These data is used to plot in Vastropolis map.
 
|[[file:microblog_split.png]]
 
|[[file:microblog_split.png]]
 +
|-
 +
|'''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.
 +
|[[file:missing_time.png]][[file:outlier_Longitude.png]]
 
|-
 
|-
 
|}
 
|}

Revision as of 03:16, 15 October 2017

Title.png

Vastropolis Epidemic Report

Background

Data Preparation

Visualization

Answer

Reference

Feedback

 



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.
Microblog split.png
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.
Missing time.pngOutlier Longitude.png