I want to essentially get a list of all the items where the total does not match the sum of the weekly items.
The column headers of the csv are Name, Type, EMPID, Year, Period, UniqueID, and Value. In the ideal scenario, the logic in the script should return instances where -- when the its the same EmpID and the same year and the same uniqueID and the same Name and the same Type -- ** then Total Should NOT equal to (week 1 + week 2 + week 3 + week 4)**
If the total equals the sum of the weekly items, we dont want that.
I'm getting confused when i have to diff against the total values and the sum of the weekly rows.
38 freelancers are bidding on average £20 for this job
Hi, I am a python developer and I can write a script to compare the shell values according to your logic and give the output. I can complete this task within an hour.
Hi, This is something very easy for me; just call me out, I am there to help. Much experience in data processing. Thank you! Relevant Skills and Experience Python, CSV, Data Processing, Logic
Hi, I read your description but it still leaves some questions, if you can clear the doubts in the chat and share a sample file we can get started right away.
Hi, I am a python expert. Having 12 years of experience in Python, C, Shell Scripting and Linux. Have delivered many projects in Python. Thanks, Rajesh Pal
Hello, I have a strong on pandas background (CSV parser) & Python can help you complete this project, check my Freelance profile and my portfolio (Github). [login to view URL] Greetings Emely S
hey, this task is pretty easy and I can finish it in half an hour max, I have +9 years python experience and you can view my past work on my github (link in my profile page)