Em Andamento

Scraping 1 input csv file to 4 output csv files for "bag of words" matrices

I have a .csv Excel spreadsheet over 40,000 rows and three relevant columns. The first is an ID. The second and third are title text and body text for each of the rows. I am looking for someone to create "bag of words" .csv's in the following manner. Needed 4 csv files

1) First csv Just using title text only from all 40k rows or so where each column is a unique word and the entries are the # of occurrences.

2) Second csv same thing except for body text (should be a wider matrix).

3) Third csv is combining the title & body texts as one.

4) 4th csv just title text with single words as columns and also 2-word phrases as columns. For example "The cats are cats." would be columns called: the, cats, are, the cats, cats are, are cats. The entries would be 1, 2, 1, 1, 1, 1.

Each csv is a matrix. We are willing to award this and do it very quickly. Preference will be given to speed, ability to get rid of "garbage words" or periods at end of word (., the, a, etc.), and in general anyone with experience doing this. Anyone who has good ideas of how to make the matrices cleaner are also very welcome too, for example, reducing words to their roots (booked or books --> book). We are open to new ideas too.

Thank you! File will be sent once project accepted.

(Third csv just concatenates the title text and body text. So, title = "The Cats" and body = "The cats are cats." would have counts 2 for the, 3 for cats, 1 for are.

Habilidades: Processamento de Dados, Processamento de dados, Java, Captura de dados na web

Ver mais: java project ideas, how do i get data entry experience, looking for a book title, csv spreadsheet, how to get data entry experience, spreadsheet input, roots, how to award, garbage one, Data matrix, bag, project input output, spreadsheet csv, open input file, excel create input output, text file scraping, data scraping word, csv excel text, java data matrix, word csv, csv text file, bag words, data matrix java, csv file input, java output file

Acerca do Empregador:
( 3 comentários ) Portland, United States

ID do Projeto: #5117108

Premiar a:

Faylixe

Hi. I have a master degree in software engineering and working as engineer in a company specialized in data mining and NLP. Your query is quite simple. I can provided a Java solution that with process your CSV in Mais

$111 USD em 3 dias
(5 Avaliações)
2.4

32 freelancers estão ofertando em média $165 para este trabalho

samitXI

Hi Sir, I am ready to work for you.I have 9 years of experience in C/C++ , java, PHP and, MySQL. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within Mais

$154 USD in 3 dias
(121 Comentários)
6.9
mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$230 USD in 5 dias
(99 Comentários)
6.4
uumairkhalid

Hi.. Expert web scraper/Data Minor here. Interested in your project. I assure you 100% accurate and good quality work. I have too too scraping experience. let me know if you want sample before awarding. lets start. Reg Mais

$157 USD in 3 dias
(75 Comentários)
6.1
pandey2008

Hello sir,i have 8 member team and good experience plz give us one chance we will do our [url removed, login to view] you

$105 USD in 3 dias
(100 Comentários)
5.6
best4best

If you provide few sample rows of csv file, I will show you 4 converted csv files according to the project description for your review.

$155 USD in 3 dias
(82 Comentários)
5.6
weng0000

Good day! I can help you provide an application using vb.net or c#. I am ready to start. Thanks and regards, Weng

$333 USD in 3 dias
(8 Comentários)
5.5
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at my feedback to know more about me and my work. Waiting for more details along with posi Mais

$88 USD in 3 dias
(71 Comentários)
5.5
fhasanbd

Hi dear sir, I can do this for [url removed, login to view] refer to PMB for details. I graduated as cum laude with 5 years extensive experience in data entry, web search, webscraping, mining and lead generation. As well as 3 years exp Mais

$526 USD in 5 dias
(66 Comentários)
5.3
proauthor

Dear employer, I can easily create the matrix as per your requirement. Plese send in more details to proceed with the project. Looking forward to working with you. Awaiting positive reply. Also, I use java Mais

$99 USD in 3 dias
(31 Comentários)
5.2
priyal1997

Happy to discuss details.. ;-)) .......................................................................................................................................................................

$150 USD in 3 dias
(33 Comentários)
4.7
nicky789

Hi, I am Nicky I have experience in analysis data like web scrapping, filter and present data in MS word... and I feel interested in this smart project. I have done a lot of projects on freelancer with best comm Mais

$300 USD in 6 dias
(2 Comentários)
4.6
elMancha

Hello I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I'm exper Mais

$100 USD em 1 dia
(24 Comentários)
4.4
Virtualworker50

Respected Sir, It would be pleasure for me to render my services to you for making 4 different csv files from one main csv file according to given criteria. I am an advance level user of excel and fully understand y Mais

$175 USD in 30 dias
(47 Comentários)
4.3
vietitdotinfo

Hi. I am very interested in this project. I have exp in working with csv, excel files. I have done alot of similar projects. I am ready to do for you. Thanks!

$50 USD em 1 dia
(12 Comentários)
4.3
csharpdotnettech

sir i have understood the concept, what u need is frequency of the words from the columns of the csv file with 40k rows csv 1 wil use 2nd column as input, csv 2 wil use 3rd column as input, csv 3 will make combine u Mais

$150 USD in 3 dias
(6 Comentários)
4.0
fattahaabdul

I will create "bag of words" .csv's. I know a trick for it.I have read all your 4 points and it is very easy for me to do [url removed, login to view] us start

$421 USD in 10 dias
(4 Comentários)
3.9
rahulrahangdale

Hello Sir I am a data and research specialist, with over 4 years of experience. My moto is simple: Excellence and 100% cllient satisfaction. My areas of work include - Product Uploading on most of backends Like Mais

$250 USD in 15 dias
(8 Comentários)
3.7
inoussakabore

I am a statistician engineer working as a data manager and analyst there is 4 years. i am ready to do your job

$210 USD in 3 dias
(2 Comentários)
3.3
KnightLight

Hi please provide me this opportunity i will provide you each file soon and once it has been completed i will use java programming to traverse each row and will form all 4 csv from that Let me know if you have an Mais

$100 USD em 1 dia
(2 Comentários)
3.1
zExcel

Hey, I can help you with this and can start right away, but I need to see the file to give you an estimate on how long it should take

$122 USD em 1 dia
(6 Comentários)
3.1