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

Revision as of 23:31, 15 March 2020

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

Screenshot	Steps Taken
	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: Pivot Select columns from I01-I26 & P01-P27 Right click and pivot

@@ Line 32: / Line 32: @@
 Data Cleaning & Preparation
 File: Raw data 2018-03-07 SMU LCS data file – KLG.xls
 {| class="wikitable"
 |-
 !<center>'''Screenshot'''</center>
-!<center>'''Steps'''</center>
+!<center>'''Steps Taken'''</center>
 |-
 |<center>
-[[File:clean1.png|600px]]
+[[File:Ss1.png|frameless|600px]]
 <center>
 |
-'''Data Preparation: Hide Unused columns'''<br>
+'''Data Preparation: Hiding'''<br>
-*Hide NA columns and comment by right clicking and select hide
+*Hide column NA1-NA26 and comment by right clicking and select hide
+|-
+|<center>
+[[File:Clean2.png|600px]]
+<center>
+|
+'''Data Preparation: Pivot'''<br>
+*Select columns from I01-I26 & P01-P27<br>
+*Right click and pivot<br>
+|-
+|<center>
 [[File:Clean2.png|600px]]
 <center>
@@ Line 53: / Line 64: @@
 *Right click and pivot<br>
+|-