In [1]:

    

import requests,re,time,numpy as np,pickle,asyncio,concurrent.futures
# Make this notebook wiiiiiiiiide
from IPython.core.display import display, HTML
display(HTML("<style>.container { width:100% !important; }</style>"))


    

In [2]:

    

# Setup relevant variables
ZIP = '60615'
pickupDate = '11/1/2017'
dropoffDate = '11/8/2017'
TIME = '10:00 AM'
RADIUS = '35'


    

In [4]:

    

%run core_functions.ipynb


    

In [5]:

    

results = runparser(threads=4)


    

    




001 OK      | ('1', 'city', 'enterprise', 'E11586', 'Gg Hyde Park', 'ET', '5508 South Lake Park', 'Chicago', 'IL', '60637', '0.95', '41.794955', '-87.587695')
003 NO DATA |004 OK      |  ('3', 'city', 'avis', 'CHIC05', 'Chicago - 18th Street & Wabash Avenue', 'AV', '1830 South Wabash Avenue', 'Chicago', 'IL', '60616', '4.05', '41.856873', '-87.62607')('4', 'city', 'budget', 'CHIC02', 'Chicago', 'BG', '1830 S Wabash Ave', 'Chicago', 'IL', '60616', '4.05', '41.856873', '-87.62607')

005 OK      | ('5', 'city', 'enterprise', 'E115DN', 'Gg South Western', 'ET', '4524 S Western Ave', 'Chicago', 'IL', '60609', '4.19', '41.811259', '-87.68454')
002 OK      | ('2', 'city', 'enterprise', 'E11576', 'Gg South Loop', 'ET', '2640 S Michigan Ave', 'Chicago', 'IL', '60616', '3.17', '41.844252', '-87.623689')
006 OK      | ('6', 'city', 'budget', 'CHIC08', 'Chicago', 'BG', '714 South Wabash Avenue', 'Chicago', 'IL', '60605', '5.11', '41.872643', '-87.62627')
007 OK      | ('7', 'city', 'enterprise', 'E11530', 'Gg Stony Island', 'ET', '9214 S Stony Island Ave', 'Chicago', 'IL', '60617', '5.17', '41.727246', '-87.585492')
009 NO DATA | ('9', 'city', 'avis', 'CHIX01', 'Chicago Union Train Station', 'AV', '225 South Canal Street', 'Chicago', 'IL', '60606', '5.71', '41.878674', '-87.640335')
008 OK      | ('8', 'city', 'enterprise', 'E115DA', 'Gg Gresham', 'ET', '1820 W 87th St', 'Chicago', 'IL', '60620', '5.57', '41.735849', '-87.66861')
010 OK      | ('10', 'city', 'budget', 'CHIX01', 'Chicago Union Train Station', 'BG', '225 S Canal Street', 'Chicago', 'IL', '60606', '5.71', '41.878674', '-87.640335')
011 OK      | ('11', 'city', 'enterprise', 'E115CE', 'Chicago Loop', 'ET', '201 W Madison St Fl 3', 'Chicago', 'IL', '60606', '5.82', '41.881861', '-87.633865')
013 OK      | ('13', 'city', 'enterprise', 'E11555', 'Union Station/pres Tower', 'ET', '555 W. Madison Suite 102', 'Chicago', 'IL', '60661', '5.93', '41.881786', '-87.641611')
012 OK      | ('12', 'city', 'enterprise', 'E115CD', 'Dd West Loop A/b(ex15ca)', 'ET', '318 S. Morgan', 'Chicago', 'IL', '60607', '5.84', '41.877343', '-87.65196')
014 OK      | ('14', 'city', 'enterprise', 'E115KB', 'Millennium Park', 'ET', '20 E Randolph St 3rd Fl', 'Chicago', 'IL', '60601', '5.93', '41.88467', '-87.627454')
015 OK      | ('15', 'city', 'avis', 'CHIC01', 'North Loop-downtown', 'AV', '214 North Clark Street (at Wacker)', 'Chicago', 'IL', '60601', '6.05', '41.8859', '-87.630974')
016 OK      | ('16', 'city', 'budget', 'CHIC09', 'North Loop Budget', 'BG', '214 North Clark Street', 'Chicago', 'IL', '60601', '6.05', '41.8859', '-87.630974')
017 OK      | ('17', 'city', 'alamo', 'CHIC72', 'Chicago N Lasalle', 'AL', '203 N La Salle St', 'Chicago', 'IL', '60601', '6.07', '41.88587', '-87.63229')
018 OK      | ('18', 'city', 'enterprise', 'E115CA', 'Lake And Franklin', 'ET', '303 W. Lake St', 'Chicago', 'IL', '60606', '6.09', '41.885651', '-87.63548')
019 OK      | ('19', 'city', 'enterprise', 'E115C6', 'Gg Archer Heights', 'ET', '4825 South Pulaski', 'Chicago', 'IL', '60632', '6.13', '41.805136', '-87.723332')020 OK      |
 ('20', 'city', 'enterprise', 'E115CU', 'Gg Western And Roosevelt', 'ET', '1224 S Western Ave', 'Chicago', 'IL', '60608', '6.17', '41.865925', '-87.686167')
021 OK      | ('21', 'city', 'enterprise', 'E11557', 'Chicago Magnificent Mile', 'ET', '10 E Grand; Hilton Garage Fl 2', 'Chicago', 'IL', '60611', '6.43', '41.892012', '-87.62754')
024 OK      | ('24', 'airport', 'budget', 'MDWT02', 'Midway Airport', 'BG', '5150 West 55th Street', 'Chicago', 'IL', '60638', '7.54', '41.79356', '-87.750374')
023 NO DATA | ('23', 'airport', 'avis', 'MDWT01', 'Chicago Midway Intl Airport', 'AV', '5150 West 55th Street', 'Chicago', 'IL', '60638', '7.54', '41.79356', '-87.750374')
022 OK      | ('22', 'city', 'enterprise', 'E115C7', 'Gold Coast', 'ET', '850 N State St', 'Chicago', 'IL', '60610', '6.86', '41.898111', '-87.628326')
025 OK      | ('25', 'city', 'enterprise', 'E115CQ', 'Dd Gold Coast Auto Body', 'ET', '930 W Division St', 'Chicago', 'IL', '60622', '7.54', '41.903634', '-87.652298')
026 OK      | ('26', 'airport', 'enterprise', 'MDWT61', 'Midway Intl Arpt', 'ET', '5150 W 55th St', 'Chicago', 'IL', '60638', '7.60', '41.793059', '-87.751574')
027 OK      | ('27', 'airport', 'alamo', 'MDWT71', 'Midway Intl Arpt', 'AL', '5150 W 55th St', 'Chicago', 'IL', '60638', '7.60', '41.793059', '-87.751574')
028 OK      | ('28', 'city', 'enterprise', 'E115C4', 'Dd Old Town', 'ET', '523 West North Ave', 'Chicago', 'IL', '60610', '7.87', '41.910926', '-87.641928')
029 NO DATA | ('29', 'city', 'avis', 'CHIC12', 'Grossinger City Autoplex', 'AV', '1561 North Fremont Street', 'Chicago', 'IL', '60642', '7.94', '41.91009', '-87.65097')
031 OK      | ('31', 'city', 'avis', 'CHIS08', 'Oak Lawn/chicago', 'AV', '8181 South Cicero Avenue', 'Chicago', 'IL', '60652', '8.04', '41.743652', '-87.740295')
032 OK      | ('32', 'city', 'budget', 'CHIS04', 'Oak Lawn', 'BG', '8181 South Cicero Avenue', 'Chicago', 'IL', '60652', '8.04', '41.743652', '-87.740295')
030 OK      | ('30', 'city', 'budget', 'CHIC12', 'Chicago Grossinger Autoplex', 'BG', '1561 North Fremont Street', 'Chicago', 'IL', '60642', '7.94', '41.91009', '-87.65097')
033 OK      | ('33', 'city', 'enterprise', 'E115MT', 'Euro Collission', 'ET', '1630 N Kingsbury St', 'Chicago', 'IL', '60614', '8.08', '41.911263', '-87.654638')
035 NO DATA | ('35', 'city', 'enterprise', 'E115CF', 'Sat Howard Orloff', 'ET', '1924 N. Paulina', 'Chicago', 'IL', '60622', '8.76', '41.917331', '-87.670582')
034 OK      | ('34', 'city', 'enterprise', 'E11503', 'Gg Oak Lawn', 'ET', '4700 Southwest Highway', 'Oak Lawn', 'IL', '60453', '8.70', '41.724344', '-87.738564')
036 OK      | ('36', 'city', 'enterprise', 'E11578', 'Dd Bucktown', 'ET', '1842 N Milwaukee Ave', 'Chicago', 'IL', '60647', '8.91', '41.914815', '-87.684416')
037 OK      | ('37', 'city', 'enterprise', 'E11575', 'Gg Berwyn', 'ET', '6301 Ogden Ave', 'Berwyn', 'IL', '60402', '9.33', '41.831514', '-87.780798')
038 OK      | ('38', 'city', 'enterprise', 'E1159D', 'Gg Blue Island', 'ET', '11945 Western Ave', 'Blue Island', 'IL', '60406', '9.47', '41.67601', '-87.680491')
039 NO DATA | ('39', 'city', 'enterprise', 'E115FX', 'Nn Fox Ford', 'ET', '2501 N Elston Ave', 'Chicago', 'IL', '60647', '9.58', '41.92709', '-87.68011')
041 NO DATA | ('41', 'city', 'avis', 'CHIC04', 'Logan Square', 'AV', '3255 West Fullerton Avenue', 'Chicago', 'IL', '60647', '10.15', '41.92456', '-87.70991')
040 OK      | ('40', 'city', 'enterprise', 'E11510', 'Nn Lincoln Park', 'ET', '2900 N Sheffield', 'Chicago', 'IL', '60657', '9.61', '41.934515', '-87.653996')
042 OK      | ('42', 'city', 'budget', 'CHIC01', 'Logan Square Chicago Il', 'BG', '3255 West Fullerton Avenue', 'Chicago', 'IL', '60647', '10.15', '41.92456', '-87.70991')
043 OK      | ('43', 'city', 'budget', 'CHIC07', 'Chicago/lakeview', 'BG', '3721 North Broadway Street', 'Chicago', 'IL', '60613', '10.55', '41.94957', '-87.64859')
045 OK      | ('45', 'city', 'avis', 'CHIS04', 'Sears Auto-westfield Chicago Ridge Mall', 'AV', '6501 West 95th Street', 'Chicago Ridge', 'IL', '60415', '10.78', '41.719547', '-87.78285')
044 NO DATA | ('44', 'city', 'avis', 'CHIC07', 'Lakeview/chicago', 'AV', '3721 North Broadway Street', 'Chicago', 'IL', '60613', '10.56', '41.94973', '-87.64849')
046 OK      | ('46', 'city', 'budget', 'CHIS02', 'Chicago Ridge Il Sears', 'BG', '6501 West 95th Street', 'Chicago Ridge', 'IL', '60415', '10.78', '41.719547', '-87.78285')
047 OK      | ('47', 'city', 'enterprise', 'E115C9', 'Nn Gerber Logan Square', 'ET', '3029 No Kedzie', 'Chicago', 'IL', '60618', '10.78', '41.936343', '-87.707473')
049 OK      | ('49', 'city', 'budget', 'CHIW09', 'Oak Park', 'BG', '414 Madison Street', 'Oak Park', 'IL', '60302', '10.82', '41.880333', '-87.785225')
048 OK      | ('48', 'city', 'avis', 'CHIW12', 'Oak Park', 'AV', '414 Madison Street', 'Oak Park', 'IL', '60302', '10.82', '41.88025', '-87.785286')
050 OK      | ('50', 'city', 'enterprise', 'E11509', 'Dd Oak Park', 'ET', '25 Chicago Ave', 'Oak Park', 'IL', '60302', '10.97', '41.894663', '-87.775929')
051 OK      | ('51', 'city', 'enterprise', 'E11588', 'Gg Bridgeview', 'ET', '6801 W 95th St', 'Oak Lawn', 'IL', '60453', '11.09', '41.719279', '-87.789709')
052 OK      | ('52', 'city', 'enterprise', 'E11581', 'Gg Crestwood', 'ET', '12055 S. Cicero', 'Alsip', 'IL', '60803', '11.20', '41.673567', '-87.738897')
053 OK      | ('53', 'city', 'enterprise', 'E11522', 'Gg Forest Park', 'ET', '7630 Roosevelt Rd Ste 73', 'Forest Park', 'IL', '60130', '11.71', '41.864679', '-87.814844')
054 OK      | ('54', 'city', 'enterprise', 'E11559', 'Nn Riverview', 'ET', '4314 N Western Ave', 'Chicago', 'IL', '60618', '11.85', '41.959919', '-87.688863')
055 OK      | ('55', 'city', 'enterprise', 'E11528', 'Nn Cragin', 'ET', '3057 N. Cicero', 'Chicago', 'IL', '60641', '11.92', '41.936688', '-87.746583')
056 OK      | ('56', 'city', 'enterprise', 'E11558', 'Nn Uptown', 'ET', '5313 N. Sheridan Road', 'Chicago', 'IL', '60640', '12.59', '41.978742', '-87.654958')
057 OK      | ('57', 'city', 'enterprise', 'E115DB', 'Gg Brookfield', 'ET', '9116 Ogden Ave', 'Brookfield', 'IL', '60513', '12.70', '41.816932', '-87.849992')
058 OK      | ('58', 'city', 'enterprise', 'E11502', 'Nn Irving Park', 'ET', '5358 W Irving Park Rd', 'Chicago', 'IL', '60641', '13.31', '41.953179', '-87.761859')
060 OK      | ('60', 'city', 'enterprise', 'E1151G', 'Gg South Holland', 'ET', '16130 State St', 'South Holland', 'IL', '60473', '13.76', '41.602075', '-87.617275')
059 OK      | ('59', 'city', 'enterprise', 'E11527', 'Aa Lagrange', 'ET', '5508 S La Grange Rd', 'Countryside', 'IL', '60525', '13.64', '41.79009', '-87.868729')
061 OK      | ('61', 'city', 'enterprise', 'E11524', 'Napleton Chrysler', 'ET', '5950 N Western Ave', 'Chicago', 'IL', '60659', '13.81', '41.989931', '-87.689823')
062 OK      | ('62', 'city', 'enterprise', 'E115CH', 'Dd Elmwood Park', 'ET', '7807 W Grand Ave', 'Elmwood Park', 'IL', '60707', '14.15', '41.926269', '-87.821333')
063 OK      | ('63', 'city', 'enterprise', 'E11517', 'Gg Calumet City', 'ET', '410 River Oaks W', 'Calumet City', 'IL', '60409', '14.33', '41.597253', '-87.552046')
064 OK      | ('64', 'city', 'enterprise', 'E11536', 'Gg Hammond', 'ET', '5716 Indianapolis Blvd', 'Hammond', 'IN', '46320', '14.69', '41.609535', '-87.480752')
065 OK      | ('65', 'city', 'budget', 'CHIN08', 'Lincolnwood', 'BG', '6517 North Lincoln Avenue', 'Lincolnwood', 'IL', '60712', '15.03', '41.9995', '-87.722')
067 OK      | ('67', 'city', 'enterprise', 'E11551', 'Dd Stone Park', 'ET', '1701 N. Mannheim Rd', 'Stone Park', 'IL', '60165', '16.04', '41.903409', '-87.883578')
066 OK      | ('66', 'city', 'enterprise', 'E115C1', 'Nn Norwood Park C1', 'ET', '5451 N Northwest Hwy', 'Chicago', 'IL', '60630', '15.24', '41.979844', '-87.776625')
069 OK      | ('69', 'city', 'avis', 'CHIN03', 'Evanston (525 Kedzie Building)', 'AV', '801 Chicago Avenue', 'Evanston', 'IL', '60202', '16.46', '42.03226', '-87.67768')
068 OK      | ('68', 'city', 'enterprise', 'E11553', 'Nn Lincolnwood 53', 'ET', '3209 Howard St', 'Skokie', 'IL', '60076', '16.04', '42.019014', '-87.709152')
070 OK      | ('70', 'city', 'budget', 'CHIN19', 'Evanston', 'BG', '801 Chicago Avenue', 'Evanston', 'IL', '60202', '16.46', '42.03226', '-87.67768')
071 OK      | ('71', 'city', 'enterprise', 'E11513', 'Gg Orland Park East', 'ET', '15701 S 71st Ct', 'Orland Park', 'IL', '60462', '16.75', '41.604145', '-87.794035')
072 OK      | ('72', 'city', 'avis', 'CHIS01', 'Orland Park, Il', 'AV', '7412 West 159th Street', 'Orland Park', 'IL', '60462', '16.99', '41.603123', '-87.79996')
073 OK      | ('73', 'city', 'budget', 'CHIS01', 'Orland Park', 'BG', '7412 West 159th Street', 'Orland Park', 'IL', '60462', '16.99', '41.603123', '-87.79996')
074 OK      | ('74', 'city', 'enterprise', 'E11589', 'Gg Homewood', 'ET', '18300 A South Halsted', 'Glenwood', 'IL', '60425', '17.26', '41.5525', '-87.6387')
075 OK      | ('75', 'city', 'enterprise', 'E11516', 'Nn Skokie', 'ET', '8225 Skokie Blvd', 'Skokie', 'IL', '60077', '17.54', '42.030789', '-87.74713')
076 OK      | ('76', 'city', 'enterprise', 'E115CZ', 'Schiller Park', 'ET', '4940 River Rd', 'Schiller Park', 'IL', '60176', '17.63', '41.968657', '-87.861879')
077 OK      | ('77', 'city', 'enterprise', 'E115N2', 'Nn South Evanston N2', 'ET', '1810 Maple Ave', 'Evanston', 'IL', '60201', '17.76', '42.0502', '-87.68493')
078 OK      | ('78', 'city', 'enterprise', 'E115EX', 'Exotic Cook County', 'ET', '1810 Maple Ave', 'Evanston', 'IL', '60201', '17.82', '42.051186', '-87.684985')
079 OK      | ('79', 'city', 'enterprise', 'E11585', 'Gg Lansing', 'ET', '3331 Glenwood Lansing Rd', 'Lansing', 'IL', '60438', '18.03', '41.542754', '-87.554405')
080 NO DATA | ('80', 'city', 'avis', 'CHIW13', 'Oak Brook Doubletree Hotel', 'AV', '1909 Spring Road', 'Oak Brook', 'IL', '60523', '18.03', '41.852848', '-87.94729')
081 OK      | ('81', 'city', 'budget', 'CHIW08', 'Oak Brook Il', 'BG', '1909 Spring Road', 'Oak Brook', 'IL', '60523', '18.03', '41.852848', '-87.94729')
084 OK      | ('84', 'city', 'budget', 'CHIN09', 'Skokie', 'BG', '5151 Dempster Street', 'Skokie', 'IL', '60077', '18.35', '42.04075', '-87.7561')
083 OK      | ('83', 'city', 'avis', 'CHIN06', 'Skokie - Dempster Street', 'AV', '5151 Dempster Street', 'Skokie', 'IL', '60077', '18.35', '42.04075', '-87.7561')
082 OK      | ('82', 'city', 'enterprise', 'E115D2', 'Gg Orland West', 'ET', '8878 W. 159th', 'Orland Park', 'IL', '60462', '18.12', '41.601694', '-87.83278')
085 OK      | ('85', 'city', 'enterprise', 'E115AD', 'Aa Willowbrook', 'ET', '10s636 Kingery Hwy', 'Willowbrook', 'IL', '60527', '18.57', '41.714094', '-87.945247')
086 OK      | ('86', 'city', 'enterprise', 'E115F1', 'Morton Grove', 'ET', '6065 Dempster St', 'Morton Grove', 'IL', '60053', '18.86', '42.040761', '-87.777849')
087 OK      | ('87', 'city', 'enterprise', 'E115RH', 'Aa Holiday Inn', 'ET', '17w350 22nd St', 'Oakbrook Ter', 'IL', '60181', '18.96', '41.846533', '-87.967222')
088 OK      | ('88', 'city', 'enterprise', 'E11533', 'Nn North Evanston', 'ET', '2636 Green Bay Rd', 'Evanston', 'IL', '60201', '18.96', '42.065419', '-87.699728')
089 NO DATA | ('89', 'airport', 'avis', 'ORDT01', 'Chicago Ohare Intl Airport', 'AV', '10000 Bessie Coleman Drive', 'Chicago', 'IL', '60666', '19.01', '41.98131', '-87.88256')
090 OK      | ('90', 'airport', 'budget', 'ORDT01', 'Ohare Intl Airport', 'BG', '10000 Bessie Coleman Drive', 'Chicago', 'IL', '60666', '19.01', '41.98131', '-87.88256')
092 OK      | ('92', 'city', 'enterprise', 'E11508', 'Aa Westmont', 'ET', '540 North Cass', 'Westmont', 'IL', '60559', '19.16', '41.808409', '-87.9759')
091 OK      | ('91', 'airport', 'alamo', 'ORDT71', 'Chicago Ohare Airport', 'AL', '560 Bessie Coleman Drive', 'Chicago', 'IL', '60666', '19.06', '41.979899', '-87.885468')
093 OK      | ('93', 'city', 'enterprise', 'E11501', 'Aa Elmhurst', 'ET', '896 North York Road', 'Elmhurst', 'IL', '60126', '19.34', '41.92641', '-87.939792')
094 NO DATA | ('94', 'city', 'enterprise', 'E115P1', 'Packer Branch Elmhurst', 'ET', '896 North York Road', 'Elmhurst', 'IL', '60126', '19.34', '41.926378', '-87.939894')
096 OK      | ('96', 'city', 'enterprise', 'E115GR', 'Gg Griffith', 'ET', '112 E Ridge Rd', 'Griffith', 'IN', '46319', '19.55', '41.551021', '-87.427419')
097 OK      | ('97', 'airport', 'enterprise', 'ORDT61', 'Ohare Intl Arpt', 'ET', '6400 N Schilling Rd', 'Chicago', 'IL', '60666', '19.79', '41.995592', '-87.885729')
095 OK      | ('95', 'city', 'enterprise', 'E11532', 'Gg Highland', 'ET', '9650 Indianapolis Blvd', 'Highland', 'IN', '46322', '19.43', '41.538019', '-87.471322')
098 OK      | ('98', 'city', 'enterprise', 'E115AL', 'Aa Lombard', 'ET', '113 W Roosevelt Rd', 'Villa Park', 'IL', '60181', '19.86', '41.86029', '-87.98148')
099 OK      | ('99', 'city', 'enterprise', 'E115AK', 'Aa W Grand Ave', 'ET', '400 W Grand Ave', 'Elmhurst', 'IL', '60126', '20.15', '41.9305', '-87.954659')
101 OK      | ('101', 'city', 'avis', 'CHIW10', 'Lombard', 'AV', '1101 East Roosevelt Road', 'Lombard', 'IL', '60148', '20.30', '41.86054', '-87.99008')
100 OK      | ('100', 'city', 'enterprise', 'E11550', 'Nn-park Ridge', 'ET', '2315 Oakton St', 'Park Ridge', 'IL', '60068', '20.19', '42.024864', '-87.855535')
102 OK      | ('102', 'city', 'budget', 'CHIW03', 'Lombard', 'BG', '1101 East Roosevelt Road', 'Lombard', 'IL', '60148', '20.30', '41.86054', '-87.99008')
103 OK      | ('103', 'city', 'enterprise', 'E11505', 'Nn Des Plaines 1505', 'ET', '1670 S. River Road', 'Des Plaines', 'IL', '60018', '20.79', '42.02303', '-87.876173')
104 OK      | ('104', 'city', 'enterprise', 'E11546', 'Aa Villa Park', 'ET', '501 West North Ave.', 'Villa Park', 'IL', '60181', '20.90', '41.90522', '-87.98516')
105 OK      | ('105', 'city', 'enterprise', 'E1157N', 'Golf Mill Ford', 'ET', '9401 N Milwaukee Ave', 'Niles', 'IL', '60714', '21.00', '42.051139', '-87.834753')
106 OK      | ('106', 'city', 'avis', 'CHIN02', 'Sears Auto Ctr - Golf Mill Shopping Ctr', 'AV', '9411 North Greenwood Avenue', 'Niles', 'IL', '60714', '21.15', '42.051243', '-87.83984')
107 OK      | ('107', 'city', 'budget', 'CHIN04', 'Niles Il Sears', 'BG', '9411 North Greenwood Avenue', 'Niles', 'IL', '60714', '21.15', '42.051243', '-87.83984')
108 NO DATA | ('108', 'city', 'enterprise', 'E115PD', 'Packer Br Downers Grove', 'ET', '7411 Lemont Rd', 'Downers Grove', 'IL', '60516', '21.30', '41.752699', '-88.012501')
109 OK      | ('109', 'city', 'enterprise', 'E11519', 'Aa South Downers Grove', 'ET', '7411 Lemont Road', 'Downers Grove', 'IL', '60516', '21.31', '41.752321', '-88.012558')
110 OK      | ('110', 'city', 'enterprise', 'E11584', 'Gg Matteson', 'ET', '4545 Lincoln Hwy', 'Matteson', 'IL', '60443', '21.35', '41.505936', '-87.726663')
112 OK      | ('112', 'city', 'budget', 'CHIW04', 'Downers Grove Il', 'BG', '1340 Ogden Avenue', 'Downers Grove', 'IL', '60515', '21.35', '41.80815', '-88.01856')
111 OK      | ('111', 'city', 'avis', 'CHIW06', 'Downers Grove, Il', 'AV', '1340 Ogden Avenue', 'Downers Grove', 'IL', '60515', '21.35', '41.80815', '-88.01856')
113 OK      | ('113', 'city', 'enterprise', 'E115A4', 'Aa North Downers Grove', 'ET', '1420 Ogden Ave', 'Downers Grove', 'IL', '60515', '21.41', '41.808226', '-88.019714')
114 OK      | ('114', 'city', 'enterprise', 'E115GA', 'Gg Gary', 'ET', '3790 Grant St', 'Gary', 'IN', '46408', '21.60', '41.549776', '-87.355896')
115 OK      | ('115', 'city', 'enterprise', 'E115D3', 'Gg Schererville', 'ET', '1233 Us Highway 41', 'Schererville', 'IN', '46375', '21.81', '41.501676', '-87.471048')
116 OK      | ('116', 'city', 'enterprise', 'E1154G', 'Gg Miller Automall', 'ET', '21321 Central Ave', 'Matteson', 'IL', '60443', '21.92', '41.5035', '-87.751447')
118 OK      | ('118', 'city', 'avis', 'CHIW03', 'Elk Grove Village, Il', 'AV', '2420 Landmeier Road', 'Elk Grove Village', 'IL', '60007', '22.76', '42.01132', '-87.94404')
117 OK      | ('117', 'city', 'enterprise', 'E11582', 'Gg Frankfort And Mokena', 'ET', '19300 La Grange Rd', 'Mokena', 'IL', '60448', '22.13', '41.538804', '-87.850622')
119 OK      | ('119', 'city', 'budget', 'CHIW05', 'Elk Grove Village Il', 'BG', '2420 Landmeier Road', 'Elk Grove Village', 'IL', '60007', '22.76', '42.01132', '-87.94404')
120 OK      | ('120', 'city', 'enterprise', 'E11554', 'Nn-glenview', 'ET', '2300 Waukegan Rd', 'Northfield', 'IL', '60093', '22.80', '42.096914', '-87.798417')
122 OK      | ('122', 'city', 'budget', 'CHIS07', 'Addison', 'BG', '159 South Rohlwing Road', 'Addison', 'IL', '60101', '23.57', '41.922844', '-88.031586')
121 OK      | ('121', 'city', 'enterprise', 'E115GS', 'Gg Steger', 'ET', '3421 Chicago Rd', 'Steger', 'IL', '60475', '23.02', '41.468751', '-87.63577')
123 OK      | ('123', 'city', 'avis', 'CHIS05', 'Addison', 'AV', '159 South Rohlwing Road', 'Addison', 'IL', '60101', '23.70', '41.92713', '-88.03218')
124 OK      | ('124', 'city', 'enterprise', 'E11515', 'Nn-mount Prospect', 'ET', '400 Dempster St', 'Mount Prospect', 'IL', '60056', '23.87', '42.037499', '-87.941662')
126 OK      | ('126', 'city', 'avis', 'CHIW02', 'The Hyatt Of Lisle', 'AV', '1400 Corporetum Drive', 'Lisle', 'IL', '60532', '24.42', '41.8063', '-88.07807')
125 OK      | ('125', 'city', 'enterprise', 'E11534', 'Gg Hobart', 'ET', '1500 W 37th Ave', 'Hobart', 'IN', '46342', '24.13', '41.551108', '-87.278361')
127 OK      | ('127', 'city', 'budget', 'CHIW10', 'The Hyatt Of Lisle Il', 'BG', '1400 Corporetum Drive', 'Lisle', 'IL', '60532', '24.47', '41.806988', '-88.07895')
128 OK      | ('128', 'city', 'enterprise', 'E11541', 'Aa Glen Ellyn', 'ET', '395 Roosevelt Road', 'Glen Ellyn', 'IL', '60137', '24.53', '41.859241', '-88.07394')
130 OK      | ('130', 'city', 'enterprise', 'E115LS', 'Aa Lisle', 'ET', '1712 Ogden Ave', 'Lisle', 'IL', '60532', '24.83', '41.800274', '-88.086066')
129 OK      | ('129', 'city', 'enterprise', 'E11548', 'Aa Bolingbrook', 'ET', '417 N Bolingbrook Dr', 'Bolingbrook', 'IL', '60440', '24.81', '41.707431', '-88.068758')
131 NO DATA | ('131', 'city', 'avis', 'CHIN16', 'Renaissance Chicago North Shore', 'AV', '933 Skokie Blvd', 'Northbrook', 'IL', '60062', '25.02', '42.135353', '-87.78872')
132 OK      | ('132', 'city', 'budget', 'CHIN16', 'Northbrook', 'BG', '933 Skokie Blvd', 'Northbrook', 'IL', '60062', '25.02', '42.135353', '-87.78872')
134 OK      |133 NO DATA |  ('134', 'city', 'budget', 'SBNW01', 'Merrillville', 'BG', '1750 West 81st Avenue', 'Merrillville', 'IN', '46410', '26.05', '41.472466', '-87.35756')('133', 'city', 'avis', 'SBNW01', 'Merrillville Car Care Center', 'AV', '1750 West 81st Avenue', 'Merrillville', 'IN', '46410', '26.05', '41.472466', '-87.35756')

135 OK      | ('135', 'city', 'enterprise', 'E115N7', 'Nn-wheeling', 'ET', '99 E Palatine Rd', 'Wheeling', 'IL', '60090', '26.13', '42.108959', '-87.897977')
136 OK      | ('136', 'city', 'enterprise', 'E115LP', 'Aa Lockport', 'ET', '1240 E 9th St', 'Lockport', 'IL', '60441', '26.20', '41.597651', '-88.032744')
138 OK      | ('138', 'city', 'enterprise', 'E115GN', 'Gg New Lenox', 'ET', '650 E Lincoln Hwy', 'New Lenox', 'IL', '60451', '26.83', '41.512281', '-87.951544')
137 OK      | ('137', 'city', 'enterprise', 'E11538', 'Gg Merrillville', 'ET', '1100 W 81st Ave', 'Merrillville', 'IN', '46410', '26.33', '41.471163', '-87.349806')
140 OK      | ('140', 'city', 'avis', 'CHIW08', 'Naperville, Il', 'AV', '1115 East Ogden Avenue', 'Naperville', 'IL', '60563', '27.04', '41.792515', '-88.12876')
139 OK      | ('139', 'city', 'budget', 'CHIS05', 'Naperville', 'BG', '1115 East Ogden Avenue', 'Naperville', 'IL', '60563', '27.01', '41.7924', '-88.1281')
141 OK      | ('141', 'city', 'enterprise', 'E11573', 'Aa East Naperville', 'ET', '1097 E Ogden Ave', 'Naperville', 'IL', '60563', '27.09', '41.791525', '-88.12976')
142 OK      | ('142', 'city', 'enterprise', 'E11504', 'Nn-arlington Heights', 'ET', '215 S Arlington Heights Rd', 'Arlington Heights', 'IL', '60005', '27.34', '42.080032', '-87.980205')
144 OK      | ('144', 'city', 'enterprise', 'E115AJ', 'Aa Carol Stream', 'ET', '371 N Gary Ave', 'Carol Stream', 'IL', '60188', '27.68', '41.912262', '-88.120477')
143 OK      | ('143', 'city', 'enterprise', 'E115NT', 'Aa Rolling Meadows Nt', 'ET', '2785 Algonquin Rd', 'Rolling Meadows', 'IL', '60008', '27.52', '42.058915', '-88.011279')
145 OK      | ('145', 'city', 'enterprise', 'E11549', 'Aa East Schaumburg', 'ET', '534 Mall Drive', 'Schaumburg', 'IL', '60173', '27.81', '42.039629', '-88.039012')
148 OK      | ('148', 'city', 'budget', 'CHIW12', 'Hyatt Woodfield', 'BG', '1800 East Golf Road', 'Schaumburg', 'IL', '60173', '28.09', '42.05144', '-88.03364')
147 OK      | ('147', 'city', 'avis', 'CHIW01', 'Schaumburg Hyatt Regency Hotel', 'AV', '1800 East Golf Road', 'Schaumburg', 'IL', '60173', '28.09', '42.05144', '-88.03364')
146 OK      | ('146', 'city', 'enterprise', 'E115NX', 'Nn-hyatt-deerfield', 'ET', '1750 Lake Cook Road', 'Deerfield', 'IL', '60015', '27.93', '42.153096', '-87.86922')
149 OK      | ('149', 'city', 'enterprise', 'E115GP', 'Gg Portage', 'ET', '6279 Us Highway 6', 'Portage', 'IN', '46368', '28.25', '41.550398', '-87.172509')
150 OK      |151 OK      | 152 OK      | ('150', 'city', 'enterprise', 'E11531', 'Nn-highland Park', 'ET', '1430 Old Skokie Valley Road', 'Highland Park', 'IL', '60035', '28.39', '42.178692', '-87.819165') ('151', 'city', 'enterprise', 'E11540', 'Aa Roselle', 'ET', '950 S Roselle Road', 'Schaumburg', 'IL', '60193', '28.43', '42.009392', '-88.080225')
('152', 'city', 'enterprise', 'E1155G', 'Gg East Merrillville', 'ET', '4550 E Lincoln Hwy', 'Merrillville', 'IN', '46410', '28.45', '41.470409', '-87.276588')

153 OK      | ('153', 'city', 'avis', 'CHIS06', 'Lewis University Airport', 'AV', '1 Hanger Road', 'Romeoville', 'IL', '60446', '28.59', '41.60497', '-88.092224')
154 OK      | ('154', 'city', 'budget', 'CHIS08', 'Romeoville, Il Lewis Airport', 'BG', '1 Hanger Road', 'Romeoville', 'IL', '60446', '28.59', '41.60497', '-88.092224')
155 OK      | ('155', 'city', 'enterprise', 'E1153G', 'Gg Arnell', 'ET', '237 Melton Rd', 'Burns Harbor', 'IN', '46304', '28.80', '41.604724', '-87.112503')
156 OK      | ('156', 'city', 'enterprise', 'E11506', 'Aa Schaumburg', 'ET', '1035 East Golf Road', 'Schaumburg', 'IL', '60173', '28.87', '42.050006', '-88.054263')
157 NO DATA | ('157', 'city', 'avis', 'CHIN07', 'Highland Park Ford', 'AV', '1333 Park Avenue West', 'Highland Park', 'IL', '60035', '29.21', '42.18987', '-87.824715')
158 OK      | ('158', 'city', 'budget', 'CHIN02', 'Highland Park', 'BG', '1333 Park Ave W', 'Highland Park', 'IL', '60035', '29.21', '42.18987', '-87.824715')
160 OK      | ('160', 'city', 'enterprise', 'E115GB', 'Gg Cedar Lake', 'ET', '11009 W 133rd Ave', 'Cedar Lake', 'IN', '46303', '30.13', '41.377238', '-87.468396')
159 OK      | ('159', 'city', 'enterprise', 'E115GF', 'Gg Crown Point Indiana', 'ET', '10724 Broadway', 'Crown Point', 'IN', '46307', '29.60', '41.423018', '-87.335557')
161 OK      | ('161', 'city', 'enterprise', 'E115AN', 'Aa West Ogden', 'ET', '1715 W Ogden Ave', 'Naperville', 'IL', '60540', '30.14', '41.762253', '-88.186569')
162 OK      | ('162', 'city', 'enterprise', 'E115AH', 'Aa Hanover Park', 'ET', '1001 Irving Park Rd', 'Hanover Park', 'IL', '60133', '30.52', '42.003261', '-88.131078')
163 OK      | ('163', 'city', 'avis', 'CHIN11', 'Schaumburg/hoffman Estates', 'AV', '805 West Higgins Road', 'Hoffman Estates', 'IL', '60195', '30.75', '42.049248', '-88.099846')
164 OK      | ('164', 'city', 'budget', 'CHIN05', 'Schaumburg', 'BG', '805 West Higgins Road', 'Hoffman Estates', 'IL', '60195', '30.75', '42.049248', '-88.099846')
165 OK      | ('165', 'city', 'enterprise', 'E115A1', 'Aa Hoffman Estates', 'ET', '809 W Higgins Rd', 'Schaumburg', 'IL', '60195', '30.76', '42.049644', '-88.099604')
166 OK      | ('166', 'city', 'enterprise', 'E115AX', 'Aa Warrenville', 'ET', '2 South 781 Route 59 Unit B', 'Warrenville', 'IL', '60555', '30.85', '41.8263', '-88.202')
168 OK      | ('168', 'city', 'avis', 'CHIW11', 'Naperville - Pebblewood Plaza', 'AV', '1550 North Route 59, Suite 184', 'Naperville', 'IL', '60563', '30.94', '41.795982', '-88.20447')
167 OK      | ('167', 'city', 'enterprise', 'E115NY', 'Nn-napleton Dge Jeep Chr', 'ET', '1155 W Dundee Rd', 'Arlington Heights', 'IL', '60004', '30.91', '42.138909', '-87.997069')
169 OK      | ('169', 'city', 'budget', 'CHIW06', 'Naperville Il', 'BG', '1550 North Route 59 Suite 184', 'Naperville', 'IL', '60563', '30.94', '41.795982', '-88.20447')
172 OK      | ('172', 'city', 'budget', 'AUZC02', 'Aurora Il Sears', 'BG', '2 Fox Valley Center', 'Aurora', 'IL', '60504', '31.24', '41.758778', '-88.20756')
171 OK      | ('171', 'city', 'avis', 'AUZC02', 'Sears Auto Ctr-westfield Fox Valley Mall', 'AV', '2 Fox Valley Center', 'Aurora', 'IL', '60504', '31.24', '41.758778', '-88.20756')
170 OK      | ('170', 'city', 'enterprise', 'E115YN', 'Aa Naperville North', 'ET', '504 North Route 59', 'Naperville', 'IL', '60563', '31.04', '41.780769', '-88.205731')
173 OK      | ('173', 'city', 'avis', 'CHIW04', 'Streamwood, Il', 'AV', '724 South Barrington Road', 'Streamwood', 'IL', '60107', '31.61', '42.017406', '-88.14513')
174 OK      | ('174', 'city', 'budget', 'CHIW07', 'Streamwood Il', 'BG', '724 South Barrington Road', 'Streamwood', 'IL', '60107', '31.61', '42.017406', '-88.14513')
176 OK      | ('176', 'city', 'enterprise', 'E115AC', 'Aa South Naperville', 'ET', '24125 111th St Ste 900', 'Naperville', 'IL', '60564', '32.22', '41.68058', '-88.20771')
175 OK      | ('175', 'city', 'enterprise', 'E115AB', 'Aa East Aurora', 'ET', '4000 Ogden Ave', 'Aurora', 'IL', '60504', '31.67', '41.75084', '-88.214853')
177 OK      | ('177', 'city', 'enterprise', 'E115A5', 'Aa Crest Hill', 'ET', '2400 Plainfield Rd', 'Crest Hill', 'IL', '60403', '32.26', '41.568463', '-88.146129')
178 OK      | ('178', 'city', 'enterprise', 'E115DP', 'Aa North Plainfield', 'ET', '12337 S Route 59 Unit 135', 'Plainfield', 'IL', '60585', '32.46', '41.657817', '-88.203493')
179 OK      | ('179', 'city', 'avis', 'CHIS10', 'Sears Auto Center - Louis Joliet Mall', 'AV', '3340 Mall Loop Drive', 'Joliet', 'IL', '60435', '32.83', '41.57457', '-88.1632')
180 OK      | ('180', 'city', 'budget', 'CHIS10', 'Joliet Il Sears', 'BG', '3340 Mall Loop Drive', 'Joliet', 'IL', '60435', '32.83', '41.57457', '-88.1632')
181 OK      | ('181', 'city', 'enterprise', 'E11545', 'Aa Palatine', 'ET', '2234 N Rand Rd', 'Palatine', 'IL', '60074', '32.84', '42.150901', '-88.035398')
182 NO DATA | ('182', 'city', 'enterprise', 'E115PA', 'Packer Branch Joliet', 'ET', '2221 W Jefferson St', 'Joliet', 'IL', '60435', '33.51', '41.5225', '-88.135302')

In [ ]:

    




    

In [6]:

    

car1 = 'Economy Car'
car2 = 'Compact Car'
car3 = 'Intermediate Car'
car4 = 'Intermediate SUV'
desiredcar = car2

results2 = dict()
for k,v in results.items():
    #print(v)
    if desiredcar in v:
        results2[k] = v
order = np.array([x[desiredcar] for x in results2.values()]).argsort()
order = np.array([x[desiredcar] for x in results2.values() if desiredcar in x]).argsort()


    

In [7]:

    

brands = np.array([x['brand'] for x in results2.values()])[order]
nums = np.array([x for x in results2.keys()])[order]
titles = np.array([x['name'] for x in results2.values()])[order]
prices = np.array([x[desiredcar] for x in results2.values()])[order]
prices2 = np.array([x[car2] for x in results2.values()])[order]
prices3 = np.array([x[car3] for x in results2.values()])[order]
distances = np.array([x['dist'] for x in results2.values()])[order]

print(data['pickupDate'],data['pickupTime'],data['dropoffDate'],data['dropoffTime'],desiredcar,car2,car3)
for k in zip(nums,prices,prices2,prices3,brands,titles,distances):
    #print(k)
    print('{:03d} | {:5.2f} | {:7.2f} | {:7.2f} | {:7.2f} | {:12s} | {}'.format(k[0],float(k[6]),k[1],k[2],k[3],str(k[4]),k[5]))


    

    




11/1/2017 10:00 AM 11/8/2017 10:00 AM Compact Car Compact Car Intermediate Car






    




---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
<ipython-input-7-01ace2a828f5> in <module>()
     10 for k in zip(nums,prices,prices2,prices3,brands,titles,distances):
     11     #print(k)
---> 12     print('{:03d} | {:5.2f} | {:7.2f} | {:7.2f} | {:7.2f} | {:12s} | {}'.format(k[0],float(k[6]),k[1],k[2],k[3],str(k[4]),k[5]))

ValueError: could not convert string to float: '1333 Park Ave W'

In [ ]:

    

print(results2)
#pickle.dump(results2, open("rental_3wks.pkl","wb"))


    

In [ ]:

    

"""
10/19/2017 10:00 AM 10/26/2017 10:00 AM Compact Car Compact Car Intermediate Car
214 | 44.16 |  125.31 |  125.31 |  128.39 | avis         | Sears Auto Center - Gurnee Mills Mall
215 | 44.16 |  125.99 |  125.99 |  124.49 | budget       | Gurnee Il Sears
197 | 37.18 |  126.50 |  126.50 |  129.62 | avis         | Lake Zurich-village Square Auto Center
201 | 37.57 |  126.50 |  126.50 |  129.62 | avis         | Libertyville - Milwaukee Avenue
157 | 29.21 |  126.50 |  126.50 |  129.62 | avis         | Highland Park Ford
221 | 46.33 |  126.50 |  126.50 |  129.62 | avis         | Crystal Lake, Il
206 | 39.56 |  126.50 |  126.50 |  129.62 | avis         | Libertyville - Peterson Road
198 | 37.18 |  127.19 |  127.19 |  125.67 | budget       | Lake Zurich Il
200 | 37.57 |  127.19 |  127.19 |  125.67 | budget       | Libertyville
222 | 46.33 |  127.19 |  127.19 |  125.67 | budget       | Crystal Lake Il
158 | 29.21 |  127.19 |  127.19 |  125.67 | budget       | Highland Park
207 | 39.56 |  127.19 |  127.19 |  125.67 | budget       | Libertyville Il
131 | 25.02 |  133.66 |  133.66 |  136.95 | avis         | Renaissance Chicago North Shore
132 | 25.02 |  134.39 |  134.39 |  132.79 | budget       | Northbrook
194 | 36.89 |  135.72 |  135.72 |  139.10 | budget       | Aurora
113 | 21.35 |  135.72 |  135.72 |  139.10 | budget       | Downers Grove Il
169 | 30.94 |  135.72 |  135.72 |  139.10 | budget       | Naperville Il
172 | 31.24 |  135.72 |  135.72 |  139.10 | budget       | Aurora Il Sears
139 | 27.01 |  135.72 |  135.72 |  139.10 | budget       | Naperville
121 | 22.80 |  139.98 |  139.98 |  147.97 | enterprise   | Nn-glenview
213 | 44.03 |  141.84 |  141.84 |  151.29 | enterprise   | Nn-lake Villa
218 | 44.78 |  141.84 |  141.84 |  151.29 | enterprise   | Aa -algonquin
189 | 36.51 |  141.84 |  141.84 |  151.29 | enterprise   | Nn-mundelein
209 | 40.91 |  141.84 |  141.84 |  151.29 | enterprise   | Aa Casten's Body Shop
225 | 47.30 |  141.84 |  141.84 |  151.29 | enterprise   | Nn-round Lake Heights
217 | 44.78 |  141.84 |  141.84 |  151.29 | enterprise   | Nn-gurnee
168 | 30.94 |  142.18 |  142.18 |  144.64 | avis         | Naperville - Pebblewood Plaza
112 | 21.35 |  142.18 |  142.18 |  144.64 | avis         | Downers Grove, Il
127 | 24.42 |  142.18 |  142.18 |  144.64 | avis         | The Hyatt Of Lisle
171 | 31.24 |  142.18 |  142.18 |  144.64 | avis         | Sears Auto Ctr-westfield Fox Valley Mall
140 | 27.04 |  142.18 |  142.18 |  144.64 | avis         | Naperville, Il
193 | 36.89 |  142.18 |  142.18 |  144.64 | avis         | Aurora
137 | 26.33 |  142.83 |  142.83 |  145.14 | enterprise   | Gg Merrillville
152 | 28.45 |  142.83 |  142.83 |  145.14 | enterprise   | Gg East Merrillville
116 | 21.81 |  142.83 |  142.83 |  145.14 | enterprise   | Gg Schererville
160 | 30.13 |  142.83 |  142.83 |  145.14 | enterprise   | Gg Cedar Lake
159 | 29.60 |  142.83 |  142.83 |  145.14 | enterprise   | Gg Crown Point Indiana
097 | 19.55 |  142.83 |  142.83 |  145.14 | enterprise   | Gg Griffith
096 | 19.43 |  142.83 |  142.83 |  145.14 | enterprise   | Gg Highland
203 | 38.45 |  143.19 |  143.19 |  152.73 | enterprise   | Aa St Charles
150 | 28.39 |  143.19 |  143.19 |  152.73 | enterprise   | Nn-highland Park
224 | 47.08 |  143.19 |  143.19 |  152.73 | enterprise   | Aa -crystal Lake 2
220 | 45.36 |  143.19 |  143.19 |  152.73 | enterprise   | Aa Crystal Lake West
195 | 37.14 |  143.19 |  143.19 |  152.73 | enterprise   | Nn-libertyville
196 | 37.15 |  143.19 |  143.19 |  152.73 | enterprise   | Aa Barrington
192 | 36.83 |  143.19 |  143.19 |  152.73 | enterprise   | Aa East St. Charles
082 | 18.03 |  148.14 |  148.14 |  149.54 | budget       | Oak Brook Il
191 | 36.65 |  148.91 |  148.91 |  152.73 | enterprise   | Aa Aurora
186 | 35.80 |  149.56 |  149.56 |  150.97 | budget       | St.charles
123 | 23.57 |  149.56 |  149.56 |  150.97 | budget       | Addison
130 | 24.83 |  150.34 |  150.34 |  159.88 | enterprise   | Aa Lisle
141 | 27.09 |  150.34 |  150.34 |  159.88 | enterprise   | Aa East Naperville
188 | 36.35 |  151.27 |  151.27 |  166.40 | enterprise   | Aa Oswego
181 | 32.84 |  151.30 |  151.30 |  161.38 | enterprise   | Aa Palatine
175 | 31.67 |  152.15 |  152.15 |  161.69 | enterprise   | Aa East Aurora
161 | 30.14 |  152.15 |  152.15 |  161.69 | enterprise   | Aa West Ogden
170 | 31.04 |  152.15 |  152.15 |  161.69 | enterprise   | Aa Naperville North
166 | 30.85 |  152.15 |  152.15 |  161.69 | enterprise   | Aa Warrenville
144 | 27.68 |  152.71 |  152.71 |  167.98 | enterprise   | Aa Carol Stream
216 | 44.52 |  152.71 |  152.71 |  167.98 | enterprise   | Aa Yorkville
134 | 26.05 |  155.02 |  155.02 |  156.50 | budget       | Merrillville
086 | 18.57 |  156.02 |  156.02 |  165.47 | enterprise   | Aa Willowbrook
212 | 41.03 |  156.61 |  156.61 |  158.09 | budget       | West Dundee Sears
174 | 31.61 |  156.61 |  156.61 |  158.09 | budget       | Streamwood Il
081 | 18.03 |  157.28 |  157.28 |  157.37 | avis         | Oak Brook Doubletree Hotel
102 | 20.30 |  157.28 |  157.28 |  157.37 | avis         | Lombard
110 | 21.31 |  157.49 |  157.49 |  167.03 | enterprise   | Aa South Downers Grove
093 | 19.16 |  157.49 |  157.49 |  167.03 | enterprise   | Aa Westmont
114 | 21.41 |  157.51 |  157.51 |  167.05 | enterprise   | Aa North Downers Grove
085 | 18.35 |  158.02 |  158.02 |  159.51 | budget       | Skokie
108 | 21.15 |  158.02 |  158.02 |  159.51 | budget       | Niles Il Sears
047 | 10.78 |  158.02 |  158.02 |  159.51 | budget       | Chicago Ridge Il Sears
074 | 16.99 |  158.02 |  158.02 |  159.51 | budget       | Orland Park
120 | 22.76 |  158.02 |  158.02 |  159.51 | budget       | Elk Grove Village Il
066 | 15.03 |  158.02 |  158.02 |  159.51 | budget       | Lincolnwood
033 |  8.04 |  158.02 |  158.02 |  159.51 | budget       | Oak Lawn
124 | 23.70 |  158.78 |  158.78 |  158.87 | avis         | Addison
185 | 35.80 |  158.78 |  158.78 |  158.87 | avis         | Foxfield Commons Shopping Plaza
148 | 28.09 |  159.02 |  159.02 |  160.51 | budget       | Hyatt Woodfield
164 | 30.75 |  159.02 |  159.02 |  160.51 | budget       | Schaumburg
146 | 27.93 |  160.72 |  160.72 |  179.63 | enterprise   | Nn-hyatt-deerfield
094 | 19.34 |  162.27 |  162.27 |  171.81 | enterprise   | Aa Elmhurst
099 | 19.86 |  162.27 |  162.27 |  171.81 | enterprise   | Aa Lombard
100 | 20.15 |  162.27 |  162.27 |  171.81 | enterprise   | Aa W Grand Ave
105 | 20.90 |  162.27 |  162.27 |  171.81 | enterprise   | Aa Villa Park
077 | 17.63 |  162.33 |  162.33 |  178.45 | enterprise   | Schiller Park
129 | 24.81 |  162.70 |  162.70 |  172.24 | enterprise   | Aa Bolingbrook
128 | 24.53 |  163.05 |  163.05 |  172.51 | enterprise   | Aa Glen Ellyn
133 | 26.05 |  164.68 |  164.68 |  164.77 | avis         | Merrillville Car Care Center
211 | 41.03 |  166.27 |  166.27 |  166.37 | avis         | Sears Auto Center-spring Hill Mall
050 | 10.82 |  166.27 |  166.27 |  166.37 | budget       | Oak Park
173 | 31.61 |  166.27 |  166.27 |  166.37 | avis         | Streamwood, Il
060 | 13.64 |  166.40 |  166.40 |  176.48 | enterprise   | Aa Lagrange
208 | 40.85 |  166.45 |  166.45 |  175.98 | enterprise   | Aa West Elgin
032 |  8.04 |  167.76 |  167.76 |  167.87 | avis         | Oak Lawn/chicago
046 | 10.78 |  167.76 |  167.76 |  167.87 | avis         | Sears Auto-westfield Chicago Ridge Mall
071 | 16.46 |  167.76 |  167.76 |  167.87 | budget       | Evanston
107 | 21.15 |  167.76 |  167.76 |  167.87 | avis         | Sears Auto Ctr - Golf Mill Shopping Ctr
119 | 22.76 |  167.76 |  167.76 |  167.87 | avis         | Elk Grove Village, Il
084 | 18.35 |  167.76 |  167.76 |  167.87 | avis         | Skokie - Dempster Street
073 | 16.99 |  167.76 |  167.76 |  167.87 | avis         | Orland Park, Il
154 | 28.59 |  168.00 |  168.00 |  166.77 | budget       | Romeoville, Il Lewis Airport
180 | 32.83 |  168.00 |  168.00 |  166.77 | budget       | Joliet Il Sears
204 | 39.05 |  168.04 |  168.04 |  177.66 | enterprise   | Aa East Dundee
147 | 28.09 |  168.76 |  168.76 |  168.87 | avis         | Schaumburg Hyatt Regency Hotel
163 | 30.75 |  168.76 |  168.76 |  168.87 | avis         | Schaumburg/hoffman Estates
143 | 27.52 |  169.93 |  169.93 |  179.92 | enterprise   | Aa Rolling Meadows Nt
088 | 18.96 |  170.17 |  170.17 |  179.62 | enterprise   | Aa Holiday Inn
219 | 45.36 |  170.19 |  170.19 |  179.64 | enterprise   | Nn Zion
115 | 21.60 |  170.67 |  170.67 |  180.66 | enterprise   | Gg Gary
167 | 30.91 |  171.43 |  171.43 |  191.60 | enterprise   | Nn-napleton Dge Jeep Chr
135 | 26.13 |  171.43 |  171.43 |  191.60 | enterprise   | Nn-wheeling
142 | 27.34 |  171.46 |  171.46 |  181.54 | enterprise   | Nn-arlington Heights
069 | 16.04 |  171.48 |  171.48 |  181.56 | enterprise   | Nn Lincolnwood 53
087 | 18.86 |  171.48 |  171.48 |  181.56 | enterprise   | Morton Grove
076 | 17.54 |  171.48 |  171.48 |  181.56 | enterprise   | Nn Skokie
210 | 41.00 |  171.81 |  171.81 |  181.35 | enterprise   | Nn-waukegan
202 | 37.77 |  171.81 |  171.81 |  181.35 | enterprise   | Nn-north Chicago
165 | 30.76 |  172.46 |  172.46 |  182.54 | enterprise   | Aa Hoffman Estates
151 | 28.43 |  172.46 |  172.46 |  182.54 | enterprise   | Aa Roselle
156 | 28.87 |  172.46 |  172.46 |  182.54 | enterprise   | Aa Schaumburg
145 | 27.81 |  172.46 |  172.46 |  182.54 | enterprise   | Aa East Schaumburg
063 | 14.15 |  174.91 |  174.91 |  184.92 | enterprise   | Dd Elmwood Park
068 | 16.04 |  174.91 |  174.91 |  184.92 | enterprise   | Dd Stone Park
049 | 10.82 |  175.92 |  175.92 |  174.64 | avis         | Oak Park
199 | 37.33 |  175.96 |  175.96 |  186.04 | enterprise   | Aa Elgin
106 | 21.00 |  176.52 |  176.52 |  186.60 | enterprise   | Golf Mill Ford
125 | 23.87 |  176.52 |  176.52 |  186.60 | enterprise   | Nn-mount Prospect
104 | 20.79 |  176.52 |  176.52 |  186.60 | enterprise   | Nn Des Plaines 1505
101 | 20.19 |  176.52 |  176.52 |  186.60 | enterprise   | Nn-park Ridge
179 | 32.83 |  177.22 |  177.22 |  174.68 | avis         | Sears Auto Center - Louis Joliet Mall
153 | 28.59 |  177.22 |  177.22 |  174.68 | avis         | Lewis University Airport
070 | 16.46 |  177.51 |  177.51 |  176.21 | avis         | Evanston (525 Kedzie Building)
176 | 32.22 |  177.54 |  177.54 |  188.04 | enterprise   | Aa South Naperville
184 | 35.69 |  177.54 |  177.54 |  188.04 | enterprise   | Aa Plainfield
187 | 35.82 |  177.54 |  177.54 |  188.04 | enterprise   | Aa Shorewood
136 | 26.20 |  177.54 |  177.54 |  188.04 | enterprise   | Aa Lockport
178 | 32.46 |  177.54 |  177.54 |  188.04 | enterprise   | Aa North Plainfield
162 | 30.52 |  177.55 |  177.55 |  187.72 | enterprise   | Aa Hanover Park
183 | 33.53 |  179.23 |  179.23 |  189.83 | enterprise   | Aa Joliet
177 | 32.26 |  179.23 |  179.23 |  189.83 | enterprise   | Aa Crest Hill
051 | 10.97 |  179.90 |  179.90 |  189.89 | enterprise   | Dd Oak Park
038 |  9.33 |  179.92 |  179.92 |  189.91 | enterprise   | Gg Berwyn
054 | 11.71 |  181.54 |  181.54 |  191.62 | enterprise   | Gg Forest Park
031 |  7.94 |  184.00 |  184.00 |  184.10 | budget       | Chicago Grossinger Autoplex
043 | 10.15 |  184.00 |  184.00 |  184.10 | budget       | Logan Square Chicago Il
089 | 18.96 |  186.20 |  186.20 |  196.28 | enterprise   | Nn North Evanston
067 | 15.24 |  188.01 |  188.01 |  198.90 | enterprise   | Nn Norwood Park C1
078 | 17.76 |  190.68 |  190.68 |  200.76 | enterprise   | Nn South Evanston N2
003 |  4.05 |  194.52 |  194.52 |  193.12 | avis         | Chicago - 18th Street & Wabash Avenue
030 |  7.94 |  194.52 |  194.52 |  193.12 | avis         | Grossinger City Autoplex
042 | 10.15 |  194.52 |  194.52 |  193.12 | avis         | Logan Square
010 |  5.71 |  194.52 |  194.52 |  193.12 | avis         | Chicago Union Train Station
045 | 10.56 |  194.52 |  194.52 |  193.12 | avis         | Lakeview/chicago
009 |  5.57 |  198.88 |  198.88 |  209.77 | enterprise   | Gg Gresham
008 |  5.17 |  198.88 |  198.88 |  209.77 | enterprise   | Gg Stony Island
034 |  8.08 |  198.90 |  198.90 |  209.79 | enterprise   | Euro Collission
011 |  5.71 |  202.12 |  202.12 |  202.24 | budget       | Chicago Union Train Station
044 | 10.55 |  203.48 |  203.48 |  211.17 | budget       | Chicago/lakeview
004 |  4.05 |  203.48 |  203.48 |  211.17 | budget       | Chicago
007 |  5.11 |  203.48 |  203.48 |  211.17 | budget       | Chicago
059 | 13.31 |  206.08 |  206.08 |  216.97 | enterprise   | Nn Irving Park
056 | 11.92 |  206.08 |  206.08 |  216.97 | enterprise   | Nn Cragin
048 | 10.78 |  206.08 |  206.08 |  216.97 | enterprise   | Nn Gerber Logan Square
026 |  7.54 |  207.32 |  207.32 |  219.43 | enterprise   | Dd Gold Coast Auto Body
029 |  7.87 |  207.32 |  207.32 |  219.43 | enterprise   | Dd Old Town
057 | 12.59 |  207.32 |  207.32 |  219.43 | enterprise   | Nn Uptown
041 |  9.61 |  207.32 |  207.32 |  219.43 | enterprise   | Nn Lincoln Park
037 |  8.91 |  207.32 |  207.32 |  219.43 | enterprise   | Dd Bucktown
223 | 46.50 |  207.99 |  207.99 |  217.44 | enterprise   | Gg Kankakee
013 |  5.84 |  208.69 |  208.69 |  219.58 | enterprise   | Dd West Loop A/b(ex15ca)
014 |  5.93 |  208.69 |  208.69 |  219.58 | enterprise   | Union Station/pres Tower
021 |  6.17 |  208.69 |  208.69 |  220.13 | enterprise   | Gg Western And Roosevelt
002 |  3.17 |  208.69 |  208.69 |  220.13 | enterprise   | Gg South Loop
012 |  5.82 |  208.69 |  208.69 |  219.58 | enterprise   | Chicago Loop
190 | 36.52 |  210.63 |  210.63 |  220.62 | enterprise   | Gg Valparaiso
126 | 24.13 |  210.63 |  210.63 |  220.62 | enterprise   | Gg Hobart
065 | 14.69 |  215.63 |  215.63 |  225.62 | enterprise   | Gg Hammond
001 |  0.95 |  217.40 |  217.40 |  228.84 | enterprise   | Gg Hyde Park
149 | 28.25 |  218.63 |  218.63 |  228.62 | enterprise   | Gg Portage
155 | 28.80 |  218.63 |  218.63 |  228.62 | enterprise   | Gg Arnell
039 |  9.47 |  219.88 |  219.88 |  229.87 | enterprise   | Gg Blue Island
122 | 23.02 |  222.18 |  222.18 |  233.99 | enterprise   | Gg Steger
064 | 14.33 |  224.88 |  224.88 |  234.87 | enterprise   | Gg Calumet City
075 | 17.26 |  226.91 |  226.91 |  236.99 | enterprise   | Gg Homewood
080 | 18.03 |  226.91 |  226.91 |  236.99 | enterprise   | Gg Lansing
061 | 13.76 |  226.91 |  226.91 |  236.99 | enterprise   | Gg South Holland
018 |  6.07 |  229.67 |  229.67 |  241.49 | alamo        | Chicago N Lasalle
226 | 48.38 |  230.61 |  230.61 |  240.60 | enterprise   | Gg Laporte
205 | 39.53 |  230.61 |  230.61 |  240.60 | enterprise   | Gg Michigan City
058 | 12.70 |  235.86 |  235.86 |  245.85 | enterprise   | Gg Brookfield
117 | 21.92 |  237.00 |  237.00 |  249.59 | enterprise   | Gg Miller Automall
111 | 21.35 |  237.00 |  237.00 |  249.59 | enterprise   | Gg Matteson
062 | 13.81 |  238.78 |  238.78 |  249.64 | enterprise   | Napleton Chrysler
055 | 11.85 |  238.78 |  238.78 |  249.64 | enterprise   | Nn Riverview
019 |  6.09 |  239.83 |  239.83 |  248.57 | enterprise   | Lake And Franklin
023 |  6.86 |  239.83 |  239.83 |  248.57 | enterprise   | Gold Coast
022 |  6.43 |  239.83 |  239.83 |  248.57 | enterprise   | Chicago Magnificent Mile
015 |  5.93 |  239.83 |  239.83 |  248.57 | enterprise   | Millennium Park
138 | 26.83 |  245.79 |  245.79 |  255.24 | enterprise   | Gg New Lenox
118 | 22.13 |  248.13 |  248.13 |  257.67 | enterprise   | Gg Frankfort And Mokena
053 | 11.20 |  262.18 |  262.18 |  272.26 | enterprise   | Gg Crestwood
072 | 16.75 |  262.18 |  262.18 |  272.26 | enterprise   | Gg Orland Park East
035 |  8.70 |  262.18 |  262.18 |  272.26 | enterprise   | Gg Oak Lawn
052 | 11.09 |  262.18 |  262.18 |  272.26 | enterprise   | Gg Bridgeview
083 | 18.12 |  264.93 |  264.93 |  275.01 | enterprise   | Gg Orland West
020 |  6.13 |  286.00 |  286.00 |  296.89 | enterprise   | Gg Archer Heights
005 |  4.19 |  286.00 |  286.00 |  296.89 | enterprise   | Gg South Western
092 | 19.06 |  294.57 |  294.57 |  297.68 | alamo        | Chicago Ohare Airport
028 |  7.60 |  376.87 |  376.87 |  340.20 | alamo        | Midway Intl Arpt
027 |  7.60 |  417.95 |  417.95 |  418.66 | enterprise   | Midway Intl Arpt
091 | 19.01 |  444.92 |  444.92 |  451.71 | budget       | Ohare Intl Airport
098 | 19.79 |  454.66 |  454.66 |  453.19 | enterprise   | Ohare Intl Arpt
090 | 19.01 |  489.93 |  489.93 |  504.83 | avis         | Chicago Ohare Intl Airport
024 |  7.54 |  492.96 |  492.96 |  470.10 | avis         | Chicago Midway Intl Airport


    

In [ ]:

    

"""
10/19/2017 10:00 AM 11/16/2017 10:00 AM Compact Car Compact Car Intermediate Car
176 | 32.22 |  491.82 |  491.82 |  538.13 | enterprise   | Aa South Naperville
178 | 32.46 |  491.82 |  491.82 |  538.13 | enterprise   | Aa North Plainfield
136 | 26.20 |  491.82 |  491.82 |  538.13 | enterprise   | Aa Lockport
184 | 35.69 |  491.82 |  491.82 |  538.13 | enterprise   | Aa Plainfield
187 | 35.82 |  491.82 |  491.82 |  538.13 | enterprise   | Aa Shorewood
141 | 27.09 |  496.50 |  496.50 |  543.26 | enterprise   | Aa East Naperville
166 | 30.85 |  496.50 |  496.50 |  543.26 | enterprise   | Aa Warrenville
130 | 24.83 |  496.50 |  496.50 |  543.26 | enterprise   | Aa Lisle
175 | 31.67 |  496.50 |  496.50 |  543.26 | enterprise   | Aa East Aurora
177 | 32.26 |  496.50 |  496.50 |  543.26 | enterprise   | Aa Crest Hill
170 | 31.04 |  496.50 |  496.50 |  543.26 | enterprise   | Aa Naperville North
183 | 33.53 |  496.50 |  496.50 |  543.26 | enterprise   | Aa Joliet
161 | 30.14 |  496.50 |  496.50 |  543.26 | enterprise   | Aa West Ogden
129 | 24.81 |  499.25 |  499.25 |  546.01 | enterprise   | Aa Bolingbrook
208 | 40.85 |  507.24 |  507.24 |  541.20 | enterprise   | Aa West Elgin
204 | 39.05 |  512.07 |  512.07 |  546.35 | enterprise   | Aa East Dundee
215 | 44.16 |  519.71 |  519.71 |  548.94 | budget       | Gurnee Il Sears
222 | 46.33 |  524.66 |  524.66 |  554.17 | budget       | Crystal Lake Il
158 | 29.21 |  524.66 |  524.66 |  554.17 | budget       | Highland Park
198 | 37.18 |  524.66 |  524.66 |  554.17 | budget       | Lake Zurich Il
200 | 37.57 |  524.66 |  524.66 |  554.17 | budget       | Libertyville
207 | 39.56 |  524.66 |  524.66 |  554.17 | budget       | Libertyville Il
199 | 37.33 |  536.23 |  536.23 |  572.13 | enterprise   | Aa Elgin
214 | 44.16 |  537.98 |  537.98 |  561.96 | avis         | Sears Auto Center - Gurnee Mills Mall
162 | 30.52 |  541.06 |  541.06 |  577.28 | enterprise   | Aa Hanover Park
157 | 29.21 |  543.10 |  543.10 |  567.31 | avis         | Highland Park Ford
201 | 37.57 |  543.10 |  543.10 |  567.31 | avis         | Libertyville - Milwaukee Avenue
197 | 37.18 |  543.10 |  543.10 |  567.31 | avis         | Lake Zurich-village Square Auto Center
206 | 39.56 |  543.10 |  543.10 |  567.31 | avis         | Libertyville - Peterson Road
221 | 46.33 |  543.10 |  543.10 |  567.31 | avis         | Crystal Lake, Il
132 | 25.02 |  554.36 |  554.36 |  585.54 | budget       | Northbrook
128 | 24.53 |  562.35 |  562.35 |  597.29 | enterprise   | Aa Glen Ellyn
192 | 36.83 |  567.81 |  567.81 |  603.11 | enterprise   | Aa East St. Charles
191 | 36.65 |  567.81 |  567.81 |  603.11 | enterprise   | Aa Aurora
203 | 38.45 |  567.81 |  567.81 |  603.11 | enterprise   | Aa St Charles
131 | 25.02 |  573.84 |  573.84 |  599.42 | avis         | Renaissance Chicago North Shore
081 | 18.03 |  574.51 |  574.51 |  587.53 | avis         | Oak Brook Doubletree Hotel
103 | 20.30 |  574.51 |  574.51 |  592.78 | budget       | Lombard
082 | 18.03 |  574.51 |  574.51 |  592.78 | budget       | Oak Brook Il
102 | 20.30 |  574.51 |  574.51 |  587.53 | avis         | Lombard
123 | 23.57 |  579.98 |  579.98 |  598.42 | budget       | Addison
124 | 23.70 |  579.98 |  579.98 |  593.12 | avis         | Addison
113 | 21.35 |  579.99 |  579.99 |  616.88 | budget       | Downers Grove Il
172 | 31.24 |  579.99 |  579.99 |  616.88 | budget       | Aurora Il Sears
169 | 30.94 |  579.99 |  579.99 |  616.88 | budget       | Naperville Il
139 | 27.01 |  579.99 |  579.99 |  616.88 | budget       | Naperville
194 | 36.89 |  579.99 |  579.99 |  616.88 | budget       | Aurora
150 | 28.39 |  591.90 |  591.90 |  610.98 | enterprise   | Nn-highland Park
225 | 47.30 |  597.04 |  597.04 |  615.94 | enterprise   | Nn-round Lake Heights
217 | 44.78 |  597.04 |  597.04 |  615.94 | enterprise   | Nn-gurnee
213 | 44.03 |  597.04 |  597.04 |  615.94 | enterprise   | Nn-lake Villa
189 | 36.51 |  597.07 |  597.07 |  615.97 | enterprise   | Nn-mundelein
195 | 37.14 |  602.76 |  602.76 |  621.84 | enterprise   | Nn-libertyville
226 | 48.38 |  602.80 |  602.80 |  632.77 | enterprise   | Gg Laporte
205 | 39.53 |  602.80 |  602.80 |  632.77 | enterprise   | Gg Michigan City
100 | 20.15 |  603.11 |  603.11 |  622.19 | enterprise   | Aa W Grand Ave
105 | 20.90 |  603.11 |  603.11 |  622.19 | enterprise   | Aa Villa Park
099 | 19.86 |  603.11 |  603.11 |  622.19 | enterprise   | Aa Lombard
094 | 19.34 |  603.11 |  603.11 |  622.19 | enterprise   | Aa Elmhurst
086 | 18.57 |  605.21 |  605.21 |  641.12 | enterprise   | Aa Willowbrook
122 | 23.02 |  605.21 |  605.21 |  633.56 | enterprise   | Gg Steger
138 | 26.83 |  605.21 |  605.21 |  633.56 | enterprise   | Gg New Lenox
193 | 36.89 |  605.81 |  605.81 |  637.40 | avis         | Aurora
171 | 31.24 |  605.81 |  605.81 |  637.40 | avis         | Sears Auto Ctr-westfield Fox Valley Mall
127 | 24.42 |  605.81 |  605.81 |  637.40 | avis         | The Hyatt Of Lisle
112 | 21.35 |  605.81 |  605.81 |  637.40 | avis         | Downers Grove, Il
168 | 30.94 |  605.81 |  605.81 |  637.40 | avis         | Naperville - Pebblewood Plaza
140 | 27.04 |  605.81 |  605.81 |  637.40 | avis         | Naperville, Il
185 | 35.80 |  607.66 |  607.66 |  620.80 | avis         | Foxfield Commons Shopping Plaza
186 | 35.80 |  607.66 |  607.66 |  626.10 | budget       | St.charles
051 | 10.97 |  607.84 |  607.84 |  644.80 | enterprise   | Dd Oak Park
089 | 18.96 |  609.71 |  609.71 |  647.01 | enterprise   | Nn North Evanston
078 | 17.76 |  609.71 |  609.71 |  647.01 | enterprise   | Nn South Evanston N2
093 | 19.16 |  610.97 |  610.97 |  647.23 | enterprise   | Aa Westmont
118 | 22.13 |  610.97 |  610.97 |  639.59 | enterprise   | Gg Frankfort And Mokena
114 | 21.41 |  610.97 |  610.97 |  647.23 | enterprise   | Aa North Downers Grove
110 | 21.31 |  610.97 |  610.97 |  647.23 | enterprise   | Aa South Downers Grove
143 | 27.52 |  614.83 |  614.83 |  644.80 | enterprise   | Aa Rolling Meadows Nt
142 | 27.34 |  620.37 |  620.37 |  650.61 | enterprise   | Nn-arlington Heights
165 | 30.76 |  621.37 |  621.37 |  651.61 | enterprise   | Aa Hoffman Estates
156 | 28.87 |  621.37 |  621.37 |  651.61 | enterprise   | Aa Schaumburg
151 | 28.43 |  621.37 |  621.37 |  651.61 | enterprise   | Aa Roselle
145 | 27.81 |  621.37 |  621.37 |  651.61 | enterprise   | Aa East Schaumburg
069 | 16.04 |  623.40 |  623.40 |  660.69 | enterprise   | Nn Lincolnwood 53
087 | 18.86 |  623.40 |  623.40 |  660.69 | enterprise   | Morton Grove
076 | 17.54 |  623.40 |  623.40 |  660.69 | enterprise   | Nn Skokie
121 | 22.80 |  624.82 |  624.82 |  644.80 | enterprise   | Nn-glenview
218 | 44.78 |  628.85 |  628.85 |  647.75 | enterprise   | Aa -algonquin
209 | 40.91 |  628.85 |  628.85 |  647.75 | enterprise   | Aa Casten's Body Shop
133 | 26.05 |  630.07 |  630.07 |  668.69 | avis         | Merrillville Car Care Center
223 | 46.50 |  633.57 |  633.57 |  643.02 | enterprise   | Gg Kankakee
196 | 37.15 |  634.84 |  634.84 |  653.92 | enterprise   | Aa Barrington
220 | 45.36 |  634.84 |  634.84 |  653.92 | enterprise   | Aa Crystal Lake West
224 | 47.08 |  634.84 |  634.84 |  653.92 | enterprise   | Aa -crystal Lake 2
211 | 41.03 |  636.32 |  636.32 |  650.08 | avis         | Sears Auto Center-spring Hill Mall
050 | 10.82 |  636.32 |  636.32 |  655.63 | budget       | Oak Park
212 | 41.03 |  636.32 |  636.32 |  655.63 | budget       | West Dundee Sears
049 | 10.82 |  636.32 |  636.32 |  650.08 | avis         | Oak Park
174 | 31.61 |  636.32 |  636.32 |  655.63 | budget       | Streamwood Il
173 | 31.61 |  636.32 |  636.32 |  650.08 | avis         | Streamwood, Il
038 |  9.33 |  639.79 |  639.79 |  669.76 | enterprise   | Gg Berwyn
039 |  9.47 |  639.79 |  639.79 |  669.76 | enterprise   | Gg Blue Island
058 | 12.70 |  639.79 |  639.79 |  669.76 | enterprise   | Gg Brookfield
071 | 16.46 |  642.05 |  642.05 |  661.54 | budget       | Evanston
084 | 18.35 |  642.05 |  642.05 |  655.94 | avis         | Skokie - Dempster Street
107 | 21.15 |  642.05 |  642.05 |  655.94 | avis         | Sears Auto Ctr - Golf Mill Shopping Ctr
120 | 22.76 |  642.05 |  642.05 |  661.54 | budget       | Elk Grove Village Il
119 | 22.76 |  642.05 |  642.05 |  655.94 | avis         | Elk Grove Village, Il
085 | 18.35 |  642.05 |  642.05 |  661.54 | budget       | Skokie
066 | 15.03 |  642.05 |  642.05 |  661.54 | budget       | Lincolnwood
108 | 21.15 |  642.05 |  642.05 |  661.54 | budget       | Niles Il Sears
070 | 16.46 |  642.05 |  642.05 |  655.94 | avis         | Evanston (525 Kedzie Building)
097 | 19.55 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Griffith
096 | 19.43 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Highland
065 | 14.69 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Hammond
190 | 36.52 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Valparaiso
159 | 29.60 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Crown Point Indiana
160 | 30.13 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Cedar Lake
137 | 26.33 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Merrillville
116 | 21.81 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Schererville
152 | 28.45 |  642.78 |  642.78 |  682.74 | enterprise   | Gg East Merrillville
126 | 24.13 |  642.78 |  642.78 |  682.74 | enterprise   | Gg Hobart
164 | 30.75 |  643.05 |  643.05 |  662.54 | budget       | Schaumburg
163 | 30.75 |  643.05 |  643.05 |  656.94 | avis         | Schaumburg/hoffman Estates
147 | 28.09 |  643.05 |  643.05 |  656.94 | avis         | Schaumburg Hyatt Regency Hotel
148 | 28.09 |  643.05 |  643.05 |  662.54 | budget       | Hyatt Woodfield
053 | 11.20 |  645.55 |  645.55 |  675.79 | enterprise   | Gg Crestwood
125 | 23.87 |  645.55 |  645.55 |  675.79 | enterprise   | Nn-mount Prospect
072 | 16.75 |  645.55 |  645.55 |  675.79 | enterprise   | Gg Orland Park East
054 | 11.71 |  645.55 |  645.55 |  675.79 | enterprise   | Gg Forest Park
111 | 21.35 |  645.55 |  645.55 |  675.79 | enterprise   | Gg Matteson
106 | 21.00 |  645.55 |  645.55 |  675.79 | enterprise   | Golf Mill Ford
101 | 20.19 |  645.55 |  645.55 |  675.79 | enterprise   | Nn-park Ridge
117 | 21.92 |  645.55 |  645.55 |  675.79 | enterprise   | Gg Miller Automall
060 | 13.64 |  645.55 |  645.55 |  683.87 | enterprise   | Aa Lagrange
104 | 20.79 |  645.55 |  645.55 |  675.79 | enterprise   | Nn Des Plaines 1505
153 | 28.59 |  646.87 |  646.87 |  692.05 | avis         | Lewis University Airport
180 | 32.83 |  646.87 |  646.87 |  692.05 | budget       | Joliet Il Sears
179 | 32.83 |  646.87 |  646.87 |  692.05 | avis         | Sears Auto Center - Louis Joliet Mall
154 | 28.59 |  646.87 |  646.87 |  692.05 | budget       | Romeoville, Il Lewis Airport
134 | 26.05 |  646.94 |  646.94 |  630.07 | budget       | Merrillville
083 | 18.12 |  648.30 |  648.30 |  678.54 | enterprise   | Gg Orland West
219 | 45.36 |  652.47 |  652.47 |  727.13 | enterprise   | Nn Zion
188 | 36.35 |  652.47 |  652.47 |  727.13 | enterprise   | Aa Oswego
146 | 27.93 |  652.47 |  652.47 |  727.13 | enterprise   | Nn-hyatt-deerfield
046 | 10.78 |  654.26 |  654.26 |  693.24 | avis         | Sears Auto-westfield Chicago Ridge Mall
073 | 16.99 |  654.26 |  654.26 |  693.24 | avis         | Orland Park, Il
032 |  8.04 |  654.26 |  654.26 |  693.24 | avis         | Oak Lawn/chicago
202 | 37.77 |  658.68 |  658.68 |  734.06 | enterprise   | Nn-north Chicago
210 | 41.00 |  658.68 |  658.68 |  734.06 | enterprise   | Nn-waukegan
216 | 44.52 |  658.68 |  658.68 |  734.06 | enterprise   | Aa Yorkville
013 |  5.84 |  659.91 |  659.91 |  700.19 | enterprise   | Dd West Loop A/b(ex15ca)
012 |  5.82 |  659.91 |  659.91 |  700.19 | enterprise   | Chicago Loop
014 |  5.93 |  659.91 |  659.91 |  700.19 | enterprise   | Union Station/pres Tower
063 | 14.15 |  664.76 |  664.76 |  674.72 | enterprise   | Dd Elmwood Park
068 | 16.04 |  664.76 |  664.76 |  674.72 | enterprise   | Dd Stone Park
048 | 10.78 |  666.35 |  666.35 |  719.10 | enterprise   | Nn Gerber Logan Square
056 | 11.92 |  666.35 |  666.35 |  719.10 | enterprise   | Nn Cragin
059 | 13.31 |  666.35 |  666.35 |  719.10 | enterprise   | Nn Irving Park
155 | 28.80 |  667.75 |  667.75 |  707.71 | enterprise   | Gg Arnell
149 | 28.25 |  667.75 |  667.75 |  707.71 | enterprise   | Gg Portage
181 | 32.84 |  670.77 |  670.77 |  690.93 | enterprise   | Aa Palatine
041 |  9.61 |  670.78 |  670.78 |  711.07 | enterprise   | Nn Lincoln Park
057 | 12.59 |  670.78 |  670.78 |  711.07 | enterprise   | Nn Uptown
037 |  8.91 |  670.78 |  670.78 |  711.07 | enterprise   | Dd Bucktown
026 |  7.54 |  670.78 |  670.78 |  711.07 | enterprise   | Dd Gold Coast Auto Body
029 |  7.87 |  670.78 |  670.78 |  711.07 | enterprise   | Dd Old Town
022 |  6.43 |  670.80 |  670.80 |  711.08 | enterprise   | Chicago Magnificent Mile
019 |  6.09 |  670.80 |  670.80 |  711.08 | enterprise   | Lake And Franklin
023 |  6.86 |  670.80 |  670.80 |  711.08 | enterprise   | Gold Coast
015 |  5.93 |  670.80 |  670.80 |  711.08 | enterprise   | Millennium Park
047 | 10.78 |  671.28 |  671.28 |  654.26 | budget       | Chicago Ridge Il Sears
074 | 16.99 |  671.28 |  671.28 |  654.26 | budget       | Orland Park
033 |  8.04 |  671.28 |  671.28 |  654.26 | budget       | Oak Lawn
067 | 15.24 |  676.24 |  676.24 |  716.53 | enterprise   | Nn Norwood Park C1
055 | 11.85 |  678.85 |  678.85 |  719.10 | enterprise   | Nn Riverview
062 | 13.81 |  678.85 |  678.85 |  719.10 | enterprise   | Napleton Chrysler
064 | 14.33 |  679.76 |  679.76 |  719.72 | enterprise   | Gg Calumet City
088 | 18.96 |  680.81 |  680.81 |  690.26 | enterprise   | Aa Holiday Inn
115 | 21.60 |  682.72 |  682.72 |  692.71 | enterprise   | Gg Gary
035 |  8.70 |  685.88 |  685.88 |  735.29 | enterprise   | Gg Oak Lawn
052 | 11.09 |  685.88 |  685.88 |  735.29 | enterprise   | Gg Bridgeview
080 | 18.03 |  685.88 |  685.88 |  726.20 | enterprise   | Gg Lansing
135 | 26.13 |  695.96 |  695.96 |  775.61 | enterprise   | Nn-wheeling
167 | 30.91 |  695.96 |  695.96 |  775.61 | enterprise   | Nn-napleton Dge Jeep Chr
044 | 10.55 |  696.39 |  696.39 |  717.45 | budget       | Chicago/lakeview
030 |  7.94 |  696.39 |  696.39 |  711.40 | avis         | Grossinger City Autoplex
010 |  5.71 |  696.39 |  696.39 |  711.40 | avis         | Chicago Union Train Station
043 | 10.15 |  696.39 |  696.39 |  717.45 | budget       | Logan Square Chicago Il
003 |  4.05 |  696.39 |  696.39 |  711.40 | avis         | Chicago - 18th Street & Wabash Avenue
004 |  4.05 |  696.39 |  696.39 |  717.45 | budget       | Chicago
031 |  7.94 |  696.39 |  696.39 |  717.45 | budget       | Chicago Grossinger Autoplex
042 | 10.15 |  696.39 |  696.39 |  711.40 | avis         | Logan Square
045 | 10.56 |  696.39 |  696.39 |  711.40 | avis         | Lakeview/chicago
007 |  5.11 |  696.39 |  696.39 |  717.45 | budget       | Chicago
001 |  0.95 |  700.18 |  700.18 |  732.85 | enterprise   | Gg Hyde Park
002 |  3.17 |  700.18 |  700.18 |  732.85 | enterprise   | Gg South Loop
034 |  8.08 |  700.18 |  700.18 |  732.85 | enterprise   | Euro Collission
021 |  6.17 |  700.18 |  700.18 |  732.85 | enterprise   | Gg Western And Roosevelt
020 |  6.13 |  700.18 |  700.18 |  732.85 | enterprise   | Gg Archer Heights
005 |  4.19 |  700.18 |  700.18 |  732.85 | enterprise   | Gg South Western
008 |  5.17 |  700.18 |  700.18 |  732.85 | enterprise   | Gg Stony Island
009 |  5.57 |  700.18 |  700.18 |  732.85 | enterprise   | Gg Gresham
018 |  6.07 |  702.84 |  702.84 |  744.48 | alamo        | Chicago N Lasalle
144 | 27.68 |  734.99 |  734.99 |  801.77 | enterprise   | Aa Carol Stream
011 |  5.71 |  765.76 |  765.76 |  788.92 | budget       | Chicago Union Train Station
077 | 17.63 |  777.54 |  777.54 |  848.10 | enterprise   | Schiller Park
061 | 13.76 |  814.17 |  814.17 |  863.55 | enterprise   | Gg South Holland
075 | 17.26 |  814.17 |  814.17 |  863.55 | enterprise   | Gg Homewood
028 |  7.60 | 1015.96 | 1015.96 | 1028.65 | alamo        | Midway Intl Arpt
027 |  7.60 | 1057.20 | 1057.20 | 1111.65 | enterprise   | Midway Intl Arpt
091 | 19.01 | 1064.68 | 1064.68 |  994.50 | budget       | Ohare Intl Airport
092 | 19.06 | 1092.34 | 1092.34 | 1119.57 | alamo        | Chicago Ohare Airport
024 |  7.54 | 1166.74 | 1166.74 | 1219.38 | avis         | Chicago Midway Intl Airport
098 | 19.79 | 1192.73 | 1192.73 | 1128.64 | enterprise   | Ohare Intl Arpt
090 | 19.01 | 1240.10 | 1240.10 | 1456.47 | avis         | Chicago Ohare Intl Airport


    

In [ ]:

    

"""
09/11/2017 11:00 AM 10/02/2017 11:00 AM Economy Car Compact Car Intermediate Car
124 | 21.02 |  354.57 |  354.66 |  402.57 | enterprise   | Nn-hyatt-deerfield
220 | 39.00 |  354.61 |  354.69 |  385.88 | enterprise   | Nn Zion
103 | 17.63 |  354.61 |  354.69 |  482.55 | enterprise   | Aa Willowbrook
097 | 15.71 |  358.07 |  358.07 |  487.15 | enterprise   | Aa Westmont
182 | 31.08 |  357.99 |  358.07 |  389.56 | enterprise   | Nn-north Chicago
112 | 19.00 |  358.07 |  358.07 |  487.15 | enterprise   | Aa South Downers Grove
130 | 21.68 |  357.99 |  358.07 |  397.00 | enterprise   | Nn-highland Park
203 | 34.40 |  357.99 |  358.07 |  389.56 | enterprise   | Nn-waukegan
106 | 17.87 |  357.99 |  358.07 |  487.15 | enterprise   | Aa North Downers Grove
116 | 19.98 |  360.16 |  360.22 |  495.73 | enterprise   | Aa Glen Ellyn
211 | 35.87 |  359.54 |  360.33 |  429.59 | enterprise   | Aa Shorewood
156 | 26.51 |  359.54 |  360.33 |  429.59 | enterprise   | Aa Lockport
209 | 35.41 |  363.65 |  363.73 |  504.41 | enterprise   | Aa Plainfield
181 | 30.80 |  363.65 |  363.73 |  504.41 | enterprise   | Aa North Plainfield
174 | 30.23 |  363.65 |  363.73 |  504.41 | enterprise   | Aa South Naperville
202 | 33.95 |  362.96 |  363.76 |  433.68 | enterprise   | Aa Joliet
185 | 31.77 |  363.67 |  363.76 |  395.24 | enterprise   | Aa East St. Charles
198 | 33.57 |  363.67 |  363.76 |  395.24 | enterprise   | Aa St Charles
140 | 23.64 |  362.96 |  363.76 |  496.38 | enterprise   | Aa East Naperville
169 | 28.66 |  363.67 |  363.76 |  504.43 | enterprise   | Aa East Aurora
161 | 27.62 |  363.67 |  363.76 |  504.43 | enterprise   | Aa Naperville North
126 | 21.31 |  362.96 |  363.76 |  496.38 | enterprise   | Aa Lisle
158 | 27.03 |  363.67 |  363.76 |  504.43 | enterprise   | Aa West Ogden
194 | 33.16 |  363.67 |  363.76 |  395.24 | enterprise   | Aa Aurora
186 | 32.09 |  362.96 |  363.76 |  433.68 | enterprise   | Aa Crest Hill
157 | 26.80 |  363.67 |  363.76 |  504.43 | enterprise   | Aa Warrenville
214 | 37.16 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-lake Villa
224 | 40.33 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-round Lake Heights
217 | 37.97 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-gurnee
171 | 29.52 |  365.60 |  365.69 |  404.25 | enterprise   | Nn-mundelein
200 | 33.92 |  368.78 |  368.87 |  416.78 | enterprise   | Aa Casten's Body Shop
229 | 44.92 |  369.00 |  369.08 |  408.01 | enterprise   | Nn-antioch
175 | 30.23 |  369.08 |  369.17 |  408.10 | enterprise   | Nn-libertyville
176 | 30.28 |  372.29 |  372.38 |  420.75 | enterprise   | Aa Barrington
113 | 19.14 |  378.21 |  378.31 |  429.40 | enterprise   | Nn-wheeling
141 | 23.92 |  378.21 |  378.31 |  429.40 | enterprise   | Nn-napleton Dge Jeep Chr
065 | 11.28 |  378.34 |  378.34 |  514.72 | enterprise   | Aa Lagrange
206 | 34.98 |  381.31 |  381.39 |  456.15 | enterprise   | Aa West Elgin
215 | 37.38 |  383.22 |  383.22 |  405.14 | budget       | Gurnee Il Sears
189 | 32.65 |  384.94 |  385.02 |  460.49 | enterprise   | Aa East Dundee
172 | 30.23 |  386.87 |  386.87 |  409.00 | budget       | Lake Zurich Il
221 | 39.53 |  386.87 |  386.87 |  409.00 | budget       | Crystal Lake Il
190 | 32.67 |  386.87 |  386.87 |  409.00 | budget       | Libertyville Il
177 | 30.67 |  386.87 |  386.87 |  409.00 | budget       | Libertyville
134 | 22.51 |  386.87 |  386.87 |  409.00 | budget       | Highland Park
151 | 25.86 |  393.36 |  393.46 |  444.57 | enterprise   | Aa Palatine
030 |  4.67 |  395.85 |  395.94 |  407.93 | enterprise   | Dd Oak Park
092 | 14.63 |  397.22 |  397.22 |  525.07 | enterprise   | Aa Holiday Inn
184 | 31.23 |  403.10 |  403.18 |  482.22 | enterprise   | Aa Elgin
146 | 24.36 |  406.73 |  406.81 |  486.56 | enterprise   | Aa Hanover Park
109 | 18.35 |  408.77 |  408.77 |  432.15 | budget       | Northbrook
216 | 37.38 |  410.62 |  410.62 |  427.30 | avis         | Sears Auto Center - Gurnee Mills Mall
218 | 38.25 |  411.31 |  411.39 |  434.07 | enterprise   | Aa -algonquin
226 | 42.99 |  411.31 |  411.39 |  434.07 | enterprise   | Aa-huntley
003 |  2.34 |  411.35 |  411.46 |  447.38 | enterprise   | Dd Bucktown
005 |  2.38 |  411.35 |  411.46 |  447.38 | enterprise   | Dd Gold Coast Auto Body
047 |  6.96 |  411.35 |  411.46 |  447.38 | enterprise   | Nn Uptown
028 |  4.07 |  411.35 |  411.46 |  447.38 | enterprise   | Nn Lincoln Park
018 |  3.11 |  411.35 |  411.46 |  447.38 | enterprise   | Dd Old Town
009 |  2.68 |  411.49 |  411.49 |  447.44 | enterprise   | Euro Collission
135 | 22.51 |  414.53 |  414.53 |  431.37 | avis         | Highland Park Ford
222 | 39.53 |  414.53 |  414.53 |  431.37 | avis         | Crystal Lake, Il
178 | 30.67 |  414.53 |  414.53 |  431.37 | avis         | Libertyville - Milwaukee Avenue
191 | 32.67 |  414.53 |  414.53 |  431.37 | avis         | Libertyville - Peterson Road
173 | 30.23 |  414.53 |  414.53 |  431.37 | avis         | Lake Zurich-village Square Auto Center
219 | 38.54 |  412.45 |  415.31 |  438.20 | enterprise   | Aa Crystal Lake West
223 | 40.21 |  412.45 |  415.31 |  438.20 | enterprise   | Aa -crystal Lake 2
098 | 15.99 |  419.82 |  419.92 |  443.89 | enterprise   | Nn-glenview
110 | 18.35 |  438.00 |  438.00 |  455.78 | avis         | Renaissance Chicago North Shore
199 | 33.67 |  453.75 |  453.83 |  499.22 | enterprise   | Aa Oswego
227 | 43.35 |  453.83 |  453.83 |  499.22 | enterprise   | Aa Mchenry
225 | 42.12 |  458.07 |  458.15 |  503.97 | enterprise   | Aa Yorkville
213 | 36.65 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Cedar Lake
212 | 36.54 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Crown Point Indiana
210 | 35.46 |  484.81 |  484.91 |  485.02 | enterprise   | Gg East Merrillville
155 | 26.48 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Griffith
153 | 26.22 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Highland
166 | 28.53 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Schererville
197 | 33.29 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Merrillville
063 | 10.85 |  485.09 |  485.09 |  533.47 | enterprise   | Schiller Park
019 |  3.16 |  460.45 |  493.12 |  525.79 | enterprise   | Chicago Magnificent Mile
017 |  3.08 |  460.45 |  493.12 |  525.79 | enterprise   | Millennium Park
004 |  2.34 |  460.45 |  493.12 |  525.79 | enterprise   | Union Station/pres Tower
013 |  2.74 |  460.45 |  493.12 |  525.79 | enterprise   | Chicago Loop
010 |  2.68 |  460.45 |  493.12 |  525.79 | enterprise   | Lake And Franklin
002 |  1.83 |  460.45 |  493.12 |  525.79 | enterprise   | Dd West Loop A/b(ex15ca)
024 |  3.25 |  460.45 |  493.12 |  525.79 | enterprise   | Gold Coast
205 | 34.63 |  506.37 |  506.37 |  529.79 | avis         | Sears Auto Center-spring Hill Mall
170 | 28.94 |  510.50 |  510.58 |  538.93 | enterprise   | Gg New Lenox
168 | 28.65 |  510.50 |  510.58 |  538.93 | enterprise   | Gg Steger
228 | 43.38 |  512.02 |  512.02 |  541.99 | enterprise   | Gg Valparaiso
167 | 28.60 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Gary
230 | 45.02 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Michigan City
129 | 21.60 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Hammond
183 | 31.09 |  512.02 |  512.02 |  541.99 | enterprise   | Gg Hobart
148 | 25.14 |  515.36 |  515.44 |  544.06 | enterprise   | Gg Frankfort And Mokena
084 | 13.90 |  522.95 |  522.95 |  550.36 | budget       | Oak Brook Il Sears
095 | 15.67 |  522.95 |  522.95 |  550.36 | budget       | Lombard
014 |  2.84 |  491.49 |  525.25 |  559.01 | alamo        | Chicago N Lasalle
058 | 10.23 |  526.21 |  526.31 |  566.77 | enterprise   | Dd Stone Park
049 |  7.58 |  526.21 |  526.31 |  566.77 | enterprise   | Dd Elmwood Park
107 | 17.97 |  527.93 |  527.93 |  555.60 | budget       | Addison
179 | 30.67 |  527.93 |  527.93 |  555.60 | budget       | St.charles
195 | 33.26 |  527.93 |  527.93 |  555.60 | budget       | Aurora
159 | 27.31 |  527.93 |  527.93 |  555.60 | budget       | Naperville Il
162 | 28.13 |  527.93 |  527.93 |  555.60 | budget       | Aurora Il Sears
104 | 17.81 |  527.93 |  527.93 |  555.60 | budget       | Downers Grove Il
138 | 23.54 |  527.93 |  527.93 |  555.60 | budget       | Naperville
133 | 22.42 |  529.76 |  529.76 |  558.38 | enterprise   | Aa Carol Stream
231 | 48.25 |  529.76 |  529.76 |  558.38 | enterprise   | Aa-woodstock
094 | 15.44 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Villa Park
093 | 15.23 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Lombard
089 | 14.19 |  529.67 |  529.76 |  558.38 | enterprise   | Aa W Grand Ave
081 | 13.38 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Elmhurst
071 | 11.99 |  530.95 |  531.05 |  571.88 | enterprise   | Morton Grove
062 | 10.81 |  530.95 |  531.05 |  571.88 | enterprise   | Nn Skokie
054 |  9.61 |  530.95 |  531.05 |  571.88 | enterprise   | Nn Lincolnwood 53
137 | 23.06 |  532.42 |  532.51 |  561.13 | enterprise   | Aa Bolingbrook
208 | 35.29 |  536.00 |  536.00 |  565.97 | enterprise   | Gg Arnell
207 | 35.07 |  536.00 |  536.00 |  565.97 | enterprise   | Gg Portage
096 | 15.67 |  536.66 |  536.66 |  558.81 | avis         | Lombard
085 | 13.90 |  536.66 |  536.66 |  558.81 | avis         | Sears Auto Center-oak Brook Center Mall
078 | 12.77 |  537.74 |  537.79 |  578.62 | enterprise   | Nn North Evanston
068 | 11.70 |  537.76 |  537.82 |  578.65 | enterprise   | Nn South Evanston N2
053 |  9.49 |  539.76 |  539.76 |  569.73 | enterprise   | Gg Brookfield
123 | 20.84 |  539.67 |  539.76 |  569.73 | enterprise   | Gg Calumet City
090 | 14.19 |  539.76 |  539.76 |  569.73 | enterprise   | Gg Blue Island
040 |  5.92 |  539.67 |  539.76 |  569.73 | enterprise   | Gg Berwyn
192 | 33.01 |  540.74 |  540.74 |  569.71 | budget       | Merrillville
196 | 33.26 |  541.77 |  541.77 |  564.13 | avis         | Aurora
160 | 27.31 |  541.77 |  541.77 |  564.13 | avis         | Naperville - Pebblewood Plaza
163 | 28.13 |  541.77 |  541.77 |  564.13 | avis         | Sears Auto Ctr-westfield Fox Valley Mall
105 | 17.81 |  541.77 |  541.77 |  564.13 | avis         | Downers Grove, Il
180 | 30.67 |  541.77 |  541.77 |  564.13 | avis         | Foxfield Commons Shopping Plaza
122 | 20.80 |  541.77 |  541.77 |  564.13 | avis         | The Hyatt Of Lisle
139 | 23.57 |  541.77 |  541.77 |  564.13 | avis         | Naperville, Il
077 | 12.38 |  544.62 |  544.62 |  574.86 | enterprise   | Gg Bridgeview
064 | 11.16 |  544.62 |  544.62 |  574.86 | enterprise   | Gg Oak Lawn
042 |  6.68 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Forest Park
154 | 26.34 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Miller Automall
152 | 26.04 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Matteson
115 | 19.94 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Orland Park East
147 | 24.39 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Lansing
114 | 19.64 |  544.53 |  544.62 |  574.86 | enterprise   | Gg South Holland
091 | 14.60 |  544.62 |  544.62 |  574.86 | enterprise   | Gg Crestwood
136 | 22.87 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Homewood
121 | 20.74 |  547.28 |  547.37 |  577.61 | enterprise   | Gg Orland West
034 |  5.05 |  549.94 |  549.94 |  578.91 | budget       | Oak Park
035 |  5.06 |  549.94 |  549.94 |  573.36 | avis         | Oak Park
149 | 25.38 |  552.84 |  552.84 |  581.81 | budget       | Streamwood Il
204 | 34.63 |  552.84 |  552.84 |  581.81 | budget       | West Dundee Sears
164 | 28.32 |  552.86 |  552.86 |  579.36 | budget       | Romeoville, Il Lewis Airport
187 | 32.46 |  552.86 |  552.86 |  579.36 | budget       | Joliet Il Sears
120 | 20.72 |  554.65 |  554.75 |  584.72 | enterprise   | Aa Rolling Meadows Nt
193 | 33.01 |  555.23 |  555.23 |  578.64 | avis         | Merrillville Car Care Center
052 |  8.39 |  557.82 |  557.82 |  587.05 | budget       | Lincolnwood
066 | 11.60 |  557.82 |  557.82 |  587.05 | budget       | Skokie
059 | 10.47 |  557.82 |  557.82 |  587.05 | budget       | Evanston
087 | 14.15 |  557.82 |  557.82 |  587.05 | budget       | Niles Il Sears
099 | 16.00 |  557.82 |  557.82 |  587.05 | budget       | Elk Grove Village Il
142 | 24.21 |  558.82 |  558.82 |  588.05 | budget       | Schaumburg
127 | 21.37 |  558.82 |  558.82 |  588.05 | budget       | Hyatt Woodfield
119 | 20.41 |  559.65 |  559.75 |  589.99 | enterprise   | Nn-arlington Heights
132 | 22.21 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Schaumburg
131 | 22.09 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Roselle
144 | 24.21 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Hoffman Estates
125 | 21.17 |  560.65 |  560.75 |  590.99 | enterprise   | Aa East Schaumburg
165 | 28.32 |  566.70 |  566.70 |  589.06 | avis         | Lewis University Airport
188 | 32.46 |  566.70 |  566.70 |  589.06 | avis         | Sears Auto Center - Louis Joliet Mall
150 | 25.38 |  567.32 |  567.32 |  590.74 | avis         | Streamwood, Il
102 | 16.99 |  568.04 |  568.14 |  601.74 | enterprise   | Nn-mount Prospect
080 | 13.19 |  568.04 |  568.14 |  601.74 | enterprise   | Nn-park Ridge
086 | 14.00 |  568.04 |  568.14 |  601.74 | enterprise   | Golf Mill Ford
060 | 10.47 |  572.43 |  572.43 |  596.06 | avis         | Evanston (525 Kedzie Building)
100 | 16.00 |  572.43 |  572.43 |  596.06 | avis         | Elk Grove Village, Il
067 | 11.60 |  572.43 |  572.43 |  596.06 | avis         | Skokie - Dempster Street
088 | 14.15 |  572.43 |  572.43 |  596.06 | avis         | Sears Auto Ctr - Golf Mill Shopping Ctr
143 | 24.21 |  573.43 |  573.43 |  597.06 | avis         | Schaumburg/hoffman Estates
128 | 21.37 |  573.43 |  573.43 |  597.06 | avis         | Schaumburg Hyatt Regency Hotel
051 |  8.24 |  576.37 |  576.47 |  620.58 | enterprise   | Nn Norwood Park C1
055 |  9.90 |  584.16 |  584.16 |  612.16 | budget       | Oak Lawn
074 | 12.22 |  584.16 |  584.16 |  612.16 | budget       | Chicago Ridge Il Sears
117 | 20.10 |  584.16 |  584.16 |  612.16 | budget       | Orland Park
016 |  2.91 |  570.69 |  586.48 |  612.01 | avis         | North Loop-downtown
015 |  2.91 |  570.69 |  586.48 |  618.06 | budget       | North Loop Budget
001 |  1.05 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Western And Roosevelt
039 |  5.58 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Archer Heights
029 |  4.14 |  591.04 |  591.13 |  623.80 | enterprise   | Gg South Loop
032 |  4.83 |  591.04 |  591.13 |  623.80 | enterprise   | Gg South Western
070 | 11.86 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Stony Island
061 | 10.77 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Chatham Village Sq
057 | 10.09 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Gresham
038 |  5.46 |  596.72 |  596.83 |  640.83 | enterprise   | Nn Riverview
048 |  7.53 |  596.72 |  596.83 |  640.83 | enterprise   | Napleton Chrysler
108 | 18.05 |  597.10 |  597.10 |  619.46 | avis         | Addison
118 | 20.10 |  598.77 |  598.77 |  622.41 | avis         | Orland Park, Il
056 |  9.90 |  598.77 |  598.77 |  622.41 | avis         | Oak Lawn
075 | 12.22 |  598.77 |  598.77 |  622.41 | avis         | Sears Auto-westfield Chicago Ridge Mall
011 |  2.74 |  602.23 |  602.23 |  633.81 | budget       | Chicago Grossinger Autoplex
012 |  2.74 |  602.23 |  602.23 |  627.76 | avis         | Grossinger City Autoplex
022 |  3.23 |  602.23 |  602.23 |  633.81 | budget       | Logan Square Chicago Il
023 |  3.23 |  602.23 |  602.23 |  627.76 | avis         | Logan Square
026 |  3.56 |  602.23 |  602.23 |  627.76 | avis         | Chicago - 18th Street & Wabash Avenue
037 |  5.15 |  602.23 |  602.23 |  627.76 | avis         | Lakeview/chicago
083 | 13.82 |  608.00 |  608.11 |  638.35 | enterprise   | Nn Des Plaines 1505
050 |  7.86 |  617.18 |  617.27 |  649.94 | enterprise   | Gg Hyde Park
033 |  4.92 |  645.30 |  645.41 |  678.08 | enterprise   | Nn Cragin
041 |  6.30 |  645.30 |  645.41 |  678.08 | enterprise   | Nn Irving Park
027 |  3.97 |  645.30 |  645.41 |  678.08 | enterprise   | Nn Gerber Logan Square
007 |  2.42 |  649.64 |  649.64 |  675.17 | avis         | Chicago Union Train Station
006 |  2.42 |  696.96 |  696.96 |  730.24 | budget       | Chicago Union Train Station
036 |  5.14 |  696.98 |  696.98 |  668.06 | budget       | Chicago/lakeview
025 |  3.56 |  696.98 |  696.98 |  668.06 | budget       | Chicago
020 |  3.19 |  696.98 |  696.98 |  668.06 | budget       | Chicago
043 |  6.88 | 1087.39 | 1087.39 | 1104.94 | budget       | Midway Airport
046 |  6.94 | 1099.89 | 1099.89 | 1071.90 | alamo        | Midway Intl Arpt
045 |  6.94 | 1232.42 | 1232.42 | 1201.08 | enterprise   | Midway Intl Arpt
044 |  6.88 | 1232.59 | 1232.59 | 1256.79 | avis         | Chicago Midway Intl Airport
072 | 12.22 | 1264.81 | 1264.81 | 1288.27 | budget       | Ohare Intl Airport
076 | 12.29 | 1277.31 | 1277.31 | 1240.85 | alamo        | Chicago Ohare Airport
079 | 12.93 | 1277.34 | 1277.34 | 1390.27 | enterprise   | Ohare Intl Arpt
073 | 12.22 | 1513.44 | 1537.99 | 1562.12 | avis         | Chicago Ohare Intl Airport
"""
"""
09/11/2017 11:00 AM 10/02/2017 11:00 AM Economy Car Compact Car Intermediate Car
220 | 39.00 |  354.61 |  354.69 |  385.88 | enterprise   | Nn Zion
182 | 31.08 |  357.99 |  358.07 |  389.56 | enterprise   | Nn-north Chicago
203 | 34.40 |  357.99 |  358.07 |  389.56 | enterprise   | Nn-waukegan
194 | 33.16 |  363.67 |  363.76 |  395.24 | enterprise   | Aa Aurora
198 | 33.57 |  363.67 |  363.76 |  395.24 | enterprise   | Aa St Charles
185 | 31.77 |  363.67 |  363.76 |  395.24 | enterprise   | Aa East St. Charles
130 | 21.68 |  357.99 |  358.07 |  397.00 | enterprise   | Nn-highland Park
124 | 21.02 |  354.57 |  354.66 |  402.57 | enterprise   | Nn-hyatt-deerfield
214 | 37.16 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-lake Villa
217 | 37.97 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-gurnee
224 | 40.33 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-round Lake Heights
171 | 29.52 |  365.60 |  365.69 |  404.25 | enterprise   | Nn-mundelein
215 | 37.38 |  383.22 |  383.22 |  405.14 | budget       | Gurnee Il Sears
030 |  4.67 |  395.85 |  395.94 |  407.93 | enterprise   | Dd Oak Park
229 | 44.92 |  369.00 |  369.08 |  408.01 | enterprise   | Nn-antioch
175 | 30.23 |  369.08 |  369.17 |  408.10 | enterprise   | Nn-libertyville
172 | 30.23 |  386.87 |  386.87 |  409.00 | budget       | Lake Zurich Il
134 | 22.51 |  386.87 |  386.87 |  409.00 | budget       | Highland Park
190 | 32.67 |  386.87 |  386.87 |  409.00 | budget       | Libertyville Il
177 | 30.67 |  386.87 |  386.87 |  409.00 | budget       | Libertyville
221 | 39.53 |  386.87 |  386.87 |  409.00 | budget       | Crystal Lake Il
200 | 33.92 |  368.78 |  368.87 |  416.78 | enterprise   | Aa Casten's Body Shop
176 | 30.28 |  372.29 |  372.38 |  420.75 | enterprise   | Aa Barrington
216 | 37.38 |  410.62 |  410.62 |  427.30 | avis         | Sears Auto Center - Gurnee Mills Mall
113 | 19.14 |  378.21 |  378.31 |  429.40 | enterprise   | Nn-wheeling
141 | 23.92 |  378.21 |  378.31 |  429.40 | enterprise   | Nn-napleton Dge Jeep Chr
156 | 26.51 |  359.54 |  360.33 |  429.59 | enterprise   | Aa Lockport
211 | 35.87 |  359.54 |  360.33 |  429.59 | enterprise   | Aa Shorewood
178 | 30.67 |  414.53 |  414.53 |  431.37 | avis         | Libertyville - Milwaukee Avenue
222 | 39.53 |  414.53 |  414.53 |  431.37 | avis         | Crystal Lake, Il
173 | 30.23 |  414.53 |  414.53 |  431.37 | avis         | Lake Zurich-village Square Auto Center
191 | 32.67 |  414.53 |  414.53 |  431.37 | avis         | Libertyville - Peterson Road
135 | 22.51 |  414.53 |  414.53 |  431.37 | avis         | Highland Park Ford
109 | 18.35 |  408.77 |  408.77 |  432.15 | budget       | Northbrook
186 | 32.09 |  362.96 |  363.76 |  433.68 | enterprise   | Aa Crest Hill
202 | 33.95 |  362.96 |  363.76 |  433.68 | enterprise   | Aa Joliet
218 | 38.25 |  411.31 |  411.39 |  434.07 | enterprise   | Aa -algonquin
226 | 42.99 |  411.31 |  411.39 |  434.07 | enterprise   | Aa-huntley
219 | 38.54 |  412.45 |  415.31 |  438.20 | enterprise   | Aa Crystal Lake West
223 | 40.21 |  412.45 |  415.31 |  438.20 | enterprise   | Aa -crystal Lake 2
098 | 15.99 |  419.82 |  419.92 |  443.89 | enterprise   | Nn-glenview
151 | 25.86 |  393.36 |  393.46 |  444.57 | enterprise   | Aa Palatine
018 |  3.11 |  411.35 |  411.46 |  447.38 | enterprise   | Dd Old Town
028 |  4.07 |  411.35 |  411.46 |  447.38 | enterprise   | Nn Lincoln Park
047 |  6.96 |  411.35 |  411.46 |  447.38 | enterprise   | Nn Uptown
003 |  2.34 |  411.35 |  411.46 |  447.38 | enterprise   | Dd Bucktown
005 |  2.38 |  411.35 |  411.46 |  447.38 | enterprise   | Dd Gold Coast Auto Body
009 |  2.68 |  411.49 |  411.49 |  447.44 | enterprise   | Euro Collission
110 | 18.35 |  438.00 |  438.00 |  455.78 | avis         | Renaissance Chicago North Shore
206 | 34.98 |  381.31 |  381.39 |  456.15 | enterprise   | Aa West Elgin
189 | 32.65 |  384.94 |  385.02 |  460.49 | enterprise   | Aa East Dundee
184 | 31.23 |  403.10 |  403.18 |  482.22 | enterprise   | Aa Elgin
103 | 17.63 |  354.61 |  354.69 |  482.55 | enterprise   | Aa Willowbrook
197 | 33.29 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Merrillville
212 | 36.54 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Crown Point Indiana
155 | 26.48 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Griffith
153 | 26.22 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Highland
166 | 28.53 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Schererville
213 | 36.65 |  484.81 |  484.91 |  485.02 | enterprise   | Gg Cedar Lake
210 | 35.46 |  484.81 |  484.91 |  485.02 | enterprise   | Gg East Merrillville
146 | 24.36 |  406.73 |  406.81 |  486.56 | enterprise   | Aa Hanover Park
097 | 15.71 |  358.07 |  358.07 |  487.15 | enterprise   | Aa Westmont
112 | 19.00 |  358.07 |  358.07 |  487.15 | enterprise   | Aa South Downers Grove
106 | 17.87 |  357.99 |  358.07 |  487.15 | enterprise   | Aa North Downers Grove
116 | 19.98 |  360.16 |  360.22 |  495.73 | enterprise   | Aa Glen Ellyn
126 | 21.31 |  362.96 |  363.76 |  496.38 | enterprise   | Aa Lisle
140 | 23.64 |  362.96 |  363.76 |  496.38 | enterprise   | Aa East Naperville
227 | 43.35 |  453.83 |  453.83 |  499.22 | enterprise   | Aa Mchenry
199 | 33.67 |  453.75 |  453.83 |  499.22 | enterprise   | Aa Oswego
225 | 42.12 |  458.07 |  458.15 |  503.97 | enterprise   | Aa Yorkville
209 | 35.41 |  363.65 |  363.73 |  504.41 | enterprise   | Aa Plainfield
181 | 30.80 |  363.65 |  363.73 |  504.41 | enterprise   | Aa North Plainfield
174 | 30.23 |  363.65 |  363.73 |  504.41 | enterprise   | Aa South Naperville
161 | 27.62 |  363.67 |  363.76 |  504.43 | enterprise   | Aa Naperville North
158 | 27.03 |  363.67 |  363.76 |  504.43 | enterprise   | Aa West Ogden
157 | 26.80 |  363.67 |  363.76 |  504.43 | enterprise   | Aa Warrenville
169 | 28.66 |  363.67 |  363.76 |  504.43 | enterprise   | Aa East Aurora
065 | 11.28 |  378.34 |  378.34 |  514.72 | enterprise   | Aa Lagrange
092 | 14.63 |  397.22 |  397.22 |  525.07 | enterprise   | Aa Holiday Inn
019 |  3.16 |  460.45 |  493.12 |  525.79 | enterprise   | Chicago Magnificent Mile
010 |  2.68 |  460.45 |  493.12 |  525.79 | enterprise   | Lake And Franklin
013 |  2.74 |  460.45 |  493.12 |  525.79 | enterprise   | Chicago Loop
004 |  2.34 |  460.45 |  493.12 |  525.79 | enterprise   | Union Station/pres Tower
002 |  1.83 |  460.45 |  493.12 |  525.79 | enterprise   | Dd West Loop A/b(ex15ca)
017 |  3.08 |  460.45 |  493.12 |  525.79 | enterprise   | Millennium Park
024 |  3.25 |  460.45 |  493.12 |  525.79 | enterprise   | Gold Coast
205 | 34.63 |  506.37 |  506.37 |  529.79 | avis         | Sears Auto Center-spring Hill Mall
063 | 10.85 |  485.09 |  485.09 |  533.47 | enterprise   | Schiller Park
170 | 28.94 |  510.50 |  510.58 |  538.93 | enterprise   | Gg New Lenox
168 | 28.65 |  510.50 |  510.58 |  538.93 | enterprise   | Gg Steger
230 | 45.02 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Michigan City
183 | 31.09 |  512.02 |  512.02 |  541.99 | enterprise   | Gg Hobart
228 | 43.38 |  512.02 |  512.02 |  541.99 | enterprise   | Gg Valparaiso
129 | 21.60 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Hammond
167 | 28.60 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Gary
148 | 25.14 |  515.36 |  515.44 |  544.06 | enterprise   | Gg Frankfort And Mokena
095 | 15.67 |  522.95 |  522.95 |  550.36 | budget       | Lombard
084 | 13.90 |  522.95 |  522.95 |  550.36 | budget       | Oak Brook Il Sears
179 | 30.67 |  527.93 |  527.93 |  555.60 | budget       | St.charles
104 | 17.81 |  527.93 |  527.93 |  555.60 | budget       | Downers Grove Il
162 | 28.13 |  527.93 |  527.93 |  555.60 | budget       | Aurora Il Sears
138 | 23.54 |  527.93 |  527.93 |  555.60 | budget       | Naperville
107 | 17.97 |  527.93 |  527.93 |  555.60 | budget       | Addison
195 | 33.26 |  527.93 |  527.93 |  555.60 | budget       | Aurora
159 | 27.31 |  527.93 |  527.93 |  555.60 | budget       | Naperville Il
133 | 22.42 |  529.76 |  529.76 |  558.38 | enterprise   | Aa Carol Stream
231 | 48.25 |  529.76 |  529.76 |  558.38 | enterprise   | Aa-woodstock
089 | 14.19 |  529.67 |  529.76 |  558.38 | enterprise   | Aa W Grand Ave
081 | 13.38 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Elmhurst
093 | 15.23 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Lombard
094 | 15.44 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Villa Park
085 | 13.90 |  536.66 |  536.66 |  558.81 | avis         | Sears Auto Center-oak Brook Center Mall
096 | 15.67 |  536.66 |  536.66 |  558.81 | avis         | Lombard
014 |  2.84 |  491.49 |  525.25 |  559.01 | alamo        | Chicago N Lasalle
137 | 23.06 |  532.42 |  532.51 |  561.13 | enterprise   | Aa Bolingbrook
122 | 20.80 |  541.77 |  541.77 |  564.13 | avis         | The Hyatt Of Lisle
105 | 17.81 |  541.77 |  541.77 |  564.13 | avis         | Downers Grove, Il
196 | 33.26 |  541.77 |  541.77 |  564.13 | avis         | Aurora
180 | 30.67 |  541.77 |  541.77 |  564.13 | avis         | Foxfield Commons Shopping Plaza
160 | 27.31 |  541.77 |  541.77 |  564.13 | avis         | Naperville - Pebblewood Plaza
139 | 23.57 |  541.77 |  541.77 |  564.13 | avis         | Naperville, Il
163 | 28.13 |  541.77 |  541.77 |  564.13 | avis         | Sears Auto Ctr-westfield Fox Valley Mall
208 | 35.29 |  536.00 |  536.00 |  565.97 | enterprise   | Gg Arnell
207 | 35.07 |  536.00 |  536.00 |  565.97 | enterprise   | Gg Portage
049 |  7.58 |  526.21 |  526.31 |  566.77 | enterprise   | Dd Elmwood Park
058 | 10.23 |  526.21 |  526.31 |  566.77 | enterprise   | Dd Stone Park
192 | 33.01 |  540.74 |  540.74 |  569.71 | budget       | Merrillville
040 |  5.92 |  539.67 |  539.76 |  569.73 | enterprise   | Gg Berwyn
053 |  9.49 |  539.76 |  539.76 |  569.73 | enterprise   | Gg Brookfield
123 | 20.84 |  539.67 |  539.76 |  569.73 | enterprise   | Gg Calumet City
090 | 14.19 |  539.76 |  539.76 |  569.73 | enterprise   | Gg Blue Island
071 | 11.99 |  530.95 |  531.05 |  571.88 | enterprise   | Morton Grove
062 | 10.81 |  530.95 |  531.05 |  571.88 | enterprise   | Nn Skokie
054 |  9.61 |  530.95 |  531.05 |  571.88 | enterprise   | Nn Lincolnwood 53
035 |  5.06 |  549.94 |  549.94 |  573.36 | avis         | Oak Park
114 | 19.64 |  544.53 |  544.62 |  574.86 | enterprise   | Gg South Holland
077 | 12.38 |  544.62 |  544.62 |  574.86 | enterprise   | Gg Bridgeview
042 |  6.68 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Forest Park
064 | 11.16 |  544.62 |  544.62 |  574.86 | enterprise   | Gg Oak Lawn
154 | 26.34 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Miller Automall
152 | 26.04 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Matteson
115 | 19.94 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Orland Park East
136 | 22.87 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Homewood
091 | 14.60 |  544.62 |  544.62 |  574.86 | enterprise   | Gg Crestwood
147 | 24.39 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Lansing
121 | 20.74 |  547.28 |  547.37 |  577.61 | enterprise   | Gg Orland West
078 | 12.77 |  537.74 |  537.79 |  578.62 | enterprise   | Nn North Evanston
193 | 33.01 |  555.23 |  555.23 |  578.64 | avis         | Merrillville Car Care Center
068 | 11.70 |  537.76 |  537.82 |  578.65 | enterprise   | Nn South Evanston N2
034 |  5.05 |  549.94 |  549.94 |  578.91 | budget       | Oak Park
187 | 32.46 |  552.86 |  552.86 |  579.36 | budget       | Joliet Il Sears
164 | 28.32 |  552.86 |  552.86 |  579.36 | budget       | Romeoville, Il Lewis Airport
204 | 34.63 |  552.84 |  552.84 |  581.81 | budget       | West Dundee Sears
149 | 25.38 |  552.84 |  552.84 |  581.81 | budget       | Streamwood Il
120 | 20.72 |  554.65 |  554.75 |  584.72 | enterprise   | Aa Rolling Meadows Nt
052 |  8.39 |  557.82 |  557.82 |  587.05 | budget       | Lincolnwood
059 | 10.47 |  557.82 |  557.82 |  587.05 | budget       | Evanston
099 | 16.00 |  557.82 |  557.82 |  587.05 | budget       | Elk Grove Village Il
066 | 11.60 |  557.82 |  557.82 |  587.05 | budget       | Skokie
087 | 14.15 |  557.82 |  557.82 |  587.05 | budget       | Niles Il Sears
142 | 24.21 |  558.82 |  558.82 |  588.05 | budget       | Schaumburg
127 | 21.37 |  558.82 |  558.82 |  588.05 | budget       | Hyatt Woodfield
165 | 28.32 |  566.70 |  566.70 |  589.06 | avis         | Lewis University Airport
188 | 32.46 |  566.70 |  566.70 |  589.06 | avis         | Sears Auto Center - Louis Joliet Mall
119 | 20.41 |  559.65 |  559.75 |  589.99 | enterprise   | Nn-arlington Heights
150 | 25.38 |  567.32 |  567.32 |  590.74 | avis         | Streamwood, Il
131 | 22.09 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Roselle
144 | 24.21 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Hoffman Estates
132 | 22.21 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Schaumburg
125 | 21.17 |  560.65 |  560.75 |  590.99 | enterprise   | Aa East Schaumburg
067 | 11.60 |  572.43 |  572.43 |  596.06 | avis         | Skokie - Dempster Street
088 | 14.15 |  572.43 |  572.43 |  596.06 | avis         | Sears Auto Ctr - Golf Mill Shopping Ctr
100 | 16.00 |  572.43 |  572.43 |  596.06 | avis         | Elk Grove Village, Il
060 | 10.47 |  572.43 |  572.43 |  596.06 | avis         | Evanston (525 Kedzie Building)
143 | 24.21 |  573.43 |  573.43 |  597.06 | avis         | Schaumburg/hoffman Estates
128 | 21.37 |  573.43 |  573.43 |  597.06 | avis         | Schaumburg Hyatt Regency Hotel
080 | 13.19 |  568.04 |  568.14 |  601.74 | enterprise   | Nn-park Ridge
102 | 16.99 |  568.04 |  568.14 |  601.74 | enterprise   | Nn-mount Prospect
086 | 14.00 |  568.04 |  568.14 |  601.74 | enterprise   | Golf Mill Ford
016 |  2.91 |  570.69 |  586.48 |  612.01 | avis         | North Loop-downtown
074 | 12.22 |  584.16 |  584.16 |  612.16 | budget       | Chicago Ridge Il Sears
117 | 20.10 |  584.16 |  584.16 |  612.16 | budget       | Orland Park
055 |  9.90 |  584.16 |  584.16 |  612.16 | budget       | Oak Lawn
015 |  2.91 |  570.69 |  586.48 |  618.06 | budget       | North Loop Budget
108 | 18.05 |  597.10 |  597.10 |  619.46 | avis         | Addison
051 |  8.24 |  576.37 |  576.47 |  620.58 | enterprise   | Nn Norwood Park C1
118 | 20.10 |  598.77 |  598.77 |  622.41 | avis         | Orland Park, Il
075 | 12.22 |  598.77 |  598.77 |  622.41 | avis         | Sears Auto-westfield Chicago Ridge Mall
056 |  9.90 |  598.77 |  598.77 |  622.41 | avis         | Oak Lawn
001 |  1.05 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Western And Roosevelt
070 | 11.86 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Stony Island
061 | 10.77 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Chatham Village Sq
057 | 10.09 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Gresham
029 |  4.14 |  591.04 |  591.13 |  623.80 | enterprise   | Gg South Loop
032 |  4.83 |  591.04 |  591.13 |  623.80 | enterprise   | Gg South Western
039 |  5.58 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Archer Heights
012 |  2.74 |  602.23 |  602.23 |  627.76 | avis         | Grossinger City Autoplex
023 |  3.23 |  602.23 |  602.23 |  627.76 | avis         | Logan Square
026 |  3.56 |  602.23 |  602.23 |  627.76 | avis         | Chicago - 18th Street & Wabash Avenue
037 |  5.15 |  602.23 |  602.23 |  627.76 | avis         | Lakeview/chicago
011 |  2.74 |  602.23 |  602.23 |  633.81 | budget       | Chicago Grossinger Autoplex
022 |  3.23 |  602.23 |  602.23 |  633.81 | budget       | Logan Square Chicago Il
083 | 13.82 |  608.00 |  608.11 |  638.35 | enterprise   | Nn Des Plaines 1505
038 |  5.46 |  596.72 |  596.83 |  640.83 | enterprise   | Nn Riverview
048 |  7.53 |  596.72 |  596.83 |  640.83 | enterprise   | Napleton Chrysler
050 |  7.86 |  617.18 |  617.27 |  649.94 | enterprise   | Gg Hyde Park
025 |  3.56 |  696.98 |  696.98 |  668.06 | budget       | Chicago
036 |  5.14 |  696.98 |  696.98 |  668.06 | budget       | Chicago/lakeview
020 |  3.19 |  696.98 |  696.98 |  668.06 | budget       | Chicago
007 |  2.42 |  649.64 |  649.64 |  675.17 | avis         | Chicago Union Train Station
033 |  4.92 |  645.30 |  645.41 |  678.08 | enterprise   | Nn Cragin
027 |  3.97 |  645.30 |  645.41 |  678.08 | enterprise   | Nn Gerber Logan Square
041 |  6.30 |  645.30 |  645.41 |  678.08 | enterprise   | Nn Irving Park
006 |  2.42 |  696.96 |  696.96 |  730.24 | budget       | Chicago Union Train Station
046 |  6.94 | 1099.89 | 1099.89 | 1071.90 | alamo        | Midway Intl Arpt
043 |  6.88 | 1087.39 | 1087.39 | 1104.94 | budget       | Midway Airport
045 |  6.94 | 1232.42 | 1232.42 | 1201.08 | enterprise   | Midway Intl Arpt
076 | 12.29 | 1277.31 | 1277.31 | 1240.85 | alamo        | Chicago Ohare Airport
044 |  6.88 | 1232.59 | 1232.59 | 1256.79 | avis         | Chicago Midway Intl Airport
072 | 12.22 | 1264.81 | 1264.81 | 1288.27 | budget       | Ohare Intl Airport
079 | 12.93 | 1277.34 | 1277.34 | 1390.27 | enterprise   | Ohare Intl Arpt
073 | 12.22 | 1513.44 | 1537.99 | 1562.12 | avis         | Chicago Ohare Intl Airport
"""


    

In [ ]:

    

"""
09/18/2017 11:00 AM 10/09/2017 11:00 AM Economy Car Compact Car Intermediate Car
087 | 18.57 |  354.61 |  354.69 |  385.88 | enterprise   | Aa Willowbrook
116 | 21.41 |  357.99 |  358.07 |  389.56 | enterprise   | Aa North Downers Grove
112 | 21.31 |  358.07 |  358.07 |  389.56 | enterprise   | Aa South Downers Grove
094 | 19.16 |  358.07 |  358.07 |  389.56 | enterprise   | Aa Westmont
130 | 24.53 |  360.16 |  360.22 |  391.41 | enterprise   | Aa Glen Ellyn
139 | 26.20 |  359.54 |  360.33 |  391.51 | enterprise   | Aa Lockport
190 | 35.82 |  359.54 |  360.33 |  391.51 | enterprise   | Aa Shorewood
149 | 27.93 |  354.57 |  354.66 |  393.21 | enterprise   | Nn-hyatt-deerfield
222 | 45.36 |  354.61 |  354.69 |  393.25 | enterprise   | Nn Zion
181 | 32.46 |  363.65 |  363.73 |  395.20 | enterprise   | Aa North Plainfield
179 | 32.22 |  363.65 |  363.73 |  395.20 | enterprise   | Aa South Naperville
187 | 35.69 |  363.65 |  363.73 |  395.20 | enterprise   | Aa Plainfield
195 | 36.83 |  363.67 |  363.76 |  395.24 | enterprise   | Aa East St. Charles
194 | 36.65 |  363.67 |  363.76 |  395.24 | enterprise   | Aa Aurora
186 | 33.53 |  362.96 |  363.76 |  395.24 | enterprise   | Aa Joliet
173 | 31.04 |  363.67 |  363.76 |  395.24 | enterprise   | Aa Naperville North
180 | 32.26 |  362.96 |  363.76 |  395.24 | enterprise   | Aa Crest Hill
178 | 31.67 |  363.67 |  363.76 |  395.24 | enterprise   | Aa East Aurora
144 | 27.09 |  362.96 |  363.76 |  395.24 | enterprise   | Aa East Naperville
169 | 30.85 |  363.67 |  363.76 |  395.24 | enterprise   | Aa Warrenville
164 | 30.14 |  363.67 |  363.76 |  395.24 | enterprise   | Aa West Ogden
206 | 38.45 |  363.67 |  363.76 |  395.24 | enterprise   | Aa St Charles
132 | 24.83 |  362.96 |  363.76 |  395.24 | enterprise   | Aa Lisle
205 | 37.77 |  357.99 |  358.07 |  397.00 | enterprise   | Nn-north Chicago
153 | 28.39 |  357.99 |  358.07 |  397.00 | enterprise   | Nn-highland Park
213 | 41.00 |  357.99 |  358.07 |  397.00 | enterprise   | Nn-waukegan
220 | 44.78 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-gurnee
216 | 44.03 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-lake Villa
228 | 47.30 |  365.52 |  365.60 |  404.16 | enterprise   | Nn-round Lake Heights
192 | 36.51 |  365.60 |  365.69 |  404.25 | enterprise   | Nn-mundelein
212 | 40.91 |  368.78 |  368.87 |  407.42 | enterprise   | Aa Casten's Body Shop
233 | 51.79 |  369.00 |  369.08 |  408.01 | enterprise   | Nn-antioch
198 | 37.14 |  369.08 |  369.17 |  408.10 | enterprise   | Nn-libertyville
199 | 37.15 |  372.29 |  372.38 |  411.30 | enterprise   | Aa Barrington
061 | 13.64 |  378.34 |  378.34 |  411.61 | enterprise   | Aa Lagrange
211 | 40.85 |  381.31 |  381.39 |  414.37 | enterprise   | Aa West Elgin
131 | 24.81 |  386.49 |  386.58 |  418.06 | enterprise   | Aa Bolingbrook
207 | 39.05 |  384.94 |  385.02 |  418.32 | enterprise   | Aa East Dundee
138 | 26.13 |  378.21 |  378.31 |  419.42 | enterprise   | Nn-wheeling
170 | 30.91 |  378.21 |  378.31 |  419.42 | enterprise   | Nn-napleton Dge Jeep Chr
089 | 18.96 |  397.22 |  397.22 |  428.40 | enterprise   | Aa Holiday Inn
184 | 32.84 |  393.36 |  393.46 |  434.58 | enterprise   | Aa Palatine
202 | 37.33 |  403.10 |  403.18 |  438.05 | enterprise   | Aa Elgin
165 | 30.52 |  406.73 |  406.81 |  442.00 | enterprise   | Aa Hanover Park
052 | 10.97 |  461.78 |  461.88 |  473.86 | enterprise   | Dd Oak Park
273 | 81.95 |  453.88 |  468.06 |  482.23 | enterprise   | Loves Park Il
238 | 58.96 |  458.20 |  472.52 |  486.82 | enterprise   | Dekalb Il
253 | 72.51 |  458.20 |  472.52 |  486.82 | enterprise   | Belvidere Il
262 | 79.96 |  458.20 |  472.52 |  486.82 | enterprise   | Rockford Alpine
261 | 78.89 |  458.20 |  472.52 |  486.82 | enterprise   | Rockford East
015 |  5.93 |  427.78 |  460.45 |  493.12 | enterprise   | Union Station/pres Tower
014 |  5.84 |  427.78 |  460.45 |  493.12 | enterprise   | Dd West Loop A/b(ex15ca)
013 |  5.82 |  427.78 |  460.45 |  493.12 | enterprise   | Chicago Loop
249 | 69.92 |  388.95 |  415.46 |  498.45 | enterprise   | Niles
232 | 51.79 |  453.83 |  453.83 |  499.22 | enterprise   | Aa Morris
191 | 36.35 |  453.83 |  453.83 |  499.22 | enterprise   | Aa Oswego
231 | 50.34 |  453.83 |  453.83 |  499.22 | enterprise   | Aa Mchenry
219 | 44.52 |  458.15 |  458.15 |  503.97 | enterprise   | Aa Yorkville
147 | 27.68 |  458.15 |  458.15 |  503.97 | enterprise   | Aa Carol Stream
256 | 73.39 |  392.14 |  419.90 |  506.81 | enterprise   | Mishawaka
250 | 70.01 |  392.14 |  419.90 |  506.81 | enterprise   | South Bend N - Roseland
252 | 70.61 |  392.14 |  419.90 |  506.81 | enterprise   | South Bend
234 | 55.06 |  461.02 |  461.02 |  506.84 | enterprise   | Aa-woodstock
285 | 88.32 |  493.10 |  493.10 |  522.94 | enterprise   | Beloit
295 | 95.49 |  493.10 |  493.10 |  522.94 | enterprise   | Janesville
287 | 88.32 |  495.60 |  495.60 |  524.34 | budget       | Midway Brookfield
242 | 64.95 |  495.60 |  495.60 |  524.34 | budget       | Racine Wi Marriott Hotel
024 |  6.86 |  460.45 |  493.12 |  525.79 | enterprise   | Gold Coast
023 |  6.43 |  460.45 |  493.12 |  525.79 | enterprise   | Chicago Magnificent Mile
020 |  6.09 |  460.45 |  493.12 |  525.79 | enterprise   | Lake And Franklin
016 |  5.93 |  460.45 |  493.12 |  525.79 | enterprise   | Millennium Park
294 | 95.32 |  486.69 |  486.69 |  529.71 | budget       | Janesville, Wi Sears
214 | 41.03 |  506.37 |  506.37 |  529.79 | avis         | Sears Auto Center-spring Hill Mall
123 | 22.80 |  488.76 |  488.84 |  530.80 | enterprise   | Nn-glenview
078 | 17.63 |  485.09 |  485.09 |  533.47 | enterprise   | Schiller Park
230 | 49.44 |  510.38 |  510.47 |  538.82 | enterprise   | Aa-huntley
221 | 44.78 |  510.38 |  510.47 |  538.82 | enterprise   | Aa -algonquin
141 | 26.83 |  510.50 |  510.58 |  538.93 | enterprise   | Gg New Lenox
124 | 23.02 |  510.50 |  510.58 |  538.93 | enterprise   | Gg Steger
280 | 86.65 |  511.35 |  511.35 |  541.01 | budget       | West Allis
282 | 87.06 |  511.35 |  511.35 |  541.01 | budget       | Milwaukee
162 | 29.60 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Crown Point Indiana
118 | 21.81 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Schererville
066 | 14.69 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Hammond
117 | 21.60 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Gary
163 | 30.13 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Cedar Lake
193 | 36.52 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Valparaiso
140 | 26.33 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Merrillville
097 | 19.43 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Highland
098 | 19.55 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Griffith
155 | 28.45 |  511.93 |  512.02 |  541.99 | enterprise   | Gg East Merrillville
128 | 24.13 |  511.93 |  512.02 |  541.99 | enterprise   | Gg Hobart
120 | 22.13 |  515.36 |  515.44 |  544.06 | enterprise   | Gg Frankfort And Mokena
286 | 88.32 |  524.34 |  524.34 |  547.57 | avis         | Brookfield - Best Western Midway
241 | 64.95 |  524.34 |  524.34 |  547.57 | avis         | Racine Marriott Hotel
086 | 18.39 |  522.95 |  522.95 |  550.36 | budget       | Oak Brook Il Sears
104 | 20.30 |  522.95 |  522.95 |  550.36 | budget       | Lombard
172 | 30.94 |  527.93 |  527.93 |  555.60 | budget       | Naperville Il
197 | 36.89 |  527.93 |  527.93 |  555.60 | budget       | Aurora
115 | 21.35 |  527.93 |  527.93 |  555.60 | budget       | Downers Grove Il
142 | 27.01 |  527.93 |  527.93 |  555.60 | budget       | Naperville
125 | 23.57 |  527.93 |  527.93 |  555.60 | budget       | Addison
175 | 31.24 |  527.93 |  527.93 |  555.60 | budget       | Aurora Il Sears
189 | 35.80 |  527.93 |  527.93 |  555.60 | budget       | St.charles
095 | 19.34 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Elmhurst
223 | 45.36 |  529.76 |  529.76 |  558.38 | enterprise   | Aa Crystal Lake West
101 | 20.15 |  529.67 |  529.76 |  558.38 | enterprise   | Aa W Grand Ave
107 | 20.90 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Villa Park
227 | 47.08 |  529.76 |  529.76 |  558.38 | enterprise   | Aa -crystal Lake 2
100 | 19.86 |  529.67 |  529.76 |  558.38 | enterprise   | Aa Lombard
035 |  8.08 |  545.45 |  545.45 |  558.51 | enterprise   | Euro Collission
085 | 18.39 |  536.66 |  536.66 |  558.81 | avis         | Sears Auto Center-oak Brook Center Mall
103 | 20.30 |  536.66 |  536.66 |  558.81 | avis         | Lombard
019 |  6.07 |  491.49 |  525.25 |  559.01 | alamo        | Chicago N Lasalle
064 | 14.15 |  533.80 |  536.80 |  563.77 | enterprise   | Dd Elmwood Park
069 | 16.04 |  533.80 |  536.80 |  563.77 | enterprise   | Dd Stone Park
188 | 35.80 |  541.77 |  541.77 |  564.13 | avis         | Foxfield Commons Shopping Plaza
196 | 36.89 |  541.77 |  541.77 |  564.13 | avis         | Aurora
129 | 24.42 |  541.77 |  541.77 |  564.13 | avis         | The Hyatt Of Lisle
143 | 27.04 |  541.77 |  541.77 |  564.13 | avis         | Naperville, Il
171 | 30.94 |  541.77 |  541.77 |  564.13 | avis         | Naperville - Pebblewood Plaza
114 | 21.35 |  541.77 |  541.77 |  564.13 | avis         | Downers Grove, Il
174 | 31.24 |  541.77 |  541.77 |  564.13 | avis         | Sears Auto Ctr-westfield Fox Valley Mall
226 | 46.50 |  510.58 |  538.97 |  564.48 | enterprise   | Gg Kankakee
281 | 87.06 |  541.01 |  541.01 |  564.98 | avis         | Downtown Milwaukee
279 | 86.65 |  541.01 |  541.01 |  564.98 | avis         | West Allis
152 | 28.25 |  535.91 |  536.00 |  565.97 | enterprise   | Gg Portage
158 | 28.80 |  535.91 |  536.00 |  565.97 | enterprise   | Gg Arnell
276 | 84.51 |  538.93 |  553.11 |  567.28 | enterprise   | Peru Il
248 | 69.67 |  538.93 |  553.11 |  567.28 | enterprise   | Bill Walsh Ottawa
070 | 16.04 |  538.61 |  541.64 |  568.85 | enterprise   | Nn Lincolnwood 53
077 | 17.54 |  538.61 |  541.64 |  568.85 | enterprise   | Nn Skokie
088 | 18.86 |  538.61 |  541.64 |  568.85 | enterprise   | Morton Grove
137 | 26.05 |  540.74 |  540.74 |  569.71 | budget       | Merrillville
243 | 66.91 |  540.74 |  540.74 |  569.71 | budget       | South Bend
039 |  9.33 |  539.76 |  539.76 |  569.73 | enterprise   | Gg Berwyn
040 |  9.47 |  539.76 |  539.76 |  569.73 | enterprise   | Gg Blue Island
065 | 14.33 |  539.67 |  539.76 |  569.73 | enterprise   | Gg Calumet City
059 | 12.70 |  539.76 |  539.76 |  569.73 | enterprise   | Gg Brookfield
278 | 84.83 |  452.08 |  482.05 |  571.96 | enterprise   | Monticello
297 | 97.23 |  452.08 |  482.05 |  571.96 | enterprise   | Logansport
296 | 97.08 |  544.06 |  558.38 |  572.68 | enterprise   | Dixon
050 | 10.82 |  549.94 |  549.94 |  573.36 | avis         | Oak Park
218 | 44.16 |  547.65 |  547.65 |  573.90 | budget       | Gurnee Il Sears
036 |  8.70 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Oak Lawn
113 | 21.35 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Matteson
054 | 11.20 |  544.62 |  544.62 |  574.86 | enterprise   | Gg Crestwood
055 | 11.71 |  544.62 |  544.62 |  574.86 | enterprise   | Gg Forest Park
119 | 21.92 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Miller Automall
062 | 13.76 |  544.53 |  544.62 |  574.86 | enterprise   | Gg South Holland
073 | 16.75 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Orland Park East
076 | 17.26 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Homewood
053 | 11.09 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Bridgeview
081 | 18.03 |  544.53 |  544.62 |  574.86 | enterprise   | Gg Lansing
258 | 76.73 |  539.00 |  552.83 |  575.20 | avis         | Sears Auto Center - Cherryvale Mall
082 | 18.12 |  547.28 |  547.37 |  577.61 | enterprise   | Gg Orland West
136 | 26.05 |  555.23 |  555.23 |  578.64 | avis         | Merrillville Car Care Center
051 | 10.82 |  549.94 |  549.94 |  578.91 | budget       | Oak Park
225 | 46.33 |  552.86 |  552.86 |  579.36 | budget       | Crystal Lake Il
157 | 28.59 |  552.86 |  552.86 |  579.36 | budget       | Romeoville, Il Lewis Airport
183 | 32.83 |  552.86 |  552.86 |  579.36 | budget       | Joliet Il Sears
161 | 29.21 |  552.86 |  552.86 |  579.36 | budget       | Highland Park
210 | 39.56 |  552.86 |  552.86 |  579.36 | budget       | Libertyville Il
204 | 37.57 |  552.86 |  552.86 |  579.36 | budget       | Libertyville
201 | 37.18 |  552.86 |  552.86 |  579.36 | budget       | Lake Zurich Il
272 | 81.68 |  550.77 |  550.77 |  580.50 | enterprise   | John Amato Ford
251 | 70.56 |  550.77 |  550.77 |  580.50 | enterprise   | Burlington
289 | 90.01 |  550.77 |  550.77 |  580.50 | enterprise   | Waukesha
290 | 92.37 |  550.77 |  550.77 |  580.50 | enterprise   | Brookfield
240 | 64.85 |  550.77 |  550.77 |  580.50 | enterprise   | Racine
291 | 92.58 |  550.77 |  550.77 |  580.50 | enterprise   | Pewaukee
042 |  9.61 |  568.21 |  568.30 |  581.37 | enterprise   | Nn Lincoln Park
027 |  7.54 |  568.21 |  568.30 |  581.37 | enterprise   | Dd Gold Coast Auto Body
030 |  7.87 |  568.21 |  568.30 |  581.37 | enterprise   | Dd Old Town
058 | 12.59 |  568.21 |  568.30 |  581.37 | enterprise   | Nn Uptown
038 |  8.91 |  568.21 |  568.30 |  581.37 | enterprise   | Dd Bucktown
177 | 31.61 |  552.84 |  552.84 |  581.81 | budget       | Streamwood Il
215 | 41.03 |  552.84 |  552.84 |  581.81 | budget       | West Dundee Sears
235 | 55.23 |  552.77 |  552.77 |  582.61 | enterprise   | Kenosha West
260 | 77.75 |  552.77 |  552.77 |  582.61 | enterprise   | Delavan
217 | 44.16 |  561.35 |  561.35 |  583.51 | avis         | Sears Auto Center - Gurnee Mills Mall
146 | 27.52 |  554.65 |  554.75 |  584.72 | enterprise   | Aa Rolling Meadows Nt
267 | 81.52 |  547.13 |  561.93 |  585.86 | avis         | Chicago Rockford Intl Airport
084 | 18.35 |  557.82 |  557.82 |  587.05 | budget       | Skokie
072 | 16.46 |  557.82 |  557.82 |  587.05 | budget       | Evanston
067 | 15.03 |  557.82 |  557.82 |  587.05 | budget       | Lincolnwood
122 | 22.76 |  557.82 |  557.82 |  587.05 | budget       | Elk Grove Village Il
110 | 21.15 |  557.82 |  557.82 |  587.05 | budget       | Niles Il Sears
151 | 28.09 |  558.82 |  558.82 |  588.05 | budget       | Hyatt Woodfield
167 | 30.75 |  558.82 |  558.82 |  588.05 | budget       | Schaumburg
182 | 32.83 |  566.70 |  566.70 |  589.06 | avis         | Sears Auto Center - Louis Joliet Mall
224 | 46.33 |  566.70 |  566.70 |  589.06 | avis         | Crystal Lake, Il
200 | 37.18 |  566.70 |  566.70 |  589.06 | avis         | Lake Zurich-village Square Auto Center
209 | 39.56 |  566.70 |  566.70 |  589.06 | avis         | Libertyville - Peterson Road
156 | 28.59 |  566.70 |  566.70 |  589.06 | avis         | Lewis University Airport
203 | 37.57 |  566.70 |  566.70 |  589.06 | avis         | Libertyville - Milwaukee Avenue
160 | 29.21 |  566.70 |  566.70 |  589.06 | avis         | Highland Park Ford
145 | 27.34 |  559.65 |  559.75 |  589.99 | enterprise   | Nn-arlington Heights
176 | 31.61 |  567.32 |  567.32 |  590.74 | avis         | Streamwood, Il
148 | 27.81 |  560.65 |  560.75 |  590.99 | enterprise   | Aa East Schaumburg
168 | 30.76 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Hoffman Estates
154 | 28.43 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Roselle
159 | 28.87 |  560.65 |  560.75 |  590.99 | enterprise   | Aa Schaumburg
083 | 18.35 |  572.43 |  572.43 |  596.06 | avis         | Skokie - Dempster Street
071 | 16.46 |  572.43 |  572.43 |  596.06 | avis         | Evanston (525 Kedzie Building)
121 | 22.76 |  572.43 |  572.43 |  596.06 | avis         | Elk Grove Village, Il
109 | 21.15 |  572.43 |  572.43 |  596.06 | avis         | Sears Auto Ctr - Golf Mill Shopping Ctr
166 | 30.75 |  573.43 |  573.43 |  597.06 | avis         | Schaumburg/hoffman Estates
150 | 28.09 |  573.43 |  573.43 |  597.06 | avis         | Schaumburg Hyatt Regency Hotel
060 | 13.31 |  597.09 |  597.18 |  597.25 | enterprise   | Nn Irving Park
057 | 11.92 |  597.09 |  597.18 |  597.25 | enterprise   | Nn Cragin
049 | 10.78 |  597.09 |  597.18 |  597.25 | enterprise   | Nn Gerber Logan Square
288 | 89.66 |  568.28 |  571.36 |  598.95 | enterprise   | Wauwatosa
283 | 87.14 |  568.28 |  568.28 |  598.95 | enterprise   | Milwaukee Downtown
277 | 84.56 |  568.28 |  568.28 |  598.95 | enterprise   | Greenfield
292 | 93.18 |  568.28 |  568.28 |  598.95 | enterprise   | Glendale
274 | 82.47 |  568.28 |  568.28 |  598.95 | enterprise   | South Milwaukee
298 | 97.52 |  568.28 |  568.28 |  598.95 | enterprise   | Milwaukee Northeast
293 | 95.32 |  563.49 |  563.49 |  600.60 | avis         | Sears Auto Center - Janesville Mall
239 | 62.35 |  560.67 |  580.70 |  600.73 | enterprise   | Benton Harbor
268 | 81.52 |  561.93 |  576.72 |  605.79 | budget       | Greater Rockford Apo
017 |  6.05 |  570.69 |  586.48 |  612.01 | avis         | North Loop-downtown
034 |  8.04 |  584.16 |  584.16 |  612.16 | budget       | Oak Lawn
048 | 10.78 |  584.16 |  584.16 |  612.16 | budget       | Chicago Ridge Il Sears
075 | 16.99 |  584.16 |  584.16 |  612.16 | budget       | Orland Park
134 | 25.02 |  584.16 |  584.16 |  612.16 | budget       | Northbrook
237 | 58.59 |  593.35 |  593.35 |  612.60 | budget       | Budget St Joseph-red Arrow
255 | 73.31 |  584.04 |  584.04 |  615.33 | budget       | Mishawaka In Sears
068 | 15.24 |  584.64 |  587.91 |  617.31 | enterprise   | Nn Norwood Park C1
018 |  6.05 |  570.69 |  586.48 |  618.06 | budget       | North Loop Budget
126 | 23.70 |  597.10 |  597.10 |  619.46 | avis         | Addison
033 |  8.04 |  598.77 |  598.77 |  622.41 | avis         | Oak Lawn/chicago
074 | 16.99 |  598.77 |  598.77 |  622.41 | avis         | Orland Park, Il
047 | 10.78 |  598.77 |  598.77 |  622.41 | avis         | Sears Auto-westfield Chicago Ridge Mall
133 | 25.02 |  598.77 |  598.77 |  622.41 | avis         | Renaissance Chicago North Shore
005 |  4.19 |  591.04 |  591.13 |  623.80 | enterprise   | Gg South Western
007 |  4.43 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Chatham Village Sq
009 |  5.17 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Stony Island
010 |  5.57 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Gresham
002 |  3.17 |  591.04 |  591.13 |  623.80 | enterprise   | Gg South Loop
021 |  6.13 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Archer Heights
022 |  6.17 |  591.04 |  591.13 |  623.80 | enterprise   | Gg Western And Roosevelt
236 | 58.59 |  607.18 |  607.18 |  624.01 | avis         | Saint Joseph, Mi
254 | 73.31 |  599.69 |  599.69 |  624.99 | avis         | Sears Auto Center - University Park Mall
046 | 10.56 |  602.23 |  602.23 |  627.76 | avis         | Lakeview/chicago
031 |  7.94 |  602.23 |  602.23 |  627.76 | avis         | Grossinger City Autoplex
043 | 10.15 |  602.23 |  602.23 |  627.76 | avis         | Logan Square
003 |  4.05 |  602.23 |  602.23 |  627.76 | avis         | Chicago - 18th Street & Wabash Avenue
257 | 73.45 |  571.96 |  601.93 |  631.90 | enterprise   | Plymouth
275 | 82.97 |  571.96 |  601.93 |  631.90 | enterprise   | Elkhart
284 | 88.24 |  571.96 |  601.93 |  631.90 | enterprise   | Goshen
044 | 10.15 |  602.23 |  602.23 |  633.81 | budget       | Logan Square Chicago Il
032 |  7.94 |  602.23 |  602.23 |  633.81 | budget       | Chicago Grossinger Autoplex
106 | 20.79 |  605.01 |  605.10 |  635.34 | enterprise   | Nn Des Plaines 1505
102 | 20.19 |  605.01 |  605.10 |  635.34 | enterprise   | Nn-park Ridge
127 | 23.87 |  605.01 |  605.10 |  635.34 | enterprise   | Nn-mount Prospect
108 | 21.00 |  605.01 |  605.10 |  635.34 | enterprise   | Golf Mill Ford
270 | 81.55 |  593.66 |  608.98 |  639.60 | enterprise   | Rockford Ap Erac Ody
001 |  0.95 |  617.18 |  617.27 |  649.94 | enterprise   | Gg Hyde Park
271 | 81.55 |  611.78 |  620.55 |  650.53 | alamo        | Chicago Rockford Arpt
264 | 80.84 |  633.52 |  639.03 |  653.71 | budget       | General Mitchell Intl Apo
090 | 18.96 |  635.25 |  635.34 |  665.58 | enterprise   | Nn North Evanston
079 | 17.76 |  635.25 |  635.34 |  665.58 | enterprise   | Nn South Evanston N2
004 |  4.05 |  696.98 |  696.98 |  668.06 | budget       | Chicago
045 | 10.55 |  696.98 |  696.98 |  668.06 | budget       | Chicago/lakeview
008 |  5.11 |  696.98 |  696.98 |  668.06 | budget       | Chicago
011 |  5.71 |  649.64 |  649.64 |  675.17 | avis         | Chicago Union Train Station
265 | 81.05 |  679.51 |  679.51 |  688.86 | enterprise   | Milwaukee Intl Arpt
246 | 67.12 |  623.08 |  623.08 |  694.17 | avis         | South Bend Regional Airport
247 | 67.12 |  726.09 |  740.44 |  711.09 | budget       | Southbend Regional Airport
263 | 80.84 |  700.32 |  711.68 |  712.94 | avis         | General Mitchell Field
245 | 66.94 |  681.42 |  695.78 |  713.46 | alamo        | South Bend Regional Arpt
229 | 48.38 |  661.87 |  691.84 |  721.81 | enterprise   | Gg Laporte
208 | 39.53 |  661.87 |  691.84 |  721.81 | enterprise   | Gg Michigan City
056 | 11.85 |  689.14 |  689.14 |  721.81 | enterprise   | Nn Riverview
063 | 13.81 |  689.14 |  689.14 |  721.81 | enterprise   | Napleton Chrysler
012 |  5.71 |  696.96 |  696.96 |  730.24 | budget       | Chicago Union Train Station
244 | 66.93 |  767.82 |  778.04 |  785.36 | enterprise   | South Bend Regional Arpt
026 |  7.54 | 1043.53 | 1043.53 | 1055.81 | budget       | Midway Airport
092 | 19.01 | 1095.90 | 1095.90 | 1120.47 | budget       | Ohare Intl Airport
028 |  7.60 | 1183.30 | 1183.30 | 1211.85 | enterprise   | Midway Intl Arpt
029 |  7.60 | 1056.06 | 1056.06 | 1211.85 | alamo        | Midway Intl Arpt
093 | 19.06 | 1277.31 | 1277.31 | 1240.85 | alamo        | Chicago Ohare Airport
025 |  7.54 | 1232.59 | 1232.59 | 1256.79 | avis         | Chicago Midway Intl Airport
099 | 19.79 | 1277.34 | 1277.34 | 1310.01 | enterprise   | Ohare Intl Arpt
091 | 19.01 | 1300.73 | 1300.73 | 1316.95 | avis         | Chicago Ohare Intl Airport
266 | 81.05 | 1209.52 | 1269.39 | 1332.77 | alamo        | Milwaukee Intl Arpt
"""