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

Revision as of 23:32, 15 March 2020

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

Screenshot	Steps
	Data Preparation: Hiding Hide column NA1-NA26 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 Go to sheets Drag Position from measures to dimensions Right click and create Group

@@ Line 36: / Line 36: @@
 |-
 !<center>'''Screenshot'''</center>
-!<center>'''Steps Taken'''</center>
+!<center>'''Steps'''</center>
 |-
 |<center>
@@ Line 57: / Line 57: @@
 |<center>
-[[File:Clean2.png|600px]]
+[[File:Clean3.png|600px]]
 <center>
 |
-'''Data Preparation: Pivot'''<br>
+'''Data Preparation: Group'''<br>
-*Select columns from I01-I26 & P01-P27<br>
+*Go to sheets
+*Drag Position from measures to dimensions
-*Right click and pivot<br>
+*Right click and create Group<br>
 |-