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
|
|
|
|
|
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".