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

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 47: Line 47:
 
|-
 
|-
 
|<center>
 
|<center>
−
[[File:clean2.png|600px]
+
[[File:Clean2.png|600px]]
 
<center>
 
<center>
 
|
 
|

Revision as of 23:24, 15 March 2020


Overview

 

Data Cleaning

 

Undergraduate

 

Postgraduate

 

Faculty

 

Staff



Data preparation

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


Screenshot
Steps

Clean1.png

Data Preparation: Hide Unused columns

  • Hide NA columns and comment by right clicking and select hide

Clean2.png

Data Preparation: Pivot

  • Select columns from I01-I26 & P01-P27
  • Right click and pivot
Retrieved from ‘https://wiki.smu.edu.sg/1920t2is428/index.php?title=IS428_AY2019-20T2_Assign_YIP_JIAN_MING_DataCleaning&oldid=3983’