ANLY482 AY2017-18T2 Group32: Project Overview/Data
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.
