You can download the shapefiles from the
Global Administrative Areas.
![](/c/portal/getImageAttachment?filename=GAA.png&userId=78214)
If you expand the Zip File you'll find that the regions can be found at level 1. So we can import both th shapefile and database into Mathematica.
kazakhstan = Import["C:\\Users\\Diego\\Documents\\Downloads\\KAZ_adm\\KAZ_adm1.shp", "Graphics"];
regions = Import["C:\\Users\\Diego\\Documents\\Downloads\\KAZ_adm\\KAZ_adm1.dbf"];
(*Modified the XLS file so the names of the Regions will match in XLS *)
data = Import["ModifiedCountryMap.xlsx", "Data"][[1]] // Rest;
(*Shapes of the different regions can be found at this level of the list - This was done by checking the list content visually *)
regionsKaz = kazakhstan[[1]][[2]][[1]][[2]];
minValue = Min@data[[All, 5]]; maxValue = Max@data[[All, 5]];
myScale[value_, min_, max_] := (value - min)/(max - min) // N
(*Testing to see if the map works*)
Module[{a},Show[Graphics[{EdgeForm[Gray], ColorData["TemperatureMap"][ myScale[a = First@Cases[data, {regions[[#, 5]], info1_, info2_, info3_, infoTotal_} -> infoTotal], minValue, maxValue]], Tooltip[regionsKaz[[#]],Column[{regions[[#, 5]], a}, Center, Frame -> True]]}] & /@ Range[14], Frame -> True, FrameTicks -> None, PlotLabel -> "Kazakhstan", ImageSize -> Large]]
Attachments: