{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "![title](https://i.ytimg.com/vi/Cgu5y-6VWfo/maxresdefault.jpg)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# On va nous déménager: un cas d’intelligence de localisation pour compare locations entre Paris, Lyon et Marseille\n", "\n", "
\n", " | venue.name | \n", "venue.id | \n", "venue.categories | \n", "venue.location.lat | \n", "venue.location.lng | \n", "
---|---|---|---|---|---|
0 | \n", "La Tour d'Argent | \n", "4adcda11f964a520da3521e3 | \n", "French Restaurant | \n", "48.849791 | \n", "2.354950 | \n", "
1 | \n", "Restaurant AT | \n", "5342fcff498e1d32177cc21b | \n", "Japanese Restaurant | \n", "48.849628 | \n", "2.354654 | \n", "
2 | \n", "Au Moulin à Vent | \n", "4d3898babb0d721ea09c55e3 | \n", "French Restaurant | \n", "48.848504 | \n", "2.354937 | \n", "
3 | \n", "Grand Action | \n", "4b8a75d1f964a520a96d32e3 | \n", "Indie Movie Theater | \n", "48.847614 | \n", "2.352291 | \n", "
4 | \n", "5ème Cru | \n", "4b5474d4f964a520e9bb27e3 | \n", "Wine Bar | \n", "48.849066 | \n", "2.354118 | \n", "
5 | \n", "Boulangerie La Parisienne | \n", "4e58cf2bd164da2b275956ff | \n", "Bakery | \n", "48.849949 | \n", "2.349760 | \n", "
6 | \n", "Bonvivant | \n", "5530cc1f498ea6903c33a3da | \n", "Wine Bar | \n", "48.847551 | \n", "2.351969 | \n", "
7 | \n", "Anahuacalli | \n", "4adcda14f964a520fe3621e3 | \n", "Mexican Restaurant | \n", "48.849907 | \n", "2.350409 | \n", "
8 | \n", "Diptyque | \n", "4adcda21f964a520b93921e3 | \n", "Miscellaneous Shop | \n", "48.849589 | \n", "2.351653 | \n", "
9 | \n", "Strada Café | \n", "54842e01498ee191fa3c80e8 | \n", "Café | \n", "48.847038 | \n", "2.351278 | \n", "
\n", " | name | \n", "price_tier | \n", "likes | \n", "
---|---|---|---|
0 | \n", "La Tour d'Argent | \n", "{'tier': 3, 'message': 'Expensive', 'currency'... | \n", "120 | \n", "
1 | \n", "Restaurant AT | \n", "{'tier': 2, 'message': 'Moderate', 'currency':... | \n", "50 | \n", "
2 | \n", "Au Moulin à Vent | \n", "{'tier': 3, 'message': 'Expensive', 'currency'... | \n", "16 | \n", "
3 | \n", "Grand Action | \n", "Not Available | \n", "41 | \n", "
4 | \n", "5ème Cru | \n", "{'tier': 2, 'message': 'Moderate', 'currency':... | \n", "27 | \n", "
5 | \n", "Boulangerie La Parisienne | \n", "{'tier': 1, 'message': 'Cheap', 'currency': '€'} | \n", "125 | \n", "
6 | \n", "Bonvivant | \n", "{'tier': 2, 'message': 'Moderate', 'currency':... | \n", "41 | \n", "
7 | \n", "Anahuacalli | \n", "{'tier': 1, 'message': 'Cheap', 'currency': '€'} | \n", "97 | \n", "
8 | \n", "Diptyque | \n", "Not Available | \n", "25 | \n", "
9 | \n", "Strada Café | \n", "{'tier': 1, 'message': 'Cheap', 'currency': '€'} | \n", "287 | \n", "
10 | \n", "Aux Merveilleux de Fred | \n", "Not Available | \n", "24 | \n", "
11 | \n", "Collège des Bernardins | \n", "Not Available | \n", "34 | \n", "
12 | \n", "Bar à Iode | \n", "{'tier': 3, 'message': 'Expensive', 'currency'... | \n", "21 | \n", "
13 | \n", "Le Buisson Ardent | \n", "{'tier': 3, 'message': 'Expensive', 'currency'... | \n", "36 | \n", "
14 | \n", "La Maison d'Isabelle | \n", "{'tier': 1, 'message': 'Cheap', 'currency': '€'} | \n", "29 | \n", "
\n", " | name | \n", "price_tier | \n", "likes | \n", "
---|---|---|---|
9 | \n", "Strada Café | \n", "Cheap | \n", "287 | \n", "
5 | \n", "Boulangerie La Parisienne | \n", "Cheap | \n", "125 | \n", "
0 | \n", "La Tour d'Argent | \n", "Expensive | \n", "120 | \n", "
7 | \n", "Anahuacalli | \n", "Cheap | \n", "97 | \n", "
1 | \n", "Restaurant AT | \n", "Moderate | \n", "50 | \n", "
3 | \n", "Grand Action | \n", "None | \n", "41 | \n", "
6 | \n", "Bonvivant | \n", "Moderate | \n", "41 | \n", "
13 | \n", "Le Buisson Ardent | \n", "Expensive | \n", "36 | \n", "
11 | \n", "Collège des Bernardins | \n", "None | \n", "34 | \n", "
14 | \n", "La Maison d'Isabelle | \n", "Cheap | \n", "29 | \n", "
4 | \n", "5ème Cru | \n", "Moderate | \n", "27 | \n", "
8 | \n", "Diptyque | \n", "None | \n", "25 | \n", "
10 | \n", "Aux Merveilleux de Fred | \n", "None | \n", "24 | \n", "
12 | \n", "Bar à Iode | \n", "Expensive | \n", "21 | \n", "
2 | \n", "Au Moulin à Vent | \n", "Expensive | \n", "16 | \n", "
\n", " | name | \n", "id | \n", "categories | \n", "lat | \n", "lng | \n", "
---|---|---|---|---|---|
0 | \n", "Place des Jacobins | \n", "4b61baf8f964a520361f2ae3 | \n", "Plaza | \n", "45.760489 | \n", "4.833636 | \n", "
1 | \n", "Place des Célestins | \n", "4b61bb38f964a5203f1f2ae3 | \n", "Plaza | \n", "45.759804 | \n", "4.831842 | \n", "
2 | \n", "Place de la République | \n", "4cbfe494021ca1438bf15e0c | \n", "Plaza | \n", "45.760347 | \n", "4.835635 | \n", "
3 | \n", "Slake Coffee House | \n", "5602838f498e9111e2522df3 | \n", "Café | \n", "45.760922 | \n", "4.832910 | \n", "
4 | \n", "Marché Saint-Antoine | \n", "4c304d6a66e40f470f65c38b | \n", "Farmers Market | \n", "45.761756 | \n", "4.831853 | \n", "
5 | \n", "Mozzato - Comptoir à Mozzarella | \n", "526038cd11d2d0efdb9f407f | \n", "Italian Restaurant | \n", "45.761697 | \n", "4.832963 | \n", "
6 | \n", "Place Bellecour | \n", "4b5e0a3df964a520817a29e3 | \n", "Plaza | \n", "45.757523 | \n", "4.832397 | \n", "
7 | \n", "Théâtre des Célestins | \n", "4b8a84caf964a520567032e3 | \n", "Theater | \n", "45.759769 | \n", "4.831996 | \n", "
8 | \n", "L'Épicerie - Bistrot à Tartines | \n", "4b6ef616f964a52068d32ce3 | \n", "Restaurant | \n", "45.761931 | \n", "4.832668 | \n", "
9 | \n", "Pignol Patissier & Restaurant | \n", "5066b98416482fabcf2082b4 | \n", "Dessert Shop | \n", "45.758589 | \n", "4.832523 | \n", "
\n", " | name | \n", "price_tier | \n", "likes | \n", "
---|---|---|---|
0 | \n", "Place des Jacobins | \n", "Not Available | \n", "198 | \n", "
1 | \n", "Place des Célestins | \n", "Not Available | \n", "38 | \n", "
2 | \n", "Place de la République | \n", "Not Available | \n", "127 | \n", "
3 | \n", "Slake Coffee House | \n", "{'tier': 1, 'message': 'Cheap', 'currency': '€'} | \n", "148 | \n", "
4 | \n", "Marché Saint-Antoine | \n", "Not Available | \n", "77 | \n", "
5 | \n", "Mozzato - Comptoir à Mozzarella | \n", "{'tier': 2, 'message': 'Moderate', 'currency':... | \n", "64 | \n", "
6 | \n", "Place Bellecour | \n", "Not Available | \n", "516 | \n", "
7 | \n", "Théâtre des Célestins | \n", "Not Available | \n", "26 | \n", "
8 | \n", "L'Épicerie - Bistrot à Tartines | \n", "{'tier': 2, 'message': 'Moderate', 'currency':... | \n", "185 | \n", "
9 | \n", "Pignol Patissier & Restaurant | \n", "{'tier': 1, 'message': 'Cheap', 'currency': '€'} | \n", "23 | \n", "
10 | \n", "Mercure Lyon Centre Beaux-Arts | \n", "Not Available | \n", "44 | \n", "
11 | \n", "Best Bagels Company | \n", "{'tier': 2, 'message': 'Moderate', 'currency':... | \n", "74 | \n", "
12 | \n", "MOS - Maker of Stories | \n", "{'tier': 1, 'message': 'Cheap', 'currency': '€'} | \n", "6 | \n", "
13 | \n", "Gangnam | \n", "{'tier': 2, 'message': 'Moderate', 'currency':... | \n", "10 | \n", "
14 | \n", "La Voûte Chez Léa | \n", "{'tier': 3, 'message': 'Expensive', 'currency'... | \n", "7 | \n", "
\n", " | name | \n", "price_tier | \n", "likes | \n", "
---|---|---|---|
6 | \n", "Place Bellecour | \n", "None | \n", "516 | \n", "
0 | \n", "Place des Jacobins | \n", "None | \n", "198 | \n", "
8 | \n", "L'Épicerie - Bistrot à Tartines | \n", "Moderate | \n", "185 | \n", "
3 | \n", "Slake Coffee House | \n", "Cheap | \n", "148 | \n", "
2 | \n", "Place de la République | \n", "None | \n", "127 | \n", "
4 | \n", "Marché Saint-Antoine | \n", "None | \n", "77 | \n", "
11 | \n", "Best Bagels Company | \n", "Moderate | \n", "74 | \n", "
5 | \n", "Mozzato - Comptoir à Mozzarella | \n", "Moderate | \n", "64 | \n", "
10 | \n", "Mercure Lyon Centre Beaux-Arts | \n", "None | \n", "44 | \n", "
1 | \n", "Place des Célestins | \n", "None | \n", "38 | \n", "
7 | \n", "Théâtre des Célestins | \n", "None | \n", "26 | \n", "
9 | \n", "Pignol Patissier & Restaurant | \n", "Cheap | \n", "23 | \n", "
13 | \n", "Gangnam | \n", "Moderate | \n", "10 | \n", "
14 | \n", "La Voûte Chez Léa | \n", "Expensive | \n", "7 | \n", "
12 | \n", "MOS - Maker of Stories | \n", "Cheap | \n", "6 | \n", "
\n", " | venue.name | \n", "venue.id | \n", "venue.categories | \n", "venue.location.lat | \n", "venue.location.lng | \n", "
---|---|---|---|---|---|
0 | \n", "La Caravelle | \n", "4b5b300ef964a520b1e928e3 | \n", "[{'id': '4bf58dd8d48988d116941735', 'name': 'B... | \n", "43.296535 | \n", "5.372060 | \n", "
1 | \n", "Starbucks (Starbucks Coffee) | \n", "4bea370a61aca593e7908300 | \n", "[{'id': '4bf58dd8d48988d1e0931735', 'name': 'C... | \n", "43.297847 | \n", "5.372830 | \n", "
2 | \n", "InterContinental Marseille Hôtel-Dieu | \n", "50d1943ae4b0fff6c391682b | \n", "[{'id': '4bf58dd8d48988d1fa931735', 'name': 'H... | \n", "43.298661 | \n", "5.369779 | \n", "
3 | \n", "Les Buvards | \n", "4bc57ecfccbcef3b1399e6d2 | \n", "[{'id': '4bf58dd8d48988d123941735', 'name': 'W... | \n", "43.297783 | \n", "5.371368 | \n", "
4 | \n", "Galeries Lafayette | \n", "4bbdf9ce078095218635db91 | \n", "[{'id': '4bf58dd8d48988d1f6941735', 'name': 'D... | \n", "43.296544 | \n", "5.374758 | \n", "
\n", " | name | \n", "id | \n", "categories | \n", "lat | \n", "lng | \n", "
---|---|---|---|---|---|
0 | \n", "La Caravelle | \n", "4b5b300ef964a520b1e928e3 | \n", "Bar | \n", "43.296535 | \n", "5.372060 | \n", "
1 | \n", "Starbucks (Starbucks Coffee) | \n", "4bea370a61aca593e7908300 | \n", "Coffee Shop | \n", "43.297847 | \n", "5.372830 | \n", "
2 | \n", "InterContinental Marseille Hôtel-Dieu | \n", "50d1943ae4b0fff6c391682b | \n", "Hotel | \n", "43.298661 | \n", "5.369779 | \n", "
3 | \n", "Les Buvards | \n", "4bc57ecfccbcef3b1399e6d2 | \n", "Wine Bar | \n", "43.297783 | \n", "5.371368 | \n", "
4 | \n", "Galeries Lafayette | \n", "4bbdf9ce078095218635db91 | \n", "Department Store | \n", "43.296544 | \n", "5.374758 | \n", "
5 | \n", "Terrasse de l'InterContinental Marseille Hôtel... | \n", "51bc60145019f457c9e71423 | \n", "Roof Deck | \n", "43.298463 | \n", "5.369761 | \n", "
6 | \n", "Capian Bar | \n", "51ad0479498eafba19f59d33 | \n", "Cocktail Bar | \n", "43.298360 | \n", "5.369721 | \n", "
7 | \n", "Spa de l'InterContinental Marseille Hôtel-Dieu | \n", "51bc5f505019f457c9e67182 | \n", "Spa | \n", "43.298510 | \n", "5.369782 | \n", "
8 | \n", "Hôtel la Résidence du Vieux-Port | \n", "4bd0b48ba8b3a593b770645f | \n", "Hotel | \n", "43.296483 | \n", "5.372727 | \n", "
9 | \n", "Vanille Noire | \n", "53f87ce2498ecc0a79b29359 | \n", "Ice Cream Shop | \n", "43.297199 | \n", "5.368588 | \n", "
\n", " | name | \n", "price_tier | \n", "likes | \n", "
---|---|---|---|
1 | \n", "Starbucks (Starbucks Coffee) | \n", "Expensive | \n", "147 | \n", "
2 | \n", "InterContinental Marseille Hôtel-Dieu | \n", "None | \n", "126 | \n", "
4 | \n", "Galeries Lafayette | \n", "None | \n", "101 | \n", "
0 | \n", "La Caravelle | \n", "Moderate | \n", "96 | \n", "
13 | \n", "Amorino | \n", "Cheap | \n", "69 | \n", "
12 | \n", "Au Cœur du Panier | \n", "None | \n", "51 | \n", "
5 | \n", "Terrasse de l'InterContinental Marseille Hôtel... | \n", "None | \n", "27 | \n", "
9 | \n", "Vanille Noire | \n", "Cheap | \n", "21 | \n", "
10 | \n", "La Fabrique | \n", "Expensive | \n", "20 | \n", "
11 | \n", "Cup of Tea | \n", "Moderate | \n", "19 | \n", "
14 | \n", "Une Table Au Sud | \n", "None | \n", "19 | \n", "
3 | \n", "Les Buvards | \n", "Moderate | \n", "17 | \n", "
8 | \n", "Hôtel la Résidence du Vieux-Port | \n", "None | \n", "14 | \n", "
6 | \n", "Capian Bar | \n", "Expensive | \n", "12 | \n", "
7 | \n", "Spa de l'InterContinental Marseille Hôtel-Dieu | \n", "None | \n", "12 | \n", "