Difference between revisions of "IS428 AY2019-20T2 Assign TIAN. MINGZE"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
== Data preparation == | == Data preparation == | ||
| − | <p>We are given 2 datasets, Raw data 2018-03-07 and SMU Library Survey Comments. Unfortunately, these two given datasets are not well structured and cannot be directly used. So, I will mainly focus on data cleaning and preparation in this section.</p> | + | <p>We are given 2 datasets, Raw data 2018-03-07 and SMU Library Survey Comments. Unfortunately, these two given datasets are not well structured and cannot be directly used. So, I will mainly focus on data cleaning and data preparation in this section.</p> |
| + | |||
| + | '''Raw data 2018-03-07 SMU LCS data file''' | ||
| + | <p>There are two worksheets in this raw data. The first worksheet record all response data from all participants. The second worksheet contains all the column name (legend) | ||
| + | for the first worksheet.</p> | ||
| + | [[File:Mz3.jpg|thumb|900px|center]] | ||
| + | |||
| + | |||
| + | |||
| − | |||
== Dashboard == | == Dashboard == | ||
Revision as of 16:22, 8 March 2020
Contents
Overview
Data preparation
We are given 2 datasets, Raw data 2018-03-07 and SMU Library Survey Comments. Unfortunately, these two given datasets are not well structured and cannot be directly used. So, I will mainly focus on data cleaning and data preparation in this section.
Raw data 2018-03-07 SMU LCS data file
There are two worksheets in this raw data. The first worksheet record all response data from all participants. The second worksheet contains all the column name (legend) for the first worksheet.
