Difference between revisions of "G1-Group10"
(13 intermediate revisions by 2 users not shown) | |||
Line 18: | Line 18: | ||
| style="background:none;" width="1%" | | | style="background:none;" width="1%" | | ||
| style="padding:0.2em; font-size:100%; background-color:#1D1D1D; border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" | | | style="padding:0.2em; font-size:100%; background-color:#1D1D1D; border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" | | ||
− | [[ | + | [[Three_horrible_guys_Web_Maps|<font color="#F5F5F5" size=2 face="Helvetica"><b>WEB MAPS</b></font>]] |
| style="background:none;" width="1%" | | | style="background:none;" width="1%" | | ||
| style="padding:0.2em; font-size:100%; background-color:#1D1D1D; border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" | | | style="padding:0.2em; font-size:100%; background-color:#1D1D1D; border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" | | ||
− | [[ | + | [[Three_horrible_guys_Project_Report|<font color="#F5F5F5" size=2 face="Helvetica"><b>REPORT</b></font>]] |
|} | |} | ||
<!--/Header--> | <!--/Header--> | ||
Line 36: | Line 36: | ||
Leveraging on this fact, our group aims to digitalise the data and conduct in-depth analysis on each branch. We hope to track the performance of each chain in relation to Point-Of-Interests surrounding each chain, uncovering and comprehending phenomena, with the aid of spatial data. | Leveraging on this fact, our group aims to digitalise the data and conduct in-depth analysis on each branch. We hope to track the performance of each chain in relation to Point-Of-Interests surrounding each chain, uncovering and comprehending phenomena, with the aid of spatial data. | ||
+ | |||
+ | This project was made in tandem with: https://wiki.smu.edu.sg/1920t1is428g1/Two_Eyes_One_Pizza | ||
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Objectives</font></div>== | ==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Objectives</font></div>== | ||
Line 64: | Line 66: | ||
Datasets Provided: | Datasets Provided: | ||
</p> | </p> | ||
+ | |||
{| class="wikitable" style="background-color:#FFFFFF;" width="100%" | {| class="wikitable" style="background-color:#FFFFFF;" width="100%" | ||
|- | |- | ||
Line 81: | Line 84: | ||
| <center> Geospatial Data </center>[[Image: A2.png |300px|center]] || | | <center> Geospatial Data </center>[[Image: A2.png |300px|center]] || | ||
* The client provided us SHP files that contains information about Counties found in Taiwan | * The client provided us SHP files that contains information about Counties found in Taiwan | ||
− | + | <center> | |
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 94: | Line 97: | ||
| COUNTYENG|| Name of the County in English|| “Taipei City” | | COUNTYENG|| Name of the County in English|| “Taipei City” | ||
|} | |} | ||
− | + | </center> | |
|- | |- | ||
| <center> Town Area </center> [[Image: A3.png |300px|center]]|| | | <center> Town Area </center> [[Image: A3.png |300px|center]]|| | ||
* The client provided us SHP files that contains information about Towns found in Taiwan | * The client provided us SHP files that contains information about Towns found in Taiwan | ||
+ | |||
+ | <center> | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 122: | Line 127: | ||
| NOTE|| Miscellaneous notes || NIL | | NOTE|| Miscellaneous notes || NIL | ||
|} | |} | ||
− | + | </center> | |
|- | |- | ||
| <center> Village Area </center> [[Image: A4.png |300px|center]]|| | | <center> Village Area </center> [[Image: A4.png |300px|center]]|| | ||
* The client provided us SHP files that contains information about Villages found in Taiwan | * The client provided us SHP files that contains information about Villages found in Taiwan | ||
− | + | <center> | |
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 145: | Line 150: | ||
| COUNTYNAME|| Name of the County in Mandarin|| “台北市” | | COUNTYNAME|| Name of the County in Mandarin|| “台北市” | ||
|} | |} | ||
− | + | </center> | |
|- | |- | ||
− | | <center> Taiwan Stores </center> [[Image: | + | | <center> Taiwan Stores </center> [[Image: A6.png |500px|center]] || |
− | * The client provided us a GeoPackage that contains information about each | + | * The client provided us a GeoPackage that contains information about each IFC Store |
− | + | <center> | |
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 208: | Line 213: | ||
| Cluster ID|| Used to denote which group these stores were assigned to, in numerical value|| 6 | | Cluster ID|| Used to denote which group these stores were assigned to, in numerical value|| 6 | ||
|} | |} | ||
+ | </center> | ||
+ | |- | ||
+ | | <center> POIs </center>[[Image: A6.png |300px|center]] || | ||
+ | * The client provided us SHP files that contains information about each POI. We used 32 out of the 86 POI SHPs given. They are: | ||
+ | # ATM | ||
+ | # BANK | ||
+ | # BAR OR PUB | ||
+ | # BOOKSTORE | ||
+ | # BOWLING CENTRE | ||
+ | # BUS STATION | ||
+ | # BUSINESS FACILITY | ||
+ | # CINEMA | ||
+ | # CLOTHING STORE | ||
+ | # COFFEE SHOP | ||
+ | # COMMUTER RAIL STATION | ||
+ | # CONSUMER ELECTRONICS STORE | ||
+ | # CONVENIENCE STORE | ||
+ | # DEPARTMENT STORE | ||
+ | # INDUSTRIAL ZONE | ||
+ | # GOVERNMENT OFFICE | ||
+ | # GROCERY STORE | ||
+ | # HIGHER EDUCATION | ||
+ | # HOSPITAL | ||
+ | # HOTEL | ||
+ | # MEDICAL SERVICE | ||
+ | # NIGHTLIFE | ||
+ | # PERFORMING ARTS | ||
+ | # PHARMACY | ||
+ | # RESIDENTIAL AREA/BUILDING | ||
+ | # RESTAURANT | ||
+ | # SCHOOL | ||
+ | # SHOPPING | ||
+ | # SPECIALITY STORE | ||
+ | # SPORTS CENTRE | ||
+ | # SPORTS COMPLEX | ||
+ | # TRAIN STATION | ||
+ | <center> | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Column !! Description !! Example | ||
+ | |- | ||
+ | | fid || Unique numerical ID of each POI type || 25 | ||
+ | |- | ||
+ | | LINK_ID || Unsure || 969985784 | ||
+ | |- | ||
+ | | POI_ID || Unique numerical ID for each POI || 1201865541 | ||
+ | |- | ||
+ | | SEQ_NUM || Unsure || 1 | ||
+ | |- | ||
+ | | FAC_TYPE || Numerical ID for facility type || 9853 | ||
+ | |- | ||
+ | |POI_NAME || Name of the POI || “王牙科” | ||
+ | |- | ||
+ | | POI_LANGCD || Unsure || “CHT” | ||
+ | |- | ||
+ | | POI_NMTYPE || Unsure || “B” | ||
+ | |- | ||
+ | | POI_ST_NUM || Unsure || 91 | ||
+ | |- | ||
+ | | ST_NUM_FUL || Unsure || 124-1 | ||
+ | |- | ||
+ | | ST_NFUL_LC || Unsure || “CHT” | ||
+ | |- | ||
+ | | ST_NAME || Name of ST || “中和路” | ||
+ | |- | ||
+ | | ST_LANGCD || Unsure || “CHT” | ||
+ | |- | ||
+ | | POI_ST_SD || Unsure || “L” | ||
+ | |- | ||
+ | | ACC_TYPE || Unsure || NIL | ||
+ | |- | ||
+ | | PH_NUMBER || Unsure || 3-5281997 | ||
+ | |- | ||
+ | | CHAIN_ID || Unsure || 0 | ||
+ | |- | ||
+ | | NAT_IMPORT || Unsure || “N” | ||
+ | |- | ||
+ | | PRIVATE || Unsure || “N” | ||
+ | |- | ||
+ | | IN_VICIN || Unsure || “N” | ||
+ | |- | ||
+ | | NUM_PARENT || Unsure || 0 | ||
+ | |- | ||
+ | | NUM_CHILD || Unsure || 0 | ||
+ | |- | ||
+ | | PERCFRREF || Unsure || 40 | ||
+ | |- | ||
+ | | VANCITY_ID || Unsure || 0 | ||
+ | |- | ||
+ | | ACT_ADDR || Unsure || NIL | ||
+ | |- | ||
+ | | ACT_LANGCD || Unsure || NIL | ||
+ | |- | ||
+ | | ACT_ST_NAM || Unsure || NIL | ||
+ | |- | ||
+ | | ACT_ADMIN || Unsure || NIL | ||
+ | |- | ||
+ | | ACT_POSTAL || Unsure || NIL | ||
+ | |- | ||
+ | | ENTR_TYPE || Unsure || NIL | ||
+ | |} | ||
+ | </center> | ||
+ | |- | ||
+ | | <center> Competitor POI’s </center> || | ||
+ | * The client also provided us SHP files that contains information about each individual store from 5 clients. The data has the same attributes as POIs (refer to above), with an addition column: | ||
+ | <center> | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Column !! Description !! Example | ||
+ | |- | ||
+ | | FOOD_TYPE|| Type of food Competitor sells || “FAST FOOD” | ||
+ | |} | ||
+ | </center> | ||
+ | |||
+ | |||
+ | |- | ||
+ | | <center> Taiwan Road </center>[[Image: A7.png |300px|center]] || | ||
+ | * We obtained Taiwan Road SHP files online and managed to get it from mapcruzin.com. This was used in our shortest path analytical task. | ||
+ | * Obtained from https://mapcruzin.com/free-taiwan-country-city-place-gis-shapefiles.htm | ||
+ | <center> | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Column !! Description !! Example | ||
+ | |- | ||
+ | | osm_id || Unique ID of the road || 25 | ||
+ | |- | ||
+ | | name || Name of the road || Alley 43-33, Ln. 361, Jieshou Rd. Sec. 2 | ||
+ | |- | ||
+ | | ref || Unsure || 4 | ||
+ | |- | ||
+ | | type || The type of road || “primary” | ||
+ | |- | ||
+ | | oneway || One hot encoded, 1 = oneway 0 = not oneway || 1 | ||
+ | |- | ||
+ | | bridge || One hot encoded,, 1 = road on bridge 0 = not on bridge || 0 | ||
+ | |- | ||
+ | | tunnel || One hot encoded, 1 = road in a tunnel = 0 not in tunnel || 0 | ||
+ | |- | ||
+ | | maxspeed || Max allowed speed on road || 90 | ||
+ | |} | ||
+ | </center> | ||
+ | |||
+ | |- | ||
+ | | <center> Sales Data </center>[[Image: A8.png |300px|center]] || | ||
+ | * The client gave us a CSV file containing yearly sales information of each region, further broken down into zone | ||
+ | |||
+ | <center> | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Column !! Description !! Example | ||
+ | |- | ||
+ | | Zone || Name of the Zone || “D-05” | ||
+ | |- | ||
+ | | Bills || Numerical value of bills || 666 | ||
+ | |- | ||
+ | | Bills % || Percentage of total number of bills || 24.46 | ||
+ | |- | ||
+ | | Amount || Total monetary amount of sales || 450182 | ||
+ | |- | ||
+ | | Amount % || Percentage of Total monetary amount of sales || 23.88 | ||
+ | |- | ||
+ | | Ave Bill || Average monetary amount from sales || 675.95 | ||
+ | |- | ||
+ | | Shop Code Sales || String used to denote shop code || “AE” | ||
+ | |} | ||
+ | </center> | ||
+ | |||
+ | |- | ||
+ | | <center> Population Data </center> || | ||
+ | * We obtained population data with regards to Taiwan online. The XLS file contains population Data is from the year 2010 and is in, uncleaned table format XLS. This was used as an addition feature in our analysis. | ||
+ | * Obtained from https://census.dgbas.gov.tw/PHC2010/english/rehome.htm | ||
+ | |||
+ | |||
+ | <center> | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | | Number of resident population: Grand total || Total number of residents, male + female || 23123866 | ||
+ | |- | ||
+ | | Number of resident population: Male || Total number of male residents || 11489285 | ||
+ | |- | ||
+ | | Number of resident population: Female || Total number of female residents || 11634581 | ||
+ | |- | ||
+ | | Total Land Area (km2) || Total monetary amount of sales || 36191.5 | ||
+ | |- | ||
+ | | Population Density (person/km2) || Percentage of Total monetary amount of sales || 638.9 | ||
+ | |- | ||
+ | | By Country/City || Country/City the row of data belongs to || “Taipei City” | ||
+ | |} | ||
+ | </center> | ||
|- | |- | ||
|} | |} | ||
Line 303: | Line 497: | ||
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Project Schedule</font></div>== | ==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>Project Schedule</font></div>== | ||
− | + | Project Gantt chart: | |
− | + | [[File:Ganttgantt.png|1200px|none]] | |
− | [[ | ||
==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>References</font></div>== | ==<div style="background: #8b1209; padding: 15px; line-height: 0.3em; text-indent: 15px; font-size:18px; font-family:Helvetica"><font color= #FFFFFF>References</font></div>== |
Latest revision as of 02:10, 22 November 2019
Contents
Introduction & Motivation
International Food Chain (IFC) is a leading brand in its sector, with over 18000 outlets worldwide and an ever-growing presence in the global market. In Taiwan alone, IFC has over 240 branches and are constantly expanding.
However, as the franchise grows bigger, so does its challenges. One of the challenges involves the lack of a geographical analysis to efficiently compare the performance of each chain to one another.
Leveraging on this fact, our group aims to digitalise the data and conduct in-depth analysis on each branch. We hope to track the performance of each chain in relation to Point-Of-Interests surrounding each chain, uncovering and comprehending phenomena, with the aid of spatial data.
This project was made in tandem with: https://wiki.smu.edu.sg/1920t1is428g1/Two_Eyes_One_Pizza
Objectives
This project aims to provide insights into the following:
- Missing Areas in trade zone
- Number of POIs surrounding each store
- Store performance with regards to sales
- Delivery Information
- Population Density
- Buffer and proximity
- Nearest Competitors to store
- Variable importance based on regression analysis
Tools and Libraries
The following tools and libraries are used in the digitisation and analysis:
- QGIS
- Excel
- Python
Datasets
Datasets Provided:
Dataset | Rationale | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Foreseen Technical Challenges
We encountered the following technical challenges throughout the course of the project. We have indicated our proposed solutions, and the outcomes of the solutions.
Key Technical Challenges | Proposed Solution | Outcome |
---|---|---|
|
NA | |
|
We managed to start using the languages quickly and suit our own project needs. Each of us work on different parts such as setting up, designing, logic and deployment. This speeds up our project progress. | |
|
The adopted process was having clear instructions issued to each member in the team, along with maintaining constant communication with each other. In the event that the dataset is deemed too dirty to be usable, it was dropped along with sourcing for new data that would be a suitable replacement. | |
|
NA | |
|
The data points can better allow us to generate insights on the profile of each outlet via its trade area. | |
|
NA |
Scope of work
- Roles
Kelvin Chia Sen Wei | Linus Cheng Xin Wei | Eugene Choy Wen Jie |
---|---|---|
Data Cleaner in Python |
Project Manager |
Data Cleaner in Excel |
Project Schedule
Project Gantt chart:
References
- Project Page: https://wiki.smu.edu.sg/1920t1smt201/GIS_Project
- Python Pandas: https://pandas.pydata.org/
- Tableau: https://www.tableau.com/learn/training
- QGIS: http://www.qgistutorials.com/en/
Comments
Feel free to leave comments / suggestions!