一份数据科学的考试答案，有感兴趣的人的话会做一个解析，还是很全面的，从数据清洗到分析画图到机器学习从涉及到了，很全面的一个小项目
# dataframe opertations - pandas import sys import pandas as pd # plotting data - matplotlib from matplotlib import pyplot as plt # time series - statsmodels # Seasonality decomposition from statsmodels.tsa.seasonal import seasonal_decompose from statsmodels.tsa.seasonal import seasonal_decompose # holt winters # single exponential smoothing from statsmodels.tsa.holtwinters import SimpleExpSmoothing # double and triple exponential smoothing from statsmodels.tsa.holtwinters import ExponentialSmoothing
#importing & Cleaning Data
BlaBlaCar = pd.read_excel("BlaBlaCar.xlsx")
BlaBlaCar.head()
| driver_id | offer_id | departure | arrival | trip_distance | offer_date | departure_date | price | nb_offers | photo | ... | min_price_depd | mean_price_depd | sd_price_depd | seats_in_car | seat_sold | Driver_first_name | Satisfaction_Livel | nb_evaluation | driver_age | driver_gender | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 255920 | 840914 | Paris | Lyon | 440.0 | 26-Feb-14 | 5/6/2014 10:00 | 20 | 813.0 | 0 | ... | 20 | 24.829268 | 4.543690 | 4 | 1 | Morgane | Average | 0 | 21 | 1 |
| 1 | 4086 | 10939 | Lyon | Paris | 483.0 | 22-Dec-13 | 5/24/2014 12:40 | 30 | 800.0 | 0 | ... | 30 | 30.000000 | 0.000000 | 0 | 0 | Adrien | Average | 4 | 68 | 0 |
| 2 | 62752 | 212083 | Lyon | Paris | 462.0 | 16-Mar-14 | 4/8/2014 11:00 | 30 | 794.0 | 0 | ... | 30 | 30.000000 | NaN | 4 | 0 | Celine | Average | 0 | 25 | 1 |
| 3 | 62752 | 212078 | Lyon | Paris | 471.0 | 16-Mar-14 | 4/3/2014 11:00 | 30 | 794.0 | 0 | ... | 15 | 21.666666 | 6.945163 | 4 | 0 | Celine | Average | 0 | 25 | 1 |
| 4 | 64229 | 216955 | Paris | Lyon | 462.0 | 22-Feb-14 | 4/20/2014 13:00 | 28 | 797.0 | 0 | ... | 28 | 29.515152 | 0.863667 | 3 | 0 | Chantal | Average | 0 | 53 | 1 |
5 rows × 33 columns
columns = BlaBlaCar.head(1).columns columns
Index(['driver_id', 'offer_id', 'departure', 'arrival', 'trip_distance',
'offer_date', 'departure_date', 'price', 'nb_offers', 'photo',
'driver_status', 'music', 'talk', 'pet', 'smoking',
'manual_reservation', 'round_trip', 'car_rating', 'detour_time',
'page_view', 'Recommendation', 'Recom_Rate', 'max_price_depd',
'min_price_depd', 'mean_price_depd', 'sd_price_depd', 'seats_in_car',
'seat_sold', 'Driver_first_name', 'Satisfaction_Livel', 'nb_evaluation',
'driver_age', 'driver_gender'],
dtype='object')
# Data cleaning
columns_listnum = ['driver_id', 'offer_id', 'trip_distance',
'price', 'nb_offers', 'photo','music', 'talk', 'pet', 'smoking',
'manual_reservation', 'round_trip', 'car_rating', 'detour_time',
'page_view', 'Recommendation', 'Recom_Rate', 'max_price_depd',
'min_price_depd', 'mean_price_depd', 'sd_price_depd', 'seats_in_car',
'seat_sold', 'nb_evaluation',
'driver_age', 'driver_gender']
driver_status=["S1","S2","S3","S4","S5"]
mean_by_day = {}
for x in driver_status:
rows = BlaBlaCar[BlaBlaCar.driver_status==x]
for column in columns_listnum:
mean_by_day[x,column] = rows[column].mean()
#print((Pizza.DayOfTheWeek==x) & (Pizza[column].isnull()),column)
BlaBlaCar[(BlaBlaCar.driver_status==x) & (BlaBlaCar[column].isnull())].column = mean_by_day[x,column]
mean_by_day
{('S1', 'driver_id'): 178434.75739961487,
('S1', 'offer_id'): 596562.0330218957,
('S1', 'trip_distance'): 468.48669472783047,
('S1', 'price'): 29.513194493973327,
('S1', 'nb_offers'): 767.4211577558227,
('S1', 'photo'): 0.2740888666999501,
('S1', 'music'): 0.41551957777619286,
('S1', 'talk'): 1.0,
('S1', 'pet'): 0.0581627558662007,
('S1', 'smoking'): 0.06575850509949362,
('S1', 'manual_reservation'): 0.23939091362955567,
('S1', 'round_trip'): 0.25108765423293633,
('S1', 'car_rating'): 1.9730741797432239,
('S1', 'detour_time'): 8.279661923611854,
('S1', 'page_view'): 40.92325797018758,
('S1', 'Recommendation'): 0.5300263889879466,
('S1', 'Recom_Rate'): 12.737108622780115,
('S1', 'max_price_depd'): 47.00941444975394,
('S1', 'min_price_depd'): 17.585015334141644,
('S1', 'mean_price_depd'): 29.70589785090184,
('S1', 'sd_price_depd'): 3.3134058732683154,
('S1', 'seats_in_car'): 2.327152128949433,
('S1', 'seat_sold'): 0.9689751087654233,
('S1', 'nb_evaluation'): 0.48085015334141645,
('S1', 'driver_age'): 34.98923044005421,
('S1', 'driver_gender'): 0.282112545467513,
('S2', 'driver_id'): 182815.85885799633,
('S2', 'offer_id'): 611063.240636489,
('S2', 'trip_distance'): 467.20353982300884,
('S2', 'price'): 29.227711397058822,
('S2', 'nb_offers'): 767.3183359190945,
('S2', 'photo'): 0.35661764705882354,
('S2', 'music'): 0.5086167279411765,
('S2', 'talk'): 1.0,
('S2', 'pet'): 0.07278262867647059,
('S2', 'smoking'): 0.059857536764705885,
('S2', 'manual_reservation'): 0.18841911764705882,
('S2', 'round_trip'): 0.2192095588235294,
('S2', 'car_rating'): 2.292049632352941,
('S2', 'detour_time'): 7.806755514705882,
('S2', 'page_view'): 39.75338924632353,
('S2', 'Recommendation'): 0.5086167279411765,
('S2', 'Recom_Rate'): 12.674574908088236,
('S2', 'max_price_depd'): 46.50775505514706,
('S2', 'min_price_depd'): 17.484547334558822,
('S2', 'mean_price_depd'): 29.687136152113762,
('S2', 'sd_price_depd'): 3.295760889884489,
('S2', 'seats_in_car'): 2.2593060661764706,
('S2', 'seat_sold'): 1.108053768382353,
('S2', 'nb_evaluation'): 2.878216911764706,
('S2', 'driver_age'): 34.356330422794116,
('S2', 'driver_gender'): 0.3001493566176471,
('S3', 'driver_id'): 184335.3271400581,
('S3', 'offer_id'): 616202.406121208,
('S3', 'trip_distance'): 467.5742279883776,
('S3', 'price'): 29.00729680426998,
('S3', 'nb_offers'): 766.0222372423116,
('S3', 'photo'): 0.44321329639889195,
('S3', 'music'): 0.6058374434159854,
('S3', 'talk'): 1.0,
('S3', 'pet'): 0.08073778798729815,
('S3', 'smoking'): 0.06607661644483481,
('S3', 'manual_reservation'): 0.17275859739206811,
('S3', 'round_trip'): 0.2347138706844132,
('S3', 'car_rating'): 2.496385379366259,
('S3', 'detour_time'): 7.604891561380988,
('S3', 'page_view'): 40.20167556246199,
('S3', 'Recommendation'): 0.49618269035875956,
('S3', 'Recom_Rate'): 12.844054054054054,
('S3', 'max_price_depd'): 47.26275251672185,
('S3', 'min_price_depd'): 17.556516451591108,
('S3', 'mean_price_depd'): 29.673620787379168,
('S3', 'sd_price_depd'): 3.2960719824525406,
('S3', 'seats_in_car'): 2.269171001959327,
('S3', 'seat_sold'): 1.1663401121545842,
('S3', 'nb_evaluation'): 5.9336531315451655,
('S3', 'driver_age'): 34.199648672387,
('S3', 'driver_gender'): 0.2649145328018377,
('S4', 'driver_id'): 184124.99772434946,
('S4', 'offer_id'): 615712.4551795785,
('S4', 'trip_distance'): 467.02968827313214,
('S4', 'price'): 28.68106262986049,
('S4', 'nb_offers'): 767.6358733300347,
('S4', 'photo'): 0.3909666567725339,
('S4', 'music'): 0.6482141090333432,
('S4', 'talk'): 1.0,
('S4', 'pet'): 0.11299099633917087,
('S4', 'smoking'): 0.05520926090828139,
('S4', 'manual_reservation'): 0.1370337389927773,
('S4', 'round_trip'): 0.23865828921980903,
('S4', 'car_rating'): 2.6212833325087814,
('S4', 'detour_time'): 7.3018699910952805,
('S4', 'page_view'): 40.17265261699812,
('S4', 'Recommendation'): 0.4780350252300386,
('S4', 'Recom_Rate'): 12.786880379934699,
('S4', 'max_price_depd'): 46.97214801622638,
('S4', 'min_price_depd'): 17.493915108340754,
('S4', 'mean_price_depd'): 29.662343048037563,
('S4', 'sd_price_depd'): 3.295174642051816,
('S4', 'seats_in_car'): 2.3153260116750767,
('S4', 'seat_sold'): 1.2354308894825368,
('S4', 'nb_evaluation'): 18.376323340259226,
('S4', 'driver_age'): 34.553527258335805,
('S4', 'driver_gender'): 0.2183635104383101,
('S5', 'driver_id'): 188810.7724941725,
('S5', 'offer_id'): 631667.023018648,
('S5', 'trip_distance'): 467.628526463045,
('S5', 'price'): 29.073601398601397,
('S5', 'nb_offers'): 769.2936822473482,
('S5', 'photo'): 0.7312354312354312,
('S5', 'music'): 0.7718531468531469,
('S5', 'talk'): 1.0,
('S5', 'pet'): 0.11287878787878788,
('S5', 'smoking'): 0.041375291375291376,
('S5', 'manual_reservation'): 0.09201631701631702,
('S5', 'round_trip'): 0.2484555309476629,
('S5', 'car_rating'): 2.8846153846153846,
('S5', 'detour_time'): 7.045454545454546,
('S5', 'page_view'): 51.973601398601396,
('S5', 'Recommendation'): 0.46002331002331004,
('S5', 'Recom_Rate'): 13.080244755244756,
('S5', 'max_price_depd'): 46.672494172494176,
('S5', 'min_price_depd'): 17.291666666666668,
('S5', 'mean_price_depd'): 29.661237250116375,
('S5', 'sd_price_depd'): 3.2877041341812037,
('S5', 'seats_in_car'): 2.3055944055944058,
('S5', 'seat_sold'): 1.4304195804195805,
('S5', 'nb_evaluation'): 38.98152680652681,
('S5', 'driver_age'): 34.7997668997669,
('S5', 'driver_gender'): 0.16655011655011656}
# 使用众数进行填充
cols = ["music","talk", "pet", "smoking", "detour_time"]
for i in cols:
age_maxf = BlaBlaCar[i].value_counts().index[0]
BlaBlaCar[i].fillna(age_maxf, inplace=True)
# Data Manipulation
# Find & Print the Maximum " trip_distance" Driver name
trip_max = BlaBlaCar.trip_distance.max()
trip_max_name = BlaBlaCar[BlaBlaCar.trip_distance == trip_max].Driver_first_name
print("the maximum of trip_distance is",trip_max)
print("the name of maximum of trip_distance is "+trip_max_name.values[0])
the maximum of trip_distance is 1700.0 the name of maximum of trip_distance is Claude
# Select and print by ‘‘driver_status’’, the Driver_name with the max “"detour_time"
detour_max = BlaBlaCar.detour_time.max()
detour_max_name = BlaBlaCar[BlaBlaCar.detour_time == detour_max].Driver_first_name
for name in detour_max_name:
print(name)
Krisnen Arnaud Benjamin Adrien Amaury Benoit Bernard Fabien Farid Gaetan Herve Marie Razi Stephanie Alexis Caroline Caroline Emmanuel Faycal Julien Julien Mohamed Pierre Youssef Zoubair Achour Anthony Antonio Arthur Cyril Eric Gregory Guylene Ines Magali Maxime Yohan Yves Amouche Audrey Benjamin Etienne Ferreira Gael Guillaume Lamro Moran Nadege Vincent Alexandre Arnaud Hubert Jean-Philippe Quentin Thomas Abdel Angie Antonio Arnaud Arthur Charlotte Christophe Clarence Clement Didier Elodie Faycal Frank Gengis Gilles Gilles Gregory Jean-Luc Jean-Philippe Jimmy Marc Maxime Melanie Mohamed Nadege Nicolas Patrick Pierre-Adrien Pierre-Antoine Sarra Sebastien Test Thibault Valerie Abdoul Alain Aurelien Brosse Christian Claudia Corinne Etienne Joe Jonathan Julien Kevin Le Nathanael Paul Youcef Augustin Aurelien Catherine Christine Florent Florian Francois-Joseph Gaetan Jean-Marie Jean-Philippe Julien Montaux-Lambert Thierry Fred Guillaume Mael P-Fabien P-Fabien Patient Alexandre Christian David Hakkar Philippe Ambroise Anthony Bastien Benjamin Benoit Bertrand Cecile Chantal Evan Fanny Francois Gaetan Isabelle Jocelyne Jonathan Jose Julien Laetitia Lily Ludovic Marie Marti Mathilde Maxime Mohammed Nico Nicolas Oceane Olivier Pascal Romain Sandra Serge Sophie Stephane Sylvain-Catherine Tatsuya Yoann Ahmed Melvin Taleb Aymeric Linda Tristan Anais Antoine Jean-Philippe Laurent Pierre-Arnaud Benoit Mathieu Pierrick Gautier Gharib Christian Jean-Hugues Krystel Maxime Dominique Julien Annie Sebastien Benjamin Caroline Damien Fred Gregory Isabelle Omar Sebastien Christian Geoffrey Mohamed Nael Raphael Sylvain Fabrice Aurelie-Serge Couty Angelique Pierre-Adrien Jean Jean Sebastien Francois Yann Laure Philippe Audrey Audrey Edgar Francoise Manu Marie Anne-Sophie Ludovic Sandra Arnaud Mathieu Paul Pierre Severine Thibaud Thierry Alexis Aurelie Damien Didier Didier Florent Lionel Mehdi Mohammed Thomas Yann Francois Valentin Vincent Aurelien Delphine Fabien Jacques Marcel Pascal Pierre Sylvie Thomas Victor Nicolas Sophie Abdel Alain Angel Antonio Ced Cedric David Emeric Emeric Etienne Fabrice Hamoudi Jean Jean-Claude Jean-Louis Julie Luc Mario Mathilde Moms Nathalie Patrick Philippe Pierre-Yves Rodrigo Romain Serge Shakti Thomas Vincent Amandine Dominique Fernand Luc Magalie Marc Noemie Patricia Perrine Romain Charlotte Emilie Fred Frederic Geoffrey Hubert Hubert Jean-Francois Leo Omar Philippe Ricaud Robin Alexandre Lise Mathieu Mouna Amer Andreas Francesca Jeremy Mohammed Pierre-Michael Ahmed Alioune Anais Anthony Aurelie Aurore Baptiste Christophe Christophe Cyril David David David David David Denis Didier Emilie Ezzedine Florent Florian Herve Imed Jeremy Jimmy Jose Julia Karine Laura Lydie Marlene Mathieu Mickael Nicolas Odile Olivier Olivier Olivier Philippe Robert Sebastien Sebastien Simon Sophie Thibault Thibaut C Charvet Gael Sabrina Antonio Heleniza Lise Marie-Anne Mortada Nadia Noussa Sara Amelie Luc Valerie Clement Gael Jean-Sebastien Marco Axel Candice Eddine Patrick Severine Al Antoine Daniel Ludovic Pascal Alain Benoit Benoit Sabri Xavier Hossam Nadir Nathalie Pauline Xavier Jean Laurent Mohammed Thibault Emilie Justine Olivier Sabine Ln Stanislas Angelique Anna Clement Juliette Kevin Ouissem Angie Gilles Isabelle Hossam Melania Djamil Audrey Christophe Thierry Francoise Natacha Olivier Lamro Luc Etienne Jonathan Alice Bastien David Emmanuel Jugurtha Mickael Mohammed Olivier Olivier Quentin Robert Sam Thibaud Vanessa Fabrice Imed Julien Yoann Adrien Amandine Azzedine Christophe Damien Edmond Frederic Jeremy Johann Karim Mhamed Olivier Pauline Abbee Adrien Armand Benjamin Ezzedine Florian Florian Frederic Jonathan Julien Marine Maxime Myriam Samir Vincent Amor Claire Eve Fabrizio Le Quentin Remi Sebastien Stoyan Yann Adrien Adrien Adrien Alain Anais Aymeric Bilal Bilal Cedric Cedric Clemence Didier Elodie Eric Etienne Florian Jean-Luc Joachim Julien Julien Laure Maxime Mustapha Nadege Remi Rodrigo Sam Shakti Stephane Sylvie Theo Thibaut Thierry Thierry Thomas Yannick Yannick Yasmina Younes Aurelie Bryan Fabrice Frederic Hassani Linda Lucie Marilyn Matthieu Mickael Patricia Sofian Stephanie Thibault Tristan Vincent Vincent Arnaud Aurelie Emmanuel Francois Fred Julien Manuel Maxime Nadir Olivier Pierre-Etienne Remy Sophie Youssouf Alexandre Benjamin Mama Sophie Taleb Thibault Aubin Francois Laurent Tiphaine Astrid Atanas Boumediene Christian Claire Emilie Fabrice Fady Frederic Hippolyte Jean-Francois Johan Justine Laetitia Lamro Louis-Maxence Madeleine Marguerite Marie Marie Mathieu Maud Michel Mourad Nicolas Ophelie Philippe Philippe Philippe Pierre Pierre Remi Robert Rudy Sarah Sebastien Sid Sophie Stephane Steven Tarek Thierry Valentin Xavier Yoann Younes Delphine Salam Sami Fabrice Dadom Loic Olivier Sylvain Yves Guylaine Jeanne Matthieu Nicolas Rayan Berenice Damien Gharib Marlene Remi Sandra Sophie Thomas Youcef Alex Ghislain Julien Maxime Jonathan Mhand Yohan Berenger Florian Mohammed Nelly Olivier Anicet Pascal Pierre Serge Yann Anais Anthony Marianne Melania Nazha Theo Thierry Thomas Oceane Steven Amara Benoit Yann Yannick Alain Catherine Henri Vanessa Robert Geoffrey Geoffrey Mohammed Vanessa Yoann Djamil Thomas Bernard Arthur David David Didier Evan Youssouf Akoi Andre Fabien Jean Taleb Thomas Bruno Benjamin Carole Eric Pierre Linda Loic Anne-Charlotte Simon Omar Tony Adam Dominique Fabrice Alexandre Clement Catherine Charles-Andre Charles-Andre Cedric Christine Alexandra Celine Charline Caroline Clement Aime Alexandre Aymeric Boris Cedric Christophe Alexandre Bernard Charlotte Claude Andre Joe Fethi Jean-Louis Jose Louis Mohammed Alexandre Alexandre Damien David Eric Etienne Flora Francois-Xavier Geoffrey Jose Laurent Lionel Ludovic Marc Mishko Nass Oceane Oceane Philippe Philippe Philippe Philippe Regine Romain Romain Samy Thibaut Alain Brayan Bruno Deede Francis Geoffrey Julie Julien Karine Madeleine Marie-Anne Marilou Pauline Remi Sebastien Sebastien Sylvain Thierry Timothee Tristan Yazid Allaya Amelie Antoine Camille Daniel Florent Ghislain Gregory Guy Heba Helene Jean Jean Jean Jerome Joachim Juan Jules Kevin Lisa Mathilde Max Maxime Mehdi Michel Robin Romain Servet Servet Thomas Vanessa Adrien Diogene Dominique Gengis Hubert Jean Jean-Marc Jean-Philippe Julien Julien Lucah Magali Matthieu Nicolas Pacome Philippe Rachel Sarra Stephane Stephen Tristan Vanessa Walid Yazid Alexis Arthur Bernard Dadom Denis Franck Frederic Jc Jugurtha Laurent Luc Noemie Raphael Adrien Alice Anthony Aurelien Baptiste Beatrice Brayan Chantal Chloe Christian Christophe Christophe Clement Cyrille Elodie Emmanuel Erwan Fabien Farid Fenris Firmin Florent Florent Florian Frank Gaetan Gilles Gregoire Guillaume Hammy Henri Jacques Jean Jessica Jocelyne Jonathan Jules-Arthur Julien Kevin Krystel Lamro Laurent Luc Ludovic Ludovic Marc-Andre Marguerite Marilou Marine Mathieu Max Michel Michel Morgane N Nadege Nathalie Nazha Nicolas Nicolas Nicolas Nicolas Nicolas Nicolas Noemie Olivier Ouerfelli Philippe Pierre Rami Remi Remy Romain Romain Sam Sam Sarra Steeve Stephane Sven Thomas Thomas Timothee Vassilis Yann Yann Yoan Younes Adrien Agnes Alexis Arnaud Christine Christophe Clement Dani Denis Florence Florian Gregoire Hassen Hichem Jacques Jean Jean-Baptiste Jeremie Jeremie Kevin Kevin Lilou Margaux Mhammed Mickael N Nicolas Philippe Pierre-Antoine Remy Rida Sarah Severine Sylvie Antoine Armen Arthur Caroline Djebril Edwige Emmanuel Hakim Jean Jean-Baptiste Jean-Christophe Jereeme Jonathan Leroy Marine Marlene Maxime Melanie Michael Nicolas Nicolas Omar Pascal Philippe Remi Renaud Rira Romain Romain Sebastien Vincent Alain Alain Alexandre Alexandre Antoine Bertrand Celine David Florian Haylan Jean Patrick Pierre Thibault Houriya Jean-Louis Lucie Ludovic Marco Marco Mariane Martin Mathieu Morgane Pascal Sebastien Vincent-Pascal Yoan Abdel Adla Alex Alexis Alexis Alexis Alice Amandine Amele Angelique Anthony Arthur Aurelie Aurelien Aymeric Benoit Bienvenu Bruno Charles-Elie Cherfi Christian Christophe Clement David Didier Didier Elie Eric Eric Etienne Fabien Florent Florian Franck Francois Frederic Gc Ghislain Gilles Gregoire Guelord Guillaume Guillaume Gus Gus Gwilherm Hamoudi Hamza Herve Herve Ibrahim Ines Ivan Jean Jean-Louis Jean-Marc Jereeme Joana John Joy-Jolyne Julien Julien Kamel Kevin Laetitia Laurent Lionel Loic Lucille Ludovic Manu Marianne Marie Marie Marine Marti Martine Martine Martine Mathieu Mathieu Maxime Mejdi Michel Moufid Mourad Nath Nathalie Nicola Nicolas Nizar Nolwenn Olivier Pascal Pascal Pascal Philippe Pierre Pierre Pierre Quentin Quentin Raphael Remi Remy Renaud Richard Romain Sebastien Siffax Sophie Sophie Tristan Tristan Gill Guillaume Hubert Matos Olivier Ouerfelli Sophie Sophie Sophie Yohann Alexandre Houriya Damien Emilie Fred Laura Loic Marilyne Mohamed Sabrina Brice Gaspard Jean Jerome Olivier Philippe Julie Pascal Ralph Samidil Sebastien Victor Gauthier Gilles Guillaume Michael Olivier Antonin Clement Couty David Douglas Eddine Florent Gaetan Julien Kevin Marion Mathieu Mathieu Mourad Nass Nizar Pierre-Antoine Adrien Alexia Bartoli Emmanuelle Gerald Jeremy Laurent Myriam Remi Simon Anthony Cedric David Jean Marc Matthieu Thibaut Thibaut Yves Adrien Arthur Aurelie Aurelie Benjamin Isabelle Lamro Nadir Olivier Anthony Delphine Hugo Luc Luc Pascal Pierre Pierre-Henri Romain Sinthujan Axel Christine Emek Laurent Marc Marion Nicolas Nicole Olivier Pascal Philippe Philippe Philippe Stephane Valerie Vanessa Angel Fenris Apolline Benoit Damien Igor Linda Nath Evan Francois-Xavier Guillaume Philippe Wissem Audrey Benjamin Paul Vivien Jean Justine Michael Omar Sebastien Joachim Mohammed Oussama Saad Saandi Stessy Romain Mickael Christine Edmond Julien Laura Sonia Alex Antoine Charlotte Cyril Firmin Pierre Akoi Arnaud Benedicte Frederic Mejdi Benoit Francoise Mourad Pascal Christine Emilie Francoise Matthieu Mohamed Sandy Matthieu Nicolas Sebastien Charlotte Benjamin Cedric Didier
# Defining Your Own Python Function
def Inquire(driver_id):
try:
target = BlaBlaCar[BlaBlaCar.driver_id == driver_id]
Driver_first_name =target.Driver_first_name.values[0]
Driver_Age =target.driver_age.values[0]
Average_trip_distance=target.trip_distance.values.mean()
Average_Price=target.price.values.mean()
return Driver_first_name, Driver_Age, Average_trip_distance, Average_Price
except Exception as e:
return "Not Found",0,0,0
Inquire(282461)
('Not Found', 0, 0, 0)
for drive_id in range(282460,282870):
Driver_first_name, Driver_Age, Average_trip_distance, Average_Price = Inquire(drive_id)
print("drive_id:%d, Driver_first_name:%s, Driver_Age:%d, Average_trip_distance:%d, Average_Price:%d"%(drive_id,Driver_first_name, Driver_Age, Average_trip_distance, Average_Price))
drive_id:282460, Driver_first_name:Philippe, Driver_Age:38, Average_trip_distance:464, Average_Price:30 drive_id:282461, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282462, Driver_first_name:Philippe, Driver_Age:40, Average_trip_distance:450, Average_Price:28 drive_id:282463, Driver_first_name:Philippe, Driver_Age:41, Average_trip_distance:459, Average_Price:30 drive_id:282464, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282465, Driver_first_name:Philippe, Driver_Age:43, Average_trip_distance:465, Average_Price:30 drive_id:282466, Driver_first_name:Philippe, Driver_Age:44, Average_trip_distance:462, Average_Price:29 drive_id:282467, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282468, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282469, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282470, Driver_first_name:Philippe, Driver_Age:48, Average_trip_distance:470, Average_Price:30 drive_id:282471, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282472, Driver_first_name:Philippe, Driver_Age:50, Average_trip_distance:492, Average_Price:25 drive_id:282473, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282474, Driver_first_name:Philippe, Driver_Age:52, Average_trip_distance:463, Average_Price:30 drive_id:282475, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282476, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282477, Driver_first_name:Philippe, Driver_Age:55, Average_trip_distance:460, Average_Price:30 drive_id:282478, Driver_first_name:Philippe, Driver_Age:56, Average_trip_distance:462, Average_Price:25 drive_id:282479, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282480, Driver_first_name:Philippe, Driver_Age:58, Average_trip_distance:462, Average_Price:30 drive_id:282481, Driver_first_name:Philippe, Driver_Age:59, Average_trip_distance:466, Average_Price:29 drive_id:282482, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282483, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282484, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282485, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282486, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282487, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282488, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282489, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282490, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282491, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282492, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282493, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282494, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282495, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282496, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282497, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282498, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282499, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282500, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282501, Driver_first_name:Philippe, Driver_Age:24, Average_trip_distance:465, Average_Price:23 drive_id:282502, Driver_first_name:Philippe, Driver_Age:25, Average_trip_distance:469, Average_Price:23 drive_id:282503, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282504, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282505, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282506, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282507, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282508, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282509, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282510, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282511, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282512, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282513, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282514, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282515, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282516, Driver_first_name:Philippe, Driver_Age:45, Average_trip_distance:462, Average_Price:27 drive_id:282517, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282518, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282519, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282520, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282521, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282522, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282523, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282524, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282525, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282526, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282527, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282528, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282529, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282530, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282531, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282532, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282533, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282534, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282535, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282536, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282537, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282538, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282539, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282540, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282541, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282542, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282543, Driver_first_name:Philippe, Driver_Age:29, Average_trip_distance:467, Average_Price:30 drive_id:282544, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282545, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282546, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282547, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282548, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282549, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282550, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282551, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282552, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282553, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282554, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282555, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282556, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282557, Driver_first_name:Philippe, Driver_Age:51, Average_trip_distance:494, Average_Price:32 drive_id:282558, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282559, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282560, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282561, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282562, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282563, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282564, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282565, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282566, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282567, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282568, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282569, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282570, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282571, Driver_first_name:Philippe, Driver_Age:22, Average_trip_distance:492, Average_Price:30 drive_id:282572, Driver_first_name:Philippe, Driver_Age:23, Average_trip_distance:462, Average_Price:30 drive_id:282573, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282574, Driver_first_name:Philippe, Driver_Age:25, Average_trip_distance:462, Average_Price:30 drive_id:282575, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282576, Driver_first_name:Philippe, Driver_Age:27, Average_trip_distance:465, Average_Price:30 drive_id:282577, Driver_first_name:Philippe, Driver_Age:28, Average_trip_distance:462, Average_Price:25 drive_id:282578, Driver_first_name:Philippe, Driver_Age:29, Average_trip_distance:462, Average_Price:30 drive_id:282579, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282580, Driver_first_name:Philippe, Driver_Age:31, Average_trip_distance:462, Average_Price:30 drive_id:282581, Driver_first_name:Philippe, Driver_Age:32, Average_trip_distance:468, Average_Price:30 drive_id:282582, Driver_first_name:Philippe, Driver_Age:33, Average_trip_distance:462, Average_Price:30 drive_id:282583, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282584, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282585, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282586, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282587, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282588, Driver_first_name:Philippe, Driver_Age:39, Average_trip_distance:462, Average_Price:30 drive_id:282589, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282590, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282591, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282592, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282593, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282594, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282595, Driver_first_name:Philippe, Driver_Age:46, Average_trip_distance:470, Average_Price:30 drive_id:282596, Driver_first_name:Philippe, Driver_Age:47, Average_trip_distance:451, Average_Price:30 drive_id:282597, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282598, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282599, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282600, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282601, Driver_first_name:Philippe, Driver_Age:52, Average_trip_distance:460, Average_Price:27 drive_id:282602, Driver_first_name:Philippe, Driver_Age:53, Average_trip_distance:462, Average_Price:29 drive_id:282603, Driver_first_name:Philippe, Driver_Age:54, Average_trip_distance:461, Average_Price:30 drive_id:282604, Driver_first_name:Philippe, Driver_Age:55, Average_trip_distance:470, Average_Price:28 drive_id:282605, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282606, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282607, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282608, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282609, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282610, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282611, Driver_first_name:Philippe, Driver_Age:62, Average_trip_distance:485, Average_Price:32 drive_id:282612, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282613, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282614, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282615, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282616, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282617, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282618, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282619, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282620, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282621, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282622, Driver_first_name:Philippe, Driver_Age:19, Average_trip_distance:462, Average_Price:28 drive_id:282623, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282624, Driver_first_name:Philippe, Driver_Age:24, Average_trip_distance:461, Average_Price:28 drive_id:282625, Driver_first_name:Philippe, Driver_Age:25, Average_trip_distance:462, Average_Price:28 drive_id:282626, Driver_first_name:Philippe, Driver_Age:26, Average_trip_distance:462, Average_Price:28 drive_id:282627, Driver_first_name:Philippe, Driver_Age:27, Average_trip_distance:456, Average_Price:28 drive_id:282628, Driver_first_name:Philippe, Driver_Age:28, Average_trip_distance:464, Average_Price:28 drive_id:282629, Driver_first_name:Philippe, Driver_Age:29, Average_trip_distance:469, Average_Price:28 drive_id:282630, Driver_first_name:Philippe, Driver_Age:30, Average_trip_distance:471, Average_Price:28 drive_id:282631, Driver_first_name:Philippe, Driver_Age:31, Average_trip_distance:484, Average_Price:28 drive_id:282632, Driver_first_name:Philippe, Driver_Age:32, Average_trip_distance:462, Average_Price:28 drive_id:282633, Driver_first_name:Philippe, Driver_Age:33, Average_trip_distance:468, Average_Price:28 drive_id:282634, Driver_first_name:Philippe, Driver_Age:34, Average_trip_distance:462, Average_Price:28 drive_id:282635, Driver_first_name:Philippe, Driver_Age:35, Average_trip_distance:473, Average_Price:28 drive_id:282636, Driver_first_name:Philippe, Driver_Age:36, Average_trip_distance:462, Average_Price:28 drive_id:282637, Driver_first_name:Philippe, Driver_Age:37, Average_trip_distance:462, Average_Price:28 drive_id:282638, Driver_first_name:Philippe, Driver_Age:38, Average_trip_distance:474, Average_Price:28 drive_id:282639, Driver_first_name:Philippe, Driver_Age:40, Average_trip_distance:462, Average_Price:28 drive_id:282640, Driver_first_name:Philippe, Driver_Age:41, Average_trip_distance:462, Average_Price:28 drive_id:282641, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282642, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282643, Driver_first_name:Philippe, Driver_Age:48, Average_trip_distance:461, Average_Price:28 drive_id:282644, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282645, Driver_first_name:Philippe, Driver_Age:51, Average_trip_distance:516, Average_Price:28 drive_id:282646, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282647, Driver_first_name:Philippe, Driver_Age:53, Average_trip_distance:455, Average_Price:28 drive_id:282648, Driver_first_name:Philippe, Driver_Age:54, Average_trip_distance:462, Average_Price:28 drive_id:282649, Driver_first_name:Philippe, Driver_Age:57, Average_trip_distance:466, Average_Price:28 drive_id:282650, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282651, Driver_first_name:Philippe, Driver_Age:61, Average_trip_distance:453, Average_Price:28 drive_id:282652, Driver_first_name:Philippe, Driver_Age:64, Average_trip_distance:459, Average_Price:28 drive_id:282653, Driver_first_name:Philippe, Driver_Age:66, Average_trip_distance:468, Average_Price:28 drive_id:282654, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282655, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282656, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282657, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282658, Driver_first_name:Philippe, Driver_Age:20, Average_trip_distance:455, Average_Price:25 drive_id:282659, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282660, Driver_first_name:Philippe, Driver_Age:22, Average_trip_distance:499, Average_Price:30 drive_id:282661, Driver_first_name:Philippe, Driver_Age:23, Average_trip_distance:458, Average_Price:26 drive_id:282662, Driver_first_name:Philippe, Driver_Age:24, Average_trip_distance:462, Average_Price:26 drive_id:282663, Driver_first_name:Philippe, Driver_Age:25, Average_trip_distance:532, Average_Price:23 drive_id:282664, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282665, Driver_first_name:Philippe, Driver_Age:27, Average_trip_distance:462, Average_Price:28 drive_id:282666, Driver_first_name:Philippe, Driver_Age:28, Average_trip_distance:477, Average_Price:25 drive_id:282667, Driver_first_name:Philippe, Driver_Age:29, Average_trip_distance:462, Average_Price:30 drive_id:282668, Driver_first_name:Philippe, Driver_Age:30, Average_trip_distance:462, Average_Price:25 drive_id:282669, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282670, Driver_first_name:Philippe, Driver_Age:32, Average_trip_distance:463, Average_Price:30 drive_id:282671, Driver_first_name:Philippe, Driver_Age:33, Average_trip_distance:464, Average_Price:25 drive_id:282672, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282673, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282674, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282675, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282676, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282677, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282678, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282679, Driver_first_name:Philippe, Driver_Age:41, Average_trip_distance:497, Average_Price:32 drive_id:282680, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282681, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282682, Driver_first_name:Philippe, Driver_Age:44, Average_trip_distance:407, Average_Price:26 drive_id:282683, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282684, Driver_first_name:Philippe, Driver_Age:46, Average_trip_distance:462, Average_Price:25 drive_id:282685, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282686, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282687, Driver_first_name:Philippe, Driver_Age:49, Average_trip_distance:467, Average_Price:29 drive_id:282688, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282689, Driver_first_name:Philippe, Driver_Age:51, Average_trip_distance:470, Average_Price:28 drive_id:282690, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282691, Driver_first_name:Philippe, Driver_Age:53, Average_trip_distance:462, Average_Price:28 drive_id:282692, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282693, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282694, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282695, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282696, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282697, Driver_first_name:Philippe, Driver_Age:59, Average_trip_distance:471, Average_Price:31 drive_id:282698, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282699, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282700, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282701, Driver_first_name:Philippe, Driver_Age:63, Average_trip_distance:462, Average_Price:25 drive_id:282702, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282703, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282704, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282705, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282706, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282707, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282708, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282709, Driver_first_name:Philippe, Driver_Age:21, Average_trip_distance:462, Average_Price:25 drive_id:282710, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282711, Driver_first_name:Philippe, Driver_Age:23, Average_trip_distance:477, Average_Price:31 drive_id:282712, Driver_first_name:Philippe, Driver_Age:24, Average_trip_distance:469, Average_Price:30 drive_id:282713, Driver_first_name:Philippe, Driver_Age:25, Average_trip_distance:472, Average_Price:32 drive_id:282714, Driver_first_name:Philippe, Driver_Age:26, Average_trip_distance:466, Average_Price:30 drive_id:282715, Driver_first_name:Philippe, Driver_Age:27, Average_trip_distance:484, Average_Price:31 drive_id:282716, Driver_first_name:Philippe, Driver_Age:28, Average_trip_distance:469, Average_Price:28 drive_id:282717, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282718, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282719, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282720, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282721, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282722, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282723, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282724, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282725, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282726, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282727, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282728, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282729, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282730, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282731, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282732, Driver_first_name:Philippe, Driver_Age:44, Average_trip_distance:462, Average_Price:31 drive_id:282733, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282734, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282735, Driver_first_name:Philippe, Driver_Age:47, Average_trip_distance:470, Average_Price:31 drive_id:282736, Driver_first_name:Philippe, Driver_Age:48, Average_trip_distance:462, Average_Price:30 drive_id:282737, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282738, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282739, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282740, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282741, Driver_first_name:Philippe, Driver_Age:53, Average_trip_distance:464, Average_Price:30 drive_id:282742, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282743, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282744, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282745, Driver_first_name:Philippe, Driver_Age:57, Average_trip_distance:467, Average_Price:30 drive_id:282746, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282747, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282748, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282749, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282750, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282751, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282752, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282753, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282754, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282755, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282756, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282757, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282758, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282759, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282760, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282761, Driver_first_name:Philippe, Driver_Age:25, Average_trip_distance:462, Average_Price:30 drive_id:282762, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282763, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282764, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282765, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282766, Driver_first_name:Philippe, Driver_Age:30, Average_trip_distance:476, Average_Price:22 drive_id:282767, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282768, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282769, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282770, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282771, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282772, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282773, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282774, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282775, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282776, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282777, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282778, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282779, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282780, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282781, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282782, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282783, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282784, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282785, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282786, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282787, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282788, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282789, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282790, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282791, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282792, Driver_first_name:Philippe, Driver_Age:56, Average_trip_distance:514, Average_Price:34 drive_id:282793, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282794, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282795, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282796, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282797, Driver_first_name:Philippe, Driver_Age:62, Average_trip_distance:503, Average_Price:31 drive_id:282798, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282799, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282800, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282801, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282802, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282803, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282804, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282805, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282806, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282807, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282808, Driver_first_name:Philippe, Driver_Age:22, Average_trip_distance:463, Average_Price:30 drive_id:282809, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282810, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282811, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282812, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282813, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282814, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282815, Driver_first_name:Philippe, Driver_Age:29, Average_trip_distance:431, Average_Price:30 drive_id:282816, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282817, Driver_first_name:Philippe, Driver_Age:31, Average_trip_distance:456, Average_Price:25 drive_id:282818, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282819, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282820, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282821, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282822, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282823, Driver_first_name:Philippe, Driver_Age:37, Average_trip_distance:462, Average_Price:30 drive_id:282824, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282825, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282826, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282827, Driver_first_name:Philippe, Driver_Age:41, Average_trip_distance:468, Average_Price:28 drive_id:282828, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282829, Driver_first_name:Philippe, Driver_Age:43, Average_trip_distance:468, Average_Price:30 drive_id:282830, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282831, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282832, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282833, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282834, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282835, Driver_first_name:Philippe, Driver_Age:49, Average_trip_distance:462, Average_Price:30 drive_id:282836, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282837, Driver_first_name:Philippe, Driver_Age:51, Average_trip_distance:469, Average_Price:30 drive_id:282838, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282839, Driver_first_name:Philippe, Driver_Age:53, Average_trip_distance:464, Average_Price:30 drive_id:282840, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282841, Driver_first_name:Philippe, Driver_Age:55, Average_trip_distance:517, Average_Price:32 drive_id:282842, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282843, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282844, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282845, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282846, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282847, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282848, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282849, Driver_first_name:Philippe, Driver_Age:64, Average_trip_distance:469, Average_Price:28 drive_id:282850, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282851, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282852, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282853, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282854, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282855, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282856, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282857, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282858, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282859, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282860, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282861, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282862, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282863, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282864, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282865, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282866, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282867, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282868, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0 drive_id:282869, Driver_first_name:Not Found, Driver_Age:0, Average_trip_distance:0, Average_Price:0
#Data Visualization & Data Analysis
#Data Visualization
#Bar chart
import numpy as np
Bar_chart = BlaBlaCar.pivot_table(index="Satisfaction_Livel", values=["min_price_depd","max_price_depd"],aggfunc=np.mean)
y=(Bar_chart.max_price_depd+Bar_chart.min_price_depd)/2
fig, ax = plt.subplots(figsize=(10, 7))
ax.bar(x=Bar_chart.index, height=(Bar_chart.max_price_depd+Bar_chart.min_price_depd)/2)
ax.bar(
x=Bar_chart.index,# Matplotlib自动将非数值变量转化为x轴坐标
height=y, # 柱子高度，y轴坐标
width=0.6, # 柱子宽度，默认0.8，两根柱子中心的距离默认为1.0
align="center", # 柱子的对齐方式，'center' or 'edge'
color="grey", # 柱子颜色
edgecolor="red", # 柱子边框的颜色
linewidth=2.0 # 柱子边框线的大小
)
ax.set_title("avarge by Satisfaction_Level", fontsize=15)
xticks = ax.get_xticks()
for i in range(len(y)):
xy = (xticks[i], y[i] * 1.03)
s = str(round(y[i],3))
ax.annotate(
s=s, # 要添加的文本
xy=xy, # 将文本添加到哪个位置
fontsize=12, # 标签大小
color="blue", # 标签颜色
ha="center", # 水平对齐
va="baseline" # 垂直对齐
)
:24: MatplotlibDeprecationWarning: The 's' parameter of annotate() has been renamed 'text' since Matplotlib 3.3; support for the old name will be dropped two minor releases later. ax.annotate(
#Pie chart
Pie_chart = BlaBlaCar.pivot_table(index="driver_status", values="nb_evaluation",aggfunc=np.max)
my_dpi=96
plt.figure(figsize=(480/my_dpi,480/my_dpi),dpi=my_dpi)
plt.pie(x=Pie_chart.nb_evaluation,#指定绘图数据
labels=Pie_chart.index,#为饼图添加标签说明
autopct='%.2f%%'
)
plt.show()
#histograme
plt.figure(figsize=(15,5))
nums,bins,patches = plt.hist(BlaBlaCar.driver_age,bins=[0,20,40,60,80,100],edgecolor='k')
plt.xticks(bins,bins)
for num,bin in zip(nums,bins):
plt.annotate(num,xy=(bin,num),xytext=(bin+1.5,num+0.5))
plt.show()
#Data Analysis analysis = BlaBlaCar.pivot_table(index="driver_id", values=["Driver_first_name","driver_status", "trip_distance","mean_price_depd", "car_rating","detour_time","music","smoking"])
analysis["Business_Index"] = analysis.mean_price_depd * analysis.trip_distance analysis["Confort_Index"] = 3 + analysis.car_rating + analysis.detour_time + analysis.music - analysis.smoking analysis["result"]=analysis.Business_Index/(1+analysis.Confort_Index)
result=analysis.sort_values(by = "result",ascending = False) result[0:5]
| car_rating | detour_time | mean_price_depd | music | smoking | trip_distance | Business_Index | Confort_Index | result | |
|---|---|---|---|---|---|---|---|---|---|
| driver_id | |||||||||
| 54213 | 0.0 | 0.0 | 29.100958 | 0.0 | 0.0 | 864.5 | 25157.777975 | 3.0 | 6289.444494 |
| 316597 | 2.0 | 0.0 | 30.070442 | 0.0 | 0.0 | 1131.0 | 34009.669902 | 5.0 | 5668.278317 |
| 280513 | 2.0 | 0.0 | 30.220057 | 1.0 | 1.0 | 1102.0 | 33302.502814 | 5.0 | 5550.417136 |
| 306909 | 0.0 | 0.0 | 29.580454 | 0.0 | 0.0 | 750.0 | 22185.340500 | 3.0 | 5546.335125 |
| 21274 | 0.0 | 0.0 | 31.129770 | 0.0 | 0.0 | 704.0 | 21915.358080 | 3.0 | 5478.839520 |
#Machine Learning Algorithm
#Supervised Machine Learning
from sklearn.linear_model import LogisticRegression
from sklearn.model_selection import train_test_split
from sklearn.metrics import accuracy_score
# 使用如下特征做预测
cols = ["music","talk", "pet", "smoking", "detour_time"]
# 创建 X (特征) 和 y (类别标签)
X = BlaBlaCar[cols]
y = BlaBlaCar['Recommendation']
# 将 X 和 y 分为两个部分
X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=2)
# 检测 logistic regression 模型的性能
# TODO 添加代码:
# 1.训练模型,
# 2.根据模型, 以 X_test 为输入, 生成变量 y_pred
logreg = LogisticRegression()
logreg.fit(X_train, y_train.values.reshape(-1))
y_pred = logreg.predict(X_test)
# print('在测试数据集上面的预测准确率: {:.2f}'.format(logreg.score(X_test, y_test)))
print('Train/Test split results:')
print("准确率为 %2.3f" % accuracy_score(y_test, y_pred))
Train/Test split results: 准确率为 1.000
#analysi from sklearn.metrics import classification_report print(classification_report(y_test, y_pred))
precision recall f1-score support
0 1.00 1.00 1.00 9743
1 1.00 1.00 1.00 9782
accuracy 1.00 19525
macro avg 1.00 1.00 1.00 19525
weighted avg 1.00 1.00 1.00 19525
#ROC曲线
#曲线下方所围面积越大，分类效果越好
from sklearn.metrics import roc_auc_score
from sklearn.metrics import roc_curve
logit_roc_auc = roc_auc_score(y_test, logreg.predict(X_test))
fpr, tpr, thresholds = roc_curve(y_test, logreg.predict_proba(X_test)[:,1])
plt.figure()
plt.plot(fpr, tpr, label='Logistic Regression (area = %0.2f)' % logit_roc_auc)
plt.plot([0, 1], [0, 1],'r--')
plt.xlim([0.0, 1.0])
plt.ylim([0.0, 1.05])
plt.xlabel('False Positive Rate')
plt.ylabel('True Positive Rate')
plt.title('Receiver operating characteristic')
plt.legend(loc="lower right")
plt.savefig('Log_ROC')
plt.show()
#分析：自己翻译一下：预测率达到百分之百，发现效果非常好
# K-means X=np.array(BlaBlaCar[["trip_distance","mean_price_depd"]]) X=X[~np.isnan(X).any(axis=1)] print(np.isnan(X).any())
False
from sklearn.cluster import KMeans n_clusters=3 cluster = KMeans(n_clusters=n_clusters,random_state=0).fit(X) centroid=cluster.cluster_centers_
y_pred = cluster.labels_#获取训练后对象的每个样本的标签
centtrod = cluster.cluster_centers_
color=['red','pink','orange','gray']
fig, axi1=plt.subplots(1)
for i in range(n_clusters):
axi1.scatter(X[y_pred==i, 0], X[y_pred==i, 1],
marker='o',
s=8,
c=color[i])
axi1.scatter(centroid[:,0],centroid[:,1],marker='x',s=100,c='black')
# 看的出来这个效果很垃圾啊
