Question 1: Dynamic Routing
C:\Users\1481656\OneDrive - Standard Chartered Bank\Documents\Data Projects\Data Science Learning Path\Use Case- Kyosk App\territories_centroids.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
territories_centroids.csv
C:\Users\1481656\AppData\Local\Temp\Engine_21592_e231026718ce4685bef791b3559df63d_\Engine_22036_536d21a97cd74d1088357520ebab0293_.yxdb
Single
Profile
C:\Users\1481656\AppData\Local\Temp\Engine_21592_e231026718ce4685bef791b3559df63d_\Engine_22036_02087d1c68ef4e758a687a0761685c9c_.yxdb
Single
Profile
Select required columns for clustering_1
Select required columns for clustering_1
Clustering Analysis
duka_latitude + duka_longitude
True
True
False
True
False
False
19
10
True
False
2
True
5.50
5.50
False
13.00
14.95
1x
10
K-Centroid Cluster Analysis : Partition the records into the selected number of clusters based on the chosen method.
K-Centroid Cluster Analysis : Partition the records into the selected number of clusters based on the chosen method.
Select required columns for clustering_2
Select required columns for clustering_2
Cluster
Append Cluster:Append the cluster assignment onto each record.
Append Cluster:Append the cluster assignment onto each record.
C:\Users\1481656\AppData\Local\Temp\Engine_21592_e231026718ce4685bef791b3559df63d_\Engine_22036_188100280c6b4c4d8f6d0bd467aec502_.yxdb
C:\Users\1481656\AppData\Local\Temp\Engine_21592_e231026718ce4685bef791b3559df63d_\Engine_22036_31884654d9e6447b96b9182c76cac19d_.yxdb
Single
Profile
Join the cluster info with the original location data.
Join the cluster info with the original location data.
Rename columns
C:\Users\1481656\OneDrive - Standard Chartered Bank\Documents\Data Projects\Data Science Learning Path\Use Case- Kyosk App\Outputs\Q1_Output_submission_file_centroids.csv
CRLF
,
False
True
28591
True
Q1_Output_submission_file_centroids.csv
Remove duplicates
Visualize clusters of customers on a map
C:\Users\1481656\AppData\Local\Temp\Engine_21592_e231026718ce4685bef791b3559df63d_\Engine_22036_a388ce43cdfd4f679d2c82c55d163bbc_.yxdb
Single
Map
C:\Users\1481656\OneDrive - Standard Chartered Bank\Documents\Data Projects\Data Science Learning Path\Use Case- Kyosk App\dataset.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
dataset.csv
Horizontal
Kyosk Workflow_Question 1