Data_Types_for_Data_Science.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Course 3: Meet the collections module"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from collections import Counter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   station_id         stationname        date         daytype  rides\n",
      "0       40010  Austin-Forest Park  01/01/2015  SUNDAY/HOLIDAY    587\n",
      "1       40010  Austin-Forest Park  01/02/2015         WEEKDAY   1386\n",
      "2       40010  Austin-Forest Park  01/03/2015        SATURDAY    785\n",
      "3       40010  Austin-Forest Park  01/04/2015  SUNDAY/HOLIDAY    625\n",
      "4       40010  Austin-Forest Park  01/05/2015         WEEKDAY   1752\n"
     ]
    }
   ],
   "source": [
    "collection = pd.read_csv('data/cta_daily_station_totals.csv')\n",
    "print(collection.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.series.Series"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Using Counter on lists\n",
    "station = collection['stationname']\n",
    "type(station)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Counter({'Austin-Forest Park': 700, 'Harlem-Lake': 700, 'Pulaski-Lake': 700, 'Quincy/Wells': 700, 'Davis': 700, \"Belmont-O'Hare\": 700, 'Jackson/Dearborn': 700, 'Sheridan': 700, 'Damen-Brown': 700, 'Morse': 700, '35th/Archer': 700, '51st': 700, 'Dempster-Skokie': 700, 'Pulaski-Cermak': 700, 'LaSalle/Van Buren': 700, 'Ashland-Lake': 700, 'Oak Park-Forest Park': 700, 'Sox-35th-Dan Ryan': 700, 'Randolph/Wabash': 700, 'Damen-Cermak': 700, 'Western-Forest Park': 700, 'Cumberland': 700, '79th': 700, 'Kedzie-Homan-Forest Park': 700, 'State/Lake': 700, 'Main': 700, 'Central-Lake': 700, 'Ashland/63rd': 700, 'Indiana': 700, 'Western-Orange': 700, 'Division/Milwaukee': 700, 'Grand/State': 700, 'Berwyn': 700, 'UIC-Halsted': 700, 'Southport': 700, 'Washington/Dearborn': 700, 'Clark/Lake': 700, 'Forest Park': 700, 'Noyes': 700, 'Cicero-Cermak': 700, 'Clinton-Forest Park': 700, 'California-Cermak': 700, '95th/Dan Ryan': 700, 'Merchandise Mart': 700, 'Racine': 700, 'Cicero-Lake': 700, 'Grand/Milwaukee': 700, 'Garfield-South Elevated': 700, 'Foster': 700, 'Diversey': 700, 'Wilson': 700, \"Irving Park-O'Hare\": 700, 'Jackson/State': 700, 'California/Milwaukee': 700, '54th/Cermak': 700, 'Damen/Milwaukee': 700, 'Kostner': 700, 'Ridgeland': 700, 'Clark/Division': 700, 'Madison/Wabash': 700, 'North/Clybourn': 700, 'Armitage': 700, 'Western/Milwaukee': 700, 'Adams/Wabash': 700, 'Dempster': 700, 'Laramie': 700, 'Chicago/Franklin': 700, 'East 63rd-Cottage Grove': 700, 'Washington/Wells': 700, 'Western-Cermak': 700, \"Harlem-O'Hare\": 700, 'Granville': 700, 'Lawrence': 700, 'Central Park': 700, 'Monroe/Dearborn': 700, 'Sedgwick': 700, 'Medical Center': 700, 'Rosemont': 700, '18th': 700, 'South Boulevard': 700, 'Library': 700, 'Francisco': 700, 'Thorndale': 700, \"O'Hare Airport\": 700, 'Howard': 700, '63rd-Dan Ryan': 700, 'Pulaski-Forest Park': 700, 'Midway Airport': 700, 'Halsted/63rd': 700, 'Pulaski-Orange': 700, 'Cicero-Forest Park': 700, 'Harlem-Forest Park': 700, '69th': 700, 'Cermak-Chinatown': 700, 'Rockwell': 700, 'Logan Square': 700, 'Polk': 700, 'Kedzie-Cermak': 700, 'Linden': 700, 'Ashland-Orange': 700, 'Kedzie-Lake': 700, '47th-South Elevated': 700, 'Monroe/State': 700, '35-Bronzeville-IIT': 700, 'Halsted-Orange': 700, 'King Drive': 700, 'Kedzie-Midway': 700, 'Clinton-Lake': 700, 'Garfield-Dan Ryan': 700, 'Kedzie-Brown': 700, 'Jarvis': 700, 'Argyle': 700, 'Wellington': 700, 'Fullerton': 700, '47th-Dan Ryan': 700, \"Addison-O'Hare\": 700, 'Central-Evanston': 700, 'Austin-Lake': 700, '43rd': 700, 'Jefferson Park': 700, 'Kimball': 700, 'Loyola': 700, 'Paulina': 700, 'Belmont-North Main': 700, \"Montrose-O'Hare\": 700, 'LaSalle': 700, 'Oak Park-Lake': 700, 'California-Lake': 700, 'Bryn Mawr': 700, 'Roosevelt': 700, 'Chicago/Milwaukee': 700, 'Addison-North Main': 700, '87th': 700, 'Addison-Brown': 700, 'Chicago/State': 700, 'Irving Park-Brown': 700, 'Western-Brown': 700, 'Harrison': 700, 'Montrose-Brown': 700, 'Morgan-Lake': 700, 'Lake/State': 700, 'Conservatory': 700, 'Oakton-Skokie': 700, 'Cermak-McCormick Place': 700})\n"
     ]
    }
   ],
   "source": [
    "# Create a Counter of the stations list: station_count\n",
    "station_count = Counter(station)\n",
    "print(station_count)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('Austin-Forest Park', 700), ('Harlem-Lake', 700), ('Pulaski-Lake', 700), ('Quincy/Wells', 700), ('Davis', 700)]\n"
     ]
    }
   ],
   "source": [
    "# Find the 5 most common elements using most_common()\n",
    "print(station_count.most_common(5))"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating dictionaries of an unknown structure"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['station_id', 'stationname', 'date', 'daytype', 'rides'], dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection.columns\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([['01/01/2015', 'Austin-Forest Park', 587],\n",
       "       ['01/02/2015', 'Austin-Forest Park', 1386],\n",
       "       ['01/03/2015', 'Austin-Forest Park', 785],\n",
       "       ...,\n",
       "       ['11/28/2016', 'Cermak-McCormick Place', 1406],\n",
       "       ['11/29/2016', 'Cermak-McCormick Place', 1545],\n",
       "       ['11/30/2016', 'Cermak-McCormick Place', 1499]], dtype=object)"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "entries = collection[['date','stationname','rides']].values\n",
    "entries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('Austin-Forest Park', 2128), ('Harlem-Lake', 3769), ('Pulaski-Lake', 1502), ('Quincy/Wells', 8139), ('Davis', 3656), (\"Belmont-O'Hare\", 5294), ('Jackson/Dearborn', 8369), ('Sheridan', 5823), ('Damen-Brown', 3048), ('Morse', 4826), ('35th/Archer', 3450), ('51st', 1033), ('Dempster-Skokie', 1697), ('Pulaski-Cermak', 1259), ('LaSalle/Van Buren', 3104), ('Ashland-Lake', 2486), ('Oak Park-Forest Park', 1882), ('Sox-35th-Dan Ryan', 4967), ('Randolph/Wabash', 9659), ('Damen-Cermak', 1572), ('Western-Forest Park', 1819), ('Cumberland', 4589), ('79th', 7476), ('Kedzie-Homan-Forest Park', 2256), ('State/Lake', 10594), ('Main', 1129), ('Central-Lake', 2145), ('Ashland/63rd', 1302), ('Indiana', 919), ('Western-Orange', 3958), ('Division/Milwaukee', 6580), ('Grand/State', 10949), ('Berwyn', 3539), ('UIC-Halsted', 7523), ('Southport', 3467), ('Washington/Dearborn', 12365), ('Clark/Lake', 21640), ('Forest Park', 3636), ('Noyes', 941), ('Cicero-Cermak', 1271), ('Clinton-Forest Park', 4016), ('California-Cermak', 1627), ('95th/Dan Ryan', 11509), ('Merchandise Mart', 8345), ('Racine', 2598), ('Cicero-Lake', 1485), ('Grand/Milwaukee', 2851), ('Garfield-South Elevated', 1413), ('Foster', 963), ('Diversey', 5771), ('Wilson', 6470), (\"Irving Park-O'Hare\", 4808), ('Jackson/State', 12445), ('California/Milwaukee', 5413), ('54th/Cermak', 2170), ('Damen/Milwaukee', 7022), ('Kostner', 556), ('Ridgeland', 1353), ('Clark/Division', 8216), ('Madison/Wabash', 0), ('North/Clybourn', 6360), ('Armitage', 4575), ('Western/Milwaukee', 5511), ('Adams/Wabash', 9666), ('Dempster', 788), ('Laramie', 1328), ('Chicago/Franklin', 6868), ('East 63rd-Cottage Grove', 1135), ('Washington/Wells', 8267), ('Western-Cermak', 1182), (\"Harlem-O'Hare\", 3202), ('Granville', 3762), ('Lawrence', 3355), ('Central Park', 1342), ('Monroe/Dearborn', 7972), ('Sedgwick', 4004), ('Medical Center', 3581), ('Rosemont', 6101), ('18th', 2028), ('South Boulevard', 813), ('Library', 4127), ('Francisco', 1617), ('Thorndale', 3355), (\"O'Hare Airport\", 9742), ('Howard', 5935), ('63rd-Dan Ryan', 3500), ('Pulaski-Forest Park', 2110), ('Midway Airport', 8698), ('Halsted/63rd', 839), ('Pulaski-Orange', 5663), ('Cicero-Forest Park', 1475), ('Harlem-Forest Park', 1185), ('69th', 5790), ('Cermak-Chinatown', 4312), ('Rockwell', 1996), ('Logan Square', 7536), ('Polk', 3750), ('Kedzie-Cermak', 1181), ('Linden', 817), ('Ashland-Orange', 1637), ('Kedzie-Lake', 1753), ('47th-South Elevated', 1347), ('Monroe/State', 11264), ('35-Bronzeville-IIT', 1901), ('Halsted-Orange', 3162), ('King Drive', 651), ('Kedzie-Midway', 3552), ('Clinton-Lake', 4278), ('Garfield-Dan Ryan', 3676), ('Kedzie-Brown', 2039), ('Jarvis', 1817), ('Argyle', 3152), ('Wellington', 3242), ('Fullerton', 15150), ('47th-Dan Ryan', 3331), (\"Addison-O'Hare\", 3563), ('Central-Evanston', 802), ('Austin-Lake', 1994), ('43rd', 1090), ('Jefferson Park', 7112), ('Kimball', 4236), ('Loyola', 4712), ('Paulina', 2895), ('Belmont-North Main', 12936), (\"Montrose-O'Hare\", 2529), ('LaSalle', 3556), ('Oak Park-Lake', 1561), ('California-Lake', 1125), ('Bryn Mawr', 4888), ('Roosevelt', 11055), ('Chicago/Milwaukee', 4605), ('Addison-North Main', 6719), ('87th', 4473), ('Addison-Brown', 2754), ('Chicago/State', 13946), ('Irving Park-Brown', 3268), ('Western-Brown', 4273), ('Harrison', 4750), ('Montrose-Brown', 2875), ('Morgan-Lake', 2700), ('Lake/State', 21708), ('Conservatory', 999), ('Oakton-Skokie', 839), ('Cermak-McCormick Place', 1208)]\n"
     ]
    }
   ],
   "source": [
    "# Create an empty dictionary: ridership\n",
    "ridership = {}\n",
    "\n",
    "# Iterate over the entries\n",
    "for date, stop, riders in entries:\n",
    "    # Check to see if date is already in the dictionary\n",
    "    if date not in ridership:\n",
    "        # Create an empty list for any missing date\n",
    "        ridership[date] = []\n",
    "    # Append the stop and riders as a tuple to the date keys list\n",
    "    ridership[date].append((stop, riders))\n",
    "    \n",
    "# Print the ridership for '03/09/2016'\n",
    "print(ridership['03/09/2016'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Safely appending to a key's value list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('Austin-Forest Park', [587, 1386, 785, 625, 1752, 1777, 1269, 1435, 1631, 771, 588, 2065, 2108, 2012, 2069, 2003, 953, 706, 1216, 2115, 2132, 2185, 2072, 854, 585, 2095, 2251, 2133, 2083, 2074, 953, 596, 1583, 2263, 2179, 2105, 2076, 1049, 612, 2095, 2191, 2117, 1931, 1943, 800, 584, 1434, 2078, 1869, 1455, 1830, 841, 621, 1884, 2100, 2046, 2066, 2016, 875, 615, 1975, 2391, 2058, 2035, 2008, 989, 635, 2105, 2148, 2152, 2155, 2182, 1340, 718, 2191, 2220, 2154, 2248, 2183, 1073, 664, 1924, 2060, 2049, 2138, 1930, 972, 693, 2059, 2060, 2120, 2062, 1751, 928, 664, 2047, 2032, 2030, 1899, 2096, 1012, 688, 2090, 2160, 2182, 2184, 2235, 1060, 732, 2090, 2161, 2115, 2203, 2180, 885, 738, 2152, 2175, 2230, 2218, 2320, 1207, 773, 2171, 2090, 2225, 2333, 2098, 1042, 678, 2048, 2097, 2118, 2198, 2273, 1095, 779, 2103, 2119, 2090, 2206, 2081, 1095, 767, 795, 2025, 2171, 2271, 2175, 910, 668, 2148, 2110, 2198, 2152, 2138, 1129, 773, 2041, 2156, 2172, 2093, 2010, 1225, 843, 2006, 2126, 2062, 2341, 2022, 1134, 832, 1938, 2142, 2117, 2076, 1932, 1155, 1172, 2022, 2097, 2152, 2093, 1445, 1205, 884, 1946, 2044, 2146, 2247, 2226, 1162, 1039, 1983, 2094, 2175, 2037, 2106, 1086, 877, 2031, 2141, 2125, 2190, 2192, 1207, 757, 2038, 2164, 2177, 2066, 2181, 1247, 974, 1997, 2118, 2102, 2119, 2072, 1082, 752, 1926, 2152, 2075, 2086, 2086, 1129, 850, 2026, 2021, 2055, 2120, 2099, 1162, 813, 2195, 2333, 2267, 2253, 2148, 976, 836, 2221, 2401, 2177, 2356, 2160, 1043, 897, 787, 2197, 2366, 2335, 2215, 1055, 787, 2296, 2391, 2359, 2367, 2187, 1103, 837, 2286, 2424, 2321, 2333, 2231, 1164, 773, 2393, 2391, 2435, 2489, 2305, 1031, 757, 2366, 2457, 2435, 2400, 2458, 1083, 890, 2038, 2438, 2386, 2467, 2245, 1078, 752, 2237, 2437, 2461, 2345, 2336, 1035, 735, 2299, 2351, 2349, 2344, 2264, 937, 788, 2284, 2256, 2426, 2383, 2245, 1086, 799, 2227, 2399, 2038, 2363, 2156, 1005, 709, 2229, 2233, 2319, 2207, 2103, 947, 631, 2142, 2229, 1887, 642, 971, 852, 666, 2098, 2192, 2237, 2200, 2168, 1059, 820, 1992, 2130, 2172, 2192, 2213, 1261, 715, 1904, 2049, 2056, 2082, 1944, 834, 715, 1664, 1820, 1585, 1022, 523, 774, 650, 1300, 1512, 1534, 1418, 586, 799, 599, 1835, 1891, 1974, 1983, 1938, 823, 502, 1865, 1939, 1907, 2095, 1979, 855, 493, 883, 1968, 2044, 2078, 2021, 804, 609, 2053, 2065, 2145, 2118, 1993, 879, 664, 2128, 2013, 2158, 2167, 1970, 950, 643, 1988, 2023, 2038, 2041, 1766, 782, 601, 1384, 1995, 2080, 2098, 2172, 1051, 671, 1995, 2111, 2084, 2107, 2002, 940, 749, 1941, 2056, 2061, 2048, 1950, 895, 649, 2004, 2148, 2128, 2079, 2097, 1129, 634, 2056, 2001, 2104, 2193, 2104, 929, 707, 1869, 2000, 1927, 1826, 1586, 881, 590, 1899, 2037, 2071, 2061, 1992, 1014, 884, 2005, 2126, 2055, 2114, 1990, 927, 669, 2072, 2131, 2235, 2184, 2126, 1193, 918, 2063, 2088, 2105, 2126, 1978, 1054, 861, 2066, 2152, 2056, 2154, 2173, 956, 748, 2017, 2129, 2066, 2276, 2151, 1142, 797, 1897, 1912, 2054, 2000, 1993, 1035, 847, 2020, 2099, 2113, 2110, 2048, 1234, 881, 2038, 2122, 2078, 2172, 1977, 1069, 895, 878, 2030, 2136, 2211, 2222, 1041, 925, 2036, 2189, 2190, 2065, 2239, 1130, 837, 2063, 2153, 2119, 2184, 2050, 1097, 774, 2043, 2162, 1946, 2074, 2127, 1101, 903, 1955, 2153, 2116, 2190, 2005, 1013, 810, 894, 1910, 2038, 2171, 2047, 1180, 887, 2009, 2084, 2090, 2101, 2137, 1101, 835, 2015, 2256, 2152, 2102, 2061, 1054, 775, 1913, 2104, 2160, 2159, 2223, 1080, 847, 1969, 2070, 2084, 2148, 2076, 1093, 803, 1919, 2108, 2107, 2094, 1836, 1099, 846, 1916, 2134, 2107, 2002, 2091, 1055, 909, 2067, 2243, 2102, 2081, 2128, 1000, 743, 2217, 2225, 2261, 2322, 2245, 1079, 872, 833, 2313, 2307, 2318, 2267, 1036, 778, 2294, 2356, 2387, 2411, 2279, 1077, 774, 2299, 2420, 2266, 2359, 2302, 1086, 815, 2278, 2398, 2209, 2218, 2186, 943, 715, 2222, 2415, 2402, 2219, 2310, 1068, 930, 1860, 2309, 2346, 2295, 2321, 1101, 770, 2285, 2353, 2389, 2238, 2143, 1101, 704, 2215, 2267, 2227, 2315, 2218, 1033, 733, 2136, 2326, 2338, 2286, 3226, 1040, 729, 2200, 2231, 2311, 2230, 1896, 991, 705, 2257, 2330, 2353, 2324, 2152, 1031, 640, 2179, 2195, 1763, 564, 1002, 847, 630, 2015, 2224, 2197]), ('Harlem-Lake', [1106, 3113, 1818, 1339, 3287, 3446, 2580, 2998, 3252, 1849, 1403, 3648, 3672, 3724, 3797, 3843, 2392, 1514, 2737, 3800, 3940, 3912, 3833, 2261, 1402, 3673, 3885, 3944, 3872, 4010, 2311, 1144, 2808, 4161, 4152, 3963, 3979, 2406, 1441, 3758, 4040, 3938, 3696, 3905, 2212, 1346, 2998, 3784, 3591, 3053, 3621, 2215, 1451, 3467, 3714, 3860, 3918, 3806, 2117, 1363, 3735, 3112, 3777, 4056, 3842, 2461, 1578, 3868, 3869, 4016, 4070, 4181, 4069, 1805, 3998, 3908, 4008, 4113, 4111, 2696, 1534, 3575, 3844, 3871, 3980, 3996, 2444, 1570, 3758, 3899, 4173, 3861, 3588, 2409, 1724, 3529, 3791, 3912, 3717, 4185, 2647, 1716, 3856, 4077, 4061, 4072, 4445, 2674, 1739, 3847, 4030, 3979, 4259, 4185, 2293, 1773, 3960, 4053, 4110, 4220, 4441, 3065, 1891, 3963, 3914, 4113, 4325, 3976, 2392, 1615, 3839, 3993, 4232, 4200, 4320, 2698, 1693, 4029, 4038, 4059, 4221, 4101, 2703, 1885, 1515, 3768, 4173, 4296, 4223, 2284, 1641, 4023, 4144, 4254, 4170, 4001, 2768, 1607, 3982, 4110, 4291, 4211, 4208, 2928, 1930, 4040, 4237, 4008, 5152, 4391, 2635, 2061, 3954, 4499, 4306, 4187, 4087, 2940, 2487, 3793, 4156, 4136, 4165, 3276, 2737, 2030, 3912, 4022, 4297, 4549, 4645, 3066, 2383, 4024, 4080, 4344, 4216, 4473, 2956, 2346, 4012, 4330, 4280, 4254, 4464, 2708, 1900, 4135, 4155, 4344, 4477, 5005, 3317, 2401, 4093, 4138, 4366, 4292, 4340, 2798, 1776, 3819, 4130, 4269, 4396, 4314, 3245, 2376, 3950, 3934, 4226, 4243, 4441, 2916, 1980, 4080, 4123, 4315, 4254, 4331, 2404, 1895, 4098, 4225, 4243, 4430, 4370, 2936, 2443, 1689, 3838, 4225, 4189, 4469, 2750, 2193, 4124, 4265, 4466, 4351, 4246, 3025, 2012, 4196, 4224, 4253, 4281, 4414, 2857, 1911, 4191, 4044, 4359, 4291, 4433, 2489, 1764, 4102, 4281, 4415, 4269, 4391, 2708, 2282, 3865, 4331, 4442, 4390, 4591, 2640, 1755, 4139, 4293, 4485, 4392, 4377, 2445, 1732, 4069, 4142, 4237, 4299, 4414, 2120, 1875, 4113, 4318, 4415, 4436, 4411, 2663, 1868, 4118, 4267, 3953, 3998, 4229, 2499, 1765, 4015, 4050, 4185, 4238, 4318, 2420, 1702, 3901, 4114, 3604, 1184, 2515, 2613, 1607, 3871, 4140, 4207, 4175, 4404, 2680, 1741, 3982, 3994, 4103, 4209, 4239, 2612, 1804, 3812, 4002, 3961, 4107, 3963, 2400, 1820, 3546, 3778, 3260, 2282, 940, 1890, 1546, 2805, 3177, 3332, 3339, 1255, 2094, 1517, 3590, 3747, 3771, 3802, 3771, 2036, 1247, 3415, 3509, 3695, 3866, 3835, 2123, 1257, 2163, 3569, 3848, 3886, 3880, 2201, 1522, 3700, 3762, 3889, 3938, 3914, 2382, 1475, 3810, 3645, 3912, 3908, 3823, 2233, 1572, 3772, 4222, 3794, 3803, 3674, 2054, 1651, 2995, 3711, 3853, 3967, 2854, 2316, 1576, 3726, 3905, 3619, 3763, 3929, 2526, 1780, 3691, 3569, 3760, 3792, 3834, 2300, 1681, 3598, 3823, 3769, 3844, 3943, 3200, 1464, 3774, 3701, 3883, 3953, 3968, 2487, 1783, 3752, 3839, 3724, 3469, 3496, 2183, 1397, 3479, 3748, 3701, 3644, 3583, 173, 84, 3532, 3690, 3634, 3779, 3701, 2211, 1482, 3772, 3830, 3970, 4086, 3951, 113, 80, 3810, 3727, 3815, 3769, 3651, 78, 82, 3715, 3783, 3792, 3940, 3870, 66, 92, 3634, 3832, 3729, 3985, 3851, 75, 89, 3511, 3516, 3981, 3776, 3637, 83, 81, 3527, 3640, 3847, 3944, 3888, 97, 89, 3833, 3874, 3758, 3870, 3775, 2546, 1948, 1749, 3546, 3733, 4079, 4167, 2079, 1890, 3736, 4005, 3967, 3735, 4115, 2535, 1949, 3728, 3801, 3913, 3967, 4098, 2639, 1788, 3656, 4038, 3749, 3994, 4168, 2638, 1873, 3735, 3922, 3939, 3912, 3892, 2404, 1948, 1814, 3540, 3812, 3951, 4140, 2691, 1964, 3733, 3866, 3821, 4059, 4268, 2828, 1984, 3902, 3957, 4010, 3851, 3984, 2120, 1561, 3879, 3894, 4106, 4388, 4366, 2883, 2305, 3870, 3867, 4002, 3930, 3819, 2377, 1805, 3686, 3935, 3912, 3861, 3564, 2440, 1788, 3591, 3995, 4061, 3973, 3819, 2399, 2106, 3986, 4023, 3785, 3952, 3960, 2331, 1835, 3824, 3900, 4023, 3938, 4094, 2674, 2182, 1855, 3700, 3848, 4036, 4056, 2221, 1774, 3844, 4013, 4268, 4298, 4194, 2826, 2011, 3889, 4045, 3896, 4062, 4064, 2595, 1868, 3822, 4057, 3969, 3871, 3955, 2106, 1740, 3939, 3937, 3986, 3940, 4142, 2434, 1968, 3539, 3972, 3861, 4148, 4044, 2480, 1884, 3863, 4135, 4088, 4024, 4098, 2593, 1659, 3951, 3970, 3901, 4046, 4371, 2754, 1796, 3806, 3987, 4227, 4050, 6446, 2721, 1837, 3918, 3984, 4129, 4109, 3778, 2344, 1621, 3777, 3946, 4061, 4125, 3989, 2508, 1475, 3664, 3769, 3291, 1179, 2594, 2467, 1627, 3463, 3887, 3806]), ('Pulaski-Lake', [811, 1529, 1096, 801, 1490, 1566, 1085, 1205, 1506, 1031, 830, 1726, 1694, 1703, 1770, 1839, 1171, 858, 1276, 1884, 1806, 1786, 1828, 1335, 814, 1705, 1730, 1763, 1710, 1909, 1187, 618, 1170, 1780, 1801, 1694, 1826, 1287, 858, 1637, 1782, 1837, 1605, 1800, 1077, 709, 1228, 1704, 1503, 1128, 1589, 1122, 854, 1518, 1620, 1679, 1580, 1775, 1112, 810, 1658, 1400, 1675, 1618, 1617, 1184, 889, 1853, 1886, 1857, 1813, 1965, 1328, 936, 1794, 1800, 1783, 1774, 1830, 1245, 855, 1487, 1777, 1711, 1725, 1727, 1139, 776, 1642, 1700, 1950, 1702, 1543, 1295, 987, 1602, 1607, 1633, 1493, 1759, 1224, 944, 1773, 1880, 1820, 1816, 1946, 1262, 849, 1694, 1754, 1717, 1732, 1859, 1115, 819, 1758, 1889, 1888, 1821, 2052, 1435, 926, 1776, 1798, 1811, 1935, 1847, 1177, 955, 1747, 1795, 1861, 1791, 1880, 1264, 975, 1868, 1820, 1799, 1784, 1900, 1304, 866, 857, 1685, 1959, 1904, 1926, 1133, 938, 1917, 1893, 1940, 1987, 1886, 1383, 930, 1826, 1952, 1971, 1868, 1811, 1359, 966, 1645, 1774, 1820, 1861, 1939, 1350, 1054, 1624, 1807, 1721, 1722, 1723, 1310, 1138, 1703, 1742, 1863, 1811, 1497, 1317, 1044, 1740, 1730, 1793, 1858, 1911, 1386, 1088, 1620, 1758, 1835, 1735, 1784, 1301, 1040, 1766, 1904, 1802, 1767, 1857, 1302, 947, 1727, 1789, 1705, 1713, 1933, 1427, 1094, 1823, 1869, 1847, 1816, 1836, 1411, 989, 1644, 1812, 1765, 1685, 1771, 1308, 1037, 1689, 1683, 1664, 1744, 1782, 1276, 934, 1695, 1731, 1819, 1702, 1757, 1225, 998, 1710, 1869, 1706, 1750, 1780, 1306, 1039, 1056, 1687, 2091, 1823, 1885, 1269, 1036, 1961, 2018, 1979, 1864, 1924, 1333, 1071, 1926, 1923, 1961, 1933, 1971, 1423, 1073, 1857, 1864, 1887, 1977, 1871, 1259, 944, 1882, 1969, 1986, 1901, 1888, 1297, 967, 1460, 1949, 1957, 1846, 1907, 1301, 938, 1839, 1942, 1912, 1901, 1876, 1217, 941, 1811, 1810, 1809, 1785, 2016, 1076, 926, 1823, 2037, 1943, 1906, 1900, 1290, 939, 1851, 1918, 1526, 1734, 1677, 1196, 919, 1806, 1724, 1723, 1763, 1809, 1066, 792, 1641, 1841, 1584, 762, 1082, 1033, 803, 1656, 1899, 1724, 1851, 1910, 1224, 842, 1707, 1782, 1816, 1763, 1774, 1214, 890, 1747, 1733, 1708, 1670, 1664, 1135, 856, 1468, 1490, 1401, 1207, 704, 923, 768, 1092, 1287, 1284, 1339, 741, 969, 721, 1544, 1609, 1577, 1599, 1653, 1018, 670, 1365, 1354, 1360, 1575, 1569, 1068, 616, 828, 1478, 1539, 1495, 1563, 1061, 761, 1545, 1604, 1555, 1533, 1607, 1104, 727, 1595, 1494, 1614, 1584, 1511, 1142, 743, 1476, 1412, 1412, 1538, 1470, 923, 709, 1070, 1580, 1528, 1616, 1158, 980, 729, 1542, 1556, 1357, 1445, 1543, 1224, 807, 1455, 1454, 1429, 1444, 1503, 930, 790, 1566, 1653, 1502, 1544, 1617, 1086, 693, 1536, 1559, 1475, 1607, 1553, 1013, 716, 1472, 1524, 1459, 1398, 1293, 1032, 705, 1513, 1597, 1550, 1629, 1514, 816, 711, 1476, 1535, 1357, 1528, 1383, 1012, 663, 1585, 1643, 1466, 1524, 1594, 1153, 834, 1451, 1321, 1358, 1376, 1307, 949, 733, 1545, 1516, 1426, 1558, 1568, 923, 687, 1529, 1559, 1502, 1638, 1671, 1023, 805, 1394, 1541, 1549, 1591, 1562, 1059, 695, 1481, 1492, 1536, 1536, 1525, 1113, 786, 1565, 1631, 1476, 1527, 1589, 1063, 844, 884, 1515, 1605, 1691, 1701, 1011, 842, 1544, 1482, 1597, 1600, 1725, 1021, 839, 1512, 1562, 1623, 1558, 1606, 1069, 812, 1374, 1473, 1280, 1460, 1485, 1031, 807, 1513, 1447, 1484, 1431, 1546, 1047, 871, 891, 1385, 1389, 1515, 1477, 1076, 841, 1399, 1518, 1421, 1507, 1537, 1094, 745, 1406, 1515, 1470, 1393, 1528, 898, 633, 1465, 1490, 1517, 1454, 1473, 1094, 807, 1571, 1484, 1544, 1418, 1451, 964, 756, 1395, 1450, 1544, 1407, 1360, 1054, 747, 1282, 1367, 1282, 1409, 1436, 913, 741, 1334, 1398, 1304, 1269, 1535, 995, 763, 1349, 1411, 1345, 1522, 1538, 1058, 806, 832, 1487, 1487, 1491, 1581, 1037, 733, 1445, 1558, 1526, 1581, 1584, 1043, 756, 1462, 1519, 1393, 1512, 1520, 982, 769, 1548, 1508, 1516, 1476, 1609, 1006, 737, 1490, 1591, 1583, 1549, 1619, 1075, 840, 1223, 1575, 1441, 1618, 1632, 1070, 832, 1588, 1615, 1546, 1640, 1705, 1075, 864, 1447, 1477, 1470, 1608, 1653, 1083, 763, 1448, 1658, 1519, 1681, 1747, 1127, 819, 1575, 1588, 1579, 1712, 1393, 1094, 808, 1538, 1720, 1719, 1713, 1692, 1070, 803, 1484, 1460, 1374, 723, 1036, 1006, 800, 1449, 1609, 1574]), ('Quincy/Wells', [1117, 4645, 1217, 1009, 8626, 8642, 6678, 7906, 7828, 1236, 910, 8707, 8388, 8368, 8267, 7683, 1597, 1172, 4788, 8219, 8192, 8033, 7680, 1391, 1138, 7906, 8278, 8185, 7916, 7593, 1390, 1234, 6428, 9023, 8698, 8398, 7728, 1606, 1108, 8331, 8276, 8024, 7945, 7532, 1583, 1319, 5349, 8172, 7874, 6750, 7389, 1717, 1257, 8112, 8015, 8357, 8280, 7648, 1604, 939, 8264, 8094, 8176, 7961, 7596, 1642, 1334, 8134, 8201, 8155, 8168, 7652, 2676, 1210, 8137, 8496, 8199, 8026, 7461, 1927, 1392, 8046, 8368, 8174, 7858, 7494, 1852, 1505, 8270, 8123, 8176, 7699, 6109, 1878, 1681, 8037, 7935, 7932, 7770, 7258, 1416, 873, 7911, 8063, 8114, 7892, 7102, 1498, 934, 8040, 7951, 8025, 8108, 7550, 1527, 1497, 8257, 8102, 7954, 7916, 7325, 1391, 1074, 7964, 7925, 7898, 7783, 7645, 1244, 873, 8388, 8221, 8358, 8081, 7206, 1299, 931, 8108, 8201, 8337, 7625, 6704, 2185, 1677, 1852, 8283, 8175, 8035, 7448, 1203, 949, 8229, 8165, 8114, 7997, 7276, 1608, 842, 8413, 8514, 8213, 8080, 7531, 2277, 1516, 9389, 8549, 8364, 9687, 7636, 1791, 1510, 8469, 8490, 8349, 8305, 7905, 2061, 2806, 8371, 8341, 8334, 7266, 2880, 1711, 1936, 8325, 8544, 8419, 8448, 7814, 2069, 1779, 8405, 8403, 8308, 8319, 7611, 1724, 1569, 8502, 8438, 8300, 8279, 7638, 1615, 1282, 8651, 8446, 8336, 8493, 7574, 2204, 1732, 8520, 8369, 8338, 8123, 7210, 1633, 1098, 8388, 8628, 8401, 8152, 7492, 2023, 1773, 8296, 8384, 8278, 8223, 7033, 1519, 1153, 8476, 8274, 8197, 7989, 6936, 1109, 1141, 8081, 8307, 8159, 7979, 6537, 1968, 2083, 1799, 8367, 8276, 8196, 8102, 1561, 1190, 8228, 8415, 8239, 8642, 7832, 1732, 1257, 8599, 8454, 8211, 8193, 7511, 1494, 1124, 8429, 8561, 8331, 8315, 7749, 1596, 1469, 8348, 8792, 8584, 8296, 7832, 2270, 3030, 7851, 8700, 8479, 8598, 8079, 2290, 1709, 8677, 8825, 8665, 8411, 7778, 1805, 1564, 8463, 8818, 8483, 8445, 7901, 1241, 1406, 8644, 8376, 8398, 8271, 7926, 1966, 1652, 8697, 8520, 7342, 8274, 7872, 1799, 1417, 8463, 8606, 8339, 8418, 7770, 1471, 1331, 8424, 8048, 5581, 945, 2414, 1873, 1599, 8422, 8380, 8247, 8205, 7492, 1689, 1146, 8011, 8079, 8080, 7881, 7127, 1357, 1071, 8065, 8078, 7889, 7654, 7121, 1411, 1097, 6831, 6606, 4945, 2206, 700, 1225, 1326, 6007, 6268, 6082, 4744, 1225, 1644, 1072, 8662, 8734, 8423, 8391, 7969, 1337, 1019, 8559, 8543, 8845, 8241, 7562, 1481, 936, 4074, 8520, 8480, 8063, 7794, 1406, 953, 8492, 8431, 8359, 8148, 7607, 1365, 863, 8512, 8642, 8401, 8229, 7468, 1436, 941, 8192, 8280, 8239, 7860, 7341, 1560, 1183, 5188, 8396, 8394, 8153, 7731, 1478, 1241, 8150, 8179, 8110, 7885, 7555, 1417, 1173, 8322, 8255, 8239, 8080, 7562, 1452, 1311, 8343, 8161, 8139, 8160, 7821, 2256, 1070, 8620, 8425, 8430, 8317, 7596, 1849, 1518, 8619, 8286, 8374, 7906, 6251, 1897, 1387, 8705, 8173, 8102, 7672, 7495, 1400, 1434, 8674, 8550, 8454, 8295, 7616, 1959, 1207, 8414, 8406, 8119, 8266, 7507, 1805, 1561, 7999, 8185, 7997, 7748, 7426, 1775, 1370, 8279, 8528, 8907, 8264, 7701, 1615, 1245, 8630, 8166, 8262, 8229, 7222, 1598, 1459, 8680, 8579, 8515, 8117, 7425, 1723, 1664, 8308, 8383, 8487, 8083, 7386, 1824, 1355, 8340, 8401, 8773, 7757, 6815, 2277, 2138, 1893, 9333, 8580, 8489, 7899, 1565, 1662, 8727, 8552, 8540, 8439, 7711, 2103, 1694, 8741, 9019, 8662, 8274, 7509, 2237, 1858, 9029, 8624, 8590, 8475, 7664, 2211, 2418, 8528, 8670, 8438, 8364, 6210, 1709, 1859, 1641, 8375, 8706, 8816, 7807, 1902, 1531, 8934, 8760, 8864, 8486, 7784, 2249, 1763, 8882, 8825, 8890, 8436, 7604, 2041, 1453, 9034, 8823, 9420, 9348, 7997, 2163, 1840, 8921, 9079, 8768, 8481, 7347, 2114, 1711, 8713, 8592, 8811, 8685, 7758, 2178, 1646, 8819, 8879, 8799, 8172, 7385, 1675, 1615, 8635, 8396, 8309, 8054, 7444, 1642, 1302, 8589, 8427, 8284, 8188, 6285, 1961, 1848, 1787, 8405, 8473, 8430, 7866, 1628, 1380, 8448, 8446, 8161, 8427, 7730, 1941, 1621, 8773, 8625, 8495, 8275, 7493, 2162, 1636, 8459, 8431, 8584, 8252, 7484, 1508, 1413, 8330, 8385, 8366, 8608, 8071, 2304, 2571, 7506, 8523, 8627, 8402, 7678, 1886, 1565, 8458, 8314, 8242, 8141, 7706, 1765, 1356, 8162, 8565, 8690, 8074, 8700, 2087, 1573, 8245, 8388, 9462, 8033, 9625, 1825, 1478, 8402, 8419, 8231, 8206, 6636, 1792, 1318, 8252, 8334, 8220, 7990, 7441, 1388, 1137, 8334, 7820, 5272, 915, 2167, 1681, 1372, 8399, 8251, 8158]), ('Davis', [1400, 2997, 2079, 1667, 3524, 3551, 2768, 3202, 3548, 2334, 1708, 3724, 3781, 3761, 3870, 4150, 3024, 2099, 3101, 3704, 3790, 3730, 4107, 2768, 1769, 3535, 3761, 3685, 3769, 4099, 2766, 1591, 3468, 4190, 4055, 4079, 4381, 2887, 1899, 3746, 3914, 3789, 3622, 4050, 2634, 1797, 3215, 3760, 3451, 3010, 3830, 2816, 1718, 3444, 3579, 3641, 3767, 3877, 2620, 1777, 3689, 3791, 3727, 3647, 4059, 2759, 1806, 3793, 3810, 3896, 4030, 4141, 3305, 1971, 3760, 3771, 3716, 3897, 3975, 2727, 1814, 3455, 3426, 3537, 3701, 3509, 2464, 1758, 3767, 3769, 3784, 3969, 3766, 2839, 1869, 3593, 3681, 3855, 3675, 4100, 2863, 1991, 3691, 4044, 3828, 4051, 4168, 3117, 2045, 3650, 3801, 3737, 3954, 4069, 2613, 2073, 3793, 4115, 3819, 4073, 4234, 3284, 2232, 3716, 3820, 3978, 3973, 3917, 2552, 1819, 3646, 4071, 3870, 3950, 4253, 2878, 2079, 3823, 4027, 3770, 3996, 4029, 2908, 2080, 1938, 3912, 4052, 4191, 4343, 2763, 2342, 3880, 4094, 4088, 4170, 4048, 2756, 1748, 3732, 3911, 3979, 4180, 4073, 3239, 2295, 4001, 4511, 4197, 4285, 4329, 3072, 2107, 3944, 4347, 4148, 4297, 3876, 3185, 2753, 3718, 3954, 3903, 4025, 3365, 2961, 2313, 3925, 4368, 4231, 4138, 4510, 3355, 2297, 3853, 4028, 4133, 3956, 4063, 2799, 2223, 3829, 4037, 4094, 4172, 4349, 3011, 2340, 3972, 4149, 4210, 4142, 4193, 3039, 2152, 3817, 3996, 3980, 4117, 4172, 2949, 2116, 3613, 4045, 3983, 4193, 3827, 2872, 2078, 3627, 4025, 4050, 4044, 4086, 2790, 1988, 3768, 3829, 3851, 4048, 3833, 2432, 1865, 3745, 3803, 3844, 3839, 3821, 2911, 2235, 1730, 3684, 3718, 3960, 4196, 2843, 1979, 3696, 4208, 4019, 3983, 4330, 3145, 2568, 4110, 4034, 4034, 4095, 4474, 3409, 2063, 3978, 3943, 3947, 4119, 4298, 2931, 2043, 3950, 3969, 4016, 4050, 4592, 3043, 2363, 3844, 4252, 3915, 4179, 4510, 3922, 2221, 3885, 4370, 4246, 4164, 4255, 3087, 2067, 3784, 3930, 3888, 4125, 4046, 2243, 1927, 3721, 3933, 3889, 4052, 4321, 3328, 2022, 3768, 3989, 3712, 3868, 4134, 2927, 1908, 3736, 3697, 3791, 3954, 4167, 2482, 1892, 3789, 3825, 3283, 1130, 2095, 2231, 1665, 3620, 3877, 3746, 3900, 4127, 2687, 1763, 3686, 3816, 3825, 4091, 4093, 2485, 1612, 3506, 3671, 3650, 3654, 3836, 2391, 1631, 3238, 3285, 2680, 1701, 801, 1554, 1396, 2405, 3007, 2913, 2661, 1415, 2110, 1562, 3505, 3675, 3686, 3710, 3916, 2515, 1546, 3486, 3387, 3479, 3824, 3956, 2532, 1326, 2319, 3531, 3764, 3683, 3947, 2609, 1684, 3592, 3641, 3682, 3740, 3863, 2518, 1745, 3684, 3515, 3695, 3801, 3800, 2679, 1682, 3488, 3660, 3549, 3860, 3851, 2494, 1990, 3064, 3823, 3692, 3798, 3834, 2772, 1774, 3633, 3697, 3497, 3706, 3963, 2784, 1785, 3470, 3582, 3706, 3681, 3924, 2612, 1787, 3637, 3730, 3656, 3785, 3969, 2857, 1579, 3597, 3703, 3699, 3809, 3831, 2351, 1735, 3486, 3572, 3340, 3284, 3373, 2356, 1482, 3519, 3885, 3676, 3739, 4011, 2710, 1984, 3604, 3644, 3531, 3721, 3920, 2654, 1650, 3738, 3732, 3837, 4044, 3978, 3057, 2028, 3715, 3797, 3746, 3738, 3786, 2605, 1785, 3506, 3847, 3614, 3823, 4002, 2413, 1835, 3650, 3706, 3661, 4134, 4228, 2893, 1983, 3694, 3878, 3829, 3816, 4132, 2670, 2003, 3567, 3737, 3678, 3898, 3882, 2690, 2049, 3633, 3843, 3535, 3816, 3947, 2802, 2316, 1927, 3809, 3866, 4197, 4228, 2718, 2084, 3735, 3924, 3800, 3871, 4033, 2619, 2002, 3772, 3975, 3951, 4000, 4360, 2974, 2019, 3807, 4071, 3808, 3848, 3975, 2863, 2170, 3730, 3847, 3691, 3953, 3682, 2527, 1989, 2234, 3833, 4001, 3947, 4024, 2741, 1907, 3589, 3899, 3729, 3818, 4142, 3193, 2172, 3819, 4159, 4003, 3797, 3813, 2557, 1968, 3707, 3991, 4131, 4138, 4253, 3153, 2327, 3756, 3945, 3893, 3942, 3989, 2645, 1902, 3566, 3972, 3917, 3865, 3577, 2705, 1932, 3361, 3983, 3723, 3908, 3647, 2488, 1951, 3631, 3605, 3400, 3601, 3694, 2411, 1799, 3551, 3636, 3684, 3694, 3696, 2806, 2130, 1711, 3607, 3555, 3874, 3712, 2641, 1933, 3672, 3850, 3808, 4173, 4070, 2850, 2227, 3872, 3973, 3840, 4028, 4439, 3442, 2023, 3719, 3751, 3653, 3846, 3951, 2693, 1963, 3610, 3993, 3866, 3971, 4519, 3220, 2134, 3557, 3958, 3641, 4029, 4109, 3042, 2187, 3694, 3882, 3884, 3883, 4145, 3842, 2055, 3560, 3780, 3599, 3847, 4583, 3413, 2218, 3587, 3979, 4201, 4067, 5288, 3780, 2162, 3811, 3877, 3866, 4023, 4002, 3003, 1933, 3640, 3961, 3772, 3929, 4074, 2888, 1896, 3668, 3717, 3186, 957, 2274, 2133, 1535, 3405, 3789, 3749])]\n"
     ]
    }
   ],
   "source": [
    "# Import defaultdict\n",
    "from collections import defaultdict\n",
    "# Create a defaultdict with a default type of list: ridership\n",
    "rider = defaultdict(list)\n",
    "# Iterate over the entries\n",
    "for date, stop,riders in entries:\n",
    "    # Use the stop as the key of ridership and append the riders to its value\n",
    "    rider[stop].append(riders)\n",
    "# Print the first 5 items of the ridership dictionary\n",
    "print(list(rider.items())[:5])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Working with OrderedDictionaries\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[('01/01/2015', 233956), ('01/02/2015', 432144), ('01/03/2015', 273207), ('01/04/2015', 217632), ('01/05/2015', 538868), ('01/06/2015', 556918), ('01/07/2015', 416984), ('01/08/2015', 475074), ('01/09/2015', 524144), ('01/10/2015', 282850), ('01/11/2015', 227240), ('01/12/2015', 605068), ('01/13/2015', 609226), ('01/14/2015', 608109), ('01/15/2015', 622792), ('01/16/2015', 612833), ('01/17/2015', 335555), ('01/18/2015', 244490), ('01/19/2015', 411497), ('01/20/2015', 618377), ('01/21/2015', 619945), ('01/22/2015', 623914), ('01/23/2015', 612177), ('01/24/2015', 333440), ('01/25/2015', 226964), ('01/26/2015', 605287), ('01/27/2015', 626168), ('01/28/2015', 625531), ('01/29/2015', 622695), ('01/30/2015', 618395), ('01/31/2015', 337018)]\n"
     ]
    }
   ],
   "source": [
    "entries_2 =collection[['date','rides']].values\n",
    "# Import OrderedDict from collections\n",
    "from collections import  OrderedDict\n",
    "\n",
    "# Create an OrderedDict called: ridership_date\n",
    "ridership_date = OrderedDict()\n",
    "# Iterate over the entries\n",
    "for date, riders in entries_2:\n",
    "    # If a key does not exist in ridership_date, set it to 0\n",
    "    if not date in ridership_date:\n",
    "        ridership_date[date] = 0\n",
    "    # Add riders to the date key in ridership_date\n",
    "    ridership_date[date] += riders\n",
    "# Print the first 31 records\n",
    "print(list(ridership_date.items())[:31])\n",
    "    "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating namedtuples for storing data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[DateDetails(date='01/01/2015', stop='Austin-Forest Park', riders=587), DateDetails(date='01/02/2015', stop='Austin-Forest Park', riders=1386), DateDetails(date='01/03/2015', stop='Austin-Forest Park', riders=785), DateDetails(date='01/04/2015', stop='Austin-Forest Park', riders=625), DateDetails(date='01/05/2015', stop='Austin-Forest Park', riders=1752)]\n"
     ]
    }
   ],
   "source": [
    "# Import namedtuple from collections\n",
    "from collections import namedtuple\n",
    "\n",
    "# Create the namedtuple: DateDetails\n",
    "DateDetails = namedtuple('DateDetails', ['date', 'stop', 'riders'])\n",
    "\n",
    "# Create the empty list: labeled_entries\n",
    "labeled_entries = []\n",
    "\n",
    "# Iterate over the entries\n",
    "for date, stop, riders in entries:\n",
    "    # Append a new DateDetails namedtuple instance for each entry to labeled_entries\n",
    "    labeled_entries.append(DateDetails(date,stop, riders))\n",
    "    \n",
    "# Print the first 5 items in labeled_entries\n",
    "print(labeled_entries[:5])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Austin-Forest Park\n",
      "01/01/2015\n",
      "587\n",
      "Austin-Forest Park\n",
      "01/02/2015\n",
      "1386\n",
      "Austin-Forest Park\n",
      "01/03/2015\n",
      "785\n",
      "Austin-Forest Park\n",
      "01/04/2015\n",
      "625\n",
      "Austin-Forest Park\n",
      "01/05/2015\n",
      "1752\n",
      "Austin-Forest Park\n",
      "01/06/2015\n",
      "1777\n",
      "Austin-Forest Park\n",
      "01/07/2015\n",
      "1269\n",
      "Austin-Forest Park\n",
      "01/08/2015\n",
      "1435\n",
      "Austin-Forest Park\n",
      "01/09/2015\n",
      "1631\n",
      "Austin-Forest Park\n",
      "01/10/2015\n",
      "771\n",
      "Austin-Forest Park\n",
      "01/11/2015\n",
      "588\n",
      "Austin-Forest Park\n",
      "01/12/2015\n",
      "2065\n",
      "Austin-Forest Park\n",
      "01/13/2015\n",
      "2108\n",
      "Austin-Forest Park\n",
      "01/14/2015\n",
      "2012\n",
      "Austin-Forest Park\n",
      "01/15/2015\n",
      "2069\n",
      "Austin-Forest Park\n",
      "01/16/2015\n",
      "2003\n",
      "Austin-Forest Park\n",
      "01/17/2015\n",
      "953\n",
      "Austin-Forest Park\n",
      "01/18/2015\n",
      "706\n",
      "Austin-Forest Park\n",
      "01/19/2015\n",
      "1216\n",
      "Austin-Forest Park\n",
      "01/20/2015\n",
      "2115\n"
     ]
    }
   ],
   "source": [
    "# Iterate over the first twenty items in labeled_entries\n",
    "for item in labeled_entries[: 20]:\n",
    "    # Print each item's stop\n",
    "    print(item.stop)\n",
    "\n",
    "    # Print each item's date\n",
    "    print(item.date)\n",
    "\n",
    "    # Print each item's riders\n",
    "    print(item.riders)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Course 4:Handling Dates and Times\n",
    "## Strings to DateTimes\n",
    "* strftime(format) method, to create a string representing the time\n",
    "* datetime.strptime() class method creates a datetime object from a string representing a date and time and a corresponding format string."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['01/01/2015' '01/02/2015' '01/03/2015' ... '11/28/2016' '11/29/2016'\n",
      " '11/30/2016']\n"
     ]
    }
   ],
   "source": [
    "# Let's create a date list from collection data frame\n",
    "dates_list = collection['date'].values\n",
    "print(dates_list)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "[datetime.datetime(2015, 1, 1, 0, 0), datetime.datetime(2015, 1, 2, 0, 0), datetime.datetime(2015, 1, 3, 0, 0), datetime.datetime(2015, 1, 4, 0, 0), datetime.datetime(2015, 1, 5, 0, 0), datetime.datetime(2015, 1, 6, 0, 0), datetime.datetime(2015, 1, 7, 0, 0), datetime.datetime(2015, 1, 8, 0, 0), datetime.datetime(2015, 1, 9, 0, 0), datetime.datetime(2015, 1, 10, 0, 0)]\n"
     ]
    }
   ],
   "source": [
    "#import datatime library\n",
    "from datetime import  datetime\n",
    "#Iterate over the dates_list\n",
    "datetime_list = []\n",
    "for date_str in dates_list:\n",
    "    date_dt = datetime.strptime(date_str, '%m/%d/%Y')\n",
    "    #print(date_dt)\n",
    "    datetime_list.append(date_dt)\n",
    "print(datetime_list[:10])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Converting to a String"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "01/01/2015\n",
      "2015-01-01T00:00:00\n",
      "01/02/2015\n",
      "2015-01-02T00:00:00\n",
      "01/03/2015\n",
      "2015-01-03T00:00:00\n",
      "01/04/2015\n",
      "2015-01-04T00:00:00\n",
      "01/05/2015\n",
      "2015-01-05T00:00:00\n",
      "01/06/2015\n",
      "2015-01-06T00:00:00\n",
      "01/07/2015\n",
      "2015-01-07T00:00:00\n",
      "01/08/2015\n",
      "2015-01-08T00:00:00\n",
      "01/09/2015\n",
      "2015-01-09T00:00:00\n",
      "01/10/2015\n",
      "2015-01-10T00:00:00\n"
     ]
    }
   ],
   "source": [
    "for item in datetime_list[:10]:\n",
    "    # Print out the record as a string in the format of 'MM/DD/YYYY'\n",
    "    print(datetime.strftime(item, '%m/%d/%Y'))\n",
    "    \n",
    "    # Print out the record as an ISO standard string\n",
    "    print(datetime.isoformat(item))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}