Skip to content

Instantly share code, notes, and snippets.

@belablotski
Last active December 12, 2015 04:21
Show Gist options
  • Save belablotski/6860a2146af2002a4c69 to your computer and use it in GitHub Desktop.
Save belablotski/6860a2146af2002a4c69 to your computer and use it in GitHub Desktop.
Parsing classic "auto-mpg" stats dataset, convert it to JSON, parallelize in Spark RDD and then create Spark DataFrame
package com.beloblotskiy.scalascratchpad.temp
/**
* Convert text to JSON.
* Parsing classic "auto-mpg" dataset: https://archive.ics.uci.edu/ml/datasets/Auto+MPG
* @author Aliaksei Belablotski
*/
object TextToJson {
val text = """18.0 8 307.0 130.0 3504. 12.0 70 1 "chevrolet chevelle malibu"
15.0 8 350.0 165.0 3693. 11.5 70 1 "buick skylark 320"
18.0 8 318.0 150.0 3436. 11.0 70 1 "plymouth satellite"
16.0 8 304.0 150.0 3433. 12.0 70 1 "amc rebel sst"
17.0 8 302.0 140.0 3449. 10.5 70 1 "ford torino"
15.0 8 429.0 198.0 4341. 10.0 70 1 "ford galaxie 500"
14.0 8 454.0 220.0 4354. 9.0 70 1 "chevrolet impala"
14.0 8 440.0 215.0 4312. 8.5 70 1 "plymouth fury iii"
14.0 8 455.0 225.0 4425. 10.0 70 1 "pontiac catalina"
15.0 8 390.0 190.0 3850. 8.5 70 1 "amc ambassador dpl"
15.0 8 383.0 170.0 3563. 10.0 70 1 "dodge challenger se"
14.0 8 340.0 160.0 3609. 8.0 70 1 "plymouth 'cuda 340"
15.0 8 400.0 150.0 3761. 9.5 70 1 "chevrolet monte carlo"
14.0 8 455.0 225.0 3086. 10.0 70 1 "buick estate wagon (sw)"
24.0 4 113.0 95.00 2372. 15.0 70 3 "toyota corona mark ii"
22.0 6 198.0 95.00 2833. 15.5 70 1 "plymouth duster"
18.0 6 199.0 97.00 2774. 15.5 70 1 "amc hornet"
21.0 6 200.0 85.00 2587. 16.0 70 1 "ford maverick"
27.0 4 97.00 88.00 2130. 14.5 70 3 "datsun pl510"
26.0 4 97.00 46.00 1835. 20.5 70 2 "volkswagen 1131 deluxe sedan"
25.0 4 110.0 87.00 2672. 17.5 70 2 "peugeot 504"
24.0 4 107.0 90.00 2430. 14.5 70 2 "audi 100 ls"
25.0 4 104.0 95.00 2375. 17.5 70 2 "saab 99e"
26.0 4 121.0 113.0 2234. 12.5 70 2 "bmw 2002"
21.0 6 199.0 90.00 2648. 15.0 70 1 "amc gremlin"
10.0 8 360.0 215.0 4615. 14.0 70 1 "ford f250"
10.0 8 307.0 200.0 4376. 15.0 70 1 "chevy c20"
11.0 8 318.0 210.0 4382. 13.5 70 1 "dodge d200"
9.0 8 304.0 193.0 4732. 18.5 70 1 "hi 1200d"
27.0 4 97.00 88.00 2130. 14.5 71 3 "datsun pl510"
28.0 4 140.0 90.00 2264. 15.5 71 1 "chevrolet vega 2300"
25.0 4 113.0 95.00 2228. 14.0 71 3 "toyota corona"
25.0 4 98.00 ? 2046. 19.0 71 1 "ford pinto"
19.0 6 232.0 100.0 2634. 13.0 71 1 "amc gremlin"
16.0 6 225.0 105.0 3439. 15.5 71 1 "plymouth satellite custom"
17.0 6 250.0 100.0 3329. 15.5 71 1 "chevrolet chevelle malibu"
19.0 6 250.0 88.00 3302. 15.5 71 1 "ford torino 500"
18.0 6 232.0 100.0 3288. 15.5 71 1 "amc matador"
14.0 8 350.0 165.0 4209. 12.0 71 1 "chevrolet impala"
14.0 8 400.0 175.0 4464. 11.5 71 1 "pontiac catalina brougham"
14.0 8 351.0 153.0 4154. 13.5 71 1 "ford galaxie 500"
14.0 8 318.0 150.0 4096. 13.0 71 1 "plymouth fury iii"
12.0 8 383.0 180.0 4955. 11.5 71 1 "dodge monaco (sw)"
13.0 8 400.0 170.0 4746. 12.0 71 1 "ford country squire (sw)"
13.0 8 400.0 175.0 5140. 12.0 71 1 "pontiac safari (sw)"
18.0 6 258.0 110.0 2962. 13.5 71 1 "amc hornet sportabout (sw)"
22.0 4 140.0 72.00 2408. 19.0 71 1 "chevrolet vega (sw)"
19.0 6 250.0 100.0 3282. 15.0 71 1 "pontiac firebird"
18.0 6 250.0 88.00 3139. 14.5 71 1 "ford mustang"
23.0 4 122.0 86.00 2220. 14.0 71 1 "mercury capri 2000"
28.0 4 116.0 90.00 2123. 14.0 71 2 "opel 1900"
30.0 4 79.00 70.00 2074. 19.5 71 2 "peugeot 304"
30.0 4 88.00 76.00 2065. 14.5 71 2 "fiat 124b"
31.0 4 71.00 65.00 1773. 19.0 71 3 "toyota corolla 1200"
35.0 4 72.00 69.00 1613. 18.0 71 3 "datsun 1200"
27.0 4 97.00 60.00 1834. 19.0 71 2 "volkswagen model 111"
26.0 4 91.00 70.00 1955. 20.5 71 1 "plymouth cricket"
24.0 4 113.0 95.00 2278. 15.5 72 3 "toyota corona hardtop"
25.0 4 97.50 80.00 2126. 17.0 72 1 "dodge colt hardtop"
23.0 4 97.00 54.00 2254. 23.5 72 2 "volkswagen type 3"
20.0 4 140.0 90.00 2408. 19.5 72 1 "chevrolet vega"
21.0 4 122.0 86.00 2226. 16.5 72 1 "ford pinto runabout"
13.0 8 350.0 165.0 4274. 12.0 72 1 "chevrolet impala"
14.0 8 400.0 175.0 4385. 12.0 72 1 "pontiac catalina"
15.0 8 318.0 150.0 4135. 13.5 72 1 "plymouth fury iii"
14.0 8 351.0 153.0 4129. 13.0 72 1 "ford galaxie 500"
17.0 8 304.0 150.0 3672. 11.5 72 1 "amc ambassador sst"
11.0 8 429.0 208.0 4633. 11.0 72 1 "mercury marquis"
13.0 8 350.0 155.0 4502. 13.5 72 1 "buick lesabre custom"
12.0 8 350.0 160.0 4456. 13.5 72 1 "oldsmobile delta 88 royale"
13.0 8 400.0 190.0 4422. 12.5 72 1 "chrysler newport royal"
19.0 3 70.00 97.00 2330. 13.5 72 3 "mazda rx2 coupe"
15.0 8 304.0 150.0 3892. 12.5 72 1 "amc matador (sw)"
13.0 8 307.0 130.0 4098. 14.0 72 1 "chevrolet chevelle concours (sw)"
13.0 8 302.0 140.0 4294. 16.0 72 1 "ford gran torino (sw)"
14.0 8 318.0 150.0 4077. 14.0 72 1 "plymouth satellite custom (sw)"
18.0 4 121.0 112.0 2933. 14.5 72 2 "volvo 145e (sw)"
22.0 4 121.0 76.00 2511. 18.0 72 2 "volkswagen 411 (sw)"
21.0 4 120.0 87.00 2979. 19.5 72 2 "peugeot 504 (sw)"
26.0 4 96.00 69.00 2189. 18.0 72 2 "renault 12 (sw)"
22.0 4 122.0 86.00 2395. 16.0 72 1 "ford pinto (sw)"
28.0 4 97.00 92.00 2288. 17.0 72 3 "datsun 510 (sw)"
23.0 4 120.0 97.00 2506. 14.5 72 3 "toyouta corona mark ii (sw)"
28.0 4 98.00 80.00 2164. 15.0 72 1 "dodge colt (sw)"
27.0 4 97.00 88.00 2100. 16.5 72 3 "toyota corolla 1600 (sw)"
13.0 8 350.0 175.0 4100. 13.0 73 1 "buick century 350"
14.0 8 304.0 150.0 3672. 11.5 73 1 "amc matador"
13.0 8 350.0 145.0 3988. 13.0 73 1 "chevrolet malibu"
14.0 8 302.0 137.0 4042. 14.5 73 1 "ford gran torino"
15.0 8 318.0 150.0 3777. 12.5 73 1 "dodge coronet custom"
12.0 8 429.0 198.0 4952. 11.5 73 1 "mercury marquis brougham"
13.0 8 400.0 150.0 4464. 12.0 73 1 "chevrolet caprice classic"
13.0 8 351.0 158.0 4363. 13.0 73 1 "ford ltd"
14.0 8 318.0 150.0 4237. 14.5 73 1 "plymouth fury gran sedan"
13.0 8 440.0 215.0 4735. 11.0 73 1 "chrysler new yorker brougham"
12.0 8 455.0 225.0 4951. 11.0 73 1 "buick electra 225 custom"
13.0 8 360.0 175.0 3821. 11.0 73 1 "amc ambassador brougham"
18.0 6 225.0 105.0 3121. 16.5 73 1 "plymouth valiant"
16.0 6 250.0 100.0 3278. 18.0 73 1 "chevrolet nova custom"
18.0 6 232.0 100.0 2945. 16.0 73 1 "amc hornet"
18.0 6 250.0 88.00 3021. 16.5 73 1 "ford maverick"
23.0 6 198.0 95.00 2904. 16.0 73 1 "plymouth duster"
26.0 4 97.00 46.00 1950. 21.0 73 2 "volkswagen super beetle"
11.0 8 400.0 150.0 4997. 14.0 73 1 "chevrolet impala"
12.0 8 400.0 167.0 4906. 12.5 73 1 "ford country"
13.0 8 360.0 170.0 4654. 13.0 73 1 "plymouth custom suburb"
12.0 8 350.0 180.0 4499. 12.5 73 1 "oldsmobile vista cruiser"
18.0 6 232.0 100.0 2789. 15.0 73 1 "amc gremlin"
20.0 4 97.00 88.00 2279. 19.0 73 3 "toyota carina"
21.0 4 140.0 72.00 2401. 19.5 73 1 "chevrolet vega"
22.0 4 108.0 94.00 2379. 16.5 73 3 "datsun 610"
18.0 3 70.00 90.00 2124. 13.5 73 3 "maxda rx3"
19.0 4 122.0 85.00 2310. 18.5 73 1 "ford pinto"
21.0 6 155.0 107.0 2472. 14.0 73 1 "mercury capri v6"
26.0 4 98.00 90.00 2265. 15.5 73 2 "fiat 124 sport coupe"
15.0 8 350.0 145.0 4082. 13.0 73 1 "chevrolet monte carlo s"
16.0 8 400.0 230.0 4278. 9.50 73 1 "pontiac grand prix"
29.0 4 68.00 49.00 1867. 19.5 73 2 "fiat 128"
24.0 4 116.0 75.00 2158. 15.5 73 2 "opel manta"
20.0 4 114.0 91.00 2582. 14.0 73 2 "audi 100ls"
19.0 4 121.0 112.0 2868. 15.5 73 2 "volvo 144ea"
15.0 8 318.0 150.0 3399. 11.0 73 1 "dodge dart custom"
24.0 4 121.0 110.0 2660. 14.0 73 2 "saab 99le"
20.0 6 156.0 122.0 2807. 13.5 73 3 "toyota mark ii"
11.0 8 350.0 180.0 3664. 11.0 73 1 "oldsmobile omega"
20.0 6 198.0 95.00 3102. 16.5 74 1 "plymouth duster"
21.0 6 200.0 ? 2875. 17.0 74 1 "ford maverick"
19.0 6 232.0 100.0 2901. 16.0 74 1 "amc hornet"
15.0 6 250.0 100.0 3336. 17.0 74 1 "chevrolet nova"
31.0 4 79.00 67.00 1950. 19.0 74 3 "datsun b210"
26.0 4 122.0 80.00 2451. 16.5 74 1 "ford pinto"
32.0 4 71.00 65.00 1836. 21.0 74 3 "toyota corolla 1200"
25.0 4 140.0 75.00 2542. 17.0 74 1 "chevrolet vega"
16.0 6 250.0 100.0 3781. 17.0 74 1 "chevrolet chevelle malibu classic"
16.0 6 258.0 110.0 3632. 18.0 74 1 "amc matador"
18.0 6 225.0 105.0 3613. 16.5 74 1 "plymouth satellite sebring"
16.0 8 302.0 140.0 4141. 14.0 74 1 "ford gran torino"
13.0 8 350.0 150.0 4699. 14.5 74 1 "buick century luxus (sw)"
14.0 8 318.0 150.0 4457. 13.5 74 1 "dodge coronet custom (sw)"
14.0 8 302.0 140.0 4638. 16.0 74 1 "ford gran torino (sw)"
14.0 8 304.0 150.0 4257. 15.5 74 1 "amc matador (sw)"
29.0 4 98.00 83.00 2219. 16.5 74 2 "audi fox"
26.0 4 79.00 67.00 1963. 15.5 74 2 "volkswagen dasher"
26.0 4 97.00 78.00 2300. 14.5 74 2 "opel manta"
31.0 4 76.00 52.00 1649. 16.5 74 3 "toyota corona"
32.0 4 83.00 61.00 2003. 19.0 74 3 "datsun 710"
28.0 4 90.00 75.00 2125. 14.5 74 1 "dodge colt"
24.0 4 90.00 75.00 2108. 15.5 74 2 "fiat 128"
26.0 4 116.0 75.00 2246. 14.0 74 2 "fiat 124 tc"
24.0 4 120.0 97.00 2489. 15.0 74 3 "honda civic"
26.0 4 108.0 93.00 2391. 15.5 74 3 "subaru"
31.0 4 79.00 67.00 2000. 16.0 74 2 "fiat x1.9"
19.0 6 225.0 95.00 3264. 16.0 75 1 "plymouth valiant custom"
18.0 6 250.0 105.0 3459. 16.0 75 1 "chevrolet nova"
15.0 6 250.0 72.00 3432. 21.0 75 1 "mercury monarch"
15.0 6 250.0 72.00 3158. 19.5 75 1 "ford maverick"
16.0 8 400.0 170.0 4668. 11.5 75 1 "pontiac catalina"
15.0 8 350.0 145.0 4440. 14.0 75 1 "chevrolet bel air"
16.0 8 318.0 150.0 4498. 14.5 75 1 "plymouth grand fury"
14.0 8 351.0 148.0 4657. 13.5 75 1 "ford ltd"
17.0 6 231.0 110.0 3907. 21.0 75 1 "buick century"
16.0 6 250.0 105.0 3897. 18.5 75 1 "chevroelt chevelle malibu"
15.0 6 258.0 110.0 3730. 19.0 75 1 "amc matador"
18.0 6 225.0 95.00 3785. 19.0 75 1 "plymouth fury"
21.0 6 231.0 110.0 3039. 15.0 75 1 "buick skyhawk"
20.0 8 262.0 110.0 3221. 13.5 75 1 "chevrolet monza 2+2"
13.0 8 302.0 129.0 3169. 12.0 75 1 "ford mustang ii"
29.0 4 97.00 75.00 2171. 16.0 75 3 "toyota corolla"
23.0 4 140.0 83.00 2639. 17.0 75 1 "ford pinto"
20.0 6 232.0 100.0 2914. 16.0 75 1 "amc gremlin"
23.0 4 140.0 78.00 2592. 18.5 75 1 "pontiac astro"
24.0 4 134.0 96.00 2702. 13.5 75 3 "toyota corona"
25.0 4 90.00 71.00 2223. 16.5 75 2 "volkswagen dasher"
24.0 4 119.0 97.00 2545. 17.0 75 3 "datsun 710"
18.0 6 171.0 97.00 2984. 14.5 75 1 "ford pinto"
29.0 4 90.00 70.00 1937. 14.0 75 2 "volkswagen rabbit"
19.0 6 232.0 90.00 3211. 17.0 75 1 "amc pacer"
23.0 4 115.0 95.00 2694. 15.0 75 2 "audi 100ls"
23.0 4 120.0 88.00 2957. 17.0 75 2 "peugeot 504"
22.0 4 121.0 98.00 2945. 14.5 75 2 "volvo 244dl"
25.0 4 121.0 115.0 2671. 13.5 75 2 "saab 99le"
33.0 4 91.00 53.00 1795. 17.5 75 3 "honda civic cvcc"
28.0 4 107.0 86.00 2464. 15.5 76 2 "fiat 131"
25.0 4 116.0 81.00 2220. 16.9 76 2 "opel 1900"
25.0 4 140.0 92.00 2572. 14.9 76 1 "capri ii"
26.0 4 98.00 79.00 2255. 17.7 76 1 "dodge colt"
27.0 4 101.0 83.00 2202. 15.3 76 2 "renault 12tl"
17.5 8 305.0 140.0 4215. 13.0 76 1 "chevrolet chevelle malibu classic"
16.0 8 318.0 150.0 4190. 13.0 76 1 "dodge coronet brougham"
15.5 8 304.0 120.0 3962. 13.9 76 1 "amc matador"
14.5 8 351.0 152.0 4215. 12.8 76 1 "ford gran torino"
22.0 6 225.0 100.0 3233. 15.4 76 1 "plymouth valiant"
22.0 6 250.0 105.0 3353. 14.5 76 1 "chevrolet nova"
24.0 6 200.0 81.00 3012. 17.6 76 1 "ford maverick"
22.5 6 232.0 90.00 3085. 17.6 76 1 "amc hornet"
29.0 4 85.00 52.00 2035. 22.2 76 1 "chevrolet chevette"
24.5 4 98.00 60.00 2164. 22.1 76 1 "chevrolet woody"
29.0 4 90.00 70.00 1937. 14.2 76 2 "vw rabbit"
33.0 4 91.00 53.00 1795. 17.4 76 3 "honda civic"
20.0 6 225.0 100.0 3651. 17.7 76 1 "dodge aspen se"
18.0 6 250.0 78.00 3574. 21.0 76 1 "ford granada ghia"
18.5 6 250.0 110.0 3645. 16.2 76 1 "pontiac ventura sj"
17.5 6 258.0 95.00 3193. 17.8 76 1 "amc pacer d/l"
29.5 4 97.00 71.00 1825. 12.2 76 2 "volkswagen rabbit"
32.0 4 85.00 70.00 1990. 17.0 76 3 "datsun b-210"
28.0 4 97.00 75.00 2155. 16.4 76 3 "toyota corolla"
26.5 4 140.0 72.00 2565. 13.6 76 1 "ford pinto"
20.0 4 130.0 102.0 3150. 15.7 76 2 "volvo 245"
13.0 8 318.0 150.0 3940. 13.2 76 1 "plymouth volare premier v8"
19.0 4 120.0 88.00 3270. 21.9 76 2 "peugeot 504"
19.0 6 156.0 108.0 2930. 15.5 76 3 "toyota mark ii"
16.5 6 168.0 120.0 3820. 16.7 76 2 "mercedes-benz 280s"
16.5 8 350.0 180.0 4380. 12.1 76 1 "cadillac seville"
13.0 8 350.0 145.0 4055. 12.0 76 1 "chevy c10"
13.0 8 302.0 130.0 3870. 15.0 76 1 "ford f108"
13.0 8 318.0 150.0 3755. 14.0 76 1 "dodge d100"
31.5 4 98.00 68.00 2045. 18.5 77 3 "honda accord cvcc"
30.0 4 111.0 80.00 2155. 14.8 77 1 "buick opel isuzu deluxe"
36.0 4 79.00 58.00 1825. 18.6 77 2 "renault 5 gtl"
25.5 4 122.0 96.00 2300. 15.5 77 1 "plymouth arrow gs"
33.5 4 85.00 70.00 1945. 16.8 77 3 "datsun f-10 hatchback"
17.5 8 305.0 145.0 3880. 12.5 77 1 "chevrolet caprice classic"
17.0 8 260.0 110.0 4060. 19.0 77 1 "oldsmobile cutlass supreme"
15.5 8 318.0 145.0 4140. 13.7 77 1 "dodge monaco brougham"
15.0 8 302.0 130.0 4295. 14.9 77 1 "mercury cougar brougham"
17.5 6 250.0 110.0 3520. 16.4 77 1 "chevrolet concours"
20.5 6 231.0 105.0 3425. 16.9 77 1 "buick skylark"
19.0 6 225.0 100.0 3630. 17.7 77 1 "plymouth volare custom"
18.5 6 250.0 98.00 3525. 19.0 77 1 "ford granada"
16.0 8 400.0 180.0 4220. 11.1 77 1 "pontiac grand prix lj"
15.5 8 350.0 170.0 4165. 11.4 77 1 "chevrolet monte carlo landau"
15.5 8 400.0 190.0 4325. 12.2 77 1 "chrysler cordoba"
16.0 8 351.0 149.0 4335. 14.5 77 1 "ford thunderbird"
29.0 4 97.00 78.00 1940. 14.5 77 2 "volkswagen rabbit custom"
24.5 4 151.0 88.00 2740. 16.0 77 1 "pontiac sunbird coupe"
26.0 4 97.00 75.00 2265. 18.2 77 3 "toyota corolla liftback"
25.5 4 140.0 89.00 2755. 15.8 77 1 "ford mustang ii 2+2"
30.5 4 98.00 63.00 2051. 17.0 77 1 "chevrolet chevette"
33.5 4 98.00 83.00 2075. 15.9 77 1 "dodge colt m/m"
30.0 4 97.00 67.00 1985. 16.4 77 3 "subaru dl"
30.5 4 97.00 78.00 2190. 14.1 77 2 "volkswagen dasher"
22.0 6 146.0 97.00 2815. 14.5 77 3 "datsun 810"
21.5 4 121.0 110.0 2600. 12.8 77 2 "bmw 320i"
21.5 3 80.00 110.0 2720. 13.5 77 3 "mazda rx-4"
43.1 4 90.00 48.00 1985. 21.5 78 2 "volkswagen rabbit custom diesel"
36.1 4 98.00 66.00 1800. 14.4 78 1 "ford fiesta"
32.8 4 78.00 52.00 1985. 19.4 78 3 "mazda glc deluxe"
39.4 4 85.00 70.00 2070. 18.6 78 3 "datsun b210 gx"
36.1 4 91.00 60.00 1800. 16.4 78 3 "honda civic cvcc"
19.9 8 260.0 110.0 3365. 15.5 78 1 "oldsmobile cutlass salon brougham"
19.4 8 318.0 140.0 3735. 13.2 78 1 "dodge diplomat"
20.2 8 302.0 139.0 3570. 12.8 78 1 "mercury monarch ghia"
19.2 6 231.0 105.0 3535. 19.2 78 1 "pontiac phoenix lj"
20.5 6 200.0 95.00 3155. 18.2 78 1 "chevrolet malibu"
20.2 6 200.0 85.00 2965. 15.8 78 1 "ford fairmont (auto)"
25.1 4 140.0 88.00 2720. 15.4 78 1 "ford fairmont (man)"
20.5 6 225.0 100.0 3430. 17.2 78 1 "plymouth volare"
19.4 6 232.0 90.00 3210. 17.2 78 1 "amc concord"
20.6 6 231.0 105.0 3380. 15.8 78 1 "buick century special"
20.8 6 200.0 85.00 3070. 16.7 78 1 "mercury zephyr"
18.6 6 225.0 110.0 3620. 18.7 78 1 "dodge aspen"
18.1 6 258.0 120.0 3410. 15.1 78 1 "amc concord d/l"
19.2 8 305.0 145.0 3425. 13.2 78 1 "chevrolet monte carlo landau"
17.7 6 231.0 165.0 3445. 13.4 78 1 "buick regal sport coupe (turbo)"
18.1 8 302.0 139.0 3205. 11.2 78 1 "ford futura"
17.5 8 318.0 140.0 4080. 13.7 78 1 "dodge magnum xe"
30.0 4 98.00 68.00 2155. 16.5 78 1 "chevrolet chevette"
27.5 4 134.0 95.00 2560. 14.2 78 3 "toyota corona"
27.2 4 119.0 97.00 2300. 14.7 78 3 "datsun 510"
30.9 4 105.0 75.00 2230. 14.5 78 1 "dodge omni"
21.1 4 134.0 95.00 2515. 14.8 78 3 "toyota celica gt liftback"
23.2 4 156.0 105.0 2745. 16.7 78 1 "plymouth sapporo"
23.8 4 151.0 85.00 2855. 17.6 78 1 "oldsmobile starfire sx"
23.9 4 119.0 97.00 2405. 14.9 78 3 "datsun 200-sx"
20.3 5 131.0 103.0 2830. 15.9 78 2 "audi 5000"
17.0 6 163.0 125.0 3140. 13.6 78 2 "volvo 264gl"
21.6 4 121.0 115.0 2795. 15.7 78 2 "saab 99gle"
16.2 6 163.0 133.0 3410. 15.8 78 2 "peugeot 604sl"
31.5 4 89.00 71.00 1990. 14.9 78 2 "volkswagen scirocco"
29.5 4 98.00 68.00 2135. 16.6 78 3 "honda accord lx"
21.5 6 231.0 115.0 3245. 15.4 79 1 "pontiac lemans v6"
19.8 6 200.0 85.00 2990. 18.2 79 1 "mercury zephyr 6"
22.3 4 140.0 88.00 2890. 17.3 79 1 "ford fairmont 4"
20.2 6 232.0 90.00 3265. 18.2 79 1 "amc concord dl 6"
20.6 6 225.0 110.0 3360. 16.6 79 1 "dodge aspen 6"
17.0 8 305.0 130.0 3840. 15.4 79 1 "chevrolet caprice classic"
17.6 8 302.0 129.0 3725. 13.4 79 1 "ford ltd landau"
16.5 8 351.0 138.0 3955. 13.2 79 1 "mercury grand marquis"
18.2 8 318.0 135.0 3830. 15.2 79 1 "dodge st. regis"
16.9 8 350.0 155.0 4360. 14.9 79 1 "buick estate wagon (sw)"
15.5 8 351.0 142.0 4054. 14.3 79 1 "ford country squire (sw)"
19.2 8 267.0 125.0 3605. 15.0 79 1 "chevrolet malibu classic (sw)"
18.5 8 360.0 150.0 3940. 13.0 79 1 "chrysler lebaron town @ country (sw)"
31.9 4 89.00 71.00 1925. 14.0 79 2 "vw rabbit custom"
34.1 4 86.00 65.00 1975. 15.2 79 3 "maxda glc deluxe"
35.7 4 98.00 80.00 1915. 14.4 79 1 "dodge colt hatchback custom"
27.4 4 121.0 80.00 2670. 15.0 79 1 "amc spirit dl"
25.4 5 183.0 77.00 3530. 20.1 79 2 "mercedes benz 300d"
23.0 8 350.0 125.0 3900. 17.4 79 1 "cadillac eldorado"
27.2 4 141.0 71.00 3190. 24.8 79 2 "peugeot 504"
23.9 8 260.0 90.00 3420. 22.2 79 1 "oldsmobile cutlass salon brougham"
34.2 4 105.0 70.00 2200. 13.2 79 1 "plymouth horizon"
34.5 4 105.0 70.00 2150. 14.9 79 1 "plymouth horizon tc3"
31.8 4 85.00 65.00 2020. 19.2 79 3 "datsun 210"
37.3 4 91.00 69.00 2130. 14.7 79 2 "fiat strada custom"
28.4 4 151.0 90.00 2670. 16.0 79 1 "buick skylark limited"
28.8 6 173.0 115.0 2595. 11.3 79 1 "chevrolet citation"
26.8 6 173.0 115.0 2700. 12.9 79 1 "oldsmobile omega brougham"
33.5 4 151.0 90.00 2556. 13.2 79 1 "pontiac phoenix"
41.5 4 98.00 76.00 2144. 14.7 80 2 "vw rabbit"
38.1 4 89.00 60.00 1968. 18.8 80 3 "toyota corolla tercel"
32.1 4 98.00 70.00 2120. 15.5 80 1 "chevrolet chevette"
37.2 4 86.00 65.00 2019. 16.4 80 3 "datsun 310"
28.0 4 151.0 90.00 2678. 16.5 80 1 "chevrolet citation"
26.4 4 140.0 88.00 2870. 18.1 80 1 "ford fairmont"
24.3 4 151.0 90.00 3003. 20.1 80 1 "amc concord"
19.1 6 225.0 90.00 3381. 18.7 80 1 "dodge aspen"
34.3 4 97.00 78.00 2188. 15.8 80 2 "audi 4000"
29.8 4 134.0 90.00 2711. 15.5 80 3 "toyota corona liftback"
31.3 4 120.0 75.00 2542. 17.5 80 3 "mazda 626"
37.0 4 119.0 92.00 2434. 15.0 80 3 "datsun 510 hatchback"
32.2 4 108.0 75.00 2265. 15.2 80 3 "toyota corolla"
46.6 4 86.00 65.00 2110. 17.9 80 3 "mazda glc"
27.9 4 156.0 105.0 2800. 14.4 80 1 "dodge colt"
40.8 4 85.00 65.00 2110. 19.2 80 3 "datsun 210"
44.3 4 90.00 48.00 2085. 21.7 80 2 "vw rabbit c (diesel)"
43.4 4 90.00 48.00 2335. 23.7 80 2 "vw dasher (diesel)"
36.4 5 121.0 67.00 2950. 19.9 80 2 "audi 5000s (diesel)"
30.0 4 146.0 67.00 3250. 21.8 80 2 "mercedes-benz 240d"
44.6 4 91.00 67.00 1850. 13.8 80 3 "honda civic 1500 gl"
40.9 4 85.00 ? 1835. 17.3 80 2 "renault lecar deluxe"
33.8 4 97.00 67.00 2145. 18.0 80 3 "subaru dl"
29.8 4 89.00 62.00 1845. 15.3 80 2 "vokswagen rabbit"
32.7 6 168.0 132.0 2910. 11.4 80 3 "datsun 280-zx"
23.7 3 70.00 100.0 2420. 12.5 80 3 "mazda rx-7 gs"
35.0 4 122.0 88.00 2500. 15.1 80 2 "triumph tr7 coupe"
23.6 4 140.0 ? 2905. 14.3 80 1 "ford mustang cobra"
32.4 4 107.0 72.00 2290. 17.0 80 3 "honda accord"
27.2 4 135.0 84.00 2490. 15.7 81 1 "plymouth reliant"
26.6 4 151.0 84.00 2635. 16.4 81 1 "buick skylark"
25.8 4 156.0 92.00 2620. 14.4 81 1 "dodge aries wagon (sw)"
23.5 6 173.0 110.0 2725. 12.6 81 1 "chevrolet citation"
30.0 4 135.0 84.00 2385. 12.9 81 1 "plymouth reliant"
39.1 4 79.00 58.00 1755. 16.9 81 3 "toyota starlet"
39.0 4 86.00 64.00 1875. 16.4 81 1 "plymouth champ"
35.1 4 81.00 60.00 1760. 16.1 81 3 "honda civic 1300"
32.3 4 97.00 67.00 2065. 17.8 81 3 "subaru"
37.0 4 85.00 65.00 1975. 19.4 81 3 "datsun 210 mpg"
37.7 4 89.00 62.00 2050. 17.3 81 3 "toyota tercel"
34.1 4 91.00 68.00 1985. 16.0 81 3 "mazda glc 4"
34.7 4 105.0 63.00 2215. 14.9 81 1 "plymouth horizon 4"
34.4 4 98.00 65.00 2045. 16.2 81 1 "ford escort 4w"
29.9 4 98.00 65.00 2380. 20.7 81 1 "ford escort 2h"
33.0 4 105.0 74.00 2190. 14.2 81 2 "volkswagen jetta"
34.5 4 100.0 ? 2320. 15.8 81 2 "renault 18i"
33.7 4 107.0 75.00 2210. 14.4 81 3 "honda prelude"
32.4 4 108.0 75.00 2350. 16.8 81 3 "toyota corolla"
32.9 4 119.0 100.0 2615. 14.8 81 3 "datsun 200sx"
31.6 4 120.0 74.00 2635. 18.3 81 3 "mazda 626"
28.1 4 141.0 80.00 3230. 20.4 81 2 "peugeot 505s turbo diesel"
30.7 6 145.0 76.00 3160. 19.6 81 2 "volvo diesel"
25.4 6 168.0 116.0 2900. 12.6 81 3 "toyota cressida"
24.2 6 146.0 120.0 2930. 13.8 81 3 "datsun 810 maxima"
22.4 6 231.0 110.0 3415. 15.8 81 1 "buick century"
26.6 8 350.0 105.0 3725. 19.0 81 1 "oldsmobile cutlass ls"
20.2 6 200.0 88.00 3060. 17.1 81 1 "ford granada gl"
17.6 6 225.0 85.00 3465. 16.6 81 1 "chrysler lebaron salon"
28.0 4 112.0 88.00 2605. 19.6 82 1 "chevrolet cavalier"
27.0 4 112.0 88.00 2640. 18.6 82 1 "chevrolet cavalier wagon"
34.0 4 112.0 88.00 2395. 18.0 82 1 "chevrolet cavalier 2-door"
31.0 4 112.0 85.00 2575. 16.2 82 1 "pontiac j2000 se hatchback"
29.0 4 135.0 84.00 2525. 16.0 82 1 "dodge aries se"
27.0 4 151.0 90.00 2735. 18.0 82 1 "pontiac phoenix"
24.0 4 140.0 92.00 2865. 16.4 82 1 "ford fairmont futura"
23.0 4 151.0 ? 3035. 20.5 82 1 "amc concord dl"
36.0 4 105.0 74.00 1980. 15.3 82 2 "volkswagen rabbit l"
37.0 4 91.00 68.00 2025. 18.2 82 3 "mazda glc custom l"
31.0 4 91.00 68.00 1970. 17.6 82 3 "mazda glc custom"
38.0 4 105.0 63.00 2125. 14.7 82 1 "plymouth horizon miser"
36.0 4 98.00 70.00 2125. 17.3 82 1 "mercury lynx l"
36.0 4 120.0 88.00 2160. 14.5 82 3 "nissan stanza xe"
36.0 4 107.0 75.00 2205. 14.5 82 3 "honda accord"
34.0 4 108.0 70.00 2245 16.9 82 3 "toyota corolla"
38.0 4 91.00 67.00 1965. 15.0 82 3 "honda civic"
32.0 4 91.00 67.00 1965. 15.7 82 3 "honda civic (auto)"
38.0 4 91.00 67.00 1995. 16.2 82 3 "datsun 310 gx"
25.0 6 181.0 110.0 2945. 16.4 82 1 "buick century limited"
38.0 6 262.0 85.00 3015. 17.0 82 1 "oldsmobile cutlass ciera (diesel)"
26.0 4 156.0 92.00 2585. 14.5 82 1 "chrysler lebaron medallion"
22.0 6 232.0 112.0 2835 14.7 82 1 "ford granada l"
32.0 4 144.0 96.00 2665. 13.9 82 3 "toyota celica gt"
36.0 4 135.0 84.00 2370. 13.0 82 1 "dodge charger 2.2"
27.0 4 151.0 90.00 2950. 17.3 82 1 "chevrolet camaro"
27.0 4 140.0 86.00 2790. 15.6 82 1 "ford mustang gl"
44.0 4 97.00 52.00 2130. 24.6 82 2 "vw pickup"
32.0 4 135.0 84.00 2295. 11.6 82 1 "dodge rampage"
28.0 4 120.0 79.00 2625. 18.6 82 1 "ford ranger"
31.0 4 119.0 82.00 2720. 19.4 82 1 "chevy s-10""""
private val colNames: Array[(String, String)] = Array(
"mpg" -> "Double", "cylinders" -> "Int", "displacement" -> "Double", "horsepower" -> "Double", "weight" -> "Double", "acceleration" -> "Double", "model year" -> "Int", "origin" -> "Int", "car name" -> "String")
def main(args: Array[String]): Unit = {
def colToJson(colInfo: (String, String), colVal: String): String = {
val (colName, colType) = colInfo
val colValFmt = if (colVal == "null")
"null"
else
colType match {
case "String" => "\"" + colVal + "\""
case "Double" => colVal.toDouble.toString()
case "Int" => colVal.toInt.toString()
case _ => assert(false)
}
s""""$colName":$colValFmt"""
}
val records: Array[Array[String]] = text.split("\n").map(_.replace("?", "null").replace("\"", "").split("\\s\\s+")) //.take(5)
assert(records.map(_.length).distinct(0) == colNames.length)
val jsonRecords = records.map(colNames.zip(_).map(x => colToJson(x._1, x._2)).reduce((x, y) => x + "," + y)).map("{" + _ + "}")
//jsonRecords.foreach(println)
val jsonToSpark = jsonRecords.map(" \"\"\"" + _ + "\"\"\"").reduce((x, y) => x + ",\n" + y)
println("val statAutoMpg = sqlContext.read.json(sc.parallelize(List(\n" + jsonToSpark + "\n)))\nstatAutoMpg.printSchema\n")
}
}
//Script for spark-shell
val statAutoMpg = sqlContext.read.json(sc.parallelize(List(
"""{"mpg":18.0,"cylinders":8,"displacement":307.0,"horsepower":130.0,"weight":3504.0,"acceleration":12.0,"model year":70,"origin":1,"car name":"chevrolet chevelle malibu"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":350.0,"horsepower":165.0,"weight":3693.0,"acceleration":11.5,"model year":70,"origin":1,"car name":"buick skylark 320"}""",
"""{"mpg":18.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":3436.0,"acceleration":11.0,"model year":70,"origin":1,"car name":"plymouth satellite"}""",
"""{"mpg":16.0,"cylinders":8,"displacement":304.0,"horsepower":150.0,"weight":3433.0,"acceleration":12.0,"model year":70,"origin":1,"car name":"amc rebel sst"}""",
"""{"mpg":17.0,"cylinders":8,"displacement":302.0,"horsepower":140.0,"weight":3449.0,"acceleration":10.5,"model year":70,"origin":1,"car name":"ford torino"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":429.0,"horsepower":198.0,"weight":4341.0,"acceleration":10.0,"model year":70,"origin":1,"car name":"ford galaxie 500"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":454.0,"horsepower":220.0,"weight":4354.0,"acceleration":9.0,"model year":70,"origin":1,"car name":"chevrolet impala"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":440.0,"horsepower":215.0,"weight":4312.0,"acceleration":8.5,"model year":70,"origin":1,"car name":"plymouth fury iii"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":455.0,"horsepower":225.0,"weight":4425.0,"acceleration":10.0,"model year":70,"origin":1,"car name":"pontiac catalina"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":390.0,"horsepower":190.0,"weight":3850.0,"acceleration":8.5,"model year":70,"origin":1,"car name":"amc ambassador dpl"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":383.0,"horsepower":170.0,"weight":3563.0,"acceleration":10.0,"model year":70,"origin":1,"car name":"dodge challenger se"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":340.0,"horsepower":160.0,"weight":3609.0,"acceleration":8.0,"model year":70,"origin":1,"car name":"plymouth 'cuda 340"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":400.0,"horsepower":150.0,"weight":3761.0,"acceleration":9.5,"model year":70,"origin":1,"car name":"chevrolet monte carlo"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":455.0,"horsepower":225.0,"weight":3086.0,"acceleration":10.0,"model year":70,"origin":1,"car name":"buick estate wagon (sw)"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":113.0,"horsepower":95.0,"weight":2372.0,"acceleration":15.0,"model year":70,"origin":3,"car name":"toyota corona mark ii"}""",
"""{"mpg":22.0,"cylinders":6,"displacement":198.0,"horsepower":95.0,"weight":2833.0,"acceleration":15.5,"model year":70,"origin":1,"car name":"plymouth duster"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":199.0,"horsepower":97.0,"weight":2774.0,"acceleration":15.5,"model year":70,"origin":1,"car name":"amc hornet"}""",
"""{"mpg":21.0,"cylinders":6,"displacement":200.0,"horsepower":85.0,"weight":2587.0,"acceleration":16.0,"model year":70,"origin":1,"car name":"ford maverick"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":97.0,"horsepower":88.0,"weight":2130.0,"acceleration":14.5,"model year":70,"origin":3,"car name":"datsun pl510"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":97.0,"horsepower":46.0,"weight":1835.0,"acceleration":20.5,"model year":70,"origin":2,"car name":"volkswagen 1131 deluxe sedan"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":110.0,"horsepower":87.0,"weight":2672.0,"acceleration":17.5,"model year":70,"origin":2,"car name":"peugeot 504"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":107.0,"horsepower":90.0,"weight":2430.0,"acceleration":14.5,"model year":70,"origin":2,"car name":"audi 100 ls"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":104.0,"horsepower":95.0,"weight":2375.0,"acceleration":17.5,"model year":70,"origin":2,"car name":"saab 99e"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":121.0,"horsepower":113.0,"weight":2234.0,"acceleration":12.5,"model year":70,"origin":2,"car name":"bmw 2002"}""",
"""{"mpg":21.0,"cylinders":6,"displacement":199.0,"horsepower":90.0,"weight":2648.0,"acceleration":15.0,"model year":70,"origin":1,"car name":"amc gremlin"}""",
"""{"mpg":10.0,"cylinders":8,"displacement":360.0,"horsepower":215.0,"weight":4615.0,"acceleration":14.0,"model year":70,"origin":1,"car name":"ford f250"}""",
"""{"mpg":10.0,"cylinders":8,"displacement":307.0,"horsepower":200.0,"weight":4376.0,"acceleration":15.0,"model year":70,"origin":1,"car name":"chevy c20"}""",
"""{"mpg":11.0,"cylinders":8,"displacement":318.0,"horsepower":210.0,"weight":4382.0,"acceleration":13.5,"model year":70,"origin":1,"car name":"dodge d200"}""",
"""{"mpg":9.0,"cylinders":8,"displacement":304.0,"horsepower":193.0,"weight":4732.0,"acceleration":18.5,"model year":70,"origin":1,"car name":"hi 1200d"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":97.0,"horsepower":88.0,"weight":2130.0,"acceleration":14.5,"model year":71,"origin":3,"car name":"datsun pl510"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":140.0,"horsepower":90.0,"weight":2264.0,"acceleration":15.5,"model year":71,"origin":1,"car name":"chevrolet vega 2300"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":113.0,"horsepower":95.0,"weight":2228.0,"acceleration":14.0,"model year":71,"origin":3,"car name":"toyota corona"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":98.0,"horsepower":null,"weight":2046.0,"acceleration":19.0,"model year":71,"origin":1,"car name":"ford pinto"}""",
"""{"mpg":19.0,"cylinders":6,"displacement":232.0,"horsepower":100.0,"weight":2634.0,"acceleration":13.0,"model year":71,"origin":1,"car name":"amc gremlin"}""",
"""{"mpg":16.0,"cylinders":6,"displacement":225.0,"horsepower":105.0,"weight":3439.0,"acceleration":15.5,"model year":71,"origin":1,"car name":"plymouth satellite custom"}""",
"""{"mpg":17.0,"cylinders":6,"displacement":250.0,"horsepower":100.0,"weight":3329.0,"acceleration":15.5,"model year":71,"origin":1,"car name":"chevrolet chevelle malibu"}""",
"""{"mpg":19.0,"cylinders":6,"displacement":250.0,"horsepower":88.0,"weight":3302.0,"acceleration":15.5,"model year":71,"origin":1,"car name":"ford torino 500"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":232.0,"horsepower":100.0,"weight":3288.0,"acceleration":15.5,"model year":71,"origin":1,"car name":"amc matador"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":350.0,"horsepower":165.0,"weight":4209.0,"acceleration":12.0,"model year":71,"origin":1,"car name":"chevrolet impala"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":400.0,"horsepower":175.0,"weight":4464.0,"acceleration":11.5,"model year":71,"origin":1,"car name":"pontiac catalina brougham"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":351.0,"horsepower":153.0,"weight":4154.0,"acceleration":13.5,"model year":71,"origin":1,"car name":"ford galaxie 500"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":4096.0,"acceleration":13.0,"model year":71,"origin":1,"car name":"plymouth fury iii"}""",
"""{"mpg":12.0,"cylinders":8,"displacement":383.0,"horsepower":180.0,"weight":4955.0,"acceleration":11.5,"model year":71,"origin":1,"car name":"dodge monaco (sw)"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":400.0,"horsepower":170.0,"weight":4746.0,"acceleration":12.0,"model year":71,"origin":1,"car name":"ford country squire (sw)"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":400.0,"horsepower":175.0,"weight":5140.0,"acceleration":12.0,"model year":71,"origin":1,"car name":"pontiac safari (sw)"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":258.0,"horsepower":110.0,"weight":2962.0,"acceleration":13.5,"model year":71,"origin":1,"car name":"amc hornet sportabout (sw)"}""",
"""{"mpg":22.0,"cylinders":4,"displacement":140.0,"horsepower":72.0,"weight":2408.0,"acceleration":19.0,"model year":71,"origin":1,"car name":"chevrolet vega (sw)"}""",
"""{"mpg":19.0,"cylinders":6,"displacement":250.0,"horsepower":100.0,"weight":3282.0,"acceleration":15.0,"model year":71,"origin":1,"car name":"pontiac firebird"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":250.0,"horsepower":88.0,"weight":3139.0,"acceleration":14.5,"model year":71,"origin":1,"car name":"ford mustang"}""",
"""{"mpg":23.0,"cylinders":4,"displacement":122.0,"horsepower":86.0,"weight":2220.0,"acceleration":14.0,"model year":71,"origin":1,"car name":"mercury capri 2000"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":116.0,"horsepower":90.0,"weight":2123.0,"acceleration":14.0,"model year":71,"origin":2,"car name":"opel 1900"}""",
"""{"mpg":30.0,"cylinders":4,"displacement":79.0,"horsepower":70.0,"weight":2074.0,"acceleration":19.5,"model year":71,"origin":2,"car name":"peugeot 304"}""",
"""{"mpg":30.0,"cylinders":4,"displacement":88.0,"horsepower":76.0,"weight":2065.0,"acceleration":14.5,"model year":71,"origin":2,"car name":"fiat 124b"}""",
"""{"mpg":31.0,"cylinders":4,"displacement":71.0,"horsepower":65.0,"weight":1773.0,"acceleration":19.0,"model year":71,"origin":3,"car name":"toyota corolla 1200"}""",
"""{"mpg":35.0,"cylinders":4,"displacement":72.0,"horsepower":69.0,"weight":1613.0,"acceleration":18.0,"model year":71,"origin":3,"car name":"datsun 1200"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":97.0,"horsepower":60.0,"weight":1834.0,"acceleration":19.0,"model year":71,"origin":2,"car name":"volkswagen model 111"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":91.0,"horsepower":70.0,"weight":1955.0,"acceleration":20.5,"model year":71,"origin":1,"car name":"plymouth cricket"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":113.0,"horsepower":95.0,"weight":2278.0,"acceleration":15.5,"model year":72,"origin":3,"car name":"toyota corona hardtop"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":97.5,"horsepower":80.0,"weight":2126.0,"acceleration":17.0,"model year":72,"origin":1,"car name":"dodge colt hardtop"}""",
"""{"mpg":23.0,"cylinders":4,"displacement":97.0,"horsepower":54.0,"weight":2254.0,"acceleration":23.5,"model year":72,"origin":2,"car name":"volkswagen type 3"}""",
"""{"mpg":20.0,"cylinders":4,"displacement":140.0,"horsepower":90.0,"weight":2408.0,"acceleration":19.5,"model year":72,"origin":1,"car name":"chevrolet vega"}""",
"""{"mpg":21.0,"cylinders":4,"displacement":122.0,"horsepower":86.0,"weight":2226.0,"acceleration":16.5,"model year":72,"origin":1,"car name":"ford pinto runabout"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":350.0,"horsepower":165.0,"weight":4274.0,"acceleration":12.0,"model year":72,"origin":1,"car name":"chevrolet impala"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":400.0,"horsepower":175.0,"weight":4385.0,"acceleration":12.0,"model year":72,"origin":1,"car name":"pontiac catalina"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":4135.0,"acceleration":13.5,"model year":72,"origin":1,"car name":"plymouth fury iii"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":351.0,"horsepower":153.0,"weight":4129.0,"acceleration":13.0,"model year":72,"origin":1,"car name":"ford galaxie 500"}""",
"""{"mpg":17.0,"cylinders":8,"displacement":304.0,"horsepower":150.0,"weight":3672.0,"acceleration":11.5,"model year":72,"origin":1,"car name":"amc ambassador sst"}""",
"""{"mpg":11.0,"cylinders":8,"displacement":429.0,"horsepower":208.0,"weight":4633.0,"acceleration":11.0,"model year":72,"origin":1,"car name":"mercury marquis"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":350.0,"horsepower":155.0,"weight":4502.0,"acceleration":13.5,"model year":72,"origin":1,"car name":"buick lesabre custom"}""",
"""{"mpg":12.0,"cylinders":8,"displacement":350.0,"horsepower":160.0,"weight":4456.0,"acceleration":13.5,"model year":72,"origin":1,"car name":"oldsmobile delta 88 royale"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":400.0,"horsepower":190.0,"weight":4422.0,"acceleration":12.5,"model year":72,"origin":1,"car name":"chrysler newport royal"}""",
"""{"mpg":19.0,"cylinders":3,"displacement":70.0,"horsepower":97.0,"weight":2330.0,"acceleration":13.5,"model year":72,"origin":3,"car name":"mazda rx2 coupe"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":304.0,"horsepower":150.0,"weight":3892.0,"acceleration":12.5,"model year":72,"origin":1,"car name":"amc matador (sw)"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":307.0,"horsepower":130.0,"weight":4098.0,"acceleration":14.0,"model year":72,"origin":1,"car name":"chevrolet chevelle concours (sw)"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":302.0,"horsepower":140.0,"weight":4294.0,"acceleration":16.0,"model year":72,"origin":1,"car name":"ford gran torino (sw)"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":4077.0,"acceleration":14.0,"model year":72,"origin":1,"car name":"plymouth satellite custom (sw)"}""",
"""{"mpg":18.0,"cylinders":4,"displacement":121.0,"horsepower":112.0,"weight":2933.0,"acceleration":14.5,"model year":72,"origin":2,"car name":"volvo 145e (sw)"}""",
"""{"mpg":22.0,"cylinders":4,"displacement":121.0,"horsepower":76.0,"weight":2511.0,"acceleration":18.0,"model year":72,"origin":2,"car name":"volkswagen 411 (sw)"}""",
"""{"mpg":21.0,"cylinders":4,"displacement":120.0,"horsepower":87.0,"weight":2979.0,"acceleration":19.5,"model year":72,"origin":2,"car name":"peugeot 504 (sw)"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":96.0,"horsepower":69.0,"weight":2189.0,"acceleration":18.0,"model year":72,"origin":2,"car name":"renault 12 (sw)"}""",
"""{"mpg":22.0,"cylinders":4,"displacement":122.0,"horsepower":86.0,"weight":2395.0,"acceleration":16.0,"model year":72,"origin":1,"car name":"ford pinto (sw)"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":97.0,"horsepower":92.0,"weight":2288.0,"acceleration":17.0,"model year":72,"origin":3,"car name":"datsun 510 (sw)"}""",
"""{"mpg":23.0,"cylinders":4,"displacement":120.0,"horsepower":97.0,"weight":2506.0,"acceleration":14.5,"model year":72,"origin":3,"car name":"toyouta corona mark ii (sw)"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":98.0,"horsepower":80.0,"weight":2164.0,"acceleration":15.0,"model year":72,"origin":1,"car name":"dodge colt (sw)"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":97.0,"horsepower":88.0,"weight":2100.0,"acceleration":16.5,"model year":72,"origin":3,"car name":"toyota corolla 1600 (sw)"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":350.0,"horsepower":175.0,"weight":4100.0,"acceleration":13.0,"model year":73,"origin":1,"car name":"buick century 350"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":304.0,"horsepower":150.0,"weight":3672.0,"acceleration":11.5,"model year":73,"origin":1,"car name":"amc matador"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":350.0,"horsepower":145.0,"weight":3988.0,"acceleration":13.0,"model year":73,"origin":1,"car name":"chevrolet malibu"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":302.0,"horsepower":137.0,"weight":4042.0,"acceleration":14.5,"model year":73,"origin":1,"car name":"ford gran torino"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":3777.0,"acceleration":12.5,"model year":73,"origin":1,"car name":"dodge coronet custom"}""",
"""{"mpg":12.0,"cylinders":8,"displacement":429.0,"horsepower":198.0,"weight":4952.0,"acceleration":11.5,"model year":73,"origin":1,"car name":"mercury marquis brougham"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":400.0,"horsepower":150.0,"weight":4464.0,"acceleration":12.0,"model year":73,"origin":1,"car name":"chevrolet caprice classic"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":351.0,"horsepower":158.0,"weight":4363.0,"acceleration":13.0,"model year":73,"origin":1,"car name":"ford ltd"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":4237.0,"acceleration":14.5,"model year":73,"origin":1,"car name":"plymouth fury gran sedan"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":440.0,"horsepower":215.0,"weight":4735.0,"acceleration":11.0,"model year":73,"origin":1,"car name":"chrysler new yorker brougham"}""",
"""{"mpg":12.0,"cylinders":8,"displacement":455.0,"horsepower":225.0,"weight":4951.0,"acceleration":11.0,"model year":73,"origin":1,"car name":"buick electra 225 custom"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":360.0,"horsepower":175.0,"weight":3821.0,"acceleration":11.0,"model year":73,"origin":1,"car name":"amc ambassador brougham"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":225.0,"horsepower":105.0,"weight":3121.0,"acceleration":16.5,"model year":73,"origin":1,"car name":"plymouth valiant"}""",
"""{"mpg":16.0,"cylinders":6,"displacement":250.0,"horsepower":100.0,"weight":3278.0,"acceleration":18.0,"model year":73,"origin":1,"car name":"chevrolet nova custom"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":232.0,"horsepower":100.0,"weight":2945.0,"acceleration":16.0,"model year":73,"origin":1,"car name":"amc hornet"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":250.0,"horsepower":88.0,"weight":3021.0,"acceleration":16.5,"model year":73,"origin":1,"car name":"ford maverick"}""",
"""{"mpg":23.0,"cylinders":6,"displacement":198.0,"horsepower":95.0,"weight":2904.0,"acceleration":16.0,"model year":73,"origin":1,"car name":"plymouth duster"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":97.0,"horsepower":46.0,"weight":1950.0,"acceleration":21.0,"model year":73,"origin":2,"car name":"volkswagen super beetle"}""",
"""{"mpg":11.0,"cylinders":8,"displacement":400.0,"horsepower":150.0,"weight":4997.0,"acceleration":14.0,"model year":73,"origin":1,"car name":"chevrolet impala"}""",
"""{"mpg":12.0,"cylinders":8,"displacement":400.0,"horsepower":167.0,"weight":4906.0,"acceleration":12.5,"model year":73,"origin":1,"car name":"ford country"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":360.0,"horsepower":170.0,"weight":4654.0,"acceleration":13.0,"model year":73,"origin":1,"car name":"plymouth custom suburb"}""",
"""{"mpg":12.0,"cylinders":8,"displacement":350.0,"horsepower":180.0,"weight":4499.0,"acceleration":12.5,"model year":73,"origin":1,"car name":"oldsmobile vista cruiser"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":232.0,"horsepower":100.0,"weight":2789.0,"acceleration":15.0,"model year":73,"origin":1,"car name":"amc gremlin"}""",
"""{"mpg":20.0,"cylinders":4,"displacement":97.0,"horsepower":88.0,"weight":2279.0,"acceleration":19.0,"model year":73,"origin":3,"car name":"toyota carina"}""",
"""{"mpg":21.0,"cylinders":4,"displacement":140.0,"horsepower":72.0,"weight":2401.0,"acceleration":19.5,"model year":73,"origin":1,"car name":"chevrolet vega"}""",
"""{"mpg":22.0,"cylinders":4,"displacement":108.0,"horsepower":94.0,"weight":2379.0,"acceleration":16.5,"model year":73,"origin":3,"car name":"datsun 610"}""",
"""{"mpg":18.0,"cylinders":3,"displacement":70.0,"horsepower":90.0,"weight":2124.0,"acceleration":13.5,"model year":73,"origin":3,"car name":"maxda rx3"}""",
"""{"mpg":19.0,"cylinders":4,"displacement":122.0,"horsepower":85.0,"weight":2310.0,"acceleration":18.5,"model year":73,"origin":1,"car name":"ford pinto"}""",
"""{"mpg":21.0,"cylinders":6,"displacement":155.0,"horsepower":107.0,"weight":2472.0,"acceleration":14.0,"model year":73,"origin":1,"car name":"mercury capri v6"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":98.0,"horsepower":90.0,"weight":2265.0,"acceleration":15.5,"model year":73,"origin":2,"car name":"fiat 124 sport coupe"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":350.0,"horsepower":145.0,"weight":4082.0,"acceleration":13.0,"model year":73,"origin":1,"car name":"chevrolet monte carlo s"}""",
"""{"mpg":16.0,"cylinders":8,"displacement":400.0,"horsepower":230.0,"weight":4278.0,"acceleration":9.5,"model year":73,"origin":1,"car name":"pontiac grand prix"}""",
"""{"mpg":29.0,"cylinders":4,"displacement":68.0,"horsepower":49.0,"weight":1867.0,"acceleration":19.5,"model year":73,"origin":2,"car name":"fiat 128"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":116.0,"horsepower":75.0,"weight":2158.0,"acceleration":15.5,"model year":73,"origin":2,"car name":"opel manta"}""",
"""{"mpg":20.0,"cylinders":4,"displacement":114.0,"horsepower":91.0,"weight":2582.0,"acceleration":14.0,"model year":73,"origin":2,"car name":"audi 100ls"}""",
"""{"mpg":19.0,"cylinders":4,"displacement":121.0,"horsepower":112.0,"weight":2868.0,"acceleration":15.5,"model year":73,"origin":2,"car name":"volvo 144ea"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":3399.0,"acceleration":11.0,"model year":73,"origin":1,"car name":"dodge dart custom"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":121.0,"horsepower":110.0,"weight":2660.0,"acceleration":14.0,"model year":73,"origin":2,"car name":"saab 99le"}""",
"""{"mpg":20.0,"cylinders":6,"displacement":156.0,"horsepower":122.0,"weight":2807.0,"acceleration":13.5,"model year":73,"origin":3,"car name":"toyota mark ii"}""",
"""{"mpg":11.0,"cylinders":8,"displacement":350.0,"horsepower":180.0,"weight":3664.0,"acceleration":11.0,"model year":73,"origin":1,"car name":"oldsmobile omega"}""",
"""{"mpg":20.0,"cylinders":6,"displacement":198.0,"horsepower":95.0,"weight":3102.0,"acceleration":16.5,"model year":74,"origin":1,"car name":"plymouth duster"}""",
"""{"mpg":21.0,"cylinders":6,"displacement":200.0,"horsepower":null,"weight":2875.0,"acceleration":17.0,"model year":74,"origin":1,"car name":"ford maverick"}""",
"""{"mpg":19.0,"cylinders":6,"displacement":232.0,"horsepower":100.0,"weight":2901.0,"acceleration":16.0,"model year":74,"origin":1,"car name":"amc hornet"}""",
"""{"mpg":15.0,"cylinders":6,"displacement":250.0,"horsepower":100.0,"weight":3336.0,"acceleration":17.0,"model year":74,"origin":1,"car name":"chevrolet nova"}""",
"""{"mpg":31.0,"cylinders":4,"displacement":79.0,"horsepower":67.0,"weight":1950.0,"acceleration":19.0,"model year":74,"origin":3,"car name":"datsun b210"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":122.0,"horsepower":80.0,"weight":2451.0,"acceleration":16.5,"model year":74,"origin":1,"car name":"ford pinto"}""",
"""{"mpg":32.0,"cylinders":4,"displacement":71.0,"horsepower":65.0,"weight":1836.0,"acceleration":21.0,"model year":74,"origin":3,"car name":"toyota corolla 1200"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":140.0,"horsepower":75.0,"weight":2542.0,"acceleration":17.0,"model year":74,"origin":1,"car name":"chevrolet vega"}""",
"""{"mpg":16.0,"cylinders":6,"displacement":250.0,"horsepower":100.0,"weight":3781.0,"acceleration":17.0,"model year":74,"origin":1,"car name":"chevrolet chevelle malibu classic"}""",
"""{"mpg":16.0,"cylinders":6,"displacement":258.0,"horsepower":110.0,"weight":3632.0,"acceleration":18.0,"model year":74,"origin":1,"car name":"amc matador"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":225.0,"horsepower":105.0,"weight":3613.0,"acceleration":16.5,"model year":74,"origin":1,"car name":"plymouth satellite sebring"}""",
"""{"mpg":16.0,"cylinders":8,"displacement":302.0,"horsepower":140.0,"weight":4141.0,"acceleration":14.0,"model year":74,"origin":1,"car name":"ford gran torino"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":350.0,"horsepower":150.0,"weight":4699.0,"acceleration":14.5,"model year":74,"origin":1,"car name":"buick century luxus (sw)"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":4457.0,"acceleration":13.5,"model year":74,"origin":1,"car name":"dodge coronet custom (sw)"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":302.0,"horsepower":140.0,"weight":4638.0,"acceleration":16.0,"model year":74,"origin":1,"car name":"ford gran torino (sw)"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":304.0,"horsepower":150.0,"weight":4257.0,"acceleration":15.5,"model year":74,"origin":1,"car name":"amc matador (sw)"}""",
"""{"mpg":29.0,"cylinders":4,"displacement":98.0,"horsepower":83.0,"weight":2219.0,"acceleration":16.5,"model year":74,"origin":2,"car name":"audi fox"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":79.0,"horsepower":67.0,"weight":1963.0,"acceleration":15.5,"model year":74,"origin":2,"car name":"volkswagen dasher"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":97.0,"horsepower":78.0,"weight":2300.0,"acceleration":14.5,"model year":74,"origin":2,"car name":"opel manta"}""",
"""{"mpg":31.0,"cylinders":4,"displacement":76.0,"horsepower":52.0,"weight":1649.0,"acceleration":16.5,"model year":74,"origin":3,"car name":"toyota corona"}""",
"""{"mpg":32.0,"cylinders":4,"displacement":83.0,"horsepower":61.0,"weight":2003.0,"acceleration":19.0,"model year":74,"origin":3,"car name":"datsun 710"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":90.0,"horsepower":75.0,"weight":2125.0,"acceleration":14.5,"model year":74,"origin":1,"car name":"dodge colt"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":90.0,"horsepower":75.0,"weight":2108.0,"acceleration":15.5,"model year":74,"origin":2,"car name":"fiat 128"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":116.0,"horsepower":75.0,"weight":2246.0,"acceleration":14.0,"model year":74,"origin":2,"car name":"fiat 124 tc"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":120.0,"horsepower":97.0,"weight":2489.0,"acceleration":15.0,"model year":74,"origin":3,"car name":"honda civic"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":108.0,"horsepower":93.0,"weight":2391.0,"acceleration":15.5,"model year":74,"origin":3,"car name":"subaru"}""",
"""{"mpg":31.0,"cylinders":4,"displacement":79.0,"horsepower":67.0,"weight":2000.0,"acceleration":16.0,"model year":74,"origin":2,"car name":"fiat x1.9"}""",
"""{"mpg":19.0,"cylinders":6,"displacement":225.0,"horsepower":95.0,"weight":3264.0,"acceleration":16.0,"model year":75,"origin":1,"car name":"plymouth valiant custom"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":250.0,"horsepower":105.0,"weight":3459.0,"acceleration":16.0,"model year":75,"origin":1,"car name":"chevrolet nova"}""",
"""{"mpg":15.0,"cylinders":6,"displacement":250.0,"horsepower":72.0,"weight":3432.0,"acceleration":21.0,"model year":75,"origin":1,"car name":"mercury monarch"}""",
"""{"mpg":15.0,"cylinders":6,"displacement":250.0,"horsepower":72.0,"weight":3158.0,"acceleration":19.5,"model year":75,"origin":1,"car name":"ford maverick"}""",
"""{"mpg":16.0,"cylinders":8,"displacement":400.0,"horsepower":170.0,"weight":4668.0,"acceleration":11.5,"model year":75,"origin":1,"car name":"pontiac catalina"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":350.0,"horsepower":145.0,"weight":4440.0,"acceleration":14.0,"model year":75,"origin":1,"car name":"chevrolet bel air"}""",
"""{"mpg":16.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":4498.0,"acceleration":14.5,"model year":75,"origin":1,"car name":"plymouth grand fury"}""",
"""{"mpg":14.0,"cylinders":8,"displacement":351.0,"horsepower":148.0,"weight":4657.0,"acceleration":13.5,"model year":75,"origin":1,"car name":"ford ltd"}""",
"""{"mpg":17.0,"cylinders":6,"displacement":231.0,"horsepower":110.0,"weight":3907.0,"acceleration":21.0,"model year":75,"origin":1,"car name":"buick century"}""",
"""{"mpg":16.0,"cylinders":6,"displacement":250.0,"horsepower":105.0,"weight":3897.0,"acceleration":18.5,"model year":75,"origin":1,"car name":"chevroelt chevelle malibu"}""",
"""{"mpg":15.0,"cylinders":6,"displacement":258.0,"horsepower":110.0,"weight":3730.0,"acceleration":19.0,"model year":75,"origin":1,"car name":"amc matador"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":225.0,"horsepower":95.0,"weight":3785.0,"acceleration":19.0,"model year":75,"origin":1,"car name":"plymouth fury"}""",
"""{"mpg":21.0,"cylinders":6,"displacement":231.0,"horsepower":110.0,"weight":3039.0,"acceleration":15.0,"model year":75,"origin":1,"car name":"buick skyhawk"}""",
"""{"mpg":20.0,"cylinders":8,"displacement":262.0,"horsepower":110.0,"weight":3221.0,"acceleration":13.5,"model year":75,"origin":1,"car name":"chevrolet monza 2+2"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":302.0,"horsepower":129.0,"weight":3169.0,"acceleration":12.0,"model year":75,"origin":1,"car name":"ford mustang ii"}""",
"""{"mpg":29.0,"cylinders":4,"displacement":97.0,"horsepower":75.0,"weight":2171.0,"acceleration":16.0,"model year":75,"origin":3,"car name":"toyota corolla"}""",
"""{"mpg":23.0,"cylinders":4,"displacement":140.0,"horsepower":83.0,"weight":2639.0,"acceleration":17.0,"model year":75,"origin":1,"car name":"ford pinto"}""",
"""{"mpg":20.0,"cylinders":6,"displacement":232.0,"horsepower":100.0,"weight":2914.0,"acceleration":16.0,"model year":75,"origin":1,"car name":"amc gremlin"}""",
"""{"mpg":23.0,"cylinders":4,"displacement":140.0,"horsepower":78.0,"weight":2592.0,"acceleration":18.5,"model year":75,"origin":1,"car name":"pontiac astro"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":134.0,"horsepower":96.0,"weight":2702.0,"acceleration":13.5,"model year":75,"origin":3,"car name":"toyota corona"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":90.0,"horsepower":71.0,"weight":2223.0,"acceleration":16.5,"model year":75,"origin":2,"car name":"volkswagen dasher"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":119.0,"horsepower":97.0,"weight":2545.0,"acceleration":17.0,"model year":75,"origin":3,"car name":"datsun 710"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":171.0,"horsepower":97.0,"weight":2984.0,"acceleration":14.5,"model year":75,"origin":1,"car name":"ford pinto"}""",
"""{"mpg":29.0,"cylinders":4,"displacement":90.0,"horsepower":70.0,"weight":1937.0,"acceleration":14.0,"model year":75,"origin":2,"car name":"volkswagen rabbit"}""",
"""{"mpg":19.0,"cylinders":6,"displacement":232.0,"horsepower":90.0,"weight":3211.0,"acceleration":17.0,"model year":75,"origin":1,"car name":"amc pacer"}""",
"""{"mpg":23.0,"cylinders":4,"displacement":115.0,"horsepower":95.0,"weight":2694.0,"acceleration":15.0,"model year":75,"origin":2,"car name":"audi 100ls"}""",
"""{"mpg":23.0,"cylinders":4,"displacement":120.0,"horsepower":88.0,"weight":2957.0,"acceleration":17.0,"model year":75,"origin":2,"car name":"peugeot 504"}""",
"""{"mpg":22.0,"cylinders":4,"displacement":121.0,"horsepower":98.0,"weight":2945.0,"acceleration":14.5,"model year":75,"origin":2,"car name":"volvo 244dl"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":121.0,"horsepower":115.0,"weight":2671.0,"acceleration":13.5,"model year":75,"origin":2,"car name":"saab 99le"}""",
"""{"mpg":33.0,"cylinders":4,"displacement":91.0,"horsepower":53.0,"weight":1795.0,"acceleration":17.5,"model year":75,"origin":3,"car name":"honda civic cvcc"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":107.0,"horsepower":86.0,"weight":2464.0,"acceleration":15.5,"model year":76,"origin":2,"car name":"fiat 131"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":116.0,"horsepower":81.0,"weight":2220.0,"acceleration":16.9,"model year":76,"origin":2,"car name":"opel 1900"}""",
"""{"mpg":25.0,"cylinders":4,"displacement":140.0,"horsepower":92.0,"weight":2572.0,"acceleration":14.9,"model year":76,"origin":1,"car name":"capri ii"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":98.0,"horsepower":79.0,"weight":2255.0,"acceleration":17.7,"model year":76,"origin":1,"car name":"dodge colt"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":101.0,"horsepower":83.0,"weight":2202.0,"acceleration":15.3,"model year":76,"origin":2,"car name":"renault 12tl"}""",
"""{"mpg":17.5,"cylinders":8,"displacement":305.0,"horsepower":140.0,"weight":4215.0,"acceleration":13.0,"model year":76,"origin":1,"car name":"chevrolet chevelle malibu classic"}""",
"""{"mpg":16.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":4190.0,"acceleration":13.0,"model year":76,"origin":1,"car name":"dodge coronet brougham"}""",
"""{"mpg":15.5,"cylinders":8,"displacement":304.0,"horsepower":120.0,"weight":3962.0,"acceleration":13.9,"model year":76,"origin":1,"car name":"amc matador"}""",
"""{"mpg":14.5,"cylinders":8,"displacement":351.0,"horsepower":152.0,"weight":4215.0,"acceleration":12.8,"model year":76,"origin":1,"car name":"ford gran torino"}""",
"""{"mpg":22.0,"cylinders":6,"displacement":225.0,"horsepower":100.0,"weight":3233.0,"acceleration":15.4,"model year":76,"origin":1,"car name":"plymouth valiant"}""",
"""{"mpg":22.0,"cylinders":6,"displacement":250.0,"horsepower":105.0,"weight":3353.0,"acceleration":14.5,"model year":76,"origin":1,"car name":"chevrolet nova"}""",
"""{"mpg":24.0,"cylinders":6,"displacement":200.0,"horsepower":81.0,"weight":3012.0,"acceleration":17.6,"model year":76,"origin":1,"car name":"ford maverick"}""",
"""{"mpg":22.5,"cylinders":6,"displacement":232.0,"horsepower":90.0,"weight":3085.0,"acceleration":17.6,"model year":76,"origin":1,"car name":"amc hornet"}""",
"""{"mpg":29.0,"cylinders":4,"displacement":85.0,"horsepower":52.0,"weight":2035.0,"acceleration":22.2,"model year":76,"origin":1,"car name":"chevrolet chevette"}""",
"""{"mpg":24.5,"cylinders":4,"displacement":98.0,"horsepower":60.0,"weight":2164.0,"acceleration":22.1,"model year":76,"origin":1,"car name":"chevrolet woody"}""",
"""{"mpg":29.0,"cylinders":4,"displacement":90.0,"horsepower":70.0,"weight":1937.0,"acceleration":14.2,"model year":76,"origin":2,"car name":"vw rabbit"}""",
"""{"mpg":33.0,"cylinders":4,"displacement":91.0,"horsepower":53.0,"weight":1795.0,"acceleration":17.4,"model year":76,"origin":3,"car name":"honda civic"}""",
"""{"mpg":20.0,"cylinders":6,"displacement":225.0,"horsepower":100.0,"weight":3651.0,"acceleration":17.7,"model year":76,"origin":1,"car name":"dodge aspen se"}""",
"""{"mpg":18.0,"cylinders":6,"displacement":250.0,"horsepower":78.0,"weight":3574.0,"acceleration":21.0,"model year":76,"origin":1,"car name":"ford granada ghia"}""",
"""{"mpg":18.5,"cylinders":6,"displacement":250.0,"horsepower":110.0,"weight":3645.0,"acceleration":16.2,"model year":76,"origin":1,"car name":"pontiac ventura sj"}""",
"""{"mpg":17.5,"cylinders":6,"displacement":258.0,"horsepower":95.0,"weight":3193.0,"acceleration":17.8,"model year":76,"origin":1,"car name":"amc pacer d/l"}""",
"""{"mpg":29.5,"cylinders":4,"displacement":97.0,"horsepower":71.0,"weight":1825.0,"acceleration":12.2,"model year":76,"origin":2,"car name":"volkswagen rabbit"}""",
"""{"mpg":32.0,"cylinders":4,"displacement":85.0,"horsepower":70.0,"weight":1990.0,"acceleration":17.0,"model year":76,"origin":3,"car name":"datsun b-210"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":97.0,"horsepower":75.0,"weight":2155.0,"acceleration":16.4,"model year":76,"origin":3,"car name":"toyota corolla"}""",
"""{"mpg":26.5,"cylinders":4,"displacement":140.0,"horsepower":72.0,"weight":2565.0,"acceleration":13.6,"model year":76,"origin":1,"car name":"ford pinto"}""",
"""{"mpg":20.0,"cylinders":4,"displacement":130.0,"horsepower":102.0,"weight":3150.0,"acceleration":15.7,"model year":76,"origin":2,"car name":"volvo 245"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":3940.0,"acceleration":13.2,"model year":76,"origin":1,"car name":"plymouth volare premier v8"}""",
"""{"mpg":19.0,"cylinders":4,"displacement":120.0,"horsepower":88.0,"weight":3270.0,"acceleration":21.9,"model year":76,"origin":2,"car name":"peugeot 504"}""",
"""{"mpg":19.0,"cylinders":6,"displacement":156.0,"horsepower":108.0,"weight":2930.0,"acceleration":15.5,"model year":76,"origin":3,"car name":"toyota mark ii"}""",
"""{"mpg":16.5,"cylinders":6,"displacement":168.0,"horsepower":120.0,"weight":3820.0,"acceleration":16.7,"model year":76,"origin":2,"car name":"mercedes-benz 280s"}""",
"""{"mpg":16.5,"cylinders":8,"displacement":350.0,"horsepower":180.0,"weight":4380.0,"acceleration":12.1,"model year":76,"origin":1,"car name":"cadillac seville"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":350.0,"horsepower":145.0,"weight":4055.0,"acceleration":12.0,"model year":76,"origin":1,"car name":"chevy c10"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":302.0,"horsepower":130.0,"weight":3870.0,"acceleration":15.0,"model year":76,"origin":1,"car name":"ford f108"}""",
"""{"mpg":13.0,"cylinders":8,"displacement":318.0,"horsepower":150.0,"weight":3755.0,"acceleration":14.0,"model year":76,"origin":1,"car name":"dodge d100"}""",
"""{"mpg":31.5,"cylinders":4,"displacement":98.0,"horsepower":68.0,"weight":2045.0,"acceleration":18.5,"model year":77,"origin":3,"car name":"honda accord cvcc"}""",
"""{"mpg":30.0,"cylinders":4,"displacement":111.0,"horsepower":80.0,"weight":2155.0,"acceleration":14.8,"model year":77,"origin":1,"car name":"buick opel isuzu deluxe"}""",
"""{"mpg":36.0,"cylinders":4,"displacement":79.0,"horsepower":58.0,"weight":1825.0,"acceleration":18.6,"model year":77,"origin":2,"car name":"renault 5 gtl"}""",
"""{"mpg":25.5,"cylinders":4,"displacement":122.0,"horsepower":96.0,"weight":2300.0,"acceleration":15.5,"model year":77,"origin":1,"car name":"plymouth arrow gs"}""",
"""{"mpg":33.5,"cylinders":4,"displacement":85.0,"horsepower":70.0,"weight":1945.0,"acceleration":16.8,"model year":77,"origin":3,"car name":"datsun f-10 hatchback"}""",
"""{"mpg":17.5,"cylinders":8,"displacement":305.0,"horsepower":145.0,"weight":3880.0,"acceleration":12.5,"model year":77,"origin":1,"car name":"chevrolet caprice classic"}""",
"""{"mpg":17.0,"cylinders":8,"displacement":260.0,"horsepower":110.0,"weight":4060.0,"acceleration":19.0,"model year":77,"origin":1,"car name":"oldsmobile cutlass supreme"}""",
"""{"mpg":15.5,"cylinders":8,"displacement":318.0,"horsepower":145.0,"weight":4140.0,"acceleration":13.7,"model year":77,"origin":1,"car name":"dodge monaco brougham"}""",
"""{"mpg":15.0,"cylinders":8,"displacement":302.0,"horsepower":130.0,"weight":4295.0,"acceleration":14.9,"model year":77,"origin":1,"car name":"mercury cougar brougham"}""",
"""{"mpg":17.5,"cylinders":6,"displacement":250.0,"horsepower":110.0,"weight":3520.0,"acceleration":16.4,"model year":77,"origin":1,"car name":"chevrolet concours"}""",
"""{"mpg":20.5,"cylinders":6,"displacement":231.0,"horsepower":105.0,"weight":3425.0,"acceleration":16.9,"model year":77,"origin":1,"car name":"buick skylark"}""",
"""{"mpg":19.0,"cylinders":6,"displacement":225.0,"horsepower":100.0,"weight":3630.0,"acceleration":17.7,"model year":77,"origin":1,"car name":"plymouth volare custom"}""",
"""{"mpg":18.5,"cylinders":6,"displacement":250.0,"horsepower":98.0,"weight":3525.0,"acceleration":19.0,"model year":77,"origin":1,"car name":"ford granada"}""",
"""{"mpg":16.0,"cylinders":8,"displacement":400.0,"horsepower":180.0,"weight":4220.0,"acceleration":11.1,"model year":77,"origin":1,"car name":"pontiac grand prix lj"}""",
"""{"mpg":15.5,"cylinders":8,"displacement":350.0,"horsepower":170.0,"weight":4165.0,"acceleration":11.4,"model year":77,"origin":1,"car name":"chevrolet monte carlo landau"}""",
"""{"mpg":15.5,"cylinders":8,"displacement":400.0,"horsepower":190.0,"weight":4325.0,"acceleration":12.2,"model year":77,"origin":1,"car name":"chrysler cordoba"}""",
"""{"mpg":16.0,"cylinders":8,"displacement":351.0,"horsepower":149.0,"weight":4335.0,"acceleration":14.5,"model year":77,"origin":1,"car name":"ford thunderbird"}""",
"""{"mpg":29.0,"cylinders":4,"displacement":97.0,"horsepower":78.0,"weight":1940.0,"acceleration":14.5,"model year":77,"origin":2,"car name":"volkswagen rabbit custom"}""",
"""{"mpg":24.5,"cylinders":4,"displacement":151.0,"horsepower":88.0,"weight":2740.0,"acceleration":16.0,"model year":77,"origin":1,"car name":"pontiac sunbird coupe"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":97.0,"horsepower":75.0,"weight":2265.0,"acceleration":18.2,"model year":77,"origin":3,"car name":"toyota corolla liftback"}""",
"""{"mpg":25.5,"cylinders":4,"displacement":140.0,"horsepower":89.0,"weight":2755.0,"acceleration":15.8,"model year":77,"origin":1,"car name":"ford mustang ii 2+2"}""",
"""{"mpg":30.5,"cylinders":4,"displacement":98.0,"horsepower":63.0,"weight":2051.0,"acceleration":17.0,"model year":77,"origin":1,"car name":"chevrolet chevette"}""",
"""{"mpg":33.5,"cylinders":4,"displacement":98.0,"horsepower":83.0,"weight":2075.0,"acceleration":15.9,"model year":77,"origin":1,"car name":"dodge colt m/m"}""",
"""{"mpg":30.0,"cylinders":4,"displacement":97.0,"horsepower":67.0,"weight":1985.0,"acceleration":16.4,"model year":77,"origin":3,"car name":"subaru dl"}""",
"""{"mpg":30.5,"cylinders":4,"displacement":97.0,"horsepower":78.0,"weight":2190.0,"acceleration":14.1,"model year":77,"origin":2,"car name":"volkswagen dasher"}""",
"""{"mpg":22.0,"cylinders":6,"displacement":146.0,"horsepower":97.0,"weight":2815.0,"acceleration":14.5,"model year":77,"origin":3,"car name":"datsun 810"}""",
"""{"mpg":21.5,"cylinders":4,"displacement":121.0,"horsepower":110.0,"weight":2600.0,"acceleration":12.8,"model year":77,"origin":2,"car name":"bmw 320i"}""",
"""{"mpg":21.5,"cylinders":3,"displacement":80.0,"horsepower":110.0,"weight":2720.0,"acceleration":13.5,"model year":77,"origin":3,"car name":"mazda rx-4"}""",
"""{"mpg":43.1,"cylinders":4,"displacement":90.0,"horsepower":48.0,"weight":1985.0,"acceleration":21.5,"model year":78,"origin":2,"car name":"volkswagen rabbit custom diesel"}""",
"""{"mpg":36.1,"cylinders":4,"displacement":98.0,"horsepower":66.0,"weight":1800.0,"acceleration":14.4,"model year":78,"origin":1,"car name":"ford fiesta"}""",
"""{"mpg":32.8,"cylinders":4,"displacement":78.0,"horsepower":52.0,"weight":1985.0,"acceleration":19.4,"model year":78,"origin":3,"car name":"mazda glc deluxe"}""",
"""{"mpg":39.4,"cylinders":4,"displacement":85.0,"horsepower":70.0,"weight":2070.0,"acceleration":18.6,"model year":78,"origin":3,"car name":"datsun b210 gx"}""",
"""{"mpg":36.1,"cylinders":4,"displacement":91.0,"horsepower":60.0,"weight":1800.0,"acceleration":16.4,"model year":78,"origin":3,"car name":"honda civic cvcc"}""",
"""{"mpg":19.9,"cylinders":8,"displacement":260.0,"horsepower":110.0,"weight":3365.0,"acceleration":15.5,"model year":78,"origin":1,"car name":"oldsmobile cutlass salon brougham"}""",
"""{"mpg":19.4,"cylinders":8,"displacement":318.0,"horsepower":140.0,"weight":3735.0,"acceleration":13.2,"model year":78,"origin":1,"car name":"dodge diplomat"}""",
"""{"mpg":20.2,"cylinders":8,"displacement":302.0,"horsepower":139.0,"weight":3570.0,"acceleration":12.8,"model year":78,"origin":1,"car name":"mercury monarch ghia"}""",
"""{"mpg":19.2,"cylinders":6,"displacement":231.0,"horsepower":105.0,"weight":3535.0,"acceleration":19.2,"model year":78,"origin":1,"car name":"pontiac phoenix lj"}""",
"""{"mpg":20.5,"cylinders":6,"displacement":200.0,"horsepower":95.0,"weight":3155.0,"acceleration":18.2,"model year":78,"origin":1,"car name":"chevrolet malibu"}""",
"""{"mpg":20.2,"cylinders":6,"displacement":200.0,"horsepower":85.0,"weight":2965.0,"acceleration":15.8,"model year":78,"origin":1,"car name":"ford fairmont (auto)"}""",
"""{"mpg":25.1,"cylinders":4,"displacement":140.0,"horsepower":88.0,"weight":2720.0,"acceleration":15.4,"model year":78,"origin":1,"car name":"ford fairmont (man)"}""",
"""{"mpg":20.5,"cylinders":6,"displacement":225.0,"horsepower":100.0,"weight":3430.0,"acceleration":17.2,"model year":78,"origin":1,"car name":"plymouth volare"}""",
"""{"mpg":19.4,"cylinders":6,"displacement":232.0,"horsepower":90.0,"weight":3210.0,"acceleration":17.2,"model year":78,"origin":1,"car name":"amc concord"}""",
"""{"mpg":20.6,"cylinders":6,"displacement":231.0,"horsepower":105.0,"weight":3380.0,"acceleration":15.8,"model year":78,"origin":1,"car name":"buick century special"}""",
"""{"mpg":20.8,"cylinders":6,"displacement":200.0,"horsepower":85.0,"weight":3070.0,"acceleration":16.7,"model year":78,"origin":1,"car name":"mercury zephyr"}""",
"""{"mpg":18.6,"cylinders":6,"displacement":225.0,"horsepower":110.0,"weight":3620.0,"acceleration":18.7,"model year":78,"origin":1,"car name":"dodge aspen"}""",
"""{"mpg":18.1,"cylinders":6,"displacement":258.0,"horsepower":120.0,"weight":3410.0,"acceleration":15.1,"model year":78,"origin":1,"car name":"amc concord d/l"}""",
"""{"mpg":19.2,"cylinders":8,"displacement":305.0,"horsepower":145.0,"weight":3425.0,"acceleration":13.2,"model year":78,"origin":1,"car name":"chevrolet monte carlo landau"}""",
"""{"mpg":17.7,"cylinders":6,"displacement":231.0,"horsepower":165.0,"weight":3445.0,"acceleration":13.4,"model year":78,"origin":1,"car name":"buick regal sport coupe (turbo)"}""",
"""{"mpg":18.1,"cylinders":8,"displacement":302.0,"horsepower":139.0,"weight":3205.0,"acceleration":11.2,"model year":78,"origin":1,"car name":"ford futura"}""",
"""{"mpg":17.5,"cylinders":8,"displacement":318.0,"horsepower":140.0,"weight":4080.0,"acceleration":13.7,"model year":78,"origin":1,"car name":"dodge magnum xe"}""",
"""{"mpg":30.0,"cylinders":4,"displacement":98.0,"horsepower":68.0,"weight":2155.0,"acceleration":16.5,"model year":78,"origin":1,"car name":"chevrolet chevette"}""",
"""{"mpg":27.5,"cylinders":4,"displacement":134.0,"horsepower":95.0,"weight":2560.0,"acceleration":14.2,"model year":78,"origin":3,"car name":"toyota corona"}""",
"""{"mpg":27.2,"cylinders":4,"displacement":119.0,"horsepower":97.0,"weight":2300.0,"acceleration":14.7,"model year":78,"origin":3,"car name":"datsun 510"}""",
"""{"mpg":30.9,"cylinders":4,"displacement":105.0,"horsepower":75.0,"weight":2230.0,"acceleration":14.5,"model year":78,"origin":1,"car name":"dodge omni"}""",
"""{"mpg":21.1,"cylinders":4,"displacement":134.0,"horsepower":95.0,"weight":2515.0,"acceleration":14.8,"model year":78,"origin":3,"car name":"toyota celica gt liftback"}""",
"""{"mpg":23.2,"cylinders":4,"displacement":156.0,"horsepower":105.0,"weight":2745.0,"acceleration":16.7,"model year":78,"origin":1,"car name":"plymouth sapporo"}""",
"""{"mpg":23.8,"cylinders":4,"displacement":151.0,"horsepower":85.0,"weight":2855.0,"acceleration":17.6,"model year":78,"origin":1,"car name":"oldsmobile starfire sx"}""",
"""{"mpg":23.9,"cylinders":4,"displacement":119.0,"horsepower":97.0,"weight":2405.0,"acceleration":14.9,"model year":78,"origin":3,"car name":"datsun 200-sx"}""",
"""{"mpg":20.3,"cylinders":5,"displacement":131.0,"horsepower":103.0,"weight":2830.0,"acceleration":15.9,"model year":78,"origin":2,"car name":"audi 5000"}""",
"""{"mpg":17.0,"cylinders":6,"displacement":163.0,"horsepower":125.0,"weight":3140.0,"acceleration":13.6,"model year":78,"origin":2,"car name":"volvo 264gl"}""",
"""{"mpg":21.6,"cylinders":4,"displacement":121.0,"horsepower":115.0,"weight":2795.0,"acceleration":15.7,"model year":78,"origin":2,"car name":"saab 99gle"}""",
"""{"mpg":16.2,"cylinders":6,"displacement":163.0,"horsepower":133.0,"weight":3410.0,"acceleration":15.8,"model year":78,"origin":2,"car name":"peugeot 604sl"}""",
"""{"mpg":31.5,"cylinders":4,"displacement":89.0,"horsepower":71.0,"weight":1990.0,"acceleration":14.9,"model year":78,"origin":2,"car name":"volkswagen scirocco"}""",
"""{"mpg":29.5,"cylinders":4,"displacement":98.0,"horsepower":68.0,"weight":2135.0,"acceleration":16.6,"model year":78,"origin":3,"car name":"honda accord lx"}""",
"""{"mpg":21.5,"cylinders":6,"displacement":231.0,"horsepower":115.0,"weight":3245.0,"acceleration":15.4,"model year":79,"origin":1,"car name":"pontiac lemans v6"}""",
"""{"mpg":19.8,"cylinders":6,"displacement":200.0,"horsepower":85.0,"weight":2990.0,"acceleration":18.2,"model year":79,"origin":1,"car name":"mercury zephyr 6"}""",
"""{"mpg":22.3,"cylinders":4,"displacement":140.0,"horsepower":88.0,"weight":2890.0,"acceleration":17.3,"model year":79,"origin":1,"car name":"ford fairmont 4"}""",
"""{"mpg":20.2,"cylinders":6,"displacement":232.0,"horsepower":90.0,"weight":3265.0,"acceleration":18.2,"model year":79,"origin":1,"car name":"amc concord dl 6"}""",
"""{"mpg":20.6,"cylinders":6,"displacement":225.0,"horsepower":110.0,"weight":3360.0,"acceleration":16.6,"model year":79,"origin":1,"car name":"dodge aspen 6"}""",
"""{"mpg":17.0,"cylinders":8,"displacement":305.0,"horsepower":130.0,"weight":3840.0,"acceleration":15.4,"model year":79,"origin":1,"car name":"chevrolet caprice classic"}""",
"""{"mpg":17.6,"cylinders":8,"displacement":302.0,"horsepower":129.0,"weight":3725.0,"acceleration":13.4,"model year":79,"origin":1,"car name":"ford ltd landau"}""",
"""{"mpg":16.5,"cylinders":8,"displacement":351.0,"horsepower":138.0,"weight":3955.0,"acceleration":13.2,"model year":79,"origin":1,"car name":"mercury grand marquis"}""",
"""{"mpg":18.2,"cylinders":8,"displacement":318.0,"horsepower":135.0,"weight":3830.0,"acceleration":15.2,"model year":79,"origin":1,"car name":"dodge st. regis"}""",
"""{"mpg":16.9,"cylinders":8,"displacement":350.0,"horsepower":155.0,"weight":4360.0,"acceleration":14.9,"model year":79,"origin":1,"car name":"buick estate wagon (sw)"}""",
"""{"mpg":15.5,"cylinders":8,"displacement":351.0,"horsepower":142.0,"weight":4054.0,"acceleration":14.3,"model year":79,"origin":1,"car name":"ford country squire (sw)"}""",
"""{"mpg":19.2,"cylinders":8,"displacement":267.0,"horsepower":125.0,"weight":3605.0,"acceleration":15.0,"model year":79,"origin":1,"car name":"chevrolet malibu classic (sw)"}""",
"""{"mpg":18.5,"cylinders":8,"displacement":360.0,"horsepower":150.0,"weight":3940.0,"acceleration":13.0,"model year":79,"origin":1,"car name":"chrysler lebaron town @ country (sw)"}""",
"""{"mpg":31.9,"cylinders":4,"displacement":89.0,"horsepower":71.0,"weight":1925.0,"acceleration":14.0,"model year":79,"origin":2,"car name":"vw rabbit custom"}""",
"""{"mpg":34.1,"cylinders":4,"displacement":86.0,"horsepower":65.0,"weight":1975.0,"acceleration":15.2,"model year":79,"origin":3,"car name":"maxda glc deluxe"}""",
"""{"mpg":35.7,"cylinders":4,"displacement":98.0,"horsepower":80.0,"weight":1915.0,"acceleration":14.4,"model year":79,"origin":1,"car name":"dodge colt hatchback custom"}""",
"""{"mpg":27.4,"cylinders":4,"displacement":121.0,"horsepower":80.0,"weight":2670.0,"acceleration":15.0,"model year":79,"origin":1,"car name":"amc spirit dl"}""",
"""{"mpg":25.4,"cylinders":5,"displacement":183.0,"horsepower":77.0,"weight":3530.0,"acceleration":20.1,"model year":79,"origin":2,"car name":"mercedes benz 300d"}""",
"""{"mpg":23.0,"cylinders":8,"displacement":350.0,"horsepower":125.0,"weight":3900.0,"acceleration":17.4,"model year":79,"origin":1,"car name":"cadillac eldorado"}""",
"""{"mpg":27.2,"cylinders":4,"displacement":141.0,"horsepower":71.0,"weight":3190.0,"acceleration":24.8,"model year":79,"origin":2,"car name":"peugeot 504"}""",
"""{"mpg":23.9,"cylinders":8,"displacement":260.0,"horsepower":90.0,"weight":3420.0,"acceleration":22.2,"model year":79,"origin":1,"car name":"oldsmobile cutlass salon brougham"}""",
"""{"mpg":34.2,"cylinders":4,"displacement":105.0,"horsepower":70.0,"weight":2200.0,"acceleration":13.2,"model year":79,"origin":1,"car name":"plymouth horizon"}""",
"""{"mpg":34.5,"cylinders":4,"displacement":105.0,"horsepower":70.0,"weight":2150.0,"acceleration":14.9,"model year":79,"origin":1,"car name":"plymouth horizon tc3"}""",
"""{"mpg":31.8,"cylinders":4,"displacement":85.0,"horsepower":65.0,"weight":2020.0,"acceleration":19.2,"model year":79,"origin":3,"car name":"datsun 210"}""",
"""{"mpg":37.3,"cylinders":4,"displacement":91.0,"horsepower":69.0,"weight":2130.0,"acceleration":14.7,"model year":79,"origin":2,"car name":"fiat strada custom"}""",
"""{"mpg":28.4,"cylinders":4,"displacement":151.0,"horsepower":90.0,"weight":2670.0,"acceleration":16.0,"model year":79,"origin":1,"car name":"buick skylark limited"}""",
"""{"mpg":28.8,"cylinders":6,"displacement":173.0,"horsepower":115.0,"weight":2595.0,"acceleration":11.3,"model year":79,"origin":1,"car name":"chevrolet citation"}""",
"""{"mpg":26.8,"cylinders":6,"displacement":173.0,"horsepower":115.0,"weight":2700.0,"acceleration":12.9,"model year":79,"origin":1,"car name":"oldsmobile omega brougham"}""",
"""{"mpg":33.5,"cylinders":4,"displacement":151.0,"horsepower":90.0,"weight":2556.0,"acceleration":13.2,"model year":79,"origin":1,"car name":"pontiac phoenix"}""",
"""{"mpg":41.5,"cylinders":4,"displacement":98.0,"horsepower":76.0,"weight":2144.0,"acceleration":14.7,"model year":80,"origin":2,"car name":"vw rabbit"}""",
"""{"mpg":38.1,"cylinders":4,"displacement":89.0,"horsepower":60.0,"weight":1968.0,"acceleration":18.8,"model year":80,"origin":3,"car name":"toyota corolla tercel"}""",
"""{"mpg":32.1,"cylinders":4,"displacement":98.0,"horsepower":70.0,"weight":2120.0,"acceleration":15.5,"model year":80,"origin":1,"car name":"chevrolet chevette"}""",
"""{"mpg":37.2,"cylinders":4,"displacement":86.0,"horsepower":65.0,"weight":2019.0,"acceleration":16.4,"model year":80,"origin":3,"car name":"datsun 310"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":151.0,"horsepower":90.0,"weight":2678.0,"acceleration":16.5,"model year":80,"origin":1,"car name":"chevrolet citation"}""",
"""{"mpg":26.4,"cylinders":4,"displacement":140.0,"horsepower":88.0,"weight":2870.0,"acceleration":18.1,"model year":80,"origin":1,"car name":"ford fairmont"}""",
"""{"mpg":24.3,"cylinders":4,"displacement":151.0,"horsepower":90.0,"weight":3003.0,"acceleration":20.1,"model year":80,"origin":1,"car name":"amc concord"}""",
"""{"mpg":19.1,"cylinders":6,"displacement":225.0,"horsepower":90.0,"weight":3381.0,"acceleration":18.7,"model year":80,"origin":1,"car name":"dodge aspen"}""",
"""{"mpg":34.3,"cylinders":4,"displacement":97.0,"horsepower":78.0,"weight":2188.0,"acceleration":15.8,"model year":80,"origin":2,"car name":"audi 4000"}""",
"""{"mpg":29.8,"cylinders":4,"displacement":134.0,"horsepower":90.0,"weight":2711.0,"acceleration":15.5,"model year":80,"origin":3,"car name":"toyota corona liftback"}""",
"""{"mpg":31.3,"cylinders":4,"displacement":120.0,"horsepower":75.0,"weight":2542.0,"acceleration":17.5,"model year":80,"origin":3,"car name":"mazda 626"}""",
"""{"mpg":37.0,"cylinders":4,"displacement":119.0,"horsepower":92.0,"weight":2434.0,"acceleration":15.0,"model year":80,"origin":3,"car name":"datsun 510 hatchback"}""",
"""{"mpg":32.2,"cylinders":4,"displacement":108.0,"horsepower":75.0,"weight":2265.0,"acceleration":15.2,"model year":80,"origin":3,"car name":"toyota corolla"}""",
"""{"mpg":46.6,"cylinders":4,"displacement":86.0,"horsepower":65.0,"weight":2110.0,"acceleration":17.9,"model year":80,"origin":3,"car name":"mazda glc"}""",
"""{"mpg":27.9,"cylinders":4,"displacement":156.0,"horsepower":105.0,"weight":2800.0,"acceleration":14.4,"model year":80,"origin":1,"car name":"dodge colt"}""",
"""{"mpg":40.8,"cylinders":4,"displacement":85.0,"horsepower":65.0,"weight":2110.0,"acceleration":19.2,"model year":80,"origin":3,"car name":"datsun 210"}""",
"""{"mpg":44.3,"cylinders":4,"displacement":90.0,"horsepower":48.0,"weight":2085.0,"acceleration":21.7,"model year":80,"origin":2,"car name":"vw rabbit c (diesel)"}""",
"""{"mpg":43.4,"cylinders":4,"displacement":90.0,"horsepower":48.0,"weight":2335.0,"acceleration":23.7,"model year":80,"origin":2,"car name":"vw dasher (diesel)"}""",
"""{"mpg":36.4,"cylinders":5,"displacement":121.0,"horsepower":67.0,"weight":2950.0,"acceleration":19.9,"model year":80,"origin":2,"car name":"audi 5000s (diesel)"}""",
"""{"mpg":30.0,"cylinders":4,"displacement":146.0,"horsepower":67.0,"weight":3250.0,"acceleration":21.8,"model year":80,"origin":2,"car name":"mercedes-benz 240d"}""",
"""{"mpg":44.6,"cylinders":4,"displacement":91.0,"horsepower":67.0,"weight":1850.0,"acceleration":13.8,"model year":80,"origin":3,"car name":"honda civic 1500 gl"}""",
"""{"mpg":40.9,"cylinders":4,"displacement":85.0,"horsepower":null,"weight":1835.0,"acceleration":17.3,"model year":80,"origin":2,"car name":"renault lecar deluxe"}""",
"""{"mpg":33.8,"cylinders":4,"displacement":97.0,"horsepower":67.0,"weight":2145.0,"acceleration":18.0,"model year":80,"origin":3,"car name":"subaru dl"}""",
"""{"mpg":29.8,"cylinders":4,"displacement":89.0,"horsepower":62.0,"weight":1845.0,"acceleration":15.3,"model year":80,"origin":2,"car name":"vokswagen rabbit"}""",
"""{"mpg":32.7,"cylinders":6,"displacement":168.0,"horsepower":132.0,"weight":2910.0,"acceleration":11.4,"model year":80,"origin":3,"car name":"datsun 280-zx"}""",
"""{"mpg":23.7,"cylinders":3,"displacement":70.0,"horsepower":100.0,"weight":2420.0,"acceleration":12.5,"model year":80,"origin":3,"car name":"mazda rx-7 gs"}""",
"""{"mpg":35.0,"cylinders":4,"displacement":122.0,"horsepower":88.0,"weight":2500.0,"acceleration":15.1,"model year":80,"origin":2,"car name":"triumph tr7 coupe"}""",
"""{"mpg":23.6,"cylinders":4,"displacement":140.0,"horsepower":null,"weight":2905.0,"acceleration":14.3,"model year":80,"origin":1,"car name":"ford mustang cobra"}""",
"""{"mpg":32.4,"cylinders":4,"displacement":107.0,"horsepower":72.0,"weight":2290.0,"acceleration":17.0,"model year":80,"origin":3,"car name":"honda accord"}""",
"""{"mpg":27.2,"cylinders":4,"displacement":135.0,"horsepower":84.0,"weight":2490.0,"acceleration":15.7,"model year":81,"origin":1,"car name":"plymouth reliant"}""",
"""{"mpg":26.6,"cylinders":4,"displacement":151.0,"horsepower":84.0,"weight":2635.0,"acceleration":16.4,"model year":81,"origin":1,"car name":"buick skylark"}""",
"""{"mpg":25.8,"cylinders":4,"displacement":156.0,"horsepower":92.0,"weight":2620.0,"acceleration":14.4,"model year":81,"origin":1,"car name":"dodge aries wagon (sw)"}""",
"""{"mpg":23.5,"cylinders":6,"displacement":173.0,"horsepower":110.0,"weight":2725.0,"acceleration":12.6,"model year":81,"origin":1,"car name":"chevrolet citation"}""",
"""{"mpg":30.0,"cylinders":4,"displacement":135.0,"horsepower":84.0,"weight":2385.0,"acceleration":12.9,"model year":81,"origin":1,"car name":"plymouth reliant"}""",
"""{"mpg":39.1,"cylinders":4,"displacement":79.0,"horsepower":58.0,"weight":1755.0,"acceleration":16.9,"model year":81,"origin":3,"car name":"toyota starlet"}""",
"""{"mpg":39.0,"cylinders":4,"displacement":86.0,"horsepower":64.0,"weight":1875.0,"acceleration":16.4,"model year":81,"origin":1,"car name":"plymouth champ"}""",
"""{"mpg":35.1,"cylinders":4,"displacement":81.0,"horsepower":60.0,"weight":1760.0,"acceleration":16.1,"model year":81,"origin":3,"car name":"honda civic 1300"}""",
"""{"mpg":32.3,"cylinders":4,"displacement":97.0,"horsepower":67.0,"weight":2065.0,"acceleration":17.8,"model year":81,"origin":3,"car name":"subaru"}""",
"""{"mpg":37.0,"cylinders":4,"displacement":85.0,"horsepower":65.0,"weight":1975.0,"acceleration":19.4,"model year":81,"origin":3,"car name":"datsun 210 mpg"}""",
"""{"mpg":37.7,"cylinders":4,"displacement":89.0,"horsepower":62.0,"weight":2050.0,"acceleration":17.3,"model year":81,"origin":3,"car name":"toyota tercel"}""",
"""{"mpg":34.1,"cylinders":4,"displacement":91.0,"horsepower":68.0,"weight":1985.0,"acceleration":16.0,"model year":81,"origin":3,"car name":"mazda glc 4"}""",
"""{"mpg":34.7,"cylinders":4,"displacement":105.0,"horsepower":63.0,"weight":2215.0,"acceleration":14.9,"model year":81,"origin":1,"car name":"plymouth horizon 4"}""",
"""{"mpg":34.4,"cylinders":4,"displacement":98.0,"horsepower":65.0,"weight":2045.0,"acceleration":16.2,"model year":81,"origin":1,"car name":"ford escort 4w"}""",
"""{"mpg":29.9,"cylinders":4,"displacement":98.0,"horsepower":65.0,"weight":2380.0,"acceleration":20.7,"model year":81,"origin":1,"car name":"ford escort 2h"}""",
"""{"mpg":33.0,"cylinders":4,"displacement":105.0,"horsepower":74.0,"weight":2190.0,"acceleration":14.2,"model year":81,"origin":2,"car name":"volkswagen jetta"}""",
"""{"mpg":34.5,"cylinders":4,"displacement":100.0,"horsepower":null,"weight":2320.0,"acceleration":15.8,"model year":81,"origin":2,"car name":"renault 18i"}""",
"""{"mpg":33.7,"cylinders":4,"displacement":107.0,"horsepower":75.0,"weight":2210.0,"acceleration":14.4,"model year":81,"origin":3,"car name":"honda prelude"}""",
"""{"mpg":32.4,"cylinders":4,"displacement":108.0,"horsepower":75.0,"weight":2350.0,"acceleration":16.8,"model year":81,"origin":3,"car name":"toyota corolla"}""",
"""{"mpg":32.9,"cylinders":4,"displacement":119.0,"horsepower":100.0,"weight":2615.0,"acceleration":14.8,"model year":81,"origin":3,"car name":"datsun 200sx"}""",
"""{"mpg":31.6,"cylinders":4,"displacement":120.0,"horsepower":74.0,"weight":2635.0,"acceleration":18.3,"model year":81,"origin":3,"car name":"mazda 626"}""",
"""{"mpg":28.1,"cylinders":4,"displacement":141.0,"horsepower":80.0,"weight":3230.0,"acceleration":20.4,"model year":81,"origin":2,"car name":"peugeot 505s turbo diesel"}""",
"""{"mpg":30.7,"cylinders":6,"displacement":145.0,"horsepower":76.0,"weight":3160.0,"acceleration":19.6,"model year":81,"origin":2,"car name":"volvo diesel"}""",
"""{"mpg":25.4,"cylinders":6,"displacement":168.0,"horsepower":116.0,"weight":2900.0,"acceleration":12.6,"model year":81,"origin":3,"car name":"toyota cressida"}""",
"""{"mpg":24.2,"cylinders":6,"displacement":146.0,"horsepower":120.0,"weight":2930.0,"acceleration":13.8,"model year":81,"origin":3,"car name":"datsun 810 maxima"}""",
"""{"mpg":22.4,"cylinders":6,"displacement":231.0,"horsepower":110.0,"weight":3415.0,"acceleration":15.8,"model year":81,"origin":1,"car name":"buick century"}""",
"""{"mpg":26.6,"cylinders":8,"displacement":350.0,"horsepower":105.0,"weight":3725.0,"acceleration":19.0,"model year":81,"origin":1,"car name":"oldsmobile cutlass ls"}""",
"""{"mpg":20.2,"cylinders":6,"displacement":200.0,"horsepower":88.0,"weight":3060.0,"acceleration":17.1,"model year":81,"origin":1,"car name":"ford granada gl"}""",
"""{"mpg":17.6,"cylinders":6,"displacement":225.0,"horsepower":85.0,"weight":3465.0,"acceleration":16.6,"model year":81,"origin":1,"car name":"chrysler lebaron salon"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":112.0,"horsepower":88.0,"weight":2605.0,"acceleration":19.6,"model year":82,"origin":1,"car name":"chevrolet cavalier"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":112.0,"horsepower":88.0,"weight":2640.0,"acceleration":18.6,"model year":82,"origin":1,"car name":"chevrolet cavalier wagon"}""",
"""{"mpg":34.0,"cylinders":4,"displacement":112.0,"horsepower":88.0,"weight":2395.0,"acceleration":18.0,"model year":82,"origin":1,"car name":"chevrolet cavalier 2-door"}""",
"""{"mpg":31.0,"cylinders":4,"displacement":112.0,"horsepower":85.0,"weight":2575.0,"acceleration":16.2,"model year":82,"origin":1,"car name":"pontiac j2000 se hatchback"}""",
"""{"mpg":29.0,"cylinders":4,"displacement":135.0,"horsepower":84.0,"weight":2525.0,"acceleration":16.0,"model year":82,"origin":1,"car name":"dodge aries se"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":151.0,"horsepower":90.0,"weight":2735.0,"acceleration":18.0,"model year":82,"origin":1,"car name":"pontiac phoenix"}""",
"""{"mpg":24.0,"cylinders":4,"displacement":140.0,"horsepower":92.0,"weight":2865.0,"acceleration":16.4,"model year":82,"origin":1,"car name":"ford fairmont futura"}""",
"""{"mpg":23.0,"cylinders":4,"displacement":151.0,"horsepower":null,"weight":3035.0,"acceleration":20.5,"model year":82,"origin":1,"car name":"amc concord dl"}""",
"""{"mpg":36.0,"cylinders":4,"displacement":105.0,"horsepower":74.0,"weight":1980.0,"acceleration":15.3,"model year":82,"origin":2,"car name":"volkswagen rabbit l"}""",
"""{"mpg":37.0,"cylinders":4,"displacement":91.0,"horsepower":68.0,"weight":2025.0,"acceleration":18.2,"model year":82,"origin":3,"car name":"mazda glc custom l"}""",
"""{"mpg":31.0,"cylinders":4,"displacement":91.0,"horsepower":68.0,"weight":1970.0,"acceleration":17.6,"model year":82,"origin":3,"car name":"mazda glc custom"}""",
"""{"mpg":38.0,"cylinders":4,"displacement":105.0,"horsepower":63.0,"weight":2125.0,"acceleration":14.7,"model year":82,"origin":1,"car name":"plymouth horizon miser"}""",
"""{"mpg":36.0,"cylinders":4,"displacement":98.0,"horsepower":70.0,"weight":2125.0,"acceleration":17.3,"model year":82,"origin":1,"car name":"mercury lynx l"}""",
"""{"mpg":36.0,"cylinders":4,"displacement":120.0,"horsepower":88.0,"weight":2160.0,"acceleration":14.5,"model year":82,"origin":3,"car name":"nissan stanza xe"}""",
"""{"mpg":36.0,"cylinders":4,"displacement":107.0,"horsepower":75.0,"weight":2205.0,"acceleration":14.5,"model year":82,"origin":3,"car name":"honda accord"}""",
"""{"mpg":34.0,"cylinders":4,"displacement":108.0,"horsepower":70.0,"weight":2245.0,"acceleration":16.9,"model year":82,"origin":3,"car name":"toyota corolla"}""",
"""{"mpg":38.0,"cylinders":4,"displacement":91.0,"horsepower":67.0,"weight":1965.0,"acceleration":15.0,"model year":82,"origin":3,"car name":"honda civic"}""",
"""{"mpg":32.0,"cylinders":4,"displacement":91.0,"horsepower":67.0,"weight":1965.0,"acceleration":15.7,"model year":82,"origin":3,"car name":"honda civic (auto)"}""",
"""{"mpg":38.0,"cylinders":4,"displacement":91.0,"horsepower":67.0,"weight":1995.0,"acceleration":16.2,"model year":82,"origin":3,"car name":"datsun 310 gx"}""",
"""{"mpg":25.0,"cylinders":6,"displacement":181.0,"horsepower":110.0,"weight":2945.0,"acceleration":16.4,"model year":82,"origin":1,"car name":"buick century limited"}""",
"""{"mpg":38.0,"cylinders":6,"displacement":262.0,"horsepower":85.0,"weight":3015.0,"acceleration":17.0,"model year":82,"origin":1,"car name":"oldsmobile cutlass ciera (diesel)"}""",
"""{"mpg":26.0,"cylinders":4,"displacement":156.0,"horsepower":92.0,"weight":2585.0,"acceleration":14.5,"model year":82,"origin":1,"car name":"chrysler lebaron medallion"}""",
"""{"mpg":22.0,"cylinders":6,"displacement":232.0,"horsepower":112.0,"weight":2835.0,"acceleration":14.7,"model year":82,"origin":1,"car name":"ford granada l"}""",
"""{"mpg":32.0,"cylinders":4,"displacement":144.0,"horsepower":96.0,"weight":2665.0,"acceleration":13.9,"model year":82,"origin":3,"car name":"toyota celica gt"}""",
"""{"mpg":36.0,"cylinders":4,"displacement":135.0,"horsepower":84.0,"weight":2370.0,"acceleration":13.0,"model year":82,"origin":1,"car name":"dodge charger 2.2"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":151.0,"horsepower":90.0,"weight":2950.0,"acceleration":17.3,"model year":82,"origin":1,"car name":"chevrolet camaro"}""",
"""{"mpg":27.0,"cylinders":4,"displacement":140.0,"horsepower":86.0,"weight":2790.0,"acceleration":15.6,"model year":82,"origin":1,"car name":"ford mustang gl"}""",
"""{"mpg":44.0,"cylinders":4,"displacement":97.0,"horsepower":52.0,"weight":2130.0,"acceleration":24.6,"model year":82,"origin":2,"car name":"vw pickup"}""",
"""{"mpg":32.0,"cylinders":4,"displacement":135.0,"horsepower":84.0,"weight":2295.0,"acceleration":11.6,"model year":82,"origin":1,"car name":"dodge rampage"}""",
"""{"mpg":28.0,"cylinders":4,"displacement":120.0,"horsepower":79.0,"weight":2625.0,"acceleration":18.6,"model year":82,"origin":1,"car name":"ford ranger"}""",
"""{"mpg":31.0,"cylinders":4,"displacement":119.0,"horsepower":82.0,"weight":2720.0,"acceleration":19.4,"model year":82,"origin":1,"car name":"chevy s-10"}"""
)))
statAutoMpg.printSchema
//Working with auto-mpg dataset in Spark
statAutoMpg.select("cylinders").distinct.show
+---------+
|cylinders|
+---------+
| 3|
| 4|
| 5|
| 6|
| 8|
+---------+
statAutoMpg.registerTempTable("stat_auto_mpg")
sqlContext.sql("SELECT cylinders, count(1) as cnt FROM stat_auto_mpg GROUP BY cylinders ORDER BY cnt DESC").show
+---------+---+
|cylinders|cnt|
+---------+---+
| 4|204|
| 8|103|
| 6| 84|
| 3| 4|
| 5| 3|
+---------+---+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment