Closed

Script to read, compare, amend and write CSV

We have a thriving online business, but do not want to ship to certain UK postal codes with our main courier (due to high costs of these outlying areas). We need to be able to process CSV files automatically without our staff needing to manipulate the data manually.

Ideally, the workflow will be as follows:

- Drag-and-drop CSV file into Windows folder (CSV IN, for instance)

- Script reads postal code data field and compares against a separate file (we have a list of postcodes in outlying areas). If match found, it appends postal code of source file to force error.

- Processed data is written to a new CSV file that is automatically placed in a different Windows folder location (where the shipping software will automatically pick it up and process)

Obviously I can provide greater detail as required. The only thing I'm unsure of is that the dataset to compare against may sometimes require only a partial match, but not always - see the attached file for an example of the dataset to check against.

Anyway, that's what I'm thinking! I'm sure it's possible with some kind of script that runs in the background, but am unsure of how to do this.

Skills: PHP, Python

See more: photo editing background removal software, zen cart different shipping location, download photo editing background removal software, white background remover software, freeware photo background removal software, image background removal software, remove background jpg software, oscommerce different shipping method different products, transparent video background flash software, separate shipping charges different items virtuemart, different software projects cnet different universities, different software projects cnet different universities pakistan, photo background removal software, jpeg transparent background free software, oscommerce shipping module different departments, background removal software, best background removal software, picture background removing software

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

Project ID: #21796091

51 freelancers are bidding on average £160 for this job

gobyweb2

Hi, Having handful of experience in PHP at its advanced level I can assist you with processing CSV files automatically without your staff needing to manipulate the data manually. Please share further details so I can More

£200 GBP in 2 days
(196 Reviews)
7.5
zekovicm

Hi there,I am Python expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this project ! I can start immediately and finish it within the agree More

£235 GBP in 3 days
(37 Reviews)
6.7
naravila

⭐⭐⭐Dear sir!⭐⭐⭐ I am honored to bid on your project. This is my development experience similar to your project. I'm a software developer with a wealth of Python development experience and willing to do my best to comp More

£200 GBP in 2 days
(44 Reviews)
6.4
valor312

VERY EASY FOR ME As you can see in my review, I've done similar with yours Hello. I have read your description and I am so interested in your project. I am confident in your project and I can finish it clearly on time More

£175 GBP in 7 days
(106 Reviews)
6.6
susanna2018

Hi, Client!! @$@$@$PLEASE CONTACT ME. I CAN DO IT WONDERFULLY.$@$@$@ ##% Your idea is attracted me to your world.%## I am Python expert. i have various skills. @@PLEASE GIVE ME CHANCE TO PROVE MY SKILLS@@ :-):-):-) More

£175 GBP in 7 days
(60 Reviews)
6.3
skfaroo123

Pro Python/Data processing/Math/Algorithm/ Machine Learning/AI Expert! Hi client. Once saw a your project, it was very attracted my mind because I am very interested in your project and also, have rich experiences and More

£250 GBP in 7 days
(26 Reviews)
6.1
MohanKumar28

Hi I have gone through the requirements. Will do this script using PHP and the cron job which runs automatically. I'm available to start now. Please share additional details. Regards, Mohan

£150 GBP in 3 days
(98 Reviews)
5.8
mananraja

hey, I understand your project details as I have read them and seen the attached file. I can make you a script to do this task automatically. Would love to discus a few details with you in chat.

£100 GBP in 1 day
(93 Reviews)
5.9
TopDesigner315

Hi there! My name is Shi J and I’m a professional developer with 7+ years of experience. I'm honesty, communicable, responsible and passionate about programming holding my hand on a pulse of a new technologies every More

£100 GBP in 2 days
(36 Reviews)
5.5
£180 GBP in 4 days
(47 Reviews)
5.5
imagicsoft

Hi! I am a software developer having great experience in Python and PHP I can achieve to build script so that reading, compare, amend, and writing There can be negotiations about the price according to your requiremen More

£200 GBP in 3 days
(23 Reviews)
5.4
ITPyramid85

Hello, I am software developer with enough experiences on PHP for 13 years. I can work by full time for your project and trying to satisfy the requirements. [login to view URL] [login to view URL] [login to view URL] More

£175 GBP in 7 days
(4 Reviews)
5.4
AlexanderPGR

Hello.. I have read your post very carefully and I have understood what you want. I am a 100% completion Developer. I have rich experiences in manipulating CSV by using Pandas. It is very simple for me. I can do More

£175 GBP in 7 days
(34 Reviews)
5.5
Pingduoduo

Hi. How are you?. I saw your description carefully and i 'm very interesting your project. I have rich experience in your proejct types, so i can do your project perfectly. If u would like to give me your project More

£100 GBP in 2 days
(20 Reviews)
5.4
StormLion227

Hello. My name is Marko and I am an Engineering Graduate with an MBA degree. I am a full time freelancer and I will work hard on this till completion. A Python Expert on freelancer.com and I do not bid on projects More

£194 GBP in 1 day
(48 Reviews)
5.3
maximwang8661

hello, how are you? I read you details and I have good experience(5 years) in skill similar your project. we can discuss in detail about project on chat. I will complete your project perfectly. best regards. I am watin More

£175 GBP in 7 days
(21 Reviews)
5.5
ayeilyurt

Hello, I have csv processing experience and I am thinking of using Python with Pandas library. I would like to see a sample file and more details on what you want. Please contact me for further discussion.

£235 GBP in 1 day
(9 Reviews)
4.8
shanymathew

Dear Sir am excellent in web development I can do this csv of postal code compare application perfectly and fastly very much interested in this project please reply Thank You

£120 GBP in 3 days
(50 Reviews)
4.7
mateenbhatti94

Dear sir I will write the script that will do these tasks and will write the csv with postal codes with errors by comparing with outling postal codes. I have been in this industry for 1 year and such jobs are my dail More

£150 GBP in 1 day
(21 Reviews)
4.8
FedericoRiva

Hi there! I'm interested in your project. We can do an executable script using python. That lists the files that are in a determinate folder using a database as memory of previously processed files just to avoid unnece More

£150 GBP in 7 days
(25 Reviews)
4.8