CSV Database updation/manipulation using Python
- or -
Post a project like this2045
$50/hr
- Posted:
- Proposals: 5
- Remote
- #2122149
- Awarded
Description
Experience Level: Expert
Estimated project duration: less than 1 week
There's a large csv file with 5000+ rows. I want to select 8 items matching each item and write them in a column. The matching process will be by conditional in incremental steps with fallback criteria. Something like -
Try this - Match A and B if (value of column X in A and matches value in column X of B), Else Match A and C and so on.
For each ID (PID) I want to show 8 related IDs based on the value matching in the other columns. I have attached the logic of doing the work manually and XLSX sheet with one example of the manual output for one PID. This has to be done using conditional statements in the script. I would need the script in 2.7.x with comments and not an executable file.
Try this - Match A and B if (value of column X in A and matches value in column X of B), Else Match A and C and so on.
For each ID (PID) I want to show 8 related IDs based on the value matching in the other columns. I have attached the logic of doing the work manually and XLSX sheet with one example of the manual output for one PID. This has to be done using conditional statements in the script. I would need the script in 2.7.x with comments and not an executable file.
Rahul R.
100% (4)Projects Completed
5
Freelancers worked with
3
Projects awarded
33%
Last project
21 Sep 2019
India
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies