Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »

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)
over 2 years ago
Edit Post #285244 Initial revision over 2 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)
over 2 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)
over 2 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)
over 2 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)
over 2 years ago
Edit Post #284806 Post edited:
over 2 years ago
Edit Post #284806 Post edited:
over 2 years ago
Edit Post #284806 Initial revision over 2 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)
over 2 years ago
Edit Post #284805 Post edited:
over 2 years ago
Edit Post #284805 Post edited:
over 2 years ago
Edit Post #284805 Initial revision over 2 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)
over 2 years ago
Comment Post #284804 Your answer is amazing. I will spend time to check everything that you comment and explain. Thank you!
(more)
over 2 years ago
Edit Post #284803 Initial revision over 2 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)
over 2 years ago