Kapalı

CSV file cleansing

We have a CSV file which has some fields that contains words that are all in uppercase. We would like to process the CSV file changing some of the entries to lower and uppercase, and leaving some as they are.

The first step would be to analyse 4 columns of the CSV file to determine a list of unique words. We would then decide which of these words become upper and lower case and which stay the same.

Once the list has been compiled, the words that we have requested to be changed should be changed and copy of the CSV file made available for download.

Here is an example:

In one field, we have:

BROTHER TN155 BLACK TONER HL4040 HL4050 HIGH YIELD

In this case the words we would like to change would be:

BROTHER, BLACK, TONER, HIGH, YIELD

They should be changed to:

Brother, Black, Toner, High, Yield

So the field content would now be:

Brother TN155 Black Toner HL4040 HL4050 High Yield

If any other field that contains BROTHER, BLACK, TONER, HIGH, YIELD should also be changed to lowercase.

Attached in an example of the CSV file that the columns that need analysing are D, E, F and I

We would like the system to learn the changes, so we could provide a list of words to change based on a list of unique words. Then if when another CSV file is uploaded for cleansing and there are new words added, the system should ask if they need to be changed or not and save the response for the next file upload.

Please ask any questions by PM.

Thanks for taking the time to read this post.

Beceriler: MySQL, PHP

Daha fazlasını görün: remove special characters from csv file, csv file opens with data in a single column, csv cleaner online, remove quotes from csv file excel, repair csv file online, csv cleanup utility, clean csv file python, how to remove unwanted commas from a .csv file, php download csv file script, csv file curl download, php post csv file, download csv file database using php, post csv file, php download csv file yahoo finance, post entries csv file web link

İşveren Hakkında:
( 131 değerlendirme ) Bassendean, Australia

Proje NO: #15191383

52 freelancer bu iş için ortalamada 180$ teklif veriyor

in 5 gün içinde210$ AUD
(880 Değerlendirme)
8.5
mascotindia123

Hey Friend, We are 14 person team of developer, designer and tester provide you excellent services. Relevant Skills and Experience Myself having has 10 + years experience of web site development. Expert in Custom pr Daha fazlası

in 4 gün içinde220$ AUD
(217 Değerlendirme)
7.2
mantislin

Hi sir, This is kimi and I checked fill description, yes I can do this for you and can start right now. Thanks, Kimi Relevant Skills and Experience PHP MYSQL Proposed Milestones $155 AUD - full payment

in 3 gün içinde155$ AUD
(203 Değerlendirme)
7.0
tranngocanh1702

I am able to analyze the CSV files with text, split into words, change from upper case to lower case. I am ready to start now. Relevant Skills and Experience I am Anna with more than 5 years experience in PHP, Laravel Daha fazlası

in 5 gün içinde250$ AUD
(72 Değerlendirme)
6.8
Vlzinch

Hi! I can create python script that will read csv, create list of uniq words, that read rule for each word and create updated csv. Relevant Skills and Experience More then 7 years if experience in data science, dozen Daha fazlası

1 gün içinde 210$ AUD
(14 Değerlendirme)
6.0
princevenkat

I am MCA gradurade i am experienced in excel please give an chance i will give you the good result thankd

in 3 gün içinde220$ AUD
(8 Değerlendirme)
6.2
versacode

We are a group of electrical engineers and web developers. I understand that you would like a PHP script that analyzes the CSV file and changes the text as explained and we can help you do so. Relevant Skills and Expe Daha fazlası

1 gün içinde 200$ AUD
(78 Değerlendirme)
6.0
swapnilchavan18

I can do this program to clean csv, within 1 day. can we discuss. Thanks Relevant Skills and Experience php mysql Proposed Milestones $150 AUD - Initial Milestone

1 gün içinde 150$ AUD
(62 Değerlendirme)
6.4
Starlight05

Hello, i checked the attachment carefully and got it clearly. And therefore could provide cleansing application to you. Relevant Skills and Experience i am strong in php, mysql, database programming, excel macro, exce Daha fazlası

in 3 gün içinde250$ AUD
(46 Değerlendirme)
5.9
Attractionnet

Hello. I can write a program in vb.net for this. I have written many similar programs. You will just have to add the file, choose words and run it. It will have a database to store everything. Relevant Skills and Expe Daha fazlası

in 2 gün içinde155$ AUD
(83 Değerlendirme)
5.8
morfsys

Greetings! I see that you want contents of a CSV files to be modified based on certain keywords. If these keywords are present in the CSV, then they should be re-written as Abcde instead of ABCDE Relevant Skills and Daha fazlası

in 3 gün içinde150$ AUD
(53 Değerlendirme)
5.8
in 3 gün içinde155$ AUD
(21 Değerlendirme)
5.3
acecoder84

Hello, I have gone through your project and understood the requirement. I will be able to create the script which will read the CSV and will make necessary changes to the CSV file. Relevant Skills and Experience I am Daha fazlası

in 3 gün içinde100$ AUD
(46 Değerlendirme)
5.5
prakash2813

Hi there, I have read the details and checked the attached csv file. Its an easy job for me. Matter of some hours. Message me, Relevant Skills and Experience Have a look at my profile for portfolios and past work expe Daha fazlası

in 0 gün içinde260$ AUD
(21 Değerlendirme)
5.2
Hatembenarfa

Hey there, Open it through excel, replace the required words with the new words, won't take a minute. Goodluck

in 3 gün içinde111$ AUD
(7 Değerlendirme)
5.3
engmalaa

A proposal has not yet been provided

in 30 gün içinde1100$ AUD
(29 Değerlendirme)
4.9
in 3 gün içinde250$ AUD
(13 Değerlendirme)
4.9
khemrajfreelance

i seen your csv file, message me for discussion Relevant Skills and Experience php, wordpress Proposed Milestones $155 AUD - csv field updation by script

in 3 gün içinde155$ AUD
(26 Değerlendirme)
4.7
monillo

Hi I can write a small PHP script to convert the csv file as you wrote. I can be used for you later on new files. Habilidades y experiencia relevante PHP, Parsing Htos propuestos $100 AUD - Happy client

in 2 gün içinde100$ AUD
(8 Değerlendirme)
5.0
guptaabhinav

Expert python developer with experience of over 100 projects and masters in Data science. Contact me

1 gün içinde 111$ AUD
(2 Değerlendirme)
4.0