Difference between revisions of "IS428 AY2019-20T1 Assign Chua Xuan Ni, Rachel DATA TRANSFORMATION"
Jump to navigation
Jump to search
Line 30: | Line 30: | ||
== Dataset Analysis & Transformation Process == | == Dataset Analysis & Transformation Process == | ||
− | + | {| class="wikitable" | |
− | + | |- | |
− | In the current dataset, “mc1-reports-data.csv”. The different categories of damage are a column by itself, making it difficult to compare the damage by the categories. | + | ! Issue !! Solution !! Resolution |
− | + | |- | |
− | + | | In the current dataset, “mc1-reports-data.csv”. The different categories of damage are a column by itself, making it difficult to compare the damage by the categories. || Pivot the different categories of damage – sewer_and_water, power, roads_and_bridges, medical and buildings into a new column, “Damage Area”, with their respective damage level in a new column, “Damage Level (0-10)”. || To do this, I used Tableau Prep’s “Pivot function” to make the changes. After applying the pivot function, you can see that I now have 2 new columns containing the data from sewer_and_water, power, roads_and_bridges, medical and buildings merged as one. | |
− | + | |- | |
− | To do this, I used Tableau Prep’s “Pivot function” to make the changes. After applying the pivot function, you can see that I now have 2 new columns containing the data from sewer_and_water, power, roads_and_bridges, medical and buildings merged as one. | + | | Example || Example || Example |
+ | |- | ||
+ | | Example || Example || Example | ||
+ | |- | ||
+ | | Example || Example || Example | ||
+ | |- | ||
+ | | Example || Example || Example | ||
+ | |} | ||
== Dataset Import Structure & Process == | == Dataset Import Structure & Process == |
Revision as of 19:18, 11 October 2019
|
|
|
|
|
Dataset Analysis & Transformation Process
Issue | Solution | Resolution |
---|---|---|
In the current dataset, “mc1-reports-data.csv”. The different categories of damage are a column by itself, making it difficult to compare the damage by the categories. | Pivot the different categories of damage – sewer_and_water, power, roads_and_bridges, medical and buildings into a new column, “Damage Area”, with their respective damage level in a new column, “Damage Level (0-10)”. | To do this, I used Tableau Prep’s “Pivot function” to make the changes. After applying the pivot function, you can see that I now have 2 new columns containing the data from sewer_and_water, power, roads_and_bridges, medical and buildings merged as one. |
Example | Example | Example |
Example | Example | Example |
Example | Example | Example |
Example | Example | Example |