Lukket

Groups Keywords in Excel or SQL

Hello,

First thing, I'm not sure what is the best tool / script to achieve what I want to do. I guess that either Excel or SQL should do the job. If you need something else, there should not be a problem if its relatively easy to use.

The objective of the project is to be able to sort a list containing many keywords (many thousands). Here is exactly what I need

1. The script will analyze all the keywords in the list and report a table with the TOP 100 keywords with the highest occurence. So let's say we have 3 keywords:

a. computer printer

b. computer supplies

c. computer printer supplies

The tool would report the following:

Computer : 3 occurences

Printer: 2 occurences

Supplies: 2 occurences

Computer Printer : 2 occurences

Computer supplies: 1 occurence

Computer printer supplies: 1 occurence

This is the first step. Figuring out what are the most popular words in the document.

2. Once we get the TOP 100 word, I want to be able to select among those 100, the ones I want to use, let's call them the Selected Groups. So some sort of Selection process where I check what i'm interested in. Per example i would select 1. Printer and 2. Supplies

3. I now want the tool to sort all the keywords in the Selected Groups according to what they contain. The tool would then output something like:

Group: Printer

- computer printer

Group: Supplies

- computer supplies

As you can see, the issue would be sorting the third word 'computer printer supplies' which would belong to both groups. We will simply use a rule that says that the keyword will belong to the first word we find in the keyword. So in the case of 'computer printer supplies' the first word to be found is 'Printer', the keyword would then be allocated to the Printer group.

4. Once this is done, most of the keywords should belong to a group. however some may not, so I want to know which ones

I need this asap, let me know if you need more details

Thanks,

Thomas




********* PROJECT IS CLOSED ****************

Færdigheder: Databehandling, Excel, MySQL

Se mere: excel sql keywords, what's the best job, what is sorting data, what is data sorting, what is word processing, Sql 2012, sort excel, report sql, i want to do excel, groups , excel to sql, excel or word , excel data sorting, analyze some data 3, groups list, excel selection list, sql keyword, data table excel, excel find select, script excel sql, sql tool, find excel job, use keywords, simply data excel, excel sorting

Om arbejdsgiveren:
( 25 bedømmelser ) Montreal, Canada

Projekt-ID: #4035145

22 freelancere byder i gennemsnit $345 for dette job

omtechnologies

Hi! Our PHP Experts can do this project for you professionally. Please check PMB for details.

$300 USD in 5 dage
(37 bedømmelser)
6.4
deepbluetech

I can take on the job and provide Excel macro based solution. Please confirm and provide sample data.

$250 USD in 3 dage
(148 bedømmelser)
5.6
bigdognec

This can be done using a database like MySql

$300 USD in 7 dage
(42 bedømmelser)
5.1
pierreho

Dear stimpsy1, Your need seems really simple to answer with excel. Please have a look on my PM.

$250 USD på 1 dag
(27 bedømmelser)
4.9
NiceDeveloper

Hi, I'll give you a windows desktop app that take your keywords and give you all reports. Check your inbox.

$250 USD in 2 dage
(10 bedømmelser)
4.7
techvolcano

We can do this beautifully.

$250 USD in 5 dage
(12 bedømmelser)
4.2
naveenvarthaan

Hi stimpsy1, I had done this already in Excel. So I can just fine tune it to suit you. I will send the tool in few minutes. Looking forward to start the work and send the file within 24 hours. File along with Mere

$250 USD på 1 dag
(14 bedømmelser)
4.2
renze

Thank you for the clear description of what you want. Some further detail will be needed to make sure that you get what you want. I am positive that we will be able to complete this succesfully. I propose to make go Mere

$250 USD in 5 dage
(11 bedømmelser)
3.7
parsermonster

Dear Project Manager, Your project description is very clear. I think I can help you, since your data is simple text. I'll use a custom app to extract the keywords and process them as you require. Regards, Mit Mere

$250 USD in 2 dage
(7 bedømmelser)
3.7
goodperlcoder

Hi! It's CLOSED? :( I can really do it for two hours.. (for server and/or desktop using). PMB me if also need

$250 USD in 0 dage
(6 bedømmelser)
3.7
rajanlengde

I can use the list in excel plus back end database for sorting logics. Final Output may go on Excel sheet. Please see PMB for details.

$250 USD på 1 dag
(6 bedømmelser)
3.6
R0b0t

Good Morning, This sounds like the perfect job for a custom access database. Data manipulation and analysis is my specialty. I do have a few questions concerning where the dataset will be coming from and how new d Mere

$500 USD in 3 dage
(3 bedømmelser)
3.1
petrovp

Dear stimpsy1, I am good in Data Processing and Excel and MySQL and can complete this project as soon as possible.

$250 USD in 3 dage
(5 bedømmelser)
2.7
pbq

questions in pmb

$250 USD in 3 dage
(1 bedømmelse)
2.5
mirondan

I can do this in SQL + a nice web application for managing and displaying the data like you want

$400 USD in 5 dage
(0 bedømmelser)
0.0
ksharpvw

It is easy for SAS. I know SAS very well.

$250 USD in 2 dage
(0 bedømmelser)
0.0
viacor

Hello, I can handle this job. I have the necessary conditions for it. Fluent in Excel.

$430 USD på 1 dag
(0 bedømmelser)
0.0
Fn9B85FKm

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. www.<b><i>Removed by [url removed, login to view] Admin for breaching our Terms and Conditions</i></b>.io

$500 USD på 1 dag
(0 bedømmelser)
0.0
christineherron

I understand the project and you need two programs one to search for words and the excel for sorting it sounds like it could be done it have done tasks like this before and have many years of administrative experience

$750 USD in 30 dage
(0 bedømmelser)
0.0
venkatreddyc

We will help you to build a script / tool around your needs

$650 USD in 10 dage
(0 bedømmelser)
0.0