Difference between revisions of "ANLY482 AY2017-18T2 Group32: Project Overview/Data"
Zycheng.2014 (talk | contribs) |
Zycheng.2014 (talk | contribs) |
||
| Line 57: | Line 57: | ||
{| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" | {| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" | ||
! style="background: #fcb706; color: #262626 ; font-weight: bold;" | File/ Sheet Name | ! style="background: #fcb706; color: #262626 ; font-weight: bold;" | File/ Sheet Name | ||
| + | ! style="background: #fcb706; color: #262626 ; font-weight: bold; " | Description | ||
! style="background: #fcb706; color: #262626 ; font-weight: bold; " | Count | ! style="background: #fcb706; color: #262626 ; font-weight: bold; " | Count | ||
| − | |||
|- | |- | ||
|'''HCP''' | |'''HCP''' | ||
| − | |||
|Information on individual doctors | |Information on individual doctors | ||
| + | |7553 | ||
|- | |- | ||
|'''HCO''' | |'''HCO''' | ||
| − | |||
|Information on clinics, organizations | |Information on clinics, organizations | ||
| + | |4919 | ||
|- | |- | ||
|'''Invoice Detail''' | |'''Invoice Detail''' | ||
| − | | | + | |Transactions of product purchases by Target Audience |
| − | | | + | |337518 |
|- | |- | ||
|'''TCE Account List/ TCE Brands only GP_SP''' | |'''TCE Account List/ TCE Brands only GP_SP''' | ||
| − | |||
| | | | ||
| + | |2361 | ||
|- | |- | ||
|'''TCE Brands''' | |'''TCE Brands''' | ||
| − | | | + | |Brands amongst the entire list of drugs that falls under the TCE category |
| − | | | + | |86 |
|- | |- | ||
Revision as of 22:08, 25 February 2018
Return to ANLY482 AY2017-18 Home Page
| Description | Data | Methodology |
With a clear understanding of what our sponsor had in mind, our team began data munging process. This includes: data cleaning, transformation, and integration to obtain a an integrated data table via JMP for further analysis.
For our project, the sponsor has provided us with five datasets - Invoice data, TCE Account List data, TCE Brands data, HCO and HCP data that stretched from the year 2015 to today.
| File/ Sheet Name | Description | Count |
|---|---|---|
| HCP | Information on individual doctors | 7553 |
| HCO | Information on clinics, organizations | 4919 |
| Invoice Detail | Transactions of product purchases by Target Audience | 337518 |
| TCE Account List/ TCE Brands only GP_SP | 2361 | |
| TCE Brands | Brands amongst the entire list of drugs that falls under the TCE category | 86 |
This metadata was obtained through our communications with Shopee Human Resources Team. However, they have notified us that they would require more time to verify with their internal Data Engineering and Operations teams before they can give us the final metadata as well as the preview of the dataset.
