Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
I have a list of 11-digit numbers stored in one single column in Excel, and I need to separate the digits according to this pattern: 2-2-1-3-3. Example: 00002451018 becomes 00 00 2 451 018. How c...
#3: Post edited
by
Alexei
·
2021-11-09T06:07:26Z (over 2 years ago)
added the question from own answer in the original post
- I have a list of 11-digit numbers stored in one single column in Excel, and I need to separate the digits according to this pattern: `2-2-1-3-3`.
- Example: `00002451018` becomes `00 00 2 451 018`.
How can I do it in Python?
- I have a list of 11-digit numbers stored in one single column in Excel, and I need to separate the digits according to this pattern: `2-2-1-3-3`.
- Example: `00002451018` becomes `00 00 2 451 018`.
- How can I do it in Python?
- I have tried the following:
- 
- If you notice the last column new Value is getting only from the last row. Which is ending with 416. Somehow I want inside of this to update and create a new column to contain for each row the updated pattern.
#2: Post edited
by
hkotsubo
·
2021-11-08T17:36:54Z (over 2 years ago)
Improve title, make text more concise, add tags
Transform number in specific pattern in Python
- Separate digits of a number in groups with different sizes
I have a list of numbers stored in one single column in Excel.<br>All numbers are 11 digit length.<br>For example 00002451018 I need to transform it in this specific pattern 00 00 2 451 018.<br>The pattern is 2-2-1-3-3.<br>How can I do it in Python?<br><br>Thanks in advance!
- I have a list of 11-digit numbers stored in one single column in Excel, and I need to separate the digits according to this pattern: `2-2-1-3-3`.
- Example: `00002451018` becomes `00 00 2 451 018`.
- How can I do it in Python?
#1: Initial revision
by
sfrow
·
2021-11-08T14:53:36Z (over 2 years ago)
Transform number in specific pattern in Python
I have a list of numbers stored in one single column in Excel.<br> All numbers are 11 digit length.<br> For example 00002451018 I need to transform it in this specific pattern 00 00 2 451 018.<br> The pattern is 2-2-1-3-3.<br> How can I do it in Python?<br> <br> Thanks in advance!