shipment_id,week,hub,distance_km,service,promised_minutes,actual_minutes,late,satisfaction
S0001,1,East,48.4,priority,99.3,96.1,0,4
S0002,1,East,35.7,priority,77.7,64.6,0,5
S0003,1,East,34.1,priority,75.0,68.6,0,3
S0004,1,East,44.6,priority,92.8,111.2,1,
S0005,1,East,33.7,standard,82.3,75.7,0,5
S0006,1,East,51.1,standard,111.9,106.2,0,3
S0007,1,East,29.5,standard,75.2,75.8,1,
S0008,1,East,20.3,standard,59.5,72.4,1,4
S0009,1,East,32.9,standard,80.9,66.6,0,3
S0010,1,East,20.2,standard,59.3,59.2,0,4
S0011,1,East,27.5,standard,71.8,61.9,0,4
S0012,1,East,48.5,standard,107.5,95.3,0,4
S0013,1,East,40.4,priority,85.7,77.4,0,5
S0014,1,East,50.3,standard,110.5,86.1,0,4
S0015,1,East,20.8,standard,60.4,51.5,0,4
S0016,1,West,16.1,priority,44.4,17.7,0,3
S0017,1,West,19.7,priority,50.5,37.4,0,5
S0018,1,West,16.7,priority,45.4,40.3,0,5
S0019,1,West,10.2,standard,42.3,31.2,0,4
S0020,1,West,14.7,standard,50.0,37.1,0,
S0021,1,West,21.6,priority,53.7,43.0,0,5
S0022,1,West,17.6,priority,46.9,42.7,0,4
S0023,1,West,30.4,priority,68.7,63.9,0,5
S0024,1,West,32.9,priority,72.9,59.9,0,4
S0025,1,West,23.5,priority,56.9,53.4,0,4
S0026,1,West,27.3,standard,71.4,62.1,0,4
S0027,1,West,10.2,priority,34.3,21.0,0,5
S0028,1,West,8.5,priority,31.5,25.8,0,
S0029,1,West,14.0,standard,48.8,36.5,0,3
S0030,1,West,6.3,standard,35.7,15.9,0,5
S0031,2,East,26.0,priority,61.2,56.0,0,5
S0032,2,East,22.2,standard,62.7,55.6,0,5
S0033,2,East,52.4,standard,114.1,125.1,1,3
S0034,2,East,54.8,standard,118.2,106.5,0,4
S0035,2,East,31.8,priority,71.1,56.0,0,
S0036,2,East,26.0,standard,69.2,60.8,0,5
S0037,2,East,30.2,priority,68.3,62.9,0,5
S0038,2,East,50.6,standard,111.0,95.6,0,5
S0039,2,East,28.5,standard,73.4,67.5,0,
S0040,2,East,33.3,standard,81.6,77.6,0,5
S0041,2,East,40.3,standard,93.5,92.6,0,4
S0042,2,East,45.2,priority,93.8,83.3,0,5
S0043,2,East,32.4,priority,72.1,62.8,0,4
S0044,2,East,21.6,standard,61.7,87.4,1,3
S0045,2,East,24.5,standard,66.7,57.6,0,5
S0046,2,West,13.7,priority,40.3,36.0,0,4
S0047,2,West,20.2,standard,59.3,93.1,1,4
S0048,2,West,29.5,priority,67.2,66.0,0,4
S0049,2,West,6.8,priority,28.6,25.5,0,5
S0050,2,West,16.9,standard,53.7,41.8,0,5
S0051,2,West,5.2,priority,25.8,19.1,0,4
S0052,2,West,16.5,priority,45.0,36.3,0,4
S0053,2,West,11.0,priority,35.7,27.3,0,4
S0054,2,West,25.6,standard,68.5,48.5,0,4
S0055,2,West,30.5,priority,68.8,77.5,1,
S0056,2,West,30.3,standard,76.5,58.8,0,4
S0057,2,West,8.7,standard,39.8,44.9,1,3
S0058,2,West,13.1,priority,39.3,48.5,1,4
S0059,2,West,8.0,priority,30.6,13.0,0,4
S0060,2,West,5.6,priority,26.5,21.1,0,5
S0061,3,East,54.0,priority,108.8,124.0,1,2
S0062,3,East,32.3,priority,71.9,55.6,0,3
S0063,3,East,34.8,standard,84.2,67.3,0,4
S0064,3,East,38.7,standard,90.8,104.4,1,
S0065,3,East,48.8,priority,100.0,99.6,0,5
S0066,3,East,23.9,priority,57.6,58.1,1,3
S0067,3,East,37.5,priority,80.8,63.6,0,5
S0068,3,East,27.4,standard,71.6,64.1,0,
S0069,3,East,20.4,standard,59.7,45.4,0,5
S0070,3,East,20.5,standard,59.9,54.7,0,
S0071,3,East,32.1,standard,79.6,82.4,1,1
S0072,3,East,40.4,standard,93.7,85.1,0,4
S0073,3,East,43.3,standard,98.6,79.5,0,4
S0074,3,East,43.2,standard,98.4,97.5,0,5
S0075,3,East,46.3,standard,103.7,91.4,0,5
S0076,3,West,34.6,priority,75.8,72.9,0,5
S0077,3,West,13.3,standard,47.6,53.0,1,
S0078,3,West,8.2,standard,38.9,24.0,0,4
S0079,3,West,11.0,priority,35.7,17.9,0,
S0080,3,West,21.7,priority,53.9,46.9,0,4
S0081,3,West,25.4,priority,60.2,48.2,0,5
S0082,3,West,18.5,priority,48.5,43.4,0,4
S0083,3,West,21.2,priority,53.0,65.5,1,2
S0084,3,West,33.1,priority,73.3,66.8,0,4
S0085,3,West,7.7,standard,38.1,26.0,0,5
S0086,3,West,7.8,priority,30.3,20.2,0,
S0087,3,West,18.5,priority,48.5,38.7,0,5
S0088,3,West,7.9,standard,38.4,33.3,0,4
S0089,3,West,22.2,priority,54.7,68.3,1,4
S0090,3,West,29.3,standard,74.8,80.4,1,
S0091,4,East,28.4,standard,73.3,75.9,1,
S0092,4,East,20.0,standard,59.0,54.7,0,5
S0093,4,East,54.6,priority,109.8,121.6,1,
S0094,4,East,29.4,standard,75.0,80.6,1,
S0095,4,East,31.6,standard,78.7,60.2,0,
S0096,4,East,32.1,priority,71.6,70.9,0,4
S0097,4,East,44.9,standard,101.3,98.3,0,4
S0098,4,East,46.7,standard,104.4,98.5,0,3
S0099,4,East,28.2,standard,72.9,64.5,0,4
S0100,4,East,54.4,priority,109.5,121.9,1,2
S0101,4,East,34.1,priority,75.0,74.8,0,5
S0102,4,East,53.7,standard,116.3,136.8,1,
S0103,4,East,52.7,standard,114.6,105.6,0,
S0104,4,East,27.8,standard,72.3,52.3,0,3
S0105,4,East,37.3,priority,80.4,77.5,0,5
S0106,4,West,27.2,standard,71.2,71.1,0,5
S0107,4,West,27.0,priority,62.9,56.2,0,
S0108,4,West,25.9,priority,61.0,51.3,0,5
S0109,4,West,34.2,priority,75.1,78.8,1,3
S0110,4,West,7.3,priority,29.4,35.4,1,
S0111,4,West,22.5,standard,63.2,46.9,0,5
S0112,4,West,14.4,standard,49.5,39.8,0,4
S0113,4,West,9.3,priority,32.8,18.3,0,5
S0114,4,West,16.5,priority,45.0,53.2,1,
S0115,4,West,11.7,priority,36.9,29.4,0,5
S0116,4,West,28.2,standard,72.9,62.4,0,4
S0117,4,West,16.8,priority,45.6,46.5,1,
S0118,4,West,34.8,priority,76.2,68.8,0,
S0119,4,West,11.6,standard,44.7,45.1,1,
S0120,4,West,23.3,priority,56.6,68.4,1,4
S0121,5,East,25.7,standard,68.7,51.7,0,4
S0122,5,East,54.7,standard,118.0,116.2,0,3
S0123,5,East,47.8,standard,106.3,94.9,0,3
S0124,5,East,52.1,standard,113.6,99.2,0,4
S0125,5,East,41.3,priority,87.2,76.3,0,5
S0126,5,East,42.6,standard,97.4,88.4,0,4
S0127,5,East,46.8,priority,96.6,81.9,0,5
S0128,5,East,50.5,standard,110.8,100.7,0,3
S0129,5,East,33.6,priority,74.1,70.0,0,5
S0130,5,East,37.3,standard,88.4,76.9,0,4
S0131,5,East,47.4,standard,105.6,87.2,0,5
S0132,5,East,41.0,standard,94.7,94.5,0,4
S0133,5,East,53.6,priority,108.1,106.7,0,4
S0134,5,East,26.5,standard,70.0,61.2,0,4
S0135,5,East,45.3,priority,94.0,81.4,0,4
S0136,5,West,27.9,priority,64.4,66.3,1,2
S0137,5,West,24.9,standard,67.3,51.6,0,5
S0138,5,West,8.2,priority,30.9,16.8,0,5
S0139,5,West,9.3,standard,40.8,11.1,0,3
S0140,5,West,13.8,standard,48.5,68.1,1,
S0141,5,West,9.5,standard,41.1,19.9,0,5
S0142,5,West,13.7,priority,40.3,23.3,0,5
S0143,5,West,11.9,priority,37.2,32.7,0,5
S0144,5,West,14.5,priority,41.6,31.2,0,4
S0145,5,West,7.3,priority,29.4,25.6,0,5
S0146,5,West,7.1,standard,37.1,33.4,0,5
S0147,5,West,31.9,priority,71.2,67.3,0,5
S0148,5,West,26.3,priority,61.7,51.7,0,5
S0149,5,West,13.5,priority,40.0,31.2,0,5
S0150,5,West,5.7,priority,26.7,6.7,0,5
S0151,6,East,52.7,standard,114.6,122.2,1,3
S0152,6,East,50.3,priority,102.5,96.3,0,4
S0153,6,East,53.0,standard,115.1,111.1,0,5
S0154,6,East,49.8,priority,101.7,90.2,0,5
S0155,6,East,37.8,standard,89.3,82.8,0,5
S0156,6,East,45.8,standard,102.9,92.1,0,4
S0157,6,East,24.4,standard,66.5,42.4,0,4
S0158,6,East,23.2,standard,64.4,61.1,0,4
S0159,6,East,23.7,standard,65.3,59.7,0,4
S0160,6,East,35.1,standard,84.7,79.7,0,4
S0161,6,East,24.3,priority,58.3,51.0,0,3
S0162,6,East,52.5,priority,106.2,124.1,1,2
S0163,6,East,23.1,standard,64.3,48.4,0,4
S0164,6,East,20.1,standard,59.2,54.6,0,4
S0165,6,East,46.6,priority,96.2,84.4,0,5
S0166,6,West,28.7,standard,73.8,51.9,0,4
S0167,6,West,29.4,priority,67.0,56.6,0,3
S0168,6,West,28.5,standard,73.4,70.8,0,5
S0169,6,West,20.2,priority,51.3,70.6,1,
S0170,6,West,7.9,standard,38.4,35.9,0,4
S0171,6,West,16.9,priority,45.7,36.3,0,4
S0172,6,West,28.2,standard,72.9,72.8,0,4
S0173,6,West,20.5,priority,51.9,36.0,0,3
S0174,6,West,11.6,priority,36.7,39.1,1,2
S0175,6,West,9.0,priority,32.3,38.6,1,4
S0176,6,West,8.6,standard,39.6,31.4,0,
S0177,6,West,30.1,priority,68.2,72.9,1,2
S0178,6,West,26.0,priority,61.2,60.2,0,4
S0179,6,West,28.9,priority,66.1,63.7,0,
S0180,6,West,6.3,priority,27.7,16.0,0,4
S0181,7,East,35.2,priority,76.8,77.7,1,3
S0182,7,East,26.7,standard,70.4,51.5,0,4
S0183,7,East,46.6,standard,104.2,89.0,0,5
S0184,7,East,20.2,standard,59.3,59.1,0,4
S0185,7,East,36.5,priority,79.0,81.5,1,
S0186,7,East,42.7,standard,97.6,106.9,1,3
S0187,7,East,26.6,priority,62.2,62.4,1,
S0188,7,East,31.8,standard,79.1,71.1,0,5
S0189,7,East,51.8,standard,113.1,103.2,0,
S0190,7,East,34.7,standard,84.0,74.8,0,4
S0191,7,East,26.2,priority,61.5,61.6,1,4
S0192,7,East,32.0,standard,79.4,52.9,0,4
S0193,7,East,21.3,priority,53.2,54.4,1,3
S0194,7,East,35.2,standard,84.8,67.4,0,3
S0195,7,East,37.6,standard,88.9,78.8,0,4
S0196,7,West,19.9,priority,50.8,77.0,1,
S0197,7,West,24.7,priority,59.0,64.5,1,4
S0198,7,West,33.5,standard,81.9,77.1,0,5
S0199,7,West,34.4,priority,75.5,61.1,0,5
S0200,7,West,24.2,priority,58.1,55.6,0,3
S0201,7,West,6.7,priority,28.4,18.1,0,4
S0202,7,West,14.6,priority,41.8,30.6,0,5
S0203,7,West,18.3,standard,56.1,42.5,0,4
S0204,7,West,24.6,priority,58.8,75.3,1,3
S0205,7,West,34.6,standard,83.8,71.2,0,5
S0206,7,West,8.4,standard,39.3,37.0,0,4
S0207,7,West,15.5,priority,43.3,37.2,0,5
S0208,7,West,32.6,standard,80.4,70.2,0,4
S0209,7,West,27.8,priority,64.3,59.1,0,5
S0210,7,West,26.6,priority,62.2,58.4,0,5
S0211,8,East,44.4,standard,100.5,93.6,0,
S0212,8,East,23.4,priority,56.8,50.3,0,5
S0213,8,East,43.5,priority,91.0,87.9,0,3
S0214,8,East,53.7,priority,108.3,109.8,1,4
S0215,8,East,26.6,standard,70.2,59.5,0,5
S0216,8,East,39.5,standard,92.1,86.6,0,5
S0217,8,East,32.2,standard,79.7,76.5,0,
S0218,8,East,45.5,standard,102.3,124.5,1,
S0219,8,East,24.2,standard,66.1,62.4,0,5
S0220,8,East,35.6,priority,77.5,69.7,0,4
S0221,8,East,24.5,standard,66.7,69.0,1,3
S0222,8,East,29.0,standard,74.3,72.2,0,4
S0223,8,East,46.7,priority,96.4,87.5,0,
S0224,8,East,23.5,standard,64.9,63.7,0,4
S0225,8,East,38.7,standard,90.8,79.8,0,4
S0226,8,West,10.5,standard,42.8,48.9,1,4
S0227,8,West,23.3,priority,56.6,46.1,0,
S0228,8,West,28.9,priority,66.1,59.4,0,4
S0229,8,West,16.9,priority,45.7,58.1,1,4
S0230,8,West,7.9,priority,30.4,24.8,0,3
S0231,8,West,22.2,priority,54.7,41.4,0,
S0232,8,West,20.2,priority,51.3,57.3,1,3
S0233,8,West,10.7,standard,43.2,22.1,0,5
S0234,8,West,6.0,priority,27.2,22.6,0,5
S0235,8,West,11.1,priority,35.9,24.6,0,5
S0236,8,West,30.8,priority,69.4,67.5,0,4
S0237,8,West,13.7,standard,48.3,35.2,0,
S0238,8,West,19.6,standard,58.3,52.5,0,5
S0239,8,West,28.0,priority,64.6,62.3,0,5
S0240,8,West,15.8,standard,51.9,45.5,0,4
