IS428 AY2019-20T2 Assign YIP JIAN MING DataCleaning

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search


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’