Home Verkennen Help
Inloggen
pranav
/
Data-Analyst-Nanodegree
spiegel van https://github.com/pranavsuri/Data-Analyst-Nanodegree
1
0
Vork 0
Bestanden Issues 0 Wiki
Boom: e17e9c937c
Aftakkingen Labels
Data-Analyst-Na...
/
P0 - Bay Area Bike Share Analysis
/
201408_README.txt

201408_README.txt 2.2 KB
Geschiedenis Ruwe

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 
  1. FILE LIST
    2. 

  2. 1) 201408_status_data.csv – approx. 18 million records of status data (bike and dock availability)
    3. 

  3. 2) 201408_station_data.csv – 70 records – station latitude, longitude, name, dockcount, installation date
    4. 

  4. 3) 201408_trip_data.csv – approx. 171,000 records of individual trips
    5. 

  5. 4) 201408_weather_data.csv – 920 records of daily weather by city
    6. 

  6. 

  7. Files contain data from  3/1/14 to 8/31/14.
    8. 

  8. 

  9. 1) STATUS DATA
    10. 

  10. FILE = "201408_status_data.csv"
    11. 

  11. -station_id: station ID number (use "201408_station_data.csv" to find corresponding station information)
    12. 

  12. -bikes_available: number of available bikes
    13. 

  13. -docks_available: number of available docks
    14. 

  14. -time: date and time, PST
    15. 

  15. 

  16. 2) STATION INFORMATION
    17. 

  17. FILE = "201408_station_data.csv"
    18. 

  18. -station_id: station ID number (corresponds to "station_id" in "201408_status_data.csv")
    19. 

  19. -name: name of station
    20. 

  20. -lat: latitude
    21. 

  21. -long: longitude
    22. 

  22. -dockcount: number of total docks at station
    23. 

  23. -landmark: city (San Francisco, Redwood City, Palo Alto, Mountain View, San Jose)
    24. 

  24. -installation: date that station was installed 
    25. 

  25. 

  26. 3) TRIP DATA
    27. 

  27. FILE = "201408_trip_data.csv"
    28. 

  28. -Trip ID: numeric ID of bike trip
    29. 

  29. -Duration: time of trip in seconds
    30. 

  30. -Start Date: start date of trip with date and time, in PST
    31. 

  31. -Start Station: station name of start station
    32. 

  32. -Start Terminal: numeric reference for start station
    33. 

  33. -End Date: end date of trip with date and time, in PST
    34. 

  34. -End Station: station name for end station
    35. 

  35. -End Terminal: numeric reference for end station
    36. 

  36. -Bike #: ID of bike used
    37. 

  37. -Subscription Type: Subscriber = annual member; Customer = 24-hour or 3-day member
    38. 

  38. -Zip Code: Home zip code of user (only available for annual members)
    39. 

  39. 

  40. 4) WEATHER DATA
    41. 

  41. FILE = "201408_weather_data.csv"
    42. 

  42. Daily weather information per service area. Weather is listed from north to south (San Francisco, Redwood City, Palo Alto, Mountain View, San Jose).
    43. 

  43. 	
    44. 

  44. -Max_Visibility_Miles 	
    45. 

  45. -Mean_Visibility_Miles 	
    46. 

  46. -Min_Visibility_Miles 	 		
    47. 

  47. -Precipitation_In 	"numeric, in form x.xx but alpha ""T""= trace when amount less than .01 inch"	
    48. 

  48. -Cloud_Cover 	"scale of 0-8, 0=clear"	
    49. 

  49. -Events	"text field - entries: rain, fog, thunderstorm"	
    50. 

  50. -zip code: 94107=San Francisco, 94063=Redwood City, 94301=Palo Alto, 94041=Mountain View, 95113= San Jose"	
    51.