Difference between revisions of "Kabak: Research Paper Data Preparation"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 80: Line 80:
 
*T8 Ethnicity  
 
*T8 Ethnicity  
 
**378 rows of raw data
 
**378 rows of raw data
 +
|}
 +
<br/>
 +
=Data Cleaning=
 +
{| class="wikitable" style="background-color:#FFFFFF;" width="100%"
 +
|-
 +
! style="font-weight: bold;background: #35383c;color:#FFFFFF;width: 50%;font-family:Trebuchet MS" | METHOD
 +
! style="font-weight: bold;background: #35383c;color:#FFFFFF;font-family:Trebuchet MS" | DESCRIPTION
 +
|-
 +
|
 +
<p>Average Monthly Household Electricity Consumption <br> by Postal Code (Public Housing) & Dwelling Type, 1H & 2H 2015</p>
 +
<p>'''Link (1H)''': https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/23RSU.xls </p>
 +
<p>'''Link (2H)''': https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/25RSU.xls </p>
 +
||
 +
* Average monthly household electricity consumption (kwh)
 +
**By month
 +
**By postal code
 +
**By public housing type
 +
* Total Average household electricity consumption (kwh)
 +
**By postal code
 +
**By public housing type
 +
|-
 +
|
 +
<p>Average Monthly Household Electricity Consumption by Postal Code (Private Apartments), 2015</p>
 +
<p>'''Link''': https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/2RSU.xls  </p>
 +
||
 +
* Average monthly household electricity consumption (kwh)
 +
**By month
 +
**By postal code
 +
* Total Average household electricity consumption (kwh)
 +
**By postal code
 +
|-
 +
|
 +
<p>Basic Demographics Characteristics (2015)</p>
 +
<p>'''Link''': http://www.singstat.gov.sg/docs/default-source/default-document-library/publications/publications_and_papers/GHS/ghs2015/excel/t7-9.xls  </p>
 +
||
 +
* Resident Population by Planning Area/Subzone
 +
**By age group
 +
**By sex
 +
**By ethnicity
 +
**By type of dwelling
 
|}
 
|}
 
<br/>
 
<br/>

Revision as of 11:18, 22 November 2016


OVERVIEW

DATA PREPARATION

ANALYSIS

PROJECT MANAGEMENT


Initial Dataset

DATASET DESCRIPTION DATA USED

Average Monthly Household Electricity Consumption
by Postal Code (Public Housing) & Dwelling Type, 1H & 2H 2015

Link (1H): https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/23RSU.xls

Link (2H): https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/25RSU.xls

  • Average monthly household electricity consumption (kwh)
    • By month
    • By postal code
    • By public housing type
  • Total Average household electricity consumption (kwh)
    • By postal code
    • By public housing type
  • 9379 rows of raw data X 12 sheets = 112,548 rows of raw data

Average Monthly Household Electricity Consumption by Postal Code (Private Apartments), 2015

Link: https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/2RSU.xls

  • Average monthly household electricity consumption (kwh)
    • By month
    • By postal code
  • Total Average household electricity consumption (kwh)
    • By postal code
  • 9911 rows of raw data

Basic Demographics Characteristics (2015)

Link: http://www.singstat.gov.sg/docs/default-source/default-document-library/publications/publications_and_papers/GHS/ghs2015/excel/t7-9.xls

  • Resident Population by Planning Area/Subzone
    • By age group
    • By sex
    • By ethnicity
    • By type of dwelling
  • T7 Age group
    • 378 rows of raw data
  • T8 Ethnicity
    • 378 rows of raw data


Data Cleaning

METHOD DESCRIPTION

Average Monthly Household Electricity Consumption
by Postal Code (Public Housing) & Dwelling Type, 1H & 2H 2015

Link (1H): https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/23RSU.xls

Link (2H): https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/25RSU.xls

  • Average monthly household electricity consumption (kwh)
    • By month
    • By postal code
    • By public housing type
  • Total Average household electricity consumption (kwh)
    • By postal code
    • By public housing type

Average Monthly Household Electricity Consumption by Postal Code (Private Apartments), 2015

Link: https://www.ema.gov.sg/cmsmedia/Publications_and_Statistics/Statistics/2RSU.xls

  • Average monthly household electricity consumption (kwh)
    • By month
    • By postal code
  • Total Average household electricity consumption (kwh)
    • By postal code

Basic Demographics Characteristics (2015)

Link: http://www.singstat.gov.sg/docs/default-source/default-document-library/publications/publications_and_papers/GHS/ghs2015/excel/t7-9.xls

  • Resident Population by Planning Area/Subzone
    • By age group
    • By sex
    • By ethnicity
    • By type of dwelling


Retrieved from ‘https://wiki.smu.edu.sg/1617t1IS428g1/index.php?title=Kabak:_Research_Paper_Data_Preparation&oldid=6761’