00_clustering_retail_data.xlsx

	A	B	C	D	E	F	G	H	I	J
1	Store Code	Store Name	GeoName ID	Country	City	Latitude - Longtitude	Latitude	Longtitude	Store Capacity	Trendy Customer %

2	1	Store 1	3432043	Argentina	La Plata	-34.92145, -57.95453	-34.92145	-57.95453	Medium Stores	0.49
3	3	Store 3	3835994	Argentina	Santa Rosa	-36.61667, -64.28333	-36.61667	-64.28333	Small Stores	0.26
4	5	Store 5	3836277	Argentina	Santa Fe	-31.64881, -60.70868	-31.64881	-60.70868	Small Stores	0.45
5	9	Store 9	3836873	Argentina	San Miguel de Tucuman	-26.82414, -65.2226	-26.82414	-65.2226	Big Stores	0.28
6	14	Store 14	2160517	Australia	Launceston	-41.43876, 147.13467	-41.43876	147.13467	Big Stores	0.36
7	17	Store 17	2172517	Australia	Canberra	-35.28346, 149.12807	-35.28346	149.12807	Small Stores	0.43
8	20	Store 20	8063098	Austria	Favoriten	48.16116, 16.38233	48.16116	16.38233	Small Stores	0.36
9	22	Store 22	2761369	Austria	Vienna	48.20849, 16.37208	48.20849	16.37208	Small Stores	0.37
10	25	Store 25	11903636	Austria	Donaustadt	48.2333, 16.46002	48.2333	16.46002	Small Stores	0.28
11	30	Store 30	2800481	Belgium	Charleroi	50.41136, 4.44448	50.41136	4.44448	Medium Stores	0.21
12	33	Store 33	2787149	Belgium	Schaerbeek	50.86935, 4.37737	50.86935	4.37737	Medium Stores	0.29
13	37	Store 37	2803138	Belgium	Antwerpen	51.22047, 4.40026	51.22047	4.40026	Small Stores	0.33
14	38	Store 38	3188582	Bosnia and Herzegovina	Tuzla	44.53842, 18.66709	44.53842	18.66709	Small Stores	0.18
15	43	Store 43	3186573	Bosnia and Herzegovina	Zenica	44.20169, 17.90397	44.20169	17.90397	Small Stores	0.31
16	49	Store 49	3386361	Brazil	Timon	-5.09417, -42.83667	-5.09417	-42.83667	Big Stores	0.33
17	53	Store 53	3452073	Brazil	Queimados	-22.71611, -43.55528	-22.71611	-43.55528	Small Stores	0.26
18	54	Store 54	3460718	Brazil	Itapevi	-23.54889, -46.93417	-23.54889	-46.93417	Medium Stores	0.36
19	57	Store 57	3471715	Brazil	Araruama	-22.87278, -42.34306	-22.87278	-42.34306	Small Stores	0.22
20	58	Store 58	3471910	Brazil	Apucarana	-23.55083, -51.46083	-23.55083	-51.46083	Small Stores	0.49
21	59	Store 59	3395473	Brazil	Maracanau	-3.87667, -38.62556	-3.87667	-38.62556	Small Stores	0.33
22	62	Store 62	3407669	Brazil	Ananindeua	-1.36556, -48.37222	-1.36556	-48.37222	Small Stores	0.21
23	63	Store 63	6317872	Brazil	Parauapebas	-6.0675, -49.90222	-6.0675	-49.90222	Big Stores	0.20
24	81	Store 81	3472177	Brazil	Angra dos Reis	-23.00667, -44.31806	-23.00667	-44.31806	Big Stores	0.21
25	82	Store 82	3392242	Brazil	Petrolina	-9.39861, -40.50083	-9.39861	-40.50083	Medium Stores	0.27
26	84	Store 84	3458930	Brazil	Lages	-27.81611, -50.32611	-27.81611	-50.32611	Small Stores	0.19
27	88	Store 88	3472766	Brazil	Alagoinhas	-12.13556, -38.41917	-12.13556	-38.41917	Small Stores	0.17
28	89	Store 89	11184422	Brazil	Planaltina	-15.61791, -47.64874	-15.61791	-47.64874	Big Stores	0.50
29	93	Store 93	3457001	Brazil	Mogi das Cruzes	-23.52278, -46.18833	-23.52278	-46.18833	Small Stores	0.47
30	94	Store 94	3471859	Brazil	Aracatuba	-21.20889, -50.43278	-21.20889	-50.43278	Medium Stores	0.27
31	95	Store 95	3448632	Brazil	Sao Jose dos Pinhais	-25.5302, -49.20836	-25.5302	-49.20836	Big Stores	0.22
32	101	Store 101	3662762	Brazil	Porto Velho	-8.76194, -63.90389	-8.76194	-63.90389	Small Stores	0.49
33	103	Store 103	3459712	Brazil	Joinville	-26.30444, -48.84556	-26.30444	-48.84556	Medium Stores	0.35
34	107	Store 107	3452925	Brazil	Porto Alegre	-30.03283, -51.23019	-30.03283	-51.23019	Big Stores	0.47
35	110	Store 110	3462315	Brazil	Governador Valadares	-18.85111, -41.94944	-18.85111	-41.94944	Medium Stores	0.45
36	115	Store 115	3465944	Brazil	Colatina	-19.53944, -40.63056	-19.53944	-40.63056	Medium Stores	0.46
37	117	Store 117	3450083	Brazil	Santa Maria	-29.68417, -53.80694	-29.68417	-53.80694	Small Stores	0.49
38	119	Store 119	727523	Bulgaria	Ruse	43.84872, 25.9534	43.84872	25.9534	Small Stores	0.25
39	120	Store 120	726848	Bulgaria	Stara Zagora	42.43278, 25.64194	42.43278	25.64194	Medium Stores	0.15
40	127	Store 127	6325521	Canada	Levis	46.80326, -71.17793	46.80326	-71.17793	Big Stores	0.39
41	136	Store 136	7602078	Canada	Ladner	49.08938, -123.08241	49.08938	-123.08241	Small Stores	0.22
42	137	Store 137	6077243	Canada	Montreal	45.50884, -73.58781	45.50884	-73.58781	Small Stores	0.37
43	138	Store 138	6087029	Canada	Nepean	45.33619, -75.7225	45.33619	-75.7225	Small Stores	0.22
44	141	Store 141	6167865	Canada	Toronto	43.70011, -79.4163	43.70011	-79.4163	Small Stores	0.32
45	144	Store 144	1529484	China	Hami	42.83393, 93.50601	42.83393	93.50601	Small Stores	0.44
46	149	Store 149	7303248	China	Jiashan	30.84918, 120.92583	30.84918	120.92583	Small Stores	0.35
47	153	Store 153	1801934	China	Luohe	33.56394, 114.04272	33.56394	114.04272	Big Stores	0.33
48	163	Store 163	1811028	China	Fuji	29.14819, 105.37391	29.14819	105.37391	Big Stores	0.32
49	165	Store 165	10942359	China	Baoji	34.36775, 107.23705	34.36775	107.23705	Small Stores	0.28
50	179	Store 179	1808392	China	Hengshui	37.73222, 115.70111	37.73222	115.70111	Small Stores	0.48
51	184	Store 184	1785974	China	Yuci	37.68028, 112.73194	37.68028	112.73194	Small Stores	0.37
52	189	Store 189	1808370	China	Hengyang	26.88946, 112.61888	26.88946	112.61888	Medium Stores	0.32
53	190	Store 190	1808950	China	Hanfeng	31.16946, 108.4031	31.16946	108.4031	Small Stores	0.18
54	191	Store 191	2038180	China	Changchun	43.88, 125.32278	43.88	125.32278	Small Stores	0.41
55	192	Store 192	2035225	China	Fendou	46.64142, 124.86283	46.64142	124.86283	Medium Stores	0.47
56	197	Store 197	1796236	China	Shanghai	31.22222, 121.45806	31.22222	121.45806	Medium Stores	0.39
57	198	Store 198	1802276	China	Longyan	25.07485, 117.01775	25.07485	117.01775	Big Stores	0.33
58	200	Store 200	1916012	China	Wuzhishan	18.78229, 109.5013	18.78229	109.5013	Small Stores	0.23
59	202	Store 202	8408334	China	Qianjiang	29.53284, 108.77478	29.53284	108.77478	Medium Stores	0.41
60	204	Store 204	2036892	China	Hohhot	40.81056, 111.65222	40.81056	111.65222	Big Stores	0.46
61	208	Store 208	1814757	China	Chuzhou	32.32194, 118.29778	32.32194	118.29778	Small Stores	0.43
62	209	Store 209	2035669	China	Lianhe	47.13333, 129.27426	47.13333	129.27426	Small Stores	0.41
63	215	Store 215	1785623	China	Kunshan	31.37762, 120.95431	31.37762	120.95431	Small Stores	0.19
64	220	Store 220	1810820	China	Fuzhou	27.95999, 116.33333	27.95999	116.33333	Small Stores	0.38
65	223	Store 223	7576887	China	Hezhou	24.40357, 111.56675	24.40357	111.56675	Small Stores	0.34
66	226	Store 226	1814082	China	Daliang	22.84067, 113.2503	22.84067	113.2503	Small Stores	0.47
67	230	Store 230	1784580	China	Zhenzhou	32.28034, 119.16999	32.28034	119.16999	Small Stores	0.26
68	233	Store 233	1803551	China	Beiliu	22.70722, 110.34917	22.70722	110.34917	Small Stores	0.17
69	235	Store 235	1806776	China	Huizhou	23.11147, 114.41523	23.11147	114.41523	Big Stores	0.33
70	239	Store 239	1799471	China	Nianbo	36.48, 102.41639	36.48	102.41639	Medium Stores	0.43
71	242	Store 242	1816234	China	Bozhou	33.87722, 115.77028	33.87722	115.77028	Small Stores	0.26
72	247	Store 247	1811200	China	Fengcheng	34.70388, 116.58717	34.70388	116.58717	Medium Stores	0.17
73	249	Store 249	1785018	China	Zhangzhou	24.51333, 117.65556	24.51333	117.65556	Big Stores	0.34
74	254	Store 254	1796068	China	Shangluo	33.86667, 109.93056	33.86667	109.93056	Medium Stores	0.27
75	259	Store 259	1815059	China	Chenzhou	25.8, 113.03333	25.8	113.03333	Big Stores	0.15
76	262	Store 262	2037860	China	Daqing	46.58333, 125.0	46.58333	125.0	Small Stores	0.27
77	267	Store 267	1798473	China	Puqi	29.71667, 113.88333	29.71667	113.88333	Small Stores	0.49
78	268	Store 268	1803567	China	Linfen	36.08889, 111.51889	36.08889	111.51889	Medium Stores	0.24
79	272	Store 272	1787828	China	Xuyong	28.16992, 105.43452	28.16992	105.43452	Small Stores	0.36
80	273	Store 273	1792947	China	Tianjin	39.14222, 117.17667	39.14222	117.17667	Small Stores	0.43
81	275	Store 275	1788492	China	Xinzhai	36.4, 118.61667	36.4	118.61667	Small Stores	0.22
82	281	Store 281	1784658	China	Zhengzhou	34.75778, 113.64861	34.75778	113.64861	Small Stores	0.49
83	287	Store 287	1807544	China	Daxing	39.74025, 116.32693	39.74025	116.32693	Big Stores	0.49
84	288	Store 288	1812955	China	Dezhou	37.44661, 116.36706	37.44661	116.36706	Medium Stores	0.39
85	290	Store 290	1817968	China	Anshun	26.25, 105.93333	26.25	105.93333	Small Stores	0.48
86	291	Store 291	2034754	China	Shunyi	40.12175, 116.64783	40.12175	116.64783	Small Stores	0.31
87	294	Store 294	1785453	China	Zaozhuang	34.86472, 117.55417	34.86472	117.55417	Medium Stores	0.22
88	296	Store 296	1793419	China	Binhe	32.68833, 112.8275	32.68833	112.8275	Big Stores	0.17
89	299	Store 299	1784178	China	Zhoucun	36.81667, 117.81667	36.81667	117.81667	Small Stores	0.27
90	303	Store 303	2038679	China	Acheng	45.54558, 126.95191	45.54558	126.95191	Big Stores	0.22
91	304	Store 304	8533133	China	Liupanshui	26.59444, 104.83333	26.59444	104.83333	Big Stores	0.33
92	307	Store 307	1784820	China	Xinghua	32.93917, 119.83417	32.93917	119.83417	Big Stores	0.34
93	311	Store 311	1784712	China	Zhengding	38.13972, 114.55944	38.13972	114.55944	Big Stores	0.38
94	317	Store 317	1814934	China	Chizhou	30.66134, 117.47783	30.66134	117.47783	Small Stores	0.31
95	318	Store 318	1815286	China	Chengdu	30.66667, 104.06667	30.66667	104.06667	Small Stores	0.40
96	322	Store 322	1795060	China	Shiqi	22.51682, 113.38521	22.51682	113.38521	Small Stores	0.40
97	324	Store 324	1809467	China	Guixi	30.33355, 107.34545	30.33355	107.34545	Medium Stores	0.36
98	325	Store 325	1812749	China	Dingxi	35.57088, 104.62303	35.57088	104.62303	Big Stores	0.46
99	326	Store 326	2036876	China	Honggang	46.3974, 124.88447	46.3974	124.88447	Big Stores	0.36
100	328	Store 328	2033536	China	Yakeshi	49.28333, 120.73333	49.28333	120.73333	Small Stores	0.40