================================================================================ AIRBNB DATASET — airbnb.csv ================================================================================ Shape: 5000 rows x 19 columns --- Dtypes --- name str city str property_type str price_numeric float64 price_category str rating float64 rating_category str bedrooms int64 bathrooms float64 guests_count int64 amenities_count int64 num_images int64 num_reviews float64 quality_score float64 is_superhost bool is_guest_favorite bool pets_allowed bool lat float64 long float64 --- Null counts --- name 0 ( 0.0%) city 0 ( 0.0%) property_type 0 ( 0.0%) price_numeric 1544 ( 30.9%) price_category 0 ( 0.0%) rating 810 ( 16.2%) rating_category 0 ( 0.0%) bedrooms 0 ( 0.0%) bathrooms 0 ( 0.0%) guests_count 0 ( 0.0%) amenities_count 0 ( 0.0%) num_images 0 ( 0.0%) num_reviews 725 ( 14.5%) quality_score 0 ( 0.0%) is_superhost 0 ( 0.0%) is_guest_favorite 0 ( 0.0%) pets_allowed 0 ( 0.0%) lat 0 ( 0.0%) long 0 ( 0.0%) --- Numeric summary --- price_numeric rating bedrooms bathrooms guests_count amenities_count num_images num_reviews quality_score lat long count 3456.000000 4190.000000 5000.000000 5000.000000 5000.000000 5000.000000 5000.000000 4275.000000 5000.000000 5000.000000 5000.000000 mean 1520.102228 4.799635 2.083600 1.277600 5.309600 44.917600 27.878400 62.748304 93.780360 46.241247 -72.673328 std 5491.179837 0.231128 1.529536 1.047644 3.367553 15.985441 19.211076 85.019557 41.944939 0.962092 3.267367 min 1.043410 2.250000 0.000000 0.000000 1.000000 3.000000 0.000000 0.000000 0.000000 45.012400 -79.487900 25% 125.000000 4.730000 1.000000 1.000000 2.000000 34.000000 14.000000 10.000000 94.500000 45.513773 -73.741125 50% 219.825000 4.860000 2.000000 1.000000 4.000000 45.000000 23.000000 33.000000 107.900000 45.943650 -73.559351 75% 1211.757500 4.960000 3.000000 2.000000 7.000000 56.000000 36.000000 82.000000 121.000000 46.811925 -71.268675 max 99950.000000 5.000000 25.000000 24.000000 16.000000 109.000000 199.000000 986.000000 139.800000 54.797600 -1.627760 --- Value counts: city --- Montreal 1141 Québec 299 Montréal 275 Mont-Tremblant 204 Gatineau 119 Longueuil 96 Petite-Rivière-Saint-François 67 Laval 53 Chertsey 51 Saint Come 49 Beaupré 46 Saguenay 45 Lac-Supérieur 45 Québec City 41 La Malbaie 40 Stoneham-et-Tewkesbury 39 Magog 37 Trois-Rivières 35 Shawinigan 33 Rimouski 32 Sherbrooke 31 Orford 30 Baie-Saint-Paul 29 Mont-Blanc 29 L'Anse-Saint-Jean 28 Saint-Ferréol-les-Neiges 28 La Conception 23 Brossard 23 Levis 22 Mille-Isles 22 Saint-Adolphe-d'Howard 22 Sutton 21 Sainte-Lucie-des-Laurentides 21 Amherst 21 Mandeville 20 Val-des-Monts 20 Bromont 20 Matawinie 20 Gaspe 19 Mansonville 18 Eastman 18 Saint-Alexis-des-Monts 18 Nominingue 17 Saint-Irénée 16 Sainte-Agathe-des-Monts 16 Pont-Rouge 15 Val-Morin 15 Village de Labelle 15 Les Éboulements 14 Saint-David-de-Falardeau 14 Quebec 14 Saint-Gabriel-de-Valcartier 14 Saint-Donat-de-Montcalm 14 Wentworth North 13 Entrelacs 13 Sainte-Béatrix 13 Rouyn-Noranda 13 Saint-Philémon 13 Château-Richer 13 Saint-Mathieu-du-Parc 12 Saint-Damien 12 Terrebonne 12 Gracefield 12 Matane 11 Notre-Dame-de-la-Merci 11 Val-David 11 Notre-Dame-des-Bois 11 Boischatel 10 Saint-Michel-des-Saints 10 Lac-Etchemin 10 Val-d'Or 10 Sainte-Adèle 10 Petite-Vallée 10 Dunham 10 Mirabel 10 Lac-Beauport 10 La Tuque 10 La Minerve 9 Shannon 9 Coaticook 9 Piedmont 9 Saint-Sauveur 9 Les Laurentides 9 Sainte-Anne-des-Monts 9 Sainte-Brigitte-de-Laval 9 Wakefield 9 Saint-Georges 8 Saint-Tite-des-Caps 8 Charlevoix 8 Saint-Jean-de-Matha 8 Cap-Chat 8 Sainte-Émélie-de-l'Énergie 8 Saint-Jean-Port-Joli 8 Sainte-Anne-des-Lacs 8 Alma 8 Namur 7 Chelsea 7 Val-des-Lacs 7 Rawdon 7 Saint-Calixte 7 Sacré-Coeur 7 Mansfield-et-Pontefract 7 Notre-Dame-Auxiliatrice-de-Buckland 7 Lac-Mégantic 7 St-Raymond 7 Pointe-Claire 7 Saint-Joachim 7 Messines 7 Saint-Siméon 7 Lac-aux-Sables 7 Brownsburg 6 Saint-Étienne-de-Bolton 6 Saint-André-Avellin 6 Saint-Jean-de-l'Île-d'Orléans 6 Disraeli 6 Austin 6 Chapeau 6 Roberval 6 Cowansville 6 Adstock 6 Saint-Laurent-Ile-d'Orleans 6 Lac-Sainte-Marie 6 Saint-Jean-sur-Richelieu 6 Pabos 6 Tadoussac 6 Val-des-Bois 6 Pontiac 6 Lévis 6 Îles de la Madeleine 6 Weedon 6 Murdochville 6 Saint-Hyacinthe 5 Repentigny 5 Beloeil 5 Salaberry-de-Valleyfield 5 Les Laurentides Regional County Municipality 5 Saint-Zénon 5 Saint-Côme 5 Trois-Rives 5 Rivière-Rouge 5 Bricquebec-en-Cotentin 5 Saint-Anicet 5 Knowlton 5 Sainte-Marguerite-du-Lac-Masson 5 Saint-Denis-de-Brompton 5 Hérouxville 5 Argenteuil 5 Morin-Heights 5 Beaulac-Garthby 5 Saint-Romain 5 Sainte-Anne-de-Beaupré 5 Notre-Dame-de-Pontmain 5 Fulford 5 Sainte-Flavie 5 Grandes-Bergeronnes 4 Saint-Paulin 4 L'Ange-Gardien 4 La Vallée-de-la-Gatineau 4 Carleton-sur-mer 4 Sayabec 4 Bowman 4 Dolbeau-Mistassini 4 Saint-André-d'Argenteuil 4 Frampton 4 Saint-Casimir 4 Lambton 4 Otterburn Park 4 Berthier-sur-Mer 4 Antoine-Labelle 4 Sainte-Thérèse-de-la-Gatineau 4 Chute-Saint-Philippe 4 L'Île-Perrot 4 Shefford 4 Ayer's Cliff 4 Labelle 4 Waterloo 4 Montréal-Est 4 Saint-Donat 4 Bolton-Est 4 Drummondville 4 Percé 4 Saint-Hippolyte 4 Otter Lake 4 Notre-Dame-des-Monts 4 Saint-Urbain 4 North Hatley 4 Saint-Roch-des-Aulnaies 4 Saint-Michel-de-Bellechasse 4 Le Fjord-du-Saguenay 4 Saint-Pierre 4 La Côte-de-Beaupré 4 Saint-Henri-de-Taillon 4 Grandes-Piles 4 Sainte-Luce 4 West Bolton 4 Duhamel 4 Saint-Gabriel-de-Brandon 4 L'Islet 4 Deschambault 4 Cap-aux-Meules 4 Huberdeau 4 La Prairie 4 Saint-Alphonse-Rodriguez 4 Venise-en-Québec 4 Côte Saint-Luc 4 Stratford 3 Prévost 3 Sainte-Ursule 3 Notre-Dame-de-Montauban 3 Paspébiac 3 Saint-Adrien 3 Kamouraska 3 Saint-André 3 Les Îles-de-la-Madeleine 3 L'Ascension 3 L'Ascension-de-Notre-Seigneur 3 Châteauguay 3 Bury 3 Pohenegamook 3 Saint-Joseph-de-la-Rive 3 Stanstead 3 Val-des-Sources 3 Wemotaci 3 Blainville 3 Piopolis 3 Saint-Narcisse-de-Rimouski 3 Rivière-à-Pierre 3 Saint-Simon 3 Saint-Basile 3 Lac-Drolet 3 Saint-René-de-Matane 3 Normandin 3 Cantley 3 Témiscouata-sur-le-Lac 3 Champlain 3 Sainte-Anne-du-Lac 3 Memphrémagog 3 Dollard-Des Ormeaux 3 Lac-Brome 3 L'Isle-aux-Coudres 3 Saint-Herménégilde 3 Bonaventure 3 Longue-Rive 3 Havre-Saint-Pierre 3 Valcourt 3 Brébeuf 3 Sainte-Julie 3 Woburn 3 Mont-Carmel 3 Saint-Barthélemy 3 Harrington 3 Stukely 3 Saint-Raphaël 3 Saint-Colomban 3 Chénéville 3 Mont-Saint-Pierre 3 New Richmond 3 Saint-Rémi-de-Tingwick 3 Saint-Roch-de-Mékinac 3 Notre-Dame-du-Portage 3 Saint-Polycarpe 3 Foster 3 Saint-Eustache 3 Frelighsburg 3 Westmount 3 Lachute 2 Saint-Georges-de-Malbaie 2 Saint-Ignace-de-Loyola 2 Maria 2 Kazabazua 2 Notre-Dame-du-Nord 2 Hatley 2 Fatima 2 Kiamika 2 St-Tite 2 Sainte-Cécile-de-Masham 2 Lac-Saint-Jean-Est Regional County Municipality 2 Dudswell 2 Cap-Saint-Ignace 2 Saint-Gédéon 2 Baie-Johan-Beetz 2 Cap-Chat-Est 2 Montpellier 2 Saint-Marc-sur-Richelieu 2 Beauceville 2 Boucherville 2 Hampstead 2 Scott 2 Nouvelle 2 Péribonka 2 Scotstown 2 Candiac 2 Saint-Pascal 2 Louiseville 2 Lac-des-Îles 2 Rivière-Bonaventure 2 Chibougamau 2 Rivière-Éternité 2 Saint-Georges-de-Clarenceville 2 Témiscamingue 2 Communauté maritime des Îles-de-la-Madeleine 2 La Bostonnais 2 Joliette 2 Saint-Ambroise 2 Farnham 2 Saint-Félicien 2 Papineauville 2 Matapédia 2 Charlevoix-Est 2 Bassin 2 Pincourt 2 Dorval 2 Baie-Sainte-Catherine 2 Saint-Germain 2 Mt Royal 2 Lac-des-Plages 2 Saint-Charles-Borromée 2 St-Bruno-de-Montarville 2 Saint-Léon-de-Standon 2 Saint-Aimé-des-Lacs 2 Saint-Élie-de-Caxton 2 Rivière-Ouelle 2 Pointe-Calumet 2 Saint-Benoît-Labre 2 Brownsburg-Chatham 2 Saint-Augustin-de-Desmaures 2 Saint-Paul-de-Montminy 2 Ormstown 2 Le Domaine-du-Roy 2 Grenville-sur-la-Rouge 2 Portneuf 2 Desbiens 2 Dollard-des-Ormeaux 2 Saint-Fabien-de-Panet 2 Métabetchouan-Lac-à-la-Croix 2 Saint-Cyrille-de-Lessard 2 Saint-Ludger-de-Milot 2 Amqui 2 Les Pays-d'en-Haut 2 Saint-Adelphe 2 Notre-Dame-de-la-Salette 2 Saint-Aubert 2 Lac-des-Seize-Îles 2 Lorraine 2 Chambly 2 Saint-Émile-de-Suffolk 2 Grondines 2 Saint-Ferdinand 2 Sorel-Tracy 2 Lantier 2 Papineau 2 Hemmingford 2 Montreal West 2 Lac-Simon 2 Barnston-Ouest 2 Quebec City 2 Notre-Dame-du-Rosaire 2 Rivière-du-Loup 2 La Jacques-Cartier 2 La Pocatière 2 Saint-Fabien 2 Les Collines-de-l'Outaouais 2 Victoriaville 2 Saint-Didace 2 Saint-Jérôme 2 La Patrie 2 Les Escoumins 2 Métis-sur-Mer 2 Saint-Félix-d'Otis 2 Lac-Sergent 2 Labrecque 2 Amos 2 Sainte-Rose-du-Nord 2 Saint-Mathieu-de-Rioux 2 Granby 2 Saint-Marc-du-Lac-Long 1 Sainte-Julienne 1 Baie-Comeau 1 Donnacona 1 La Jacques-Cartier Regional County Municipality 1 La Martre 1 Rivière-à-Claude 1 Saint-Armand 1 Les Basques 1 Fabre 1 Sainte-Thècle 1 Batiscan 1 Trois-Pistoles 1 Bégin 1 Frontenac 1 Princeville 1 Odanak 1 Sainte-Praxède 1 Dewittville 1 St Étienne des Grès 1 Nicolet 1 Bristol 1 Fassett 1 Saint-Lin-Laurentides 1 Île-aux-Noix 1 Oka 1 Le Haut-Saint-François Regional County Municipality 1 L'Ancienne-Lorette 1 St-Urbain-de-Charlevoix 1 Lourdes-de-Joliette 1 Wotton 1 Wentworth-Nord 1 Stanstead-Est 1 Larouche 1 Vallée-Jonction 1 Cascapédia-Saint-Jules 1 Mont-Saint-Hilaire 1 Godmanchester 1 Grosse-Île 1 Low 1 La Macaza 1 Vaudreuil-Dorion 1 Laniel 1 Saint-Cuthbert 1 La Bostonnais(près de la tuque) 1 Auclair 1 Biencourt 1 Montcalm 1 Saint-Lucien 1 Tourville 1 Rivière-la-Madeleine 1 Saint-Martin 1 Sept-Îles 1 Caplan 1 Le Fjord-du-Saguenay Regional County Municipality 1 Lourdes 1 Lachine 1 Chartierville 1 Sainte-Séraphine 1 Mont-Saint-Grégoire 1 Lamarche 1 Verdun 1 Saint-Isidore-de-Clifton 1 Duclos 1 Sheenboro 1 Barkmere 1 Kinnear's Mills 1 Sainte-Anne-de-la-Pérade 1 Sainte-Thérèse-de-Gaspé 1 Ripon 1 Sainte-Anne-de-Sorel 1 Richmond 1 Dégelis 1 Saint-Constant 1 Saint-Boniface 1 Davidson 1 Saint-Marcellin 1 Saint-Michel-du-Squatec 1 Stukely-Sud 1 Windsor 1 Saint-Pierre-les-Becquets 1 Notre-Dame-du-Mont-Carmel 1 Saint-Fulgence 1 Ange-Gardien 1 Havre-Aubert 1 price 1 Brome 1 Saint-Zotique 1 Newport 1 saint-Hubert 1 Cascapédia-St-Jules 1 Lac-Saguay 1 Hébertville 1 Ham-Nord 1 Saint-Lambert-de-Lauzon 1 D'Autray 1 Shawville 1 Sainte-Marthe-sur-le-Lac 1 Matawinie Regional County Municipality 1 Ville-Marie 1 Maskinongé 1 Martinville 1 Pointe-Lebel 1 Ville St Laurent 1 Saint-Amable 1 Sainte-Thérèse 1 Esprit-Saint 1 Saint-Joachim-de-Shefford 1 East Broughton 1 Sainte-Félicité 1 Yamachiche 1 Deux-Montagnes 1 Saint-Lambert 1 Saint-Marcel 1 Mont-blanc 1 Sagard 1 Saint-Hubert-de-Rivière-du-Loup 1 Packington 1 Sainte-Sophie 1 Arr. Chicoutimi (Saguenay) 1 Sainte-Marcelline-de-Kildare 1 Saint-Jean-de-Dieu 1 Saint-Alphonse-de-Granby 1 Bryson 1 Saint-Samuel 1 Saint-Antoine-de-l'Isle-aux-Grues 1 Saint-Octave-de-Métis 1 trois rives 1 Blue Sea 1 La Haute-Gaspésie 1 Notre-Dame-de-Ham 1 Val-Brillant 1 Lac-Bouchette 1 Thetford Mines 1 Barachois 1 Plaisance 1 L'Anse-Pleureuse 1 Sainte-Angèle-de-Mérici 1 Potton 1 Saint-Bernard-sur-Mer 1 Waterville 1 Bécancour 1 Sainte-Anne-de-la-Rochelle 1 St-Gabriel-de-Valcartier 1 Sainte-Françoise 1 Lorrainville 1 New Carlisle 1 Ville de Québec 1 Lac-Saint-Jean-Est 1 Nouvelle-Ouest 1 Chambord 1 Saint-Basile-le-Grand 1 Mascouche 1 Sainte-Catherine 1 Carignan 1 Thorne 1 Saint-Modeste 1 Saint-Honoré 1 Saint-Roch-de-Richelieu 1 Saint-Antonin 1 Sainte-Irène 1 Saint-Benjamin 1 La Conception-Station 1 Trécesson 1 Memphrémagog Regional County Municipality 1 Ladysmith 1 Sainte-Aurélie 1 Sainte-Christine-d'Auvergne 1 Saint-Athanase 1 Chandler 1 Petit-Saguenay 1 Saint-François-de-l'Île-d'Orléans 1 Cap-d'Espoir 1 Sainte-Madeleine-de-la-Rivière-Madeleine 1 Saint-Damase 1 Saint-Léonard-d'Aston 1 Saint-Valère 1 Temiscaming 1 Roxton Falls 1 Sainte-Agathe-de-Lotbinière 1 Mékinac 1 Barraute 1 Ferland-et-Boilleau 1 La Baleine 1 Saint-Malo 1 Saint-Siméon-de-Bonaventure 1 Saint-Hilarion 1 Sainte-Pétronille 1 Saint-Raymond 1 Notre-Dame-du-Laus 1 Saint-Zacharie 1 Arthabaska 1 Charles-E. 1 Sainte Ursule 1 Luskville 1 Mercier 1 Saint-Pie 1 Saint-Pierre-de-Broughton 1 Ferme-Neuve 1 Havre-aux-Maisons 1 St-irénée 1 Sainte-Apolline-de-Patton 1 Hudson 1 Kirkland 1 Saint-Faustin--Lac-Carré 1 Saint-Anaclet-de-Lessard 1 l'Ascension-de-notre-Seigneur 1 Saint Donat 1 Saint-Joseph-de-Beauce 1 Notre-Dame-de-l'Île-Perrot 1 Le Haut-Saint-François 1 La Matapédia 1 Lac-Saint-Paul 1 --- Value counts: property_type --- Rental unit 1777 Cabin/Chalet 977 House 963 Other 819 Condo 332 Apartment 132 --- Value counts: price_category --- Unknown 1544 Moderate ($100-200) 1003 Ultra-Luxury (>$1000) 915 Premium ($200-400) 682 Budget (<$100) 579 Luxury ($400-1000) 277 --- Value counts: rating_category --- Exceptional (4.9-5.0) 1761 Excellent (4.7-4.9) 1530 No rating 810 Very Good (4.5-4.7) 548 Good (4.0-4.5) 324 Average (<4.0) 27 --- Value counts: is_superhost --- True 2616 False 2384 --- Value counts: is_guest_favorite --- False 3328 True 1672 --- Value counts: pets_allowed --- False 3538 True 1462 --- First 5 rows --- name city property_type price_numeric price_category rating rating_category bedrooms bathrooms guests_count amenities_count num_images num_reviews quality_score is_superhost is_guest_favorite pets_allowed lat long 0 Rental unit in Montréal · ★New · 1 bedroom · 1 bed · 1 shared bath Montréal Rental unit NaN Unknown NaN No rating 1 0.0 2 31 29 NaN 0.0 False False False 45.477030 -73.607700 1 Rental unit in Québec · 1 bedroom · 2 beds · 1 bath Québec Rental unit NaN Unknown NaN No rating 1 1.0 4 34 7 NaN 0.0 False False False 46.815630 -71.207260 2 Rental unit in Saint-Georges · ★5.0 · 2 bedrooms · 2 beds · 1 bath Saint-Georges Rental unit 83.0 Budget (<$100) 5.0 Exceptional (4.9-5.0) 2 1.0 4 35 16 NaN 100.0 False False False 46.119212 -70.666145 3 Home in Nominingue · ★New · 3 bedrooms · 4 beds · 1 bath Nominingue House NaN Unknown NaN No rating 3 1.0 8 12 21 NaN 0.0 False False False 46.461320 -74.948370 4 Rental unit in Montréal · ★New · 1 bedroom · 1 bed · 1 bath Montréal Rental unit NaN Unknown NaN No rating 1 1.0 4 5 7 NaN 0.0 False False False 45.558490 -73.585060 ================================================================================ RENT DATASET — rent.json ================================================================================ Total records: 8356 Shape (flattened): 8356 rows x 14 columns --- Dtypes --- address_text str latitude str longitude str property_type str lease_rent str lease_rent_unformatted str building_type str bedrooms str bathrooms_total str size_interior str stories_total str postal_code str province str scraped_at str --- Empty-string + null counts --- address_text null= 0 blank= 0 total= 0 ( 0.0%) latitude null= 0 blank= 0 total= 0 ( 0.0%) longitude null= 0 blank= 0 total= 0 ( 0.0%) property_type null= 0 blank= 0 total= 0 ( 0.0%) lease_rent null= 0 blank= 0 total= 0 ( 0.0%) lease_rent_unformatted null= 0 blank= 0 total= 0 ( 0.0%) building_type null= 0 blank= 48 total= 48 ( 0.6%) bedrooms null= 0 blank= 426 total= 426 ( 5.1%) bathrooms_total null= 0 blank= 48 total= 48 ( 0.6%) size_interior null= 0 blank= 4438 total= 4438 ( 53.1%) stories_total null= 0 blank= 2172 total= 2172 ( 26.0%) postal_code null= 0 blank= 0 total= 0 ( 0.0%) province null= 0 blank= 0 total= 0 ( 0.0%) scraped_at null= 0 blank= 0 total= 0 ( 0.0%) --- Value counts: property_type --- Single Family 8308 Vacant Land 48 --- Value counts: building_type --- Apartment 7515 House 745 48 Row / Townhouse 48 --- LeaseRent frequency patterns (top 10) --- $1,800/Monthly 237 $2,500/Monthly 214 $1,600/Monthly 204 $2,000/Monthly 190 $1,700/Monthly 186 $2,200/Monthly 181 $1,500/Monthly 178 $2,100/Monthly 165 $1,900/Monthly 161 $1,850/Monthly 143 --- LeaseRent period distribution --- Monthly 8319 Yearly 33 Weekly 4 --- First 5 rows (flattened) --- address_text latitude longitude property_type lease_rent lease_rent_unformatted building_type bedrooms bathrooms_total size_interior stories_total postal_code province scraped_at 0 1764 Rue Jérôme-Hamel|Trois-Rivières, Quebec G8V1W3 46.402706 -72.533809 Vacant Land $1/Yearly/sqft 1 G8V1W3 Quebec 2026-01-08T01:58:53.220Z 1 24 Rg St-Charles|Mercier, Quebec J6E2L1 45.310747 -73.768111 Vacant Land $1/Yearly/sqft 1 J6E2L1 Quebec 2026-01-08T01:58:53.220Z 2 Route du Président-Kennedy|Lévis (Desjardins), Quebec G6C1C8 46.75664186 -71.12321116 Vacant Land $1/Yearly/sqft 1 G6C1C8 Quebec 2026-01-08T01:58:53.220Z 3 116 Boul. Fortin|Saint-Bernard-de-Lacolle, Quebec J0J1V0 45.012127 -73.453971 Vacant Land $1.50/Yearly/sqft 1.5 J0J1V0 Quebec 2026-01-08T01:58:53.220Z 4 Rue Valmont|Saint-Jérôme, Quebec J7Y4Y2 45.758094 -74.01657 Vacant Land $1.50/Yearly/sqft 1.5 J7Y4Y2 Quebec 2026-01-08T01:58:53.220Z