Closed

Need advice from someone who is an expert in Excel VBA, SOLR, Elasticsearch for which would be the best way to organize data through scraping

Please note: this project is only for ADVISING – so should not take more than 1-2 hours of your time. If you’re interested in actual implementation of this, please message separately BUT FOR NOT ONLY BID FOR ADVICE.

Need advice from someone who is an expert in Excel VBA, SOLR, Elasticsearch for which would be the best way to organize data through scraping

1. We have around 2000 categories (3rd level, Level 1 is around 12 only) for our internal website

2. We have a “historical database” (excel file) of over half a million items sold, each item showing which of the 2000 categories it belongs to, fields such as Brand, Model, city/state/country, serial number, year of manufacture, etc.

What we want to do:

1. We want to “scrape” over a 100 other “source sites” which offer the same items and list them as an “aggregator” website.

2. Each of these source sites have their own category structure, and number of categories can vary from none to a couple of hundred, but substantially less than our 2000. The OBJECTIVE is to map each of their items to one of our (3rd level) 2000 categories.

I don’t have experience in data analysis or programming, hence am relying on freelancers to create my product. I would like someone who is an expert in this to advice which would be the best way to go about doing this. Without being an expert, and with my limited understanding and research, I have some insights (which, mind you, may be naïve or amateurish) on how to go about doing this and here’s a one pager: [login to view URL]

I would like you to create a similar brief document of a few pages on what you feel would be the best way to go about achieving the OBJECTIVE stated above.

Skills: Apache Solr, Elasticsearch, Excel VBA, Software Architecture, Web Scraping

See more: freelance jobs for core java, java freelance work project, java freelance jobs, freelance java developer jobs india, freelance html jobs, best freelance sites for java developers, html jobs in freelancer, how to get java projects from clients, excel vba programing expert, excel vba expert resume, expert excel vba, become expert excel vba, excel vba expert dashboard, salary excel vba expert, best best excel vba expert, freelance excel vba expert switzerland, excel vba expert phildelphia, excel vba tutorial expert, excel vba expert needed, excel vba expert needed write application

About the Employer:
( 160 reviews ) San Ramon, United States

Project ID: #17650195

12 freelancers are bidding on average $106 for this job

waema

as i understand u need to scrap websites with different category than your site and import their data into your own categories. I don't think u need vba for this. The scraping bot will take care of all their categories More

$150 USD in 3 days
(85 Reviews)
6.6
schoudhary1553

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 390 + projects with 100% client satisfaction. I can help you More

$250 USD in 4 days
(41 Reviews)
6.2
vmadhavan15

BUT FOR NOT ONLY BID FOR ADVICE... I have 16 years of expertise with various project exposure.. Please ping me if you are interested with my proposal and thank you..

$55 USD in 3 days
(16 Reviews)
4.6
$111 USD in 1 day
(15 Reviews)
4.5
DarkKnight2206

I am a python developer.\nI have great experience in web scraping and I am an expert in it.\nI have all necessary skills by which I can scrape any website. I have even scraped sites like google, whatsapp web, etc. whic More

$250 USD in 2 days
(18 Reviews)
4.8
superbpartner

Hi,dear. I've just checked all requirements of your project 'Need advice from someone who is an expert in Excel VBA, SOLR, Elasticsearch for which would be the best way to organize data through scraping'. I'm a senior More

$155 USD in 1 day
(3 Reviews)
3.6
mtdevil369

Dear client, please share further details. The accuracy and timely delivery will be ensured. All the requirements will strictly be met.i will start now.. Looking Forward

$68 USD in 1 day
(8 Reviews)
2.9
dataexplorer

"Hi, I have just gone through your project description and reviewed everything. Yes, I’m able to work as per your instructions in your "Need advice from someone who is an expert in Excel VBA, SOLR, Elasticsearch for More

$30 USD in 5 days
(3 Reviews)
1.8
nehameshram13

Hello Client, I have read your requirement about -an expert in Excel VBA, SOLR, Elasticsearch and I am sure I can complete it as per the given description. I do have skills like Software Architecture, Web Scra More

$51 USD in 3 days
(0 Reviews)
0.0
$55 USD in 2 days
(0 Reviews)
0.0
sakhawat2

Hi, I read the one-pager you've written. I've got to say, you spoke very little of yourself in the job description. You actually have the majority of the correct concept, if not all. I have edited the file with s More

$50 USD in 3 days
(0 Reviews)
0.0
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I feel fit myself for this project. please contact with me. Thanks.

$45 USD in 1 day
(0 Reviews)
0.0