Suoritettu

Find fields within a CSV and add a catagory - python/vbs/excel

Hi,

I basically have a csv file as input (sheet1). I have another list of key words broken into categories (sheet2). I need a way of automatically opening the csv sheet1 and searching through each line for the keywords listed in sheet 2. It must then add a field to the end of each line with either "no match" or "catagory A found" etc. Can be done in either excel/libre office/python, bash script etc.

More work to come too.

Taidot: Excel, Perl, Python, Shell Script, VB.NET

Näytä lisää: python find, find python, software write edid, free software write company profile, software write websites idea, software write book images, software write books, software write protection, free software write book, software write book, software write protect software, software write technical manual

Tietoa työnantajasta:
( 10 arvostelua ) Stafford, United Kingdom

Projektin tunnus: #9702024

Myönnetty käyttäjälle:

crazynightwalker

Hi! I can write an automatic program that will do the match for you. What should it display in case multiple keywords are found? Ready to go!

£15 GBP 1 päivässä
(23 Arvostelua)
4.3
Shusui

Hello, I have a bachelor in computer science and 5+ years coding experience. I've worked a lot with python in the past, for example in games, artificial intelligence agents, data processing scripts, among other applic Lisää

£11 GBP 1 päivässä
(1 arvostelu)
0.6

21 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

surekash7096

I have the expertise in Excel and experience in writing a similar search script in csv file. Ready to start work immediately.

£18 GBP 1 päivässä
(33 arvostelua)
4.5
kjgroup197318

-------------------Nice job. Best result in time.I am VBA expert----------------------------------------------------ac

£50 GBP 1 päivässä
(7 arvostelua)
3.8
£10 GBP 1 päivässä
(21 arvostelua)
3.6
mahmoudfawzi420

hey there , i'm a full stack developer with over 4 years of experience in the field , i already built similar python projects you can view my work history in python here on freelancer.com or on my other profile : Lisää

£18 GBP 1 päivässä
(2 arvostelua)
3.6
thuyduongrands

Dear Sir or Mardam, You need an accontant outsourcing for your job. I am a person who are good you needed I have over 10 years of experience and knowledge of accounting and good skill Office software. I have great expe Lisää

£33 GBP 1 päivässä
(4 arvostelua)
3.2
TechnoVilla

Dear Sir/Madam, I have over 8 years of work experience in Excel, Shell Script, VB.NET, PHP, MySQL, HTML, CSS, Javascript, jQuery, .NET, Bootstrap, C, C++, C# and so on... Please visit the links below to see so Lisää

£12 GBP 1 päivässä
(4 arvostelua)
2.7
levong

Hello Can do it in one day with python. Plust can generate an executable of the script, so that you can use it python independently. Looking forward for cooperation Lev

£20 GBP 1 päivässä
(2 arvostelua)
1.9
AmmarHafeez

Hi... I am a python expert and have done the projects involving python and csv files recently... You can share the files with me and i will finish the task in maximum 1 day... Looking forward to work with you...

£15 GBP 1 päivässä
(3 arvostelua)
1.9
dfrmex

Hi, I can help you. My choice for this work is awk, but python can also do the job very simple. Please contact me for details, Regards, David 30+ years C/Unix-HP-UX-Solaris-AIX/Linux programmer, performa Lisää

£18 GBP 1 päivässä
(4 arvostelua)
1.7
bhatkiran

I am software engineer with over 5 years of development experience. I can write and provide you a script that can help you merge the required information accurately.

£10 GBP 1 päivässä
(5 arvostelua)
1.7
£13 GBP 1 päivässä
(1 arvostelu)
1.6
ptkhoa1984

I've been working with Python for more than 3 years. The library CSV in python can help to do this project easily, I think.

£13 GBP 1 päivässä
(2 arvostelua)
1.3
kenildomadia

I am Data Analyist at Hubilo and currently have the job for performing data analysis and work with CSV files on daily basis. I think I can do this task confidently.

£13 GBP 1 päivässä
(0 arvostelua)
0.0
replybarbara

Summary Im a fully qualified MBA Finance with 6yrs. experience with financial business plans, financial modelling We can make your management fast and easy with date wise and time wise updates. Most of the compa Lisää

£18 GBP 1 päivässä
(0 arvostelua)
0.0
AgentBlackhat

Hi, I can do this using AutoIt which I have extensive experience in. AutoIt is a programming language specifically designed for automating tasks. I increased the price to £45 as sometimes these things are not as sim Lisää

£50 GBP 1 päivässä
(0 arvostelua)
0.0
sanjay2812

Will do it either in perl orr shell script. will take 2 days to do it. 1 days in buffer if project is some differ then my understanding.

£18 GBP 3 päivässä
(0 arvostelua)
0.0
spanichev

hello I am ready to try to solve your problem. I need your files for solutions.

£10 GBP 3 päivässä
(0 arvostelua)
0.0
£18 GBP 1 päivässä
(0 arvostelua)
2.2
omair104

Hello, I have been working on some similar stuff recently. I could write a python code that does the above tasks for you. How big are the excel sheets? Looking forward to hearing from you

£18 GBP 1 päivässä
(0 arvostelua)
0.0
£10 GBP 1 päivässä
(1 arvostelu)
0.0