Advise a CEO of a video game studio with the search for a suitable work area in California with geolocation tools.
As a CEO of a video game studio I want a new workspace in California, USA since my business has grown as well as the number of employees, so I need to relocate the headquarters in order to be able to place my employees in a wide place, easy to reach in any kind of transportation and with enough space to place new employees.
• Close to public transportation such as bus or subway. • That the location is in California. • Close to other video game studios, in the city where there are more studios.
To provide an ideal area in California where offices are available, close to public transportation stations. With evidence such as maps with the location and price of the places and info plots.
- I made a query from the companies.json database with pymongo retriving only the videogames companies in California.
- Look for the city that has the most videogames company and easy public transportation.
- Get a heatmap to locate the zone that has the most videogames studios and compare it with a map of the public transportation.
- Pin all the videogames studios on the map to get a notion of the density.
- Finding available offices in the selected city by webscrapping sites with offices rent service and filtering by size.
- Extract the information from the site.
- Get the latitude and longitude of the available offices by webscrapping google maps.
- Cleaning data of available offices and exporting it to a csv.
- Generate a map with the available offices pined and with the detail of street, size and price.
- Generate a map with the videogames studios and the available offices for comparison.
- Export an info table by street, occupancy and price.
- Data visualization by interactive plots.
• The blue pins are the occupied offices. • The red pins are the available offices, and you can see the detail of the office if you click the pin. • The heatmaps show the density of the zones of occupied offices.
The companies json can be downloaded from the link: https://drive.google.com/file/d/1z7UdvlV9-RNouduz6mGlbez89NwFpyco/view?usp=sharing