Closed

Script to read, amend, and write a new CSV file.

We have a thriving online business, but changes to our courier's shipping software mean 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 recognises presence of file and parses data - amends column headers, writes extra column of data based on existing data, removes unnecessary columns. Then writes to new CSV file with appended filename (time and date added) in different Windows folder (CSV OUT, for instance)

Obviously I can provide greater detail as required.

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: read csv file using python script, script fetch particular column values csv file perl, read modify write csv file python, write list to csv python, python write list to csv column, python read csv and write to new file, python write list to csv row, write to csv file python, write csv python, python write csv example, python csv write to specific column, ksh script read csv file, read csv file table php script, script run mysql query write results csv file, csv file shell script read korn shell, read csv file java script, csv file read php script, read csv file update script, script read excel write mysql, visual basic script read write xml file

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

Project ID: #19187045

29 freelancers are bidding on average £163 for this job

zhangyingtai

Hello sir Thanks for job posting. I have fully understood the requirements. I can make a python script to do automatically all what you need. Looking forward to hearing from you soon. Best Regards, Yong More

£150 GBP in 3 days
(108 Reviews)
7.5
abugosia

Hello, I'm Abu Gosia. I'm interesting in your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

£244 GBP in 1 day
(141 Reviews)
6.7
seemasit

Hi, I read your project requirement carefully and I understand your project but I want to ask a few questions before mover further so that I can deliver you exact work with one shoot. I always deliver quality wit More

£372 GBP in 3 days
(60 Reviews)
6.9
Piao217

Hi I have rich experience in Python script development. I can develop it to transact with CSV easily. Please check my profile and past reviews. Let us discuss in more detail through chat. Thanks. Wang C.

£150 GBP in 3 days
(26 Reviews)
6.3
anuyadav1

i can write app which will check csv in folder and once csv file is dropped in it , it will update csv out file , this automation can be done via python or java .

£200 GBP in 3 days
(78 Reviews)
6.2
adampohp79

Hi sir Your job is exciting me. That is a very simple job for me. I can complete your job perfectly and plz check my profile in freelancer. I have 13 years experiment with python. Let me do this job for you now ju More

£222 GBP in 3 days
(63 Reviews)
6.1
ThanassisKalv

hi your automation task can be done efficiently with Python taking advantage of Pandas library. The script will recognize possible new columns and append them efficiently, the 'background' automation is also feasibl More

£100 GBP in 5 days
(98 Reviews)
6.0
yesikov1224

[login to view URL] Credit is my motto. I am expert web scraping. I can do your job with BS4 ,Perl script,Scrapy Seleinum framework of python. And You can know my skill as u see my profile. I can do any project in your demand More

£222 GBP in 3 days
(31 Reviews)
5.6
TSCreators

hi there , it can be possible to create script that run back ground by creating windows service i am ready to work on it kindly message me for discussion regards tscreators

£150 GBP in 3 days
(62 Reviews)
5.5
shantanupython

well i get the picture by what is given in the description script need to sun continuously in a loop it recognizes new csv presence in certain folder parses the data accordingly and creates new csv in specified folder More

£67 GBP in 3 days
(45 Reviews)
4.9
esolzpk

Hi! i have been developed similar project as you required, i managed complete inventory by uploading CSV file. here is my past work [login to view URL] [login to view URL] [login to view URL] [login to view URL] More

£150 GBP in 3 days
(15 Reviews)
5.4
osmanaydin

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

£100 GBP in 1 day
(33 Reviews)
5.1
martini002

Hello, I'm a software engineer & linux sysadmin. What I can offer you is a windows application, let me simulate you how it will work: 1. Open the application. 2. Select the IN folder(Will keep the last one you use More

£120 GBP in 3 days
(17 Reviews)
4.5
Prakhark19

Hello there, Myself Prakhar, i am working in python for last 3 years. I have read your description thoroughly and i am confident that i can do this easily. i have already created a file similar to that.....and can assu More

£30 GBP in 1 day
(20 Reviews)
3.7
PiushGoutam2018

Hi, I am interested in taking up your project. I have done 10+ projects in python software development,website development,desktop automation,website automation and web scraping,.I deliver fast,clean and quality work More

£33 GBP in 3 days
(17 Reviews)
3.4
goodwork20k

I am good in perl, php along with data conversion, for your requirement i can write perl script and give u the demo before delivery the code Please let me know if you are good to award this project to me

£168 GBP in 3 days
(3 Reviews)
2.4
cooddooc

I work till satisfaction for all my clients and do work more perfectly and clearly. I can work in full-time, 12+ hours /day and can work in your timezone. Also will keep good communication. Hope to meet your solution More

£150 GBP in 3 days
(5 Reviews)
2.5
mrehman29sl

Hello I have 5 years of development and automating experience,I. have designed and deployment multiple automation solutions for public cloud services provider I can deliver your project as per your requirements l More

£111 GBP in 2 days
(2 Reviews)
2.0
kostya1207

Hi. Think of your project as completed!!! Because I can complete it. I am python expert who regard credit as the most valued. I have 7+ years experience in python. If you hire me, I will satisfy you within limited More

£100 GBP in 3 days
(1 Review)
1.7
dnickel80

Hello there! Yes this is definitely doable with a script. Is this a Windows or Linux environment? Can you provide example of the original csv and example of what you need it to look like? I hope to hear from you

£166 GBP in 3 days
(1 Review)
1.0