Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

priceyearOfReg gearbox modelkilometer fuelType brand 480 1993 manuell golf 15000

ID: 3593144 • Letter: P

Question

priceyearOfReg gearbox modelkilometer fuelType brand 480 1993 manuell golf 150000 benzin volkswagen 125000 diesel audi 125000 diesel jeep 150000 benzin volkswagen 18300 2011 manuell 9800 2004 automatik grand 1500 2001 manuel golf 3600 2008 manuell fabia Apply MapReduce to find number of cars in each brand? Total priceforeach brand? oldest car in each brand? 90000 diesel skoda 150000 benzin bmw 650 1995 manuell 3er 2200 2004 manuell 2_reihe 150000 benzin peugeot 40000 benzin volkswagen 0000 benzin ford 0 1980 manuell andere 45002014 manuell cmax 999 1998 manuell golf 2000 2004 manuell 3_reihe 150000 benzin mazda 150000 diesel volkswagen 2799 2005 manuell passat 150000 diesel volkswagen 999 1995 manuell passat 150000 benzin volkswagen 2500 2004 manuell passat 150000 diesel volkswagen 70000 diesel nissan 5000 benzin ford 17999 2011 manuell navara 450 1910 150000 benzin volkswagen 300 2016 17502004 automatik twingo150000 benzin renault 7550 2007 manuell c max 1850 2004 manuell a klasse 150000 benzin mercedes benz 150000 diesel ford 04002009 manuell scirocco 100000 benzinvolkswagen 36992002 automatik Ser 2900 150000 benzin bmw 50000 benzin opel 150000 benzin seat 2018 manuell meriva 50 1997 manuell arosa

Explanation / Answer

1. number of cars in each brand:

in the give data taken brand column as key and index as value

applying Mapper task():

(volkswagen,1)

(audi,1)

(jeep,1)

(volkswagen,1)

(skoda,1)

(bmw,1)

(peugeot,1)

(volkswagen,1)

(ford,1)

(volkswagen,1)

(mazda,1)

(volkswagen,1)

(volkswagen,1)

(volkswagen,1)

(nissan,1)

(ford,1)

(volkswagen,1)

(renault,1)

(ford,1)

(mercedes_benz,1)

(volkswagen,1)

(bmw,1)

(opel,1)

(seat,1)

now applying Reducer() task:

(volkswagen,9)

(audi,1)

(jeep,1)

(skoda,1)

(bmw,2)

(peugeot,1)

(ford,3)

(mazda,1)

(nissan,1)

(renault,1)

(mercedes_benz,1)

(opel,1)

(seat,1)

After MAP(), REDUCER() task

NUMBER OF CARS IN EACH BRAND:

Volkswagen                             9

Audi                                         1

Jeep                                         1

Skoda                                     1

Bmw                                        2

Peugeot                                   1

Ford                                         3

Mazda                                     1

Nissan                                     1

Renault                                    1

mercedes_benz                       1

opel                                         1

seat                                         1

2.Total price for brand:

brand, price taken as (key, value) prair

MAPPPER() task:

(volkswagen,480)

(audi,18300)

(jeep,9800)

(volkswagen,1500)

(skoda,3600)

(bmw,650)

(peugeot,2200)

(volkswagen,0)

(ford,14500)

(volkswagen,999)

(mazda,2000)

(volkswagen,2799)

(volkswagen,999)

(volkswagen,2500)

(nissan,17999)

(ford,450)

(volkswagen,300)

(renault,1750)

(ford,7550)

(mercedes_benz,1850)

(volkswagen,10400)

(bmw,3699)

(opel,2900)

(seat,450)

REDUCER() task:

(volkswagen, 19977)

(audi,18300)

(jeep,9800)

(skoda, 3660)

(bmw,4349)

(peugeot,2200)

(ford,22500)

(mazda,2000)

(nissan,17999)

(renault,1750)

(mercedes_benz,1850)

(opel,2900)

(seat,450)

after MAP() and REDUCR() task total price for each brand

volkswagen                          19977

                          audi                          18300                         

                          jeep                          9800                         

                          skoda                          3660                         

                          bmw                          4349                         

                          peugeot                          2200                         

                          ford                          22500                         

                          mazda                          2000                          

                          nissan                          17999                         

                          renault                          1750                         

                          mercedes_benz                          1850                         

                          opel                          2900                         

                          seat                          450

3. oldest cars in each brand:

taken brand as key, yearOfReg value in (key,value) prair

(brand, yearOfReg)

MAPPER():

(volkswagen,1993)

(audi,2011)

(jeep,2004)

(volkswagen,2001)

(skoda,2008)

(bmw,1995)

(peugeot,2004)

(volkswagen,1998)

(ford,2014)

(volkswagen,1998)

(mazda,2004)

(volkswagen,2005)

(volkswagen,1995)

(volkswagen,2004)

(nissan,2011)

(ford,1910)

(volkswagen,2016)

(renault,2004)

(ford,2007)

(mercedes_benz,2004)

(volkswagen,2009)

(bmw,2002)

(opel,2018)

(seat,1997)

REFUCER():

(volkswagen,1993,2001,1980,1998,2005,1995,2004,2016,2009)

(audi,2011)

(jeep,2004)

(skoda,2008)

(bmw,1995,2002)

(peugeot,2004)

(ford,2014,1910,2007)

(mazda,2004)

(nissan,2011)

(renault,2004)

(mercedes_benz,2004)

(opel,2018)

(seat,1997)

after MAP(), REDUCER() task oldest car in each brand is

volkswagen                      1980

                          audi                          2001                         

                          jeep                          2004                      

                          skoda                          2008                         

                          bmw                          1995                    

                          peugeot                          2004                         

                          ford                          1910                      

                          mazda                          2004                          

                          nissan                          2011                         

                          renault                          2004          

                          mercedes_benz                          2004                         

                          opel                          2018                         

                          seat                          1997