Loading data in MongoDB is very straightforward. However, making that data easily and quickly usable can be tricky.
We first connect to to local MongoDB server. mongolite automatically connects to the localhost by default. We also load the flights dataframe.
library(mongolite)
library(nycflights13)
fl1<-mongo(collection="nycflights13")We are automatically connected to the test database, if we want to connect to another we can use url=“mongodb://localhost/
fl1$count('{}')## [1] 0pt<-proc.time()
fl1$insert(flights)## List of 5
## $ nInserted : num 336776
## $ nMatched : num 0
## $ nRemoved : num 0
## $ nUpserted : num 0
## $ writeErrors: list()fl1$count('{}')## [1] 336776proc.time()-pt## user system elapsed
## 6.86 0.44 9.60This takes much longer than a .csv file or from a sql database. Searching it similarly takes some time, as the only thing indexed initially is the _id. We can index another aspect, but that takes time in its own right. Due to the size of the limits, the extended search time is harder to notice. However, without them, it would be imposible to find anything in the giant list of flights.
pt<-proc.time()
fl1$find('{"dep_delay":-1}',limit=80)## year month day dep_time sched_dep_time dep_delay arr_time
## 1 2013 1 1 544 545 -1 1004
## 2 2013 1 1 559 600 -1 941
## 3 2013 1 1 559 600 -1 854
## 4 2013 1 1 629 630 -1 824
## 5 2013 1 1 629 630 -1 721
## 6 2013 1 1 629 630 -1 824
## 7 2013 1 1 639 640 -1 739
## 8 2013 1 1 659 700 -1 1008
## 9 2013 1 1 659 700 -1 1008
## 10 2013 1 1 659 700 -1 959
## 11 2013 1 1 724 725 -1 1020
## 12 2013 1 1 729 730 -1 1049
## 13 2013 1 1 754 755 -1 1103
## 14 2013 1 1 759 800 -1 1057
## 15 2013 1 1 829 830 -1 1152
## 16 2013 1 1 829 830 -1 1117
## 17 2013 1 1 859 900 -1 1140
## 18 2013 1 1 859 900 -1 1223
## 19 2013 1 1 902 903 -1 1048
## 20 2013 1 1 959 1000 -1 1151
## 21 2013 1 1 1029 1030 -1 1427
## 22 2013 1 1 1044 1045 -1 1231
## 23 2013 1 1 1044 1045 -1 1352
## 24 2013 1 1 1059 1100 -1 1201
## 25 2013 1 1 1059 1100 -1 1210
## 26 2013 1 1 1124 1125 -1 1445
## 27 2013 1 1 1128 1129 -1 1422
## 28 2013 1 1 1130 1131 -1 1345
## 29 2013 1 1 1144 1145 -1 1422
## 30 2013 1 1 1157 1158 -1 1310
## 31 2013 1 1 1217 1218 -1 1525
## 32 2013 1 1 1219 1220 -1 1415
## 33 2013 1 1 1251 1252 -1 1611
## 34 2013 1 1 1257 1258 -1 1601
## 35 2013 1 1 1314 1315 -1 1507
## 36 2013 1 1 1355 1356 -1 1646
## 37 2013 1 1 1418 1419 -1 1726
## 38 2013 1 1 1419 1420 -1 1557
## 39 2013 1 1 1421 1422 -1 1517
## 40 2013 1 1 1443 1444 -1 1600
## 41 2013 1 1 1449 1450 -1 1651
## 42 2013 1 1 1529 1530 -1 1733
## 43 2013 1 1 1608 1609 -1 1847
## 44 2013 1 1 1719 1720 -1 1908
## 45 2013 1 1 1739 1740 -1 2051
## 46 2013 1 1 1744 1745 -1 2055
## 47 2013 1 1 1744 1745 -1 1925
## 48 2013 1 1 1809 1810 -1 2117
## 49 2013 1 1 1814 1815 -1 2122
## 50 2013 1 1 1859 1900 -1 2012
## 51 2013 1 1 1859 1900 -1 2151
## 52 2013 1 1 1904 1905 -1 2139
## 53 2013 1 1 1904 1905 -1 2157
## 54 2013 1 1 1909 1910 -1 2212
## 55 2013 1 1 1939 1940 -1 2238
## 56 2013 1 1 1959 2000 -1 2310
## 57 2013 1 1 2033 2034 -1 2134
## 58 2013 1 2 559 600 -1 906
## 59 2013 1 2 629 630 -1 1010
## 60 2013 1 2 636 637 -1 1012
## 61 2013 1 2 659 700 -1 959
## 62 2013 1 2 704 705 -1 908
## 63 2013 1 2 714 715 -1 1026
## 64 2013 1 2 719 720 -1 1027
## 65 2013 1 2 729 730 -1 1011
## 66 2013 1 2 745 746 -1 1118
## 67 2013 1 2 754 755 -1 1055
## 68 2013 1 2 804 805 -1 1039
## 69 2013 1 2 809 810 -1 950
## 70 2013 1 2 822 823 -1 1206
## 71 2013 1 2 822 823 -1 1142
## 72 2013 1 2 829 830 -1 1154
## 73 2013 1 2 844 845 -1 1157
## 74 2013 1 2 858 859 -1 1135
## 75 2013 1 2 859 900 -1 1054
## 76 2013 1 2 859 900 -1 1204
## 77 2013 1 2 919 920 -1 1240
## 78 2013 1 2 919 920 -1 1248
## 79 2013 1 2 952 953 -1 1104
## 80 2013 1 2 1014 1015 -1 1215
## sched_arr_time arr_delay carrier flight tailnum origin dest air_time
## 1 1022 -18 B6 725 N804JB JFK BQN 183
## 2 910 31 AA 707 N3DUAA LGA DFW 257
## 3 902 -8 UA 1187 N76515 EWR LAS 337
## 4 810 14 AA 303 N3CYAA LGA ORD 140
## 5 740 -19 WN 4646 N273WN LGA BWI 40
## 6 833 -9 US 1019 N426US EWR CLT 91
## 7 749 -10 B6 1002 N805JB JFK BOS 41
## 8 1015 -7 AA 2279 N3EKAA LGA MIA 159
## 9 1007 1 B6 981 N646JB JFK FLL 156
## 10 1008 -9 UA 960 N838UA EWR RSW 164
## 11 1030 -10 AS 11 N594AS EWR SEA 338
## 12 1115 -26 VX 11 N635VA JFK SFO 356
## 13 1030 33 WN 733 N789SW LGA DEN 279
## 14 1127 -30 DL 1843 N955DL JFK MIA 158
## 15 1200 -8 UA 443 N554UA JFK LAX 360
## 16 1140 -23 UA 1592 N75425 EWR MCO 145
## 17 1204 -24 DL 1885 N360NB LGA MCO 140
## 18 1225 -2 VX 407 N846VA JFK LAX 359
## 19 1045 3 UA 580 N820UA EWR ORD 145
## 20 1206 -15 US 1177 N765US LGA CLT 90
## 21 1355 32 AA 179 N325AA JFK SFO 389
## 22 1212 19 EV 4322 N15555 EWR MKE 151
## 23 1351 1 UA 455 N667UA EWR IAH 229
## 24 1215 -14 WN 321 N505SW LGA BWI 43
## 25 1215 -5 MQ 3792 N509MQ JFK DCA 50
## 26 1445 0 DL 1171 N376NW LGA RSW 169
## 27 1437 -15 UA 987 N496UA EWR TPA 156
## 28 1342 3 DL 2219 N343NB LGA MSP 166
## 29 1411 11 EV 4876 N695CA EWR ATL 126
## 30 1315 -5 EV 4511 N16546 EWR ROC 50
## 31 1529 -4 UA 391 N573UA EWR SFO 345
## 32 1415 0 AA 1757 N545AA LGA STL 161
## 33 1555 16 B6 85 N657JB JFK FLL 173
## 34 1610 -9 B6 209 N793JB JFK LGB 346
## 35 1505 2 US 1615 N177US EWR CLT 95
## 36 1650 -4 B6 1783 N709JB JFK MCO 144
## 37 1732 -6 UA 16 N37464 EWR SEA 348
## 38 1550 7 MQ 3728 N500MQ EWR ORD 136
## 39 1535 -18 B6 1010 N274JB JFK BOS 38
## 40 1602 -2 EV 4292 N13908 EWR IAD 51
## 41 1640 11 MQ 4403 N853MQ JFK RDU 78
## 42 1737 -4 US 1665 N738US LGA CLT 103
## 43 1910 -23 B6 157 N712JB JFK MCO 137
## 44 1905 3 MQ 4479 N713MQ LGA RDU 80
## 45 2112 -21 DL 1339 N3761R JFK PDX 341
## 46 2059 -4 DL 1935 N900DE LGA TPA 160
## 47 1915 10 WN 128 N8324A LGA MDW 137
## 48 2132 -15 B6 217 N592JB JFK LGB 337
## 49 2151 -29 B6 173 N569JB JFK SJC 334
## 50 2021 -9 EV 4131 N11544 EWR RIC 55
## 51 2238 -47 DL 1967 N329NW JFK MIA 150
## 52 2227 -48 DL 2159 N3758Y JFK MCO 133
## 53 2208 -11 UA 1444 N14242 EWR TPA 150
## 54 2224 -12 DL 1629 N6710E JFK LAS 323
## 55 2240 -2 AA 1787 N3EGAA JFK TPA 158
## 56 2307 3 UA 1233 N76514 EWR IAH 232
## 57 2151 -17 UA 994 N486UA EWR BOS 35
## 58 907 -1 UA 1077 N12225 EWR MIA 157
## 59 1014 -4 US 245 N837AW EWR PHX 308
## 60 955 17 UA 1276 N38727 EWR AUS 248
## 61 1025 -26 VX 399 N626VA JFK LAX 330
## 62 913 -5 DL 831 N974DL LGA DTW 90
## 63 1035 -9 AA 825 N3BAAA JFK FLL 161
## 64 1029 -2 UA 1526 N33284 EWR RSW 168
## 65 1056 -45 DL 495 N3768 JFK SEA 309
## 66 1129 -11 UA 1668 N37287 EWR SFO 350
## 67 1059 -4 DL 2263 N361NW LGA MCO 143
## 68 1110 -31 UA 423 N528UA EWR PDX 310
## 69 948 2 B6 1051 N304JB JFK PIT 71
## 70 1135 31 UA 1218 N39728 EWR DFW 259
## 71 1143 -1 UA 1067 N73259 EWR LAX 343
## 72 1200 -6 UA 572 N525UA JFK LAX 340
## 73 1145 12 B6 59 N228JB JFK TPA 160
## 74 1145 -10 DL 1747 N665DN LGA ATL 128
## 75 1043 11 UA 448 N469UA EWR CLE 79
## 76 1220 -16 UA 667 N843UA LGA IAH 230
## 77 1245 -5 AA 721 N573AA LGA DFW 237
## 78 1240 8 AA 1589 N546AA EWR DFW 243
## 79 1110 -6 B6 600 N353JB JFK PWM 47
## 80 1210 5 US 1103 N560UW EWR CLT 104
## distance hour minute time_hour
## 1 1576 5 45 2013-01-01 19:00:00
## 2 1389 6 0 2013-01-01 20:00:00
## 3 2227 6 0 2013-01-01 20:00:00
## 4 733 6 30 2013-01-01 20:00:00
## 5 185 6 30 2013-01-01 20:00:00
## 6 529 6 30 2013-01-01 20:00:00
## 7 187 6 40 2013-01-01 20:00:00
## 8 1096 7 0 2013-01-01 21:00:00
## 9 1069 7 0 2013-01-01 21:00:00
## 10 1068 7 0 2013-01-01 21:00:00
## 11 2402 7 25 2013-01-01 21:00:00
## 12 2586 7 30 2013-01-01 21:00:00
## 13 1620 7 55 2013-01-01 21:00:00
## 14 1089 8 0 2013-01-01 22:00:00
## 15 2475 8 30 2013-01-01 22:00:00
## 16 937 8 30 2013-01-01 22:00:00
## 17 950 9 0 2013-01-01 23:00:00
## 18 2475 9 0 2013-01-01 23:00:00
## 19 719 9 3 2013-01-01 23:00:00
## 20 544 10 0 2013-01-02 00:00:00
## 21 2586 10 30 2013-01-02 00:00:00
## 22 725 10 45 2013-01-02 00:00:00
## 23 1400 10 45 2013-01-02 00:00:00
## 24 185 11 0 2013-01-02 01:00:00
## 25 213 11 0 2013-01-02 01:00:00
## 26 1080 11 25 2013-01-02 01:00:00
## 27 997 11 29 2013-01-02 01:00:00
## 28 1020 11 31 2013-01-02 01:00:00
## 29 746 11 45 2013-01-02 01:00:00
## 30 246 11 58 2013-01-02 01:00:00
## 31 2565 12 18 2013-01-02 02:00:00
## 32 888 12 20 2013-01-02 02:00:00
## 33 1069 12 52 2013-01-02 02:00:00
## 34 2465 12 58 2013-01-02 02:00:00
## 35 529 13 15 2013-01-02 03:00:00
## 36 944 13 56 2013-01-02 03:00:00
## 37 2402 14 19 2013-01-02 04:00:00
## 38 719 14 20 2013-01-02 04:00:00
## 39 187 14 22 2013-01-02 04:00:00
## 40 212 14 44 2013-01-02 04:00:00
## 41 427 14 50 2013-01-02 04:00:00
## 42 544 15 30 2013-01-02 05:00:00
## 43 944 16 9 2013-01-02 06:00:00
## 44 431 17 20 2013-01-02 07:00:00
## 45 2454 17 40 2013-01-02 07:00:00
## 46 1010 17 45 2013-01-02 07:00:00
## 47 725 17 45 2013-01-02 07:00:00
## 48 2465 18 10 2013-01-02 08:00:00
## 49 2569 18 15 2013-01-02 08:00:00
## 50 277 19 0 2013-01-02 09:00:00
## 51 1089 19 0 2013-01-02 09:00:00
## 52 944 19 5 2013-01-02 09:00:00
## 53 997 19 5 2013-01-02 09:00:00
## 54 2248 19 10 2013-01-02 09:00:00
## 55 1005 19 40 2013-01-02 09:00:00
## 56 1400 20 0 2013-01-02 10:00:00
## 57 200 20 34 2013-01-02 10:00:00
## 58 1085 6 0 2013-01-02 20:00:00
## 59 2133 6 30 2013-01-02 20:00:00
## 60 1504 6 37 2013-01-02 20:00:00
## 61 2475 7 0 2013-01-02 21:00:00
## 62 502 7 5 2013-01-02 21:00:00
## 63 1069 7 15 2013-01-02 21:00:00
## 64 1068 7 20 2013-01-02 21:00:00
## 65 2422 7 30 2013-01-02 21:00:00
## 66 2565 7 46 2013-01-02 21:00:00
## 67 950 7 55 2013-01-02 21:00:00
## 68 2434 8 5 2013-01-02 22:00:00
## 69 340 8 10 2013-01-02 22:00:00
## 70 1372 8 23 2013-01-02 22:00:00
## 71 2454 8 23 2013-01-02 22:00:00
## 72 2475 8 30 2013-01-02 22:00:00
## 73 1005 8 45 2013-01-02 22:00:00
## 74 762 8 59 2013-01-02 22:00:00
## 75 404 9 0 2013-01-02 23:00:00
## 76 1416 9 0 2013-01-02 23:00:00
## 77 1389 9 20 2013-01-02 23:00:00
## 78 1372 9 20 2013-01-02 23:00:00
## 79 273 9 53 2013-01-02 23:00:00
## 80 529 10 15 2013-01-03 00:00:00proc.time()-pt## user system elapsed
## 0.03 0.00 0.03fl1$index(add='{"dep_delay":-1}')## v key._id key.dep_delay name ns
## 1 2 1 NA _id_ test.nycflights13
## 2 2 NA -1 dep_delay_-1 test.nycflights13pt<-proc.time()
fl1$find('{"dep_delay":-1}',limit = 80)## year month day dep_time sched_dep_time dep_delay arr_time
## 1 2013 1 1 544 545 -1 1004
## 2 2013 1 1 559 600 -1 941
## 3 2013 1 1 559 600 -1 854
## 4 2013 1 1 629 630 -1 824
## 5 2013 1 1 629 630 -1 721
## 6 2013 1 1 629 630 -1 824
## 7 2013 1 1 639 640 -1 739
## 8 2013 1 1 659 700 -1 1008
## 9 2013 1 1 659 700 -1 1008
## 10 2013 1 1 659 700 -1 959
## 11 2013 1 1 724 725 -1 1020
## 12 2013 1 1 729 730 -1 1049
## 13 2013 1 1 754 755 -1 1103
## 14 2013 1 1 759 800 -1 1057
## 15 2013 1 1 829 830 -1 1152
## 16 2013 1 1 829 830 -1 1117
## 17 2013 1 1 859 900 -1 1140
## 18 2013 1 1 859 900 -1 1223
## 19 2013 1 1 902 903 -1 1048
## 20 2013 1 1 959 1000 -1 1151
## 21 2013 1 1 1029 1030 -1 1427
## 22 2013 1 1 1044 1045 -1 1231
## 23 2013 1 1 1044 1045 -1 1352
## 24 2013 1 1 1059 1100 -1 1201
## 25 2013 1 1 1059 1100 -1 1210
## 26 2013 1 1 1124 1125 -1 1445
## 27 2013 1 1 1128 1129 -1 1422
## 28 2013 1 1 1130 1131 -1 1345
## 29 2013 1 1 1144 1145 -1 1422
## 30 2013 1 1 1157 1158 -1 1310
## 31 2013 1 1 1217 1218 -1 1525
## 32 2013 1 1 1219 1220 -1 1415
## 33 2013 1 1 1251 1252 -1 1611
## 34 2013 1 1 1257 1258 -1 1601
## 35 2013 1 1 1314 1315 -1 1507
## 36 2013 1 1 1355 1356 -1 1646
## 37 2013 1 1 1418 1419 -1 1726
## 38 2013 1 1 1419 1420 -1 1557
## 39 2013 1 1 1421 1422 -1 1517
## 40 2013 1 1 1443 1444 -1 1600
## 41 2013 1 1 1449 1450 -1 1651
## 42 2013 1 1 1529 1530 -1 1733
## 43 2013 1 1 1608 1609 -1 1847
## 44 2013 1 1 1719 1720 -1 1908
## 45 2013 1 1 1739 1740 -1 2051
## 46 2013 1 1 1744 1745 -1 2055
## 47 2013 1 1 1744 1745 -1 1925
## 48 2013 1 1 1809 1810 -1 2117
## 49 2013 1 1 1814 1815 -1 2122
## 50 2013 1 1 1859 1900 -1 2012
## 51 2013 1 1 1859 1900 -1 2151
## 52 2013 1 1 1904 1905 -1 2139
## 53 2013 1 1 1904 1905 -1 2157
## 54 2013 1 1 1909 1910 -1 2212
## 55 2013 1 1 1939 1940 -1 2238
## 56 2013 1 1 1959 2000 -1 2310
## 57 2013 1 1 2033 2034 -1 2134
## 58 2013 1 2 559 600 -1 906
## 59 2013 1 2 629 630 -1 1010
## 60 2013 1 2 636 637 -1 1012
## 61 2013 1 2 659 700 -1 959
## 62 2013 1 2 704 705 -1 908
## 63 2013 1 2 714 715 -1 1026
## 64 2013 1 2 719 720 -1 1027
## 65 2013 1 2 729 730 -1 1011
## 66 2013 1 2 745 746 -1 1118
## 67 2013 1 2 754 755 -1 1055
## 68 2013 1 2 804 805 -1 1039
## 69 2013 1 2 809 810 -1 950
## 70 2013 1 2 822 823 -1 1206
## 71 2013 1 2 822 823 -1 1142
## 72 2013 1 2 829 830 -1 1154
## 73 2013 1 2 844 845 -1 1157
## 74 2013 1 2 858 859 -1 1135
## 75 2013 1 2 859 900 -1 1054
## 76 2013 1 2 859 900 -1 1204
## 77 2013 1 2 919 920 -1 1240
## 78 2013 1 2 919 920 -1 1248
## 79 2013 1 2 952 953 -1 1104
## 80 2013 1 2 1014 1015 -1 1215
## sched_arr_time arr_delay carrier flight tailnum origin dest air_time
## 1 1022 -18 B6 725 N804JB JFK BQN 183
## 2 910 31 AA 707 N3DUAA LGA DFW 257
## 3 902 -8 UA 1187 N76515 EWR LAS 337
## 4 810 14 AA 303 N3CYAA LGA ORD 140
## 5 740 -19 WN 4646 N273WN LGA BWI 40
## 6 833 -9 US 1019 N426US EWR CLT 91
## 7 749 -10 B6 1002 N805JB JFK BOS 41
## 8 1015 -7 AA 2279 N3EKAA LGA MIA 159
## 9 1007 1 B6 981 N646JB JFK FLL 156
## 10 1008 -9 UA 960 N838UA EWR RSW 164
## 11 1030 -10 AS 11 N594AS EWR SEA 338
## 12 1115 -26 VX 11 N635VA JFK SFO 356
## 13 1030 33 WN 733 N789SW LGA DEN 279
## 14 1127 -30 DL 1843 N955DL JFK MIA 158
## 15 1200 -8 UA 443 N554UA JFK LAX 360
## 16 1140 -23 UA 1592 N75425 EWR MCO 145
## 17 1204 -24 DL 1885 N360NB LGA MCO 140
## 18 1225 -2 VX 407 N846VA JFK LAX 359
## 19 1045 3 UA 580 N820UA EWR ORD 145
## 20 1206 -15 US 1177 N765US LGA CLT 90
## 21 1355 32 AA 179 N325AA JFK SFO 389
## 22 1212 19 EV 4322 N15555 EWR MKE 151
## 23 1351 1 UA 455 N667UA EWR IAH 229
## 24 1215 -14 WN 321 N505SW LGA BWI 43
## 25 1215 -5 MQ 3792 N509MQ JFK DCA 50
## 26 1445 0 DL 1171 N376NW LGA RSW 169
## 27 1437 -15 UA 987 N496UA EWR TPA 156
## 28 1342 3 DL 2219 N343NB LGA MSP 166
## 29 1411 11 EV 4876 N695CA EWR ATL 126
## 30 1315 -5 EV 4511 N16546 EWR ROC 50
## 31 1529 -4 UA 391 N573UA EWR SFO 345
## 32 1415 0 AA 1757 N545AA LGA STL 161
## 33 1555 16 B6 85 N657JB JFK FLL 173
## 34 1610 -9 B6 209 N793JB JFK LGB 346
## 35 1505 2 US 1615 N177US EWR CLT 95
## 36 1650 -4 B6 1783 N709JB JFK MCO 144
## 37 1732 -6 UA 16 N37464 EWR SEA 348
## 38 1550 7 MQ 3728 N500MQ EWR ORD 136
## 39 1535 -18 B6 1010 N274JB JFK BOS 38
## 40 1602 -2 EV 4292 N13908 EWR IAD 51
## 41 1640 11 MQ 4403 N853MQ JFK RDU 78
## 42 1737 -4 US 1665 N738US LGA CLT 103
## 43 1910 -23 B6 157 N712JB JFK MCO 137
## 44 1905 3 MQ 4479 N713MQ LGA RDU 80
## 45 2112 -21 DL 1339 N3761R JFK PDX 341
## 46 2059 -4 DL 1935 N900DE LGA TPA 160
## 47 1915 10 WN 128 N8324A LGA MDW 137
## 48 2132 -15 B6 217 N592JB JFK LGB 337
## 49 2151 -29 B6 173 N569JB JFK SJC 334
## 50 2021 -9 EV 4131 N11544 EWR RIC 55
## 51 2238 -47 DL 1967 N329NW JFK MIA 150
## 52 2227 -48 DL 2159 N3758Y JFK MCO 133
## 53 2208 -11 UA 1444 N14242 EWR TPA 150
## 54 2224 -12 DL 1629 N6710E JFK LAS 323
## 55 2240 -2 AA 1787 N3EGAA JFK TPA 158
## 56 2307 3 UA 1233 N76514 EWR IAH 232
## 57 2151 -17 UA 994 N486UA EWR BOS 35
## 58 907 -1 UA 1077 N12225 EWR MIA 157
## 59 1014 -4 US 245 N837AW EWR PHX 308
## 60 955 17 UA 1276 N38727 EWR AUS 248
## 61 1025 -26 VX 399 N626VA JFK LAX 330
## 62 913 -5 DL 831 N974DL LGA DTW 90
## 63 1035 -9 AA 825 N3BAAA JFK FLL 161
## 64 1029 -2 UA 1526 N33284 EWR RSW 168
## 65 1056 -45 DL 495 N3768 JFK SEA 309
## 66 1129 -11 UA 1668 N37287 EWR SFO 350
## 67 1059 -4 DL 2263 N361NW LGA MCO 143
## 68 1110 -31 UA 423 N528UA EWR PDX 310
## 69 948 2 B6 1051 N304JB JFK PIT 71
## 70 1135 31 UA 1218 N39728 EWR DFW 259
## 71 1143 -1 UA 1067 N73259 EWR LAX 343
## 72 1200 -6 UA 572 N525UA JFK LAX 340
## 73 1145 12 B6 59 N228JB JFK TPA 160
## 74 1145 -10 DL 1747 N665DN LGA ATL 128
## 75 1043 11 UA 448 N469UA EWR CLE 79
## 76 1220 -16 UA 667 N843UA LGA IAH 230
## 77 1245 -5 AA 721 N573AA LGA DFW 237
## 78 1240 8 AA 1589 N546AA EWR DFW 243
## 79 1110 -6 B6 600 N353JB JFK PWM 47
## 80 1210 5 US 1103 N560UW EWR CLT 104
## distance hour minute time_hour
## 1 1576 5 45 2013-01-01 19:00:00
## 2 1389 6 0 2013-01-01 20:00:00
## 3 2227 6 0 2013-01-01 20:00:00
## 4 733 6 30 2013-01-01 20:00:00
## 5 185 6 30 2013-01-01 20:00:00
## 6 529 6 30 2013-01-01 20:00:00
## 7 187 6 40 2013-01-01 20:00:00
## 8 1096 7 0 2013-01-01 21:00:00
## 9 1069 7 0 2013-01-01 21:00:00
## 10 1068 7 0 2013-01-01 21:00:00
## 11 2402 7 25 2013-01-01 21:00:00
## 12 2586 7 30 2013-01-01 21:00:00
## 13 1620 7 55 2013-01-01 21:00:00
## 14 1089 8 0 2013-01-01 22:00:00
## 15 2475 8 30 2013-01-01 22:00:00
## 16 937 8 30 2013-01-01 22:00:00
## 17 950 9 0 2013-01-01 23:00:00
## 18 2475 9 0 2013-01-01 23:00:00
## 19 719 9 3 2013-01-01 23:00:00
## 20 544 10 0 2013-01-02 00:00:00
## 21 2586 10 30 2013-01-02 00:00:00
## 22 725 10 45 2013-01-02 00:00:00
## 23 1400 10 45 2013-01-02 00:00:00
## 24 185 11 0 2013-01-02 01:00:00
## 25 213 11 0 2013-01-02 01:00:00
## 26 1080 11 25 2013-01-02 01:00:00
## 27 997 11 29 2013-01-02 01:00:00
## 28 1020 11 31 2013-01-02 01:00:00
## 29 746 11 45 2013-01-02 01:00:00
## 30 246 11 58 2013-01-02 01:00:00
## 31 2565 12 18 2013-01-02 02:00:00
## 32 888 12 20 2013-01-02 02:00:00
## 33 1069 12 52 2013-01-02 02:00:00
## 34 2465 12 58 2013-01-02 02:00:00
## 35 529 13 15 2013-01-02 03:00:00
## 36 944 13 56 2013-01-02 03:00:00
## 37 2402 14 19 2013-01-02 04:00:00
## 38 719 14 20 2013-01-02 04:00:00
## 39 187 14 22 2013-01-02 04:00:00
## 40 212 14 44 2013-01-02 04:00:00
## 41 427 14 50 2013-01-02 04:00:00
## 42 544 15 30 2013-01-02 05:00:00
## 43 944 16 9 2013-01-02 06:00:00
## 44 431 17 20 2013-01-02 07:00:00
## 45 2454 17 40 2013-01-02 07:00:00
## 46 1010 17 45 2013-01-02 07:00:00
## 47 725 17 45 2013-01-02 07:00:00
## 48 2465 18 10 2013-01-02 08:00:00
## 49 2569 18 15 2013-01-02 08:00:00
## 50 277 19 0 2013-01-02 09:00:00
## 51 1089 19 0 2013-01-02 09:00:00
## 52 944 19 5 2013-01-02 09:00:00
## 53 997 19 5 2013-01-02 09:00:00
## 54 2248 19 10 2013-01-02 09:00:00
## 55 1005 19 40 2013-01-02 09:00:00
## 56 1400 20 0 2013-01-02 10:00:00
## 57 200 20 34 2013-01-02 10:00:00
## 58 1085 6 0 2013-01-02 20:00:00
## 59 2133 6 30 2013-01-02 20:00:00
## 60 1504 6 37 2013-01-02 20:00:00
## 61 2475 7 0 2013-01-02 21:00:00
## 62 502 7 5 2013-01-02 21:00:00
## 63 1069 7 15 2013-01-02 21:00:00
## 64 1068 7 20 2013-01-02 21:00:00
## 65 2422 7 30 2013-01-02 21:00:00
## 66 2565 7 46 2013-01-02 21:00:00
## 67 950 7 55 2013-01-02 21:00:00
## 68 2434 8 5 2013-01-02 22:00:00
## 69 340 8 10 2013-01-02 22:00:00
## 70 1372 8 23 2013-01-02 22:00:00
## 71 2454 8 23 2013-01-02 22:00:00
## 72 2475 8 30 2013-01-02 22:00:00
## 73 1005 8 45 2013-01-02 22:00:00
## 74 762 8 59 2013-01-02 22:00:00
## 75 404 9 0 2013-01-02 23:00:00
## 76 1416 9 0 2013-01-02 23:00:00
## 77 1389 9 20 2013-01-02 23:00:00
## 78 1372 9 20 2013-01-02 23:00:00
## 79 273 9 53 2013-01-02 23:00:00
## 80 529 10 15 2013-01-03 00:00:00proc.time()-pt## user system elapsed
## 0 0 0Mongo seems ill suited for something like the flights database, where we are keeping track of uniform information that can easily be stored as a table. Given that each document in the database is an individual BSON item, it is best used for data that is not uniform and has much more varied items in its structure.