you will have to write a code in python capable of perform a task over a microsoft excel spreadsheet, which is given attached. Basicaly you have three tables, table 1 contains expected result, while table 2 contains equations to be applied, and table 3 conditions that modify results calculated in table 2.
on table two you will find two equations to determine the curves. which equation to use depends upon value of b. If b = 0, then equation is shown in cell u5. If 0<b<=1 then the equation should be found in cell r4.
table 3 will modify values calculated by equations, following these rules: if value on table 3 is 1, nothing is modified. If value is 4, then value is modified to zero, and if value is 3, value is modified by a constant equals to the cell above. Take a look at column T to better understand as well as lines 4 and 5.
21 freelanceria on tarjonnut keskimäärin 21$ tähän työhön
HI, I am data scientist and have good experience in python and R programming. My area of interest is statistical Analysis of dataset and apply ML/deep learning algorithm. I can intern your tasks. Kind Regards
Hi I'm an expert. If you hire me, i won't let you down. I can provide you all these things with unlimited revisions till the satisfactorily completion of [login to view URL] you
No problem - I will write a python script that takes in tables 2 and 3 as a CSV file and outputs a new CSV file that is table 1. It's quite straightforward, should take ~ 1 hour to complete.