Difference between revisions of "Uncovering Market-Insights for Charles & Keith: Data Preparation"

From Analytics Practicum
Jump to navigation Jump to search
(Created page with "<!--Banner--> {|style="background-color:#FFFFFF; color:#24c7b1; padding: 6px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | style="padding:0...")
 
 
(16 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
<div style=background:#F2D0C7 border:#F2D0C7>
 +
[[Image:DATAPREP.jpg|800px|center]]
 +
</div>
 +
 
<!--Banner-->
 
<!--Banner-->
 
{|style="background-color:#FFFFFF; color:#24c7b1; padding: 6px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
 
{|style="background-color:#FFFFFF; color:#24c7b1; padding: 6px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0"  |
| style="padding:0.3em; font-size:100%; background-color:#35383c;  border-bottom:3px solid #35383c; text-align:center; color:#828282" width="11%" | [[Uncovering Market-Insights for Charles & Keith |<font face = "Trebuchet MS" color="#FFFFFF" size=2><b>HOME</b></font>]]
+
| style="padding:0.3em; font-size:100%; background-color:#FFFFFF;  border-bottom:3px solid #35383c; text-align:center; color:#828282" width="11%" | [[Uncovering Market-Insights for Charles & Keith |<font face = "Trebuchet MS" color="#000000" size=2><b>HOME</b></font>]]
  
 
| style="border-bottom:3px solid #35383c; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:3px solid #35383c; background:none;" width="1%" | &nbsp;
Line 7: Line 11:
  
 
| style="border-bottom:3px solid #35383c; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:3px solid #35383c; background:none;" width="1%" | &nbsp;
| style="padding:0.3em; font-size:100%; background-color:#FFFFFF;  border-bottom:3px solid #35383c; text-align:center; color:#828282" width="11%" | [[Uncovering Market-Insights for Charles & Keith: Data Preparation | <font face = "Trebuchet MS" color="#000000" size=2><b>DATA PREPARATION</b></font>]]
+
| style="padding:0.3em; font-size:100%; background-color:#35383c;  border-bottom:3px solid #35383c; text-align:center; color:#828282" width="11%" | [[Uncovering Market-Insights for Charles & Keith: Data Preparation | <font face = "Trebuchet MS" color="#FFFFFF" size=2><b>DATA PREPARATION</b></font>]]
  
 
| style="border-bottom:3px solid #35383c; background:none;" width="1%" | &nbsp;
 
| style="border-bottom:3px solid #35383c; background:none;" width="1%" | &nbsp;
Line 19: Line 23:
 
</font>]]
 
</font>]]
 
|}
 
|}
 +
 +
 +
 +
<center>
 +
{| style="background-color:#ffffff ; margin: 3px 11px 3px 11px;" width="80%"|
 +
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border-top:solid #f5f5f5; background-color: #fff" width="200px" |
 +
[[Uncovering Market-Insights for Charles & Keith: Data Preparation|<font color="#3c3c3c"><strong>INITIAL DATASET</strong></font>]]
 +
 +
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" | 
 +
[[Uncovering Market-Insights for Charles & Keith: Data Cleaning|<font color="#3c3c3c"><strong>DATA CLEANING </strong></font>]]
 +
 +
| style="font-family:Trebuchet MS; font-size:11px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="200px" | 
 +
[[Uncovering Market-Insights for Charles & Keith: Final Dataset|<font color="#3c3c3c"><strong>FINAL DATASET</strong></font>]]
 +
 +
|}
 +
</center>
 +
 +
[[Image:AYEInitialDatset.jpg|900px|center|AYE InitialDataset]]
 +
 +
<div style="border: 1px solid #35383c; padding: 15px 15px 20px; border-radius: 0 0 3px 3px;">
 +
Our project sponsor CHARLES & KEITH GROUP has provided us with a dataset that consist of 3 years worth of in-store transaction data from all of its C&K retail stores in Mainland China and also order quantity based on each article, during the period from 2013 to 2015. Our data set has 15 columns and 4,374,674 rows of data.
 +
</div>

Latest revision as of 17:18, 17 April 2016

DATAPREP.jpg
HOME   OVERVIEW   DATA PREPARATION   ANALYSIS   PROJECT MANAGEMENT   DOCUMENTATION


INITIAL DATASET

DATA CLEANING

FINAL DATASET

AYE InitialDataset

Our project sponsor CHARLES & KEITH GROUP has provided us with a dataset that consist of 3 years worth of in-store transaction data from all of its C&K retail stores in Mainland China and also order quantity based on each article, during the period from 2013 to 2015. Our data set has 15 columns and 4,374,674 rows of data.