数据清洗+分析画图+机器学习小项目
发布时间
阅读量：
阅读量
一份数据科学的考试答案，有感兴趣的人的话会做一个解析，还是很全面的，从数据清洗到分析画图到机器学习从涉及到了，很全面的一个小项目
# 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" # 垂直对齐
)
<ipython-input-10-7252000438ce>: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')
# 看的出来这个效果很垃圾啊
全部评论 (0)
还没有任何评论哟~