DataPreparation

ISSS608 Visual Analytics and Applications Assignment

Background

Outbreak&Affected_Areas

Transmission

EmergencyControl

DataPreparation

Data Preparation

Transforming data

Figure 13: JMP Pro screen capture of Location Field and formulae used to derive Latitude and Longitude.

After imported the original dataset into JMP, found that two columns are dirty data which need to be cleaned. Splitting the column "Created_at" into two columns, one is "Date" and the other one is "Time". With the same method split the column "location" into "latitude" and "longitude".

• 

  Figure : Dirty Data Columns