All Questions
81 questions
3
votes
2
answers
188
views
Excel sheet manipulation program
I'm very new to programming, and I'm hoping I can get feedback on the code I wrote - anything is helpful - what to split into different files (right now 1 large file), perhaps a way to break up the <...
- 33
2
votes
1
answer
240
views
Python using generators with Excelwriter - Performance
I'm looking to understand if my code has an obvious blockage or performance pain point that will cause it to operate slower or use more memory than it should.
The current Excelfile i am processing ...
- 131
0
votes
2
answers
143
views
Optimize a Python code which indicates duplicated values in an excel file [closed]
I wrote this code to indicate duplicated values. It actually works but I hope to know if there's another possible solution to optimize this process. Thanks.
...
- 77
1
vote
1
answer
137
views
Using Pandas to group data based on name and see if column value is greater than or equal to values based on group names
As you'll see from the below code, I'm creating separate data frames of a much larger data frame, then updating a column for each one. What I'm doing is looking at the second column and checking to ...
- 173
3
votes
1
answer
164
views
Update an Excel master workbook with values from new workbook
I have a master .xlsx file on which other spreadsheets depend. Each week, I export a new .xlsx file (from MRP) that may or may not be the same as the master. The columns are always identical. Rows may ...
- 33
2
votes
1
answer
125
views
Gathering data from a file and analyzing it
Recently started learning python, and it's quite a difference coming from C and knowledge taught in CS1. Overall, I am trying to build a team building script for my summer side-project (probably will ...
- 23
3
votes
1
answer
103
views
Python data entry into excel based on equality check with dataframe
My objective is to enter/type in values into Excel cells if the column names and indices match between Excel and dataframe.
So, my code does the below
Gets the ID values from the dataframe
for each ...
- 247
1
vote
1
answer
189
views
Python - Efficiently pick random data from an array, generate random UUIDs and save it all in an Excel table
I wrote the following prototype:
...
- 205
3
votes
1
answer
352
views
Transposing an Excel sheet with pandas adding additional information for a different readability - Using Fake Pizzeria Data
The goal is to transpose the excel file that comes in the following form
into this
The code I created works properly, but I think it can be improved.
I would also like to avoid using ...
- 599
3
votes
1
answer
83
views
Reading from Excel, performing geospatial analysis and writing to Excel files
I have written a Python snippet that reads lat and long stored in an Excel file. It converts them to a point which is then used to perform multiple geospatial analysis including buffer, intersection, ...
- 31
3
votes
1
answer
116
views
Load multiple worksheets from Excel file to multiple DataFrames
The spreadsheet can be found just above the references section at this link.
https://www.sciencedirect.com/science/article/pii/S1872497316301429
It's a publication for STR DNA locus frequencies to ...
- 301
5
votes
0
answers
954
views
safexl - A Python / pywin32 Excel Application wrapper
Thanks in advance for your interest in my first PyPI project.
While there happen to be a number of projects out there to help with creating & consuming Excel workbooks, I was unable to find one ...
- 86
3
votes
1
answer
4k
views
Python script for refreshing and preprocessing data in Excel report files
I wrote some code to create marketshare reports. However, I'm sure it can be improved. The tasks performed are:
Open the global data file, refresh the data, import its content as a DF.
Create a backup ...
2
votes
1
answer
420
views
Finding matches in Excel files, adding to a Pandas Dataframe
I have a business requirement where I have to read excel files and match each cell with a given keyword list and find the matches and write it into a dataframe.
I have written the code, but when the ...
- 131
2
votes
0
answers
314
views
Optimizing the openpyxl program
Purpose of the code:
Let's say I have 3 excel files to deal with.
Those file have already been filtered or hidden because the content is very large. And I only need part of the content for every ...
- 61