Difference between revisions of "Uncovering Market-Insights for Charles & Keith: About Sponsor"
Jump to navigation
Jump to search
(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" |...") |
|||
Line 18: | Line 18: | ||
{| style="background-color:#ffffff ; margin: 3px 11px 3px 11px;" width="80%"| | {| style="background-color:#ffffff ; margin: 3px 11px 3px 11px;" width="80%"| | ||
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-bottom:1px solid #000000; border-top:1px solid #000000; background-color: #FFFFFF" width="200px" | | | style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-bottom:1px solid #000000; border-top:1px solid #000000; background-color: #FFFFFF" width="200px" | | ||
− | [[ | + | [[Kabak: Research Paper: Overview|<font color="#35383c"><strong>OVERVIEW</strong></font>]] |
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-bottom:1px solid #000000; border-top:1px solid #000000; background-color: #35383c" width="200px" | | | style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-bottom:1px solid #000000; border-top:1px solid #000000; background-color: #35383c" width="200px" | | ||
− | [[ | + | [[Kabak: Research Paper: Data Preparation|<font color="#FFFFFF"><strong>DATA PREPARATION</strong></font>]] |
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-bottom:1px solid #000000; border-top:1px solid #000000; background-color: #FFFFFF" width="200px" | | | style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-bottom:1px solid #000000; border-top:1px solid #000000; background-color: #FFFFFF" width="200px" | | ||
− | [[ | + | [[Kabak: Research Paper: Analysis|<font color="#35383c"><strong>ANALYSIS</strong></font>]] |
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-bottom:1px solid #000000; border-top:1px solid #000000; background-color: #FFFFFF" width="200px" | | | style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-bottom:1px solid #000000; border-top:1px solid #000000; background-color: #FFFFFF" width="200px" | | ||
− | [[ | + | [[Kabak: Research Paper: Project Management|<font color="#35383c"><strong>PROJECT MANAGEMENT</strong></font>]] |
|} | |} | ||
</center> | </center> |
Latest revision as of 10:23, 22 November 2016
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