Introduction to Pandas

Manish Patel

Unit - 1 PANDAS FOR PYTHON

import pandas as pd

import pandas as pd
import warnings
warnings.filterwarnings('ignore') # setting ignore as a parameter

1.1 Series, DataFrame, read_csv(), tail(), head(), info(), shape()

SERIES

# Series
h = (1, 8, 100, 10)
s = pd.Series(h)
print(s)

0      1
1      8
2    100
3     10
dtype: int64

Convert Dict to Series

## Converting dict to Series
d = {'name' : 'IBM', 'date' : '2010-09-08', 'shares' : 100, 'price' : 10.2}
ds = pd.Series(d)
print(type(ds))
print(ds)
print(pd.Series(d, index = ['name','shares']))

<class 'pandas.core.series.Series'>
name             IBM
date      2010-09-08
shares           100
price           10.2
dtype: object
name      IBM
shares    100
dtype: object

Access Elements

## Access elements

l = ['name', 'date', 'shares', 'price']
f = ['FB', '2001-08-02', 90, 3.2]
f = pd.Series(f, index = l )
print(f)
print(f['shares'])
90
print(f[0])

name              FB
date      2001-08-02
shares            90
price            3.2
dtype: object
90
FB

DataFrame

Series are used to work with one dimensional array, whereas DataFrame can be used with two dimensional arrays.
All the spreadsheets and text files are read as DataFrame

EXAMPLE

data = { 'name' : ['AA', 'IBM', 'GOOG'],
'date' : ['2001-12-01', '2012-02-10', '2010-04-09'],
'shares' : [100, 30, 90],
'price' : [12.3, 10.3, 32.2]
}

DATAFRAME

df = pd.DataFrame(data)
df

	name	date	shares	price
0	AA	2001-12-01	100	12.3
1	IBM	2012-02-10	30	10.3
2	GOOG	2010-04-09	90	32.2

ADD COLUMN

## Add column
df['owner'] = 'Unknown'
df

	name	date	shares	price	owner
0	AA	2001-12-01	100	12.3	Unknown
1	IBM	2012-02-10	30	10.3	Unknown
2	GOOG	2010-04-09	90	32.2	Unknown

ADD INDEX

## ADD INDEX
df.index = ['hello', 'hi', 'bye']
df

	name	date	shares	price	owner
hello	AA	2001-12-01	100	12.3	Unknown
hi	IBM	2012-02-10	30	10.3	Unknown
bye	GOOG	2010-04-09	90	32.2	Unknown

SET INDEX

## SET INDEX
df = df.set_index(['date'])
df

	name	shares	price	owner
date
2001-12-01	AA	100	12.3	Unknown
2012-02-10	IBM	30	10.3	Unknown
2010-04-09	GOOG	90	32.2	Unknown

ACCESS DATA USING COLUMN-INDEX

## access data using column-index
df['shares']

date
2001-12-01    100
2012-02-10     30
2010-04-09     90
Name: shares, dtype: int64

ACCESS DATA USING ROW-INDEX

## access data by row-index
df.loc['2010-04-09']

name         GOOG
shares         90
price        32.2
owner     Unknown
Name: 2010-04-09, dtype: object

## access data by row-index
df.loc[['2010-04-09']]

	name	shares	price	owner
date
2010-04-09	GOOG	90	32.2	Unknown

ACCESS ALL ROWS FOR A COLUMN

## access all rows for a column
df.loc[['2012-02-10','2010-04-09']]

	name	shares	price	owner
date
2012-02-10	IBM	30	10.3	Unknown
2010-04-09	GOOG	90	32.2	Unknown

READ CSV

import pandas as pd
df = pd.read_csv('auto-mpg.csv')

print(df)

      mpg  cylinders  displacement horsepower  weight  acceleration  \
0    18.0          8         307.0        130    3504          12.0   
1    15.0          8         350.0        165    3693          11.5   
2    18.0          8         318.0        150    3436          11.0   
3    16.0          8         304.0        150    3433          12.0   
4    17.0          8         302.0        140    3449          10.5   
..    ...        ...           ...        ...     ...           ...   
393  27.0          4         140.0         86    2790          15.6   
394  44.0          4          97.0         52    2130          24.6   
395  32.0          4         135.0         84    2295          11.6   
396  28.0          4         120.0         79    2625          18.6   
397  31.0          4         119.0         82    2720          19.4   

     model year  origin                   car name  
0            70       1  chevrolet chevelle malibu  
1            70       1          buick skylark 320  
2            70       1         plymouth satellite  
3            70       1              amc rebel sst  
4            70       1                ford torino  
..          ...     ...                        ...  
393          82       1            ford mustang gl  
394          82       2                  vw pickup  
395          82       1              dodge rampage  
396          82       1                ford ranger  
397          82       1                 chevy s-10  

[398 rows x 9 columns]

Read Entire dataframe

print(df.to_string())

      mpg  cylinders  displacement horsepower  weight  acceleration  model year  origin                              car name
0    18.0          8         307.0        130    3504          12.0          70       1             chevrolet chevelle malibu
1    15.0          8         350.0        165    3693          11.5          70       1                     buick skylark 320
2    18.0          8         318.0        150    3436          11.0          70       1                    plymouth satellite
3    16.0          8         304.0        150    3433          12.0          70       1                         amc rebel sst
4    17.0          8         302.0        140    3449          10.5          70       1                           ford torino
5    15.0          8         429.0        198    4341          10.0          70       1                      ford galaxie 500
6    14.0          8         454.0        220    4354           9.0          70       1                      chevrolet impala
7    14.0          8         440.0        215    4312           8.5          70       1                     plymouth fury iii
8    14.0          8         455.0        225    4425          10.0          70       1                      pontiac catalina
9    15.0          8         390.0        190    3850           8.5          70       1                    amc ambassador dpl
10   15.0          8         383.0        170    3563          10.0          70       1                   dodge challenger se
11   14.0          8         340.0        160    3609           8.0          70       1                    plymouth 'cuda 340
12   15.0          8         400.0        150    3761           9.5          70       1                 chevrolet monte carlo
13   14.0          8         455.0        225    3086          10.0          70       1               buick estate wagon (sw)
14   24.0          4         113.0         95    2372          15.0          70       3                 toyota corona mark ii
15   22.0          6         198.0         95    2833          15.5          70       1                       plymouth duster
16   18.0          6         199.0         97    2774          15.5          70       1                            amc hornet
17   21.0          6         200.0         85    2587          16.0          70       1                         ford maverick
18   27.0          4          97.0         88    2130          14.5          70       3                          datsun pl510
19   26.0          4          97.0         46    1835          20.5          70       2          volkswagen 1131 deluxe sedan
20   25.0          4         110.0         87    2672          17.5          70       2                           peugeot 504
21   24.0          4         107.0         90    2430          14.5          70       2                           audi 100 ls
22   25.0          4         104.0         95    2375          17.5          70       2                              saab 99e
23   26.0          4         121.0        113    2234          12.5          70       2                              bmw 2002
24   21.0          6         199.0         90    2648          15.0          70       1                           amc gremlin
25   10.0          8         360.0        215    4615          14.0          70       1                             ford f250
26   10.0          8         307.0        200    4376          15.0          70       1                             chevy c20
27   11.0          8         318.0        210    4382          13.5          70       1                            dodge d200
28    9.0          8         304.0        193    4732          18.5          70       1                              hi 1200d
29   27.0          4          97.0         88    2130          14.5          71       3                          datsun pl510
30   28.0          4         140.0         90    2264          15.5          71       1                   chevrolet vega 2300
31   25.0          4         113.0         95    2228          14.0          71       3                         toyota corona
32   25.0          4          98.0          ?    2046          19.0          71       1                            ford pinto
33   19.0          6         232.0        100    2634          13.0          71       1                           amc gremlin
34   16.0          6         225.0        105    3439          15.5          71       1             plymouth satellite custom
35   17.0          6         250.0        100    3329          15.5          71       1             chevrolet chevelle malibu
36   19.0          6         250.0         88    3302          15.5          71       1                       ford torino 500
37   18.0          6         232.0        100    3288          15.5          71       1                           amc matador
38   14.0          8         350.0        165    4209          12.0          71       1                      chevrolet impala
39   14.0          8         400.0        175    4464          11.5          71       1             pontiac catalina brougham
40   14.0          8         351.0        153    4154          13.5          71       1                      ford galaxie 500
41   14.0          8         318.0        150    4096          13.0          71       1                     plymouth fury iii
42   12.0          8         383.0        180    4955          11.5          71       1                     dodge monaco (sw)
43   13.0          8         400.0        170    4746          12.0          71       1              ford country squire (sw)
44   13.0          8         400.0        175    5140          12.0          71       1                   pontiac safari (sw)
45   18.0          6         258.0        110    2962          13.5          71       1            amc hornet sportabout (sw)
46   22.0          4         140.0         72    2408          19.0          71       1                   chevrolet vega (sw)
47   19.0          6         250.0        100    3282          15.0          71       1                      pontiac firebird
48   18.0          6         250.0         88    3139          14.5          71       1                          ford mustang
49   23.0          4         122.0         86    2220          14.0          71       1                    mercury capri 2000
50   28.0          4         116.0         90    2123          14.0          71       2                             opel 1900
51   30.0          4          79.0         70    2074          19.5          71       2                           peugeot 304
52   30.0          4          88.0         76    2065          14.5          71       2                             fiat 124b
53   31.0          4          71.0         65    1773          19.0          71       3                   toyota corolla 1200
54   35.0          4          72.0         69    1613          18.0          71       3                           datsun 1200
55   27.0          4          97.0         60    1834          19.0          71       2                  volkswagen model 111
56   26.0          4          91.0         70    1955          20.5          71       1                      plymouth cricket
57   24.0          4         113.0         95    2278          15.5          72       3                 toyota corona hardtop
58   25.0          4          97.5         80    2126          17.0          72       1                    dodge colt hardtop
59   23.0          4          97.0         54    2254          23.5          72       2                     volkswagen type 3
60   20.0          4         140.0         90    2408          19.5          72       1                        chevrolet vega
61   21.0          4         122.0         86    2226          16.5          72       1                   ford pinto runabout
62   13.0          8         350.0        165    4274          12.0          72       1                      chevrolet impala
63   14.0          8         400.0        175    4385          12.0          72       1                      pontiac catalina
64   15.0          8         318.0        150    4135          13.5          72       1                     plymouth fury iii
65   14.0          8         351.0        153    4129          13.0          72       1                      ford galaxie 500
66   17.0          8         304.0        150    3672          11.5          72       1                    amc ambassador sst
67   11.0          8         429.0        208    4633          11.0          72       1                       mercury marquis
68   13.0          8         350.0        155    4502          13.5          72       1                  buick lesabre custom
69   12.0          8         350.0        160    4456          13.5          72       1            oldsmobile delta 88 royale
70   13.0          8         400.0        190    4422          12.5          72       1                chrysler newport royal
71   19.0          3          70.0         97    2330          13.5          72       3                       mazda rx2 coupe
72   15.0          8         304.0        150    3892          12.5          72       1                      amc matador (sw)
73   13.0          8         307.0        130    4098          14.0          72       1      chevrolet chevelle concours (sw)
74   13.0          8         302.0        140    4294          16.0          72       1                 ford gran torino (sw)
75   14.0          8         318.0        150    4077          14.0          72       1        plymouth satellite custom (sw)
76   18.0          4         121.0        112    2933          14.5          72       2                       volvo 145e (sw)
77   22.0          4         121.0         76    2511          18.0          72       2                   volkswagen 411 (sw)
78   21.0          4         120.0         87    2979          19.5          72       2                      peugeot 504 (sw)
79   26.0          4          96.0         69    2189          18.0          72       2                       renault 12 (sw)
80   22.0          4         122.0         86    2395          16.0          72       1                       ford pinto (sw)
81   28.0          4          97.0         92    2288          17.0          72       3                       datsun 510 (sw)
82   23.0          4         120.0         97    2506          14.5          72       3           toyouta corona mark ii (sw)
83   28.0          4          98.0         80    2164          15.0          72       1                       dodge colt (sw)
84   27.0          4          97.0         88    2100          16.5          72       3              toyota corolla 1600 (sw)
85   13.0          8         350.0        175    4100          13.0          73       1                     buick century 350
86   14.0          8         304.0        150    3672          11.5          73       1                           amc matador
87   13.0          8         350.0        145    3988          13.0          73       1                      chevrolet malibu
88   14.0          8         302.0        137    4042          14.5          73       1                      ford gran torino
89   15.0          8         318.0        150    3777          12.5          73       1                  dodge coronet custom
90   12.0          8         429.0        198    4952          11.5          73       1              mercury marquis brougham
91   13.0          8         400.0        150    4464          12.0          73       1             chevrolet caprice classic
92   13.0          8         351.0        158    4363          13.0          73       1                              ford ltd
93   14.0          8         318.0        150    4237          14.5          73       1              plymouth fury gran sedan
94   13.0          8         440.0        215    4735          11.0          73       1          chrysler new yorker brougham
95   12.0          8         455.0        225    4951          11.0          73       1              buick electra 225 custom
96   13.0          8         360.0        175    3821          11.0          73       1               amc ambassador brougham
97   18.0          6         225.0        105    3121          16.5          73       1                      plymouth valiant
98   16.0          6         250.0        100    3278          18.0          73       1                 chevrolet nova custom
99   18.0          6         232.0        100    2945          16.0          73       1                            amc hornet
100  18.0          6         250.0         88    3021          16.5          73       1                         ford maverick
101  23.0          6         198.0         95    2904          16.0          73       1                       plymouth duster
102  26.0          4          97.0         46    1950          21.0          73       2               volkswagen super beetle
103  11.0          8         400.0        150    4997          14.0          73       1                      chevrolet impala
104  12.0          8         400.0        167    4906          12.5          73       1                          ford country
105  13.0          8         360.0        170    4654          13.0          73       1                plymouth custom suburb
106  12.0          8         350.0        180    4499          12.5          73       1              oldsmobile vista cruiser
107  18.0          6         232.0        100    2789          15.0          73       1                           amc gremlin
108  20.0          4          97.0         88    2279          19.0          73       3                         toyota carina
109  21.0          4         140.0         72    2401          19.5          73       1                        chevrolet vega
110  22.0          4         108.0         94    2379          16.5          73       3                            datsun 610
111  18.0          3          70.0         90    2124          13.5          73       3                             maxda rx3
112  19.0          4         122.0         85    2310          18.5          73       1                            ford pinto
113  21.0          6         155.0        107    2472          14.0          73       1                      mercury capri v6
114  26.0          4          98.0         90    2265          15.5          73       2                  fiat 124 sport coupe
115  15.0          8         350.0        145    4082          13.0          73       1               chevrolet monte carlo s
116  16.0          8         400.0        230    4278           9.5          73       1                    pontiac grand prix
117  29.0          4          68.0         49    1867          19.5          73       2                              fiat 128
118  24.0          4         116.0         75    2158          15.5          73       2                            opel manta
119  20.0          4         114.0         91    2582          14.0          73       2                            audi 100ls
120  19.0          4         121.0        112    2868          15.5          73       2                           volvo 144ea
121  15.0          8         318.0        150    3399          11.0          73       1                     dodge dart custom
122  24.0          4         121.0        110    2660          14.0          73       2                             saab 99le
123  20.0          6         156.0        122    2807          13.5          73       3                        toyota mark ii
124  11.0          8         350.0        180    3664          11.0          73       1                      oldsmobile omega
125  20.0          6         198.0         95    3102          16.5          74       1                       plymouth duster
126  21.0          6         200.0          ?    2875          17.0          74       1                         ford maverick
127  19.0          6         232.0        100    2901          16.0          74       1                            amc hornet
128  15.0          6         250.0        100    3336          17.0          74       1                        chevrolet nova
129  31.0          4          79.0         67    1950          19.0          74       3                           datsun b210
130  26.0          4         122.0         80    2451          16.5          74       1                            ford pinto
131  32.0          4          71.0         65    1836          21.0          74       3                   toyota corolla 1200
132  25.0          4         140.0         75    2542          17.0          74       1                        chevrolet vega
133  16.0          6         250.0        100    3781          17.0          74       1     chevrolet chevelle malibu classic
134  16.0          6         258.0        110    3632          18.0          74       1                           amc matador
135  18.0          6         225.0        105    3613          16.5          74       1            plymouth satellite sebring
136  16.0          8         302.0        140    4141          14.0          74       1                      ford gran torino
137  13.0          8         350.0        150    4699          14.5          74       1              buick century luxus (sw)
138  14.0          8         318.0        150    4457          13.5          74       1             dodge coronet custom (sw)
139  14.0          8         302.0        140    4638          16.0          74       1                 ford gran torino (sw)
140  14.0          8         304.0        150    4257          15.5          74       1                      amc matador (sw)
141  29.0          4          98.0         83    2219          16.5          74       2                              audi fox
142  26.0          4          79.0         67    1963          15.5          74       2                     volkswagen dasher
143  26.0          4          97.0         78    2300          14.5          74       2                            opel manta
144  31.0          4          76.0         52    1649          16.5          74       3                         toyota corona
145  32.0          4          83.0         61    2003          19.0          74       3                            datsun 710
146  28.0          4          90.0         75    2125          14.5          74       1                            dodge colt
147  24.0          4          90.0         75    2108          15.5          74       2                              fiat 128
148  26.0          4         116.0         75    2246          14.0          74       2                           fiat 124 tc
149  24.0          4         120.0         97    2489          15.0          74       3                           honda civic
150  26.0          4         108.0         93    2391          15.5          74       3                                subaru
151  31.0          4          79.0         67    2000          16.0          74       2                             fiat x1.9
152  19.0          6         225.0         95    3264          16.0          75       1               plymouth valiant custom
153  18.0          6         250.0        105    3459          16.0          75       1                        chevrolet nova
154  15.0          6         250.0         72    3432          21.0          75       1                       mercury monarch
155  15.0          6         250.0         72    3158          19.5          75       1                         ford maverick
156  16.0          8         400.0        170    4668          11.5          75       1                      pontiac catalina
157  15.0          8         350.0        145    4440          14.0          75       1                     chevrolet bel air
158  16.0          8         318.0        150    4498          14.5          75       1                   plymouth grand fury
159  14.0          8         351.0        148    4657          13.5          75       1                              ford ltd
160  17.0          6         231.0        110    3907          21.0          75       1                         buick century
161  16.0          6         250.0        105    3897          18.5          75       1             chevroelt chevelle malibu
162  15.0          6         258.0        110    3730          19.0          75       1                           amc matador
163  18.0          6         225.0         95    3785          19.0          75       1                         plymouth fury
164  21.0          6         231.0        110    3039          15.0          75       1                         buick skyhawk
165  20.0          8         262.0        110    3221          13.5          75       1                   chevrolet monza 2+2
166  13.0          8         302.0        129    3169          12.0          75       1                       ford mustang ii
167  29.0          4          97.0         75    2171          16.0          75       3                        toyota corolla
168  23.0          4         140.0         83    2639          17.0          75       1                            ford pinto
169  20.0          6         232.0        100    2914          16.0          75       1                           amc gremlin
170  23.0          4         140.0         78    2592          18.5          75       1                         pontiac astro
171  24.0          4         134.0         96    2702          13.5          75       3                         toyota corona
172  25.0          4          90.0         71    2223          16.5          75       2                     volkswagen dasher
173  24.0          4         119.0         97    2545          17.0          75       3                            datsun 710
174  18.0          6         171.0         97    2984          14.5          75       1                            ford pinto
175  29.0          4          90.0         70    1937          14.0          75       2                     volkswagen rabbit
176  19.0          6         232.0         90    3211          17.0          75       1                             amc pacer
177  23.0          4         115.0         95    2694          15.0          75       2                            audi 100ls
178  23.0          4         120.0         88    2957          17.0          75       2                           peugeot 504
179  22.0          4         121.0         98    2945          14.5          75       2                           volvo 244dl
180  25.0          4         121.0        115    2671          13.5          75       2                             saab 99le
181  33.0          4          91.0         53    1795          17.5          75       3                      honda civic cvcc
182  28.0          4         107.0         86    2464          15.5          76       2                              fiat 131
183  25.0          4         116.0         81    2220          16.9          76       2                             opel 1900
184  25.0          4         140.0         92    2572          14.9          76       1                              capri ii
185  26.0          4          98.0         79    2255          17.7          76       1                            dodge colt
186  27.0          4         101.0         83    2202          15.3          76       2                          renault 12tl
187  17.5          8         305.0        140    4215          13.0          76       1     chevrolet chevelle malibu classic
188  16.0          8         318.0        150    4190          13.0          76       1                dodge coronet brougham
189  15.5          8         304.0        120    3962          13.9          76       1                           amc matador
190  14.5          8         351.0        152    4215          12.8          76       1                      ford gran torino
191  22.0          6         225.0        100    3233          15.4          76       1                      plymouth valiant
192  22.0          6         250.0        105    3353          14.5          76       1                        chevrolet nova
193  24.0          6         200.0         81    3012          17.6          76       1                         ford maverick
194  22.5          6         232.0         90    3085          17.6          76       1                            amc hornet
195  29.0          4          85.0         52    2035          22.2          76       1                    chevrolet chevette
196  24.5          4          98.0         60    2164          22.1          76       1                       chevrolet woody
197  29.0          4          90.0         70    1937          14.2          76       2                             vw rabbit
198  33.0          4          91.0         53    1795          17.4          76       3                           honda civic
199  20.0          6         225.0        100    3651          17.7          76       1                        dodge aspen se
200  18.0          6         250.0         78    3574          21.0          76       1                     ford granada ghia
201  18.5          6         250.0        110    3645          16.2          76       1                    pontiac ventura sj
202  17.5          6         258.0         95    3193          17.8          76       1                         amc pacer d/l
203  29.5          4          97.0         71    1825          12.2          76       2                     volkswagen rabbit
204  32.0          4          85.0         70    1990          17.0          76       3                          datsun b-210
205  28.0          4          97.0         75    2155          16.4          76       3                        toyota corolla
206  26.5          4         140.0         72    2565          13.6          76       1                            ford pinto
207  20.0          4         130.0        102    3150          15.7          76       2                             volvo 245
208  13.0          8         318.0        150    3940          13.2          76       1            plymouth volare premier v8
209  19.0          4         120.0         88    3270          21.9          76       2                           peugeot 504
210  19.0          6         156.0        108    2930          15.5          76       3                        toyota mark ii
211  16.5          6         168.0        120    3820          16.7          76       2                    mercedes-benz 280s
212  16.5          8         350.0        180    4380          12.1          76       1                      cadillac seville
213  13.0          8         350.0        145    4055          12.0          76       1                             chevy c10
214  13.0          8         302.0        130    3870          15.0          76       1                             ford f108
215  13.0          8         318.0        150    3755          14.0          76       1                            dodge d100
216  31.5          4          98.0         68    2045          18.5          77       3                     honda accord cvcc
217  30.0          4         111.0         80    2155          14.8          77       1               buick opel isuzu deluxe
218  36.0          4          79.0         58    1825          18.6          77       2                         renault 5 gtl
219  25.5          4         122.0         96    2300          15.5          77       1                     plymouth arrow gs
220  33.5          4          85.0         70    1945          16.8          77       3                 datsun f-10 hatchback
221  17.5          8         305.0        145    3880          12.5          77       1             chevrolet caprice classic
222  17.0          8         260.0        110    4060          19.0          77       1            oldsmobile cutlass supreme
223  15.5          8         318.0        145    4140          13.7          77       1                 dodge monaco brougham
224  15.0          8         302.0        130    4295          14.9          77       1               mercury cougar brougham
225  17.5          6         250.0        110    3520          16.4          77       1                    chevrolet concours
226  20.5          6         231.0        105    3425          16.9          77       1                         buick skylark
227  19.0          6         225.0        100    3630          17.7          77       1                plymouth volare custom
228  18.5          6         250.0         98    3525          19.0          77       1                          ford granada
229  16.0          8         400.0        180    4220          11.1          77       1                 pontiac grand prix lj
230  15.5          8         350.0        170    4165          11.4          77       1          chevrolet monte carlo landau
231  15.5          8         400.0        190    4325          12.2          77       1                      chrysler cordoba
232  16.0          8         351.0        149    4335          14.5          77       1                      ford thunderbird
233  29.0          4          97.0         78    1940          14.5          77       2              volkswagen rabbit custom
234  24.5          4         151.0         88    2740          16.0          77       1                 pontiac sunbird coupe
235  26.0          4          97.0         75    2265          18.2          77       3               toyota corolla liftback
236  25.5          4         140.0         89    2755          15.8          77       1                   ford mustang ii 2+2
237  30.5          4          98.0         63    2051          17.0          77       1                    chevrolet chevette
238  33.5          4          98.0         83    2075          15.9          77       1                        dodge colt m/m
239  30.0          4          97.0         67    1985          16.4          77       3                             subaru dl
240  30.5          4          97.0         78    2190          14.1          77       2                     volkswagen dasher
241  22.0          6         146.0         97    2815          14.5          77       3                            datsun 810
242  21.5          4         121.0        110    2600          12.8          77       2                              bmw 320i
243  21.5          3          80.0        110    2720          13.5          77       3                            mazda rx-4
244  43.1          4          90.0         48    1985          21.5          78       2       volkswagen rabbit custom diesel
245  36.1          4          98.0         66    1800          14.4          78       1                           ford fiesta
246  32.8          4          78.0         52    1985          19.4          78       3                      mazda glc deluxe
247  39.4          4          85.0         70    2070          18.6          78       3                        datsun b210 gx
248  36.1          4          91.0         60    1800          16.4          78       3                      honda civic cvcc
249  19.9          8         260.0        110    3365          15.5          78       1     oldsmobile cutlass salon brougham
250  19.4          8         318.0        140    3735          13.2          78       1                        dodge diplomat
251  20.2          8         302.0        139    3570          12.8          78       1                  mercury monarch ghia
252  19.2          6         231.0        105    3535          19.2          78       1                    pontiac phoenix lj
253  20.5          6         200.0         95    3155          18.2          78       1                      chevrolet malibu
254  20.2          6         200.0         85    2965          15.8          78       1                  ford fairmont (auto)
255  25.1          4         140.0         88    2720          15.4          78       1                   ford fairmont (man)
256  20.5          6         225.0        100    3430          17.2          78       1                       plymouth volare
257  19.4          6         232.0         90    3210          17.2          78       1                           amc concord
258  20.6          6         231.0        105    3380          15.8          78       1                 buick century special
259  20.8          6         200.0         85    3070          16.7          78       1                        mercury zephyr
260  18.6          6         225.0        110    3620          18.7          78       1                           dodge aspen
261  18.1          6         258.0        120    3410          15.1          78       1                       amc concord d/l
262  19.2          8         305.0        145    3425          13.2          78       1          chevrolet monte carlo landau
263  17.7          6         231.0        165    3445          13.4          78       1       buick regal sport coupe (turbo)
264  18.1          8         302.0        139    3205          11.2          78       1                           ford futura
265  17.5          8         318.0        140    4080          13.7          78       1                       dodge magnum xe
266  30.0          4          98.0         68    2155          16.5          78       1                    chevrolet chevette
267  27.5          4         134.0         95    2560          14.2          78       3                         toyota corona
268  27.2          4         119.0         97    2300          14.7          78       3                            datsun 510
269  30.9          4         105.0         75    2230          14.5          78       1                            dodge omni
270  21.1          4         134.0         95    2515          14.8          78       3             toyota celica gt liftback
271  23.2          4         156.0        105    2745          16.7          78       1                      plymouth sapporo
272  23.8          4         151.0         85    2855          17.6          78       1                oldsmobile starfire sx
273  23.9          4         119.0         97    2405          14.9          78       3                         datsun 200-sx
274  20.3          5         131.0        103    2830          15.9          78       2                             audi 5000
275  17.0          6         163.0        125    3140          13.6          78       2                           volvo 264gl
276  21.6          4         121.0        115    2795          15.7          78       2                            saab 99gle
277  16.2          6         163.0        133    3410          15.8          78       2                         peugeot 604sl
278  31.5          4          89.0         71    1990          14.9          78       2                   volkswagen scirocco
279  29.5          4          98.0         68    2135          16.6          78       3                       honda accord lx
280  21.5          6         231.0        115    3245          15.4          79       1                     pontiac lemans v6
281  19.8          6         200.0         85    2990          18.2          79       1                      mercury zephyr 6
282  22.3          4         140.0         88    2890          17.3          79       1                       ford fairmont 4
283  20.2          6         232.0         90    3265          18.2          79       1                      amc concord dl 6
284  20.6          6         225.0        110    3360          16.6          79       1                         dodge aspen 6
285  17.0          8         305.0        130    3840          15.4          79       1             chevrolet caprice classic
286  17.6          8         302.0        129    3725          13.4          79       1                       ford ltd landau
287  16.5          8         351.0        138    3955          13.2          79       1                 mercury grand marquis
288  18.2          8         318.0        135    3830          15.2          79       1                       dodge st. regis
289  16.9          8         350.0        155    4360          14.9          79       1               buick estate wagon (sw)
290  15.5          8         351.0        142    4054          14.3          79       1              ford country squire (sw)
291  19.2          8         267.0        125    3605          15.0          79       1         chevrolet malibu classic (sw)
292  18.5          8         360.0        150    3940          13.0          79       1  chrysler lebaron town @ country (sw)
293  31.9          4          89.0         71    1925          14.0          79       2                      vw rabbit custom
294  34.1          4          86.0         65    1975          15.2          79       3                      maxda glc deluxe
295  35.7          4          98.0         80    1915          14.4          79       1           dodge colt hatchback custom
296  27.4          4         121.0         80    2670          15.0          79       1                         amc spirit dl
297  25.4          5         183.0         77    3530          20.1          79       2                    mercedes benz 300d
298  23.0          8         350.0        125    3900          17.4          79       1                     cadillac eldorado
299  27.2          4         141.0         71    3190          24.8          79       2                           peugeot 504
300  23.9          8         260.0         90    3420          22.2          79       1     oldsmobile cutlass salon brougham
301  34.2          4         105.0         70    2200          13.2          79       1                      plymouth horizon
302  34.5          4         105.0         70    2150          14.9          79       1                  plymouth horizon tc3
303  31.8          4          85.0         65    2020          19.2          79       3                            datsun 210
304  37.3          4          91.0         69    2130          14.7          79       2                    fiat strada custom
305  28.4          4         151.0         90    2670          16.0          79       1                 buick skylark limited
306  28.8          6         173.0        115    2595          11.3          79       1                    chevrolet citation
307  26.8          6         173.0        115    2700          12.9          79       1             oldsmobile omega brougham
308  33.5          4         151.0         90    2556          13.2          79       1                       pontiac phoenix
309  41.5          4          98.0         76    2144          14.7          80       2                             vw rabbit
310  38.1          4          89.0         60    1968          18.8          80       3                 toyota corolla tercel
311  32.1          4          98.0         70    2120          15.5          80       1                    chevrolet chevette
312  37.2          4          86.0         65    2019          16.4          80       3                            datsun 310
313  28.0          4         151.0         90    2678          16.5          80       1                    chevrolet citation
314  26.4          4         140.0         88    2870          18.1          80       1                         ford fairmont
315  24.3          4         151.0         90    3003          20.1          80       1                           amc concord
316  19.1          6         225.0         90    3381          18.7          80       1                           dodge aspen
317  34.3          4          97.0         78    2188          15.8          80       2                             audi 4000
318  29.8          4         134.0         90    2711          15.5          80       3                toyota corona liftback
319  31.3          4         120.0         75    2542          17.5          80       3                             mazda 626
320  37.0          4         119.0         92    2434          15.0          80       3                  datsun 510 hatchback
321  32.2          4         108.0         75    2265          15.2          80       3                        toyota corolla
322  46.6          4          86.0         65    2110          17.9          80       3                             mazda glc
323  27.9          4         156.0        105    2800          14.4          80       1                            dodge colt
324  40.8          4          85.0         65    2110          19.2          80       3                            datsun 210
325  44.3          4          90.0         48    2085          21.7          80       2                  vw rabbit c (diesel)
326  43.4          4          90.0         48    2335          23.7          80       2                    vw dasher (diesel)
327  36.4          5         121.0         67    2950          19.9          80       2                   audi 5000s (diesel)
328  30.0          4         146.0         67    3250          21.8          80       2                    mercedes-benz 240d
329  44.6          4          91.0         67    1850          13.8          80       3                   honda civic 1500 gl
330  40.9          4          85.0          ?    1835          17.3          80       2                  renault lecar deluxe
331  33.8          4          97.0         67    2145          18.0          80       3                             subaru dl
332  29.8          4          89.0         62    1845          15.3          80       2                      vokswagen rabbit
333  32.7          6         168.0        132    2910          11.4          80       3                         datsun 280-zx
334  23.7          3          70.0        100    2420          12.5          80       3                         mazda rx-7 gs
335  35.0          4         122.0         88    2500          15.1          80       2                     triumph tr7 coupe
336  23.6          4         140.0          ?    2905          14.3          80       1                    ford mustang cobra
337  32.4          4         107.0         72    2290          17.0          80       3                          honda accord
338  27.2          4         135.0         84    2490          15.7          81       1                      plymouth reliant
339  26.6          4         151.0         84    2635          16.4          81       1                         buick skylark
340  25.8          4         156.0         92    2620          14.4          81       1                dodge aries wagon (sw)
341  23.5          6         173.0        110    2725          12.6          81       1                    chevrolet citation
342  30.0          4         135.0         84    2385          12.9          81       1                      plymouth reliant
343  39.1          4          79.0         58    1755          16.9          81       3                        toyota starlet
344  39.0          4          86.0         64    1875          16.4          81       1                        plymouth champ
345  35.1          4          81.0         60    1760          16.1          81       3                      honda civic 1300
346  32.3          4          97.0         67    2065          17.8          81       3                                subaru
347  37.0          4          85.0         65    1975          19.4          81       3                        datsun 210 mpg
348  37.7          4          89.0         62    2050          17.3          81       3                         toyota tercel
349  34.1          4          91.0         68    1985          16.0          81       3                           mazda glc 4
350  34.7          4         105.0         63    2215          14.9          81       1                    plymouth horizon 4
351  34.4          4          98.0         65    2045          16.2          81       1                        ford escort 4w
352  29.9          4          98.0         65    2380          20.7          81       1                        ford escort 2h
353  33.0          4         105.0         74    2190          14.2          81       2                      volkswagen jetta
354  34.5          4         100.0          ?    2320          15.8          81       2                           renault 18i
355  33.7          4         107.0         75    2210          14.4          81       3                         honda prelude
356  32.4          4         108.0         75    2350          16.8          81       3                        toyota corolla
357  32.9          4         119.0        100    2615          14.8          81       3                          datsun 200sx
358  31.6          4         120.0         74    2635          18.3          81       3                             mazda 626
359  28.1          4         141.0         80    3230          20.4          81       2             peugeot 505s turbo diesel
360  30.7          6         145.0         76    3160          19.6          81       2                          volvo diesel
361  25.4          6         168.0        116    2900          12.6          81       3                       toyota cressida
362  24.2          6         146.0        120    2930          13.8          81       3                     datsun 810 maxima
363  22.4          6         231.0        110    3415          15.8          81       1                         buick century
364  26.6          8         350.0        105    3725          19.0          81       1                 oldsmobile cutlass ls
365  20.2          6         200.0         88    3060          17.1          81       1                       ford granada gl
366  17.6          6         225.0         85    3465          16.6          81       1                chrysler lebaron salon
367  28.0          4         112.0         88    2605          19.6          82       1                    chevrolet cavalier
368  27.0          4         112.0         88    2640          18.6          82       1              chevrolet cavalier wagon
369  34.0          4         112.0         88    2395          18.0          82       1             chevrolet cavalier 2-door
370  31.0          4         112.0         85    2575          16.2          82       1            pontiac j2000 se hatchback
371  29.0          4         135.0         84    2525          16.0          82       1                        dodge aries se
372  27.0          4         151.0         90    2735          18.0          82       1                       pontiac phoenix
373  24.0          4         140.0         92    2865          16.4          82       1                  ford fairmont futura
374  23.0          4         151.0          ?    3035          20.5          82       1                        amc concord dl
375  36.0          4         105.0         74    1980          15.3          82       2                   volkswagen rabbit l
376  37.0          4          91.0         68    2025          18.2          82       3                    mazda glc custom l
377  31.0          4          91.0         68    1970          17.6          82       3                      mazda glc custom
378  38.0          4         105.0         63    2125          14.7          82       1                plymouth horizon miser
379  36.0          4          98.0         70    2125          17.3          82       1                        mercury lynx l
380  36.0          4         120.0         88    2160          14.5          82       3                      nissan stanza xe
381  36.0          4         107.0         75    2205          14.5          82       3                          honda accord
382  34.0          4         108.0         70    2245          16.9          82       3                        toyota corolla
383  38.0          4          91.0         67    1965          15.0          82       3                           honda civic
384  32.0          4          91.0         67    1965          15.7          82       3                    honda civic (auto)
385  38.0          4          91.0         67    1995          16.2          82       3                         datsun 310 gx
386  25.0          6         181.0        110    2945          16.4          82       1                 buick century limited
387  38.0          6         262.0         85    3015          17.0          82       1     oldsmobile cutlass ciera (diesel)
388  26.0          4         156.0         92    2585          14.5          82       1            chrysler lebaron medallion
389  22.0          6         232.0        112    2835          14.7          82       1                        ford granada l
390  32.0          4         144.0         96    2665          13.9          82       3                      toyota celica gt
391  36.0          4         135.0         84    2370          13.0          82       1                     dodge charger 2.2
392  27.0          4         151.0         90    2950          17.3          82       1                      chevrolet camaro
393  27.0          4         140.0         86    2790          15.6          82       1                       ford mustang gl
394  44.0          4          97.0         52    2130          24.6          82       2                             vw pickup
395  32.0          4         135.0         84    2295          11.6          82       1                         dodge rampage
396  28.0          4         120.0         79    2625          18.6          82       1                           ford ranger
397  31.0          4         119.0         82    2720          19.4          82       1                            chevy s-10

Read Head items

df.head()
#print(df.head(10))

	mpg	cylinders	displacement	horsepower	weight	acceleration	model year	origin	car name
0	18.0	8	307.0	130	3504	12.0	70	1	chevrolet chevelle malibu
1	15.0	8	350.0	165	3693	11.5	70	1	buick skylark 320
2	18.0	8	318.0	150	3436	11.0	70	1	plymouth satellite
3	16.0	8	304.0	150	3433	12.0	70	1	amc rebel sst
4	17.0	8	302.0	140	3449	10.5	70	1	ford torino

Read tail

df.tail()

	mpg	cylinders	displacement	horsepower	weight	acceleration	model year	origin	car name
393	27.0	4	140.0	86	2790	15.6	82	1	ford mustang gl
394	44.0	4	97.0	52	2130	24.6	82	2	vw pickup
395	32.0	4	135.0	84	2295	11.6	82	1	dodge rampage
396	28.0	4	120.0	79	2625	18.6	82	1	ford ranger
397	31.0	4	119.0	82	2720	19.4	82	1	chevy s-10

Set options

pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)
print(df)

      mpg  cylinders  displacement horsepower  weight  acceleration  \
0    18.0          8         307.0        130    3504          12.0   
1    15.0          8         350.0        165    3693          11.5   
2    18.0          8         318.0        150    3436          11.0   
3    16.0          8         304.0        150    3433          12.0   
4    17.0          8         302.0        140    3449          10.5   
5    15.0          8         429.0        198    4341          10.0   
6    14.0          8         454.0        220    4354           9.0   
7    14.0          8         440.0        215    4312           8.5   
8    14.0          8         455.0        225    4425          10.0   
9    15.0          8         390.0        190    3850           8.5   
10   15.0          8         383.0        170    3563          10.0   
11   14.0          8         340.0        160    3609           8.0   
12   15.0          8         400.0        150    3761           9.5   
13   14.0          8         455.0        225    3086          10.0   
14   24.0          4         113.0         95    2372          15.0   
15   22.0          6         198.0         95    2833          15.5   
16   18.0          6         199.0         97    2774          15.5   
17   21.0          6         200.0         85    2587          16.0   
18   27.0          4          97.0         88    2130          14.5   
19   26.0          4          97.0         46    1835          20.5   
20   25.0          4         110.0         87    2672          17.5   
21   24.0          4         107.0         90    2430          14.5   
22   25.0          4         104.0         95    2375          17.5   
23   26.0          4         121.0        113    2234          12.5   
24   21.0          6         199.0         90    2648          15.0   
25   10.0          8         360.0        215    4615          14.0   
26   10.0          8         307.0        200    4376          15.0   
27   11.0          8         318.0        210    4382          13.5   
28    9.0          8         304.0        193    4732          18.5   
29   27.0          4          97.0         88    2130          14.5   
30   28.0          4         140.0         90    2264          15.5   
31   25.0          4         113.0         95    2228          14.0   
32   25.0          4          98.0          ?    2046          19.0   
33   19.0          6         232.0        100    2634          13.0   
34   16.0          6         225.0        105    3439          15.5   
35   17.0          6         250.0        100    3329          15.5   
36   19.0          6         250.0         88    3302          15.5   
37   18.0          6         232.0        100    3288          15.5   
38   14.0          8         350.0        165    4209          12.0   
39   14.0          8         400.0        175    4464          11.5   
40   14.0          8         351.0        153    4154          13.5   
41   14.0          8         318.0        150    4096          13.0   
42   12.0          8         383.0        180    4955          11.5   
43   13.0          8         400.0        170    4746          12.0   
44   13.0          8         400.0        175    5140          12.0   
45   18.0          6         258.0        110    2962          13.5   
46   22.0          4         140.0         72    2408          19.0   
47   19.0          6         250.0        100    3282          15.0   
48   18.0          6         250.0         88    3139          14.5   
49   23.0          4         122.0         86    2220          14.0   
50   28.0          4         116.0         90    2123          14.0   
51   30.0          4          79.0         70    2074          19.5   
52   30.0          4          88.0         76    2065          14.5   
53   31.0          4          71.0         65    1773          19.0   
54   35.0          4          72.0         69    1613          18.0   
55   27.0          4          97.0         60    1834          19.0   
56   26.0          4          91.0         70    1955          20.5   
57   24.0          4         113.0         95    2278          15.5   
58   25.0          4          97.5         80    2126          17.0   
59   23.0          4          97.0         54    2254          23.5   
60   20.0          4         140.0         90    2408          19.5   
61   21.0          4         122.0         86    2226          16.5   
62   13.0          8         350.0        165    4274          12.0   
63   14.0          8         400.0        175    4385          12.0   
64   15.0          8         318.0        150    4135          13.5   
65   14.0          8         351.0        153    4129          13.0   
66   17.0          8         304.0        150    3672          11.5   
67   11.0          8         429.0        208    4633          11.0   
68   13.0          8         350.0        155    4502          13.5   
69   12.0          8         350.0        160    4456          13.5   
70   13.0          8         400.0        190    4422          12.5   
71   19.0          3          70.0         97    2330          13.5   
72   15.0          8         304.0        150    3892          12.5   
73   13.0          8         307.0        130    4098          14.0   
74   13.0          8         302.0        140    4294          16.0   
75   14.0          8         318.0        150    4077          14.0   
76   18.0          4         121.0        112    2933          14.5   
77   22.0          4         121.0         76    2511          18.0   
78   21.0          4         120.0         87    2979          19.5   
79   26.0          4          96.0         69    2189          18.0   
80   22.0          4         122.0         86    2395          16.0   
81   28.0          4          97.0         92    2288          17.0   
82   23.0          4         120.0         97    2506          14.5   
83   28.0          4          98.0         80    2164          15.0   
84   27.0          4          97.0         88    2100          16.5   
85   13.0          8         350.0        175    4100          13.0   
86   14.0          8         304.0        150    3672          11.5   
87   13.0          8         350.0        145    3988          13.0   
88   14.0          8         302.0        137    4042          14.5   
89   15.0          8         318.0        150    3777          12.5   
90   12.0          8         429.0        198    4952          11.5   
91   13.0          8         400.0        150    4464          12.0   
92   13.0          8         351.0        158    4363          13.0   
93   14.0          8         318.0        150    4237          14.5   
94   13.0          8         440.0        215    4735          11.0   
95   12.0          8         455.0        225    4951          11.0   
96   13.0          8         360.0        175    3821          11.0   
97   18.0          6         225.0        105    3121          16.5   
98   16.0          6         250.0        100    3278          18.0   
99   18.0          6         232.0        100    2945          16.0   
100  18.0          6         250.0         88    3021          16.5   
101  23.0          6         198.0         95    2904          16.0   
102  26.0          4          97.0         46    1950          21.0   
103  11.0          8         400.0        150    4997          14.0   
104  12.0          8         400.0        167    4906          12.5   
105  13.0          8         360.0        170    4654          13.0   
106  12.0          8         350.0        180    4499          12.5   
107  18.0          6         232.0        100    2789          15.0   
108  20.0          4          97.0         88    2279          19.0   
109  21.0          4         140.0         72    2401          19.5   
110  22.0          4         108.0         94    2379          16.5   
111  18.0          3          70.0         90    2124          13.5   
112  19.0          4         122.0         85    2310          18.5   
113  21.0          6         155.0        107    2472          14.0   
114  26.0          4          98.0         90    2265          15.5   
115  15.0          8         350.0        145    4082          13.0   
116  16.0          8         400.0        230    4278           9.5   
117  29.0          4          68.0         49    1867          19.5   
118  24.0          4         116.0         75    2158          15.5   
119  20.0          4         114.0         91    2582          14.0   
120  19.0          4         121.0        112    2868          15.5   
121  15.0          8         318.0        150    3399          11.0   
122  24.0          4         121.0        110    2660          14.0   
123  20.0          6         156.0        122    2807          13.5   
124  11.0          8         350.0        180    3664          11.0   
125  20.0          6         198.0         95    3102          16.5   
126  21.0          6         200.0          ?    2875          17.0   
127  19.0          6         232.0        100    2901          16.0   
128  15.0          6         250.0        100    3336          17.0   
129  31.0          4          79.0         67    1950          19.0   
130  26.0          4         122.0         80    2451          16.5   
131  32.0          4          71.0         65    1836          21.0   
132  25.0          4         140.0         75    2542          17.0   
133  16.0          6         250.0        100    3781          17.0   
134  16.0          6         258.0        110    3632          18.0   
135  18.0          6         225.0        105    3613          16.5   
136  16.0          8         302.0        140    4141          14.0   
137  13.0          8         350.0        150    4699          14.5   
138  14.0          8         318.0        150    4457          13.5   
139  14.0          8         302.0        140    4638          16.0   
140  14.0          8         304.0        150    4257          15.5   
141  29.0          4          98.0         83    2219          16.5   
142  26.0          4          79.0         67    1963          15.5   
143  26.0          4          97.0         78    2300          14.5   
144  31.0          4          76.0         52    1649          16.5   
145  32.0          4          83.0         61    2003          19.0   
146  28.0          4          90.0         75    2125          14.5   
147  24.0          4          90.0         75    2108          15.5   
148  26.0          4         116.0         75    2246          14.0   
149  24.0          4         120.0         97    2489          15.0   
150  26.0          4         108.0         93    2391          15.5   
151  31.0          4          79.0         67    2000          16.0   
152  19.0          6         225.0         95    3264          16.0   
153  18.0          6         250.0        105    3459          16.0   
154  15.0          6         250.0         72    3432          21.0   
155  15.0          6         250.0         72    3158          19.5   
156  16.0          8         400.0        170    4668          11.5   
157  15.0          8         350.0        145    4440          14.0   
158  16.0          8         318.0        150    4498          14.5   
159  14.0          8         351.0        148    4657          13.5   
160  17.0          6         231.0        110    3907          21.0   
161  16.0          6         250.0        105    3897          18.5   
162  15.0          6         258.0        110    3730          19.0   
163  18.0          6         225.0         95    3785          19.0   
164  21.0          6         231.0        110    3039          15.0   
165  20.0          8         262.0        110    3221          13.5   
166  13.0          8         302.0        129    3169          12.0   
167  29.0          4          97.0         75    2171          16.0   
168  23.0          4         140.0         83    2639          17.0   
169  20.0          6         232.0        100    2914          16.0   
170  23.0          4         140.0         78    2592          18.5   
171  24.0          4         134.0         96    2702          13.5   
172  25.0          4          90.0         71    2223          16.5   
173  24.0          4         119.0         97    2545          17.0   
174  18.0          6         171.0         97    2984          14.5   
175  29.0          4          90.0         70    1937          14.0   
176  19.0          6         232.0         90    3211          17.0   
177  23.0          4         115.0         95    2694          15.0   
178  23.0          4         120.0         88    2957          17.0   
179  22.0          4         121.0         98    2945          14.5   
180  25.0          4         121.0        115    2671          13.5   
181  33.0          4          91.0         53    1795          17.5   
182  28.0          4         107.0         86    2464          15.5   
183  25.0          4         116.0         81    2220          16.9   
184  25.0          4         140.0         92    2572          14.9   
185  26.0          4          98.0         79    2255          17.7   
186  27.0          4         101.0         83    2202          15.3   
187  17.5          8         305.0        140    4215          13.0   
188  16.0          8         318.0        150    4190          13.0   
189  15.5          8         304.0        120    3962          13.9   
190  14.5          8         351.0        152    4215          12.8   
191  22.0          6         225.0        100    3233          15.4   
192  22.0          6         250.0        105    3353          14.5   
193  24.0          6         200.0         81    3012          17.6   
194  22.5          6         232.0         90    3085          17.6   
195  29.0          4          85.0         52    2035          22.2   
196  24.5          4          98.0         60    2164          22.1   
197  29.0          4          90.0         70    1937          14.2   
198  33.0          4          91.0         53    1795          17.4   
199  20.0          6         225.0        100    3651          17.7   
200  18.0          6         250.0         78    3574          21.0   
201  18.5          6         250.0        110    3645          16.2   
202  17.5          6         258.0         95    3193          17.8   
203  29.5          4          97.0         71    1825          12.2   
204  32.0          4          85.0         70    1990          17.0   
205  28.0          4          97.0         75    2155          16.4   
206  26.5          4         140.0         72    2565          13.6   
207  20.0          4         130.0        102    3150          15.7   
208  13.0          8         318.0        150    3940          13.2   
209  19.0          4         120.0         88    3270          21.9   
210  19.0          6         156.0        108    2930          15.5   
211  16.5          6         168.0        120    3820          16.7   
212  16.5          8         350.0        180    4380          12.1   
213  13.0          8         350.0        145    4055          12.0   
214  13.0          8         302.0        130    3870          15.0   
215  13.0          8         318.0        150    3755          14.0   
216  31.5          4          98.0         68    2045          18.5   
217  30.0          4         111.0         80    2155          14.8   
218  36.0          4          79.0         58    1825          18.6   
219  25.5          4         122.0         96    2300          15.5   
220  33.5          4          85.0         70    1945          16.8   
221  17.5          8         305.0        145    3880          12.5   
222  17.0          8         260.0        110    4060          19.0   
223  15.5          8         318.0        145    4140          13.7   
224  15.0          8         302.0        130    4295          14.9   
225  17.5          6         250.0        110    3520          16.4   
226  20.5          6         231.0        105    3425          16.9   
227  19.0          6         225.0        100    3630          17.7   
228  18.5          6         250.0         98    3525          19.0   
229  16.0          8         400.0        180    4220          11.1   
230  15.5          8         350.0        170    4165          11.4   
231  15.5          8         400.0        190    4325          12.2   
232  16.0          8         351.0        149    4335          14.5   
233  29.0          4          97.0         78    1940          14.5   
234  24.5          4         151.0         88    2740          16.0   
235  26.0          4          97.0         75    2265          18.2   
236  25.5          4         140.0         89    2755          15.8   
237  30.5          4          98.0         63    2051          17.0   
238  33.5          4          98.0         83    2075          15.9   
239  30.0          4          97.0         67    1985          16.4   
240  30.5          4          97.0         78    2190          14.1   
241  22.0          6         146.0         97    2815          14.5   
242  21.5          4         121.0        110    2600          12.8   
243  21.5          3          80.0        110    2720          13.5   
244  43.1          4          90.0         48    1985          21.5   
245  36.1          4          98.0         66    1800          14.4   
246  32.8          4          78.0         52    1985          19.4   
247  39.4          4          85.0         70    2070          18.6   
248  36.1          4          91.0         60    1800          16.4   
249  19.9          8         260.0        110    3365          15.5   
250  19.4          8         318.0        140    3735          13.2   
251  20.2          8         302.0        139    3570          12.8   
252  19.2          6         231.0        105    3535          19.2   
253  20.5          6         200.0         95    3155          18.2   
254  20.2          6         200.0         85    2965          15.8   
255  25.1          4         140.0         88    2720          15.4   
256  20.5          6         225.0        100    3430          17.2   
257  19.4          6         232.0         90    3210          17.2   
258  20.6          6         231.0        105    3380          15.8   
259  20.8          6         200.0         85    3070          16.7   
260  18.6          6         225.0        110    3620          18.7   
261  18.1          6         258.0        120    3410          15.1   
262  19.2          8         305.0        145    3425          13.2   
263  17.7          6         231.0        165    3445          13.4   
264  18.1          8         302.0        139    3205          11.2   
265  17.5          8         318.0        140    4080          13.7   
266  30.0          4          98.0         68    2155          16.5   
267  27.5          4         134.0         95    2560          14.2   
268  27.2          4         119.0         97    2300          14.7   
269  30.9          4         105.0         75    2230          14.5   
270  21.1          4         134.0         95    2515          14.8   
271  23.2          4         156.0        105    2745          16.7   
272  23.8          4         151.0         85    2855          17.6   
273  23.9          4         119.0         97    2405          14.9   
274  20.3          5         131.0        103    2830          15.9   
275  17.0          6         163.0        125    3140          13.6   
276  21.6          4         121.0        115    2795          15.7   
277  16.2          6         163.0        133    3410          15.8   
278  31.5          4          89.0         71    1990          14.9   
279  29.5          4          98.0         68    2135          16.6   
280  21.5          6         231.0        115    3245          15.4   
281  19.8          6         200.0         85    2990          18.2   
282  22.3          4         140.0         88    2890          17.3   
283  20.2          6         232.0         90    3265          18.2   
284  20.6          6         225.0        110    3360          16.6   
285  17.0          8         305.0        130    3840          15.4   
286  17.6          8         302.0        129    3725          13.4   
287  16.5          8         351.0        138    3955          13.2   
288  18.2          8         318.0        135    3830          15.2   
289  16.9          8         350.0        155    4360          14.9   
290  15.5          8         351.0        142    4054          14.3   
291  19.2          8         267.0        125    3605          15.0   
292  18.5          8         360.0        150    3940          13.0   
293  31.9          4          89.0         71    1925          14.0   
294  34.1          4          86.0         65    1975          15.2   
295  35.7          4          98.0         80    1915          14.4   
296  27.4          4         121.0         80    2670          15.0   
297  25.4          5         183.0         77    3530          20.1   
298  23.0          8         350.0        125    3900          17.4   
299  27.2          4         141.0         71    3190          24.8   
300  23.9          8         260.0         90    3420          22.2   
301  34.2          4         105.0         70    2200          13.2   
302  34.5          4         105.0         70    2150          14.9   
303  31.8          4          85.0         65    2020          19.2   
304  37.3          4          91.0         69    2130          14.7   
305  28.4          4         151.0         90    2670          16.0   
306  28.8          6         173.0        115    2595          11.3   
307  26.8          6         173.0        115    2700          12.9   
308  33.5          4         151.0         90    2556          13.2   
309  41.5          4          98.0         76    2144          14.7   
310  38.1          4          89.0         60    1968          18.8   
311  32.1          4          98.0         70    2120          15.5   
312  37.2          4          86.0         65    2019          16.4   
313  28.0          4         151.0         90    2678          16.5   
314  26.4          4         140.0         88    2870          18.1   
315  24.3          4         151.0         90    3003          20.1   
316  19.1          6         225.0         90    3381          18.7   
317  34.3          4          97.0         78    2188          15.8   
318  29.8          4         134.0         90    2711          15.5   
319  31.3          4         120.0         75    2542          17.5   
320  37.0          4         119.0         92    2434          15.0   
321  32.2          4         108.0         75    2265          15.2   
322  46.6          4          86.0         65    2110          17.9   
323  27.9          4         156.0        105    2800          14.4   
324  40.8          4          85.0         65    2110          19.2   
325  44.3          4          90.0         48    2085          21.7   
326  43.4          4          90.0         48    2335          23.7   
327  36.4          5         121.0         67    2950          19.9   
328  30.0          4         146.0         67    3250          21.8   
329  44.6          4          91.0         67    1850          13.8   
330  40.9          4          85.0          ?    1835          17.3   
331  33.8          4          97.0         67    2145          18.0   
332  29.8          4          89.0         62    1845          15.3   
333  32.7          6         168.0        132    2910          11.4   
334  23.7          3          70.0        100    2420          12.5   
335  35.0          4         122.0         88    2500          15.1   
336  23.6          4         140.0          ?    2905          14.3   
337  32.4          4         107.0         72    2290          17.0   
338  27.2          4         135.0         84    2490          15.7   
339  26.6          4         151.0         84    2635          16.4   
340  25.8          4         156.0         92    2620          14.4   
341  23.5          6         173.0        110    2725          12.6   
342  30.0          4         135.0         84    2385          12.9   
343  39.1          4          79.0         58    1755          16.9   
344  39.0          4          86.0         64    1875          16.4   
345  35.1          4          81.0         60    1760          16.1   
346  32.3          4          97.0         67    2065          17.8   
347  37.0          4          85.0         65    1975          19.4   
348  37.7          4          89.0         62    2050          17.3   
349  34.1          4          91.0         68    1985          16.0   
350  34.7          4         105.0         63    2215          14.9   
351  34.4          4          98.0         65    2045          16.2   
352  29.9          4          98.0         65    2380          20.7   
353  33.0          4         105.0         74    2190          14.2   
354  34.5          4         100.0          ?    2320          15.8   
355  33.7          4         107.0         75    2210          14.4   
356  32.4          4         108.0         75    2350          16.8   
357  32.9          4         119.0        100    2615          14.8   
358  31.6          4         120.0         74    2635          18.3   
359  28.1          4         141.0         80    3230          20.4   
360  30.7          6         145.0         76    3160          19.6   
361  25.4          6         168.0        116    2900          12.6   
362  24.2          6         146.0        120    2930          13.8   
363  22.4          6         231.0        110    3415          15.8   
364  26.6          8         350.0        105    3725          19.0   
365  20.2          6         200.0         88    3060          17.1   
366  17.6          6         225.0         85    3465          16.6   
367  28.0          4         112.0         88    2605          19.6   
368  27.0          4         112.0         88    2640          18.6   
369  34.0          4         112.0         88    2395          18.0   
370  31.0          4         112.0         85    2575          16.2   
371  29.0          4         135.0         84    2525          16.0   
372  27.0          4         151.0         90    2735          18.0   
373  24.0          4         140.0         92    2865          16.4   
374  23.0          4         151.0          ?    3035          20.5   
375  36.0          4         105.0         74    1980          15.3   
376  37.0          4          91.0         68    2025          18.2   
377  31.0          4          91.0         68    1970          17.6   
378  38.0          4         105.0         63    2125          14.7   
379  36.0          4          98.0         70    2125          17.3   
380  36.0          4         120.0         88    2160          14.5   
381  36.0          4         107.0         75    2205          14.5   
382  34.0          4         108.0         70    2245          16.9   
383  38.0          4          91.0         67    1965          15.0   
384  32.0          4          91.0         67    1965          15.7   
385  38.0          4          91.0         67    1995          16.2   
386  25.0          6         181.0        110    2945          16.4   
387  38.0          6         262.0         85    3015          17.0   
388  26.0          4         156.0         92    2585          14.5   
389  22.0          6         232.0        112    2835          14.7   
390  32.0          4         144.0         96    2665          13.9   
391  36.0          4         135.0         84    2370          13.0   
392  27.0          4         151.0         90    2950          17.3   
393  27.0          4         140.0         86    2790          15.6   
394  44.0          4          97.0         52    2130          24.6   
395  32.0          4         135.0         84    2295          11.6   
396  28.0          4         120.0         79    2625          18.6   
397  31.0          4         119.0         82    2720          19.4   

     model year  origin                              car name  
0            70       1             chevrolet chevelle malibu  
1            70       1                     buick skylark 320  
2            70       1                    plymouth satellite  
3            70       1                         amc rebel sst  
4            70       1                           ford torino  
5            70       1                      ford galaxie 500  
6            70       1                      chevrolet impala  
7            70       1                     plymouth fury iii  
8            70       1                      pontiac catalina  
9            70       1                    amc ambassador dpl  
10           70       1                   dodge challenger se  
11           70       1                    plymouth 'cuda 340  
12           70       1                 chevrolet monte carlo  
13           70       1               buick estate wagon (sw)  
14           70       3                 toyota corona mark ii  
15           70       1                       plymouth duster  
16           70       1                            amc hornet  
17           70       1                         ford maverick  
18           70       3                          datsun pl510  
19           70       2          volkswagen 1131 deluxe sedan  
20           70       2                           peugeot 504  
21           70       2                           audi 100 ls  
22           70       2                              saab 99e  
23           70       2                              bmw 2002  
24           70       1                           amc gremlin  
25           70       1                             ford f250  
26           70       1                             chevy c20  
27           70       1                            dodge d200  
28           70       1                              hi 1200d  
29           71       3                          datsun pl510  
30           71       1                   chevrolet vega 2300  
31           71       3                         toyota corona  
32           71       1                            ford pinto  
33           71       1                           amc gremlin  
34           71       1             plymouth satellite custom  
35           71       1             chevrolet chevelle malibu  
36           71       1                       ford torino 500  
37           71       1                           amc matador  
38           71       1                      chevrolet impala  
39           71       1             pontiac catalina brougham  
40           71       1                      ford galaxie 500  
41           71       1                     plymouth fury iii  
42           71       1                     dodge monaco (sw)  
43           71       1              ford country squire (sw)  
44           71       1                   pontiac safari (sw)  
45           71       1            amc hornet sportabout (sw)  
46           71       1                   chevrolet vega (sw)  
47           71       1                      pontiac firebird  
48           71       1                          ford mustang  
49           71       1                    mercury capri 2000  
50           71       2                             opel 1900  
51           71       2                           peugeot 304  
52           71       2                             fiat 124b  
53           71       3                   toyota corolla 1200  
54           71       3                           datsun 1200  
55           71       2                  volkswagen model 111  
56           71       1                      plymouth cricket  
57           72       3                 toyota corona hardtop  
58           72       1                    dodge colt hardtop  
59           72       2                     volkswagen type 3  
60           72       1                        chevrolet vega  
61           72       1                   ford pinto runabout  
62           72       1                      chevrolet impala  
63           72       1                      pontiac catalina  
64           72       1                     plymouth fury iii  
65           72       1                      ford galaxie 500  
66           72       1                    amc ambassador sst  
67           72       1                       mercury marquis  
68           72       1                  buick lesabre custom  
69           72       1            oldsmobile delta 88 royale  
70           72       1                chrysler newport royal  
71           72       3                       mazda rx2 coupe  
72           72       1                      amc matador (sw)  
73           72       1      chevrolet chevelle concours (sw)  
74           72       1                 ford gran torino (sw)  
75           72       1        plymouth satellite custom (sw)  
76           72       2                       volvo 145e (sw)  
77           72       2                   volkswagen 411 (sw)  
78           72       2                      peugeot 504 (sw)  
79           72       2                       renault 12 (sw)  
80           72       1                       ford pinto (sw)  
81           72       3                       datsun 510 (sw)  
82           72       3           toyouta corona mark ii (sw)  
83           72       1                       dodge colt (sw)  
84           72       3              toyota corolla 1600 (sw)  
85           73       1                     buick century 350  
86           73       1                           amc matador  
87           73       1                      chevrolet malibu  
88           73       1                      ford gran torino  
89           73       1                  dodge coronet custom  
90           73       1              mercury marquis brougham  
91           73       1             chevrolet caprice classic  
92           73       1                              ford ltd  
93           73       1              plymouth fury gran sedan  
94           73       1          chrysler new yorker brougham  
95           73       1              buick electra 225 custom  
96           73       1               amc ambassador brougham  
97           73       1                      plymouth valiant  
98           73       1                 chevrolet nova custom  
99           73       1                            amc hornet  
100          73       1                         ford maverick  
101          73       1                       plymouth duster  
102          73       2               volkswagen super beetle  
103          73       1                      chevrolet impala  
104          73       1                          ford country  
105          73       1                plymouth custom suburb  
106          73       1              oldsmobile vista cruiser  
107          73       1                           amc gremlin  
108          73       3                         toyota carina  
109          73       1                        chevrolet vega  
110          73       3                            datsun 610  
111          73       3                             maxda rx3  
112          73       1                            ford pinto  
113          73       1                      mercury capri v6  
114          73       2                  fiat 124 sport coupe  
115          73       1               chevrolet monte carlo s  
116          73       1                    pontiac grand prix  
117          73       2                              fiat 128  
118          73       2                            opel manta  
119          73       2                            audi 100ls  
120          73       2                           volvo 144ea  
121          73       1                     dodge dart custom  
122          73       2                             saab 99le  
123          73       3                        toyota mark ii  
124          73       1                      oldsmobile omega  
125          74       1                       plymouth duster  
126          74       1                         ford maverick  
127          74       1                            amc hornet  
128          74       1                        chevrolet nova  
129          74       3                           datsun b210  
130          74       1                            ford pinto  
131          74       3                   toyota corolla 1200  
132          74       1                        chevrolet vega  
133          74       1     chevrolet chevelle malibu classic  
134          74       1                           amc matador  
135          74       1            plymouth satellite sebring  
136          74       1                      ford gran torino  
137          74       1              buick century luxus (sw)  
138          74       1             dodge coronet custom (sw)  
139          74       1                 ford gran torino (sw)  
140          74       1                      amc matador (sw)  
141          74       2                              audi fox  
142          74       2                     volkswagen dasher  
143          74       2                            opel manta  
144          74       3                         toyota corona  
145          74       3                            datsun 710  
146          74       1                            dodge colt  
147          74       2                              fiat 128  
148          74       2                           fiat 124 tc  
149          74       3                           honda civic  
150          74       3                                subaru  
151          74       2                             fiat x1.9  
152          75       1               plymouth valiant custom  
153          75       1                        chevrolet nova  
154          75       1                       mercury monarch  
155          75       1                         ford maverick  
156          75       1                      pontiac catalina  
157          75       1                     chevrolet bel air  
158          75       1                   plymouth grand fury  
159          75       1                              ford ltd  
160          75       1                         buick century  
161          75       1             chevroelt chevelle malibu  
162          75       1                           amc matador  
163          75       1                         plymouth fury  
164          75       1                         buick skyhawk  
165          75       1                   chevrolet monza 2+2  
166          75       1                       ford mustang ii  
167          75       3                        toyota corolla  
168          75       1                            ford pinto  
169          75       1                           amc gremlin  
170          75       1                         pontiac astro  
171          75       3                         toyota corona  
172          75       2                     volkswagen dasher  
173          75       3                            datsun 710  
174          75       1                            ford pinto  
175          75       2                     volkswagen rabbit  
176          75       1                             amc pacer  
177          75       2                            audi 100ls  
178          75       2                           peugeot 504  
179          75       2                           volvo 244dl  
180          75       2                             saab 99le  
181          75       3                      honda civic cvcc  
182          76       2                              fiat 131  
183          76       2                             opel 1900  
184          76       1                              capri ii  
185          76       1                            dodge colt  
186          76       2                          renault 12tl  
187          76       1     chevrolet chevelle malibu classic  
188          76       1                dodge coronet brougham  
189          76       1                           amc matador  
190          76       1                      ford gran torino  
191          76       1                      plymouth valiant  
192          76       1                        chevrolet nova  
193          76       1                         ford maverick  
194          76       1                            amc hornet  
195          76       1                    chevrolet chevette  
196          76       1                       chevrolet woody  
197          76       2                             vw rabbit  
198          76       3                           honda civic  
199          76       1                        dodge aspen se  
200          76       1                     ford granada ghia  
201          76       1                    pontiac ventura sj  
202          76       1                         amc pacer d/l  
203          76       2                     volkswagen rabbit  
204          76       3                          datsun b-210  
205          76       3                        toyota corolla  
206          76       1                            ford pinto  
207          76       2                             volvo 245  
208          76       1            plymouth volare premier v8  
209          76       2                           peugeot 504  
210          76       3                        toyota mark ii  
211          76       2                    mercedes-benz 280s  
212          76       1                      cadillac seville  
213          76       1                             chevy c10  
214          76       1                             ford f108  
215          76       1                            dodge d100  
216          77       3                     honda accord cvcc  
217          77       1               buick opel isuzu deluxe  
218          77       2                         renault 5 gtl  
219          77       1                     plymouth arrow gs  
220          77       3                 datsun f-10 hatchback  
221          77       1             chevrolet caprice classic  
222          77       1            oldsmobile cutlass supreme  
223          77       1                 dodge monaco brougham  
224          77       1               mercury cougar brougham  
225          77       1                    chevrolet concours  
226          77       1                         buick skylark  
227          77       1                plymouth volare custom  
228          77       1                          ford granada  
229          77       1                 pontiac grand prix lj  
230          77       1          chevrolet monte carlo landau  
231          77       1                      chrysler cordoba  
232          77       1                      ford thunderbird  
233          77       2              volkswagen rabbit custom  
234          77       1                 pontiac sunbird coupe  
235          77       3               toyota corolla liftback  
236          77       1                   ford mustang ii 2+2  
237          77       1                    chevrolet chevette  
238          77       1                        dodge colt m/m  
239          77       3                             subaru dl  
240          77       2                     volkswagen dasher  
241          77       3                            datsun 810  
242          77       2                              bmw 320i  
243          77       3                            mazda rx-4  
244          78       2       volkswagen rabbit custom diesel  
245          78       1                           ford fiesta  
246          78       3                      mazda glc deluxe  
247          78       3                        datsun b210 gx  
248          78       3                      honda civic cvcc  
249          78       1     oldsmobile cutlass salon brougham  
250          78       1                        dodge diplomat  
251          78       1                  mercury monarch ghia  
252          78       1                    pontiac phoenix lj  
253          78       1                      chevrolet malibu  
254          78       1                  ford fairmont (auto)  
255          78       1                   ford fairmont (man)  
256          78       1                       plymouth volare  
257          78       1                           amc concord  
258          78       1                 buick century special  
259          78       1                        mercury zephyr  
260          78       1                           dodge aspen  
261          78       1                       amc concord d/l  
262          78       1          chevrolet monte carlo landau  
263          78       1       buick regal sport coupe (turbo)  
264          78       1                           ford futura  
265          78       1                       dodge magnum xe  
266          78       1                    chevrolet chevette  
267          78       3                         toyota corona  
268          78       3                            datsun 510  
269          78       1                            dodge omni  
270          78       3             toyota celica gt liftback  
271          78       1                      plymouth sapporo  
272          78       1                oldsmobile starfire sx  
273          78       3                         datsun 200-sx  
274          78       2                             audi 5000  
275          78       2                           volvo 264gl  
276          78       2                            saab 99gle  
277          78       2                         peugeot 604sl  
278          78       2                   volkswagen scirocco  
279          78       3                       honda accord lx  
280          79       1                     pontiac lemans v6  
281          79       1                      mercury zephyr 6  
282          79       1                       ford fairmont 4  
283          79       1                      amc concord dl 6  
284          79       1                         dodge aspen 6  
285          79       1             chevrolet caprice classic  
286          79       1                       ford ltd landau  
287          79       1                 mercury grand marquis  
288          79       1                       dodge st. regis  
289          79       1               buick estate wagon (sw)  
290          79       1              ford country squire (sw)  
291          79       1         chevrolet malibu classic (sw)  
292          79       1  chrysler lebaron town @ country (sw)  
293          79       2                      vw rabbit custom  
294          79       3                      maxda glc deluxe  
295          79       1           dodge colt hatchback custom  
296          79       1                         amc spirit dl  
297          79       2                    mercedes benz 300d  
298          79       1                     cadillac eldorado  
299          79       2                           peugeot 504  
300          79       1     oldsmobile cutlass salon brougham  
301          79       1                      plymouth horizon  
302          79       1                  plymouth horizon tc3  
303          79       3                            datsun 210  
304          79       2                    fiat strada custom  
305          79       1                 buick skylark limited  
306          79       1                    chevrolet citation  
307          79       1             oldsmobile omega brougham  
308          79       1                       pontiac phoenix  
309          80       2                             vw rabbit  
310          80       3                 toyota corolla tercel  
311          80       1                    chevrolet chevette  
312          80       3                            datsun 310  
313          80       1                    chevrolet citation  
314          80       1                         ford fairmont  
315          80       1                           amc concord  
316          80       1                           dodge aspen  
317          80       2                             audi 4000  
318          80       3                toyota corona liftback  
319          80       3                             mazda 626  
320          80       3                  datsun 510 hatchback  
321          80       3                        toyota corolla  
322          80       3                             mazda glc  
323          80       1                            dodge colt  
324          80       3                            datsun 210  
325          80       2                  vw rabbit c (diesel)  
326          80       2                    vw dasher (diesel)  
327          80       2                   audi 5000s (diesel)  
328          80       2                    mercedes-benz 240d  
329          80       3                   honda civic 1500 gl  
330          80       2                  renault lecar deluxe  
331          80       3                             subaru dl  
332          80       2                      vokswagen rabbit  
333          80       3                         datsun 280-zx  
334          80       3                         mazda rx-7 gs  
335          80       2                     triumph tr7 coupe  
336          80       1                    ford mustang cobra  
337          80       3                          honda accord  
338          81       1                      plymouth reliant  
339          81       1                         buick skylark  
340          81       1                dodge aries wagon (sw)  
341          81       1                    chevrolet citation  
342          81       1                      plymouth reliant  
343          81       3                        toyota starlet  
344          81       1                        plymouth champ  
345          81       3                      honda civic 1300  
346          81       3                                subaru  
347          81       3                        datsun 210 mpg  
348          81       3                         toyota tercel  
349          81       3                           mazda glc 4  
350          81       1                    plymouth horizon 4  
351          81       1                        ford escort 4w  
352          81       1                        ford escort 2h  
353          81       2                      volkswagen jetta  
354          81       2                           renault 18i  
355          81       3                         honda prelude  
356          81       3                        toyota corolla  
357          81       3                          datsun 200sx  
358          81       3                             mazda 626  
359          81       2             peugeot 505s turbo diesel  
360          81       2                          volvo diesel  
361          81       3                       toyota cressida  
362          81       3                     datsun 810 maxima  
363          81       1                         buick century  
364          81       1                 oldsmobile cutlass ls  
365          81       1                       ford granada gl  
366          81       1                chrysler lebaron salon  
367          82       1                    chevrolet cavalier  
368          82       1              chevrolet cavalier wagon  
369          82       1             chevrolet cavalier 2-door  
370          82       1            pontiac j2000 se hatchback  
371          82       1                        dodge aries se  
372          82       1                       pontiac phoenix  
373          82       1                  ford fairmont futura  
374          82       1                        amc concord dl  
375          82       2                   volkswagen rabbit l  
376          82       3                    mazda glc custom l  
377          82       3                      mazda glc custom  
378          82       1                plymouth horizon miser  
379          82       1                        mercury lynx l  
380          82       3                      nissan stanza xe  
381          82       3                          honda accord  
382          82       3                        toyota corolla  
383          82       3                           honda civic  
384          82       3                    honda civic (auto)  
385          82       3                         datsun 310 gx  
386          82       1                 buick century limited  
387          82       1     oldsmobile cutlass ciera (diesel)  
388          82       1            chrysler lebaron medallion  
389          82       1                        ford granada l  
390          82       3                      toyota celica gt  
391          82       1                     dodge charger 2.2  
392          82       1                      chevrolet camaro  
393          82       1                       ford mustang gl  
394          82       2                             vw pickup  
395          82       1                         dodge rampage  
396          82       1                           ford ranger  
397          82       1                            chevy s-10

INFO() METHOD

### The info() method also tells us how many Non-Null values there are present in each column
print(df.info())
# Use colab for large memory data

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 398 entries, 0 to 397
Data columns (total 9 columns):
 #   Column        Non-Null Count  Dtype  
---  ------        --------------  -----  
 0   mpg           398 non-null    float64
 1   cylinders     398 non-null    int64  
 2   displacement  398 non-null    float64
 3   horsepower    398 non-null    object 
 4   weight        398 non-null    int64  
 5   acceleration  398 non-null    float64
 6   model year    398 non-null    int64  
 7   origin        398 non-null    int64  
 8   car name      398 non-null    object 
dtypes: float64(3), int64(4), object(2)
memory usage: 28.1+ KB
None

SHAPE METHOD

print(df.shape)
# tuple of No of Rows and columns

(398, 9)

1.3 Statistical Analysis -corr(), parallel_coordinates(),scatter_matrix(), describe()

STATISTICAL FIGURES

df.describe()

	mpg	cylinders	displacement	weight	acceleration	model year	origin
count	398.000000	398.000000	398.000000	398.000000	398.000000	398.000000	398.000000
mean	23.514573	5.454774	193.425879	2970.424623	15.568090	76.010050	1.572864
std	7.815984	1.701004	104.269838	846.841774	2.757689	3.697627	0.802055
min	9.000000	3.000000	68.000000	1613.000000	8.000000	70.000000	1.000000
25%	17.500000	4.000000	104.250000	2223.750000	13.825000	73.000000	1.000000
50%	23.000000	4.000000	148.500000	2803.500000	15.500000	76.000000	1.000000
75%	29.000000	8.000000	262.000000	3608.000000	17.175000	79.000000	2.000000
max	46.600000	8.000000	455.000000	5140.000000	24.800000	82.000000	3.000000

INCLUDE PARAMETER

df.describe(include='all')
# unique top and freq
# topmost frequency = top 150 is 22 times

	mpg	cylinders	displacement	horsepower	weight	acceleration	model year	origin	car name
count	398.000000	398.000000	398.000000	398	398.000000	398.000000	398.000000	398.000000	398
unique	NaN	NaN	NaN	94	NaN	NaN	NaN	NaN	305
top	NaN	NaN	NaN	150	NaN	NaN	NaN	NaN	ford pinto
freq	NaN	NaN	NaN	22	NaN	NaN	NaN	NaN	6
mean	23.514573	5.454774	193.425879	NaN	2970.424623	15.568090	76.010050	1.572864	NaN
std	7.815984	1.701004	104.269838	NaN	846.841774	2.757689	3.697627	0.802055	NaN
min	9.000000	3.000000	68.000000	NaN	1613.000000	8.000000	70.000000	1.000000	NaN
25%	17.500000	4.000000	104.250000	NaN	2223.750000	13.825000	73.000000	1.000000	NaN
50%	23.000000	4.000000	148.500000	NaN	2803.500000	15.500000	76.000000	1.000000	NaN
75%	29.000000	8.000000	262.000000	NaN	3608.000000	17.175000	79.000000	2.000000	NaN
max	46.600000	8.000000	455.000000	NaN	5140.000000	24.800000	82.000000	3.000000	NaN

DESCRIBE METHOD

import numpy as np
df.describe(exclude=[np.number])
#Exclude numeric columns in a ``DataFrame`` description.

	horsepower	car name
count	398	398
unique	94	305
top	150	ford pinto
freq	22	6

NUMERIC COLUMNS

df.describe(include=[np.number])
#Include numeric columns in a ``DataFrame`` description.

	mpg	cylinders	displacement	weight	acceleration	model year	origin
count	398.000000	398.000000	398.000000	398.000000	398.000000	398.000000	398.000000
mean	23.514573	5.454774	193.425879	2970.424623	15.568090	76.010050	1.572864
std	7.815984	1.701004	104.269838	846.841774	2.757689	3.697627	0.802055
min	9.000000	3.000000	68.000000	1613.000000	8.000000	70.000000	1.000000
25%	17.500000	4.000000	104.250000	2223.750000	13.825000	73.000000	1.000000
50%	23.000000	4.000000	148.500000	2803.500000	15.500000	76.000000	1.000000
75%	29.000000	8.000000	262.000000	3608.000000	17.175000	79.000000	2.000000
max	46.600000	8.000000	455.000000	5140.000000	24.800000	82.000000	3.000000

PERCENTILES

df.describe(percentiles=[0.1,0.2,0.3])

	mpg	cylinders	displacement	weight	acceleration	model year	origin
count	398.000000	398.000000	398.000000	398.000000	398.000000	398.000000	398.000000
mean	23.514573	5.454774	193.425879	2970.424623	15.568090	76.010050	1.572864
std	7.815984	1.701004	104.269838	846.841774	2.757689	3.697627	0.802055
min	9.000000	3.000000	68.000000	1613.000000	8.000000	70.000000	1.000000
10%	14.000000	4.000000	90.000000	1988.500000	12.000000	71.000000	1.000000
20%	16.000000	4.000000	98.000000	2155.000000	13.500000	72.000000	1.000000
30%	18.000000	4.000000	112.000000	2301.000000	14.200000	73.000000	1.000000
50%	23.000000	4.000000	148.500000	2803.500000	15.500000	76.000000	1.000000
max	46.600000	8.000000	455.000000	5140.000000	24.800000	82.000000	3.000000

SLICED DESCRIPTION

# Sliced description
df[['mpg','cylinders']].describe()

	mpg	cylinders
count	398.000000	398.000000
mean	23.514573	5.454774
std	7.815984	1.701004
min	9.000000	3.000000
25%	17.500000	4.000000
50%	23.000000	4.000000
75%	29.000000	8.000000
max	46.600000	8.000000

QUANTILE

df.quantile()

mpg               23.0
cylinders          4.0
displacement     148.5
weight          2803.5
acceleration      15.5
model year        76.0
origin             1.0
Name: 0.5, dtype: float64

CORRELATION

# Relation between attributes
# - 1 - perfect correlation
# - 0 - no corelation
df.corr()

	mpg	cylinders	displacement	weight	acceleration	model year	origin
mpg	1.000000	-0.775396	-0.804203	-0.831741	0.420289	0.579267	0.563450
cylinders	-0.775396	1.000000	0.950721	0.896017	-0.505419	-0.348746	-0.562543
displacement	-0.804203	0.950721	1.000000	0.932824	-0.543684	-0.370164	-0.609409
weight	-0.831741	0.896017	0.932824	1.000000	-0.417457	-0.306564	-0.581024
acceleration	0.420289	-0.505419	-0.543684	-0.417457	1.000000	0.288137	0.205873
model year	0.579267	-0.348746	-0.370164	-0.306564	0.288137	1.000000	0.180662
origin	0.563450	-0.562543	-0.609409	-0.581024	0.205873	0.180662	1.000000

PLOT USING MATPLOTLIB

import matplotlib.pyplot as plt

SCATTERPLOT

pd.plotting.scatter_matrix(df,figsize=[9,9],diagonal='kde')
plt.show()

SCATTERPLOT

BOXPLOT

pd.plotting.boxplot(df,figsize=[5,5])

<Axes: >

Parallel coordinates

‘cylinders’ as categorical variable
cols with quantitative

Acceleration vs mpg

pd.plotting.parallel_coordinates(df,'cylinders',cols = ['acceleration','mpg'],color=['red','blue','green','yellow','orange'])

<Axes: >

Weight vs mpg

pd.plotting.parallel_coordinates(df,'cylinders',cols = ['weight','mpg'],color=['red','blue','green','yellow','orange'])

<Axes: >

Cylinders

pd.plotting.parallel_coordinates(df,'cylinders',cols = ['origin','acceleration','mpg'])

<Axes: >

1.2 Cleaning Data -dropna(), fillna(), loc(), drop(),drop_duplicates()

Data Cleaning

Data cleaning means fixing bad data in your data set.

Bad data could be:

Empty cells
Data in wrong format
Wrong data
Duplicates

EXAMPLE

df = pd.read_csv('https://raw.githubusercontent.com/patelmanishv/DATASTRUCTURES/main/Datasets/data.csv')

print(df.to_string()) 
# The data set contains some empty cells ("Date" in row 22, and "Calories" in row 18 and 28).
# The data set contains wrong format ("Date" in row 26).
# The data set contains wrong data ("Duration" in row 7).
# The data set contains duplicates (row 11 and 12).

          Duration          Date  Pulse  Maxpulse  Calories
0     0         60  '2020/12/01'    110       130     409.1
1     1         60  '2020/12/02'    117       145     479.0
2     2         60  '2020/12/03'    103       135     340.0
3     3         45  '2020/12/04'    109       175     282.4
4     4         45  '2020/12/05'    117       148     406.0
5     5         60  '2020/12/06'    102       127     300.0
6     6         60  '2020/12/07'    110       136     374.0
7     7        450  '2020/12/08'    104       134     253.3
8     8         30  '2020/12/09'    109       133     195.1
9     9         60  '2020/12/10'     98       124     269.0
10    10        60  '2020/12/11'    103       147     329.3
11    11        60  '2020/12/12'    100       120     250.7
12    12        60  '2020/12/12'    100       120     250.7
13    13        60  '2020/12/13'    106       128     345.3
14    14        60  '2020/12/14'    104       132     379.3
15    15        60  '2020/12/15'     98       123     275.0
16    16        60  '2020/12/16'     98       120     215.2
17    17        60  '2020/12/17'    100       120     300.0
18    18        45  '2020/12/18'     90       112       NaN
19    19        60  '2020/12/19'    103       123     323.0
20    20        45  '2020/12/20'     97       125     243.0
21    21        60  '2020/12/21'    108       131     364.2
22    22        45           NaN    100       119     282.0
23    23        60  '2020/12/23'    130       101     300.0
24    24        45  '2020/12/24'    105       132     246.0
25    25        60  '2020/12/25'    102       126     334.5
26    26        60    2020/12/26    100       120     250.0
27    27        60  '2020/12/27'     92       118     241.0
28    28        60  '2020/12/28'    103       132       NaN
29    29        60  '2020/12/29'    100       132     280.0
30    30        60  '2020/12/30'    102       129     380.3
31    31        60  '2020/12/31'     92       115     243.0

Remove rows

# Return a new Data Frame with no empty cells:
new_df = df.dropna()
print(new_df.to_string())

          Duration          Date  Pulse  Maxpulse  Calories
0     0         60  '2020/12/01'    110       130     409.1
1     1         60  '2020/12/02'    117       145     479.0
2     2         60  '2020/12/03'    103       135     340.0
3     3         45  '2020/12/04'    109       175     282.4
4     4         45  '2020/12/05'    117       148     406.0
5     5         60  '2020/12/06'    102       127     300.0
6     6         60  '2020/12/07'    110       136     374.0
7     7        450  '2020/12/08'    104       134     253.3
8     8         30  '2020/12/09'    109       133     195.1
9     9         60  '2020/12/10'     98       124     269.0
10    10        60  '2020/12/11'    103       147     329.3
11    11        60  '2020/12/12'    100       120     250.7
12    12        60  '2020/12/12'    100       120     250.7
13    13        60  '2020/12/13'    106       128     345.3
14    14        60  '2020/12/14'    104       132     379.3
15    15        60  '2020/12/15'     98       123     275.0
16    16        60  '2020/12/16'     98       120     215.2
17    17        60  '2020/12/17'    100       120     300.0
18    18        45  '2020/12/18'     90       112       NaN
19    19        60  '2020/12/19'    103       123     323.0
20    20        45  '2020/12/20'     97       125     243.0
21    21        60  '2020/12/21'    108       131     364.2
22    22        45           NaN    100       119     282.0
23    23        60  '2020/12/23'    130       101     300.0
24    24        45  '2020/12/24'    105       132     246.0
25    25        60  '2020/12/25'    102       126     334.5
26    26        60    2020/12/26    100       120     250.0
27    27        60  '2020/12/27'     92       118     241.0
28    28        60  '2020/12/28'    103       132       NaN
29    29        60  '2020/12/29'    100       132     280.0
30    30        60  '2020/12/30'    102       129     380.3
31    31        60  '2020/12/31'     92       115     243.0

# If you want to change the original DataFrame, use the inplace = True argument:

df.dropna(inplace = True)
print(df.to_string())
# Now, the dropna(inplace = True) will NOT return a new DataFrame, but it will remove all rows containing NULL values from the original DataFrame.

          Duration          Date  Pulse  Maxpulse  Calories
0     0         60  '2020/12/01'    110       130     409.1
1     1         60  '2020/12/02'    117       145     479.0
2     2         60  '2020/12/03'    103       135     340.0
3     3         45  '2020/12/04'    109       175     282.4
4     4         45  '2020/12/05'    117       148     406.0
5     5         60  '2020/12/06'    102       127     300.0
6     6         60  '2020/12/07'    110       136     374.0
7     7        450  '2020/12/08'    104       134     253.3
8     8         30  '2020/12/09'    109       133     195.1
9     9         60  '2020/12/10'     98       124     269.0
10    10        60  '2020/12/11'    103       147     329.3
11    11        60  '2020/12/12'    100       120     250.7
12    12        60  '2020/12/12'    100       120     250.7
13    13        60  '2020/12/13'    106       128     345.3
14    14        60  '2020/12/14'    104       132     379.3
15    15        60  '2020/12/15'     98       123     275.0
16    16        60  '2020/12/16'     98       120     215.2
17    17        60  '2020/12/17'    100       120     300.0
18    18        45  '2020/12/18'     90       112       NaN
19    19        60  '2020/12/19'    103       123     323.0
20    20        45  '2020/12/20'     97       125     243.0
21    21        60  '2020/12/21'    108       131     364.2
22    22        45           NaN    100       119     282.0
23    23        60  '2020/12/23'    130       101     300.0
24    24        45  '2020/12/24'    105       132     246.0
25    25        60  '2020/12/25'    102       126     334.5
26    26        60    2020/12/26    100       120     250.0
27    27        60  '2020/12/27'     92       118     241.0
28    28        60  '2020/12/28'    103       132       NaN
29    29        60  '2020/12/29'    100       132     280.0
30    30        60  '2020/12/30'    102       129     380.3
31    31        60  '2020/12/31'     92       115     243.0

1.4 Analyzing Qualitative v/s Quantitative Data -two-way cross tabulation

df.describe()

	Duration Date Pulse Maxpulse Calories
count	32
unique	32
top	0 60 '2020/12/01' 110 130 ...
freq	1

Data info

df.info()

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 32 entries, 0 to 31
Data columns (total 1 columns):
 #   Column                                             Non-Null Count  Dtype 
---  ------                                             --------------  ----- 
 0   Duration          Date  Pulse  Maxpulse  Calories  32 non-null     object
dtypes: object(1)
memory usage: 384.0+ bytes

Crosstab

pd.crosstab(df['cylinders'], df['model year'], rownames=['cylinders'],colnames=['model year'])
# Two way cross tabulation

model year	70	71	72	73	74	75	76	77	78	79	80	81	82
cylinders
3	0	0	1	1	0	0	0	1	0	0	1	0	0
4	7	13	14	11	15	12	15	14	17	12	25	21	28
5	0	0	0	0	0	0	0	0	1	1	1	0	0
6	4	8	0	8	7	12	10	5	12	6	2	7	3
8	18	7	13	20	5	6	9	8	6	10	0	1	0

A new dataset

import numpy as np


sales_data = pd.DataFrame({'Name': ['abc','cde','fgh','xyz','mno'],'region':['a','b','c','d','e'],'sales': [10,20,30,40,50],'expense':[100,200,300,400,500]})

sales_data

	Name	region	sales	expense
0	abc	a	10	100
1	cde	b	20	200
2	fgh	c	30	300
3	xyz	d	40	400
4	mno	e	50	500

Fill nan values

sales_data = pd.DataFrame({'Name': ['abc','cde',np.nan,'xyz','mno'],'region':[np.nan,'b','c','d','e'],'sales': [10,20,30,np.nan,50],'expense':[100,200,300,400,np.nan]})

sales_data

	Name	region	sales	expense
0	abc	NaN	10.0	100.0
1	cde	b	20.0	200.0
2	NaN	c	30.0	300.0
3	xyz	d	NaN	400.0
4	mno	e	50.0	NaN

Find null values

print(sales_data.isna())
print(sales_data.isna().sum())
# print(sales_data.info())

    Name  region  sales  expense
0  False    True  False    False
1  False   False  False    False
2   True   False  False    False
3  False   False   True    False
4  False   False  False     True
Name       1
region     1
sales      1
expense    1
dtype: int64

Three options to deal with null values

Delete rows with null values
Fill NA with some dummy data (good for categorical data)
Fill data with mean/median (good for numeric data) <–Recommended

DROP NAs

# Original dataframe will remain unchanged
sales_data.dropna()
# sales_data.dropna(how = 'all') # delete complete row with NAs
# sales_data.dropna(thresh=2) Keep only the rows with at least 2 non-NA values.
# sales_data.dropna(subset = ['sales','expense']) Define in which columns to look for missing values.
# sales_data.dropna(axis = 'columns') Drop the columns where at least one element is missing.

	Name	region	sales	expense
1	cde	b	20.0	200.0

Dataset

sales_data

	Name	region	sales	expense
0	abc	NaN	10.0	100.0
1	cde	b	20.0	200.0
2	NaN	c	30.0	300.0
3	xyz	d	NaN	400.0
4	mno	e	50.0	NaN

sales_data.dropna(inplace=True)

sales_data

	Name	region	sales	expense
1	cde	b	20.0	200.0

Fill NAs

sales_data = pd.DataFrame({'Name': ['abc','cde',np.nan,'xyz','mno'],'region':[np.nan,'b','c','d','e'],'sales': [10,20,30,np.nan,50],'expense':[100,200,300,400,np.nan]})

sales_data.fillna('python')

	Name	region	sales	expense
0	abc	python	10.0	100.0
1	cde	b	20.0	200.0
2	python	c	30.0	300.0
3	xyz	d	python	400.0
4	mno	e	50.0	python

Fill mean /median

sales_data = pd.DataFrame({'Name': ['abc','cde',np.nan,'xyz','mno'],'region':[np.nan,'b','c','d','e'],'sales': [10,20,30,np.nan,50],'expense':[100,200,300,400,np.nan]})

sales_data['sales'].fillna(sales_data['sales'].median())

0    10.0
1    20.0
2    30.0
3    25.0
4    50.0
Name: sales, dtype: float64

Describe method

sales_data.describe()

	sales	expense
count	4.000000	4.000000
mean	27.500000	250.000000
std	17.078251	129.099445
min	10.000000	100.000000
25%	17.500000	175.000000
50%	25.000000	250.000000
75%	35.000000	325.000000
max	50.000000	400.000000

Replace ? with new values

df = pd.read_csv('auto-mpg.csv')

print(df.to_string())

      mpg  cylinders  displacement horsepower  weight  acceleration  model year  origin                              car name
0    18.0          8         307.0        130    3504          12.0          70       1             chevrolet chevelle malibu
1    15.0          8         350.0        165    3693          11.5          70       1                     buick skylark 320
2    18.0          8         318.0        150    3436          11.0          70       1                    plymouth satellite
3    16.0          8         304.0        150    3433          12.0          70       1                         amc rebel sst
4    17.0          8         302.0        140    3449          10.5          70       1                           ford torino
5    15.0          8         429.0        198    4341          10.0          70       1                      ford galaxie 500
6    14.0          8         454.0        220    4354           9.0          70       1                      chevrolet impala
7    14.0          8         440.0        215    4312           8.5          70       1                     plymouth fury iii
8    14.0          8         455.0        225    4425          10.0          70       1                      pontiac catalina
9    15.0          8         390.0        190    3850           8.5          70       1                    amc ambassador dpl
10   15.0          8         383.0        170    3563          10.0          70       1                   dodge challenger se
11   14.0          8         340.0        160    3609           8.0          70       1                    plymouth 'cuda 340
12   15.0          8         400.0        150    3761           9.5          70       1                 chevrolet monte carlo
13   14.0          8         455.0        225    3086          10.0          70       1               buick estate wagon (sw)
14   24.0          4         113.0         95    2372          15.0          70       3                 toyota corona mark ii
15   22.0          6         198.0         95    2833          15.5          70       1                       plymouth duster
16   18.0          6         199.0         97    2774          15.5          70       1                            amc hornet
17   21.0          6         200.0         85    2587          16.0          70       1                         ford maverick
18   27.0          4          97.0         88    2130          14.5          70       3                          datsun pl510
19   26.0          4          97.0         46    1835          20.5          70       2          volkswagen 1131 deluxe sedan
20   25.0          4         110.0         87    2672          17.5          70       2                           peugeot 504
21   24.0          4         107.0         90    2430          14.5          70       2                           audi 100 ls
22   25.0          4         104.0         95    2375          17.5          70       2                              saab 99e
23   26.0          4         121.0        113    2234          12.5          70       2                              bmw 2002
24   21.0          6         199.0         90    2648          15.0          70       1                           amc gremlin
25   10.0          8         360.0        215    4615          14.0          70       1                             ford f250
26   10.0          8         307.0        200    4376          15.0          70       1                             chevy c20
27   11.0          8         318.0        210    4382          13.5          70       1                            dodge d200
28    9.0          8         304.0        193    4732          18.5          70       1                              hi 1200d
29   27.0          4          97.0         88    2130          14.5          71       3                          datsun pl510
30   28.0          4         140.0         90    2264          15.5          71       1                   chevrolet vega 2300
31   25.0          4         113.0         95    2228          14.0          71       3                         toyota corona
32   25.0          4          98.0          ?    2046          19.0          71       1                            ford pinto
33   19.0          6         232.0        100    2634          13.0          71       1                           amc gremlin
34   16.0          6         225.0        105    3439          15.5          71       1             plymouth satellite custom
35   17.0          6         250.0        100    3329          15.5          71       1             chevrolet chevelle malibu
36   19.0          6         250.0         88    3302          15.5          71       1                       ford torino 500
37   18.0          6         232.0        100    3288          15.5          71       1                           amc matador
38   14.0          8         350.0        165    4209          12.0          71       1                      chevrolet impala
39   14.0          8         400.0        175    4464          11.5          71       1             pontiac catalina brougham
40   14.0          8         351.0        153    4154          13.5          71       1                      ford galaxie 500
41   14.0          8         318.0        150    4096          13.0          71       1                     plymouth fury iii
42   12.0          8         383.0        180    4955          11.5          71       1                     dodge monaco (sw)
43   13.0          8         400.0        170    4746          12.0          71       1              ford country squire (sw)
44   13.0          8         400.0        175    5140          12.0          71       1                   pontiac safari (sw)
45   18.0          6         258.0        110    2962          13.5          71       1            amc hornet sportabout (sw)
46   22.0          4         140.0         72    2408          19.0          71       1                   chevrolet vega (sw)
47   19.0          6         250.0        100    3282          15.0          71       1                      pontiac firebird
48   18.0          6         250.0         88    3139          14.5          71       1                          ford mustang
49   23.0          4         122.0         86    2220          14.0          71       1                    mercury capri 2000
50   28.0          4         116.0         90    2123          14.0          71       2                             opel 1900
51   30.0          4          79.0         70    2074          19.5          71       2                           peugeot 304
52   30.0          4          88.0         76    2065          14.5          71       2                             fiat 124b
53   31.0          4          71.0         65    1773          19.0          71       3                   toyota corolla 1200
54   35.0          4          72.0         69    1613          18.0          71       3                           datsun 1200
55   27.0          4          97.0         60    1834          19.0          71       2                  volkswagen model 111
56   26.0          4          91.0         70    1955          20.5          71       1                      plymouth cricket
57   24.0          4         113.0         95    2278          15.5          72       3                 toyota corona hardtop
58   25.0          4          97.5         80    2126          17.0          72       1                    dodge colt hardtop
59   23.0          4          97.0         54    2254          23.5          72       2                     volkswagen type 3
60   20.0          4         140.0         90    2408          19.5          72       1                        chevrolet vega
61   21.0          4         122.0         86    2226          16.5          72       1                   ford pinto runabout
62   13.0          8         350.0        165    4274          12.0          72       1                      chevrolet impala
63   14.0          8         400.0        175    4385          12.0          72       1                      pontiac catalina
64   15.0          8         318.0        150    4135          13.5          72       1                     plymouth fury iii
65   14.0          8         351.0        153    4129          13.0          72       1                      ford galaxie 500
66   17.0          8         304.0        150    3672          11.5          72       1                    amc ambassador sst
67   11.0          8         429.0        208    4633          11.0          72       1                       mercury marquis
68   13.0          8         350.0        155    4502          13.5          72       1                  buick lesabre custom
69   12.0          8         350.0        160    4456          13.5          72       1            oldsmobile delta 88 royale
70   13.0          8         400.0        190    4422          12.5          72       1                chrysler newport royal
71   19.0          3          70.0         97    2330          13.5          72       3                       mazda rx2 coupe
72   15.0          8         304.0        150    3892          12.5          72       1                      amc matador (sw)
73   13.0          8         307.0        130    4098          14.0          72       1      chevrolet chevelle concours (sw)
74   13.0          8         302.0        140    4294          16.0          72       1                 ford gran torino (sw)
75   14.0          8         318.0        150    4077          14.0          72       1        plymouth satellite custom (sw)
76   18.0          4         121.0        112    2933          14.5          72       2                       volvo 145e (sw)
77   22.0          4         121.0         76    2511          18.0          72       2                   volkswagen 411 (sw)
78   21.0          4         120.0         87    2979          19.5          72       2                      peugeot 504 (sw)
79   26.0          4          96.0         69    2189          18.0          72       2                       renault 12 (sw)
80   22.0          4         122.0         86    2395          16.0          72       1                       ford pinto (sw)
81   28.0          4          97.0         92    2288          17.0          72       3                       datsun 510 (sw)
82   23.0          4         120.0         97    2506          14.5          72       3           toyouta corona mark ii (sw)
83   28.0          4          98.0         80    2164          15.0          72       1                       dodge colt (sw)
84   27.0          4          97.0         88    2100          16.5          72       3              toyota corolla 1600 (sw)
85   13.0          8         350.0        175    4100          13.0          73       1                     buick century 350
86   14.0          8         304.0        150    3672          11.5          73       1                           amc matador
87   13.0          8         350.0        145    3988          13.0          73       1                      chevrolet malibu
88   14.0          8         302.0        137    4042          14.5          73       1                      ford gran torino
89   15.0          8         318.0        150    3777          12.5          73       1                  dodge coronet custom
90   12.0          8         429.0        198    4952          11.5          73       1              mercury marquis brougham
91   13.0          8         400.0        150    4464          12.0          73       1             chevrolet caprice classic
92   13.0          8         351.0        158    4363          13.0          73       1                              ford ltd
93   14.0          8         318.0        150    4237          14.5          73       1              plymouth fury gran sedan
94   13.0          8         440.0        215    4735          11.0          73       1          chrysler new yorker brougham
95   12.0          8         455.0        225    4951          11.0          73       1              buick electra 225 custom
96   13.0          8         360.0        175    3821          11.0          73       1               amc ambassador brougham
97   18.0          6         225.0        105    3121          16.5          73       1                      plymouth valiant
98   16.0          6         250.0        100    3278          18.0          73       1                 chevrolet nova custom
99   18.0          6         232.0        100    2945          16.0          73       1                            amc hornet
100  18.0          6         250.0         88    3021          16.5          73       1                         ford maverick
101  23.0          6         198.0         95    2904          16.0          73       1                       plymouth duster
102  26.0          4          97.0         46    1950          21.0          73       2               volkswagen super beetle
103  11.0          8         400.0        150    4997          14.0          73       1                      chevrolet impala
104  12.0          8         400.0        167    4906          12.5          73       1                          ford country
105  13.0          8         360.0        170    4654          13.0          73       1                plymouth custom suburb
106  12.0          8         350.0        180    4499          12.5          73       1              oldsmobile vista cruiser
107  18.0          6         232.0        100    2789          15.0          73       1                           amc gremlin
108  20.0          4          97.0         88    2279          19.0          73       3                         toyota carina
109  21.0          4         140.0         72    2401          19.5          73       1                        chevrolet vega
110  22.0          4         108.0         94    2379          16.5          73       3                            datsun 610
111  18.0          3          70.0         90    2124          13.5          73       3                             maxda rx3
112  19.0          4         122.0         85    2310          18.5          73       1                            ford pinto
113  21.0          6         155.0        107    2472          14.0          73       1                      mercury capri v6
114  26.0          4          98.0         90    2265          15.5          73       2                  fiat 124 sport coupe
115  15.0          8         350.0        145    4082          13.0          73       1               chevrolet monte carlo s
116  16.0          8         400.0        230    4278           9.5          73       1                    pontiac grand prix
117  29.0          4          68.0         49    1867          19.5          73       2                              fiat 128
118  24.0          4         116.0         75    2158          15.5          73       2                            opel manta
119  20.0          4         114.0         91    2582          14.0          73       2                            audi 100ls
120  19.0          4         121.0        112    2868          15.5          73       2                           volvo 144ea
121  15.0          8         318.0        150    3399          11.0          73       1                     dodge dart custom
122  24.0          4         121.0        110    2660          14.0          73       2                             saab 99le
123  20.0          6         156.0        122    2807          13.5          73       3                        toyota mark ii
124  11.0          8         350.0        180    3664          11.0          73       1                      oldsmobile omega
125  20.0          6         198.0         95    3102          16.5          74       1                       plymouth duster
126  21.0          6         200.0          ?    2875          17.0          74       1                         ford maverick
127  19.0          6         232.0        100    2901          16.0          74       1                            amc hornet
128  15.0          6         250.0        100    3336          17.0          74       1                        chevrolet nova
129  31.0          4          79.0         67    1950          19.0          74       3                           datsun b210
130  26.0          4         122.0         80    2451          16.5          74       1                            ford pinto
131  32.0          4          71.0         65    1836          21.0          74       3                   toyota corolla 1200
132  25.0          4         140.0         75    2542          17.0          74       1                        chevrolet vega
133  16.0          6         250.0        100    3781          17.0          74       1     chevrolet chevelle malibu classic
134  16.0          6         258.0        110    3632          18.0          74       1                           amc matador
135  18.0          6         225.0        105    3613          16.5          74       1            plymouth satellite sebring
136  16.0          8         302.0        140    4141          14.0          74       1                      ford gran torino
137  13.0          8         350.0        150    4699          14.5          74       1              buick century luxus (sw)
138  14.0          8         318.0        150    4457          13.5          74       1             dodge coronet custom (sw)
139  14.0          8         302.0        140    4638          16.0          74       1                 ford gran torino (sw)
140  14.0          8         304.0        150    4257          15.5          74       1                      amc matador (sw)
141  29.0          4          98.0         83    2219          16.5          74       2                              audi fox
142  26.0          4          79.0         67    1963          15.5          74       2                     volkswagen dasher
143  26.0          4          97.0         78    2300          14.5          74       2                            opel manta
144  31.0          4          76.0         52    1649          16.5          74       3                         toyota corona
145  32.0          4          83.0         61    2003          19.0          74       3                            datsun 710
146  28.0          4          90.0         75    2125          14.5          74       1                            dodge colt
147  24.0          4          90.0         75    2108          15.5          74       2                              fiat 128
148  26.0          4         116.0         75    2246          14.0          74       2                           fiat 124 tc
149  24.0          4         120.0         97    2489          15.0          74       3                           honda civic
150  26.0          4         108.0         93    2391          15.5          74       3                                subaru
151  31.0          4          79.0         67    2000          16.0          74       2                             fiat x1.9
152  19.0          6         225.0         95    3264          16.0          75       1               plymouth valiant custom
153  18.0          6         250.0        105    3459          16.0          75       1                        chevrolet nova
154  15.0          6         250.0         72    3432          21.0          75       1                       mercury monarch
155  15.0          6         250.0         72    3158          19.5          75       1                         ford maverick
156  16.0          8         400.0        170    4668          11.5          75       1                      pontiac catalina
157  15.0          8         350.0        145    4440          14.0          75       1                     chevrolet bel air
158  16.0          8         318.0        150    4498          14.5          75       1                   plymouth grand fury
159  14.0          8         351.0        148    4657          13.5          75       1                              ford ltd
160  17.0          6         231.0        110    3907          21.0          75       1                         buick century
161  16.0          6         250.0        105    3897          18.5          75       1             chevroelt chevelle malibu
162  15.0          6         258.0        110    3730          19.0          75       1                           amc matador
163  18.0          6         225.0         95    3785          19.0          75       1                         plymouth fury
164  21.0          6         231.0        110    3039          15.0          75       1                         buick skyhawk
165  20.0          8         262.0        110    3221          13.5          75       1                   chevrolet monza 2+2
166  13.0          8         302.0        129    3169          12.0          75       1                       ford mustang ii
167  29.0          4          97.0         75    2171          16.0          75       3                        toyota corolla
168  23.0          4         140.0         83    2639          17.0          75       1                            ford pinto
169  20.0          6         232.0        100    2914          16.0          75       1                           amc gremlin
170  23.0          4         140.0         78    2592          18.5          75       1                         pontiac astro
171  24.0          4         134.0         96    2702          13.5          75       3                         toyota corona
172  25.0          4          90.0         71    2223          16.5          75       2                     volkswagen dasher
173  24.0          4         119.0         97    2545          17.0          75       3                            datsun 710
174  18.0          6         171.0         97    2984          14.5          75       1                            ford pinto
175  29.0          4          90.0         70    1937          14.0          75       2                     volkswagen rabbit
176  19.0          6         232.0         90    3211          17.0          75       1                             amc pacer
177  23.0          4         115.0         95    2694          15.0          75       2                            audi 100ls
178  23.0          4         120.0         88    2957          17.0          75       2                           peugeot 504
179  22.0          4         121.0         98    2945          14.5          75       2                           volvo 244dl
180  25.0          4         121.0        115    2671          13.5          75       2                             saab 99le
181  33.0          4          91.0         53    1795          17.5          75       3                      honda civic cvcc
182  28.0          4         107.0         86    2464          15.5          76       2                              fiat 131
183  25.0          4         116.0         81    2220          16.9          76       2                             opel 1900
184  25.0          4         140.0         92    2572          14.9          76       1                              capri ii
185  26.0          4          98.0         79    2255          17.7          76       1                            dodge colt
186  27.0          4         101.0         83    2202          15.3          76       2                          renault 12tl
187  17.5          8         305.0        140    4215          13.0          76       1     chevrolet chevelle malibu classic
188  16.0          8         318.0        150    4190          13.0          76       1                dodge coronet brougham
189  15.5          8         304.0        120    3962          13.9          76       1                           amc matador
190  14.5          8         351.0        152    4215          12.8          76       1                      ford gran torino
191  22.0          6         225.0        100    3233          15.4          76       1                      plymouth valiant
192  22.0          6         250.0        105    3353          14.5          76       1                        chevrolet nova
193  24.0          6         200.0         81    3012          17.6          76       1                         ford maverick
194  22.5          6         232.0         90    3085          17.6          76       1                            amc hornet
195  29.0          4          85.0         52    2035          22.2          76       1                    chevrolet chevette
196  24.5          4          98.0         60    2164          22.1          76       1                       chevrolet woody
197  29.0          4          90.0         70    1937          14.2          76       2                             vw rabbit
198  33.0          4          91.0         53    1795          17.4          76       3                           honda civic
199  20.0          6         225.0        100    3651          17.7          76       1                        dodge aspen se
200  18.0          6         250.0         78    3574          21.0          76       1                     ford granada ghia
201  18.5          6         250.0        110    3645          16.2          76       1                    pontiac ventura sj
202  17.5          6         258.0         95    3193          17.8          76       1                         amc pacer d/l
203  29.5          4          97.0         71    1825          12.2          76       2                     volkswagen rabbit
204  32.0          4          85.0         70    1990          17.0          76       3                          datsun b-210
205  28.0          4          97.0         75    2155          16.4          76       3                        toyota corolla
206  26.5          4         140.0         72    2565          13.6          76       1                            ford pinto
207  20.0          4         130.0        102    3150          15.7          76       2                             volvo 245
208  13.0          8         318.0        150    3940          13.2          76       1            plymouth volare premier v8
209  19.0          4         120.0         88    3270          21.9          76       2                           peugeot 504
210  19.0          6         156.0        108    2930          15.5          76       3                        toyota mark ii
211  16.5          6         168.0        120    3820          16.7          76       2                    mercedes-benz 280s
212  16.5          8         350.0        180    4380          12.1          76       1                      cadillac seville
213  13.0          8         350.0        145    4055          12.0          76       1                             chevy c10
214  13.0          8         302.0        130    3870          15.0          76       1                             ford f108
215  13.0          8         318.0        150    3755          14.0          76       1                            dodge d100
216  31.5          4          98.0         68    2045          18.5          77       3                     honda accord cvcc
217  30.0          4         111.0         80    2155          14.8          77       1               buick opel isuzu deluxe
218  36.0          4          79.0         58    1825          18.6          77       2                         renault 5 gtl
219  25.5          4         122.0         96    2300          15.5          77       1                     plymouth arrow gs
220  33.5          4          85.0         70    1945          16.8          77       3                 datsun f-10 hatchback
221  17.5          8         305.0        145    3880          12.5          77       1             chevrolet caprice classic
222  17.0          8         260.0        110    4060          19.0          77       1            oldsmobile cutlass supreme
223  15.5          8         318.0        145    4140          13.7          77       1                 dodge monaco brougham
224  15.0          8         302.0        130    4295          14.9          77       1               mercury cougar brougham
225  17.5          6         250.0        110    3520          16.4          77       1                    chevrolet concours
226  20.5          6         231.0        105    3425          16.9          77       1                         buick skylark
227  19.0          6         225.0        100    3630          17.7          77       1                plymouth volare custom
228  18.5          6         250.0         98    3525          19.0          77       1                          ford granada
229  16.0          8         400.0        180    4220          11.1          77       1                 pontiac grand prix lj
230  15.5          8         350.0        170    4165          11.4          77       1          chevrolet monte carlo landau
231  15.5          8         400.0        190    4325          12.2          77       1                      chrysler cordoba
232  16.0          8         351.0        149    4335          14.5          77       1                      ford thunderbird
233  29.0          4          97.0         78    1940          14.5          77       2              volkswagen rabbit custom
234  24.5          4         151.0         88    2740          16.0          77       1                 pontiac sunbird coupe
235  26.0          4          97.0         75    2265          18.2          77       3               toyota corolla liftback
236  25.5          4         140.0         89    2755          15.8          77       1                   ford mustang ii 2+2
237  30.5          4          98.0         63    2051          17.0          77       1                    chevrolet chevette
238  33.5          4          98.0         83    2075          15.9          77       1                        dodge colt m/m
239  30.0          4          97.0         67    1985          16.4          77       3                             subaru dl
240  30.5          4          97.0         78    2190          14.1          77       2                     volkswagen dasher
241  22.0          6         146.0         97    2815          14.5          77       3                            datsun 810
242  21.5          4         121.0        110    2600          12.8          77       2                              bmw 320i
243  21.5          3          80.0        110    2720          13.5          77       3                            mazda rx-4
244  43.1          4          90.0         48    1985          21.5          78       2       volkswagen rabbit custom diesel
245  36.1          4          98.0         66    1800          14.4          78       1                           ford fiesta
246  32.8          4          78.0         52    1985          19.4          78       3                      mazda glc deluxe
247  39.4          4          85.0         70    2070          18.6          78       3                        datsun b210 gx
248  36.1          4          91.0         60    1800          16.4          78       3                      honda civic cvcc
249  19.9          8         260.0        110    3365          15.5          78       1     oldsmobile cutlass salon brougham
250  19.4          8         318.0        140    3735          13.2          78       1                        dodge diplomat
251  20.2          8         302.0        139    3570          12.8          78       1                  mercury monarch ghia
252  19.2          6         231.0        105    3535          19.2          78       1                    pontiac phoenix lj
253  20.5          6         200.0         95    3155          18.2          78       1                      chevrolet malibu
254  20.2          6         200.0         85    2965          15.8          78       1                  ford fairmont (auto)
255  25.1          4         140.0         88    2720          15.4          78       1                   ford fairmont (man)
256  20.5          6         225.0        100    3430          17.2          78       1                       plymouth volare
257  19.4          6         232.0         90    3210          17.2          78       1                           amc concord
258  20.6          6         231.0        105    3380          15.8          78       1                 buick century special
259  20.8          6         200.0         85    3070          16.7          78       1                        mercury zephyr
260  18.6          6         225.0        110    3620          18.7          78       1                           dodge aspen
261  18.1          6         258.0        120    3410          15.1          78       1                       amc concord d/l
262  19.2          8         305.0        145    3425          13.2          78       1          chevrolet monte carlo landau
263  17.7          6         231.0        165    3445          13.4          78       1       buick regal sport coupe (turbo)
264  18.1          8         302.0        139    3205          11.2          78       1                           ford futura
265  17.5          8         318.0        140    4080          13.7          78       1                       dodge magnum xe
266  30.0          4          98.0         68    2155          16.5          78       1                    chevrolet chevette
267  27.5          4         134.0         95    2560          14.2          78       3                         toyota corona
268  27.2          4         119.0         97    2300          14.7          78       3                            datsun 510
269  30.9          4         105.0         75    2230          14.5          78       1                            dodge omni
270  21.1          4         134.0         95    2515          14.8          78       3             toyota celica gt liftback
271  23.2          4         156.0        105    2745          16.7          78       1                      plymouth sapporo
272  23.8          4         151.0         85    2855          17.6          78       1                oldsmobile starfire sx
273  23.9          4         119.0         97    2405          14.9          78       3                         datsun 200-sx
274  20.3          5         131.0        103    2830          15.9          78       2                             audi 5000
275  17.0          6         163.0        125    3140          13.6          78       2                           volvo 264gl
276  21.6          4         121.0        115    2795          15.7          78       2                            saab 99gle
277  16.2          6         163.0        133    3410          15.8          78       2                         peugeot 604sl
278  31.5          4          89.0         71    1990          14.9          78       2                   volkswagen scirocco
279  29.5          4          98.0         68    2135          16.6          78       3                       honda accord lx
280  21.5          6         231.0        115    3245          15.4          79       1                     pontiac lemans v6
281  19.8          6         200.0         85    2990          18.2          79       1                      mercury zephyr 6
282  22.3          4         140.0         88    2890          17.3          79       1                       ford fairmont 4
283  20.2          6         232.0         90    3265          18.2          79       1                      amc concord dl 6
284  20.6          6         225.0        110    3360          16.6          79       1                         dodge aspen 6
285  17.0          8         305.0        130    3840          15.4          79       1             chevrolet caprice classic
286  17.6          8         302.0        129    3725          13.4          79       1                       ford ltd landau
287  16.5          8         351.0        138    3955          13.2          79       1                 mercury grand marquis
288  18.2          8         318.0        135    3830          15.2          79       1                       dodge st. regis
289  16.9          8         350.0        155    4360          14.9          79       1               buick estate wagon (sw)
290  15.5          8         351.0        142    4054          14.3          79       1              ford country squire (sw)
291  19.2          8         267.0        125    3605          15.0          79       1         chevrolet malibu classic (sw)
292  18.5          8         360.0        150    3940          13.0          79       1  chrysler lebaron town @ country (sw)
293  31.9          4          89.0         71    1925          14.0          79       2                      vw rabbit custom
294  34.1          4          86.0         65    1975          15.2          79       3                      maxda glc deluxe
295  35.7          4          98.0         80    1915          14.4          79       1           dodge colt hatchback custom
296  27.4          4         121.0         80    2670          15.0          79       1                         amc spirit dl
297  25.4          5         183.0         77    3530          20.1          79       2                    mercedes benz 300d
298  23.0          8         350.0        125    3900          17.4          79       1                     cadillac eldorado
299  27.2          4         141.0         71    3190          24.8          79       2                           peugeot 504
300  23.9          8         260.0         90    3420          22.2          79       1     oldsmobile cutlass salon brougham
301  34.2          4         105.0         70    2200          13.2          79       1                      plymouth horizon
302  34.5          4         105.0         70    2150          14.9          79       1                  plymouth horizon tc3
303  31.8          4          85.0         65    2020          19.2          79       3                            datsun 210
304  37.3          4          91.0         69    2130          14.7          79       2                    fiat strada custom
305  28.4          4         151.0         90    2670          16.0          79       1                 buick skylark limited
306  28.8          6         173.0        115    2595          11.3          79       1                    chevrolet citation
307  26.8          6         173.0        115    2700          12.9          79       1             oldsmobile omega brougham
308  33.5          4         151.0         90    2556          13.2          79       1                       pontiac phoenix
309  41.5          4          98.0         76    2144          14.7          80       2                             vw rabbit
310  38.1          4          89.0         60    1968          18.8          80       3                 toyota corolla tercel
311  32.1          4          98.0         70    2120          15.5          80       1                    chevrolet chevette
312  37.2          4          86.0         65    2019          16.4          80       3                            datsun 310
313  28.0          4         151.0         90    2678          16.5          80       1                    chevrolet citation
314  26.4          4         140.0         88    2870          18.1          80       1                         ford fairmont
315  24.3          4         151.0         90    3003          20.1          80       1                           amc concord
316  19.1          6         225.0         90    3381          18.7          80       1                           dodge aspen
317  34.3          4          97.0         78    2188          15.8          80       2                             audi 4000
318  29.8          4         134.0         90    2711          15.5          80       3                toyota corona liftback
319  31.3          4         120.0         75    2542          17.5          80       3                             mazda 626
320  37.0          4         119.0         92    2434          15.0          80       3                  datsun 510 hatchback
321  32.2          4         108.0         75    2265          15.2          80       3                        toyota corolla
322  46.6          4          86.0         65    2110          17.9          80       3                             mazda glc
323  27.9          4         156.0        105    2800          14.4          80       1                            dodge colt
324  40.8          4          85.0         65    2110          19.2          80       3                            datsun 210
325  44.3          4          90.0         48    2085          21.7          80       2                  vw rabbit c (diesel)
326  43.4          4          90.0         48    2335          23.7          80       2                    vw dasher (diesel)
327  36.4          5         121.0         67    2950          19.9          80       2                   audi 5000s (diesel)
328  30.0          4         146.0         67    3250          21.8          80       2                    mercedes-benz 240d
329  44.6          4          91.0         67    1850          13.8          80       3                   honda civic 1500 gl
330  40.9          4          85.0          ?    1835          17.3          80       2                  renault lecar deluxe
331  33.8          4          97.0         67    2145          18.0          80       3                             subaru dl
332  29.8          4          89.0         62    1845          15.3          80       2                      vokswagen rabbit
333  32.7          6         168.0        132    2910          11.4          80       3                         datsun 280-zx
334  23.7          3          70.0        100    2420          12.5          80       3                         mazda rx-7 gs
335  35.0          4         122.0         88    2500          15.1          80       2                     triumph tr7 coupe
336  23.6          4         140.0          ?    2905          14.3          80       1                    ford mustang cobra
337  32.4          4         107.0         72    2290          17.0          80       3                          honda accord
338  27.2          4         135.0         84    2490          15.7          81       1                      plymouth reliant
339  26.6          4         151.0         84    2635          16.4          81       1                         buick skylark
340  25.8          4         156.0         92    2620          14.4          81       1                dodge aries wagon (sw)
341  23.5          6         173.0        110    2725          12.6          81       1                    chevrolet citation
342  30.0          4         135.0         84    2385          12.9          81       1                      plymouth reliant
343  39.1          4          79.0         58    1755          16.9          81       3                        toyota starlet
344  39.0          4          86.0         64    1875          16.4          81       1                        plymouth champ
345  35.1          4          81.0         60    1760          16.1          81       3                      honda civic 1300
346  32.3          4          97.0         67    2065          17.8          81       3                                subaru
347  37.0          4          85.0         65    1975          19.4          81       3                        datsun 210 mpg
348  37.7          4          89.0         62    2050          17.3          81       3                         toyota tercel
349  34.1          4          91.0         68    1985          16.0          81       3                           mazda glc 4
350  34.7          4         105.0         63    2215          14.9          81       1                    plymouth horizon 4
351  34.4          4          98.0         65    2045          16.2          81       1                        ford escort 4w
352  29.9          4          98.0         65    2380          20.7          81       1                        ford escort 2h
353  33.0          4         105.0         74    2190          14.2          81       2                      volkswagen jetta
354  34.5          4         100.0          ?    2320          15.8          81       2                           renault 18i
355  33.7          4         107.0         75    2210          14.4          81       3                         honda prelude
356  32.4          4         108.0         75    2350          16.8          81       3                        toyota corolla
357  32.9          4         119.0        100    2615          14.8          81       3                          datsun 200sx
358  31.6          4         120.0         74    2635          18.3          81       3                             mazda 626
359  28.1          4         141.0         80    3230          20.4          81       2             peugeot 505s turbo diesel
360  30.7          6         145.0         76    3160          19.6          81       2                          volvo diesel
361  25.4          6         168.0        116    2900          12.6          81       3                       toyota cressida
362  24.2          6         146.0        120    2930          13.8          81       3                     datsun 810 maxima
363  22.4          6         231.0        110    3415          15.8          81       1                         buick century
364  26.6          8         350.0        105    3725          19.0          81       1                 oldsmobile cutlass ls
365  20.2          6         200.0         88    3060          17.1          81       1                       ford granada gl
366  17.6          6         225.0         85    3465          16.6          81       1                chrysler lebaron salon
367  28.0          4         112.0         88    2605          19.6          82       1                    chevrolet cavalier
368  27.0          4         112.0         88    2640          18.6          82       1              chevrolet cavalier wagon
369  34.0          4         112.0         88    2395          18.0          82       1             chevrolet cavalier 2-door
370  31.0          4         112.0         85    2575          16.2          82       1            pontiac j2000 se hatchback
371  29.0          4         135.0         84    2525          16.0          82       1                        dodge aries se
372  27.0          4         151.0         90    2735          18.0          82       1                       pontiac phoenix
373  24.0          4         140.0         92    2865          16.4          82       1                  ford fairmont futura
374  23.0          4         151.0          ?    3035          20.5          82       1                        amc concord dl
375  36.0          4         105.0         74    1980          15.3          82       2                   volkswagen rabbit l
376  37.0          4          91.0         68    2025          18.2          82       3                    mazda glc custom l
377  31.0          4          91.0         68    1970          17.6          82       3                      mazda glc custom
378  38.0          4         105.0         63    2125          14.7          82       1                plymouth horizon miser
379  36.0          4          98.0         70    2125          17.3          82       1                        mercury lynx l
380  36.0          4         120.0         88    2160          14.5          82       3                      nissan stanza xe
381  36.0          4         107.0         75    2205          14.5          82       3                          honda accord
382  34.0          4         108.0         70    2245          16.9          82       3                        toyota corolla
383  38.0          4          91.0         67    1965          15.0          82       3                           honda civic
384  32.0          4          91.0         67    1965          15.7          82       3                    honda civic (auto)
385  38.0          4          91.0         67    1995          16.2          82       3                         datsun 310 gx
386  25.0          6         181.0        110    2945          16.4          82       1                 buick century limited
387  38.0          6         262.0         85    3015          17.0          82       1     oldsmobile cutlass ciera (diesel)
388  26.0          4         156.0         92    2585          14.5          82       1            chrysler lebaron medallion
389  22.0          6         232.0        112    2835          14.7          82       1                        ford granada l
390  32.0          4         144.0         96    2665          13.9          82       3                      toyota celica gt
391  36.0          4         135.0         84    2370          13.0          82       1                     dodge charger 2.2
392  27.0          4         151.0         90    2950          17.3          82       1                      chevrolet camaro
393  27.0          4         140.0         86    2790          15.6          82       1                       ford mustang gl
394  44.0          4          97.0         52    2130          24.6          82       2                             vw pickup
395  32.0          4         135.0         84    2295          11.6          82       1                         dodge rampage
396  28.0          4         120.0         79    2625          18.6          82       1                           ford ranger
397  31.0          4         119.0         82    2720          19.4          82       1                            chevy s-10

Replace with ?

print(df[df['horsepower']=='?'])

      mpg  cylinders  displacement horsepower  weight  acceleration  \
32   25.0          4          98.0          ?    2046          19.0   
126  21.0          6         200.0          ?    2875          17.0   
330  40.9          4          85.0          ?    1835          17.3   
336  23.6          4         140.0          ?    2905          14.3   
354  34.5          4         100.0          ?    2320          15.8   
374  23.0          4         151.0          ?    3035          20.5   

     model year  origin              car name  
32           71       1            ford pinto  
126          74       1         ford maverick  
330          80       2  renault lecar deluxe  
336          80       1    ford mustang cobra  
354          81       2           renault 18i  
374          82       1        amc concord dl

DROP METHOD

print(newdata)

      mpg  cylinders  displacement horsepower  weight  acceleration  \
0    18.0          8         307.0        130    3504          12.0   
1    15.0          8         350.0        165    3693          11.5   
2    18.0          8         318.0        150    3436          11.0   
3    16.0          8         304.0        150    3433          12.0   
4    17.0          8         302.0        140    3449          10.5   
5    15.0          8         429.0        198    4341          10.0   
6    14.0          8         454.0        220    4354           9.0   
7    14.0          8         440.0        215    4312           8.5   
8    14.0          8         455.0        225    4425          10.0   
9    15.0          8         390.0        190    3850           8.5   
10   15.0          8         383.0        170    3563          10.0   
11   14.0          8         340.0        160    3609           8.0   
12   15.0          8         400.0        150    3761           9.5   
13   14.0          8         455.0        225    3086          10.0   
14   24.0          4         113.0         95    2372          15.0   
15   22.0          6         198.0         95    2833          15.5   
16   18.0          6         199.0         97    2774          15.5   
17   21.0          6         200.0         85    2587          16.0   
18   27.0          4          97.0         88    2130          14.5   
19   26.0          4          97.0         46    1835          20.5   
20   25.0          4         110.0         87    2672          17.5   
21   24.0          4         107.0         90    2430          14.5   
22   25.0          4         104.0         95    2375          17.5   
23   26.0          4         121.0        113    2234          12.5   
24   21.0          6         199.0         90    2648          15.0   
25   10.0          8         360.0        215    4615          14.0   
26   10.0          8         307.0        200    4376          15.0   
27   11.0          8         318.0        210    4382          13.5   
28    9.0          8         304.0        193    4732          18.5   
29   27.0          4          97.0         88    2130          14.5   
30   28.0          4         140.0         90    2264          15.5   
31   25.0          4         113.0         95    2228          14.0   
33   19.0          6         232.0        100    2634          13.0   
34   16.0          6         225.0        105    3439          15.5   
35   17.0          6         250.0        100    3329          15.5   
36   19.0          6         250.0         88    3302          15.5   
37   18.0          6         232.0        100    3288          15.5   
38   14.0          8         350.0        165    4209          12.0   
39   14.0          8         400.0        175    4464          11.5   
40   14.0          8         351.0        153    4154          13.5   
41   14.0          8         318.0        150    4096          13.0   
42   12.0          8         383.0        180    4955          11.5   
43   13.0          8         400.0        170    4746          12.0   
44   13.0          8         400.0        175    5140          12.0   
45   18.0          6         258.0        110    2962          13.5   
46   22.0          4         140.0         72    2408          19.0   
47   19.0          6         250.0        100    3282          15.0   
48   18.0          6         250.0         88    3139          14.5   
49   23.0          4         122.0         86    2220          14.0   
50   28.0          4         116.0         90    2123          14.0   
51   30.0          4          79.0         70    2074          19.5   
52   30.0          4          88.0         76    2065          14.5   
53   31.0          4          71.0         65    1773          19.0   
54   35.0          4          72.0         69    1613          18.0   
55   27.0          4          97.0         60    1834          19.0   
56   26.0          4          91.0         70    1955          20.5   
57   24.0          4         113.0         95    2278          15.5   
58   25.0          4          97.5         80    2126          17.0   
59   23.0          4          97.0         54    2254          23.5   
60   20.0          4         140.0         90    2408          19.5   
61   21.0          4         122.0         86    2226          16.5   
62   13.0          8         350.0        165    4274          12.0   
63   14.0          8         400.0        175    4385          12.0   
64   15.0          8         318.0        150    4135          13.5   
65   14.0          8         351.0        153    4129          13.0   
66   17.0          8         304.0        150    3672          11.5   
67   11.0          8         429.0        208    4633          11.0   
68   13.0          8         350.0        155    4502          13.5   
69   12.0          8         350.0        160    4456          13.5   
70   13.0          8         400.0        190    4422          12.5   
71   19.0          3          70.0         97    2330          13.5   
72   15.0          8         304.0        150    3892          12.5   
73   13.0          8         307.0        130    4098          14.0   
74   13.0          8         302.0        140    4294          16.0   
75   14.0          8         318.0        150    4077          14.0   
76   18.0          4         121.0        112    2933          14.5   
77   22.0          4         121.0         76    2511          18.0   
78   21.0          4         120.0         87    2979          19.5   
79   26.0          4          96.0         69    2189          18.0   
80   22.0          4         122.0         86    2395          16.0   
81   28.0          4          97.0         92    2288          17.0   
82   23.0          4         120.0         97    2506          14.5   
83   28.0          4          98.0         80    2164          15.0   
84   27.0          4          97.0         88    2100          16.5   
85   13.0          8         350.0        175    4100          13.0   
86   14.0          8         304.0        150    3672          11.5   
87   13.0          8         350.0        145    3988          13.0   
88   14.0          8         302.0        137    4042          14.5   
89   15.0          8         318.0        150    3777          12.5   
90   12.0          8         429.0        198    4952          11.5   
91   13.0          8         400.0        150    4464          12.0   
92   13.0          8         351.0        158    4363          13.0   
93   14.0          8         318.0        150    4237          14.5   
94   13.0          8         440.0        215    4735          11.0   
95   12.0          8         455.0        225    4951          11.0   
96   13.0          8         360.0        175    3821          11.0   
97   18.0          6         225.0        105    3121          16.5   
98   16.0          6         250.0        100    3278          18.0   
99   18.0          6         232.0        100    2945          16.0   
100  18.0          6         250.0         88    3021          16.5   
101  23.0          6         198.0         95    2904          16.0   
102  26.0          4          97.0         46    1950          21.0   
103  11.0          8         400.0        150    4997          14.0   
104  12.0          8         400.0        167    4906          12.5   
105  13.0          8         360.0        170    4654          13.0   
106  12.0          8         350.0        180    4499          12.5   
107  18.0          6         232.0        100    2789          15.0   
108  20.0          4          97.0         88    2279          19.0   
109  21.0          4         140.0         72    2401          19.5   
110  22.0          4         108.0         94    2379          16.5   
111  18.0          3          70.0         90    2124          13.5   
112  19.0          4         122.0         85    2310          18.5   
113  21.0          6         155.0        107    2472          14.0   
114  26.0          4          98.0         90    2265          15.5   
115  15.0          8         350.0        145    4082          13.0   
116  16.0          8         400.0        230    4278           9.5   
117  29.0          4          68.0         49    1867          19.5   
118  24.0          4         116.0         75    2158          15.5   
119  20.0          4         114.0         91    2582          14.0   
120  19.0          4         121.0        112    2868          15.5   
121  15.0          8         318.0        150    3399          11.0   
122  24.0          4         121.0        110    2660          14.0   
123  20.0          6         156.0        122    2807          13.5   
124  11.0          8         350.0        180    3664          11.0   
125  20.0          6         198.0         95    3102          16.5   
127  19.0          6         232.0        100    2901          16.0   
128  15.0          6         250.0        100    3336          17.0   
129  31.0          4          79.0         67    1950          19.0   
130  26.0          4         122.0         80    2451          16.5   
131  32.0          4          71.0         65    1836          21.0   
132  25.0          4         140.0         75    2542          17.0   
133  16.0          6         250.0        100    3781          17.0   
134  16.0          6         258.0        110    3632          18.0   
135  18.0          6         225.0        105    3613          16.5   
136  16.0          8         302.0        140    4141          14.0   
137  13.0          8         350.0        150    4699          14.5   
138  14.0          8         318.0        150    4457          13.5   
139  14.0          8         302.0        140    4638          16.0   
140  14.0          8         304.0        150    4257          15.5   
141  29.0          4          98.0         83    2219          16.5   
142  26.0          4          79.0         67    1963          15.5   
143  26.0          4          97.0         78    2300          14.5   
144  31.0          4          76.0         52    1649          16.5   
145  32.0          4          83.0         61    2003          19.0   
146  28.0          4          90.0         75    2125          14.5   
147  24.0          4          90.0         75    2108          15.5   
148  26.0          4         116.0         75    2246          14.0   
149  24.0          4         120.0         97    2489          15.0   
150  26.0          4         108.0         93    2391          15.5   
151  31.0          4          79.0         67    2000          16.0   
152  19.0          6         225.0         95    3264          16.0   
153  18.0          6         250.0        105    3459          16.0   
154  15.0          6         250.0         72    3432          21.0   
155  15.0          6         250.0         72    3158          19.5   
156  16.0          8         400.0        170    4668          11.5   
157  15.0          8         350.0        145    4440          14.0   
158  16.0          8         318.0        150    4498          14.5   
159  14.0          8         351.0        148    4657          13.5   
160  17.0          6         231.0        110    3907          21.0   
161  16.0          6         250.0        105    3897          18.5   
162  15.0          6         258.0        110    3730          19.0   
163  18.0          6         225.0         95    3785          19.0   
164  21.0          6         231.0        110    3039          15.0   
165  20.0          8         262.0        110    3221          13.5   
166  13.0          8         302.0        129    3169          12.0   
167  29.0          4          97.0         75    2171          16.0   
168  23.0          4         140.0         83    2639          17.0   
169  20.0          6         232.0        100    2914          16.0   
170  23.0          4         140.0         78    2592          18.5   
171  24.0          4         134.0         96    2702          13.5   
172  25.0          4          90.0         71    2223          16.5   
173  24.0          4         119.0         97    2545          17.0   
174  18.0          6         171.0         97    2984          14.5   
175  29.0          4          90.0         70    1937          14.0   
176  19.0          6         232.0         90    3211          17.0   
177  23.0          4         115.0         95    2694          15.0   
178  23.0          4         120.0         88    2957          17.0   
179  22.0          4         121.0         98    2945          14.5   
180  25.0          4         121.0        115    2671          13.5   
181  33.0          4          91.0         53    1795          17.5   
182  28.0          4         107.0         86    2464          15.5   
183  25.0          4         116.0         81    2220          16.9   
184  25.0          4         140.0         92    2572          14.9   
185  26.0          4          98.0         79    2255          17.7   
186  27.0          4         101.0         83    2202          15.3   
187  17.5          8         305.0        140    4215          13.0   
188  16.0          8         318.0        150    4190          13.0   
189  15.5          8         304.0        120    3962          13.9   
190  14.5          8         351.0        152    4215          12.8   
191  22.0          6         225.0        100    3233          15.4   
192  22.0          6         250.0        105    3353          14.5   
193  24.0          6         200.0         81    3012          17.6   
194  22.5          6         232.0         90    3085          17.6   
195  29.0          4          85.0         52    2035          22.2   
196  24.5          4          98.0         60    2164          22.1   
197  29.0          4          90.0         70    1937          14.2   
198  33.0          4          91.0         53    1795          17.4   
199  20.0          6         225.0        100    3651          17.7   
200  18.0          6         250.0         78    3574          21.0   
201  18.5          6         250.0        110    3645          16.2   
202  17.5          6         258.0         95    3193          17.8   
203  29.5          4          97.0         71    1825          12.2   
204  32.0          4          85.0         70    1990          17.0   
205  28.0          4          97.0         75    2155          16.4   
206  26.5          4         140.0         72    2565          13.6   
207  20.0          4         130.0        102    3150          15.7   
208  13.0          8         318.0        150    3940          13.2   
209  19.0          4         120.0         88    3270          21.9   
210  19.0          6         156.0        108    2930          15.5   
211  16.5          6         168.0        120    3820          16.7   
212  16.5          8         350.0        180    4380          12.1   
213  13.0          8         350.0        145    4055          12.0   
214  13.0          8         302.0        130    3870          15.0   
215  13.0          8         318.0        150    3755          14.0   
216  31.5          4          98.0         68    2045          18.5   
217  30.0          4         111.0         80    2155          14.8   
218  36.0          4          79.0         58    1825          18.6   
219  25.5          4         122.0         96    2300          15.5   
220  33.5          4          85.0         70    1945          16.8   
221  17.5          8         305.0        145    3880          12.5   
222  17.0          8         260.0        110    4060          19.0   
223  15.5          8         318.0        145    4140          13.7   
224  15.0          8         302.0        130    4295          14.9   
225  17.5          6         250.0        110    3520          16.4   
226  20.5          6         231.0        105    3425          16.9   
227  19.0          6         225.0        100    3630          17.7   
228  18.5          6         250.0         98    3525          19.0   
229  16.0          8         400.0        180    4220          11.1   
230  15.5          8         350.0        170    4165          11.4   
231  15.5          8         400.0        190    4325          12.2   
232  16.0          8         351.0        149    4335          14.5   
233  29.0          4          97.0         78    1940          14.5   
234  24.5          4         151.0         88    2740          16.0   
235  26.0          4          97.0         75    2265          18.2   
236  25.5          4         140.0         89    2755          15.8   
237  30.5          4          98.0         63    2051          17.0   
238  33.5          4          98.0         83    2075          15.9   
239  30.0          4          97.0         67    1985          16.4   
240  30.5          4          97.0         78    2190          14.1   
241  22.0          6         146.0         97    2815          14.5   
242  21.5          4         121.0        110    2600          12.8   
243  21.5          3          80.0        110    2720          13.5   
244  43.1          4          90.0         48    1985          21.5   
245  36.1          4          98.0         66    1800          14.4   
246  32.8          4          78.0         52    1985          19.4   
247  39.4          4          85.0         70    2070          18.6   
248  36.1          4          91.0         60    1800          16.4   
249  19.9          8         260.0        110    3365          15.5   
250  19.4          8         318.0        140    3735          13.2   
251  20.2          8         302.0        139    3570          12.8   
252  19.2          6         231.0        105    3535          19.2   
253  20.5          6         200.0         95    3155          18.2   
254  20.2          6         200.0         85    2965          15.8   
255  25.1          4         140.0         88    2720          15.4   
256  20.5          6         225.0        100    3430          17.2   
257  19.4          6         232.0         90    3210          17.2   
258  20.6          6         231.0        105    3380          15.8   
259  20.8          6         200.0         85    3070          16.7   
260  18.6          6         225.0        110    3620          18.7   
261  18.1          6         258.0        120    3410          15.1   
262  19.2          8         305.0        145    3425          13.2   
263  17.7          6         231.0        165    3445          13.4   
264  18.1          8         302.0        139    3205          11.2   
265  17.5          8         318.0        140    4080          13.7   
266  30.0          4          98.0         68    2155          16.5   
267  27.5          4         134.0         95    2560          14.2   
268  27.2          4         119.0         97    2300          14.7   
269  30.9          4         105.0         75    2230          14.5   
270  21.1          4         134.0         95    2515          14.8   
271  23.2          4         156.0        105    2745          16.7   
272  23.8          4         151.0         85    2855          17.6   
273  23.9          4         119.0         97    2405          14.9   
274  20.3          5         131.0        103    2830          15.9   
275  17.0          6         163.0        125    3140          13.6   
276  21.6          4         121.0        115    2795          15.7   
277  16.2          6         163.0        133    3410          15.8   
278  31.5          4          89.0         71    1990          14.9   
279  29.5          4          98.0         68    2135          16.6   
280  21.5          6         231.0        115    3245          15.4   
281  19.8          6         200.0         85    2990          18.2   
282  22.3          4         140.0         88    2890          17.3   
283  20.2          6         232.0         90    3265          18.2   
284  20.6          6         225.0        110    3360          16.6   
285  17.0          8         305.0        130    3840          15.4   
286  17.6          8         302.0        129    3725          13.4   
287  16.5          8         351.0        138    3955          13.2   
288  18.2          8         318.0        135    3830          15.2   
289  16.9          8         350.0        155    4360          14.9   
290  15.5          8         351.0        142    4054          14.3   
291  19.2          8         267.0        125    3605          15.0   
292  18.5          8         360.0        150    3940          13.0   
293  31.9          4          89.0         71    1925          14.0   
294  34.1          4          86.0         65    1975          15.2   
295  35.7          4          98.0         80    1915          14.4   
296  27.4          4         121.0         80    2670          15.0   
297  25.4          5         183.0         77    3530          20.1   
298  23.0          8         350.0        125    3900          17.4   
299  27.2          4         141.0         71    3190          24.8   
300  23.9          8         260.0         90    3420          22.2   
301  34.2          4         105.0         70    2200          13.2   
302  34.5          4         105.0         70    2150          14.9   
303  31.8          4          85.0         65    2020          19.2   
304  37.3          4          91.0         69    2130          14.7   
305  28.4          4         151.0         90    2670          16.0   
306  28.8          6         173.0        115    2595          11.3   
307  26.8          6         173.0        115    2700          12.9   
308  33.5          4         151.0         90    2556          13.2   
309  41.5          4          98.0         76    2144          14.7   
310  38.1          4          89.0         60    1968          18.8   
311  32.1          4          98.0         70    2120          15.5   
312  37.2          4          86.0         65    2019          16.4   
313  28.0          4         151.0         90    2678          16.5   
314  26.4          4         140.0         88    2870          18.1   
315  24.3          4         151.0         90    3003          20.1   
316  19.1          6         225.0         90    3381          18.7   
317  34.3          4          97.0         78    2188          15.8   
318  29.8          4         134.0         90    2711          15.5   
319  31.3          4         120.0         75    2542          17.5   
320  37.0          4         119.0         92    2434          15.0   
321  32.2          4         108.0         75    2265          15.2   
322  46.6          4          86.0         65    2110          17.9   
323  27.9          4         156.0        105    2800          14.4   
324  40.8          4          85.0         65    2110          19.2   
325  44.3          4          90.0         48    2085          21.7   
326  43.4          4          90.0         48    2335          23.7   
327  36.4          5         121.0         67    2950          19.9   
328  30.0          4         146.0         67    3250          21.8   
329  44.6          4          91.0         67    1850          13.8   
331  33.8          4          97.0         67    2145          18.0   
332  29.8          4          89.0         62    1845          15.3   
333  32.7          6         168.0        132    2910          11.4   
334  23.7          3          70.0        100    2420          12.5   
335  35.0          4         122.0         88    2500          15.1   
337  32.4          4         107.0         72    2290          17.0   
338  27.2          4         135.0         84    2490          15.7   
339  26.6          4         151.0         84    2635          16.4   
340  25.8          4         156.0         92    2620          14.4   
341  23.5          6         173.0        110    2725          12.6   
342  30.0          4         135.0         84    2385          12.9   
343  39.1          4          79.0         58    1755          16.9   
344  39.0          4          86.0         64    1875          16.4   
345  35.1          4          81.0         60    1760          16.1   
346  32.3          4          97.0         67    2065          17.8   
347  37.0          4          85.0         65    1975          19.4   
348  37.7          4          89.0         62    2050          17.3   
349  34.1          4          91.0         68    1985          16.0   
350  34.7          4         105.0         63    2215          14.9   
351  34.4          4          98.0         65    2045          16.2   
352  29.9          4          98.0         65    2380          20.7   
353  33.0          4         105.0         74    2190          14.2   
355  33.7          4         107.0         75    2210          14.4   
356  32.4          4         108.0         75    2350          16.8   
357  32.9          4         119.0        100    2615          14.8   
358  31.6          4         120.0         74    2635          18.3   
359  28.1          4         141.0         80    3230          20.4   
360  30.7          6         145.0         76    3160          19.6   
361  25.4          6         168.0        116    2900          12.6   
362  24.2          6         146.0        120    2930          13.8   
363  22.4          6         231.0        110    3415          15.8   
364  26.6          8         350.0        105    3725          19.0   
365  20.2          6         200.0         88    3060          17.1   
366  17.6          6         225.0         85    3465          16.6   
367  28.0          4         112.0         88    2605          19.6   
368  27.0          4         112.0         88    2640          18.6   
369  34.0          4         112.0         88    2395          18.0   
370  31.0          4         112.0         85    2575          16.2   
371  29.0          4         135.0         84    2525          16.0   
372  27.0          4         151.0         90    2735          18.0   
373  24.0          4         140.0         92    2865          16.4   
375  36.0          4         105.0         74    1980          15.3   
376  37.0          4          91.0         68    2025          18.2   
377  31.0          4          91.0         68    1970          17.6   
378  38.0          4         105.0         63    2125          14.7   
379  36.0          4          98.0         70    2125          17.3   
380  36.0          4         120.0         88    2160          14.5   
381  36.0          4         107.0         75    2205          14.5   
382  34.0          4         108.0         70    2245          16.9   
383  38.0          4          91.0         67    1965          15.0   
384  32.0          4          91.0         67    1965          15.7   
385  38.0          4          91.0         67    1995          16.2   
386  25.0          6         181.0        110    2945          16.4   
387  38.0          6         262.0         85    3015          17.0   
388  26.0          4         156.0         92    2585          14.5   
389  22.0          6         232.0        112    2835          14.7   
390  32.0          4         144.0         96    2665          13.9   
391  36.0          4         135.0         84    2370          13.0   
392  27.0          4         151.0         90    2950          17.3   
393  27.0          4         140.0         86    2790          15.6   
394  44.0          4          97.0         52    2130          24.6   
395  32.0          4         135.0         84    2295          11.6   
396  28.0          4         120.0         79    2625          18.6   
397  31.0          4         119.0         82    2720          19.4   

     model year  origin                              car name  
0            70       1             chevrolet chevelle malibu  
1            70       1                     buick skylark 320  
2            70       1                    plymouth satellite  
3            70       1                         amc rebel sst  
4            70       1                           ford torino  
5            70       1                      ford galaxie 500  
6            70       1                      chevrolet impala  
7            70       1                     plymouth fury iii  
8            70       1                      pontiac catalina  
9            70       1                    amc ambassador dpl  
10           70       1                   dodge challenger se  
11           70       1                    plymouth 'cuda 340  
12           70       1                 chevrolet monte carlo  
13           70       1               buick estate wagon (sw)  
14           70       3                 toyota corona mark ii  
15           70       1                       plymouth duster  
16           70       1                            amc hornet  
17           70       1                         ford maverick  
18           70       3                          datsun pl510  
19           70       2          volkswagen 1131 deluxe sedan  
20           70       2                           peugeot 504  
21           70       2                           audi 100 ls  
22           70       2                              saab 99e  
23           70       2                              bmw 2002  
24           70       1                           amc gremlin  
25           70       1                             ford f250  
26           70       1                             chevy c20  
27           70       1                            dodge d200  
28           70       1                              hi 1200d  
29           71       3                          datsun pl510  
30           71       1                   chevrolet vega 2300  
31           71       3                         toyota corona  
33           71       1                           amc gremlin  
34           71       1             plymouth satellite custom  
35           71       1             chevrolet chevelle malibu  
36           71       1                       ford torino 500  
37           71       1                           amc matador  
38           71       1                      chevrolet impala  
39           71       1             pontiac catalina brougham  
40           71       1                      ford galaxie 500  
41           71       1                     plymouth fury iii  
42           71       1                     dodge monaco (sw)  
43           71       1              ford country squire (sw)  
44           71       1                   pontiac safari (sw)  
45           71       1            amc hornet sportabout (sw)  
46           71       1                   chevrolet vega (sw)  
47           71       1                      pontiac firebird  
48           71       1                          ford mustang  
49           71       1                    mercury capri 2000  
50           71       2                             opel 1900  
51           71       2                           peugeot 304  
52           71       2                             fiat 124b  
53           71       3                   toyota corolla 1200  
54           71       3                           datsun 1200  
55           71       2                  volkswagen model 111  
56           71       1                      plymouth cricket  
57           72       3                 toyota corona hardtop  
58           72       1                    dodge colt hardtop  
59           72       2                     volkswagen type 3  
60           72       1                        chevrolet vega  
61           72       1                   ford pinto runabout  
62           72       1                      chevrolet impala  
63           72       1                      pontiac catalina  
64           72       1                     plymouth fury iii  
65           72       1                      ford galaxie 500  
66           72       1                    amc ambassador sst  
67           72       1                       mercury marquis  
68           72       1                  buick lesabre custom  
69           72       1            oldsmobile delta 88 royale  
70           72       1                chrysler newport royal  
71           72       3                       mazda rx2 coupe  
72           72       1                      amc matador (sw)  
73           72       1      chevrolet chevelle concours (sw)  
74           72       1                 ford gran torino (sw)  
75           72       1        plymouth satellite custom (sw)  
76           72       2                       volvo 145e (sw)  
77           72       2                   volkswagen 411 (sw)  
78           72       2                      peugeot 504 (sw)  
79           72       2                       renault 12 (sw)  
80           72       1                       ford pinto (sw)  
81           72       3                       datsun 510 (sw)  
82           72       3           toyouta corona mark ii (sw)  
83           72       1                       dodge colt (sw)  
84           72       3              toyota corolla 1600 (sw)  
85           73       1                     buick century 350  
86           73       1                           amc matador  
87           73       1                      chevrolet malibu  
88           73       1                      ford gran torino  
89           73       1                  dodge coronet custom  
90           73       1              mercury marquis brougham  
91           73       1             chevrolet caprice classic  
92           73       1                              ford ltd  
93           73       1              plymouth fury gran sedan  
94           73       1          chrysler new yorker brougham  
95           73       1              buick electra 225 custom  
96           73       1               amc ambassador brougham  
97           73       1                      plymouth valiant  
98           73       1                 chevrolet nova custom  
99           73       1                            amc hornet  
100          73       1                         ford maverick  
101          73       1                       plymouth duster  
102          73       2               volkswagen super beetle  
103          73       1                      chevrolet impala  
104          73       1                          ford country  
105          73       1                plymouth custom suburb  
106          73       1              oldsmobile vista cruiser  
107          73       1                           amc gremlin  
108          73       3                         toyota carina  
109          73       1                        chevrolet vega  
110          73       3                            datsun 610  
111          73       3                             maxda rx3  
112          73       1                            ford pinto  
113          73       1                      mercury capri v6  
114          73       2                  fiat 124 sport coupe  
115          73       1               chevrolet monte carlo s  
116          73       1                    pontiac grand prix  
117          73       2                              fiat 128  
118          73       2                            opel manta  
119          73       2                            audi 100ls  
120          73       2                           volvo 144ea  
121          73       1                     dodge dart custom  
122          73       2                             saab 99le  
123          73       3                        toyota mark ii  
124          73       1                      oldsmobile omega  
125          74       1                       plymouth duster  
127          74       1                            amc hornet  
128          74       1                        chevrolet nova  
129          74       3                           datsun b210  
130          74       1                            ford pinto  
131          74       3                   toyota corolla 1200  
132          74       1                        chevrolet vega  
133          74       1     chevrolet chevelle malibu classic  
134          74       1                           amc matador  
135          74       1            plymouth satellite sebring  
136          74       1                      ford gran torino  
137          74       1              buick century luxus (sw)  
138          74       1             dodge coronet custom (sw)  
139          74       1                 ford gran torino (sw)  
140          74       1                      amc matador (sw)  
141          74       2                              audi fox  
142          74       2                     volkswagen dasher  
143          74       2                            opel manta  
144          74       3                         toyota corona  
145          74       3                            datsun 710  
146          74       1                            dodge colt  
147          74       2                              fiat 128  
148          74       2                           fiat 124 tc  
149          74       3                           honda civic  
150          74       3                                subaru  
151          74       2                             fiat x1.9  
152          75       1               plymouth valiant custom  
153          75       1                        chevrolet nova  
154          75       1                       mercury monarch  
155          75       1                         ford maverick  
156          75       1                      pontiac catalina  
157          75       1                     chevrolet bel air  
158          75       1                   plymouth grand fury  
159          75       1                              ford ltd  
160          75       1                         buick century  
161          75       1             chevroelt chevelle malibu  
162          75       1                           amc matador  
163          75       1                         plymouth fury  
164          75       1                         buick skyhawk  
165          75       1                   chevrolet monza 2+2  
166          75       1                       ford mustang ii  
167          75       3                        toyota corolla  
168          75       1                            ford pinto  
169          75       1                           amc gremlin  
170          75       1                         pontiac astro  
171          75       3                         toyota corona  
172          75       2                     volkswagen dasher  
173          75       3                            datsun 710  
174          75       1                            ford pinto  
175          75       2                     volkswagen rabbit  
176          75       1                             amc pacer  
177          75       2                            audi 100ls  
178          75       2                           peugeot 504  
179          75       2                           volvo 244dl  
180          75       2                             saab 99le  
181          75       3                      honda civic cvcc  
182          76       2                              fiat 131  
183          76       2                             opel 1900  
184          76       1                              capri ii  
185          76       1                            dodge colt  
186          76       2                          renault 12tl  
187          76       1     chevrolet chevelle malibu classic  
188          76       1                dodge coronet brougham  
189          76       1                           amc matador  
190          76       1                      ford gran torino  
191          76       1                      plymouth valiant  
192          76       1                        chevrolet nova  
193          76       1                         ford maverick  
194          76       1                            amc hornet  
195          76       1                    chevrolet chevette  
196          76       1                       chevrolet woody  
197          76       2                             vw rabbit  
198          76       3                           honda civic  
199          76       1                        dodge aspen se  
200          76       1                     ford granada ghia  
201          76       1                    pontiac ventura sj  
202          76       1                         amc pacer d/l  
203          76       2                     volkswagen rabbit  
204          76       3                          datsun b-210  
205          76       3                        toyota corolla  
206          76       1                            ford pinto  
207          76       2                             volvo 245  
208          76       1            plymouth volare premier v8  
209          76       2                           peugeot 504  
210          76       3                        toyota mark ii  
211          76       2                    mercedes-benz 280s  
212          76       1                      cadillac seville  
213          76       1                             chevy c10  
214          76       1                             ford f108  
215          76       1                            dodge d100  
216          77       3                     honda accord cvcc  
217          77       1               buick opel isuzu deluxe  
218          77       2                         renault 5 gtl  
219          77       1                     plymouth arrow gs  
220          77       3                 datsun f-10 hatchback  
221          77       1             chevrolet caprice classic  
222          77       1            oldsmobile cutlass supreme  
223          77       1                 dodge monaco brougham  
224          77       1               mercury cougar brougham  
225          77       1                    chevrolet concours  
226          77       1                         buick skylark  
227          77       1                plymouth volare custom  
228          77       1                          ford granada  
229          77       1                 pontiac grand prix lj  
230          77       1          chevrolet monte carlo landau  
231          77       1                      chrysler cordoba  
232          77       1                      ford thunderbird  
233          77       2              volkswagen rabbit custom  
234          77       1                 pontiac sunbird coupe  
235          77       3               toyota corolla liftback  
236          77       1                   ford mustang ii 2+2  
237          77       1                    chevrolet chevette  
238          77       1                        dodge colt m/m  
239          77       3                             subaru dl  
240          77       2                     volkswagen dasher  
241          77       3                            datsun 810  
242          77       2                              bmw 320i  
243          77       3                            mazda rx-4  
244          78       2       volkswagen rabbit custom diesel  
245          78       1                           ford fiesta  
246          78       3                      mazda glc deluxe  
247          78       3                        datsun b210 gx  
248          78       3                      honda civic cvcc  
249          78       1     oldsmobile cutlass salon brougham  
250          78       1                        dodge diplomat  
251          78       1                  mercury monarch ghia  
252          78       1                    pontiac phoenix lj  
253          78       1                      chevrolet malibu  
254          78       1                  ford fairmont (auto)  
255          78       1                   ford fairmont (man)  
256          78       1                       plymouth volare  
257          78       1                           amc concord  
258          78       1                 buick century special  
259          78       1                        mercury zephyr  
260          78       1                           dodge aspen  
261          78       1                       amc concord d/l  
262          78       1          chevrolet monte carlo landau  
263          78       1       buick regal sport coupe (turbo)  
264          78       1                           ford futura  
265          78       1                       dodge magnum xe  
266          78       1                    chevrolet chevette  
267          78       3                         toyota corona  
268          78       3                            datsun 510  
269          78       1                            dodge omni  
270          78       3             toyota celica gt liftback  
271          78       1                      plymouth sapporo  
272          78       1                oldsmobile starfire sx  
273          78       3                         datsun 200-sx  
274          78       2                             audi 5000  
275          78       2                           volvo 264gl  
276          78       2                            saab 99gle  
277          78       2                         peugeot 604sl  
278          78       2                   volkswagen scirocco  
279          78       3                       honda accord lx  
280          79       1                     pontiac lemans v6  
281          79       1                      mercury zephyr 6  
282          79       1                       ford fairmont 4  
283          79       1                      amc concord dl 6  
284          79       1                         dodge aspen 6  
285          79       1             chevrolet caprice classic  
286          79       1                       ford ltd landau  
287          79       1                 mercury grand marquis  
288          79       1                       dodge st. regis  
289          79       1               buick estate wagon (sw)  
290          79       1              ford country squire (sw)  
291          79       1         chevrolet malibu classic (sw)  
292          79       1  chrysler lebaron town @ country (sw)  
293          79       2                      vw rabbit custom  
294          79       3                      maxda glc deluxe  
295          79       1           dodge colt hatchback custom  
296          79       1                         amc spirit dl  
297          79       2                    mercedes benz 300d  
298          79       1                     cadillac eldorado  
299          79       2                           peugeot 504  
300          79       1     oldsmobile cutlass salon brougham  
301          79       1                      plymouth horizon  
302          79       1                  plymouth horizon tc3  
303          79       3                            datsun 210  
304          79       2                    fiat strada custom  
305          79       1                 buick skylark limited  
306          79       1                    chevrolet citation  
307          79       1             oldsmobile omega brougham  
308          79       1                       pontiac phoenix  
309          80       2                             vw rabbit  
310          80       3                 toyota corolla tercel  
311          80       1                    chevrolet chevette  
312          80       3                            datsun 310  
313          80       1                    chevrolet citation  
314          80       1                         ford fairmont  
315          80       1                           amc concord  
316          80       1                           dodge aspen  
317          80       2                             audi 4000  
318          80       3                toyota corona liftback  
319          80       3                             mazda 626  
320          80       3                  datsun 510 hatchback  
321          80       3                        toyota corolla  
322          80       3                             mazda glc  
323          80       1                            dodge colt  
324          80       3                            datsun 210  
325          80       2                  vw rabbit c (diesel)  
326          80       2                    vw dasher (diesel)  
327          80       2                   audi 5000s (diesel)  
328          80       2                    mercedes-benz 240d  
329          80       3                   honda civic 1500 gl  
331          80       3                             subaru dl  
332          80       2                      vokswagen rabbit  
333          80       3                         datsun 280-zx  
334          80       3                         mazda rx-7 gs  
335          80       2                     triumph tr7 coupe  
337          80       3                          honda accord  
338          81       1                      plymouth reliant  
339          81       1                         buick skylark  
340          81       1                dodge aries wagon (sw)  
341          81       1                    chevrolet citation  
342          81       1                      plymouth reliant  
343          81       3                        toyota starlet  
344          81       1                        plymouth champ  
345          81       3                      honda civic 1300  
346          81       3                                subaru  
347          81       3                        datsun 210 mpg  
348          81       3                         toyota tercel  
349          81       3                           mazda glc 4  
350          81       1                    plymouth horizon 4  
351          81       1                        ford escort 4w  
352          81       1                        ford escort 2h  
353          81       2                      volkswagen jetta  
355          81       3                         honda prelude  
356          81       3                        toyota corolla  
357          81       3                          datsun 200sx  
358          81       3                             mazda 626  
359          81       2             peugeot 505s turbo diesel  
360          81       2                          volvo diesel  
361          81       3                       toyota cressida  
362          81       3                     datsun 810 maxima  
363          81       1                         buick century  
364          81       1                 oldsmobile cutlass ls  
365          81       1                       ford granada gl  
366          81       1                chrysler lebaron salon  
367          82       1                    chevrolet cavalier  
368          82       1              chevrolet cavalier wagon  
369          82       1             chevrolet cavalier 2-door  
370          82       1            pontiac j2000 se hatchback  
371          82       1                        dodge aries se  
372          82       1                       pontiac phoenix  
373          82       1                  ford fairmont futura  
375          82       2                   volkswagen rabbit l  
376          82       3                    mazda glc custom l  
377          82       3                      mazda glc custom  
378          82       1                plymouth horizon miser  
379          82       1                        mercury lynx l  
380          82       3                      nissan stanza xe  
381          82       3                          honda accord  
382          82       3                        toyota corolla  
383          82       3                           honda civic  
384          82       3                    honda civic (auto)  
385          82       3                         datsun 310 gx  
386          82       1                 buick century limited  
387          82       1     oldsmobile cutlass ciera (diesel)  
388          82       1            chrysler lebaron medallion  
389          82       1                        ford granada l  
390          82       3                      toyota celica gt  
391          82       1                     dodge charger 2.2  
392          82       1                      chevrolet camaro  
393          82       1                       ford mustang gl  
394          82       2                             vw pickup  
395          82       1                         dodge rampage  
396          82       1                           ford ranger  
397          82       1                            chevy s-10

Application

print(newdata.drop('mpg',axis = 1)) # drop the mpg column  axis{0 or ‘index’, 1 or ‘columns’}, default 0

     cylinders  displacement horsepower  weight  acceleration  model year  \
0            8         307.0        130    3504          12.0          70   
1            8         350.0        165    3693          11.5          70   
2            8         318.0        150    3436          11.0          70   
3            8         304.0        150    3433          12.0          70   
4            8         302.0        140    3449          10.5          70   
5            8         429.0        198    4341          10.0          70   
6            8         454.0        220    4354           9.0          70   
7            8         440.0        215    4312           8.5          70   
8            8         455.0        225    4425          10.0          70   
9            8         390.0        190    3850           8.5          70   
10           8         383.0        170    3563          10.0          70   
11           8         340.0        160    3609           8.0          70   
12           8         400.0        150    3761           9.5          70   
13           8         455.0        225    3086          10.0          70   
14           4         113.0         95    2372          15.0          70   
15           6         198.0         95    2833          15.5          70   
16           6         199.0         97    2774          15.5          70   
17           6         200.0         85    2587          16.0          70   
18           4          97.0         88    2130          14.5          70   
19           4          97.0         46    1835          20.5          70   
20           4         110.0         87    2672          17.5          70   
21           4         107.0         90    2430          14.5          70   
22           4         104.0         95    2375          17.5          70   
23           4         121.0        113    2234          12.5          70   
24           6         199.0         90    2648          15.0          70   
25           8         360.0        215    4615          14.0          70   
26           8         307.0        200    4376          15.0          70   
27           8         318.0        210    4382          13.5          70   
28           8         304.0        193    4732          18.5          70   
29           4          97.0         88    2130          14.5          71   
30           4         140.0         90    2264          15.5          71   
31           4         113.0         95    2228          14.0          71   
33           6         232.0        100    2634          13.0          71   
34           6         225.0        105    3439          15.5          71   
35           6         250.0        100    3329          15.5          71   
36           6         250.0         88    3302          15.5          71   
37           6         232.0        100    3288          15.5          71   
38           8         350.0        165    4209          12.0          71   
39           8         400.0        175    4464          11.5          71   
40           8         351.0        153    4154          13.5          71   
41           8         318.0        150    4096          13.0          71   
42           8         383.0        180    4955          11.5          71   
43           8         400.0        170    4746          12.0          71   
44           8         400.0        175    5140          12.0          71   
45           6         258.0        110    2962          13.5          71   
46           4         140.0         72    2408          19.0          71   
47           6         250.0        100    3282          15.0          71   
48           6         250.0         88    3139          14.5          71   
49           4         122.0         86    2220          14.0          71   
50           4         116.0         90    2123          14.0          71   
51           4          79.0         70    2074          19.5          71   
52           4          88.0         76    2065          14.5          71   
53           4          71.0         65    1773          19.0          71   
54           4          72.0         69    1613          18.0          71   
55           4          97.0         60    1834          19.0          71   
56           4          91.0         70    1955          20.5          71   
57           4         113.0         95    2278          15.5          72   
58           4          97.5         80    2126          17.0          72   
59           4          97.0         54    2254          23.5          72   
60           4         140.0         90    2408          19.5          72   
61           4         122.0         86    2226          16.5          72   
62           8         350.0        165    4274          12.0          72   
63           8         400.0        175    4385          12.0          72   
64           8         318.0        150    4135          13.5          72   
65           8         351.0        153    4129          13.0          72   
66           8         304.0        150    3672          11.5          72   
67           8         429.0        208    4633          11.0          72   
68           8         350.0        155    4502          13.5          72   
69           8         350.0        160    4456          13.5          72   
70           8         400.0        190    4422          12.5          72   
71           3          70.0         97    2330          13.5          72   
72           8         304.0        150    3892          12.5          72   
73           8         307.0        130    4098          14.0          72   
74           8         302.0        140    4294          16.0          72   
75           8         318.0        150    4077          14.0          72   
76           4         121.0        112    2933          14.5          72   
77           4         121.0         76    2511          18.0          72   
78           4         120.0         87    2979          19.5          72   
79           4          96.0         69    2189          18.0          72   
80           4         122.0         86    2395          16.0          72   
81           4          97.0         92    2288          17.0          72   
82           4         120.0         97    2506          14.5          72   
83           4          98.0         80    2164          15.0          72   
84           4          97.0         88    2100          16.5          72   
85           8         350.0        175    4100          13.0          73   
86           8         304.0        150    3672          11.5          73   
87           8         350.0        145    3988          13.0          73   
88           8         302.0        137    4042          14.5          73   
89           8         318.0        150    3777          12.5          73   
90           8         429.0        198    4952          11.5          73   
91           8         400.0        150    4464          12.0          73   
92           8         351.0        158    4363          13.0          73   
93           8         318.0        150    4237          14.5          73   
94           8         440.0        215    4735          11.0          73   
95           8         455.0        225    4951          11.0          73   
96           8         360.0        175    3821          11.0          73   
97           6         225.0        105    3121          16.5          73   
98           6         250.0        100    3278          18.0          73   
99           6         232.0        100    2945          16.0          73   
100          6         250.0         88    3021          16.5          73   
101          6         198.0         95    2904          16.0          73   
102          4          97.0         46    1950          21.0          73   
103          8         400.0        150    4997          14.0          73   
104          8         400.0        167    4906          12.5          73   
105          8         360.0        170    4654          13.0          73   
106          8         350.0        180    4499          12.5          73   
107          6         232.0        100    2789          15.0          73   
108          4          97.0         88    2279          19.0          73   
109          4         140.0         72    2401          19.5          73   
110          4         108.0         94    2379          16.5          73   
111          3          70.0         90    2124          13.5          73   
112          4         122.0         85    2310          18.5          73   
113          6         155.0        107    2472          14.0          73   
114          4          98.0         90    2265          15.5          73   
115          8         350.0        145    4082          13.0          73   
116          8         400.0        230    4278           9.5          73   
117          4          68.0         49    1867          19.5          73   
118          4         116.0         75    2158          15.5          73   
119          4         114.0         91    2582          14.0          73   
120          4         121.0        112    2868          15.5          73   
121          8         318.0        150    3399          11.0          73   
122          4         121.0        110    2660          14.0          73   
123          6         156.0        122    2807          13.5          73   
124          8         350.0        180    3664          11.0          73   
125          6         198.0         95    3102          16.5          74   
127          6         232.0        100    2901          16.0          74   
128          6         250.0        100    3336          17.0          74   
129          4          79.0         67    1950          19.0          74   
130          4         122.0         80    2451          16.5          74   
131          4          71.0         65    1836          21.0          74   
132          4         140.0         75    2542          17.0          74   
133          6         250.0        100    3781          17.0          74   
134          6         258.0        110    3632          18.0          74   
135          6         225.0        105    3613          16.5          74   
136          8         302.0        140    4141          14.0          74   
137          8         350.0        150    4699          14.5          74   
138          8         318.0        150    4457          13.5          74   
139          8         302.0        140    4638          16.0          74   
140          8         304.0        150    4257          15.5          74   
141          4          98.0         83    2219          16.5          74   
142          4          79.0         67    1963          15.5          74   
143          4          97.0         78    2300          14.5          74   
144          4          76.0         52    1649          16.5          74   
145          4          83.0         61    2003          19.0          74   
146          4          90.0         75    2125          14.5          74   
147          4          90.0         75    2108          15.5          74   
148          4         116.0         75    2246          14.0          74   
149          4         120.0         97    2489          15.0          74   
150          4         108.0         93    2391          15.5          74   
151          4          79.0         67    2000          16.0          74   
152          6         225.0         95    3264          16.0          75   
153          6         250.0        105    3459          16.0          75   
154          6         250.0         72    3432          21.0          75   
155          6         250.0         72    3158          19.5          75   
156          8         400.0        170    4668          11.5          75   
157          8         350.0        145    4440          14.0          75   
158          8         318.0        150    4498          14.5          75   
159          8         351.0        148    4657          13.5          75   
160          6         231.0        110    3907          21.0          75   
161          6         250.0        105    3897          18.5          75   
162          6         258.0        110    3730          19.0          75   
163          6         225.0         95    3785          19.0          75   
164          6         231.0        110    3039          15.0          75   
165          8         262.0        110    3221          13.5          75   
166          8         302.0        129    3169          12.0          75   
167          4          97.0         75    2171          16.0          75   
168          4         140.0         83    2639          17.0          75   
169          6         232.0        100    2914          16.0          75   
170          4         140.0         78    2592          18.5          75   
171          4         134.0         96    2702          13.5          75   
172          4          90.0         71    2223          16.5          75   
173          4         119.0         97    2545          17.0          75   
174          6         171.0         97    2984          14.5          75   
175          4          90.0         70    1937          14.0          75   
176          6         232.0         90    3211          17.0          75   
177          4         115.0         95    2694          15.0          75   
178          4         120.0         88    2957          17.0          75   
179          4         121.0         98    2945          14.5          75   
180          4         121.0        115    2671          13.5          75   
181          4          91.0         53    1795          17.5          75   
182          4         107.0         86    2464          15.5          76   
183          4         116.0         81    2220          16.9          76   
184          4         140.0         92    2572          14.9          76   
185          4          98.0         79    2255          17.7          76   
186          4         101.0         83    2202          15.3          76   
187          8         305.0        140    4215          13.0          76   
188          8         318.0        150    4190          13.0          76   
189          8         304.0        120    3962          13.9          76   
190          8         351.0        152    4215          12.8          76   
191          6         225.0        100    3233          15.4          76   
192          6         250.0        105    3353          14.5          76   
193          6         200.0         81    3012          17.6          76   
194          6         232.0         90    3085          17.6          76   
195          4          85.0         52    2035          22.2          76   
196          4          98.0         60    2164          22.1          76   
197          4          90.0         70    1937          14.2          76   
198          4          91.0         53    1795          17.4          76   
199          6         225.0        100    3651          17.7          76   
200          6         250.0         78    3574          21.0          76   
201          6         250.0        110    3645          16.2          76   
202          6         258.0         95    3193          17.8          76   
203          4          97.0         71    1825          12.2          76   
204          4          85.0         70    1990          17.0          76   
205          4          97.0         75    2155          16.4          76   
206          4         140.0         72    2565          13.6          76   
207          4         130.0        102    3150          15.7          76   
208          8         318.0        150    3940          13.2          76   
209          4         120.0         88    3270          21.9          76   
210          6         156.0        108    2930          15.5          76   
211          6         168.0        120    3820          16.7          76   
212          8         350.0        180    4380          12.1          76   
213          8         350.0        145    4055          12.0          76   
214          8         302.0        130    3870          15.0          76   
215          8         318.0        150    3755          14.0          76   
216          4          98.0         68    2045          18.5          77   
217          4         111.0         80    2155          14.8          77   
218          4          79.0         58    1825          18.6          77   
219          4         122.0         96    2300          15.5          77   
220          4          85.0         70    1945          16.8          77   
221          8         305.0        145    3880          12.5          77   
222          8         260.0        110    4060          19.0          77   
223          8         318.0        145    4140          13.7          77   
224          8         302.0        130    4295          14.9          77   
225          6         250.0        110    3520          16.4          77   
226          6         231.0        105    3425          16.9          77   
227          6         225.0        100    3630          17.7          77   
228          6         250.0         98    3525          19.0          77   
229          8         400.0        180    4220          11.1          77   
230          8         350.0        170    4165          11.4          77   
231          8         400.0        190    4325          12.2          77   
232          8         351.0        149    4335          14.5          77   
233          4          97.0         78    1940          14.5          77   
234          4         151.0         88    2740          16.0          77   
235          4          97.0         75    2265          18.2          77   
236          4         140.0         89    2755          15.8          77   
237          4          98.0         63    2051          17.0          77   
238          4          98.0         83    2075          15.9          77   
239          4          97.0         67    1985          16.4          77   
240          4          97.0         78    2190          14.1          77   
241          6         146.0         97    2815          14.5          77   
242          4         121.0        110    2600          12.8          77   
243          3          80.0        110    2720          13.5          77   
244          4          90.0         48    1985          21.5          78   
245          4          98.0         66    1800          14.4          78   
246          4          78.0         52    1985          19.4          78   
247          4          85.0         70    2070          18.6          78   
248          4          91.0         60    1800          16.4          78   
249          8         260.0        110    3365          15.5          78   
250          8         318.0        140    3735          13.2          78   
251          8         302.0        139    3570          12.8          78   
252          6         231.0        105    3535          19.2          78   
253          6         200.0         95    3155          18.2          78   
254          6         200.0         85    2965          15.8          78   
255          4         140.0         88    2720          15.4          78   
256          6         225.0        100    3430          17.2          78   
257          6         232.0         90    3210          17.2          78   
258          6         231.0        105    3380          15.8          78   
259          6         200.0         85    3070          16.7          78   
260          6         225.0        110    3620          18.7          78   
261          6         258.0        120    3410          15.1          78   
262          8         305.0        145    3425          13.2          78   
263          6         231.0        165    3445          13.4          78   
264          8         302.0        139    3205          11.2          78   
265          8         318.0        140    4080          13.7          78   
266          4          98.0         68    2155          16.5          78   
267          4         134.0         95    2560          14.2          78   
268          4         119.0         97    2300          14.7          78   
269          4         105.0         75    2230          14.5          78   
270          4         134.0         95    2515          14.8          78   
271          4         156.0        105    2745          16.7          78   
272          4         151.0         85    2855          17.6          78   
273          4         119.0         97    2405          14.9          78   
274          5         131.0        103    2830          15.9          78   
275          6         163.0        125    3140          13.6          78   
276          4         121.0        115    2795          15.7          78   
277          6         163.0        133    3410          15.8          78   
278          4          89.0         71    1990          14.9          78   
279          4          98.0         68    2135          16.6          78   
280          6         231.0        115    3245          15.4          79   
281          6         200.0         85    2990          18.2          79   
282          4         140.0         88    2890          17.3          79   
283          6         232.0         90    3265          18.2          79   
284          6         225.0        110    3360          16.6          79   
285          8         305.0        130    3840          15.4          79   
286          8         302.0        129    3725          13.4          79   
287          8         351.0        138    3955          13.2          79   
288          8         318.0        135    3830          15.2          79   
289          8         350.0        155    4360          14.9          79   
290          8         351.0        142    4054          14.3          79   
291          8         267.0        125    3605          15.0          79   
292          8         360.0        150    3940          13.0          79   
293          4          89.0         71    1925          14.0          79   
294          4          86.0         65    1975          15.2          79   
295          4          98.0         80    1915          14.4          79   
296          4         121.0         80    2670          15.0          79   
297          5         183.0         77    3530          20.1          79   
298          8         350.0        125    3900          17.4          79   
299          4         141.0         71    3190          24.8          79   
300          8         260.0         90    3420          22.2          79   
301          4         105.0         70    2200          13.2          79   
302          4         105.0         70    2150          14.9          79   
303          4          85.0         65    2020          19.2          79   
304          4          91.0         69    2130          14.7          79   
305          4         151.0         90    2670          16.0          79   
306          6         173.0        115    2595          11.3          79   
307          6         173.0        115    2700          12.9          79   
308          4         151.0         90    2556          13.2          79   
309          4          98.0         76    2144          14.7          80   
310          4          89.0         60    1968          18.8          80   
311          4          98.0         70    2120          15.5          80   
312          4          86.0         65    2019          16.4          80   
313          4         151.0         90    2678          16.5          80   
314          4         140.0         88    2870          18.1          80   
315          4         151.0         90    3003          20.1          80   
316          6         225.0         90    3381          18.7          80   
317          4          97.0         78    2188          15.8          80   
318          4         134.0         90    2711          15.5          80   
319          4         120.0         75    2542          17.5          80   
320          4         119.0         92    2434          15.0          80   
321          4         108.0         75    2265          15.2          80   
322          4          86.0         65    2110          17.9          80   
323          4         156.0        105    2800          14.4          80   
324          4          85.0         65    2110          19.2          80   
325          4          90.0         48    2085          21.7          80   
326          4          90.0         48    2335          23.7          80   
327          5         121.0         67    2950          19.9          80   
328          4         146.0         67    3250          21.8          80   
329          4          91.0         67    1850          13.8          80   
331          4          97.0         67    2145          18.0          80   
332          4          89.0         62    1845          15.3          80   
333          6         168.0        132    2910          11.4          80   
334          3          70.0        100    2420          12.5          80   
335          4         122.0         88    2500          15.1          80   
337          4         107.0         72    2290          17.0          80   
338          4         135.0         84    2490          15.7          81   
339          4         151.0         84    2635          16.4          81   
340          4         156.0         92    2620          14.4          81   
341          6         173.0        110    2725          12.6          81   
342          4         135.0         84    2385          12.9          81   
343          4          79.0         58    1755          16.9          81   
344          4          86.0         64    1875          16.4          81   
345          4          81.0         60    1760          16.1          81   
346          4          97.0         67    2065          17.8          81   
347          4          85.0         65    1975          19.4          81   
348          4          89.0         62    2050          17.3          81   
349          4          91.0         68    1985          16.0          81   
350          4         105.0         63    2215          14.9          81   
351          4          98.0         65    2045          16.2          81   
352          4          98.0         65    2380          20.7          81   
353          4         105.0         74    2190          14.2          81   
355          4         107.0         75    2210          14.4          81   
356          4         108.0         75    2350          16.8          81   
357          4         119.0        100    2615          14.8          81   
358          4         120.0         74    2635          18.3          81   
359          4         141.0         80    3230          20.4          81   
360          6         145.0         76    3160          19.6          81   
361          6         168.0        116    2900          12.6          81   
362          6         146.0        120    2930          13.8          81   
363          6         231.0        110    3415          15.8          81   
364          8         350.0        105    3725          19.0          81   
365          6         200.0         88    3060          17.1          81   
366          6         225.0         85    3465          16.6          81   
367          4         112.0         88    2605          19.6          82   
368          4         112.0         88    2640          18.6          82   
369          4         112.0         88    2395          18.0          82   
370          4         112.0         85    2575          16.2          82   
371          4         135.0         84    2525          16.0          82   
372          4         151.0         90    2735          18.0          82   
373          4         140.0         92    2865          16.4          82   
375          4         105.0         74    1980          15.3          82   
376          4          91.0         68    2025          18.2          82   
377          4          91.0         68    1970          17.6          82   
378          4         105.0         63    2125          14.7          82   
379          4          98.0         70    2125          17.3          82   
380          4         120.0         88    2160          14.5          82   
381          4         107.0         75    2205          14.5          82   
382          4         108.0         70    2245          16.9          82   
383          4          91.0         67    1965          15.0          82   
384          4          91.0         67    1965          15.7          82   
385          4          91.0         67    1995          16.2          82   
386          6         181.0        110    2945          16.4          82   
387          6         262.0         85    3015          17.0          82   
388          4         156.0         92    2585          14.5          82   
389          6         232.0        112    2835          14.7          82   
390          4         144.0         96    2665          13.9          82   
391          4         135.0         84    2370          13.0          82   
392          4         151.0         90    2950          17.3          82   
393          4         140.0         86    2790          15.6          82   
394          4          97.0         52    2130          24.6          82   
395          4         135.0         84    2295          11.6          82   
396          4         120.0         79    2625          18.6          82   
397          4         119.0         82    2720          19.4          82   

     origin                              car name  
0         1             chevrolet chevelle malibu  
1         1                     buick skylark 320  
2         1                    plymouth satellite  
3         1                         amc rebel sst  
4         1                           ford torino  
5         1                      ford galaxie 500  
6         1                      chevrolet impala  
7         1                     plymouth fury iii  
8         1                      pontiac catalina  
9         1                    amc ambassador dpl  
10        1                   dodge challenger se  
11        1                    plymouth 'cuda 340  
12        1                 chevrolet monte carlo  
13        1               buick estate wagon (sw)  
14        3                 toyota corona mark ii  
15        1                       plymouth duster  
16        1                            amc hornet  
17        1                         ford maverick  
18        3                          datsun pl510  
19        2          volkswagen 1131 deluxe sedan  
20        2                           peugeot 504  
21        2                           audi 100 ls  
22        2                              saab 99e  
23        2                              bmw 2002  
24        1                           amc gremlin  
25        1                             ford f250  
26        1                             chevy c20  
27        1                            dodge d200  
28        1                              hi 1200d  
29        3                          datsun pl510  
30        1                   chevrolet vega 2300  
31        3                         toyota corona  
33        1                           amc gremlin  
34        1             plymouth satellite custom  
35        1             chevrolet chevelle malibu  
36        1                       ford torino 500  
37        1                           amc matador  
38        1                      chevrolet impala  
39        1             pontiac catalina brougham  
40        1                      ford galaxie 500  
41        1                     plymouth fury iii  
42        1                     dodge monaco (sw)  
43        1              ford country squire (sw)  
44        1                   pontiac safari (sw)  
45        1            amc hornet sportabout (sw)  
46        1                   chevrolet vega (sw)  
47        1                      pontiac firebird  
48        1                          ford mustang  
49        1                    mercury capri 2000  
50        2                             opel 1900  
51        2                           peugeot 304  
52        2                             fiat 124b  
53        3                   toyota corolla 1200  
54        3                           datsun 1200  
55        2                  volkswagen model 111  
56        1                      plymouth cricket  
57        3                 toyota corona hardtop  
58        1                    dodge colt hardtop  
59        2                     volkswagen type 3  
60        1                        chevrolet vega  
61        1                   ford pinto runabout  
62        1                      chevrolet impala  
63        1                      pontiac catalina  
64        1                     plymouth fury iii  
65        1                      ford galaxie 500  
66        1                    amc ambassador sst  
67        1                       mercury marquis  
68        1                  buick lesabre custom  
69        1            oldsmobile delta 88 royale  
70        1                chrysler newport royal  
71        3                       mazda rx2 coupe  
72        1                      amc matador (sw)  
73        1      chevrolet chevelle concours (sw)  
74        1                 ford gran torino (sw)  
75        1        plymouth satellite custom (sw)  
76        2                       volvo 145e (sw)  
77        2                   volkswagen 411 (sw)  
78        2                      peugeot 504 (sw)  
79        2                       renault 12 (sw)  
80        1                       ford pinto (sw)  
81        3                       datsun 510 (sw)  
82        3           toyouta corona mark ii (sw)  
83        1                       dodge colt (sw)  
84        3              toyota corolla 1600 (sw)  
85        1                     buick century 350  
86        1                           amc matador  
87        1                      chevrolet malibu  
88        1                      ford gran torino  
89        1                  dodge coronet custom  
90        1              mercury marquis brougham  
91        1             chevrolet caprice classic  
92        1                              ford ltd  
93        1              plymouth fury gran sedan  
94        1          chrysler new yorker brougham  
95        1              buick electra 225 custom  
96        1               amc ambassador brougham  
97        1                      plymouth valiant  
98        1                 chevrolet nova custom  
99        1                            amc hornet  
100       1                         ford maverick  
101       1                       plymouth duster  
102       2               volkswagen super beetle  
103       1                      chevrolet impala  
104       1                          ford country  
105       1                plymouth custom suburb  
106       1              oldsmobile vista cruiser  
107       1                           amc gremlin  
108       3                         toyota carina  
109       1                        chevrolet vega  
110       3                            datsun 610  
111       3                             maxda rx3  
112       1                            ford pinto  
113       1                      mercury capri v6  
114       2                  fiat 124 sport coupe  
115       1               chevrolet monte carlo s  
116       1                    pontiac grand prix  
117       2                              fiat 128  
118       2                            opel manta  
119       2                            audi 100ls  
120       2                           volvo 144ea  
121       1                     dodge dart custom  
122       2                             saab 99le  
123       3                        toyota mark ii  
124       1                      oldsmobile omega  
125       1                       plymouth duster  
127       1                            amc hornet  
128       1                        chevrolet nova  
129       3                           datsun b210  
130       1                            ford pinto  
131       3                   toyota corolla 1200  
132       1                        chevrolet vega  
133       1     chevrolet chevelle malibu classic  
134       1                           amc matador  
135       1            plymouth satellite sebring  
136       1                      ford gran torino  
137       1              buick century luxus (sw)  
138       1             dodge coronet custom (sw)  
139       1                 ford gran torino (sw)  
140       1                      amc matador (sw)  
141       2                              audi fox  
142       2                     volkswagen dasher  
143       2                            opel manta  
144       3                         toyota corona  
145       3                            datsun 710  
146       1                            dodge colt  
147       2                              fiat 128  
148       2                           fiat 124 tc  
149       3                           honda civic  
150       3                                subaru  
151       2                             fiat x1.9  
152       1               plymouth valiant custom  
153       1                        chevrolet nova  
154       1                       mercury monarch  
155       1                         ford maverick  
156       1                      pontiac catalina  
157       1                     chevrolet bel air  
158       1                   plymouth grand fury  
159       1                              ford ltd  
160       1                         buick century  
161       1             chevroelt chevelle malibu  
162       1                           amc matador  
163       1                         plymouth fury  
164       1                         buick skyhawk  
165       1                   chevrolet monza 2+2  
166       1                       ford mustang ii  
167       3                        toyota corolla  
168       1                            ford pinto  
169       1                           amc gremlin  
170       1                         pontiac astro  
171       3                         toyota corona  
172       2                     volkswagen dasher  
173       3                            datsun 710  
174       1                            ford pinto  
175       2                     volkswagen rabbit  
176       1                             amc pacer  
177       2                            audi 100ls  
178       2                           peugeot 504  
179       2                           volvo 244dl  
180       2                             saab 99le  
181       3                      honda civic cvcc  
182       2                              fiat 131  
183       2                             opel 1900  
184       1                              capri ii  
185       1                            dodge colt  
186       2                          renault 12tl  
187       1     chevrolet chevelle malibu classic  
188       1                dodge coronet brougham  
189       1                           amc matador  
190       1                      ford gran torino  
191       1                      plymouth valiant  
192       1                        chevrolet nova  
193       1                         ford maverick  
194       1                            amc hornet  
195       1                    chevrolet chevette  
196       1                       chevrolet woody  
197       2                             vw rabbit  
198       3                           honda civic  
199       1                        dodge aspen se  
200       1                     ford granada ghia  
201       1                    pontiac ventura sj  
202       1                         amc pacer d/l  
203       2                     volkswagen rabbit  
204       3                          datsun b-210  
205       3                        toyota corolla  
206       1                            ford pinto  
207       2                             volvo 245  
208       1            plymouth volare premier v8  
209       2                           peugeot 504  
210       3                        toyota mark ii  
211       2                    mercedes-benz 280s  
212       1                      cadillac seville  
213       1                             chevy c10  
214       1                             ford f108  
215       1                            dodge d100  
216       3                     honda accord cvcc  
217       1               buick opel isuzu deluxe  
218       2                         renault 5 gtl  
219       1                     plymouth arrow gs  
220       3                 datsun f-10 hatchback  
221       1             chevrolet caprice classic  
222       1            oldsmobile cutlass supreme  
223       1                 dodge monaco brougham  
224       1               mercury cougar brougham  
225       1                    chevrolet concours  
226       1                         buick skylark  
227       1                plymouth volare custom  
228       1                          ford granada  
229       1                 pontiac grand prix lj  
230       1          chevrolet monte carlo landau  
231       1                      chrysler cordoba  
232       1                      ford thunderbird  
233       2              volkswagen rabbit custom  
234       1                 pontiac sunbird coupe  
235       3               toyota corolla liftback  
236       1                   ford mustang ii 2+2  
237       1                    chevrolet chevette  
238       1                        dodge colt m/m  
239       3                             subaru dl  
240       2                     volkswagen dasher  
241       3                            datsun 810  
242       2                              bmw 320i  
243       3                            mazda rx-4  
244       2       volkswagen rabbit custom diesel  
245       1                           ford fiesta  
246       3                      mazda glc deluxe  
247       3                        datsun b210 gx  
248       3                      honda civic cvcc  
249       1     oldsmobile cutlass salon brougham  
250       1                        dodge diplomat  
251       1                  mercury monarch ghia  
252       1                    pontiac phoenix lj  
253       1                      chevrolet malibu  
254       1                  ford fairmont (auto)  
255       1                   ford fairmont (man)  
256       1                       plymouth volare  
257       1                           amc concord  
258       1                 buick century special  
259       1                        mercury zephyr  
260       1                           dodge aspen  
261       1                       amc concord d/l  
262       1          chevrolet monte carlo landau  
263       1       buick regal sport coupe (turbo)  
264       1                           ford futura  
265       1                       dodge magnum xe  
266       1                    chevrolet chevette  
267       3                         toyota corona  
268       3                            datsun 510  
269       1                            dodge omni  
270       3             toyota celica gt liftback  
271       1                      plymouth sapporo  
272       1                oldsmobile starfire sx  
273       3                         datsun 200-sx  
274       2                             audi 5000  
275       2                           volvo 264gl  
276       2                            saab 99gle  
277       2                         peugeot 604sl  
278       2                   volkswagen scirocco  
279       3                       honda accord lx  
280       1                     pontiac lemans v6  
281       1                      mercury zephyr 6  
282       1                       ford fairmont 4  
283       1                      amc concord dl 6  
284       1                         dodge aspen 6  
285       1             chevrolet caprice classic  
286       1                       ford ltd landau  
287       1                 mercury grand marquis  
288       1                       dodge st. regis  
289       1               buick estate wagon (sw)  
290       1              ford country squire (sw)  
291       1         chevrolet malibu classic (sw)  
292       1  chrysler lebaron town @ country (sw)  
293       2                      vw rabbit custom  
294       3                      maxda glc deluxe  
295       1           dodge colt hatchback custom  
296       1                         amc spirit dl  
297       2                    mercedes benz 300d  
298       1                     cadillac eldorado  
299       2                           peugeot 504  
300       1     oldsmobile cutlass salon brougham  
301       1                      plymouth horizon  
302       1                  plymouth horizon tc3  
303       3                            datsun 210  
304       2                    fiat strada custom  
305       1                 buick skylark limited  
306       1                    chevrolet citation  
307       1             oldsmobile omega brougham  
308       1                       pontiac phoenix  
309       2                             vw rabbit  
310       3                 toyota corolla tercel  
311       1                    chevrolet chevette  
312       3                            datsun 310  
313       1                    chevrolet citation  
314       1                         ford fairmont  
315       1                           amc concord  
316       1                           dodge aspen  
317       2                             audi 4000  
318       3                toyota corona liftback  
319       3                             mazda 626  
320       3                  datsun 510 hatchback  
321       3                        toyota corolla  
322       3                             mazda glc  
323       1                            dodge colt  
324       3                            datsun 210  
325       2                  vw rabbit c (diesel)  
326       2                    vw dasher (diesel)  
327       2                   audi 5000s (diesel)  
328       2                    mercedes-benz 240d  
329       3                   honda civic 1500 gl  
331       3                             subaru dl  
332       2                      vokswagen rabbit  
333       3                         datsun 280-zx  
334       3                         mazda rx-7 gs  
335       2                     triumph tr7 coupe  
337       3                          honda accord  
338       1                      plymouth reliant  
339       1                         buick skylark  
340       1                dodge aries wagon (sw)  
341       1                    chevrolet citation  
342       1                      plymouth reliant  
343       3                        toyota starlet  
344       1                        plymouth champ  
345       3                      honda civic 1300  
346       3                                subaru  
347       3                        datsun 210 mpg  
348       3                         toyota tercel  
349       3                           mazda glc 4  
350       1                    plymouth horizon 4  
351       1                        ford escort 4w  
352       1                        ford escort 2h  
353       2                      volkswagen jetta  
355       3                         honda prelude  
356       3                        toyota corolla  
357       3                          datsun 200sx  
358       3                             mazda 626  
359       2             peugeot 505s turbo diesel  
360       2                          volvo diesel  
361       3                       toyota cressida  
362       3                     datsun 810 maxima  
363       1                         buick century  
364       1                 oldsmobile cutlass ls  
365       1                       ford granada gl  
366       1                chrysler lebaron salon  
367       1                    chevrolet cavalier  
368       1              chevrolet cavalier wagon  
369       1             chevrolet cavalier 2-door  
370       1            pontiac j2000 se hatchback  
371       1                        dodge aries se  
372       1                       pontiac phoenix  
373       1                  ford fairmont futura  
375       2                   volkswagen rabbit l  
376       3                    mazda glc custom l  
377       3                      mazda glc custom  
378       1                plymouth horizon miser  
379       1                        mercury lynx l  
380       3                      nissan stanza xe  
381       3                          honda accord  
382       3                        toyota corolla  
383       3                           honda civic  
384       3                    honda civic (auto)  
385       3                         datsun 310 gx  
386       1                 buick century limited  
387       1     oldsmobile cutlass ciera (diesel)  
388       1            chrysler lebaron medallion  
389       1                        ford granada l  
390       3                      toyota celica gt  
391       1                     dodge charger 2.2  
392       1                      chevrolet camaro  
393       1                       ford mustang gl  
394       2                             vw pickup  
395       1                         dodge rampage  
396       1                           ford ranger  
397       1                            chevy s-10

1.5 Detecting and Removing Outliers

OUTLIER

An observation that deviates abnormally from standard data
data measurement/entry error
deliberate error
natural outlier

IQR - INTER-QUARTILE RANGE

Range = Max - Min
IQR = Q3 - Q1
Low = Q1 - 1.5 * IQR
High = Q3 + 1.5 * IQR

IMPORT LIBRARIES

import numpy as np
import pandas as pd

2. Create a sample dataset with outliers

sample = pd.DataFrame([[1000],[2000],[3000],[4000],[5000],[6000],[7000],[8000],[9000],[20000]]  , columns=['Salary'])

OUTLIER FUNCTION

def outlier_treatment(datacolumn):
    sorted(datacolumn)
    Q1,Q3 = np.percentile(datacolumn , [25,75])
    IQR = Q3 - Q1
    lower_range = Q1 - (1.5 * IQR)
    upper_range = Q3 + (1.5 * IQR)
    return lower_range,upper_range

LOWER AND UPPERBOUND

lowerbound,upperbound = outlier_treatment(sample.Salary)

OUTLIER

sample[(sample.Salary < lowerbound) | (sample.Salary > upperbound)]

	Salary
9	20000

DROP OUTLIER

sample.drop(sample[ (sample.Salary > upperbound) | (sample.Salary < lowerbound) ].index , inplace=True)

OUTPUT

print(sample)

Remove Duplicates

print(df.drop_duplicates())

      mpg  cylinders  displacement horsepower  weight  acceleration  \
0    18.0          8         307.0        130    3504          12.0   
1    15.0          8         350.0        165    3693          11.5   
2    18.0          8         318.0        150    3436          11.0   
3    16.0          8         304.0        150    3433          12.0   
4    17.0          8         302.0        140    3449          10.5   
5    15.0          8         429.0        198    4341          10.0   
6    14.0          8         454.0        220    4354           9.0   
7    14.0          8         440.0        215    4312           8.5   
8    14.0          8         455.0        225    4425          10.0   
9    15.0          8         390.0        190    3850           8.5   
10   15.0          8         383.0        170    3563          10.0   
11   14.0          8         340.0        160    3609           8.0   
12   15.0          8         400.0        150    3761           9.5   
13   14.0          8         455.0        225    3086          10.0   
14   24.0          4         113.0         95    2372          15.0   
15   22.0          6         198.0         95    2833          15.5   
16   18.0          6         199.0         97    2774          15.5   
17   21.0          6         200.0         85    2587          16.0   
18   27.0          4          97.0         88    2130          14.5   
19   26.0          4          97.0         46    1835          20.5   
20   25.0          4         110.0         87    2672          17.5   
21   24.0          4         107.0         90    2430          14.5   
22   25.0          4         104.0         95    2375          17.5   
23   26.0          4         121.0        113    2234          12.5   
24   21.0          6         199.0         90    2648          15.0   
25   10.0          8         360.0        215    4615          14.0   
26   10.0          8         307.0        200    4376          15.0   
27   11.0          8         318.0        210    4382          13.5   
28    9.0          8         304.0        193    4732          18.5   
29   27.0          4          97.0         88    2130          14.5   
30   28.0          4         140.0         90    2264          15.5   
31   25.0          4         113.0         95    2228          14.0   
32   25.0          4          98.0          ?    2046          19.0   
33   19.0          6         232.0        100    2634          13.0   
34   16.0          6         225.0        105    3439          15.5   
35   17.0          6         250.0        100    3329          15.5   
36   19.0          6         250.0         88    3302          15.5   
37   18.0          6         232.0        100    3288          15.5   
38   14.0          8         350.0        165    4209          12.0   
39   14.0          8         400.0        175    4464          11.5   
40   14.0          8         351.0        153    4154          13.5   
41   14.0          8         318.0        150    4096          13.0   
42   12.0          8         383.0        180    4955          11.5   
43   13.0          8         400.0        170    4746          12.0   
44   13.0          8         400.0        175    5140          12.0   
45   18.0          6         258.0        110    2962          13.5   
46   22.0          4         140.0         72    2408          19.0   
47   19.0          6         250.0        100    3282          15.0   
48   18.0          6         250.0         88    3139          14.5   
49   23.0          4         122.0         86    2220          14.0   
50   28.0          4         116.0         90    2123          14.0   
51   30.0          4          79.0         70    2074          19.5   
52   30.0          4          88.0         76    2065          14.5   
53   31.0          4          71.0         65    1773          19.0   
54   35.0          4          72.0         69    1613          18.0   
55   27.0          4          97.0         60    1834          19.0   
56   26.0          4          91.0         70    1955          20.5   
57   24.0          4         113.0         95    2278          15.5   
58   25.0          4          97.5         80    2126          17.0   
59   23.0          4          97.0         54    2254          23.5   
60   20.0          4         140.0         90    2408          19.5   
61   21.0          4         122.0         86    2226          16.5   
62   13.0          8         350.0        165    4274          12.0   
63   14.0          8         400.0        175    4385          12.0   
64   15.0          8         318.0        150    4135          13.5   
65   14.0          8         351.0        153    4129          13.0   
66   17.0          8         304.0        150    3672          11.5   
67   11.0          8         429.0        208    4633          11.0   
68   13.0          8         350.0        155    4502          13.5   
69   12.0          8         350.0        160    4456          13.5   
70   13.0          8         400.0        190    4422          12.5   
71   19.0          3          70.0         97    2330          13.5   
72   15.0          8         304.0        150    3892          12.5   
73   13.0          8         307.0        130    4098          14.0   
74   13.0          8         302.0        140    4294          16.0   
75   14.0          8         318.0        150    4077          14.0   
76   18.0          4         121.0        112    2933          14.5   
77   22.0          4         121.0         76    2511          18.0   
78   21.0          4         120.0         87    2979          19.5   
79   26.0          4          96.0         69    2189          18.0   
80   22.0          4         122.0         86    2395          16.0   
81   28.0          4          97.0         92    2288          17.0   
82   23.0          4         120.0         97    2506          14.5   
83   28.0          4          98.0         80    2164          15.0   
84   27.0          4          97.0         88    2100          16.5   
85   13.0          8         350.0        175    4100          13.0   
86   14.0          8         304.0        150    3672          11.5   
87   13.0          8         350.0        145    3988          13.0   
88   14.0          8         302.0        137    4042          14.5   
89   15.0          8         318.0        150    3777          12.5   
90   12.0          8         429.0        198    4952          11.5   
91   13.0          8         400.0        150    4464          12.0   
92   13.0          8         351.0        158    4363          13.0   
93   14.0          8         318.0        150    4237          14.5   
94   13.0          8         440.0        215    4735          11.0   
95   12.0          8         455.0        225    4951          11.0   
96   13.0          8         360.0        175    3821          11.0   
97   18.0          6         225.0        105    3121          16.5   
98   16.0          6         250.0        100    3278          18.0   
99   18.0          6         232.0        100    2945          16.0   
100  18.0          6         250.0         88    3021          16.5   
101  23.0          6         198.0         95    2904          16.0   
102  26.0          4          97.0         46    1950          21.0   
103  11.0          8         400.0        150    4997          14.0   
104  12.0          8         400.0        167    4906          12.5   
105  13.0          8         360.0        170    4654          13.0   
106  12.0          8         350.0        180    4499          12.5   
107  18.0          6         232.0        100    2789          15.0   
108  20.0          4          97.0         88    2279          19.0   
109  21.0          4         140.0         72    2401          19.5   
110  22.0          4         108.0         94    2379          16.5   
111  18.0          3          70.0         90    2124          13.5   
112  19.0          4         122.0         85    2310          18.5   
113  21.0          6         155.0        107    2472          14.0   
114  26.0          4          98.0         90    2265          15.5   
115  15.0          8         350.0        145    4082          13.0   
116  16.0          8         400.0        230    4278           9.5   
117  29.0          4          68.0         49    1867          19.5   
118  24.0          4         116.0         75    2158          15.5   
119  20.0          4         114.0         91    2582          14.0   
120  19.0          4         121.0        112    2868          15.5   
121  15.0          8         318.0        150    3399          11.0   
122  24.0          4         121.0        110    2660          14.0   
123  20.0          6         156.0        122    2807          13.5   
124  11.0          8         350.0        180    3664          11.0   
125  20.0          6         198.0         95    3102          16.5   
126  21.0          6         200.0          ?    2875          17.0   
127  19.0          6         232.0        100    2901          16.0   
128  15.0          6         250.0        100    3336          17.0   
129  31.0          4          79.0         67    1950          19.0   
130  26.0          4         122.0         80    2451          16.5   
131  32.0          4          71.0         65    1836          21.0   
132  25.0          4         140.0         75    2542          17.0   
133  16.0          6         250.0        100    3781          17.0   
134  16.0          6         258.0        110    3632          18.0   
135  18.0          6         225.0        105    3613          16.5   
136  16.0          8         302.0        140    4141          14.0   
137  13.0          8         350.0        150    4699          14.5   
138  14.0          8         318.0        150    4457          13.5   
139  14.0          8         302.0        140    4638          16.0   
140  14.0          8         304.0        150    4257          15.5   
141  29.0          4          98.0         83    2219          16.5   
142  26.0          4          79.0         67    1963          15.5   
143  26.0          4          97.0         78    2300          14.5   
144  31.0          4          76.0         52    1649          16.5   
145  32.0          4          83.0         61    2003          19.0   
146  28.0          4          90.0         75    2125          14.5   
147  24.0          4          90.0         75    2108          15.5   
148  26.0          4         116.0         75    2246          14.0   
149  24.0          4         120.0         97    2489          15.0   
150  26.0          4         108.0         93    2391          15.5   
151  31.0          4          79.0         67    2000          16.0   
152  19.0          6         225.0         95    3264          16.0   
153  18.0          6         250.0        105    3459          16.0   
154  15.0          6         250.0         72    3432          21.0   
155  15.0          6         250.0         72    3158          19.5   
156  16.0          8         400.0        170    4668          11.5   
157  15.0          8         350.0        145    4440          14.0   
158  16.0          8         318.0        150    4498          14.5   
159  14.0          8         351.0        148    4657          13.5   
160  17.0          6         231.0        110    3907          21.0   
161  16.0          6         250.0        105    3897          18.5   
162  15.0          6         258.0        110    3730          19.0   
163  18.0          6         225.0         95    3785          19.0   
164  21.0          6         231.0        110    3039          15.0   
165  20.0          8         262.0        110    3221          13.5   
166  13.0          8         302.0        129    3169          12.0   
167  29.0          4          97.0         75    2171          16.0   
168  23.0          4         140.0         83    2639          17.0   
169  20.0          6         232.0        100    2914          16.0   
170  23.0          4         140.0         78    2592          18.5   
171  24.0          4         134.0         96    2702          13.5   
172  25.0          4          90.0         71    2223          16.5   
173  24.0          4         119.0         97    2545          17.0   
174  18.0          6         171.0         97    2984          14.5   
175  29.0          4          90.0         70    1937          14.0   
176  19.0          6         232.0         90    3211          17.0   
177  23.0          4         115.0         95    2694          15.0   
178  23.0          4         120.0         88    2957          17.0   
179  22.0          4         121.0         98    2945          14.5   
180  25.0          4         121.0        115    2671          13.5   
181  33.0          4          91.0         53    1795          17.5   
182  28.0          4         107.0         86    2464          15.5   
183  25.0          4         116.0         81    2220          16.9   
184  25.0          4         140.0         92    2572          14.9   
185  26.0          4          98.0         79    2255          17.7   
186  27.0          4         101.0         83    2202          15.3   
187  17.5          8         305.0        140    4215          13.0   
188  16.0          8         318.0        150    4190          13.0   
189  15.5          8         304.0        120    3962          13.9   
190  14.5          8         351.0        152    4215          12.8   
191  22.0          6         225.0        100    3233          15.4   
192  22.0          6         250.0        105    3353          14.5   
193  24.0          6         200.0         81    3012          17.6   
194  22.5          6         232.0         90    3085          17.6   
195  29.0          4          85.0         52    2035          22.2   
196  24.5          4          98.0         60    2164          22.1   
197  29.0          4          90.0         70    1937          14.2   
198  33.0          4          91.0         53    1795          17.4   
199  20.0          6         225.0        100    3651          17.7   
200  18.0          6         250.0         78    3574          21.0   
201  18.5          6         250.0        110    3645          16.2   
202  17.5          6         258.0         95    3193          17.8   
203  29.5          4          97.0         71    1825          12.2   
204  32.0          4          85.0         70    1990          17.0   
205  28.0          4          97.0         75    2155          16.4   
206  26.5          4         140.0         72    2565          13.6   
207  20.0          4         130.0        102    3150          15.7   
208  13.0          8         318.0        150    3940          13.2   
209  19.0          4         120.0         88    3270          21.9   
210  19.0          6         156.0        108    2930          15.5   
211  16.5          6         168.0        120    3820          16.7   
212  16.5          8         350.0        180    4380          12.1   
213  13.0          8         350.0        145    4055          12.0   
214  13.0          8         302.0        130    3870          15.0   
215  13.0          8         318.0        150    3755          14.0   
216  31.5          4          98.0         68    2045          18.5   
217  30.0          4         111.0         80    2155          14.8   
218  36.0          4          79.0         58    1825          18.6   
219  25.5          4         122.0         96    2300          15.5   
220  33.5          4          85.0         70    1945          16.8   
221  17.5          8         305.0        145    3880          12.5   
222  17.0          8         260.0        110    4060          19.0   
223  15.5          8         318.0        145    4140          13.7   
224  15.0          8         302.0        130    4295          14.9   
225  17.5          6         250.0        110    3520          16.4   
226  20.5          6         231.0        105    3425          16.9   
227  19.0          6         225.0        100    3630          17.7   
228  18.5          6         250.0         98    3525          19.0   
229  16.0          8         400.0        180    4220          11.1   
230  15.5          8         350.0        170    4165          11.4   
231  15.5          8         400.0        190    4325          12.2   
232  16.0          8         351.0        149    4335          14.5   
233  29.0          4          97.0         78    1940          14.5   
234  24.5          4         151.0         88    2740          16.0   
235  26.0          4          97.0         75    2265          18.2   
236  25.5          4         140.0         89    2755          15.8   
237  30.5          4          98.0         63    2051          17.0   
238  33.5          4          98.0         83    2075          15.9   
239  30.0          4          97.0         67    1985          16.4   
240  30.5          4          97.0         78    2190          14.1   
241  22.0          6         146.0         97    2815          14.5   
242  21.5          4         121.0        110    2600          12.8   
243  21.5          3          80.0        110    2720          13.5   
244  43.1          4          90.0         48    1985          21.5   
245  36.1          4          98.0         66    1800          14.4   
246  32.8          4          78.0         52    1985          19.4   
247  39.4          4          85.0         70    2070          18.6   
248  36.1          4          91.0         60    1800          16.4   
249  19.9          8         260.0        110    3365          15.5   
250  19.4          8         318.0        140    3735          13.2   
251  20.2          8         302.0        139    3570          12.8   
252  19.2          6         231.0        105    3535          19.2   
253  20.5          6         200.0         95    3155          18.2   
254  20.2          6         200.0         85    2965          15.8   
255  25.1          4         140.0         88    2720          15.4   
256  20.5          6         225.0        100    3430          17.2   
257  19.4          6         232.0         90    3210          17.2   
258  20.6          6         231.0        105    3380          15.8   
259  20.8          6         200.0         85    3070          16.7   
260  18.6          6         225.0        110    3620          18.7   
261  18.1          6         258.0        120    3410          15.1   
262  19.2          8         305.0        145    3425          13.2   
263  17.7          6         231.0        165    3445          13.4   
264  18.1          8         302.0        139    3205          11.2   
265  17.5          8         318.0        140    4080          13.7   
266  30.0          4          98.0         68    2155          16.5   
267  27.5          4         134.0         95    2560          14.2   
268  27.2          4         119.0         97    2300          14.7   
269  30.9          4         105.0         75    2230          14.5   
270  21.1          4         134.0         95    2515          14.8   
271  23.2          4         156.0        105    2745          16.7   
272  23.8          4         151.0         85    2855          17.6   
273  23.9          4         119.0         97    2405          14.9   
274  20.3          5         131.0        103    2830          15.9   
275  17.0          6         163.0        125    3140          13.6   
276  21.6          4         121.0        115    2795          15.7   
277  16.2          6         163.0        133    3410          15.8   
278  31.5          4          89.0         71    1990          14.9   
279  29.5          4          98.0         68    2135          16.6   
280  21.5          6         231.0        115    3245          15.4   
281  19.8          6         200.0         85    2990          18.2   
282  22.3          4         140.0         88    2890          17.3   
283  20.2          6         232.0         90    3265          18.2   
284  20.6          6         225.0        110    3360          16.6   
285  17.0          8         305.0        130    3840          15.4   
286  17.6          8         302.0        129    3725          13.4   
287  16.5          8         351.0        138    3955          13.2   
288  18.2          8         318.0        135    3830          15.2   
289  16.9          8         350.0        155    4360          14.9   
290  15.5          8         351.0        142    4054          14.3   
291  19.2          8         267.0        125    3605          15.0   
292  18.5          8         360.0        150    3940          13.0   
293  31.9          4          89.0         71    1925          14.0   
294  34.1          4          86.0         65    1975          15.2   
295  35.7          4          98.0         80    1915          14.4   
296  27.4          4         121.0         80    2670          15.0   
297  25.4          5         183.0         77    3530          20.1   
298  23.0          8         350.0        125    3900          17.4   
299  27.2          4         141.0         71    3190          24.8   
300  23.9          8         260.0         90    3420          22.2   
301  34.2          4         105.0         70    2200          13.2   
302  34.5          4         105.0         70    2150          14.9   
303  31.8          4          85.0         65    2020          19.2   
304  37.3          4          91.0         69    2130          14.7   
305  28.4          4         151.0         90    2670          16.0   
306  28.8          6         173.0        115    2595          11.3   
307  26.8          6         173.0        115    2700          12.9   
308  33.5          4         151.0         90    2556          13.2   
309  41.5          4          98.0         76    2144          14.7   
310  38.1          4          89.0         60    1968          18.8   
311  32.1          4          98.0         70    2120          15.5   
312  37.2          4          86.0         65    2019          16.4   
313  28.0          4         151.0         90    2678          16.5   
314  26.4          4         140.0         88    2870          18.1   
315  24.3          4         151.0         90    3003          20.1   
316  19.1          6         225.0         90    3381          18.7   
317  34.3          4          97.0         78    2188          15.8   
318  29.8          4         134.0         90    2711          15.5   
319  31.3          4         120.0         75    2542          17.5   
320  37.0          4         119.0         92    2434          15.0   
321  32.2          4         108.0         75    2265          15.2   
322  46.6          4          86.0         65    2110          17.9   
323  27.9          4         156.0        105    2800          14.4   
324  40.8          4          85.0         65    2110          19.2   
325  44.3          4          90.0         48    2085          21.7   
326  43.4          4          90.0         48    2335          23.7   
327  36.4          5         121.0         67    2950          19.9   
328  30.0          4         146.0         67    3250          21.8   
329  44.6          4          91.0         67    1850          13.8   
330  40.9          4          85.0          ?    1835          17.3   
331  33.8          4          97.0         67    2145          18.0   
332  29.8          4          89.0         62    1845          15.3   
333  32.7          6         168.0        132    2910          11.4   
334  23.7          3          70.0        100    2420          12.5   
335  35.0          4         122.0         88    2500          15.1   
336  23.6          4         140.0          ?    2905          14.3   
337  32.4          4         107.0         72    2290          17.0   
338  27.2          4         135.0         84    2490          15.7   
339  26.6          4         151.0         84    2635          16.4   
340  25.8          4         156.0         92    2620          14.4   
341  23.5          6         173.0        110    2725          12.6   
342  30.0          4         135.0         84    2385          12.9   
343  39.1          4          79.0         58    1755          16.9   
344  39.0          4          86.0         64    1875          16.4   
345  35.1          4          81.0         60    1760          16.1   
346  32.3          4          97.0         67    2065          17.8   
347  37.0          4          85.0         65    1975          19.4   
348  37.7          4          89.0         62    2050          17.3   
349  34.1          4          91.0         68    1985          16.0   
350  34.7          4         105.0         63    2215          14.9   
351  34.4          4          98.0         65    2045          16.2   
352  29.9          4          98.0         65    2380          20.7   
353  33.0          4         105.0         74    2190          14.2   
354  34.5          4         100.0          ?    2320          15.8   
355  33.7          4         107.0         75    2210          14.4   
356  32.4          4         108.0         75    2350          16.8   
357  32.9          4         119.0        100    2615          14.8   
358  31.6          4         120.0         74    2635          18.3   
359  28.1          4         141.0         80    3230          20.4   
360  30.7          6         145.0         76    3160          19.6   
361  25.4          6         168.0        116    2900          12.6   
362  24.2          6         146.0        120    2930          13.8   
363  22.4          6         231.0        110    3415          15.8   
364  26.6          8         350.0        105    3725          19.0   
365  20.2          6         200.0         88    3060          17.1   
366  17.6          6         225.0         85    3465          16.6   
367  28.0          4         112.0         88    2605          19.6   
368  27.0          4         112.0         88    2640          18.6   
369  34.0          4         112.0         88    2395          18.0   
370  31.0          4         112.0         85    2575          16.2   
371  29.0          4         135.0         84    2525          16.0   
372  27.0          4         151.0         90    2735          18.0   
373  24.0          4         140.0         92    2865          16.4   
374  23.0          4         151.0          ?    3035          20.5   
375  36.0          4         105.0         74    1980          15.3   
376  37.0          4          91.0         68    2025          18.2   
377  31.0          4          91.0         68    1970          17.6   
378  38.0          4         105.0         63    2125          14.7   
379  36.0          4          98.0         70    2125          17.3   
380  36.0          4         120.0         88    2160          14.5   
381  36.0          4         107.0         75    2205          14.5   
382  34.0          4         108.0         70    2245          16.9   
383  38.0          4          91.0         67    1965          15.0   
384  32.0          4          91.0         67    1965          15.7   
385  38.0          4          91.0         67    1995          16.2   
386  25.0          6         181.0        110    2945          16.4   
387  38.0          6         262.0         85    3015          17.0   
388  26.0          4         156.0         92    2585          14.5   
389  22.0          6         232.0        112    2835          14.7   
390  32.0          4         144.0         96    2665          13.9   
391  36.0          4         135.0         84    2370          13.0   
392  27.0          4         151.0         90    2950          17.3   
393  27.0          4         140.0         86    2790          15.6   
394  44.0          4          97.0         52    2130          24.6   
395  32.0          4         135.0         84    2295          11.6   
396  28.0          4         120.0         79    2625          18.6   
397  31.0          4         119.0         82    2720          19.4   

     model year  origin                              car name  
0            70       1             chevrolet chevelle malibu  
1            70       1                     buick skylark 320  
2            70       1                    plymouth satellite  
3            70       1                         amc rebel sst  
4            70       1                           ford torino  
5            70       1                      ford galaxie 500  
6            70       1                      chevrolet impala  
7            70       1                     plymouth fury iii  
8            70       1                      pontiac catalina  
9            70       1                    amc ambassador dpl  
10           70       1                   dodge challenger se  
11           70       1                    plymouth 'cuda 340  
12           70       1                 chevrolet monte carlo  
13           70       1               buick estate wagon (sw)  
14           70       3                 toyota corona mark ii  
15           70       1                       plymouth duster  
16           70       1                            amc hornet  
17           70       1                         ford maverick  
18           70       3                          datsun pl510  
19           70       2          volkswagen 1131 deluxe sedan  
20           70       2                           peugeot 504  
21           70       2                           audi 100 ls  
22           70       2                              saab 99e  
23           70       2                              bmw 2002  
24           70       1                           amc gremlin  
25           70       1                             ford f250  
26           70       1                             chevy c20  
27           70       1                            dodge d200  
28           70       1                              hi 1200d  
29           71       3                          datsun pl510  
30           71       1                   chevrolet vega 2300  
31           71       3                         toyota corona  
32           71       1                            ford pinto  
33           71       1                           amc gremlin  
34           71       1             plymouth satellite custom  
35           71       1             chevrolet chevelle malibu  
36           71       1                       ford torino 500  
37           71       1                           amc matador  
38           71       1                      chevrolet impala  
39           71       1             pontiac catalina brougham  
40           71       1                      ford galaxie 500  
41           71       1                     plymouth fury iii  
42           71       1                     dodge monaco (sw)  
43           71       1              ford country squire (sw)  
44           71       1                   pontiac safari (sw)  
45           71       1            amc hornet sportabout (sw)  
46           71       1                   chevrolet vega (sw)  
47           71       1                      pontiac firebird  
48           71       1                          ford mustang  
49           71       1                    mercury capri 2000  
50           71       2                             opel 1900  
51           71       2                           peugeot 304  
52           71       2                             fiat 124b  
53           71       3                   toyota corolla 1200  
54           71       3                           datsun 1200  
55           71       2                  volkswagen model 111  
56           71       1                      plymouth cricket  
57           72       3                 toyota corona hardtop  
58           72       1                    dodge colt hardtop  
59           72       2                     volkswagen type 3  
60           72       1                        chevrolet vega  
61           72       1                   ford pinto runabout  
62           72       1                      chevrolet impala  
63           72       1                      pontiac catalina  
64           72       1                     plymouth fury iii  
65           72       1                      ford galaxie 500  
66           72       1                    amc ambassador sst  
67           72       1                       mercury marquis  
68           72       1                  buick lesabre custom  
69           72       1            oldsmobile delta 88 royale  
70           72       1                chrysler newport royal  
71           72       3                       mazda rx2 coupe  
72           72       1                      amc matador (sw)  
73           72       1      chevrolet chevelle concours (sw)  
74           72       1                 ford gran torino (sw)  
75           72       1        plymouth satellite custom (sw)  
76           72       2                       volvo 145e (sw)  
77           72       2                   volkswagen 411 (sw)  
78           72       2                      peugeot 504 (sw)  
79           72       2                       renault 12 (sw)  
80           72       1                       ford pinto (sw)  
81           72       3                       datsun 510 (sw)  
82           72       3           toyouta corona mark ii (sw)  
83           72       1                       dodge colt (sw)  
84           72       3              toyota corolla 1600 (sw)  
85           73       1                     buick century 350  
86           73       1                           amc matador  
87           73       1                      chevrolet malibu  
88           73       1                      ford gran torino  
89           73       1                  dodge coronet custom  
90           73       1              mercury marquis brougham  
91           73       1             chevrolet caprice classic  
92           73       1                              ford ltd  
93           73       1              plymouth fury gran sedan  
94           73       1          chrysler new yorker brougham  
95           73       1              buick electra 225 custom  
96           73       1               amc ambassador brougham  
97           73       1                      plymouth valiant  
98           73       1                 chevrolet nova custom  
99           73       1                            amc hornet  
100          73       1                         ford maverick  
101          73       1                       plymouth duster  
102          73       2               volkswagen super beetle  
103          73       1                      chevrolet impala  
104          73       1                          ford country  
105          73       1                plymouth custom suburb  
106          73       1              oldsmobile vista cruiser  
107          73       1                           amc gremlin  
108          73       3                         toyota carina  
109          73       1                        chevrolet vega  
110          73       3                            datsun 610  
111          73       3                             maxda rx3  
112          73       1                            ford pinto  
113          73       1                      mercury capri v6  
114          73       2                  fiat 124 sport coupe  
115          73       1               chevrolet monte carlo s  
116          73       1                    pontiac grand prix  
117          73       2                              fiat 128  
118          73       2                            opel manta  
119          73       2                            audi 100ls  
120          73       2                           volvo 144ea  
121          73       1                     dodge dart custom  
122          73       2                             saab 99le  
123          73       3                        toyota mark ii  
124          73       1                      oldsmobile omega  
125          74       1                       plymouth duster  
126          74       1                         ford maverick  
127          74       1                            amc hornet  
128          74       1                        chevrolet nova  
129          74       3                           datsun b210  
130          74       1                            ford pinto  
131          74       3                   toyota corolla 1200  
132          74       1                        chevrolet vega  
133          74       1     chevrolet chevelle malibu classic  
134          74       1                           amc matador  
135          74       1            plymouth satellite sebring  
136          74       1                      ford gran torino  
137          74       1              buick century luxus (sw)  
138          74       1             dodge coronet custom (sw)  
139          74       1                 ford gran torino (sw)  
140          74       1                      amc matador (sw)  
141          74       2                              audi fox  
142          74       2                     volkswagen dasher  
143          74       2                            opel manta  
144          74       3                         toyota corona  
145          74       3                            datsun 710  
146          74       1                            dodge colt  
147          74       2                              fiat 128  
148          74       2                           fiat 124 tc  
149          74       3                           honda civic  
150          74       3                                subaru  
151          74       2                             fiat x1.9  
152          75       1               plymouth valiant custom  
153          75       1                        chevrolet nova  
154          75       1                       mercury monarch  
155          75       1                         ford maverick  
156          75       1                      pontiac catalina  
157          75       1                     chevrolet bel air  
158          75       1                   plymouth grand fury  
159          75       1                              ford ltd  
160          75       1                         buick century  
161          75       1             chevroelt chevelle malibu  
162          75       1                           amc matador  
163          75       1                         plymouth fury  
164          75       1                         buick skyhawk  
165          75       1                   chevrolet monza 2+2  
166          75       1                       ford mustang ii  
167          75       3                        toyota corolla  
168          75       1                            ford pinto  
169          75       1                           amc gremlin  
170          75       1                         pontiac astro  
171          75       3                         toyota corona  
172          75       2                     volkswagen dasher  
173          75       3                            datsun 710  
174          75       1                            ford pinto  
175          75       2                     volkswagen rabbit  
176          75       1                             amc pacer  
177          75       2                            audi 100ls  
178          75       2                           peugeot 504  
179          75       2                           volvo 244dl  
180          75       2                             saab 99le  
181          75       3                      honda civic cvcc  
182          76       2                              fiat 131  
183          76       2                             opel 1900  
184          76       1                              capri ii  
185          76       1                            dodge colt  
186          76       2                          renault 12tl  
187          76       1     chevrolet chevelle malibu classic  
188          76       1                dodge coronet brougham  
189          76       1                           amc matador  
190          76       1                      ford gran torino  
191          76       1                      plymouth valiant  
192          76       1                        chevrolet nova  
193          76       1                         ford maverick  
194          76       1                            amc hornet  
195          76       1                    chevrolet chevette  
196          76       1                       chevrolet woody  
197          76       2                             vw rabbit  
198          76       3                           honda civic  
199          76       1                        dodge aspen se  
200          76       1                     ford granada ghia  
201          76       1                    pontiac ventura sj  
202          76       1                         amc pacer d/l  
203          76       2                     volkswagen rabbit  
204          76       3                          datsun b-210  
205          76       3                        toyota corolla  
206          76       1                            ford pinto  
207          76       2                             volvo 245  
208          76       1            plymouth volare premier v8  
209          76       2                           peugeot 504  
210          76       3                        toyota mark ii  
211          76       2                    mercedes-benz 280s  
212          76       1                      cadillac seville  
213          76       1                             chevy c10  
214          76       1                             ford f108  
215          76       1                            dodge d100  
216          77       3                     honda accord cvcc  
217          77       1               buick opel isuzu deluxe  
218          77       2                         renault 5 gtl  
219          77       1                     plymouth arrow gs  
220          77       3                 datsun f-10 hatchback  
221          77       1             chevrolet caprice classic  
222          77       1            oldsmobile cutlass supreme  
223          77       1                 dodge monaco brougham  
224          77       1               mercury cougar brougham  
225          77       1                    chevrolet concours  
226          77       1                         buick skylark  
227          77       1                plymouth volare custom  
228          77       1                          ford granada  
229          77       1                 pontiac grand prix lj  
230          77       1          chevrolet monte carlo landau  
231          77       1                      chrysler cordoba  
232          77       1                      ford thunderbird  
233          77       2              volkswagen rabbit custom  
234          77       1                 pontiac sunbird coupe  
235          77       3               toyota corolla liftback  
236          77       1                   ford mustang ii 2+2  
237          77       1                    chevrolet chevette  
238          77       1                        dodge colt m/m  
239          77       3                             subaru dl  
240          77       2                     volkswagen dasher  
241          77       3                            datsun 810  
242          77       2                              bmw 320i  
243          77       3                            mazda rx-4  
244          78       2       volkswagen rabbit custom diesel  
245          78       1                           ford fiesta  
246          78       3                      mazda glc deluxe  
247          78       3                        datsun b210 gx  
248          78       3                      honda civic cvcc  
249          78       1     oldsmobile cutlass salon brougham  
250          78       1                        dodge diplomat  
251          78       1                  mercury monarch ghia  
252          78       1                    pontiac phoenix lj  
253          78       1                      chevrolet malibu  
254          78       1                  ford fairmont (auto)  
255          78       1                   ford fairmont (man)  
256          78       1                       plymouth volare  
257          78       1                           amc concord  
258          78       1                 buick century special  
259          78       1                        mercury zephyr  
260          78       1                           dodge aspen  
261          78       1                       amc concord d/l  
262          78       1          chevrolet monte carlo landau  
263          78       1       buick regal sport coupe (turbo)  
264          78       1                           ford futura  
265          78       1                       dodge magnum xe  
266          78       1                    chevrolet chevette  
267          78       3                         toyota corona  
268          78       3                            datsun 510  
269          78       1                            dodge omni  
270          78       3             toyota celica gt liftback  
271          78       1                      plymouth sapporo  
272          78       1                oldsmobile starfire sx  
273          78       3                         datsun 200-sx  
274          78       2                             audi 5000  
275          78       2                           volvo 264gl  
276          78       2                            saab 99gle  
277          78       2                         peugeot 604sl  
278          78       2                   volkswagen scirocco  
279          78       3                       honda accord lx  
280          79       1                     pontiac lemans v6  
281          79       1                      mercury zephyr 6  
282          79       1                       ford fairmont 4  
283          79       1                      amc concord dl 6  
284          79       1                         dodge aspen 6  
285          79       1             chevrolet caprice classic  
286          79       1                       ford ltd landau  
287          79       1                 mercury grand marquis  
288          79       1                       dodge st. regis  
289          79       1               buick estate wagon (sw)  
290          79       1              ford country squire (sw)  
291          79       1         chevrolet malibu classic (sw)  
292          79       1  chrysler lebaron town @ country (sw)  
293          79       2                      vw rabbit custom  
294          79       3                      maxda glc deluxe  
295          79       1           dodge colt hatchback custom  
296          79       1                         amc spirit dl  
297          79       2                    mercedes benz 300d  
298          79       1                     cadillac eldorado  
299          79       2                           peugeot 504  
300          79       1     oldsmobile cutlass salon brougham  
301          79       1                      plymouth horizon  
302          79       1                  plymouth horizon tc3  
303          79       3                            datsun 210  
304          79       2                    fiat strada custom  
305          79       1                 buick skylark limited  
306          79       1                    chevrolet citation  
307          79       1             oldsmobile omega brougham  
308          79       1                       pontiac phoenix  
309          80       2                             vw rabbit  
310          80       3                 toyota corolla tercel  
311          80       1                    chevrolet chevette  
312          80       3                            datsun 310  
313          80       1                    chevrolet citation  
314          80       1                         ford fairmont  
315          80       1                           amc concord  
316          80       1                           dodge aspen  
317          80       2                             audi 4000  
318          80       3                toyota corona liftback  
319          80       3                             mazda 626  
320          80       3                  datsun 510 hatchback  
321          80       3                        toyota corolla  
322          80       3                             mazda glc  
323          80       1                            dodge colt  
324          80       3                            datsun 210  
325          80       2                  vw rabbit c (diesel)  
326          80       2                    vw dasher (diesel)  
327          80       2                   audi 5000s (diesel)  
328          80       2                    mercedes-benz 240d  
329          80       3                   honda civic 1500 gl  
330          80       2                  renault lecar deluxe  
331          80       3                             subaru dl  
332          80       2                      vokswagen rabbit  
333          80       3                         datsun 280-zx  
334          80       3                         mazda rx-7 gs  
335          80       2                     triumph tr7 coupe  
336          80       1                    ford mustang cobra  
337          80       3                          honda accord  
338          81       1                      plymouth reliant  
339          81       1                         buick skylark  
340          81       1                dodge aries wagon (sw)  
341          81       1                    chevrolet citation  
342          81       1                      plymouth reliant  
343          81       3                        toyota starlet  
344          81       1                        plymouth champ  
345          81       3                      honda civic 1300  
346          81       3                                subaru  
347          81       3                        datsun 210 mpg  
348          81       3                         toyota tercel  
349          81       3                           mazda glc 4  
350          81       1                    plymouth horizon 4  
351          81       1                        ford escort 4w  
352          81       1                        ford escort 2h  
353          81       2                      volkswagen jetta  
354          81       2                           renault 18i  
355          81       3                         honda prelude  
356          81       3                        toyota corolla  
357          81       3                          datsun 200sx  
358          81       3                             mazda 626  
359          81       2             peugeot 505s turbo diesel  
360          81       2                          volvo diesel  
361          81       3                       toyota cressida  
362          81       3                     datsun 810 maxima  
363          81       1                         buick century  
364          81       1                 oldsmobile cutlass ls  
365          81       1                       ford granada gl  
366          81       1                chrysler lebaron salon  
367          82       1                    chevrolet cavalier  
368          82       1              chevrolet cavalier wagon  
369          82       1             chevrolet cavalier 2-door  
370          82       1            pontiac j2000 se hatchback  
371          82       1                        dodge aries se  
372          82       1                       pontiac phoenix  
373          82       1                  ford fairmont futura  
374          82       1                        amc concord dl  
375          82       2                   volkswagen rabbit l  
376          82       3                    mazda glc custom l  
377          82       3                      mazda glc custom  
378          82       1                plymouth horizon miser  
379          82       1                        mercury lynx l  
380          82       3                      nissan stanza xe  
381          82       3                          honda accord  
382          82       3                        toyota corolla  
383          82       3                           honda civic  
384          82       3                    honda civic (auto)  
385          82       3                         datsun 310 gx  
386          82       1                 buick century limited  
387          82       1     oldsmobile cutlass ciera (diesel)  
388          82       1            chrysler lebaron medallion  
389          82       1                        ford granada l  
390          82       3                      toyota celica gt  
391          82       1                     dodge charger 2.2  
392          82       1                      chevrolet camaro  
393          82       1                       ford mustang gl  
394          82       2                             vw pickup  
395          82       1                         dodge rampage  
396          82       1                           ford ranger  
397          82       1                            chevy s-10