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.
Hi there,
I am expert in data processing; and have worked with excel files much. And performing such task is no problem to me.
Best regards,
Ishaq
Relevant Skills and Experience
Python, Data Processing, Process Automation, Excel
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 am an expert in python. I have worked on various projects involving data processing between excel sheets and python. I would be very interested in helping you with this project. Let me know if you are interested. Thanks
Hi,
There is problem while downloading attached file can you reattach it ?
Based on what you describe about the project it can be easily done with in a day. Please inbox me so we can discuss further looking forward to work with you.
As i am a newfreelancer and this being my first project ,i will do this project with atmost interest and dedication .
Relevant Skills and Experience
I am doing my b-tech and had 4 years of programming experience,
At present i am dealing with data science with python, hope this project helps me.
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.
Dear Client,
I've read your job description and I wanted to apply for this project. I have good experience in data analysis using python. I can guarantee a high quality deliverable in time you need just please contact me so we can discuss further details.
I wish to hear from you soon,
Thank You!