Difference between revisions of "DataPreparation"
Jump to navigation
Jump to search
Ziwenhe.2016 (talk | contribs) |
Ziwenhe.2016 (talk | contribs) |
||
| Line 29: | Line 29: | ||
=Data Preparation= | =Data Preparation= | ||
| − | |||
==Transforming data== | ==Transforming data== | ||
| − | + | [[Image:ZW JMP1.JPG|thumb|300px|right|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". | |
| + | <gallery heights="160" widths="700"> | ||
| + | File:ZW JMP1.JPG|Figure : Dirty Data Columns | ||
| + | </gallery> | ||
==Key Words Selection== | ==Key Words Selection== | ||
| Line 47: | Line 49: | ||
==Visualing Data in Tableau== | ==Visualing Data in Tableau== | ||
| − | |||
| − | |||
| − | |||
=Recommedations= | =Recommedations= | ||
Revision as of 00:06, 15 October 2017
ISSS608 Visual Analytics and Applications Assignment
|
|
|
|
|
|
Contents
Data Preparation
Transforming data
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
