The market share analysis of rides in New York City was based in part on the data from the New York City Taxi and Limousine Commission. Data on eachride can be found on the website www.nyc.gov/html/tlc/? html/about/trip_record_data.shtml. Because there are over 10,000,000 rides a month, the monthly files are large?up to 2 GB each. For each ride they contain information on the location, costs, and date, among other variables. Here are 13 columns and the first 11rows (of 11,934,338!) for Yellow Taxis in the month of April 2016. (For a fascinating analysis of taxi data in New York and Chicago, visit the website toddwschneider.com/)

Transcribed Image Text:

Plan to Purchase Car? City or Mobile Household ID Age Rural? Device Education Gender Latitude Longitude Country Town Size Size 1.2855 103.8565 Singapore City with 5 million- 4 10 million people 00001700-9f84-0134-2d50-0aaafcbd6blf 29 yes city mobile high female 000la0c0-a08e-0134-cf68-0a62e1402143 39 yes city mobile high female -12.0678 -77.0886 Peru Town with 1 000- 5 or more 50 000 people City with 250 000 1 million people 000497f0-9efa-0134-9d13-0aaafcbd6blf 19 city mobile low female -33.0422 -71.3733 Chile 5 or more по 000501c0-ba4c-0134-49bc-Oaeaf0818377 27 city desktop medium female 4.6492 -74.0628 Colombia City with more than 10 million people по 2 0007a460-9ef0-0134-0666-0a62e1402143 35 city desktop high female 41.0214 28.9684 Turkey City with more than 10 million people 5 or more yes 000861c0-a289-0134-30ba-Oa62e1402143 53 rural mobile high male 33.7208 130.6997 Japan Town with 1 000- 2 по 50 000 people City with 250 000- 1 million people 0008dbc0-ac5e-0134-cb4a-Oaaafcbd6blf 21 yes city tablet high female 43.122 -79.805 Canada City with 50 000- 250 000 people 000920d0-9f42-0134-54fc-Oaaafcbd6blf 19 city mobile high female 3.0833 101.5333 Malaysia по 000ae030-b561-0134-aeb9-0aaafcbd6blf 44 city mobile high female 1.2855 103.8565 Singapore City with 50 000- 250 000 people yes 2 120.9721 Philippines City with 250 000- million people 000cb8d0-9dfl-0134-4a2a-0aaafcbd6blf no city mobile high female 14.5955 3