All Questions
41
questions
0
votes
4
answers
74
views
Remove Date from slugs in an excel file with Python script
I am having a hard time figuring out how to remove the date from the end of a slug for an excel file that I am trying to clean up to automate a process for one of our tasks.
Here is what the slugs ...
- 9
-1
votes
1
answer
25
views
How can I create a table where my inputs in one column spit out an assigned “code” for that text in another column?
I want to create a table that basically converts the text from one column into a specific code in another column. For example, I have a “rock type” column and a “geology code column”. If I type “SAND” ...
1
vote
1
answer
577
views
XlsxWriter adding random character (@) when writing formula [duplicate]
I am trying to write formulas to an xlsx document using XlsxWriter in Python.
What I am trying to write to a cell is:
=SUM(IF($F$5:$F$130=$F$4,I$5:I$130))
But when I try to use XlsxWriter to insert ...
- 35
1
vote
0
answers
411
views
Is it possible to convert 'dynamic' excel formulas to python code?
Is it possible to convert excel formulas to python code? For example:
"=TEXT(SORT(PROPER(UNIQUE(FILTER("
"ws_1!A:A,ws_2!B:B=ws_3!C3"
')))), ""...
0
votes
1
answer
97
views
Python and Excel Formula
Complete beginner here but have a specific need to try and make my life easier with automating Excel.
I have a weekly report that contains a lot of useless columns and using Python I can delete these ...
1
vote
1
answer
608
views
openpyxl: how to refer a cell in another sheet inside a combination of formula using OFFSET and INDIRECT functions
I am trying to automate quiz grading for trainees. The steps we follow are as follows:
pull quiz data from ODKaggregate server as a CSV file and save it in xlsx format
Load the data in python (I am ...
- 11
0
votes
1
answer
59
views
How do I read in a Formula in Excel and convert it to do the computation in Python?
I have a table of time-series data downloaded from some system. Say it is the revenue data for different persons across time. Eg below
**Table 1**
| | Jan 1999| Feb 1999|Dec 1999|
|----- | -------...
- 373
0
votes
1
answer
359
views
Inserting formula with Blank in excel using openpyxl python
I am trying to insert a formula in excel sheet using openpyxl package. The code is as shown below.
wb = openpyxl.load_workbook('Review.xlsx')
ws = wb.get_sheet_by_name('Final')
for i, cellObj in ...
- 39
0
votes
0
answers
36
views
How can we add sheet to excel workbook with formula?
I want to add a new sheet to already existing workbook.
Issue I am facing is the workbook has some formulas present in it. On reading workbook with pandas the formulas are removed and I get values.
...
1
vote
1
answer
253
views
Formula to find if a set of values in excel column is out of range
There are certain values in a column in excel, like
108
108.7
2657
35678
4563
108.8
108.9
108.95
How in excel formula or python can we mark the cells with number out of range like in the above case ...
- 73
0
votes
1
answer
604
views
Python and CSV with formulae
I have a CSV file with formulae, like this:
1;;2.74;0
=A1+C1;=A2;=C1
What's the best way to convert formulae into numbers, as follows
1;;2.74;0
3.74;3.74;2.74
?
The only way I know is to read it ...
- 57
0
votes
0
answers
63
views
Merging excel files to one workbook calculated fields not populating in final workbook output
I am appending several excel workbooks into 1 workbook. The generated output populates non-calculated fields however columns where data is derived from a formula in the original workbook do not ...
- 1
0
votes
2
answers
948
views
Python - Openpyxl - Add formula to column and repeat formula to last row of data
Trying to do the following:
In column G add the following formula:
"=ACOS(COS(RADIANS(90-D2)) *COS(RADIANS(90-D3)) +SIN(RADIANS(90-D2)) *SIN(RADIANS(90-D3)) *COS(RADIANS(E2-E3))) *6371"
...
- 1
-1
votes
1
answer
301
views
Is there any module I can use in python to calculate like how i use T.INV.2T in excel?
I want to calculate this excel formula in Python : T.INV.2T(1-D25;9999999999). The result in excel is : 2,57582940
is there any package or example in Python I can try to calculate this formula? thank ...
- 1
-1
votes
1
answer
874
views
Python and double quotes formulas to excel
I all.
I have a problem to insert a formula in exce cell.
I have this dictionary
di_count = {'Vacation Count': '=COUNTIF(E6:NF6;"V")',
'Permit Count': '=AVERAGE(E6:NF6)',
}
...
