Excel data manipulation + scraping

Closed - This job posting has been filled and work has been completed.

Job Description

We would like to create a database for calling clients.
We are creating the database based on erento.de website and existing excel files which were scraped from erento.de

We would need to have the following data manipulations made on this file:

A. Pull the city name from column E , it is located between the postal code and the word Deutschland
locate the city name in column F.

B. Insert the state of each city.
You can create a list of cities and states from this link for instance:
locate the state names in column F.

C. insert the the category and the subcategory and sub sub category of each company on erento.
the category and the subcategory are showing at the url of the item advertised by the company:

One idea how to get the category of the company:
Google "Erento" + "company name " (from the excel) and pull the the category and the subcategory and sub sub category from the url.
here is a video:
other methods are also welcome.

Open Attachment

Other open jobs by this client