Ditutup

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

Kemahiran: Pemprosesan Data, Excel, MySQL

Lihat lebih lanjut: excel sql keywords, sql 2012, sort excel, report sql, want excel, groups , excel data sorting, groups list, excel selection list, sql keyword, data table excel, excel find select, script excel sql, sql tool, use keywords, simply data excel, excel sorting, sql problem, project achieve excel, excel check, excel table word, excel group list, script sql table, excel list example, data excel objective

Tentang Majikan:
( 25 ulasan ) Montreal, Canada

ID Projek: #4035145

22 pekerja bebas membida secara purata $345 untuk pekerjaan ini

omtechnologies

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

$300 USD dalam 5 hari
(37 Ulasan)
6.4
deepbluetech

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

$250 USD dalam 3 hari
(148 Ulasan)
5.6
bigdognec

This can be done using a database like MySql

$300 USD dalam 7 hari
(42 Ulasan)
5.1
pierreho

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

$250 USD dalam sehari
(27 Ulasan)
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 dalam 2 hari
(10 Ulasan)
4.7
techvolcano

We can do this beautifully.

$250 USD dalam 5 hari
(12 Ulasan)
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 Lagi

$250 USD dalam sehari
(14 Ulasan)
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 Lagi

$250 USD dalam 5 hari
(11 Ulasan)
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 Lagi

$250 USD dalam 2 hari
(7 Ulasan)
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 dalam 0 hari
(6 Ulasan)
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 dalam sehari
(6 Ulasan)
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 Lagi

$500 USD dalam 3 hari
(3 Ulasan)
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 dalam 3 hari
(5 Ulasan)
2.7
pbq

questions in pmb

$250 USD dalam 3 hari
(1 Ulasan)
2.5
mirondan

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

$400 USD dalam 5 hari
(0 Ulasan)
0.0
ksharpvw

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

$250 USD dalam 2 hari
(0 Ulasan)
0.0
viacor

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

$430 USD dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
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 dalam 30 hari
(0 Ulasan)
0.0
venkatreddyc

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

$650 USD dalam 10 hari
(0 Ulasan)
0.0