Questions 1. Find the 'most popular' bike, i.e. the bike that has made the highest number of trips (1.5 pts) 2. Find the number of trips made by each subscription type. (1.5 pts) 3. Build a table that shows which stations are connected, and the minimum duration between them. You can use either station id or station name. Save this table as a comma separated text file in '/user/assignment1/stationlist.csv' in HDFS. Include the directory listing of the output directory and first five lines of the output file in your submission. (3 pts) 4. Find the number of trips originating from each landmark. Your output should include the landmark name and the number of trip originating from it. (3 pts) 5. Find the number of trips crossing landmarks, i.e. trips that originate in one landmark and end in another. Your output should include the originating and ending landmark names and the number of trips between them. (6 pts) . station_data.csv - station id: station ID number - name: name of station - lat: latitude - long: longitude -dockcount: number of total docks at station - landmark: city (San Francisco, Redwood City, Palo Alto, Mountain View, San Jose) - installation: original date that station was installed. - 2 San Jose Diridon Caltrain Station 3 San Jose Civic Center 4 Santa Clara at Almaden 5 Adobe on Almaden 6 San Pedro Square 7 Paseo de San Antonio 8 San Salvador at 1st 9 Japantown 10 San Jose City Hall 11 MLK Library 12 SJSU 4th at San Carlos 13 St James Park 14 Arena Green / SAP Center 16 SJSU - San Salvador at 9th 21 Franklin at Maple 22 Redwood City Caltrain Station 23 San Mateo County Center 24 Redwood City Public Library 25 Stanford in Redwood City 26 Redwood City Medical Center 27 Mountain View City Hall 28 Mountain View Caltrain Station 29 San Antonio Caltrain Station 30 Evelyn Park and Ride 31 San Antonio Shopping Center 32 Castro Street and El Camino Real 33 Rengstorff Avenue / California Street 34 Palo Alto Caltrain Station 35 University and Emerson 36 California Ave Caltrain Station 37 Cowper at University 38 Park at Olive 41 Clay at Battery 42 Davis at Jackson 37.32973 37.3307 37.33399 37.33142 37.33672 37.3338 37.33017 37.34874 37.33739 37.33589 37.33281 37.3393 37.33269 37.33396 37.48176 37.48608 37.48762 37.48422 37.48537 37.48768 37.38922 37.39436 37.40694 37.39028 37.40044 37.38596 37.40024 37.44399 37.44452 37.42908 37.4486 37.42568 37.795 37.79728 -121.902 -121.889 -121.895 -121.893 -121.894 -121.887 -121.886 -121.895 -121.887 -121.886 -121.884 -121.89 -121.9 -121.877 -122.227 -122.232 -122.23 -122.227 -122.203 -122.223 -122.082 -122.077 -122.107 -122.067 -122.108 -122.084 -122.099 -122.165 -122.163 -122.143 -122.16 -122.138 -122.4 -122.398 27 San Jose 8/6/2013 15 San Jose 8/5/2013 11 San Jose 8/6/2013 19 San Jose 8/5/2013 15 San Jose 8/7/2013 15 San Jose 8/7/2013 15 San Jose 8/5/2013 15 San Jose 8/5/2013 15 San Jose 8/6/2013 19 San Jose 8/6/2013 19 San Jose 8/7/2013 15 San Jose 8/6/2013 19 San Jose 8/5/2013 15 San Jose 8/7/2013 15 Redwood C8/12/2013 25 Redwood C8/15/2013 15 Redwood C8/15/2013 15 Redwood C8/12/2013 15 Redwood C8/12/2013 15 Redwood C8/12/2013 15 Mountain 18/16/2013 23 Mountain 18/15/2013 23 Mountain 18/15/2013 15 Mountain 18/16/2013 15 Mountain \\12/31/2013 11 Mountain (12/31/2013 15 Mountain 18/16/2013 23 Palo Alto 8/14/2013 11 Palo Alto 8/15/2013 15 Palo Alto 8/14/2013 11 Palo Alto 8/14/2013 15 Palo Alto 8/14/2013 15 San Francis 8/19/2013 15 San Francis 8/19/2013 45 Commercial at Montgomery 46 Washington at Kearney 47 Post at Kearney 48 Embarcadero at Vallejo 49 Spear at Folsom 50 Harry Bridges Plaza (Ferry Building) 51 Embarcadero at Folsom 39 Powell Street BART 54 Embarcadero at Bryant 55 Temporary Transbay Terminal (Howard at Beale) 56 Beale at Market 57 5th at Howard 58 San Francisco City Hall 59 Golden Gate at Polk 60 Embarcadero at Sansome 61 2nd at Townsend 62 2nd at Folsom 63 Howard at 2nd 64 2nd at South Park 65 Townsend at 7th 66 South Van Ness at Market 67 Market at 10th 68 Yerba Buena Center of the Arts (3rd @ Howard) 69 San Francisco Caltrain 2 (330 Townsend) 70 San Francisco Caltrain (Townsend at 4th) 71 Powell at Post (Union Square) 72 Civic Center BART (7th at Market) 73 Grant Avenue at Columbus Avenue 74 Steuart at Market 75 Mechanics Plaza (Market at Battery) 76 Market at 4th 77 Market at Sansome 80 Santa Clara County Civic Center 82 Broadway St at Battery St 37.79423 -122.403 37.79543 -122.405 37.78898 -122.403 37.79995 -122.399 37.7903 -122.391 37.79539 -122.394 37.79146 -122.391 37.78387 -122.408 37.78715 -122.388 37.78976 -122.395 37.79225 -122.397 37.78175 -122.405 37.77865 -122.418 37.78133 -122.419 37.80477 -122.403 37.78053 -122.39 37.7853 -122.396 37.78698 -122.398 37.78226 -122.393 37.77106 -122.403 37.77481 -122.419 37.77662 -122.417 37.78488 -122.401 37.7766 -122.395 37.77662 -122.395 37.78845 -122.408 37.78104 -122.412 37.79852 -122.407 37.79414 -122.394 37.7913 -122.399 37.78631 -122.405 37.78963 -122.401 37.3526 -121.906 37.79854 -122.401 15 San Francis 8/19/2013 15 San Francis 8/19/2013 19 San Francis 8/19/2013 15 San Francis 8/19/2013 19 San Francis 8/20/2013 23 San Francis 8/20/2013 19 San Francis 8/20/2013 19 San Francis 8/25/2013 15 San Francis 8/20/2013 23 San Francis 8/20/2013 19 San Francis 8/20/2013 15 San Francis 8/21/2013 19 San Francis 8/21/2013 23 San Francis 8/21/2013 15 San Francis 8/21/2013 27 San Francis 8/22/2013 19 San Francis 8/22/2013 19 San Francis 8/22/2013 15 San Francis 8/22/2013 15 San Francis 8/22/2013 19 San Francis 8/23/2013 27 San Francis 8/23/2013 19 San Francis 8/23/2013 23 San Francis 8/23/2013 19 San Francis 8/23/2013 19 San Francis 8/23/2013 23 San Francis 8/23/2013 15 San Francis 8/21/2013 23 San Francis 8/25/2013 19 San Francis 8/25/2013 19 San Francis 8/25/2013 27 San Francis 8/25/2013 15 San Jose 12/31/2013 15 San Francis 1/22/2014 83 Mezes Park 84 Ryland Park 37.49127 37.34273 -122.236 -121.896 15 Redwood C2/20/2014 15 San Jose 4/9/2014