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

38 freelancers are bidding on average £20 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
(991 Reviews)
7.5
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
(104 Reviews)
6.1
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
(49 Reviews)
6.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
(35 Reviews)
5.5
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
(36 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
(42 Reviews)
5.0
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
(20 Reviews)
5.2
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
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
(16 Reviews)
4.4
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
(31 Reviews)
4.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
(33 Reviews)
4.7
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
(13 Reviews)
4.5
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
(27 Reviews)
4.7
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
(16 Reviews)
4.2
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
(6 Reviews)
3.4
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
emely001

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

£70 GBP in 2 days
(6 Reviews)
3.0
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
(6 Reviews)
3.1
Graphs02

Hello there! I'd like to make a contribution and help you out with your project because I have experience working with Python whether is web or desktop development as well as creating and maintaining APIs therefor More

£20 GBP in 7 days
(5 Reviews)
2.3
lizojob

Hi, I'm a Python developer, based on the description, I can deliver this in a few hours. Please message me so we can discuss this further. Thank you, Job

£20 GBP in 1 day
(3 Reviews)
2.8