Find Jobs
Hire Freelancers

Excel data import

$30-250 USD

Dalam Kemajuan
Disiarkan lebih dari 11 tahun yang lalu

$30-250 USD

Dibayar semasa penghantaran
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
ID Projek: 4036084

Tentang projek

3 cadangan
Projek jarak jauh
Aktif 11 tahun yang lalu

Ingin menjana wang?

Faedah membida di Freelancer

Tetapkan bajet dan garis masa anda
Dapatkan bayaran untuk kerja anda
Tuliskan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan
Dianugerahkan kepada:
Avatar Pengguna
Hi, Thank you for invite.
$180 USD dalam 3 hari
5.0 (20 ulasan)
5.0
5.0
3 pekerja bebas membida secara purata $87 USD untuk pekerjaan ini
Avatar Pengguna
I can help you.
$30 USD dalam 0 hari
5.0 (12 ulasan)
3.8
3.8
Avatar Pengguna
I am expert in sql queries, I can do this using sql.
$50 USD dalam 1 hari
4.9 (3 ulasan)
3.4
3.4

Tentang klien

Bendera CANADA
Montreal, Canada
5.0
25
Kaedah pembayaran disahkan
Ahli sejak Mac 1, 2011

Pengesahan Klien

Terima kasih! Kami telah menghantar pautan melalui e-mel kepada anda untuk menuntut kredit percuma anda.
Sesuatu telah berlaku semasa menghantar e-mel anda. Sila cuba lagi.
Pengguna Berdaftar Jumlah Pekerjaan Disiarkan
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Memuatkan pratonton
Kebenaran diberikan untuk Geolocation.
Sesi log masuk anda telah luput dan telah dilog keluar. Sila log masuk sekali lagi.