Uncovering Market-Insights for Charles & Keith: About Sponsor
Revision as of 10:18, 22 November 2016 by Audrey.jee.2012 (talk | contribs) (Created page with "{|!--Sub Header Start--> {| style="background-color:white; color:white padding: 5px 0 0 0;" width="100%" height=50px cellspacing="0" cellpadding="0" valign="top" border="0" |...")
Initial Data Set
Data Cleaning
Public Housing Data
Step 1: Go to Tables > Stack
Step 2: Select the following columns, check “Stack by rows” and “Eliminate missing rows”
Step 3: Filter out and delete rows with missing values
Step 4: Create “Month” Column
Step 5: Fill month till the end of table
Step 6: Final Output
Step 7: Repeat the following process for all the month’s data Step 8: Go to table > Concatenate > Select all the months
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
Final consolidated data consist of 241,766 rows
