Predict Best Branch Locations For a Company
$begingroup$
I have a dataset of existing 156 branches of my company with the longitude and latitude of each branch. Now we want to open 10 more branches. How can we predict the best locations for opening the new branches using machine learning? As much as I have searched on google, I have gone through by using ARCGIS geo-spatial data or using openstreetmap but couldn't find all the steps properly. Therefore, Kindly guide me as I am a junior data scientist in my company and its my task to deliver the best locations.
machine-learning prediction geospatial
asked Jan 7 at 6:58
MaryamMaryam
62
$endgroup$
add a comment |
$begingroup$
I have a dataset of existing 156 branches of my company with the longitude and latitude of each branch. Now we want to open 10 more branches. How can we predict the best locations for opening the new branches using machine learning? As much as I have searched on google, I have gone through by using ARCGIS geo-spatial data or using openstreetmap but couldn't find all the steps properly. Therefore, Kindly guide me as I am a junior data scientist in my company and its my task to deliver the best locations.
machine-learning prediction geospatial
asked Jan 7 at 6:58
MaryamMaryam
62
$endgroup$
add a comment |
$begingroup$
I have a dataset of existing 156 branches of my company with the longitude and latitude of each branch. Now we want to open 10 more branches. How can we predict the best locations for opening the new branches using machine learning? As much as I have searched on google, I have gone through by using ARCGIS geo-spatial data or using openstreetmap but couldn't find all the steps properly. Therefore, Kindly guide me as I am a junior data scientist in my company and its my task to deliver the best locations.
machine-learning prediction geospatial
asked Jan 7 at 6:58
MaryamMaryam
62
$endgroup$
I have a dataset of existing 156 branches of my company with the longitude and latitude of each branch. Now we want to open 10 more branches. How can we predict the best locations for opening the new branches using machine learning? As much as I have searched on google, I have gone through by using ARCGIS geo-spatial data or using openstreetmap but couldn't find all the steps properly. Therefore, Kindly guide me as I am a junior data scientist in my company and its my task to deliver the best locations.
machine-learning prediction geospatial
machine-learning prediction geospatial
asked Jan 7 at 6:58
MaryamMaryam
62
asked Jan 7 at 6:58
MaryamMaryam
62
asked Jan 7 at 6:58
MaryamMaryam
62
asked Jan 7 at 6:58
MaryamMaryam
62
asked Jan 7 at 6:58
MaryamMaryam
62
62
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
This is a broad question, what I offer is one of many possible approaches; I will use R workflow (sf package to be exact).
The first step is to generate a grid covering your area of interest - city, country, continent, whatever :) Consider the approach described in this answer on StackOverflow. The size of the grid cells will depend on your company product - the catchment area of a corner shop is different from a catchment area of a strip mall.
The next step is link your store locations to grid cells - sf::st_intersects will be your friend here, and aggregate your desired metric (sales volume, new customer acquisition, or what not) per grid cell.
The third step is to find as much demographic and economic data as possible for administrative regions of your country (counties, districts, census areas...) - this will be country specific, so I cannot be your guide you here - and again link them to your grid.
The last step is creating a regression for desired output in a grid cell depending on the economic and demographic indicators.
Once you have a formula you can apply it to all the empty grid cells and pick the 10 most promising.
Edit [2019-01-22]: I have extended the suggested workflow into a blog post, you can view it at
http://www.jla-data.net/eng/branch-network-optimization-in-r/
answered Jan 7 at 8:04
Jindra LackoJindra Lacko
1616
$endgroup$
$begingroup$
I tried searching about your suggestion but couldnt get. Actually I am totally new to data science. I know basic algorithms like k-means, SVM, NN, Decision tree and random forest. How can I actually upload the geographical location of my country on R? Can you give some links, I will be really thankful to you.
$endgroup$
– Maryam
Jan 9 at 17:54
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "557"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f43602%2fpredict-best-branch-locations-for-a-company%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
$begingroup$
This is a broad question, what I offer is one of many possible approaches; I will use R workflow (sf package to be exact).
The first step is to generate a grid covering your area of interest - city, country, continent, whatever :) Consider the approach described in this answer on StackOverflow. The size of the grid cells will depend on your company product - the catchment area of a corner shop is different from a catchment area of a strip mall.
The next step is link your store locations to grid cells - sf::st_intersects will be your friend here, and aggregate your desired metric (sales volume, new customer acquisition, or what not) per grid cell.
The third step is to find as much demographic and economic data as possible for administrative regions of your country (counties, districts, census areas...) - this will be country specific, so I cannot be your guide you here - and again link them to your grid.
The last step is creating a regression for desired output in a grid cell depending on the economic and demographic indicators.
Once you have a formula you can apply it to all the empty grid cells and pick the 10 most promising.
Edit [2019-01-22]: I have extended the suggested workflow into a blog post, you can view it at
http://www.jla-data.net/eng/branch-network-optimization-in-r/
answered Jan 7 at 8:04
Jindra LackoJindra Lacko
1616
$endgroup$
$begingroup$
I tried searching about your suggestion but couldnt get. Actually I am totally new to data science. I know basic algorithms like k-means, SVM, NN, Decision tree and random forest. How can I actually upload the geographical location of my country on R? Can you give some links, I will be really thankful to you.
$endgroup$
– Maryam
Jan 9 at 17:54
add a comment |
$begingroup$
This is a broad question, what I offer is one of many possible approaches; I will use R workflow (sf package to be exact).
The first step is to generate a grid covering your area of interest - city, country, continent, whatever :) Consider the approach described in this answer on StackOverflow. The size of the grid cells will depend on your company product - the catchment area of a corner shop is different from a catchment area of a strip mall.
The next step is link your store locations to grid cells - sf::st_intersects will be your friend here, and aggregate your desired metric (sales volume, new customer acquisition, or what not) per grid cell.
The third step is to find as much demographic and economic data as possible for administrative regions of your country (counties, districts, census areas...) - this will be country specific, so I cannot be your guide you here - and again link them to your grid.
The last step is creating a regression for desired output in a grid cell depending on the economic and demographic indicators.
Once you have a formula you can apply it to all the empty grid cells and pick the 10 most promising.
Edit [2019-01-22]: I have extended the suggested workflow into a blog post, you can view it at
http://www.jla-data.net/eng/branch-network-optimization-in-r/
answered Jan 7 at 8:04
Jindra LackoJindra Lacko
1616
$endgroup$
$begingroup$
I tried searching about your suggestion but couldnt get. Actually I am totally new to data science. I know basic algorithms like k-means, SVM, NN, Decision tree and random forest. How can I actually upload the geographical location of my country on R? Can you give some links, I will be really thankful to you.
$endgroup$
– Maryam
Jan 9 at 17:54
add a comment |
$begingroup$
This is a broad question, what I offer is one of many possible approaches; I will use R workflow (sf package to be exact).
The first step is to generate a grid covering your area of interest - city, country, continent, whatever :) Consider the approach described in this answer on StackOverflow. The size of the grid cells will depend on your company product - the catchment area of a corner shop is different from a catchment area of a strip mall.
The next step is link your store locations to grid cells - sf::st_intersects will be your friend here, and aggregate your desired metric (sales volume, new customer acquisition, or what not) per grid cell.
The third step is to find as much demographic and economic data as possible for administrative regions of your country (counties, districts, census areas...) - this will be country specific, so I cannot be your guide you here - and again link them to your grid.
The last step is creating a regression for desired output in a grid cell depending on the economic and demographic indicators.
Once you have a formula you can apply it to all the empty grid cells and pick the 10 most promising.
Edit [2019-01-22]: I have extended the suggested workflow into a blog post, you can view it at
http://www.jla-data.net/eng/branch-network-optimization-in-r/
answered Jan 7 at 8:04
Jindra LackoJindra Lacko
1616
$endgroup$
This is a broad question, what I offer is one of many possible approaches; I will use R workflow (sf package to be exact).
The first step is to generate a grid covering your area of interest - city, country, continent, whatever :) Consider the approach described in this answer on StackOverflow. The size of the grid cells will depend on your company product - the catchment area of a corner shop is different from a catchment area of a strip mall.
The next step is link your store locations to grid cells - sf::st_intersects will be your friend here, and aggregate your desired metric (sales volume, new customer acquisition, or what not) per grid cell.
The third step is to find as much demographic and economic data as possible for administrative regions of your country (counties, districts, census areas...) - this will be country specific, so I cannot be your guide you here - and again link them to your grid.
The last step is creating a regression for desired output in a grid cell depending on the economic and demographic indicators.
Once you have a formula you can apply it to all the empty grid cells and pick the 10 most promising.
Edit [2019-01-22]: I have extended the suggested workflow into a blog post, you can view it at
http://www.jla-data.net/eng/branch-network-optimization-in-r/
answered Jan 7 at 8:04
Jindra LackoJindra Lacko
1616
edited 11 mins ago
answered Jan 7 at 8:04
Jindra LackoJindra Lacko
1616
answered Jan 7 at 8:04
Jindra LackoJindra Lacko
1616
answered Jan 7 at 8:04
Jindra LackoJindra Lacko
1616
1616
$begingroup$
I tried searching about your suggestion but couldnt get. Actually I am totally new to data science. I know basic algorithms like k-means, SVM, NN, Decision tree and random forest. How can I actually upload the geographical location of my country on R? Can you give some links, I will be really thankful to you.
$endgroup$
– Maryam
Jan 9 at 17:54
add a comment |
$begingroup$
I tried searching about your suggestion but couldnt get. Actually I am totally new to data science. I know basic algorithms like k-means, SVM, NN, Decision tree and random forest. How can I actually upload the geographical location of my country on R? Can you give some links, I will be really thankful to you.
$endgroup$
– Maryam
Jan 9 at 17:54
$begingroup$
I tried searching about your suggestion but couldnt get. Actually I am totally new to data science. I know basic algorithms like k-means, SVM, NN, Decision tree and random forest. How can I actually upload the geographical location of my country on R? Can you give some links, I will be really thankful to you.
$endgroup$
– Maryam
Jan 9 at 17:54
$begingroup$
I tried searching about your suggestion but couldnt get. Actually I am totally new to data science. I know basic algorithms like k-means, SVM, NN, Decision tree and random forest. How can I actually upload the geographical location of my country on R? Can you give some links, I will be really thankful to you.
$endgroup$
– Maryam
Jan 9 at 17:54
add a comment |
Thanks for contributing an answer to Data Science Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f43602%2fpredict-best-branch-locations-for-a-company%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
