Closed

Python Script to compare rows in CSV

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.

Skills: Python, Software Architecture

See more: script compare xls files, php script form data csv, compare delete csv entries, compare two csv files python pandas, compare two csv files for differences in python pandas, python compare two csv files and return the difference, compare two csv files and remove duplicates python pandas, compare two large csv files for differences python, compare two csv files and remove duplicates python, python compare columns in two csv files, compare two rows in python, script copy folders csv file, script parse html csv, perl script mysql imort csv, script export xls csv, script import access csv files, script fetch particular column values csv file perl, python script convert xml csv, python script data extraction csv, python script compare audio file

About the Employer:
( 0 reviews ) London, United Kingdom

Project ID: #21082684

43 freelancers are bidding on average £21 for this job

vano101

Hello I have almost 3 years of experience with Python, including working with CSV files I checked requirements and it looks quite easy to complete

£15 GBP in 2 days
(931 Reviews)
7.4
jacklin1990

Hello, I can complete your project exactly. I have experiences with Python for more than 10 years. My skills are relevant to your job. If you want me to do this project, please contact me. Thanks. Regarding.

£15 GBP in 7 days
(15 Reviews)
6.6
kaloyan13

I have done Python scripts that process CSV files. Your logic can be implemented for 1-2 hours time.

£20 GBP in 1 day
(89 Reviews)
5.9
anupkelkar02

I am a Python data science expert with experience in Classification and partitioning,Nureal Networks, Association rules. Also I am a Oracle Certified professional (OCP) with experience in Oracle,MySQL, SQL Server and More

£30 GBP in 3 days
(46 Reviews)
6.0
dungforever

Hi. ⭐⭐⭐ I can complete your project in 3 hours⭐⭐⭐ I've read your requirements carefully. I understood your requirement and I have full experience in this area. I am a certified freelancer with great ideas & methodologi More

£15 GBP in 1 day
(89 Reviews)
6.0
ironstar20311

(✿◠‿◠) Hello, sir! I am happy to put my bid on your project. I have a full of experience in csv data processing in Python. I have finished many projects like this. I promise I will do your project with high quality. I More

£25 GBP in 1 day
(51 Reviews)
5.0
osmanaydin

Hello sir, Please take a look at my reviews and portfolio. I have completed data related jobs for many times. I am interested in your project as well. I would like to discuss details via pm. I look forward to hearing More

£100 GBP in 1 day
(31 Reviews)
5.2
mrbrave

Hi, Its easy to create spreadsheet in Excel to analyze CSV file to get result you like. If you still like in python, then thats ok [login to view URL] still easy to create script in python using libraries. I am available for eit More

£20 GBP in 1 day
(37 Reviews)
4.8
phantom1222

Hello, How are you? I have read all your requirement. I have rich experience with Python/Web Scraping and I can help you perfectly. I'm very interested in your job post.I believe my skills would be ideal for your proje More

£20 GBP in 1 day
(13 Reviews)
4.7
vw7534121vw

Hello, Your problem can be solved with a few lines of Pandas ([login to view URL]) - read the CSV file into a Pandas dataframe - separate the dataframe into two parts: - one with all rows where Period=Tot More

£25 GBP in 1 day
(5 Reviews)
4.4
rajorshi1001

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.

£15 GBP in 1 day
(17 Reviews)
4.2
asifkhan268

Hi there, I see you are looking for someone to create a python script to extract list of products where total should not be equal to the sum of all 4 weeks. After reading your project's description and checking att More

£14 GBP in 1 day
(9 Reviews)
4.0
Techiedev

Hi, I have good experiences developing code in Python Programming language for scientific application and Machine learning projects for more than 3 years. I think your task can be implemented easily with using Pandas l More

£15 GBP in 1 day
(15 Reviews)
4.0
IshaqKN

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

£15 GBP in 1 day
(2 Reviews)
3.5
rajeshpal007

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

£20 GBP in 7 days
(6 Reviews)
3.6
iffi37

hi i would love to do your task. i 'll do unlimited revisions till satisfactorily completion of your [login to view URL] for your response

£15 GBP in 7 days
(10 Reviews)
3.6
shahinrahimi

hi, good day, could you share me more details, I can help you to solve your problem. I have rich experience in python (web app, windows app, web scrapping,....), and I do my best to save your time and pocket. Please fe More

£20 GBP in 1 day
(7 Reviews)
3.6
noureldinyosri

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)

£10 GBP in 1 day
(5 Reviews)
3.0
msunij93

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.

£15 GBP in 1 day
(6 Reviews)
3.1
parvindarb

Hi, This seems like a easy project. I have worked on many projects using python to handle CSV, excel files. I can get you a nifty GUI tool that does not require python installation and gets your job done. This tool can More

£20 GBP in 3 days
(3 Reviews)
2.9