Difference between revisions of "IS428 AY2019-20T2 Assign YIP JIAN MING DataCleaning"

Revision as of 23:27, 15 March 2020

Data Cleaning & Preparation File: Raw data 2018-03-07 SMU LCS data file – KLG.xls

Screenshot	Steps
	Data Preparation: Hide Unused columns Hide NA columns and comment by right clicking and select hide	Data Preparation: Pivot Select columns from I01-I26 & P01-P27 Right click and pivot
	Data Preparation: Group Drag position from measures to dimensions Right click and create Group

@@ Line 45: / Line 45: @@
 '''Data Preparation: Hide Unused columns'''<br>
 *Hide NA columns and comment by right clicking and select hide
-|-
-|<center>
 [[File:Clean2.png|600px]]
 <center>
@@ Line 54: / Line 53: @@
 *Right click and pivot<br>
+|-
+|<center>
+[[File:Clean2.png|600px]]
+<center>
+|
+'''Data Preparation: Group'''<br>
+*Drag position from measures to dimensions
+*Right click and create Group<br>
+|-
+|<center>