View source for Visualizing Electricity Consumption in Singapore: Data Preparation

=Initial Data Set=
<br/>

=Data Cleaning=
<b>Public Housing Data</b><br/>
Step 1: Go to Tables > Stack
[[File: publichousingdc1.jpg|400px|center]]
Step 2: Select the following columns, check “Stack by rows” and “Eliminate missing rows”
[[File: publichousingdc2.jpg|400px|center]]
Step 3: Filter out and delete rows with missing values
[[File: publichousingdc3.jpg|400px|center]]
Step 4: Create “Month” Column
[[File: publichousingdc4.jpg|400px|center]]
Step 5: Fill month till the end of table
[[File: publichousingdc5.jpg|400px|center]]
Step 6: Final Output 
[[File: publichousingdc6.jpg|400px|center]]
Step 7: Repeat the following process for all the month’s data 
Step 8: Go to table > Concatenate > Select all the months
[[File: publichousingdc8.jpg|400px|center]]
Step 9: By the end of the data cleaning, we have a total of 177,053 rows
Step 10: Merging Private Housing Data with Public Housing Data
[[File: publichousingdc10.jpg|400px|center]]
[[File: publichousingdc10_2.jpg|400px|center]]
Final consolidated data consist of 241,766 rows 
[[File: publichousingdc11.jpg|400px|center]] <br/>

<br/>