From Visual Analytics and Applications
Jump to navigation
Jump to search
ISSS608 Assignment MU FUYAO - MC2
Data Preparation
Tools
1.JMP
Problems |
Solutions |
1.Missing value and repetitive value
There are some measures having value of 0, I can’t decide whether the measurement is 0 or didn’t have measure. So, I regard it as missing value and delete.
There are some strange values in this dataset. For same location, same time and same measure, but there are different values. I think it’s repetitive value. So, I get average of them.
|
|
2.Wrong format of years
In JMP, it can’t recognize year before 2000. So, for year 1998 and 1999 it will show 2098 and 2099, I have to recode it by myself.
|
|
2.Tableau
Method |
Graph |
1.Combine different tables
I use three different excel (csv) table in tableau, first I should combine them together then I can use them to draw graph
|
|
2.Make a map for location
If I want to make sure of location for different cities, I have to do telltale mark. And connect it with other tables. Then I can find exactly location for these 10 cities.
|
|