Use Python to find groups of consecutive numbers in excel
SO i embarked on learning python a couple of weeks ago through codecademy and it has been a slow process for me. But unfortunately I'm at a point right now that i need a script to do a specific function for me right now.
I have an excel doc that is a list of ID numbers, example -
72100234
72100235
72100239
There are roughly 50,000 id numbers. I need a script that will do a couple of things for me.
- first is to show me how the job is done so i can learn from it
- second is its purpose, I need it to go through and find the consecutive numbers and group them together in either a separate file or another tab
Example -
72100234
72100235
72100236
72100239
72100240
I have to find these blocks of numbers so they can be assigned to a specific agency and going through the list manually... yeah, been there, done that, dont want to do it again.
Thanks for any help.
python
asked Nov 13 '18 at 20:03
Chris DChris D
1
add a comment |
SO i embarked on learning python a couple of weeks ago through codecademy and it has been a slow process for me. But unfortunately I'm at a point right now that i need a script to do a specific function for me right now.
I have an excel doc that is a list of ID numbers, example -
72100234
72100235
72100239
There are roughly 50,000 id numbers. I need a script that will do a couple of things for me.
- first is to show me how the job is done so i can learn from it
- second is its purpose, I need it to go through and find the consecutive numbers and group them together in either a separate file or another tab
Example -
72100234
72100235
72100236
72100239
72100240
I have to find these blocks of numbers so they can be assigned to a specific agency and going through the list manually... yeah, been there, done that, dont want to do it again.
Thanks for any help.
python
asked Nov 13 '18 at 20:03
Chris DChris D
1
5
Hi Chris, welcome to Stack Overflow. Unfortunately this is not a platform where we create code from scratch to solve your problems, can you share any code you've already written and point out where you're having issues? If your code is working but you think it is inefficient, I would suggest looking at the Code Review stack exchange.
– Christian Scillitoe
Nov 13 '18 at 20:08
add a comment |
SO i embarked on learning python a couple of weeks ago through codecademy and it has been a slow process for me. But unfortunately I'm at a point right now that i need a script to do a specific function for me right now.
I have an excel doc that is a list of ID numbers, example -
72100234
72100235
72100239
There are roughly 50,000 id numbers. I need a script that will do a couple of things for me.
- first is to show me how the job is done so i can learn from it
- second is its purpose, I need it to go through and find the consecutive numbers and group them together in either a separate file or another tab
Example -
72100234
72100235
72100236
72100239
72100240
I have to find these blocks of numbers so they can be assigned to a specific agency and going through the list manually... yeah, been there, done that, dont want to do it again.
Thanks for any help.
python
asked Nov 13 '18 at 20:03
Chris DChris D
1
SO i embarked on learning python a couple of weeks ago through codecademy and it has been a slow process for me. But unfortunately I'm at a point right now that i need a script to do a specific function for me right now.
I have an excel doc that is a list of ID numbers, example -
72100234
72100235
72100239
There are roughly 50,000 id numbers. I need a script that will do a couple of things for me.
- first is to show me how the job is done so i can learn from it
- second is its purpose, I need it to go through and find the consecutive numbers and group them together in either a separate file or another tab
Example -
72100234
72100235
72100236
72100239
72100240
I have to find these blocks of numbers so they can be assigned to a specific agency and going through the list manually... yeah, been there, done that, dont want to do it again.
Thanks for any help.
python
python
asked Nov 13 '18 at 20:03
Chris DChris D
1
asked Nov 13 '18 at 20:03
Chris DChris D
1
asked Nov 13 '18 at 20:03
Chris DChris D
1
asked Nov 13 '18 at 20:03
Chris DChris D
1
asked Nov 13 '18 at 20:03
Chris DChris D
1
1
5
Hi Chris, welcome to Stack Overflow. Unfortunately this is not a platform where we create code from scratch to solve your problems, can you share any code you've already written and point out where you're having issues? If your code is working but you think it is inefficient, I would suggest looking at the Code Review stack exchange.
– Christian Scillitoe
Nov 13 '18 at 20:08
add a comment |
5
Hi Chris, welcome to Stack Overflow. Unfortunately this is not a platform where we create code from scratch to solve your problems, can you share any code you've already written and point out where you're having issues? If your code is working but you think it is inefficient, I would suggest looking at the Code Review stack exchange.
– Christian Scillitoe
Nov 13 '18 at 20:08
5
5
Hi Chris, welcome to Stack Overflow. Unfortunately this is not a platform where we create code from scratch to solve your problems, can you share any code you've already written and point out where you're having issues? If your code is working but you think it is inefficient, I would suggest looking at the Code Review stack exchange.
– Christian Scillitoe
Nov 13 '18 at 20:08
Hi Chris, welcome to Stack Overflow. Unfortunately this is not a platform where we create code from scratch to solve your problems, can you share any code you've already written and point out where you're having issues? If your code is working but you think it is inefficient, I would suggest looking at the Code Review stack exchange.
– Christian Scillitoe
Nov 13 '18 at 20:08
add a comment |
1 Answer
1
active
oldest
votes
try to divide your problem into different steps.
The first step could be to get familiar with a library to access your excel file. The one i tend to use is "openpyxl". To find out how to get data from an excel file you can use this link: https://openpyxl.readthedocs.io/en/stable/optimized.html.
I am new here aswell and i found out that you should first make an affort to try yourself and afterwards people will be very helpful.
After you found out how to get the data from excel to python you could provide some of it. That would make it easier to understand your problem. I hope i could help you a bit.
answered Nov 13 '18 at 20:15
FlowFlow
358
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53288667%2fuse-python-to-find-groups-of-consecutive-numbers-in-excel%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
try to divide your problem into different steps.
The first step could be to get familiar with a library to access your excel file. The one i tend to use is "openpyxl". To find out how to get data from an excel file you can use this link: https://openpyxl.readthedocs.io/en/stable/optimized.html.
I am new here aswell and i found out that you should first make an affort to try yourself and afterwards people will be very helpful.
After you found out how to get the data from excel to python you could provide some of it. That would make it easier to understand your problem. I hope i could help you a bit.
answered Nov 13 '18 at 20:15
FlowFlow
358
add a comment |
try to divide your problem into different steps.
The first step could be to get familiar with a library to access your excel file. The one i tend to use is "openpyxl". To find out how to get data from an excel file you can use this link: https://openpyxl.readthedocs.io/en/stable/optimized.html.
I am new here aswell and i found out that you should first make an affort to try yourself and afterwards people will be very helpful.
After you found out how to get the data from excel to python you could provide some of it. That would make it easier to understand your problem. I hope i could help you a bit.
answered Nov 13 '18 at 20:15
FlowFlow
358
add a comment |
try to divide your problem into different steps.
The first step could be to get familiar with a library to access your excel file. The one i tend to use is "openpyxl". To find out how to get data from an excel file you can use this link: https://openpyxl.readthedocs.io/en/stable/optimized.html.
I am new here aswell and i found out that you should first make an affort to try yourself and afterwards people will be very helpful.
After you found out how to get the data from excel to python you could provide some of it. That would make it easier to understand your problem. I hope i could help you a bit.
answered Nov 13 '18 at 20:15
FlowFlow
358
try to divide your problem into different steps.
The first step could be to get familiar with a library to access your excel file. The one i tend to use is "openpyxl". To find out how to get data from an excel file you can use this link: https://openpyxl.readthedocs.io/en/stable/optimized.html.
I am new here aswell and i found out that you should first make an affort to try yourself and afterwards people will be very helpful.
After you found out how to get the data from excel to python you could provide some of it. That would make it easier to understand your problem. I hope i could help you a bit.
answered Nov 13 '18 at 20:15
FlowFlow
358
answered Nov 13 '18 at 20:15
FlowFlow
358
answered Nov 13 '18 at 20:15
FlowFlow
358
answered Nov 13 '18 at 20:15
FlowFlow
358
358
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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.
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%2fstackoverflow.com%2fquestions%2f53288667%2fuse-python-to-find-groups-of-consecutive-numbers-in-excel%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
5
Hi Chris, welcome to Stack Overflow. Unfortunately this is not a platform where we create code from scratch to solve your problems, can you share any code you've already written and point out where you're having issues? If your code is working but you think it is inefficient, I would suggest looking at the Code Review stack exchange.
– Christian Scillitoe
Nov 13 '18 at 20:08