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.
Activity for sfrowâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Comment | Post #285244 |
Thanks for the proposal Alexei, I will try it! Also I think from here I can try:
https://pandas.pydata.org/pandas-docs/stable/user_guide/merging.html (more) |
— | almost 3 years ago |
| Edit | Post #285244 | Initial revision | — | almost 3 years ago |
| Question | — |
Comparing two excel files with Python based on changes I have two tables: Table1: | Name| Description | Amount| | --- | --- | --- | | 123 | Description123 | 123 | | 456 | Description456 | 456| | 789 | Description789 | 666| | 101 | Description777 | 101 | | 133 | Description133 | 133 | Table2: | Name| Description | Amount| | --- ... (more) |
— | almost 3 years ago |
| Comment | Post #284806 |
First time when I run it took me almost 1 hour, but I found that the file contain several wrong data in the column and this cause the problem for the long run. (more) |
— | about 3 years ago |
| Comment | Post #284806 |
I will try it. When we are talking for so many rows I think it will give us some improvement of the process time. (more) |
— | about 3 years ago |
| Comment | Post #284806 |
Actually you are right. For 10k rows it's taking 14 seconds, which is not so bad. For the whole list of 300k it will take 7-8 minutes. (more) |
— | about 3 years ago |
| Edit | Post #284806 |
Post edited: |
— | about 3 years ago |
| Edit | Post #284806 |
Post edited: |
— | about 3 years ago |
| Edit | Post #284806 | Initial revision | — | about 3 years ago |
| Question | — |
Python looping 300 000 rows Based on my last question comes new one. How to loop over 300 000 rows and edit each row string one by one? 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`. I use the code below to loop to test the s... (more) |
— | about 3 years ago |
| Edit | Post #284805 |
Post edited: |
— | about 3 years ago |
| Edit | Post #284805 |
Post edited: |
— | about 3 years ago |
| Edit | Post #284805 | Initial revision | — | about 3 years ago |
| Answer | — |
A: Separate digits of a number in groups with different sizes I found a way how to fix it after I debug. It was only using the last used row because there was nothing to check that I want to edit only the current row. That's why I decide to use `at` ```Python for index, row in priceListTest.iterrows(): #print(index,row) def getslices(n, sizes, nd... (more) |
— | about 3 years ago |
| Comment | Post #284804 |
Your answer is amazing. I will spend time to check everything that you comment and explain. Thank you! (more) |
— | about 3 years ago |
| Edit | Post #284803 | Initial revision | — | about 3 years ago |
| Question | — |
Separate digits of a number in groups with different sizes 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: Python implementation If you notice... (more) |
— | about 3 years ago |