python数据清洗工具、方法、过程整理归纳（六、数据清洗之数据预处理（一）——重复值处理、缺失值处理）

7 数据预处理

7.1 重复值处理

• 数据清洗一般从重复值和缺失值开始
• 重复值一般采用删除发来处理
• 但有些重复值不能删除，例如订单明细数据或交易明细数据等

import numpy as np

import pandas as pd

import os 

os.chdir(r'D:\code\jupyter\course\代码和数据')

df = pd.read_csv('MotorcycleData.csv', encoding = 'gbk', na_values = 'Na')#把空字符串(Na)读成空值(NaN)

df.head()

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
0 	Used 	mint!!! very low miles 	$11,412 	McHenry, Illinois, United States 	2013.0 	16,000 	Black 	Harley-Davidson 	Unspecified 	Touring 	... 	NaN 	FALSE 	8.1 	NaN 	2427 	Private Seller 	Clear 	True 	FALSE 	28.0
1 	Used 	Perfect condition 	$17,200 	Fort Recovery, Ohio, United States 	2016.0 	60 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	17 	657 	Private Seller 	Clear 	True 	TRUE 	0.0
2 	Used 	NaN 	$3,872 	Chicago, Illinois, United States 	1970.0 	25,763 	Silver/Blue 	BMW 	Vehicle does NOT have an existing warranty 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	136 	NaN 	Clear 	True 	FALSE 	26.0
3 	Used 	CLEAN TITLE READY TO RIDE HOME 	$6,575 	Green Bay, Wisconsin, United States 	2009.0 	33,142 	Red 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	2920 	Dealer 	Clear 	True 	FALSE 	11.0
4 	Used 	NaN 	$10,000 	West Bend, Wisconsin, United States 	2012.0 	17,800 	Blue 	Harley-Davidson 	NO WARRANTY 	Touring 	... 	NaN 	FALSE 	100 	13 	271 	OWNER 	Clear 	True 	TRUE 	0.0

5 rows × 22 columns

df = pd.read_csv('MotorcycleData.csv', encoding = 'gbk', na_values = 'Used')#把(Used)读成空值(NaN)

df.head()

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
0 	NaN 	mint!!! very low miles 	$11,412 	McHenry, Illinois, United States 	2013.0 	16,000 	Black 	Harley-Davidson 	Unspecified 	Touring 	... 	NaN 	FALSE 	8.1 	NaN 	2427 	Private Seller 	Clear 	True 	FALSE 	28.0
1 	NaN 	Perfect condition 	$17,200 	Fort Recovery, Ohio, United States 	2016.0 	60 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	17 	657 	Private Seller 	Clear 	True 	TRUE 	0.0
2 	NaN 	NaN 	$3,872 	Chicago, Illinois, United States 	1970.0 	25,763 	Silver/Blue 	BMW 	Vehicle does NOT have an existing warranty 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	136 	NaN 	Clear 	True 	FALSE 	26.0
3 	NaN 	CLEAN TITLE READY TO RIDE HOME 	$6,575 	Green Bay, Wisconsin, United States 	2009.0 	33,142 	Red 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	2920 	Dealer 	Clear 	True 	FALSE 	11.0
4 	NaN 	NaN 	$10,000 	West Bend, Wisconsin, United States 	2012.0 	17,800 	Blue 	Harley-Davidson 	NO WARRANTY 	Touring 	... 	NaN 	FALSE 	100 	13 	271 	OWNER 	Clear 	True 	TRUE 	0.0

5 rows × 22 columns

def f(x):

    if '$' in str(x):

        x = str(x).strip('$')#删除'$'字符

        x = str(x).replace(',','')#去掉逗号

    else:

        x = str(x).replace(',','')

    return float(x)

df['Price'] = df['Price'].apply(f)

df['Mileage'] = df['Mileage'].apply(f)

df.head()

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
0 	Used 	mint!!! very low miles 	11412.0 	McHenry, Illinois, United States 	2013.0 	16000.0 	Black 	Harley-Davidson 	Unspecified 	Touring 	... 	NaN 	FALSE 	8.1 	NaN 	2427 	Private Seller 	Clear 	True 	FALSE 	28.0
1 	Used 	Perfect condition 	17200.0 	Fort Recovery, Ohio, United States 	2016.0 	60.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	17 	657 	Private Seller 	Clear 	True 	TRUE 	0.0
2 	Used 	NaN 	3872.0 	Chicago, Illinois, United States 	1970.0 	25763.0 	Silver/Blue 	BMW 	Vehicle does NOT have an existing warranty 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	136 	NaN 	Clear 	True 	FALSE 	26.0
3 	Used 	CLEAN TITLE READY TO RIDE HOME 	6575.0 	Green Bay, Wisconsin, United States 	2009.0 	33142.0 	Red 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	2920 	Dealer 	Clear 	True 	FALSE 	11.0
4 	Used 	NaN 	10000.0 	West Bend, Wisconsin, United States 	2012.0 	17800.0 	Blue 	Harley-Davidson 	NO WARRANTY 	Touring 	... 	NaN 	FALSE 	100 	13 	271 	OWNER 	Clear 	True 	TRUE 	0.0

5 rows × 22 columns

df.info()#价格和里程转化成了浮点型

<class 'pandas.core.frame.DataFrame'>
RangeIndex: 7493 entries, 0 to 7492
Data columns (total 22 columns):
Condition         7493 non-null object
Condition_Desc    1656 non-null object
Price             7493 non-null float64
Location          7491 non-null object
Model_Year        7489 non-null float64
Mileage           7467 non-null float64
Exterior_Color    6778 non-null object
Make              7489 non-null object
Warranty          5108 non-null object
Model             7370 non-null object
Sub_Model         2426 non-null object
Type              6011 non-null object
Vehicle_Title     268 non-null object
OBO               7427 non-null object
Feedback_Perc     6611 non-null object
Watch_Count       3517 non-null object
N_Reviews         7487 non-null object
Seller_Status     6868 non-null object
Vehicle_Tile      7439 non-null object
Auction           7476 non-null object
Buy_Now           7256 non-null object
Bid_Count         2190 non-null float64
dtypes: float64(4), object(18)
memory usage: 1.3+ MB

pd.set_option('display.max_rows',100)#最多显示200行

df.duplicated()#对每一行做判断，有没有重复

0       False
1       False
2       False
3       False
4       False
5       False
6       False
7       False
8       False
9       False
10      False
11      False
12      False
13      False
14      False
15      False
16      False
17      False
18      False
19      False
20      False
21      False
22      False
23      False
24      False
25      False
26      False
27      False
28      False
29      False
30      False
31      False
32      False
33      False
34      False
35      False
36      False
37      False
38      False
39      False
40      False
41      False
42      False
43      False
44      False
45      False
46      False
47      False
48      False
49      False
        ...  
7443    False
7444    False
7445    False
7446    False
7447    False
7448    False
7449    False
7450    False
7451    False
7452    False
7453    False
7454    False
7455    False
7456    False
7457    False
7458    False
7459    False
7460    False
7461    False
7462    False
7463    False
7464    False
7465    False
7466    False
7467    False
7468    False
7469    False
7470    False
7471    False
7472    False
7473    False
7474    False
7475    False
7476    False
7477    False
7478    False
7479    False
7480    False
7481    False
7482    False
7483    False
7484    False
7485    False
7486    False
7487    False
7488    False
7489    False
7490    False
7491    False
7492    False
Length: 7493, dtype: bool

any(df.duplicated())#只要里面有一个重复的，就会返回True

True

df[df.duplicated()]#把重复的行展示出来

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
57 	Used 	NaN 	4050.0 	Gilberts, Illinois, United States 	2006.0 	6650.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	NaN 	7< 	58 	Private Seller 	Clear 	True 	TRUE 	3.0
63 	Used 	NaN 	7300.0 	Rolling Meadows, Illinois, United States 	1997.0 	20000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	TRUE 	100 	5< 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
64 	Used 	Dent and scratch free. Paint and chrome in exc... 	5000.0 	South Bend, Indiana, United States 	2003.0 	1350.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	14 	37 	Private Seller 	Clear 	False 	TRUE 	NaN
67 	Used 	NaN 	3250.0 	Valparaiso, Indiana, United States 	2003.0 	22896.0 	Blue/Green Metallic 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	9< 	109 	Private Seller 	Clear 	True 	TRUE 	11.0
103 	Used 	NaN 	10995.0 	Delafield, Wisconsin, United States 	2002.0 	4185.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	91 	Private Seller 	Clear 	False 	TRUE 	NaN
152 	Used 	SLING SHOT SL LIMITED EDITION!! BLACK WITH RED... 	17000.0 	Plainfield, Illinois, United States 	2016.0 	11703.0 	BLACK DIAMOND 	Other Makes 	Vehicle has an existing warranty 	SLINGSHOT 	... 	NaN 	TRUE 	100 	31 	390 	Dealer 	Clear 	False 	TRUE 	NaN
155 	Used 	NaN 	6950.0 	Schenectady, New York, United States 	2006.0 	65100.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	8< 	1028 	Dealer 	Clear 	False 	TRUE 	NaN
156 	Used 	NaN 	19600.0 	Pierre, South Dakota, United States 	2012.0 	25976.0 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	40 	NaN 	Clear 	True 	FALSE 	59.0
157 	Used 	NaN 	49441.0 	Gastonia, North Carolina, United States 	2017.0 	770.0 	SILVER 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	19 	1016 	Dealer 	Clear 	False 	TRUE 	NaN
201 	Used 	NaN 	2247.0 	Shawano, Wisconsin, United States 	1976.0 	13161.0 	Brown 	Kawasaki 	Vehicle does NOT have an existing warranty 	KZ 	... 	NaN 	FALSE 	100 	NaN 	9 	Private Seller 	Clear 	True 	FALSE 	15.0
203 	Used 	Excellent Condition. 	13495.0 	Zieglerville, Pennsylvania, United States 	2015.0 	15466.0 	Vivid Black 	Harley-Davidson 	Unspecified 	Touring 	... 	NaN 	TRUE 	100 	42 	297819 	Dealer 	Clear 	False 	TRUE 	NaN
204 	New 	NaN 	2887.0 	South Haven, Michigan, United States 	2017.0 	1.0 	Green or Gray 	Kawasaki 	Vehicle has an existing warranty 	Z 125 Pro 	... 	NaN 	FALSE 	100 	NaN 	876 	Dealer 	Clear 	True 	FALSE 	0.0
205 	Used 	NaN 	30663.0 	Gastonia, North Carolina, United States 	2016.0 	6988.0 	APPLE RED CANDY 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	7< 	1016 	Dealer 	Clear 	False 	TRUE 	NaN
219 	Used 	NaN 	1691.0 	Lebanon, Pennsylvania, United States 	1975.0 	8603.0 	NaN 	Kawasaki 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	210 	NaN 	Clear 	True 	FALSE 	14.0
227 	Used 	NaN 	7500.0 	Portland, Oregon, United States 	1942.0 	10000.0 	black 	Harley-Davidson 	none 	Other 	... 	NaN 	TRUE 	7.8 	26 	120 	NaN 	Clear 	False 	TRUE 	NaN
232 	Used 	NaN 	12600.0 	Rollinsford, New Hampshire, United States 	1983.0 	30.0 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	343 	NaN 	Clear 	True 	FALSE 	67.0
250 	Used 	Owned by a local collector/enthusiast, this is... 	10900.0 	Saint Louis, Missouri, United States 	2017.0 	275.0 	BLACK DENIM 	Harley-Davidson 	Vehicle has an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	10 	65 	Private Seller 	Clear 	True 	TRUE 	3.0
251 	Used 	NaN 	2000.0 	Canoga Park, California, United States 	2006.0 	90379.0 	BLACK N WHITE 	BMW 	Vehicle has an existing warranty 	R-Series 	... 	NaN 	FALSE 	>96 	NaN 	718 	Dealer 	Clear 	True 	FALSE 	10.0
264 	Used 	NaN 	25927.0 	Gastonia, North Carolina, United States 	2016.0 	3755.0 	BLACK &amp; BLUE 	Harley-Davidson 	Vehicle has an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	14 	1016 	Dealer 	Clear 	False 	TRUE 	NaN
269 	Used 	Only 8,912 miles. Beautiful bike. Mint. Fully ... 	13495.0 	Zieglerville, Pennsylvania, United States 	2007.0 	8912.0 	Canyon Copper/Candy red 	Harley-Davidson 	Vehicle has an existing warranty 	Softail 	... 	NaN 	TRUE 	100 	22 	297819 	Dealer 	Clear 	False 	TRUE 	NaN
270 	Used 	NaN 	401.0 	Osceola, Indiana, United States 	1985.0 	78000.0 	Burgundy 	Honda 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	293 	NaN 	Clear 	True 	FALSE 	23.0
275 	Used 	NaN 	6850.0 	Rosedale, Maryland, United States 	2005.0 	29956.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	9.1 	7< 	218 	Dealer 	Clear 	False 	TRUE 	NaN
279 	Used 	NaN 	12995.0 	Hot Springs National Park, Arkansas, United St... 	2005.0 	4946.0 	Indian Smoke Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	TRUE 	100 	15 	247 	Private Seller 	Clear 	False 	TRUE 	NaN
281 	Used 	NaN 	5700.0 	Des Plaines, Illinois, United States 	1981.0 	100.0 	White 	Honda 	Unspecified 	Other 	... 	NaN 	FALSE 	100 	18 	778 	Private Seller 	Clear 	True 	TRUE 	0.0
300 	Used 	NaN 	34000.0 	Riverside, California, United States 	2013.0 	7530.0 	Yellow 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	37 	Private Seller 	Clear 	True 	FALSE 	0.0
306 	Used 	NaN 	9900.0 	Bartlett, Illinois, United States 	2007.0 	26500.0 	Metallic black 	Honda 	Vehicle does NOT have an existing warranty 	Gold Wing 	... 	NaN 	TRUE 	100 	11 	2 	Private Seller 	Clear 	False 	TRUE 	NaN
350 	Used 	Very clean, showroom condition 	22500.0 	Tampa, Florida, United States 	2008.0 	19998.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	31 	1 	Dealer 	Clear 	False 	TRUE 	NaN
351 	Used 	NaN 	29900.0 	Mahwah, New Jersey, United States 	2016.0 	703.0 	Atomic Red with Candy Apple Red Flames 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	NaN 	11 	4 	Private Seller 	Clear 	False 	TRUE 	NaN
353 	Used 	NaN 	29883.0 	Gastonia, North Carolina, United States 	2016.0 	1835.0 	ORANGE 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	6< 	1016 	Dealer 	Clear 	False 	TRUE 	NaN
355 	Used 	NaN 	2650.0 	Punta Gorda, Florida, United States 	2005.0 	99546.0 	Black 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	22 	Dealer 	Clear 	True 	FALSE 	6.0
... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	...
7154 	New 	NaN 	15199.0 	Suncook, New Hampshire, United States 	2015.0 	0.0 	MATT GRAPHITE 	Triumph 	NaN 	Thunderbird 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7163 	New 	NaN 	10400.0 	Suncook, New Hampshire, United States 	2017.0 	0.0 	JET BLACK 	Triumph 	NaN 	Bonneville 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7164 	New 	NaN 	10999.0 	Suncook, New Hampshire, United States 	2016.0 	0.0 	PURE WHITE 	Triumph 	NaN 	THRUXTON 	... 	NaN 	FALSE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7165 	New 	NaN 	10499.0 	Suncook, New Hampshire, United States 	2017.0 	0.0 	LAVA RED 	Triumph 	NaN 	Thunderbird 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7167 	New 	NaN 	9250.0 	Suncook, New Hampshire, United States 	2018.0 	0.0 	CRYSTAL WHITE 	Triumph 	NaN 	STREET TWIN W/ABS 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7176 	New 	NaN 	13250.0 	Suncook, New Hampshire, United States 	2017.0 	0.0 	COMPETITION GREEN W/GOLD TANK STRIPE 	Triumph 	NaN 	THRUXTON 	... 	NaN 	FALSE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7178 	New 	NaN 	10499.0 	Suncook, New Hampshire, United States 	2017.0 	0.0 	JET BLACK 	Triumph 	NaN 	Thunderbird 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7200 	New 	NaN 	9250.0 	Suncook, New Hampshire, United States 	2018.0 	0.0 	MATTE BLACK 	Triumph 	NaN 	STREET TWIN W/ABS 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7201 	Used 	NaN 	6891.0 	McKinney, Texas, United States 	2011.0 	7288.0 	Silver 	Yamaha 	Unspecified 	FZ 	... 	NaN 	TRUE 	>50 	NaN 	397 	Dealer 	Clear 	False 	FALSE 	NaN
7211 	New 	NaN 	19840.0 	Plano, Texas, United States 	2017.0 	0.0 	White 	BMW 	Unspecified 	S 1000 RR Premium Race LightWhite/LupinBlueMet... 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7238 	New 	NaN 	10500.0 	Suncook, New Hampshire, United States 	2017.0 	0.0 	JET BLACK/SILVER ICE 	Triumph 	NaN 	Street Cup 	... 	NaN 	FALSE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7240 	New 	NaN 	10500.0 	Suncook, New Hampshire, United States 	2017.0 	0.0 	RACING YELLOW/SILVER ICE 	Triumph 	NaN 	Street Cup 	... 	NaN 	FALSE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7250 	New 	NaN 	10550.0 	Plano, Texas, United States 	2017.0 	0.0 	Black 	Triumph 	Unspecified 	Bonneville T100 Black Matte Black 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7251 	New 	NaN 	10800.0 	Plano, Texas, United States 	2017.0 	0.0 	White 	Triumph 	Unspecified 	Bonneville T100 Fusion White/Aegean Blue 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7255 	New 	NaN 	14995.0 	Plano, Texas, United States 	2016.0 	7.0 	Red 	Ducati 	Unspecified 	Multistrada 1200 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7259 	New 	NaN 	23495.0 	Plano, Texas, United States 	2017.0 	0.0 	Gray 	Ducati 	Unspecified 	Multistrada 1200 Enduro Phantom Grey 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7260 	New 	NaN 	10550.0 	Plano, Texas, United States 	2017.0 	0.0 	Black 	Triumph 	Unspecified 	Bonneville T100 Black Matte Black 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7272 	New 	NaN 	9999.0 	Plano, Texas, United States 	2016.0 	7.0 	Yellow 	Ducati 	Unspecified 	Scrambler Flat Track Pro 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7273 	New 	NaN 	10800.0 	Plano, Texas, United States 	2017.0 	0.0 	White 	Triumph 	Unspecified 	Bonneville T100 Fusion White/Aegean Blue 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7288 	New 	NaN 	9250.0 	Plano, Texas, United States 	2017.0 	7.0 	Red 	Triumph 	Unspecified 	Street Twin Matte Jet Black 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7293 	New 	NaN 	25134.0 	Goldsboro, North Carolina, United States 	2017.0 	0.0 	Gray 	Can-Am 	Unspecified 	Spyder RT-S 	... 	NaN 	TRUE 	100 	NaN 	60 	Dealer 	Clear 	False 	FALSE 	NaN
7300 	New 	NaN 	20700.0 	Plano, Texas, United States 	2017.0 	7.0 	White 	Triumph 	Unspecified 	Tiger Explorer XCX Crystal燱hite 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7315 	New 	NaN 	10800.0 	Plano, Texas, United States 	2017.0 	0.0 	White 	Triumph 	Unspecified 	Bonneville T100 Fusion White/Aegean Blue 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7317 	New 	NaN 	27327.0 	Goldsboro, North Carolina, United States 	2017.0 	0.0 	Blue 	Can-Am 	Unspecified 	Spyder RT Limited 	... 	NaN 	TRUE 	100 	NaN 	60 	Dealer 	Clear 	False 	FALSE 	NaN
7318 	New 	NaN 	13795.0 	Plano, Texas, United States 	2016.0 	7.0 	Red 	Ducati 	Unspecified 	Monster 1200 S Red 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7319 	New 	NaN 	11695.0 	Plano, Texas, United States 	2017.0 	7.0 	Red 	Ducati 	Unspecified 	Monster 821 Red 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7384 	New 	NaN 	26999.0 	Greensboro, North Carolina, United States 	2017.0 	3.0 	Black 	Indian 	Unspecified 	Roadmaster? 	... 	TRUE 	100 	NaN 	312 	Dealer 	Clear 	FALSE 	False 	NaN 	NaN
7389 	New 	NaN 	18999.0 	Greensboro, North Carolina, United States 	2017.0 	3.0 	Green 	Indian 	Unspecified 	Chief?Vintage 	... 	NaN 	TRUE 	100 	NaN 	312 	Dealer 	Clear 	False 	FALSE 	NaN
7402 	Used 	NaN 	5200.0 	Raymond, New Hampshire, United States 	2013.0 	5307.0 	Black 	Suzuki 	NaN 	GSX-R750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7403 	Used 	Please feel free to contact me if you have any... 	4900.0 	Raymond, New Hampshire, United States 	2006.0 	22931.0 	Gray 	Suzuki 	NaN 	GSX-R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN

1221 rows × 22 columns

df[df['Price'] == 4050.0]

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
49 	Used 	NaN 	4050.0 	Gilberts, Illinois, United States 	2006.0 	6650.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	NaN 	7< 	58 	Private Seller 	Clear 	True 	TRUE 	3.0
57 	Used 	NaN 	4050.0 	Gilberts, Illinois, United States 	2006.0 	6650.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	NaN 	7< 	58 	Private Seller 	Clear 	True 	TRUE 	3.0
747 	Used 	NaN 	4050.0 	Coventry, Rhode Island, United States 	2005.0 	17800.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	5< 	198 	Private Seller 	Clear 	True 	TRUE 	7.0
829 	Used 	NaN 	4050.0 	Coventry, Rhode Island, United States 	2005.0 	17800.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	5< 	198 	Private Seller 	Clear 	True 	TRUE 	7.0
914 	Used 	NaN 	4050.0 	Scott City, Missouri, United States 	2013.0 	3591.0 	Blue 	Harley-Davidson 	Vehicle has an existing warranty 	Softail Slim 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	True 	FALSE 	29.0
982 	Used 	NaN 	4050.0 	San Diego, California, United States 	2001.0 	15134.0 	Orange 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	46 	NaN 	Clear 	True 	FALSE 	13.0
1989 	Used 	NaN 	4050.0 	New Hampton, Iowa, United States 	1950.0 	2.0 	Black 	Other Makes 	Vehicle does NOT have an existing warranty 	AJS 500 18 Single 	... 	NaN 	FALSE 	100 	NaN 	570 	NaN 	Clear 	True 	FALSE 	2.0
2070 	Used 	NaN 	4050.0 	New Hampton, Iowa, United States 	1950.0 	2.0 	Black 	Other Makes 	Vehicle does NOT have an existing warranty 	AJS 500 18 Single 	... 	NaN 	FALSE 	100 	NaN 	570 	NaN 	Clear 	True 	FALSE 	2.0
2249 	Used 	NaN 	4050.0 	Pinellas Park, Florida, United States 	2005.0 	33797.0 	Black 	Harley-Davidson 	No Warranty 	Touring 	... 	NaN 	FALSE 	9.5 	NaN 	767 	Dealer 	Clear 	True 	FALSE 	29.0
2313 	Used 	NaN 	4050.0 	Pinellas Park, Florida, United States 	2005.0 	33797.0 	Black 	Harley-Davidson 	No Warranty 	Touring 	... 	NaN 	FALSE 	9.5 	NaN 	767 	Dealer 	Clear 	True 	FALSE 	29.0
3116 	Used 	NaN 	4050.0 	Elmhurst, Illinois, United States 	2001.0 	45500.0 	Burgundy 	Honda 	Vehicle does NOT have an existing warranty 	Goldwing 	... 	NaN 	FALSE 	NaN 	19 	0 	Private Seller 	Clear 	True 	TRUE 	7.0
3787 	New 	NaN 	4050.0 	Boston, Massachusetts, United States 	2011.0 	13000.0 	Black 	Ducati 	Vehicle does NOT have an existing warranty 	Superbike 	... 	NaN 	FALSE 	1.7 	11 	52 	Private Seller 	Clear 	True 	TRUE 	23.0
3852 	New 	NaN 	4050.0 	Boston, Massachusetts, United States 	2011.0 	13000.0 	Black 	Ducati 	Vehicle does NOT have an existing warranty 	Superbike 	... 	NaN 	FALSE 	1.7 	11 	52 	Private Seller 	Clear 	True 	TRUE 	23.0
4224 	Used 	NaN 	4050.0 	Suncook, New Hampshire, United States 	2001.0 	22523.0 	Orange 	Harley-Davidson 	NaN 	FLSTF FAT BOY 	... 	NaN 	FALSE 	100 	NaN 	1978 	Dealer 	Clear 	True 	FALSE 	10.0
4344 	Used 	NaN 	4050.0 	Suncook, New Hampshire, United States 	2007.0 	42706.0 	GREEN/BLACK 	Harley-Davidson 	NaN 	FLHRC ROAD KING CLASSIC 	... 	NaN 	FALSE 	100 	NaN 	1978 	Dealer 	Clear 	True 	FALSE 	11.0
4386 	Used 	NaN 	4050.0 	Suncook, New Hampshire, United States 	2007.0 	42706.0 	GREEN/BLACK 	Harley-Davidson 	NaN 	FLHRC ROAD KING CLASSIC 	... 	NaN 	FALSE 	100 	NaN 	1978 	Dealer 	Clear 	True 	FALSE 	11.0

16 rows × 22 columns

np.sum(df.duplicated())

1221

df.drop_duplicates()#数据去重，返回去重后的视图，原始数据没有被改变

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
0 	Used 	mint!!! very low miles 	11412.0 	McHenry, Illinois, United States 	2013.0 	16000.0 	Black 	Harley-Davidson 	Unspecified 	Touring 	... 	NaN 	FALSE 	8.1 	NaN 	2427 	Private Seller 	Clear 	True 	FALSE 	28.0
1 	Used 	Perfect condition 	17200.0 	Fort Recovery, Ohio, United States 	2016.0 	60.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	17 	657 	Private Seller 	Clear 	True 	TRUE 	0.0
2 	Used 	NaN 	3872.0 	Chicago, Illinois, United States 	1970.0 	25763.0 	Silver/Blue 	BMW 	Vehicle does NOT have an existing warranty 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	136 	NaN 	Clear 	True 	FALSE 	26.0
3 	Used 	CLEAN TITLE READY TO RIDE HOME 	6575.0 	Green Bay, Wisconsin, United States 	2009.0 	33142.0 	Red 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	2920 	Dealer 	Clear 	True 	FALSE 	11.0
4 	Used 	NaN 	10000.0 	West Bend, Wisconsin, United States 	2012.0 	17800.0 	Blue 	Harley-Davidson 	NO WARRANTY 	Touring 	... 	NaN 	FALSE 	100 	13 	271 	OWNER 	Clear 	True 	TRUE 	0.0
5 	Used 	It&#039;s a &#039;72 in good shape 	1500.0 	Watervliet, Michigan, United States 	1972.0 	0.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	NaN 	412 	Private Seller 	Clear 	True 	FALSE 	1.0
6 	Used 	NaN 	24900.0 	Sterling, Illinois, United States 	2010.0 	5548.0 	Grey / Red / Silver Metallic 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	9.8 	NaN 	6229 	Dealer 	Clear 	True 	FALSE 	1.0
7 	Used 	NaN 	1400.0 	Williamston, Michigan, United States 	1975.0 	17868.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	9.7 	NaN 	1159 	Private Seller 	Clear 	True 	FALSE 	6.0
8 	Used 	NaN 	5100.0 	Palatine, Illinois, United States 	2014.0 	2800.0 	Cherry Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	NaN 	16 	3 	Private Seller 	Clear 	True 	TRUE 	6.0
9 	Used 	NaN 	8000.0 	Chicago, Illinois, United States 	2015.0 	3000.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Sportster 	... 	NaN 	FALSE 	NaN 	NaN 	1 	Private Seller 	Clear 	True 	FALSE 	0.0
10 	Used 	NaN 	2125.0 	Williamston, Michigan, United States 	1978.0 	30.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.7 	NaN 	1159 	Private Seller 	Clear 	True 	FALSE 	4.0
11 	Used 	NaN 	11100.0 	Oak Park, Illinois, United States 	2011.0 	5800.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	83 	Private Seller 	Clear 	True 	FALSE 	21.0
12 	Used 	NaN 	1125.0 	Pewaukee, Wisconsin, United States 	2002.0 	55000.0 	RICH RED W/STRIPES 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	128 	Private Seller 	Clear 	True 	FALSE 	5.0
13 	Used 	Overall, this bike is in good condition for it... 	3550.0 	Madison, Wisconsin, United States 	2000.0 	57898.0 	Luxury Rich Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	NaN 	FALSE 	100 	NaN 	10701 	Dealer 	Clear 	True 	FALSE 	2.0
14 	Used 	NaN 	5500.0 	Davenport, Iowa, United States 	2008.0 	22102.0 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.3 	NaN 	244 	Private Seller 	Clear 	True 	FALSE 	16.0
15 	Used 	NaN 	9000.0 	Plymouth, Indiana, United States 	2010.0 	7792.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	299 	Private Seller 	Clear 	True 	FALSE 	3.0
16 	Used 	NaN 	8100.0 	Goshen, Indiana, United States 	1973.0 	9305.0 	White 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	300 	Private Seller 	Clear 	True 	FALSE 	25.0
17 	Used 	Absolutely perfect condition 	14000.0 	Plainfield, Indiana, United States 	2016.0 	1125.0 	Blue 	Harley-Davidson 	Vehicle has an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	170 	Private Seller 	Clear 	True 	FALSE 	0.0
18 	Used 	NaN 	20000.0 	Bellevue, Iowa, United States 	2015.0 	5500.0 	Red 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	8< 	66 	Private Seller 	Clear 	False 	TRUE 	NaN
19 	New 	NaN 	13000.0 	Des Plaines, Illinois, United States 	2016.0 	250.0 	Black 	Harley-Davidson 	Unspecified 	Softail 	... 	NaN 	FALSE 	100 	23 	181 	Private Seller 	Clear 	True 	TRUE 	0.0
20 	New 	NaN 	10900.0 	Ottawa, Illinois, United States 	2017.0 	140.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	NaN 	3172 	Private Seller 	Clear 	False 	TRUE 	NaN
21 	Used 	IN AWESOME CONDITION. SUPER RARE. JUST SERVIC... 	9999.0 	Orland Park, Illinois, United States 	2005.0 	25405.0 	Black 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	283 	Dealer 	Clear 	True 	FALSE 	0.0
22 	Used 	NaN 	5700.0 	Cross Plains, Wisconsin, United States 	1982.0 	28888.0 	Black &amp; Blue 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	947 	Private Seller 	Clear 	True 	FALSE 	0.0
23 	Used 	NaN 	7400.0 	Watervliet, Michigan, United States 	2001.0 	23658.0 	Purple 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	412 	Private Seller 	Clear 	True 	FALSE 	0.0
24 	Used 	NaN 	26500.0 	Kewanee, Illinois, United States 	2016.0 	13089.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	15 	6 	Private Seller 	Clear 	False 	TRUE 	NaN
25 	Used 	NaN 	9850.0 	Chicago, Illinois, United States 	2003.0 	23546.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	12 	Private Seller 	Clear 	True 	FALSE 	0.0
26 	Used 	NaN 	45900.0 	South Haven, Michigan, United States 	2009.0 	40000.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	25 	199 	Private Seller 	Clear 	False 	TRUE 	NaN
27 	Used 	Almost new 2009 Harley-Davidson FLHR Road Ki... 	10600.0 	Wheeling, Illinois, United States 	2009.0 	3769.0 	Red Hot Sun Glo 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	22 	175 	Private Seller 	Clear 	False 	TRUE 	NaN
28 	Used 	*2008 Harley Davidson Rocker C *Chrome Chrome ... 	12000.0 	Chicago, Illinois, United States 	2008.0 	8700.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	11 	Private Seller 	Clear 	True 	FALSE 	0.0
29 	Used 	NaN 	20000.0 	Chicago, Illinois, United States 	2011.0 	16827.0 	Black 	Harley-Davidson 	NaN 	TRIKE 	... 	NaN 	TRUE 	NaN 	31 	17 	Private Seller 	Clear 	False 	TRUE 	NaN
30 	Used 	Very clean and well maintained 	25000.0 	Summit-Argo, Illinois, United States 	2010.0 	15000.0 	Kandy brandywine 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	1< 	18 	Private Seller 	Clear 	True 	TRUE 	0.0
31 	Used 	NaN 	20000.0 	Coldwater, Michigan, United States 	2014.0 	2900.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	142 	Private Seller 	Clear 	True 	FALSE 	0.0
32 	Used 	NaN 	11000.0 	Elkhart, Indiana, United States 	2007.0 	15200.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	NaN 	12 	28 	Private Seller 	Clear 	False 	TRUE 	NaN
33 	Used 	NaN 	8500.0 	Glenview NAS, Illinois, United States 	2008.0 	10319.0 	Black 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	8< 	324 	Private Seller 	Clear 	False 	TRUE 	NaN
34 	Used 	NaN 	18000.0 	Fox River Grove, Illinois, United States 	2010.0 	29544.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	NaN 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
35 	Used 	NaN 	7700.0 	Roselle, Illinois, United States 	2007.0 	10893.0 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	236 	NaN 	Clear 	False 	TRUE 	NaN
36 	Used 	NaN 	2750.0 	Belvidere, Illinois, United States 	2007.0 	35735.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	FLH 	... 	NaN 	FALSE 	100 	NaN 	100 	Belvidere Police Department 	Clear 	True 	FALSE 	19.0
37 	Used 	Year2005 ManufacturerHarley-Davidson ModelScre... 	10895.0 	Kalamazoo, Michigan, United States 	2005.0 	9908.0 	Red 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	1522 	Private Seller 	Clear 	True 	FALSE 	0.0
38 	Used 	No Reserve! 	6700.0 	Tinley Park, Illinois, United States 	2004.0 	8950.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	126 	Private Seller 	Clear 	True 	FALSE 	0.0
39 	Used 	NaN 	18000.0 	Batavia, Illinois, United States 	2015.0 	5600.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	63 	Private Seller 	Clear 	True 	FALSE 	0.0
40 	Used 	NaN 	7300.0 	Rolling Meadows, Illinois, United States 	1997.0 	20000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	TRUE 	100 	5< 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
41 	Used 	NaN 	6800.0 	Hampshire, Illinois, United States 	2003.0 	55782.0 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	TRUE 	100 	2< 	298 	Private Seller 	Clear 	False 	TRUE 	NaN
42 	Used 	Dent and scratch free. Paint and chrome in exc... 	5000.0 	South Bend, Indiana, United States 	2003.0 	1350.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	14 	37 	Private Seller 	Clear 	False 	TRUE 	NaN
43 	Used 	Excellent condition gently used. Adult driven 	13200.0 	Algonquin, Illinois, United States 	2011.0 	15400.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	478 	Private Seller 	Clear 	True 	FALSE 	0.0
44 	Used 	Excellent condition 	11400.0 	Indianapolis, Indiana, United States 	2012.0 	1533.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	4< 	79 	Dealer 	Clear 	False 	TRUE 	NaN
45 	Used 	NaN 	3250.0 	Valparaiso, Indiana, United States 	2003.0 	22896.0 	Blue/Green Metallic 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	9< 	109 	Private Seller 	Clear 	True 	TRUE 	11.0
46 	Used 	This is a nice looking Road King. Paint and ch... 	8000.0 	Madison, Wisconsin, United States 	2012.0 	24742.0 	Vivid Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	NaN 	FALSE 	100 	NaN 	10701 	Dealer 	Clear 	True 	FALSE 	0.0
47 	Used 	NaN 	17800.0 	Webberville, Michigan, United States 	2016.0 	1500.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	4< 	33 	Private Seller 	Clear 	False 	TRUE 	NaN
48 	Used 	NaN 	8500.0 	Rockford, Illinois, United States 	2003.0 	51000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	8< 	124 	Private Seller 	Clear 	False 	TRUE 	NaN
49 	Used 	NaN 	4050.0 	Gilberts, Illinois, United States 	2006.0 	6650.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	NaN 	7< 	58 	Private Seller 	Clear 	True 	TRUE 	3.0
... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	...
7443 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2012.0 	0.0 	Black 	Harley-Davidson 	NaN 	FXDBI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7444 	Used 	NaN 	5900.0 	Raymond, New Hampshire, United States 	2013.0 	7337.0 	Gray 	Yamaha 	NaN 	YZF-R6 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7445 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2016.0 	2669.0 	Red 	Harley-Davidson 	NaN 	XG750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7446 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2016.0 	23440.0 	Gray 	Kawasaki 	NaN 	Z1000 G 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7447 	Used 	NaN 	23499.0 	Suncook, New Hampshire, United States 	2015.0 	16927.0 	Black 	Harley-Davidson 	NaN 	FLHTK ELECTRA GLIDE ULTRA LIMITED 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7448 	Used 	Please feel free to contact me if you have any... 	6500.0 	Raymond, New Hampshire, United States 	2007.0 	29541.0 	Burgundy 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7449 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2008.0 	11388.0 	Black 	Harley-Davidson 	NaN 	FXDF 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7450 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2006.0 	28117.0 	Black 	Kawasaki 	NaN 	ZX-10R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7451 	Used 	NaN 	5200.0 	Raymond, New Hampshire, United States 	2006.0 	12876.0 	maroon 	Suzuki 	NaN 	GSX1300R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7452 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2003.0 	66219.0 	Blue 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7453 	Used 	Please feel free to contact me if you have any... 	8300.0 	Raymond, New Hampshire, United States 	2011.0 	5468.0 	TWO TONE 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7454 	Used 	NaN 	7400.0 	Raymond, New Hampshire, United States 	2013.0 	12333.0 	Red 	Harley-Davidson 	NaN 	FLD103 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7455 	Used 	NaN 	4700.0 	Raymond, New Hampshire, United States 	2015.0 	424.0 	Black 	Suzuki 	NaN 	GSX-S750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7456 	Used 	NaN 	4900.0 	Raymond, New Hampshire, United States 	2009.0 	7552.0 	Orange 	Yamaha 	NaN 	YZF-R6 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7457 	Used 	NaN 	8500.0 	Raymond, New Hampshire, United States 	2008.0 	20060.0 	Black 	Harley-Davidson 	NaN 	FXCW 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7458 	Used 	NaN 	9200.0 	Raymond, New Hampshire, United States 	2012.0 	0.0 	Blue 	Harley-Davidson 	NaN 	FLTRX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7459 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	19268.0 	Black 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7460 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2014.0 	703.0 	Black 	Suzuki 	NaN 	GSX-R1000 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7461 	Used 	NaN 	4200.0 	Raymond, New Hampshire, United States 	2008.0 	5883.0 	Gray 	Yamaha 	NaN 	XV1700 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7462 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2006.0 	32267.0 	Blue 	Harley-Davidson 	NaN 	FLSTFI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7463 	Used 	NaN 	7800.0 	Raymond, New Hampshire, United States 	2008.0 	45135.0 	Orange 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7464 	Used 	NaN 	4400.0 	Raymond, New Hampshire, United States 	2015.0 	2059.0 	Black 	Suzuki 	NaN 	GSX-S750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7465 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2012.0 	11679.0 	Black 	Harley-Davidson 	NaN 	FXDCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7466 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2016.0 	1389.0 	Blue 	Suzuki 	NaN 	GSX-R600 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7467 	Used 	Salvage Rebuildable Repairable No Reserve NR 	7400.0 	Raymond, New Hampshire, United States 	2008.0 	41618.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7468 	Used 	NaN 	8800.0 	Raymond, New Hampshire, United States 	2008.0 	52418.0 	White 	Harley-Davidson 	NaN 	FLHXI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7469 	Used 	NaN 	13570.0 	Scott City, Missouri, United States 	2016.0 	2019.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Dyna Fat Bob 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN
7470 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2007.0 	64724.0 	White 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7471 	Used 	NaN 	6200.0 	Raymond, New Hampshire, United States 	2005.0 	55993.0 	Red 	Harley-Davidson 	NaN 	FLHTCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7472 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2005.0 	32560.0 	TWO TONE 	Harley-Davidson 	NaN 	FLSTNI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7473 	Used 	NaN 	5500.0 	Raymond, New Hampshire, United States 	2000.0 	87123.0 	White 	Harley-Davidson 	NaN 	FLSTC 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7474 	Used 	NaN 	3400.0 	Raymond, New Hampshire, United States 	2006.0 	23865.0 	Blue 	Harley-Davidson 	NaN 	XL 883C 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7475 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	56633.0 	Blue 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7476 	Used 	NaN 	8500.0 	Raymond, New Hampshire, United States 	2010.0 	36780.0 	Blue 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7477 	Used 	NaN 	4900.0 	Raymond, New Hampshire, United States 	2002.0 	22709.0 	Black 	Harley-Davidson 	NaN 	FXDL 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7478 	Used 	NaN 	9900.0 	Raymond, New Hampshire, United States 	2011.0 	20851.0 	Brown 	Harley-Davidson 	NaN 	FLTRU 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7479 	Used 	NaN 	2900.0 	Raymond, New Hampshire, United States 	2013.0 	2905.0 	Black 	Suzuki 	NaN 	SV 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7480 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2016.0 	1701.0 	Green 	Harley-Davidson 	NaN 	XL 883N 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7481 	Used 	NaN 	10500.0 	Raymond, New Hampshire, United States 	2013.0 	16231.0 	Black 	Harley-Davidson 	NaN 	FLTRX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7482 	Used 	NaN 	7200.0 	Raymond, New Hampshire, United States 	2006.0 	29201.0 	Black 	Harley-Davidson 	NaN 	FLTRI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7483 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2007.0 	28716.0 	Purple 	Harley-Davidson 	NaN 	FLHRCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7484 	Used 	NaN 	5000.0 	Raymond, New Hampshire, United States 	2004.0 	12583.0 	NaN 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7485 	Used 	NaN 	5000.0 	Raymond, New Hampshire, United States 	2006.0 	19931.0 	Black 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7486 	Used 	NaN 	8900.0 	Raymond, New Hampshire, United States 	2012.0 	9305.0 	Black 	Harley-Davidson 	NaN 	FXDWG 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7487 	Used 	Please feel free to contact me if you have any... 	4900.0 	Raymond, New Hampshire, United States 	2013.0 	3475.0 	Gray 	Suzuki 	NaN 	Boulevard 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7488 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	23681.0 	Black 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7489 	Used 	NaN 	8900.0 	Raymond, New Hampshire, United States 	2013.0 	5821.0 	Black 	Suzuki 	NaN 	GSX1300RA 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7490 	Used 	NaN 	7800.0 	Raymond, New Hampshire, United States 	2011.0 	48616.0 	Red 	BMW 	NaN 	R1200GS 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7491 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2014.0 	6185.0 	TWO TONE 	Yamaha 	NaN 	YZF-R1 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7492 	Used 	NaN 	12970.0 	Scott City, Missouri, United States 	2016.0 	448.0 	Gray 	Harley-Davidson 	Vehicle has an existing warranty 	Dyna Street Bob 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN

6272 rows × 22 columns

df.drop_duplicates(inplace = True)

df

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
0 	Used 	mint!!! very low miles 	11412.0 	McHenry, Illinois, United States 	2013.0 	16000.0 	Black 	Harley-Davidson 	Unspecified 	Touring 	... 	NaN 	FALSE 	8.1 	NaN 	2427 	Private Seller 	Clear 	True 	FALSE 	28.0
1 	Used 	Perfect condition 	17200.0 	Fort Recovery, Ohio, United States 	2016.0 	60.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	17 	657 	Private Seller 	Clear 	True 	TRUE 	0.0
2 	Used 	NaN 	3872.0 	Chicago, Illinois, United States 	1970.0 	25763.0 	Silver/Blue 	BMW 	Vehicle does NOT have an existing warranty 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	136 	NaN 	Clear 	True 	FALSE 	26.0
3 	Used 	CLEAN TITLE READY TO RIDE HOME 	6575.0 	Green Bay, Wisconsin, United States 	2009.0 	33142.0 	Red 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	2920 	Dealer 	Clear 	True 	FALSE 	11.0
4 	Used 	NaN 	10000.0 	West Bend, Wisconsin, United States 	2012.0 	17800.0 	Blue 	Harley-Davidson 	NO WARRANTY 	Touring 	... 	NaN 	FALSE 	100 	13 	271 	OWNER 	Clear 	True 	TRUE 	0.0
5 	Used 	It&#039;s a &#039;72 in good shape 	1500.0 	Watervliet, Michigan, United States 	1972.0 	0.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	NaN 	412 	Private Seller 	Clear 	True 	FALSE 	1.0
6 	Used 	NaN 	24900.0 	Sterling, Illinois, United States 	2010.0 	5548.0 	Grey / Red / Silver Metallic 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	9.8 	NaN 	6229 	Dealer 	Clear 	True 	FALSE 	1.0
7 	Used 	NaN 	1400.0 	Williamston, Michigan, United States 	1975.0 	17868.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	9.7 	NaN 	1159 	Private Seller 	Clear 	True 	FALSE 	6.0
8 	Used 	NaN 	5100.0 	Palatine, Illinois, United States 	2014.0 	2800.0 	Cherry Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	NaN 	16 	3 	Private Seller 	Clear 	True 	TRUE 	6.0
9 	Used 	NaN 	8000.0 	Chicago, Illinois, United States 	2015.0 	3000.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Sportster 	... 	NaN 	FALSE 	NaN 	NaN 	1 	Private Seller 	Clear 	True 	FALSE 	0.0
10 	Used 	NaN 	2125.0 	Williamston, Michigan, United States 	1978.0 	30.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.7 	NaN 	1159 	Private Seller 	Clear 	True 	FALSE 	4.0
11 	Used 	NaN 	11100.0 	Oak Park, Illinois, United States 	2011.0 	5800.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	83 	Private Seller 	Clear 	True 	FALSE 	21.0
12 	Used 	NaN 	1125.0 	Pewaukee, Wisconsin, United States 	2002.0 	55000.0 	RICH RED W/STRIPES 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	128 	Private Seller 	Clear 	True 	FALSE 	5.0
13 	Used 	Overall, this bike is in good condition for it... 	3550.0 	Madison, Wisconsin, United States 	2000.0 	57898.0 	Luxury Rich Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	NaN 	FALSE 	100 	NaN 	10701 	Dealer 	Clear 	True 	FALSE 	2.0
14 	Used 	NaN 	5500.0 	Davenport, Iowa, United States 	2008.0 	22102.0 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.3 	NaN 	244 	Private Seller 	Clear 	True 	FALSE 	16.0
15 	Used 	NaN 	9000.0 	Plymouth, Indiana, United States 	2010.0 	7792.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	299 	Private Seller 	Clear 	True 	FALSE 	3.0
16 	Used 	NaN 	8100.0 	Goshen, Indiana, United States 	1973.0 	9305.0 	White 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	300 	Private Seller 	Clear 	True 	FALSE 	25.0
17 	Used 	Absolutely perfect condition 	14000.0 	Plainfield, Indiana, United States 	2016.0 	1125.0 	Blue 	Harley-Davidson 	Vehicle has an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	170 	Private Seller 	Clear 	True 	FALSE 	0.0
18 	Used 	NaN 	20000.0 	Bellevue, Iowa, United States 	2015.0 	5500.0 	Red 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	8< 	66 	Private Seller 	Clear 	False 	TRUE 	NaN
19 	New 	NaN 	13000.0 	Des Plaines, Illinois, United States 	2016.0 	250.0 	Black 	Harley-Davidson 	Unspecified 	Softail 	... 	NaN 	FALSE 	100 	23 	181 	Private Seller 	Clear 	True 	TRUE 	0.0
20 	New 	NaN 	10900.0 	Ottawa, Illinois, United States 	2017.0 	140.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	NaN 	3172 	Private Seller 	Clear 	False 	TRUE 	NaN
21 	Used 	IN AWESOME CONDITION. SUPER RARE. JUST SERVIC... 	9999.0 	Orland Park, Illinois, United States 	2005.0 	25405.0 	Black 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	283 	Dealer 	Clear 	True 	FALSE 	0.0
22 	Used 	NaN 	5700.0 	Cross Plains, Wisconsin, United States 	1982.0 	28888.0 	Black &amp; Blue 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	947 	Private Seller 	Clear 	True 	FALSE 	0.0
23 	Used 	NaN 	7400.0 	Watervliet, Michigan, United States 	2001.0 	23658.0 	Purple 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	412 	Private Seller 	Clear 	True 	FALSE 	0.0
24 	Used 	NaN 	26500.0 	Kewanee, Illinois, United States 	2016.0 	13089.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	15 	6 	Private Seller 	Clear 	False 	TRUE 	NaN
25 	Used 	NaN 	9850.0 	Chicago, Illinois, United States 	2003.0 	23546.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	12 	Private Seller 	Clear 	True 	FALSE 	0.0
26 	Used 	NaN 	45900.0 	South Haven, Michigan, United States 	2009.0 	40000.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	25 	199 	Private Seller 	Clear 	False 	TRUE 	NaN
27 	Used 	Almost new 2009 Harley-Davidson FLHR Road Ki... 	10600.0 	Wheeling, Illinois, United States 	2009.0 	3769.0 	Red Hot Sun Glo 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	22 	175 	Private Seller 	Clear 	False 	TRUE 	NaN
28 	Used 	*2008 Harley Davidson Rocker C *Chrome Chrome ... 	12000.0 	Chicago, Illinois, United States 	2008.0 	8700.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	11 	Private Seller 	Clear 	True 	FALSE 	0.0
29 	Used 	NaN 	20000.0 	Chicago, Illinois, United States 	2011.0 	16827.0 	Black 	Harley-Davidson 	NaN 	TRIKE 	... 	NaN 	TRUE 	NaN 	31 	17 	Private Seller 	Clear 	False 	TRUE 	NaN
30 	Used 	Very clean and well maintained 	25000.0 	Summit-Argo, Illinois, United States 	2010.0 	15000.0 	Kandy brandywine 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	1< 	18 	Private Seller 	Clear 	True 	TRUE 	0.0
31 	Used 	NaN 	20000.0 	Coldwater, Michigan, United States 	2014.0 	2900.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	142 	Private Seller 	Clear 	True 	FALSE 	0.0
32 	Used 	NaN 	11000.0 	Elkhart, Indiana, United States 	2007.0 	15200.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	NaN 	12 	28 	Private Seller 	Clear 	False 	TRUE 	NaN
33 	Used 	NaN 	8500.0 	Glenview NAS, Illinois, United States 	2008.0 	10319.0 	Black 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	8< 	324 	Private Seller 	Clear 	False 	TRUE 	NaN
34 	Used 	NaN 	18000.0 	Fox River Grove, Illinois, United States 	2010.0 	29544.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	NaN 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
35 	Used 	NaN 	7700.0 	Roselle, Illinois, United States 	2007.0 	10893.0 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	236 	NaN 	Clear 	False 	TRUE 	NaN
36 	Used 	NaN 	2750.0 	Belvidere, Illinois, United States 	2007.0 	35735.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	FLH 	... 	NaN 	FALSE 	100 	NaN 	100 	Belvidere Police Department 	Clear 	True 	FALSE 	19.0
37 	Used 	Year2005 ManufacturerHarley-Davidson ModelScre... 	10895.0 	Kalamazoo, Michigan, United States 	2005.0 	9908.0 	Red 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	1522 	Private Seller 	Clear 	True 	FALSE 	0.0
38 	Used 	No Reserve! 	6700.0 	Tinley Park, Illinois, United States 	2004.0 	8950.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	126 	Private Seller 	Clear 	True 	FALSE 	0.0
39 	Used 	NaN 	18000.0 	Batavia, Illinois, United States 	2015.0 	5600.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	63 	Private Seller 	Clear 	True 	FALSE 	0.0
40 	Used 	NaN 	7300.0 	Rolling Meadows, Illinois, United States 	1997.0 	20000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	TRUE 	100 	5< 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
41 	Used 	NaN 	6800.0 	Hampshire, Illinois, United States 	2003.0 	55782.0 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	TRUE 	100 	2< 	298 	Private Seller 	Clear 	False 	TRUE 	NaN
42 	Used 	Dent and scratch free. Paint and chrome in exc... 	5000.0 	South Bend, Indiana, United States 	2003.0 	1350.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	14 	37 	Private Seller 	Clear 	False 	TRUE 	NaN
43 	Used 	Excellent condition gently used. Adult driven 	13200.0 	Algonquin, Illinois, United States 	2011.0 	15400.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	478 	Private Seller 	Clear 	True 	FALSE 	0.0
44 	Used 	Excellent condition 	11400.0 	Indianapolis, Indiana, United States 	2012.0 	1533.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	4< 	79 	Dealer 	Clear 	False 	TRUE 	NaN
45 	Used 	NaN 	3250.0 	Valparaiso, Indiana, United States 	2003.0 	22896.0 	Blue/Green Metallic 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	9< 	109 	Private Seller 	Clear 	True 	TRUE 	11.0
46 	Used 	This is a nice looking Road King. Paint and ch... 	8000.0 	Madison, Wisconsin, United States 	2012.0 	24742.0 	Vivid Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	NaN 	FALSE 	100 	NaN 	10701 	Dealer 	Clear 	True 	FALSE 	0.0
47 	Used 	NaN 	17800.0 	Webberville, Michigan, United States 	2016.0 	1500.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	4< 	33 	Private Seller 	Clear 	False 	TRUE 	NaN
48 	Used 	NaN 	8500.0 	Rockford, Illinois, United States 	2003.0 	51000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	8< 	124 	Private Seller 	Clear 	False 	TRUE 	NaN
49 	Used 	NaN 	4050.0 	Gilberts, Illinois, United States 	2006.0 	6650.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	NaN 	7< 	58 	Private Seller 	Clear 	True 	TRUE 	3.0
... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	...
7443 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2012.0 	0.0 	Black 	Harley-Davidson 	NaN 	FXDBI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7444 	Used 	NaN 	5900.0 	Raymond, New Hampshire, United States 	2013.0 	7337.0 	Gray 	Yamaha 	NaN 	YZF-R6 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7445 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2016.0 	2669.0 	Red 	Harley-Davidson 	NaN 	XG750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7446 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2016.0 	23440.0 	Gray 	Kawasaki 	NaN 	Z1000 G 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7447 	Used 	NaN 	23499.0 	Suncook, New Hampshire, United States 	2015.0 	16927.0 	Black 	Harley-Davidson 	NaN 	FLHTK ELECTRA GLIDE ULTRA LIMITED 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7448 	Used 	Please feel free to contact me if you have any... 	6500.0 	Raymond, New Hampshire, United States 	2007.0 	29541.0 	Burgundy 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7449 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2008.0 	11388.0 	Black 	Harley-Davidson 	NaN 	FXDF 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7450 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2006.0 	28117.0 	Black 	Kawasaki 	NaN 	ZX-10R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7451 	Used 	NaN 	5200.0 	Raymond, New Hampshire, United States 	2006.0 	12876.0 	maroon 	Suzuki 	NaN 	GSX1300R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7452 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2003.0 	66219.0 	Blue 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7453 	Used 	Please feel free to contact me if you have any... 	8300.0 	Raymond, New Hampshire, United States 	2011.0 	5468.0 	TWO TONE 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7454 	Used 	NaN 	7400.0 	Raymond, New Hampshire, United States 	2013.0 	12333.0 	Red 	Harley-Davidson 	NaN 	FLD103 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7455 	Used 	NaN 	4700.0 	Raymond, New Hampshire, United States 	2015.0 	424.0 	Black 	Suzuki 	NaN 	GSX-S750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7456 	Used 	NaN 	4900.0 	Raymond, New Hampshire, United States 	2009.0 	7552.0 	Orange 	Yamaha 	NaN 	YZF-R6 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7457 	Used 	NaN 	8500.0 	Raymond, New Hampshire, United States 	2008.0 	20060.0 	Black 	Harley-Davidson 	NaN 	FXCW 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7458 	Used 	NaN 	9200.0 	Raymond, New Hampshire, United States 	2012.0 	0.0 	Blue 	Harley-Davidson 	NaN 	FLTRX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7459 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	19268.0 	Black 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7460 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2014.0 	703.0 	Black 	Suzuki 	NaN 	GSX-R1000 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7461 	Used 	NaN 	4200.0 	Raymond, New Hampshire, United States 	2008.0 	5883.0 	Gray 	Yamaha 	NaN 	XV1700 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7462 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2006.0 	32267.0 	Blue 	Harley-Davidson 	NaN 	FLSTFI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7463 	Used 	NaN 	7800.0 	Raymond, New Hampshire, United States 	2008.0 	45135.0 	Orange 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7464 	Used 	NaN 	4400.0 	Raymond, New Hampshire, United States 	2015.0 	2059.0 	Black 	Suzuki 	NaN 	GSX-S750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7465 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2012.0 	11679.0 	Black 	Harley-Davidson 	NaN 	FXDCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7466 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2016.0 	1389.0 	Blue 	Suzuki 	NaN 	GSX-R600 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7467 	Used 	Salvage Rebuildable Repairable No Reserve NR 	7400.0 	Raymond, New Hampshire, United States 	2008.0 	41618.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7468 	Used 	NaN 	8800.0 	Raymond, New Hampshire, United States 	2008.0 	52418.0 	White 	Harley-Davidson 	NaN 	FLHXI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7469 	Used 	NaN 	13570.0 	Scott City, Missouri, United States 	2016.0 	2019.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Dyna Fat Bob 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN
7470 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2007.0 	64724.0 	White 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7471 	Used 	NaN 	6200.0 	Raymond, New Hampshire, United States 	2005.0 	55993.0 	Red 	Harley-Davidson 	NaN 	FLHTCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7472 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2005.0 	32560.0 	TWO TONE 	Harley-Davidson 	NaN 	FLSTNI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7473 	Used 	NaN 	5500.0 	Raymond, New Hampshire, United States 	2000.0 	87123.0 	White 	Harley-Davidson 	NaN 	FLSTC 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7474 	Used 	NaN 	3400.0 	Raymond, New Hampshire, United States 	2006.0 	23865.0 	Blue 	Harley-Davidson 	NaN 	XL 883C 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7475 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	56633.0 	Blue 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7476 	Used 	NaN 	8500.0 	Raymond, New Hampshire, United States 	2010.0 	36780.0 	Blue 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7477 	Used 	NaN 	4900.0 	Raymond, New Hampshire, United States 	2002.0 	22709.0 	Black 	Harley-Davidson 	NaN 	FXDL 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7478 	Used 	NaN 	9900.0 	Raymond, New Hampshire, United States 	2011.0 	20851.0 	Brown 	Harley-Davidson 	NaN 	FLTRU 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7479 	Used 	NaN 	2900.0 	Raymond, New Hampshire, United States 	2013.0 	2905.0 	Black 	Suzuki 	NaN 	SV 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7480 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2016.0 	1701.0 	Green 	Harley-Davidson 	NaN 	XL 883N 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7481 	Used 	NaN 	10500.0 	Raymond, New Hampshire, United States 	2013.0 	16231.0 	Black 	Harley-Davidson 	NaN 	FLTRX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7482 	Used 	NaN 	7200.0 	Raymond, New Hampshire, United States 	2006.0 	29201.0 	Black 	Harley-Davidson 	NaN 	FLTRI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7483 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2007.0 	28716.0 	Purple 	Harley-Davidson 	NaN 	FLHRCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7484 	Used 	NaN 	5000.0 	Raymond, New Hampshire, United States 	2004.0 	12583.0 	NaN 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7485 	Used 	NaN 	5000.0 	Raymond, New Hampshire, United States 	2006.0 	19931.0 	Black 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7486 	Used 	NaN 	8900.0 	Raymond, New Hampshire, United States 	2012.0 	9305.0 	Black 	Harley-Davidson 	NaN 	FXDWG 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7487 	Used 	Please feel free to contact me if you have any... 	4900.0 	Raymond, New Hampshire, United States 	2013.0 	3475.0 	Gray 	Suzuki 	NaN 	Boulevard 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7488 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	23681.0 	Black 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7489 	Used 	NaN 	8900.0 	Raymond, New Hampshire, United States 	2013.0 	5821.0 	Black 	Suzuki 	NaN 	GSX1300RA 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7490 	Used 	NaN 	7800.0 	Raymond, New Hampshire, United States 	2011.0 	48616.0 	Red 	BMW 	NaN 	R1200GS 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7491 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2014.0 	6185.0 	TWO TONE 	Yamaha 	NaN 	YZF-R1 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7492 	Used 	NaN 	12970.0 	Scott City, Missouri, United States 	2016.0 	448.0 	Gray 	Harley-Davidson 	Vehicle has an existing warranty 	Dyna Street Bob 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN

6272 rows × 22 columns

df.shape

(6272, 22)

df.columns

​

Index(['Condition', 'Condition_Desc', 'Price', 'Location', 'Model_Year',
       'Mileage', 'Exterior_Color', 'Make', 'Warranty', 'Model', 'Sub_Model',
       'Type', 'Vehicle_Title', 'OBO', 'Feedback_Perc', 'Watch_Count',
       'N_Reviews', 'Seller_Status', 'Vehicle_Tile', 'Auction', 'Buy_Now',
       'Bid_Count'],
      dtype='object')

df.drop_duplicates(subset = ['Condition', 'Condition_Desc', 'Price', 'Location'], inplace = True)#指定列相同就认为是重复数据

df.shape

(5356, 22)

7.2 缺失值处理

• 缺失值首先需要根据实际情况定义
• 可以采取直接删除法
• 有时候需要使用替换法或者插值法
• 常用的替换法有均值替换、前向替换、后向替换和常数替换

df.apply(lambda x: sum(x.isnull()) / len(x), axis = 0)#每一列缺失值的比例

Condition         0.000000
Condition_Desc    0.752801
Price             0.000000
Location          0.000373
Model_Year        0.000747
Mileage           0.004668
Exterior_Color    0.102875
Make              0.000747
Warranty          0.306385
Model             0.014563
Sub_Model         0.657394
Type              0.206497
Vehicle_Title     0.971994
OBO               0.008215
Feedback_Perc     0.117065
Watch_Count       0.500373
N_Reviews         0.000934
Seller_Status     0.091860
Vehicle_Tile      0.009522
Auction           0.002054
Buy_Now           0.024645
Bid_Count         0.690814
dtype: float64

df.dropna()#这一行只要有一个缺失值，就删除这一行。因为这个数据每一行都有缺失值，所以删除以后就都没有了

​

#df.dropna(how = 'any')这一行只要有一个缺失值，就删除这一行。axis = 0轴向选择，默认是0，删除行；等于1时，删除列。

#df.dropna(how = 'all')这一行所有数据缺失，就删除这一行。

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count

0 rows × 22 columns

df.dropna(how = 'any', subset = ['Condition', 'Price', 'Mileage'])#三个属性里面只要有一个是缺失值，就删除整行

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
0 	Used 	mint!!! very low miles 	11412.0 	McHenry, Illinois, United States 	2013.0 	16000.0 	Black 	Harley-Davidson 	Unspecified 	Touring 	... 	NaN 	FALSE 	8.1 	NaN 	2427 	Private Seller 	Clear 	True 	FALSE 	28.0
1 	Used 	Perfect condition 	17200.0 	Fort Recovery, Ohio, United States 	2016.0 	60.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	17 	657 	Private Seller 	Clear 	True 	TRUE 	0.0
2 	Used 	NaN 	3872.0 	Chicago, Illinois, United States 	1970.0 	25763.0 	Silver/Blue 	BMW 	Vehicle does NOT have an existing warranty 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	136 	NaN 	Clear 	True 	FALSE 	26.0
3 	Used 	CLEAN TITLE READY TO RIDE HOME 	6575.0 	Green Bay, Wisconsin, United States 	2009.0 	33142.0 	Red 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	2920 	Dealer 	Clear 	True 	FALSE 	11.0
4 	Used 	NaN 	10000.0 	West Bend, Wisconsin, United States 	2012.0 	17800.0 	Blue 	Harley-Davidson 	NO WARRANTY 	Touring 	... 	NaN 	FALSE 	100 	13 	271 	OWNER 	Clear 	True 	TRUE 	0.0
5 	Used 	It's a '72 in good shape 	1500.0 	Watervliet, Michigan, United States 	1972.0 	0.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	NaN 	412 	Private Seller 	Clear 	True 	FALSE 	1.0
6 	Used 	NaN 	24900.0 	Sterling, Illinois, United States 	2010.0 	5548.0 	Grey / Red / Silver Metallic 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	9.8 	NaN 	6229 	Dealer 	Clear 	True 	FALSE 	1.0
7 	Used 	NaN 	1400.0 	Williamston, Michigan, United States 	1975.0 	17868.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	9.7 	NaN 	1159 	Private Seller 	Clear 	True 	FALSE 	6.0
8 	Used 	NaN 	5100.0 	Palatine, Illinois, United States 	2014.0 	2800.0 	Cherry Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	NaN 	16 	3 	Private Seller 	Clear 	True 	TRUE 	6.0
9 	Used 	NaN 	8000.0 	Chicago, Illinois, United States 	2015.0 	3000.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Sportster 	... 	NaN 	FALSE 	NaN 	NaN 	1 	Private Seller 	Clear 	True 	FALSE 	0.0
10 	Used 	NaN 	2125.0 	Williamston, Michigan, United States 	1978.0 	30.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.7 	NaN 	1159 	Private Seller 	Clear 	True 	FALSE 	4.0
11 	Used 	NaN 	11100.0 	Oak Park, Illinois, United States 	2011.0 	5800.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	83 	Private Seller 	Clear 	True 	FALSE 	21.0
12 	Used 	NaN 	1125.0 	Pewaukee, Wisconsin, United States 	2002.0 	55000.0 	RICH RED W/STRIPES 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	128 	Private Seller 	Clear 	True 	FALSE 	5.0
13 	Used 	Overall, this bike is in good condition for it... 	3550.0 	Madison, Wisconsin, United States 	2000.0 	57898.0 	Luxury Rich Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	NaN 	FALSE 	100 	NaN 	10701 	Dealer 	Clear 	True 	FALSE 	2.0
14 	Used 	NaN 	5500.0 	Davenport, Iowa, United States 	2008.0 	22102.0 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.3 	NaN 	244 	Private Seller 	Clear 	True 	FALSE 	16.0
15 	Used 	NaN 	9000.0 	Plymouth, Indiana, United States 	2010.0 	7792.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	299 	Private Seller 	Clear 	True 	FALSE 	3.0
16 	Used 	NaN 	8100.0 	Goshen, Indiana, United States 	1973.0 	9305.0 	White 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	300 	Private Seller 	Clear 	True 	FALSE 	25.0
17 	Used 	Absolutely perfect condition 	14000.0 	Plainfield, Indiana, United States 	2016.0 	1125.0 	Blue 	Harley-Davidson 	Vehicle has an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	170 	Private Seller 	Clear 	True 	FALSE 	0.0
18 	Used 	NaN 	20000.0 	Bellevue, Iowa, United States 	2015.0 	5500.0 	Red 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	8< 	66 	Private Seller 	Clear 	False 	TRUE 	NaN
19 	New 	NaN 	13000.0 	Des Plaines, Illinois, United States 	2016.0 	250.0 	Black 	Harley-Davidson 	Unspecified 	Softail 	... 	NaN 	FALSE 	100 	23 	181 	Private Seller 	Clear 	True 	TRUE 	0.0
20 	New 	NaN 	10900.0 	Ottawa, Illinois, United States 	2017.0 	140.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	NaN 	3172 	Private Seller 	Clear 	False 	TRUE 	NaN
21 	Used 	IN AWESOME CONDITION. SUPER RARE. JUST SERVIC... 	9999.0 	Orland Park, Illinois, United States 	2005.0 	25405.0 	Black 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	283 	Dealer 	Clear 	True 	FALSE 	0.0
22 	Used 	NaN 	5700.0 	Cross Plains, Wisconsin, United States 	1982.0 	28888.0 	Black &amp; Blue 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	947 	Private Seller 	Clear 	True 	FALSE 	0.0
23 	Used 	NaN 	7400.0 	Watervliet, Michigan, United States 	2001.0 	23658.0 	Purple 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	412 	Private Seller 	Clear 	True 	FALSE 	0.0
24 	Used 	NaN 	26500.0 	Kewanee, Illinois, United States 	2016.0 	13089.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	15 	6 	Private Seller 	Clear 	False 	TRUE 	NaN
25 	Used 	NaN 	9850.0 	Chicago, Illinois, United States 	2003.0 	23546.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	12 	Private Seller 	Clear 	True 	FALSE 	0.0
26 	Used 	NaN 	45900.0 	South Haven, Michigan, United States 	2009.0 	40000.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	25 	199 	Private Seller 	Clear 	False 	TRUE 	NaN
27 	Used 	Almost new 2009 Harley-Davidson FLHR Road Ki... 	10600.0 	Wheeling, Illinois, United States 	2009.0 	3769.0 	Red Hot Sun Glo 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	22 	175 	Private Seller 	Clear 	False 	TRUE 	NaN
28 	Used 	*2008 Harley Davidson Rocker C *Chrome Chrome ... 	12000.0 	Chicago, Illinois, United States 	2008.0 	8700.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	11 	Private Seller 	Clear 	True 	FALSE 	0.0
29 	Used 	NaN 	20000.0 	Chicago, Illinois, United States 	2011.0 	16827.0 	Black 	Harley-Davidson 	NaN 	TRIKE 	... 	NaN 	TRUE 	NaN 	31 	17 	Private Seller 	Clear 	False 	TRUE 	NaN
30 	Used 	Very clean and well maintained 	25000.0 	Summit-Argo, Illinois, United States 	2010.0 	15000.0 	Kandy brandywine 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	1< 	18 	Private Seller 	Clear 	True 	TRUE 	0.0
31 	Used 	NaN 	20000.0 	Coldwater, Michigan, United States 	2014.0 	2900.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	142 	Private Seller 	Clear 	True 	FALSE 	0.0
32 	Used 	NaN 	11000.0 	Elkhart, Indiana, United States 	2007.0 	15200.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	NaN 	12 	28 	Private Seller 	Clear 	False 	TRUE 	NaN
33 	Used 	NaN 	8500.0 	Glenview NAS, Illinois, United States 	2008.0 	10319.0 	Black 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	8< 	324 	Private Seller 	Clear 	False 	TRUE 	NaN
34 	Used 	NaN 	18000.0 	Fox River Grove, Illinois, United States 	2010.0 	29544.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	NaN 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
35 	Used 	NaN 	7700.0 	Roselle, Illinois, United States 	2007.0 	10893.0 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	236 	NaN 	Clear 	False 	TRUE 	NaN
36 	Used 	NaN 	2750.0 	Belvidere, Illinois, United States 	2007.0 	35735.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	FLH 	... 	NaN 	FALSE 	100 	NaN 	100 	Belvidere Police Department 	Clear 	True 	FALSE 	19.0
37 	Used 	Year2005 ManufacturerHarley-Davidson ModelScre... 	10895.0 	Kalamazoo, Michigan, United States 	2005.0 	9908.0 	Red 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	1522 	Private Seller 	Clear 	True 	FALSE 	0.0
38 	Used 	No Reserve! 	6700.0 	Tinley Park, Illinois, United States 	2004.0 	8950.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	126 	Private Seller 	Clear 	True 	FALSE 	0.0
39 	Used 	NaN 	18000.0 	Batavia, Illinois, United States 	2015.0 	5600.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	63 	Private Seller 	Clear 	True 	FALSE 	0.0
40 	Used 	NaN 	7300.0 	Rolling Meadows, Illinois, United States 	1997.0 	20000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	TRUE 	100 	5< 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
41 	Used 	NaN 	6800.0 	Hampshire, Illinois, United States 	2003.0 	55782.0 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	TRUE 	100 	2< 	298 	Private Seller 	Clear 	False 	TRUE 	NaN
42 	Used 	Dent and scratch free. Paint and chrome in exc... 	5000.0 	South Bend, Indiana, United States 	2003.0 	1350.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	14 	37 	Private Seller 	Clear 	False 	TRUE 	NaN
43 	Used 	Excellent condition gently used. Adult driven 	13200.0 	Algonquin, Illinois, United States 	2011.0 	15400.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	478 	Private Seller 	Clear 	True 	FALSE 	0.0
44 	Used 	Excellent condition 	11400.0 	Indianapolis, Indiana, United States 	2012.0 	1533.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	4< 	79 	Dealer 	Clear 	False 	TRUE 	NaN
45 	Used 	NaN 	3250.0 	Valparaiso, Indiana, United States 	2003.0 	22896.0 	Blue/Green Metallic 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	9< 	109 	Private Seller 	Clear 	True 	TRUE 	11.0
46 	Used 	This is a nice looking Road King. Paint and ch... 	8000.0 	Madison, Wisconsin, United States 	2012.0 	24742.0 	Vivid Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	NaN 	FALSE 	100 	NaN 	10701 	Dealer 	Clear 	True 	FALSE 	0.0
47 	Used 	NaN 	17800.0 	Webberville, Michigan, United States 	2016.0 	1500.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	4< 	33 	Private Seller 	Clear 	False 	TRUE 	NaN
48 	Used 	NaN 	8500.0 	Rockford, Illinois, United States 	2003.0 	51000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	8< 	124 	Private Seller 	Clear 	False 	TRUE 	NaN
49 	Used 	NaN 	4050.0 	Gilberts, Illinois, United States 	2006.0 	6650.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	NaN 	7< 	58 	Private Seller 	Clear 	True 	TRUE 	3.0
... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	...
7390 	Used 	NaN 	14999.0 	Greensboro, North Carolina, United States 	2015.0 	14000.0 	Red 	Indian 	Unspecified 	Chief?Vintage 	... 	NaN 	TRUE 	100 	NaN 	312 	Dealer 	Clear 	False 	FALSE 	NaN
7391 	Used 	NaN 	9299.0 	Naples, Florida, United States 	2014.0 	4470.0 	Blue 	BMW 	NaN 	F-Series 	... 	NaN 	TRUE 	8.6 	NaN 	1122 	Dealer 	Clear 	False 	FALSE 	NaN
7392 	Used 	NaN 	12990.0 	Scott City, Missouri, United States 	2014.0 	1617.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Flstfb 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN
7393 	Used 	NaN 	15990.0 	Scott City, Missouri, United States 	2016.0 	1873.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Heritage Softail Classic 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN
7394 	New 	NaN 	14440.0 	Plano, Texas, United States 	2017.0 	7.0 	White 	BMW 	Unspecified 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	161 	Dealer 	Clear 	False 	FALSE 	NaN
7395 	Used 	NaN 	10599.0 	Delbarton, West Virginia, United States 	2005.0 	16850.0 	Red 	Harley-Davidson 	Unspecified 	FLHRCI - Road King?Classic 	... 	NaN 	TRUE 	100 	NaN 	28 	Dealer 	Clear 	False 	FALSE 	NaN
7398 	Used 	NaN 	5200.0 	Raymond, New Hampshire, United States 	2013.0 	5307.0 	Black 	Suzuki 	NaN 	GSX-R750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7399 	Used 	Please feel free to contact me if you have any... 	4900.0 	Raymond, New Hampshire, United States 	2006.0 	22931.0 	Gray 	Suzuki 	NaN 	GSX-R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7404 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2005.0 	15906.0 	Blue 	Harley-Davidson 	NaN 	FLHTCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7405 	Used 	NaN 	4300.0 	Raymond, New Hampshire, United States 	2009.0 	7071.0 	Black 	Suzuki 	NaN 	GSX-R600 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7406 	Used 	NaN 	6600.0 	Raymond, New Hampshire, United States 	2006.0 	68715.0 	Black 	Harley-Davidson 	NaN 	FLHRCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7409 	Used 	NaN 	11700.0 	Raymond, New Hampshire, United States 	2011.0 	20788.0 	Green 	Harley-Davidson 	NaN 	FLHX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7410 	Used 	Please feel free to contact me if you have any... 	5200.0 	Raymond, New Hampshire, United States 	2012.0 	3123.0 	DARK BLUE 	Harley-Davidson 	NaN 	Sportster 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7411 	Used 	NaN 	4900.0 	Raymond, New Hampshire, United States 	2015.0 	3174.0 	Black 	Suzuki 	NaN 	GSX-S 750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7413 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2008.0 	70833.0 	Blue 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7414 	Used 	NaN 	10500.0 	Raymond, New Hampshire, United States 	2011.0 	32549.0 	Brown 	Harley-Davidson 	NaN 	FLHTK 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7417 	Used 	Please feel free to contact me if you have any... 	5900.0 	Raymond, New Hampshire, United States 	2008.0 	14627.0 	Red 	Honda 	NaN 	CBR 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7418 	Used 	NaN 	9600.0 	Raymond, New Hampshire, United States 	2012.0 	35906.0 	Blue 	Harley-Davidson 	NaN 	FLHRCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7419 	Used 	NaN 	12900.0 	Raymond, New Hampshire, United States 	2013.0 	16033.0 	Black 	Harley-Davidson 	NaN 	FLHX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7420 	Used 	NaN 	5900.0 	Raymond, New Hampshire, United States 	2005.0 	122277.0 	MAROON 	Harley-Davidson 	NaN 	FLHRSI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7422 	Used 	NaN 	1900.0 	Raymond, New Hampshire, United States 	2009.0 	6495.0 	Black 	Hyosung 	NaN 	GT650 R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7423 	Used 	NaN 	3300.0 	Raymond, New Hampshire, United States 	2009.0 	21756.0 	CHARCOAL 	Suzuki 	NaN 	DL650 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7424 	Used 	NaN 	3200.0 	Raymond, New Hampshire, United States 	2007.0 	4959.0 	Black 	Harley-Davidson 	NaN 	XL 883L 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7427 	Used 	NaN 	12500.0 	Raymond, New Hampshire, United States 	2014.0 	27877.0 	Gray 	Harley-Davidson 	NaN 	FLHX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7428 	Used 	NaN 	7700.0 	Raymond, New Hampshire, United States 	2015.0 	5680.0 	Green 	Kawasaki 	NaN 	ZX-6R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7429 	Used 	NaN 	5800.0 	Raymond, New Hampshire, United States 	2014.0 	4916.0 	Orange 	Harley-Davidson 	NaN 	XL 1200V 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7430 	Used 	NaN 	6800.0 	Raymond, New Hampshire, United States 	2009.0 	0.0 	Black 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7431 	Used 	NaN 	6200.0 	Raymond, New Hampshire, United States 	2007.0 	24245.0 	Blue 	Harley-Davidson 	NaN 	FLSTCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7432 	Used 	NaN 	6300.0 	Raymond, New Hampshire, United States 	2004.0 	15272.0 	Red 	Harley-Davidson 	NaN 	FXSTDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7434 	Used 	NaN 	10600.0 	Raymond, New Hampshire, United States 	2012.0 	48129.0 	Blue 	Harley-Davidson 	NaN 	FLHX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7436 	Used 	NaN 	13900.0 	Raymond, New Hampshire, United States 	2016.0 	28510.0 	Black 	Harley-Davidson 	NaN 	FLHTKL 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7438 	Used 	NaN 	4200.0 	Raymond, New Hampshire, United States 	2007.0 	10326.0 	TWO TONE 	Yamaha 	NaN 	XV1700 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7441 	Used 	NaN 	9500.0 	Raymond, New Hampshire, United States 	2010.0 	21183.0 	TWO TONE 	Harley-Davidson 	NaN 	FLSTNI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7442 	Used 	NaN 	4800.0 	Raymond, New Hampshire, United States 	2006.0 	17410.0 	White 	Suzuki 	NaN 	GSX1300R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7448 	Used 	Please feel free to contact me if you have any... 	6500.0 	Raymond, New Hampshire, United States 	2007.0 	29541.0 	Burgundy 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7453 	Used 	Please feel free to contact me if you have any... 	8300.0 	Raymond, New Hampshire, United States 	2011.0 	5468.0 	TWO TONE 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7454 	Used 	NaN 	7400.0 	Raymond, New Hampshire, United States 	2013.0 	12333.0 	Red 	Harley-Davidson 	NaN 	FLD103 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7457 	Used 	NaN 	8500.0 	Raymond, New Hampshire, United States 	2008.0 	20060.0 	Black 	Harley-Davidson 	NaN 	FXCW 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7458 	Used 	NaN 	9200.0 	Raymond, New Hampshire, United States 	2012.0 	0.0 	Blue 	Harley-Davidson 	NaN 	FLTRX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7463 	Used 	NaN 	7800.0 	Raymond, New Hampshire, United States 	2008.0 	45135.0 	Orange 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7464 	Used 	NaN 	4400.0 	Raymond, New Hampshire, United States 	2015.0 	2059.0 	Black 	Suzuki 	NaN 	GSX-S750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7467 	Used 	Salvage Rebuildable Repairable No Reserve NR 	7400.0 	Raymond, New Hampshire, United States 	2008.0 	41618.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7468 	Used 	NaN 	8800.0 	Raymond, New Hampshire, United States 	2008.0 	52418.0 	White 	Harley-Davidson 	NaN 	FLHXI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7469 	Used 	NaN 	13570.0 	Scott City, Missouri, United States 	2016.0 	2019.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Dyna Fat Bob 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN
7474 	Used 	NaN 	3400.0 	Raymond, New Hampshire, United States 	2006.0 	23865.0 	Blue 	Harley-Davidson 	NaN 	XL 883C 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7478 	Used 	NaN 	9900.0 	Raymond, New Hampshire, United States 	2011.0 	20851.0 	Brown 	Harley-Davidson 	NaN 	FLTRU 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7479 	Used 	NaN 	2900.0 	Raymond, New Hampshire, United States 	2013.0 	2905.0 	Black 	Suzuki 	NaN 	SV 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7482 	Used 	NaN 	7200.0 	Raymond, New Hampshire, United States 	2006.0 	29201.0 	Black 	Harley-Davidson 	NaN 	FLTRI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7484 	Used 	NaN 	5000.0 	Raymond, New Hampshire, United States 	2004.0 	12583.0 	NaN 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7486 	Used 	NaN 	8900.0 	Raymond, New Hampshire, United States 	2012.0 	9305.0 	Black 	Harley-Davidson 	NaN 	FXDWG 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN

5331 rows × 22 columns

df.fillna(0)#所有缺失值用0填补

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
0 	Used 	mint!!! very low miles 	11412.0 	McHenry, Illinois, United States 	2013.0 	16000.0 	Black 	Harley-Davidson 	Unspecified 	Touring 	... 	0 	FALSE 	8.1 	0 	2427 	Private Seller 	Clear 	True 	FALSE 	28.0
1 	Used 	Perfect condition 	17200.0 	Fort Recovery, Ohio, United States 	2016.0 	60.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	0 	FALSE 	100 	17 	657 	Private Seller 	Clear 	True 	TRUE 	0.0
2 	Used 	0 	3872.0 	Chicago, Illinois, United States 	1970.0 	25763.0 	Silver/Blue 	BMW 	Vehicle does NOT have an existing warranty 	R-Series 	... 	0 	FALSE 	100 	0 	136 	0 	Clear 	True 	FALSE 	26.0
3 	Used 	CLEAN TITLE READY TO RIDE HOME 	6575.0 	Green Bay, Wisconsin, United States 	2009.0 	33142.0 	Red 	Harley-Davidson 	0 	Touring 	... 	0 	FALSE 	100 	0 	2920 	Dealer 	Clear 	True 	FALSE 	11.0
4 	Used 	0 	10000.0 	West Bend, Wisconsin, United States 	2012.0 	17800.0 	Blue 	Harley-Davidson 	NO WARRANTY 	Touring 	... 	0 	FALSE 	100 	13 	271 	OWNER 	Clear 	True 	TRUE 	0.0
5 	Used 	It&#039;s a &#039;72 in good shape 	1500.0 	Watervliet, Michigan, United States 	1972.0 	0.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	0 	FALSE 	100 	0 	412 	Private Seller 	Clear 	True 	FALSE 	1.0
6 	Used 	0 	24900.0 	Sterling, Illinois, United States 	2010.0 	5548.0 	Grey / Red / Silver Metallic 	Harley-Davidson 	0 	Touring 	... 	0 	FALSE 	9.8 	0 	6229 	Dealer 	Clear 	True 	FALSE 	1.0
7 	Used 	0 	1400.0 	Williamston, Michigan, United States 	1975.0 	17868.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	0 	FALSE 	9.7 	0 	1159 	Private Seller 	Clear 	True 	FALSE 	6.0
8 	Used 	0 	5100.0 	Palatine, Illinois, United States 	2014.0 	2800.0 	Cherry Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	0 	16 	3 	Private Seller 	Clear 	True 	TRUE 	6.0
9 	Used 	0 	8000.0 	Chicago, Illinois, United States 	2015.0 	3000.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Sportster 	... 	0 	FALSE 	0 	0 	1 	Private Seller 	Clear 	True 	FALSE 	0.0
10 	Used 	0 	2125.0 	Williamston, Michigan, United States 	1978.0 	30.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	9.7 	0 	1159 	Private Seller 	Clear 	True 	FALSE 	4.0
11 	Used 	0 	11100.0 	Oak Park, Illinois, United States 	2011.0 	5800.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	100 	0 	83 	Private Seller 	Clear 	True 	FALSE 	21.0
12 	Used 	0 	1125.0 	Pewaukee, Wisconsin, United States 	2002.0 	55000.0 	RICH RED W/STRIPES 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	0 	FALSE 	100 	0 	128 	Private Seller 	Clear 	True 	FALSE 	5.0
13 	Used 	Overall, this bike is in good condition for it... 	3550.0 	Madison, Wisconsin, United States 	2000.0 	57898.0 	Luxury Rich Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	0 	FALSE 	100 	0 	10701 	Dealer 	Clear 	True 	FALSE 	2.0
14 	Used 	0 	5500.0 	Davenport, Iowa, United States 	2008.0 	22102.0 	0 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	9.3 	0 	244 	Private Seller 	Clear 	True 	FALSE 	16.0
15 	Used 	0 	9000.0 	Plymouth, Indiana, United States 	2010.0 	7792.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	100 	0 	299 	Private Seller 	Clear 	True 	FALSE 	3.0
16 	Used 	0 	8100.0 	Goshen, Indiana, United States 	1973.0 	9305.0 	White 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	0 	FALSE 	100 	0 	300 	Private Seller 	Clear 	True 	FALSE 	25.0
17 	Used 	Absolutely perfect condition 	14000.0 	Plainfield, Indiana, United States 	2016.0 	1125.0 	Blue 	Harley-Davidson 	Vehicle has an existing warranty 	Softail 	... 	0 	FALSE 	100 	0 	170 	Private Seller 	Clear 	True 	FALSE 	0.0
18 	Used 	0 	20000.0 	Bellevue, Iowa, United States 	2015.0 	5500.0 	Red 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	0 	TRUE 	100 	8< 	66 	Private Seller 	Clear 	False 	TRUE 	0.0
19 	New 	0 	13000.0 	Des Plaines, Illinois, United States 	2016.0 	250.0 	Black 	Harley-Davidson 	Unspecified 	Softail 	... 	0 	FALSE 	100 	23 	181 	Private Seller 	Clear 	True 	TRUE 	0.0
20 	New 	0 	10900.0 	Ottawa, Illinois, United States 	2017.0 	140.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	0 	TRUE 	100 	0 	3172 	Private Seller 	Clear 	False 	TRUE 	0.0
21 	Used 	IN AWESOME CONDITION. SUPER RARE. JUST SERVIC... 	9999.0 	Orland Park, Illinois, United States 	2005.0 	25405.0 	Black 	Harley-Davidson 	0 	Softail 	... 	0 	FALSE 	100 	0 	283 	Dealer 	Clear 	True 	FALSE 	0.0
22 	Used 	0 	5700.0 	Cross Plains, Wisconsin, United States 	1982.0 	28888.0 	Black &amp; Blue 	Harley-Davidson 	0 	Other 	... 	0 	FALSE 	100 	0 	947 	Private Seller 	Clear 	True 	FALSE 	0.0
23 	Used 	0 	7400.0 	Watervliet, Michigan, United States 	2001.0 	23658.0 	Purple 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	100 	0 	412 	Private Seller 	Clear 	True 	FALSE 	0.0
24 	Used 	0 	26500.0 	Kewanee, Illinois, United States 	2016.0 	13089.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	TRUE 	100 	15 	6 	Private Seller 	Clear 	False 	TRUE 	0.0
25 	Used 	0 	9850.0 	Chicago, Illinois, United States 	2003.0 	23546.0 	Blue 	Harley-Davidson 	0 	Touring 	... 	0 	FALSE 	100 	0 	12 	Private Seller 	Clear 	True 	FALSE 	0.0
26 	Used 	0 	45900.0 	South Haven, Michigan, United States 	2009.0 	40000.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	100 	25 	199 	Private Seller 	Clear 	False 	TRUE 	0.0
27 	Used 	Almost new 2009 Harley-Davidson FLHR Road Ki... 	10600.0 	Wheeling, Illinois, United States 	2009.0 	3769.0 	Red Hot Sun Glo 	Harley-Davidson 	0 	Touring 	... 	0 	TRUE 	100 	22 	175 	Private Seller 	Clear 	False 	TRUE 	0.0
28 	Used 	*2008 Harley Davidson Rocker C *Chrome Chrome ... 	12000.0 	Chicago, Illinois, United States 	2008.0 	8700.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	0 	FALSE 	100 	0 	11 	Private Seller 	Clear 	True 	FALSE 	0.0
29 	Used 	0 	20000.0 	Chicago, Illinois, United States 	2011.0 	16827.0 	Black 	Harley-Davidson 	0 	TRIKE 	... 	0 	TRUE 	0 	31 	17 	Private Seller 	Clear 	False 	TRUE 	0.0
30 	Used 	Very clean and well maintained 	25000.0 	Summit-Argo, Illinois, United States 	2010.0 	15000.0 	Kandy brandywine 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	100 	1< 	18 	Private Seller 	Clear 	True 	TRUE 	0.0
31 	Used 	0 	20000.0 	Coldwater, Michigan, United States 	2014.0 	2900.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	100 	0 	142 	Private Seller 	Clear 	True 	FALSE 	0.0
32 	Used 	0 	11000.0 	Elkhart, Indiana, United States 	2007.0 	15200.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	TRUE 	0 	12 	28 	Private Seller 	Clear 	False 	TRUE 	0.0
33 	Used 	0 	8500.0 	Glenview NAS, Illinois, United States 	2008.0 	10319.0 	Black 	Harley-Davidson 	0 	Touring 	... 	0 	TRUE 	100 	8< 	324 	Private Seller 	Clear 	False 	TRUE 	0.0
34 	Used 	0 	18000.0 	Fox River Grove, Illinois, United States 	2010.0 	29544.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	TRUE 	100 	0 	111 	Private Seller 	Clear 	False 	TRUE 	0.0
35 	Used 	0 	7700.0 	Roselle, Illinois, United States 	2007.0 	10893.0 	0 	Harley-Davidson 	0 	Other 	... 	0 	FALSE 	100 	0 	236 	0 	Clear 	False 	TRUE 	0.0
36 	Used 	0 	2750.0 	Belvidere, Illinois, United States 	2007.0 	35735.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	FLH 	... 	0 	FALSE 	100 	0 	100 	Belvidere Police Department 	Clear 	True 	FALSE 	19.0
37 	Used 	Year2005 ManufacturerHarley-Davidson ModelScre... 	10895.0 	Kalamazoo, Michigan, United States 	2005.0 	9908.0 	Red 	Harley-Davidson 	0 	Softail 	... 	0 	FALSE 	100 	0 	1522 	Private Seller 	Clear 	True 	FALSE 	0.0
38 	Used 	No Reserve! 	6700.0 	Tinley Park, Illinois, United States 	2004.0 	8950.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	0 	FALSE 	100 	0 	126 	Private Seller 	Clear 	True 	FALSE 	0.0
39 	Used 	0 	18000.0 	Batavia, Illinois, United States 	2015.0 	5600.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	0 	FALSE 	100 	0 	63 	Private Seller 	Clear 	True 	FALSE 	0.0
40 	Used 	0 	7300.0 	Rolling Meadows, Illinois, United States 	1997.0 	20000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	0 	TRUE 	100 	5< 	111 	Private Seller 	Clear 	False 	TRUE 	0.0
41 	Used 	0 	6800.0 	Hampshire, Illinois, United States 	2003.0 	55782.0 	0 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	0 	TRUE 	100 	2< 	298 	Private Seller 	Clear 	False 	TRUE 	0.0
42 	Used 	Dent and scratch free. Paint and chrome in exc... 	5000.0 	South Bend, Indiana, United States 	2003.0 	1350.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	0 	FALSE 	100 	14 	37 	Private Seller 	Clear 	False 	TRUE 	0.0
43 	Used 	Excellent condition gently used. Adult driven 	13200.0 	Algonquin, Illinois, United States 	2011.0 	15400.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	100 	0 	478 	Private Seller 	Clear 	True 	FALSE 	0.0
44 	Used 	Excellent condition 	11400.0 	Indianapolis, Indiana, United States 	2012.0 	1533.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	FALSE 	100 	4< 	79 	Dealer 	Clear 	False 	TRUE 	0.0
45 	Used 	0 	3250.0 	Valparaiso, Indiana, United States 	2003.0 	22896.0 	Blue/Green Metallic 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	0 	FALSE 	100 	9< 	109 	Private Seller 	Clear 	True 	TRUE 	11.0
46 	Used 	This is a nice looking Road King. Paint and ch... 	8000.0 	Madison, Wisconsin, United States 	2012.0 	24742.0 	Vivid Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	0 	FALSE 	100 	0 	10701 	Dealer 	Clear 	True 	FALSE 	0.0
47 	Used 	0 	17800.0 	Webberville, Michigan, United States 	2016.0 	1500.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	0 	TRUE 	100 	4< 	33 	Private Seller 	Clear 	False 	TRUE 	0.0
48 	Used 	0 	8500.0 	Rockford, Illinois, United States 	2003.0 	51000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	0 	TRUE 	100 	8< 	124 	Private Seller 	Clear 	False 	TRUE 	0.0
49 	Used 	0 	4050.0 	Gilberts, Illinois, United States 	2006.0 	6650.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	0 	FALSE 	0 	7< 	58 	Private Seller 	Clear 	True 	TRUE 	3.0
... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	...
7390 	Used 	0 	14999.0 	Greensboro, North Carolina, United States 	2015.0 	14000.0 	Red 	Indian 	Unspecified 	Chief?Vintage 	... 	0 	TRUE 	100 	0 	312 	Dealer 	Clear 	False 	FALSE 	0.0
7391 	Used 	0 	9299.0 	Naples, Florida, United States 	2014.0 	4470.0 	Blue 	BMW 	0 	F-Series 	... 	0 	TRUE 	8.6 	0 	1122 	Dealer 	Clear 	False 	FALSE 	0.0
7392 	Used 	0 	12990.0 	Scott City, Missouri, United States 	2014.0 	1617.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Flstfb 	... 	0 	FALSE 	100 	0 	4 	Dealer 	Clear 	False 	FALSE 	0.0
7393 	Used 	0 	15990.0 	Scott City, Missouri, United States 	2016.0 	1873.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Heritage Softail Classic 	... 	0 	FALSE 	100 	0 	4 	Dealer 	Clear 	False 	FALSE 	0.0
7394 	New 	0 	14440.0 	Plano, Texas, United States 	2017.0 	7.0 	White 	BMW 	Unspecified 	R-Series 	... 	0 	FALSE 	100 	0 	161 	Dealer 	Clear 	False 	FALSE 	0.0
7395 	Used 	0 	10599.0 	Delbarton, West Virginia, United States 	2005.0 	16850.0 	Red 	Harley-Davidson 	Unspecified 	FLHRCI - Road King?Classic 	... 	0 	TRUE 	100 	0 	28 	Dealer 	Clear 	False 	FALSE 	0.0
7398 	Used 	0 	5200.0 	Raymond, New Hampshire, United States 	2013.0 	5307.0 	Black 	Suzuki 	0 	GSX-R750 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7399 	Used 	Please feel free to contact me if you have any... 	4900.0 	Raymond, New Hampshire, United States 	2006.0 	22931.0 	Gray 	Suzuki 	0 	GSX-R 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7404 	Used 	0 	7500.0 	Raymond, New Hampshire, United States 	2005.0 	15906.0 	Blue 	Harley-Davidson 	0 	FLHTCI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	0.0
7405 	Used 	0 	4300.0 	Raymond, New Hampshire, United States 	2009.0 	7071.0 	Black 	Suzuki 	0 	GSX-R600 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7406 	Used 	0 	6600.0 	Raymond, New Hampshire, United States 	2006.0 	68715.0 	Black 	Harley-Davidson 	0 	FLHRCI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7409 	Used 	0 	11700.0 	Raymond, New Hampshire, United States 	2011.0 	20788.0 	Green 	Harley-Davidson 	0 	FLHX 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7410 	Used 	Please feel free to contact me if you have any... 	5200.0 	Raymond, New Hampshire, United States 	2012.0 	3123.0 	DARK BLUE 	Harley-Davidson 	0 	Sportster 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7411 	Used 	0 	4900.0 	Raymond, New Hampshire, United States 	2015.0 	3174.0 	Black 	Suzuki 	0 	GSX-S 750 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7413 	Used 	0 	6500.0 	Raymond, New Hampshire, United States 	2008.0 	70833.0 	Blue 	Harley-Davidson 	0 	FLHTCUI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7414 	Used 	0 	10500.0 	Raymond, New Hampshire, United States 	2011.0 	32549.0 	Brown 	Harley-Davidson 	0 	FLHTK 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7417 	Used 	Please feel free to contact me if you have any... 	5900.0 	Raymond, New Hampshire, United States 	2008.0 	14627.0 	Red 	Honda 	0 	CBR 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	0.0
7418 	Used 	0 	9600.0 	Raymond, New Hampshire, United States 	2012.0 	35906.0 	Blue 	Harley-Davidson 	0 	FLHRCI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7419 	Used 	0 	12900.0 	Raymond, New Hampshire, United States 	2013.0 	16033.0 	Black 	Harley-Davidson 	0 	FLHX 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7420 	Used 	0 	5900.0 	Raymond, New Hampshire, United States 	2005.0 	122277.0 	MAROON 	Harley-Davidson 	0 	FLHRSI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7422 	Used 	0 	1900.0 	Raymond, New Hampshire, United States 	2009.0 	6495.0 	Black 	Hyosung 	0 	GT650 R 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7423 	Used 	0 	3300.0 	Raymond, New Hampshire, United States 	2009.0 	21756.0 	CHARCOAL 	Suzuki 	0 	DL650 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7424 	Used 	0 	3200.0 	Raymond, New Hampshire, United States 	2007.0 	4959.0 	Black 	Harley-Davidson 	0 	XL 883L 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7427 	Used 	0 	12500.0 	Raymond, New Hampshire, United States 	2014.0 	27877.0 	Gray 	Harley-Davidson 	0 	FLHX 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	0.0
7428 	Used 	0 	7700.0 	Raymond, New Hampshire, United States 	2015.0 	5680.0 	Green 	Kawasaki 	0 	ZX-6R 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7429 	Used 	0 	5800.0 	Raymond, New Hampshire, United States 	2014.0 	4916.0 	Orange 	Harley-Davidson 	0 	XL 1200V 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7430 	Used 	0 	6800.0 	Raymond, New Hampshire, United States 	2009.0 	0.0 	Black 	Harley-Davidson 	0 	FLHTCUI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7431 	Used 	0 	6200.0 	Raymond, New Hampshire, United States 	2007.0 	24245.0 	Blue 	Harley-Davidson 	0 	FLSTCI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7432 	Used 	0 	6300.0 	Raymond, New Hampshire, United States 	2004.0 	15272.0 	Red 	Harley-Davidson 	0 	FXSTDI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7434 	Used 	0 	10600.0 	Raymond, New Hampshire, United States 	2012.0 	48129.0 	Blue 	Harley-Davidson 	0 	FLHX 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	0.0
7436 	Used 	0 	13900.0 	Raymond, New Hampshire, United States 	2016.0 	28510.0 	Black 	Harley-Davidson 	0 	FLHTKL 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7438 	Used 	0 	4200.0 	Raymond, New Hampshire, United States 	2007.0 	10326.0 	TWO TONE 	Yamaha 	0 	XV1700 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7441 	Used 	0 	9500.0 	Raymond, New Hampshire, United States 	2010.0 	21183.0 	TWO TONE 	Harley-Davidson 	0 	FLSTNI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	0.0
7442 	Used 	0 	4800.0 	Raymond, New Hampshire, United States 	2006.0 	17410.0 	White 	Suzuki 	0 	GSX1300R 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7448 	Used 	Please feel free to contact me if you have any... 	6500.0 	Raymond, New Hampshire, United States 	2007.0 	29541.0 	Burgundy 	Harley-Davidson 	0 	Touring 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7453 	Used 	Please feel free to contact me if you have any... 	8300.0 	Raymond, New Hampshire, United States 	2011.0 	5468.0 	TWO TONE 	Harley-Davidson 	0 	Softail 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7454 	Used 	0 	7400.0 	Raymond, New Hampshire, United States 	2013.0 	12333.0 	Red 	Harley-Davidson 	0 	FLD103 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7457 	Used 	0 	8500.0 	Raymond, New Hampshire, United States 	2008.0 	20060.0 	Black 	Harley-Davidson 	0 	FXCW 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7458 	Used 	0 	9200.0 	Raymond, New Hampshire, United States 	2012.0 	0.0 	Blue 	Harley-Davidson 	0 	FLTRX 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7463 	Used 	0 	7800.0 	Raymond, New Hampshire, United States 	2008.0 	45135.0 	Orange 	Harley-Davidson 	0 	FLHTCUI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7464 	Used 	0 	4400.0 	Raymond, New Hampshire, United States 	2015.0 	2059.0 	Black 	Suzuki 	0 	GSX-S750 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7467 	Used 	Salvage Rebuildable Repairable No Reserve NR 	7400.0 	Raymond, New Hampshire, United States 	2008.0 	41618.0 	Blue 	Harley-Davidson 	0 	Touring 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7468 	Used 	0 	8800.0 	Raymond, New Hampshire, United States 	2008.0 	52418.0 	White 	Harley-Davidson 	0 	FLHXI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	0.0
7469 	Used 	0 	13570.0 	Scott City, Missouri, United States 	2016.0 	2019.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Dyna Fat Bob 	... 	0 	FALSE 	100 	0 	4 	Dealer 	Clear 	False 	FALSE 	0.0
7474 	Used 	0 	3400.0 	Raymond, New Hampshire, United States 	2006.0 	23865.0 	Blue 	Harley-Davidson 	0 	XL 883C 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7478 	Used 	0 	9900.0 	Raymond, New Hampshire, United States 	2011.0 	20851.0 	Brown 	Harley-Davidson 	0 	FLTRU 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7479 	Used 	0 	2900.0 	Raymond, New Hampshire, United States 	2013.0 	2905.0 	Black 	Suzuki 	0 	SV 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7482 	Used 	0 	7200.0 	Raymond, New Hampshire, United States 	2006.0 	29201.0 	Black 	Harley-Davidson 	0 	FLTRI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7484 	Used 	0 	5000.0 	Raymond, New Hampshire, United States 	2004.0 	12583.0 	0 	Harley-Davidson 	0 	FXDI 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0
7486 	Used 	0 	8900.0 	Raymond, New Hampshire, United States 	2012.0 	9305.0 	Black 	Harley-Davidson 	0 	FXDWG 	... 	0 	TRUE 	4.7 	0 	12409 	Dealer 	Salvage 	False 	FALSE 	0.0

5356 rows × 22 columns

df.Mileage.fillna(df.Mileage.mean())#用均值填补。适用于数值型变量

0        16000.0
1           60.0
2        25763.0
3        33142.0
4        17800.0
5            0.0
6         5548.0
7        17868.0
8         2800.0
9         3000.0
10          30.0
11        5800.0
12       55000.0
13       57898.0
14       22102.0
15        7792.0
16        9305.0
17        1125.0
18        5500.0
19         250.0
20         140.0
21       25405.0
22       28888.0
23       23658.0
24       13089.0
25       23546.0
26       40000.0
27        3769.0
28        8700.0
29       16827.0
30       15000.0
31        2900.0
32       15200.0
33       10319.0
34       29544.0
35       10893.0
36       35735.0
37        9908.0
38        8950.0
39        5600.0
40       20000.0
41       55782.0
42        1350.0
43       15400.0
44        1533.0
45       22896.0
46       24742.0
47        1500.0
48       51000.0
49        6650.0
          ...   
7390     14000.0
7391      4470.0
7392      1617.0
7393      1873.0
7394         7.0
7395     16850.0
7398      5307.0
7399     22931.0
7404     15906.0
7405      7071.0
7406     68715.0
7409     20788.0
7410      3123.0
7411      3174.0
7413     70833.0
7414     32549.0
7417     14627.0
7418     35906.0
7419     16033.0
7420    122277.0
7422      6495.0
7423     21756.0
7424      4959.0
7427     27877.0
7428      5680.0
7429      4916.0
7430         0.0
7431     24245.0
7432     15272.0
7434     48129.0
7436     28510.0
7438     10326.0
7441     21183.0
7442     17410.0
7448     29541.0
7453      5468.0
7454     12333.0
7457     20060.0
7458         0.0
7463     45135.0
7464      2059.0
7467     41618.0
7468     52418.0
7469      2019.0
7474     23865.0
7478     20851.0
7479      2905.0
7482     29201.0
7484     12583.0
7486      9305.0
Name: Mileage, Length: 5356, dtype: float64

df.columns

​

Index(['Condition', 'Condition_Desc', 'Price', 'Location', 'Model_Year',
       'Mileage', 'Exterior_Color', 'Make', 'Warranty', 'Model', 'Sub_Model',
       'Type', 'Vehicle_Title', 'OBO', 'Feedback_Perc', 'Watch_Count',
       'N_Reviews', 'Seller_Status', 'Vehicle_Tile', 'Auction', 'Buy_Now',
       'Bid_Count'],
      dtype='object')

df[df['Exterior_Color'].isnull()]#缺失‘外观颜色’的行

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
14 	Used 	NaN 	$5,500 	Davenport, Iowa, United States 	2008.0 	22,102 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.3 	NaN 	244 	Private Seller 	Clear 	True 	FALSE 	16.0
35 	Used 	NaN 	$7,700 	Roselle, Illinois, United States 	2007.0 	10,893 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	236 	NaN 	Clear 	False 	TRUE 	NaN
41 	Used 	NaN 	$6,800 	Hampshire, Illinois, United States 	2003.0 	55,782 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	TRUE 	100 	2< 	298 	Private Seller 	Clear 	False 	TRUE 	NaN
55 	Used 	NaN 	$29,500 	Parma, Michigan, United States 	1950.0 	8,471 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	TRUE 	100 	24 	216 	NaN 	Clear 	False 	TRUE 	NaN
72 	Used 	NaN 	$6,500 	Bourbonnais, Illinois, United States 	1986.0 	55,300 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	2< 	1 	Private Seller 	Clear 	False 	TRUE 	NaN
79 	Used 	NaN 	$18,799 	Pekin, Illinois, United States 	2016.0 	3,400 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	6< 	2653 	NaN 	Clear 	False 	TRUE 	NaN
82 	Used 	2008 and its a show bike, everything on the fr... 	$500 	Columbus, Indiana, United States 	2008.0 	13,000 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	NaN 	3< 	76 	owner 	Clear 	True 	TRUE 	3.0
91 	Used 	NaN 	$6,950 	Addison, Illinois, United States 	2007.0 	20,000 	NaN 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	TRUE 	100 	2< 	8 	NaN 	Clear 	False 	TRUE 	NaN
98 	Used 	NaN 	$12,500 	McHenry, Illinois, United States 	2010.0 	30,200 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	1881 	NaN 	Clear 	True 	FALSE 	0.0
108 	Used 	NaN 	$9,500 	Hartland, Michigan, United States 	2008.0 	28,000 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	5< 	18 	owner 	Clear 	False 	TRUE 	NaN
114 	Used 	NaN 	$2,899 	Elkhart, Indiana, United States 	1975.0 	17,936 	NaN 	Honda 	Vehicle does NOT have an existing warranty 	Gold Wing 	... 	NaN 	FALSE 	100 	41 	3218 	Dealer 	Clear 	True 	TRUE 	0.0
118 	Used 	NaN 	$7,400 	Mount Sterling, Illinois, United States 	1999.0 	27,000 	NaN 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	107 	NaN 	Clear 	True 	FALSE 	29.0
134 	Used 	NaN 	$1,300 	Markleville, Indiana, United States 	1995.0 	1 	NaN 	Harley-Davidson 	NaN 	Dyna 	... 	NaN 	FALSE 	7.8 	NaN 	133 	NaN 	Clear 	True 	FALSE 	0.0
136 	Used 	NaN 	$2,200 	Thiensville, Wisconsin, United States 	1980.0 	35,200 	NaN 	Honda 	Vehicle does NOT have an existing warranty 	CB 	... 	NaN 	TRUE 	100 	15 	277 	NaN 	Clear 	False 	TRUE 	NaN
142 	Used 	NaN 	$19,600 	Pierre, South Dakota, United States 	2012.0 	25,976 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	40 	NaN 	Clear 	True 	FALSE 	59.0
146 	Used 	NaN 	$1,700 	Chicago, Illinois, United States 	1979.0 	1,600 	NaN 	Yamaha 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	162 	NaN 	Clear 	True 	FALSE 	0.0
148 	Used 	The cleanest 2009 Model you will find anywhere 	$12,500 	Milan, Michigan, United States 	2009.0 	3,435 	NaN 	BMW 	NaN 	R-Series 	... 	NaN 	FALSE 	9.8 	34 	34576 	Private Seller 	Clear 	False 	TRUE 	NaN
156 	Used 	NaN 	$19,600 	Pierre, South Dakota, United States 	2012.0 	25,976 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	40 	NaN 	Clear 	True 	FALSE 	59.0
159 	Used 	NaN 	$10,700 	Riverview, Michigan, United States 	2005.0 	4,300 	NaN 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	TRUE 	100 	8< 	651 	Private Seller 	Clear 	False 	TRUE 	NaN
163 	Used 	NaN 	$6,500 	Sycamore, Illinois, United States 	2008.0 	14,500 	NaN 	Harley-Davidson 	NaN 	Sportster 	... 	NaN 	TRUE 	100 	NaN 	13 	Private Seller 	Clear 	False 	TRUE 	NaN
171 	Used 	NaN 	$21,300 	Headland, Alabama, United States 	2015.0 	1,200 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	187 	Private Seller 	Clear 	True 	FALSE 	5.0
172 	Used 	NaN 	$8,200 	Milwaukee, Wisconsin, United States 	2007.0 	49,000 	NaN 	BMW 	NaN 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	40 	NaN 	Clear 	True 	FALSE 	0.0
175 	Used 	NaN 	$13,600 	Hagerstown, Maryland, United States 	1966.0 	18,441 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	110 	Private Seller 	Clear 	True 	FALSE 	23.0
184 	Used 	NaN 	$1,691 	Lebanon, Pennsylvania, United States 	1975.0 	8,603 	NaN 	Kawasaki 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	210 	NaN 	Clear 	True 	FALSE 	14.0
196 	Used 	NaN 	$12,600 	Rollinsford, New Hampshire, United States 	1983.0 	30 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	343 	NaN 	Clear 	True 	FALSE 	67.0
219 	Used 	NaN 	$1,691 	Lebanon, Pennsylvania, United States 	1975.0 	8,603 	NaN 	Kawasaki 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	210 	NaN 	Clear 	True 	FALSE 	14.0
232 	Used 	NaN 	$12,600 	Rollinsford, New Hampshire, United States 	1983.0 	30 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	343 	NaN 	Clear 	True 	FALSE 	67.0
249 	Used 	NaN 	$10,300 	New Madrid, Missouri, United States 	2017.0 	4,211 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	102 	Private Seller 	Clear 	True 	FALSE 	3.0
256 	Used 	NaN 	$6,000 	Douglas City, California, United States 	1996.0 	5,900 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	TRUE 	100 	8< 	738 	NaN 	Clear 	False 	TRUE 	NaN
276 	Used 	NaN 	$8,200 	Cortland, Ohio, United States 	2003.0 	10,298 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	15 	119 	Private Seller 	Clear 	False 	TRUE 	NaN
287 	Used 	NaN 	$10,995 	Jefferson City, Missouri, United States 	2001.0 	23,963 	NaN 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	592 	NaN 	Clear 	True 	FALSE 	0.0
289 	Used 	NaN 	$8,500 	Chillicothe, Ohio, United States 	1946.0 	25,000 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	9.7 	98 	1546 	NaN 	Clear 	True 	TRUE 	0.0
299 	Used 	NaN 	$11,700 	Monroe City, Indiana, United States 	2009.0 	2,700 	NaN 	Honda 	NaN 	Gold Wing 	... 	NaN 	FALSE 	100 	NaN 	76 	Private Seller 	Clear 	True 	FALSE 	39.0
304 	Used 	NaN 	$28,000 	Mesa, Arizona, United States 	2013.0 	5,000 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	6< 	571 	Private Seller 	Clear 	False 	TRUE 	NaN
310 	Used 	NaN 	$5,750 	Lake Worth, Florida, United States 	2005.0 	83,260 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	NaN 	7< 	59 	Private Seller 	Clear 	False 	TRUE 	NaN
327 	Used 	NaN 	$8,500 	Spring Hill, Florida, United States 	1972.0 	500 	NaN 	Harley-Davidson 	NaN 	Other 	... 	NaN 	TRUE 	100 	26 	2488 	NaN 	Clear 	False 	TRUE 	NaN
343 	Used 	Motorcycle is a 9.5 out of 10. Could be on the... 	$25,000 	Everett, Massachusetts, United States 	2015.0 	500 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	95 	Private Seller 	Clear 	True 	FALSE 	0.0
349 	Used 	NaN 	$1,025 	Staunton, Virginia, United States 	2017.0 	1,586 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	6< 	51 	NaN 	Clear 	True 	TRUE 	2.0
358 	Used 	Motorcycle is a 9.5 out of 10. Could be on the... 	$25,000 	Everett, Massachusetts, United States 	2015.0 	500 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	95 	Private Seller 	Clear 	True 	FALSE 	0.0
368 	Used 	NaN 	$1,025 	Staunton, Virginia, United States 	2017.0 	1,586 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	6< 	51 	NaN 	Clear 	True 	TRUE 	2.0
371 	Used 	NaN 	$31,500 	Lee, New Hampshire, United States 	2016.0 	554 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	2< 	352 	Dealer 	Clear 	False 	TRUE 	NaN
373 	Used 	NaN 	$28,990 	West Palm Beach, Florida, United States 	2015.0 	510 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	1156 	Dealer 	Clear 	True 	FALSE 	0.0
384 	Used 	NaN 	$18,500 	Bethlehem, Pennsylvania, United States 	1939.0 	600 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	141 	NaN 	Clear 	True 	FALSE 	0.0
392 	Used 	NaN 	$11,700 	Monroe City, Indiana, United States 	2009.0 	2,700 	NaN 	Honda 	NaN 	Gold Wing 	... 	NaN 	FALSE 	100 	NaN 	76 	Private Seller 	Clear 	True 	FALSE 	39.0
416 	Used 	Bike is like New! If you are interested in a B... 	$15,900 	Greenwood, South Carolina, United States 	1995.0 	12,107 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	49 	123 	Dealer 	Clear 	False 	TRUE 	NaN
434 	Used 	NaN 	$5,600 	Middletown, Connecticut, United States 	1994.0 	61,000 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	10 	791 	Private Seller 	Clear 	False 	TRUE 	NaN
437 	Used 	NaN 	$8,500 	Chillicothe, Ohio, United States 	1951.0 	34,039 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	9.7 	53 	1546 	NaN 	Clear 	True 	TRUE 	0.0
445 	Used 	NaN 	$8,099 	Fair Lawn, New Jersey, United States 	2005.0 	18,020 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	175 	Private Seller 	Clear 	True 	FALSE 	14.0
459 	Used 	NaN 	$5,600 	Middletown, Connecticut, United States 	1994.0 	61,000 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	10 	791 	Private Seller 	Clear 	False 	TRUE 	NaN
464 	Used 	NaN 	$8,500 	Chillicothe, Ohio, United States 	1951.0 	34,039 	NaN 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	9.7 	53 	1546 	NaN 	Clear 	True 	TRUE 	0.0
... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	...
5913 	Used 	NaN 	$685 	Warminster, Pennsylvania, United States 	1982.0 	0 	NaN 	Honda 	NaN 	cr 	... 	NaN 	FALSE 	100 	NaN 	254 	NaN 	Rebuilt, Rebuildable &amp; Reconstructed 	True 	FALSE 	4.0
5914 	Used 	NaN 	$9,000 	Old Saybrook, Connecticut, United States 	1980.0 	7,802 	NaN 	Other Makes 	NaN 	NaN 	... 	NaN 	FALSE 	100 	NaN 	1166 	NaN 	Clear 	True 	FALSE 	0.0
5917 	Used 	Only 9500 miles on cams still very good condition 	$120 	Ventura, California, United States 	2014.0 	9,500 	NaN 	Harley-Davidson 	NaN 	Dyna 	... 	NaN 	FALSE 	100 	NaN 	75 	NaN 	Salvage 	True 	TRUE 	0.0
5943 	Used 	See Pictures / Mileage Unknown 	$2,400 	North Hollywood, California, United States 	2009.0 	99,999 	NaN 	Suzuki 	NaN 	GSX-R 	... 	NaN 	TRUE 	9.6 	5< 	15713 	NaN 	Salvage 	False 	TRUE 	NaN
5951 	Used 	NaN 	$3,500 	Kitchener, Ontario, Canada 	1974.0 	56,771 	NaN 	Other Makes 	NaN 	NaN 	... 	NaN 	TRUE 	100 	20 	10 	NaN 	NaN 	False 	TRUE 	NaN
5955 	Used 	See Pictures / Mileage Unknown 	$2,400 	North Hollywood, California, United States 	2009.0 	99,999 	NaN 	Suzuki 	NaN 	GSX-R 	... 	NaN 	TRUE 	9.6 	5< 	15713 	NaN 	Salvage 	False 	TRUE 	NaN
5971 	Used 	See Pictures 	$3,700 	North Hollywood, California, United States 	2015.0 	6,815 	NaN 	Kawasaki 	NaN 	Ninja 	... 	NaN 	TRUE 	9.6 	NaN 	15713 	NaN 	Salvage 	False 	TRUE 	NaN
5973 	Used 	NaN 	$950 	Dundalk, Maryland, United States 	1975.0 	3,426 	NaN 	Yamaha 	Vehicle does NOT have an existing warranty 	RD 60 	... 	NaN 	FALSE 	100 	NaN 	801 	Private Seller 	Salvage 	True 	FALSE 	0.0
5992 	Used 	NaN 	$2,999 	Omaha, Nebraska, United States 	2007.0 	15,000 	NaN 	BMW 	NaN 	F-Series 	... 	NaN 	TRUE 	100 	6< 	448 	NaN 	Salvage 	False 	TRUE 	NaN
6005 	Used 	NaN 	$7,000 	Pleasantville, New Jersey, United States 	1998.0 	2,200 	NaN 	CR500R 	NaN 	NaN 	... 	NaN 	FALSE 	100 	6< 	167 	NaN 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	TRUE 	NaN
6013 	Used 	NaN 	$11,334 	Boring, Oregon, United States 	1923.0 	999,999 	NaN 	Indian 	Vehicle does NOT have an existing warranty 	scout 	... 	NaN 	FALSE 	100 	NaN 	137 	Private Seller 	Salvage 	True 	FALSE 	52.0
6019 	Used 	Bike is a ONE OWNER and garage kept since new ... 	$3,750 	Airville, Pennsylvania, United States 	2008.0 	1,755 	NaN 	Honda 	NaN 	XR 	... 	NaN 	TRUE 	100 	6< 	2951 	NaN 	Clear 	False 	TRUE 	NaN
6021 	Used 	Bike is a ONE OWNER and garage kept since new ... 	$4,750 	Airville, Pennsylvania, United States 	2014.0 	1,755 	NaN 	Honda 	NaN 	XR 	... 	NaN 	TRUE 	100 	7< 	2951 	NaN 	Clear 	False 	TRUE 	NaN
6029 	Used 	NaN 	$900 	Cold Spring, New York, United States 	1964.0 	3,908 	NaN 	Yamaha 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	1< 	80 	Private Seller 	Salvage 	True 	TRUE 	0.0
6049 	Used 	Original 	$260 	Monroe City, Missouri, United States 	1973.0 	5,991 	NaN 	Honda 	NaN 	XL 	... 	NaN 	FALSE 	100 	8< 	1375 	NaN 	Rebuilt, Rebuildable &amp; Reconstructed 	True 	TRUE 	0.0
6051 	Used 	NaN 	$2,000 	Westminster, Maryland, United States 	1971.0 	NaN 	NaN 	Yamaha 	NaN 	DT1 250 	... 	NaN 	TRUE 	100 	5< 	4 	NaN 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	TRUE 	NaN
6054 	Used 	NaN 	$12,000 	Mount Vernon, New York, United States 	2010.0 	20,000 	NaN 	Other Makes 	NaN 	NaN 	... 	NaN 	TRUE 	100 	NaN 	149 	NaN 	Clear 	False 	TRUE 	NaN
6065 	Used 	NaN 	$18,500 	Greenwood, Arkansas, United States 	2010.0 	8,800 	NaN 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	NaN 	1< 	0 	Private Seller 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	TRUE 	NaN
6106 	Used 	NaN 	$2,600 	Charlotte, North Carolina, United States 	2003.0 	1,193 	NaN 	Custom Built Motorcycles 	Vehicle does NOT have an existing warranty 	Chopper 	... 	NaN 	FALSE 	100 	NaN 	144 	Private Seller 	Rebuilt, Rebuildable &amp; Reconstructed 	True 	FALSE 	18.0
6109 	Used 	NaN 	$3,500 	Lee&#039;s Summit, United States 	2011.0 	2,000 	NaN 	Kawasaki 	NaN 	KLR 	... 	NaN 	FALSE 	NaN 	7< 	1 	NaN 	NaN 	False 	TRUE 	NaN
6120 	Used 	In need of full restoration 	$1,500 	Stockton, California, United States 	1986.0 	10,808 	NaN 	Honda 	Vehicle does NOT have an existing warranty 	Rebel 	... 	NaN 	TRUE 	6.5 	NaN 	998 	Private Seller 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	TRUE 	NaN
6144 	Used 	We are selling a Victory Judge 2013, customize... 	$14,500 	Levis, Quebec, Canada 	NaN 	NaN 	NaN 	NaN 	NaN 	NaN 	... 	NaN 	TRUE 	100 	15 	196 	NaN 	NaN 	False 	TRUE 	NaN
6149 	Used 	NaN 	$6,000 	Leesburg, Florida, United States 	2015.0 	65 	NaN 	Husqvarna 	NaN 	FC450 	... 	NaN 	TRUE 	100 	2< 	15 	Private Seller 	Salvage 	False 	TRUE 	NaN
6163 	Used 	Used bike not running 	$4,867 	Dallas, Texas, United States 	1977.0 	14,999 	NaN 	Benelli 	Vehicle does NOT have an existing warranty 	750 Sei 	... 	NaN 	FALSE 	100 	29 	1111 	Dealer 	Salvage 	True 	TRUE 	9.0
6164 	Used 	NaN 	$10,000 	Mascouche, Quebec, Canada 	NaN 	NaN 	NaN 	NaN 	NaN 	NaN 	... 	NaN 	TRUE 	100 	NaN 	3 	NaN 	NaN 	False 	TRUE 	NaN
6167 	Used 	NaN 	$750 	Elkton, Virginia, United States 	1967.0 	0 	NaN 	Ducati 	NaN 	Cadet 100 	... 	NaN 	FALSE 	NaN 	NaN 	79 	Private Seller 	Rebuilt, Rebuildable &amp; Reconstructed 	True 	FALSE 	0.0
6168 	Used 	NaN 	$1,950 	Charlottesville, Virginia, United States 	1987.0 	21,900 	NaN 	Suzuki 	None 	SV 	... 	NaN 	FALSE 	100 	2< 	2 	Private Seller 	Clear 	False 	TRUE 	NaN
6169 	Used 	NaN 	$3,100 	Denver, Colorado, United States 	1979.0 	12,345 	NaN 	Can-Am 	Vehicle does NOT have an existing warranty 	NaN 	... 	NaN 	TRUE 	9.1 	15 	222 	NaN 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	TRUE 	NaN
6171 	Used 	NaN 	$4,300 	Chandler, Arizona, United States 	2003.0 	8,300 	NaN 	Kawasaki 	Vehicle does NOT have an existing warranty 	Vulcan 	... 	NaN 	TRUE 	NaN 	5< 	0 	Private Seller 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	TRUE 	NaN
6178 	Used 	NaN 	$4,400 	Villa Park, California, United States 	2009.0 	16,000 	NaN 	Aprilia 	NaN 	NaN 	... 	NaN 	TRUE 	100 	7< 	179 	NaN 	Salvage 	False 	TRUE 	NaN
6184 	Used 	NaN 	$5,995 	Terrebonne, Quebec, Canada 	NaN 	NaN 	NaN 	NaN 	NaN 	NaN 	... 	NaN 	FALSE 	NaN 	4< 	0 	NaN 	NaN 	False 	TRUE 	NaN
6187 	Used 	NaN 	$7,900 	Wantagh, New York, United States 	2001.0 	7,633 	NaN 	Bourget 	NaN 	NaN 	... 	NaN 	TRUE 	100 	2< 	870 	NaN 	Salvage 	False 	TRUE 	NaN
6188 	Used 	NaN 	$4,000 	Chandler, Arizona, United States 	2003.0 	8,300 	NaN 	Kawasaki 	Vehicle does NOT have an existing warranty 	Vulcan 	... 	NaN 	TRUE 	NaN 	NaN 	0 	Private Seller 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	TRUE 	NaN
6208 	Used 	NaN 	$3,000 	Gainesville, Texas, United States 	1949.0 	0 	NaN 	Cushman 	Vehicle does NOT have an existing warranty 	Package Kar 	... 	NaN 	FALSE 	100 	NaN 	126 	Private Seller 	Rebuilt, Rebuildable &amp; Reconstructed 	True 	FALSE 	0.0
6216 	Used 	NaN 	$3,000 	Georgetown, Ontario, Canada 	2001.0 	3,500 	NaN 	Yamaha 	NaN 	YZF 	... 	NaN 	FALSE 	NaN 	4< 	0 	NaN 	NaN 	False 	TRUE 	NaN
6223 	Used 	Refinished 	$99 	Chico, California, United States 	1968.0 	NaN 	NaN 	Bultaco 	NaN 	5-speed models 	... 	NaN 	FALSE 	100 	NaN 	296 	Private Seller 	Salvage 	True 	FALSE 	0.0
6226 	Used 	NaN 	$6,555 	Mundelein, Illinois, United States 	2006.0 	15,251 	NaN 	Honda 	NaN 	Other 	... 	NaN 	TRUE 	>80 	NaN 	442 	Dealer 	Clear 	False 	FALSE 	NaN
6228 	Used 	100% RECONSTRUCTION 	$16,000 	Praha, Czech Republic 	1968.0 	0 	NaN 	Ural 	NaN 	IMZ 	... 	NaN 	FALSE 	8.6 	NaN 	106 	NaN 	Rebuilt, Rebuildable &amp; Reconstructed 	True 	FALSE 	0.0
6232 	Used 	NaN 	$51,995 	Charlotte, North Carolina, United States 	2012.0 	6,685 	NaN 	Harley-Davidson 	Vehicle has an existing warranty 	Other 	... 	NaN 	TRUE 	8.2 	NaN 	80 	Dealer 	Clear 	False 	FALSE 	NaN
6277 	Used 	NaN 	$3,999 	Miami, Florida, United States 	2008.0 	5,099 	NaN 	Kawasaki 	NaN 	Other 	... 	NaN 	TRUE 	100 	NaN 	51 	Dealer 	Clear 	False 	FALSE 	NaN
6348 	Used 	NaN 	$4,990 	Villa Park, Illinois, United States 	2003.0 	0 	NaN 	Suzuki 	NaN 	GSX-R 	... 	NaN 	TRUE 	NaN 	NaN 	647 	Dealer 	Clear 	False 	FALSE 	NaN
6934 	Used 	NaN 	$11,500 	Pori, default, Finland 	2014.0 	190,000 	NaN 	Other Makes 	NaN 	316i 	... 	NaN 	FALSE 	NaN 	NaN 	0 	Private Seller 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	TRUE 	NaN
7237 	Used 	NaN 	$3,900 	London, Kentucky, United States 	2007.0 	9,829 	NaN 	Hyosung 	NaN 	Aquila 	... 	NaN 	TRUE 	3.3 	NaN 	309 	Dealer 	Clear 	False 	FALSE 	NaN
7320 	Used 	NaN 	$300 	Charlottetown, Prince Edward Island, Canada 	2013.0 	111,111 	NaN 	Victory 	NaN 	NaN 	... 	NaN 	TRUE 	NaN 	8< 	0 	NaN 	NaN 	False 	TRUE 	NaN
7321 	Used 	NaN 	$250 	Charlottetown, Prince Edward Island, Canada 	2013.0 	111,111 	NaN 	Victory 	NaN 	NaN 	... 	NaN 	TRUE 	NaN 	2< 	0 	NaN 	NaN 	False 	TRUE 	NaN
7322 	Used 	NaN 	$300 	Charlottetown, Prince Edward Island, Canada 	2013.0 	111,111 	NaN 	Victory 	NaN 	NaN 	... 	NaN 	TRUE 	NaN 	4< 	0 	NaN 	NaN 	False 	TRUE 	NaN
7348 	Used 	NaN 	$1,000 	Holbrook, New York, United States 	2002.0 	1,775 	NaN 	Honda 	Vehicle does NOT have an existing warranty 	CBR 	... 	NaN 	FALSE 	8.4 	NaN 	769 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	True 	FALSE 	0.0
7415 	Used 	NaN 	$4,300 	Raymond, New Hampshire, United States 	2006.0 	50,572 	NaN 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7440 	Used 	Please feel free to contact me if you have any... 	$4,900 	Raymond, New Hampshire, United States 	2007.0 	16,949 	NaN 	Yamaha 	NaN 	YZF-R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7484 	Used 	NaN 	$5,000 	Raymond, New Hampshire, United States 	2004.0 	12,583 	NaN 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN

715 rows × 22 columns

df['Exterior_Color'].mode()#求众数，因为众数不止一个，所以返回的是一个列表

0    Black
dtype: object

df['Exterior_Color'].mode()[0]

'Black'

#对于字符型或者字符串型变量，习惯用众数填补

df['Exterior_Color'].fillna(df['Exterior_Color'].mode()[0])

0                              Black
1                              Black
2                        Silver/Blue
3                                Red
4                               Blue
5                                Red
6       Grey / Red / Silver Metallic
7                              Black
8                         Cherry Red
9                              Black
10                          Burgundy
11                             Black
12                RICH RED W/STRIPES
13                   Luxury Rich Red
14                             Black
15                               Red
16                             White
17                              Blue
18                               Red
19                             Black
20                             Black
21                             Black
22                  Black &amp; Blue
23                            Purple
24                             Black
25                              Blue
26                               Red
27                   Red Hot Sun Glo
28                          Burgundy
29                             Black
30                  Kandy brandywine
31                              Blue
32                               Red
33                             Black
34                              Blue
35                             Black
36                             Black
37                               Red
38                          Burgundy
39                             Black
40                             Black
41                             Black
42                             Black
43                             Black
44                             Black
45               Blue/Green Metallic
46                       Vivid Black
47                             Black
48                             Black
49                             Black
                    ...             
7443                           Black
7444                            Gray
7445                             Red
7446                            Gray
7447                           Black
7448                        Burgundy
7449                           Black
7450                           Black
7451                          maroon
7452                            Blue
7453                        TWO TONE
7454                             Red
7455                           Black
7456                          Orange
7457                           Black
7458                            Blue
7459                           Black
7460                           Black
7461                            Gray
7462                            Blue
7463                          Orange
7464                           Black
7465                           Black
7466                            Blue
7467                            Blue
7468                           White
7469                           Black
7470                           White
7471                             Red
7472                        TWO TONE
7473                           White
7474                            Blue
7475                            Blue
7476                            Blue
7477                           Black
7478                           Brown
7479                           Black
7480                           Green
7481                           Black
7482                           Black
7483                          Purple
7484                           Black
7485                           Black
7486                           Black
7487                            Gray
7488                           Black
7489                           Black
7490                             Red
7491                        TWO TONE
7492                            Gray
Name: Exterior_Color, Length: 7493, dtype: object

df['Mileage'].median()

7083.0

df.fillna(value = {'Exterior_Color':'Balck', 'Mileage':7083.0})#用字典的形式填补###元数据生效：inplace = True

	Condition 	Condition_Desc 	Price 	Location 	Model_Year 	Mileage 	Exterior_Color 	Make 	Warranty 	Model 	... 	Vehicle_Title 	OBO 	Feedback_Perc 	Watch_Count 	N_Reviews 	Seller_Status 	Vehicle_Tile 	Auction 	Buy_Now 	Bid_Count
0 	Used 	mint!!! very low miles 	11412.0 	McHenry, Illinois, United States 	2013.0 	16000.0 	Black 	Harley-Davidson 	Unspecified 	Touring 	... 	NaN 	FALSE 	8.1 	NaN 	2427 	Private Seller 	Clear 	True 	FALSE 	28.0
1 	Used 	Perfect condition 	17200.0 	Fort Recovery, Ohio, United States 	2016.0 	60.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	17 	657 	Private Seller 	Clear 	True 	TRUE 	0.0
2 	Used 	NaN 	3872.0 	Chicago, Illinois, United States 	1970.0 	25763.0 	Silver/Blue 	BMW 	Vehicle does NOT have an existing warranty 	R-Series 	... 	NaN 	FALSE 	100 	NaN 	136 	NaN 	Clear 	True 	FALSE 	26.0
3 	Used 	CLEAN TITLE READY TO RIDE HOME 	6575.0 	Green Bay, Wisconsin, United States 	2009.0 	33142.0 	Red 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	2920 	Dealer 	Clear 	True 	FALSE 	11.0
4 	Used 	NaN 	10000.0 	West Bend, Wisconsin, United States 	2012.0 	17800.0 	Blue 	Harley-Davidson 	NO WARRANTY 	Touring 	... 	NaN 	FALSE 	100 	13 	271 	OWNER 	Clear 	True 	TRUE 	0.0
5 	Used 	It&#039;s a &#039;72 in good shape 	1500.0 	Watervliet, Michigan, United States 	1972.0 	0.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	NaN 	412 	Private Seller 	Clear 	True 	FALSE 	1.0
6 	Used 	NaN 	24900.0 	Sterling, Illinois, United States 	2010.0 	5548.0 	Grey / Red / Silver Metallic 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	9.8 	NaN 	6229 	Dealer 	Clear 	True 	FALSE 	1.0
7 	Used 	NaN 	1400.0 	Williamston, Michigan, United States 	1975.0 	17868.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	9.7 	NaN 	1159 	Private Seller 	Clear 	True 	FALSE 	6.0
8 	Used 	NaN 	5100.0 	Palatine, Illinois, United States 	2014.0 	2800.0 	Cherry Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	NaN 	16 	3 	Private Seller 	Clear 	True 	TRUE 	6.0
9 	Used 	NaN 	8000.0 	Chicago, Illinois, United States 	2015.0 	3000.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Sportster 	... 	NaN 	FALSE 	NaN 	NaN 	1 	Private Seller 	Clear 	True 	FALSE 	0.0
10 	Used 	NaN 	2125.0 	Williamston, Michigan, United States 	1978.0 	30.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.7 	NaN 	1159 	Private Seller 	Clear 	True 	FALSE 	4.0
11 	Used 	NaN 	11100.0 	Oak Park, Illinois, United States 	2011.0 	5800.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	83 	Private Seller 	Clear 	True 	FALSE 	21.0
12 	Used 	NaN 	1125.0 	Pewaukee, Wisconsin, United States 	2002.0 	55000.0 	RICH RED W/STRIPES 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	128 	Private Seller 	Clear 	True 	FALSE 	5.0
13 	Used 	Overall, this bike is in good condition for it... 	3550.0 	Madison, Wisconsin, United States 	2000.0 	57898.0 	Luxury Rich Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	NaN 	FALSE 	100 	NaN 	10701 	Dealer 	Clear 	True 	FALSE 	2.0
14 	Used 	NaN 	5500.0 	Davenport, Iowa, United States 	2008.0 	22102.0 	Balck 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	9.3 	NaN 	244 	Private Seller 	Clear 	True 	FALSE 	16.0
15 	Used 	NaN 	9000.0 	Plymouth, Indiana, United States 	2010.0 	7792.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	299 	Private Seller 	Clear 	True 	FALSE 	3.0
16 	Used 	NaN 	8100.0 	Goshen, Indiana, United States 	1973.0 	9305.0 	White 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Other 	... 	NaN 	FALSE 	100 	NaN 	300 	Private Seller 	Clear 	True 	FALSE 	25.0
17 	Used 	Absolutely perfect condition 	14000.0 	Plainfield, Indiana, United States 	2016.0 	1125.0 	Blue 	Harley-Davidson 	Vehicle has an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	170 	Private Seller 	Clear 	True 	FALSE 	0.0
18 	Used 	NaN 	20000.0 	Bellevue, Iowa, United States 	2015.0 	5500.0 	Red 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	8< 	66 	Private Seller 	Clear 	False 	TRUE 	NaN
19 	New 	NaN 	13000.0 	Des Plaines, Illinois, United States 	2016.0 	250.0 	Black 	Harley-Davidson 	Unspecified 	Softail 	... 	NaN 	FALSE 	100 	23 	181 	Private Seller 	Clear 	True 	TRUE 	0.0
20 	New 	NaN 	10900.0 	Ottawa, Illinois, United States 	2017.0 	140.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	NaN 	3172 	Private Seller 	Clear 	False 	TRUE 	NaN
21 	Used 	IN AWESOME CONDITION. SUPER RARE. JUST SERVIC... 	9999.0 	Orland Park, Illinois, United States 	2005.0 	25405.0 	Black 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	283 	Dealer 	Clear 	True 	FALSE 	0.0
22 	Used 	NaN 	5700.0 	Cross Plains, Wisconsin, United States 	1982.0 	28888.0 	Black &amp; Blue 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	947 	Private Seller 	Clear 	True 	FALSE 	0.0
23 	Used 	NaN 	7400.0 	Watervliet, Michigan, United States 	2001.0 	23658.0 	Purple 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	412 	Private Seller 	Clear 	True 	FALSE 	0.0
24 	Used 	NaN 	26500.0 	Kewanee, Illinois, United States 	2016.0 	13089.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	15 	6 	Private Seller 	Clear 	False 	TRUE 	NaN
25 	Used 	NaN 	9850.0 	Chicago, Illinois, United States 	2003.0 	23546.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	FALSE 	100 	NaN 	12 	Private Seller 	Clear 	True 	FALSE 	0.0
26 	Used 	NaN 	45900.0 	South Haven, Michigan, United States 	2009.0 	40000.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	25 	199 	Private Seller 	Clear 	False 	TRUE 	NaN
27 	Used 	Almost new 2009 Harley-Davidson FLHR Road Ki... 	10600.0 	Wheeling, Illinois, United States 	2009.0 	3769.0 	Red Hot Sun Glo 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	22 	175 	Private Seller 	Clear 	False 	TRUE 	NaN
28 	Used 	*2008 Harley Davidson Rocker C *Chrome Chrome ... 	12000.0 	Chicago, Illinois, United States 	2008.0 	8700.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	11 	Private Seller 	Clear 	True 	FALSE 	0.0
29 	Used 	NaN 	20000.0 	Chicago, Illinois, United States 	2011.0 	16827.0 	Black 	Harley-Davidson 	NaN 	TRIKE 	... 	NaN 	TRUE 	NaN 	31 	17 	Private Seller 	Clear 	False 	TRUE 	NaN
30 	Used 	Very clean and well maintained 	25000.0 	Summit-Argo, Illinois, United States 	2010.0 	15000.0 	Kandy brandywine 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	1< 	18 	Private Seller 	Clear 	True 	TRUE 	0.0
31 	Used 	NaN 	20000.0 	Coldwater, Michigan, United States 	2014.0 	2900.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	142 	Private Seller 	Clear 	True 	FALSE 	0.0
32 	Used 	NaN 	11000.0 	Elkhart, Indiana, United States 	2007.0 	15200.0 	Red 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	NaN 	12 	28 	Private Seller 	Clear 	False 	TRUE 	NaN
33 	Used 	NaN 	8500.0 	Glenview NAS, Illinois, United States 	2008.0 	10319.0 	Black 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	100 	8< 	324 	Private Seller 	Clear 	False 	TRUE 	NaN
34 	Used 	NaN 	18000.0 	Fox River Grove, Illinois, United States 	2010.0 	29544.0 	Blue 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	NaN 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
35 	Used 	NaN 	7700.0 	Roselle, Illinois, United States 	2007.0 	10893.0 	Balck 	Harley-Davidson 	NaN 	Other 	... 	NaN 	FALSE 	100 	NaN 	236 	NaN 	Clear 	False 	TRUE 	NaN
36 	Used 	NaN 	2750.0 	Belvidere, Illinois, United States 	2007.0 	35735.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	FLH 	... 	NaN 	FALSE 	100 	NaN 	100 	Belvidere Police Department 	Clear 	True 	FALSE 	19.0
37 	Used 	Year2005 ManufacturerHarley-Davidson ModelScre... 	10895.0 	Kalamazoo, Michigan, United States 	2005.0 	9908.0 	Red 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	FALSE 	100 	NaN 	1522 	Private Seller 	Clear 	True 	FALSE 	0.0
38 	Used 	No Reserve! 	6700.0 	Tinley Park, Illinois, United States 	2004.0 	8950.0 	Burgundy 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	100 	NaN 	126 	Private Seller 	Clear 	True 	FALSE 	0.0
39 	Used 	NaN 	18000.0 	Batavia, Illinois, United States 	2015.0 	5600.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	63 	Private Seller 	Clear 	True 	FALSE 	0.0
40 	Used 	NaN 	7300.0 	Rolling Meadows, Illinois, United States 	1997.0 	20000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	TRUE 	100 	5< 	111 	Private Seller 	Clear 	False 	TRUE 	NaN
41 	Used 	NaN 	6800.0 	Hampshire, Illinois, United States 	2003.0 	55782.0 	Balck 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	TRUE 	100 	2< 	298 	Private Seller 	Clear 	False 	TRUE 	NaN
42 	Used 	Dent and scratch free. Paint and chrome in exc... 	5000.0 	South Bend, Indiana, United States 	2003.0 	1350.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	14 	37 	Private Seller 	Clear 	False 	TRUE 	NaN
43 	Used 	Excellent condition gently used. Adult driven 	13200.0 	Algonquin, Illinois, United States 	2011.0 	15400.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	NaN 	478 	Private Seller 	Clear 	True 	FALSE 	0.0
44 	Used 	Excellent condition 	11400.0 	Indianapolis, Indiana, United States 	2012.0 	1533.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	FALSE 	100 	4< 	79 	Dealer 	Clear 	False 	TRUE 	NaN
45 	Used 	NaN 	3250.0 	Valparaiso, Indiana, United States 	2003.0 	22896.0 	Blue/Green Metallic 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Sportster 	... 	NaN 	FALSE 	100 	9< 	109 	Private Seller 	Clear 	True 	TRUE 	11.0
46 	Used 	This is a nice looking Road King. Paint and ch... 	8000.0 	Madison, Wisconsin, United States 	2012.0 	24742.0 	Vivid Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty. AS... 	Touring 	... 	NaN 	FALSE 	100 	NaN 	10701 	Dealer 	Clear 	True 	FALSE 	0.0
47 	Used 	NaN 	17800.0 	Webberville, Michigan, United States 	2016.0 	1500.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	4< 	33 	Private Seller 	Clear 	False 	TRUE 	NaN
48 	Used 	NaN 	8500.0 	Rockford, Illinois, United States 	2003.0 	51000.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Touring 	... 	NaN 	TRUE 	100 	8< 	124 	Private Seller 	Clear 	False 	TRUE 	NaN
49 	Used 	NaN 	4050.0 	Gilberts, Illinois, United States 	2006.0 	6650.0 	Black 	Harley-Davidson 	Vehicle does NOT have an existing warranty 	Softail 	... 	NaN 	FALSE 	NaN 	7< 	58 	Private Seller 	Clear 	True 	TRUE 	3.0
... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	... 	...
7443 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2012.0 	0.0 	Black 	Harley-Davidson 	NaN 	FXDBI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7444 	Used 	NaN 	5900.0 	Raymond, New Hampshire, United States 	2013.0 	7337.0 	Gray 	Yamaha 	NaN 	YZF-R6 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7445 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2016.0 	2669.0 	Red 	Harley-Davidson 	NaN 	XG750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7446 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2016.0 	23440.0 	Gray 	Kawasaki 	NaN 	Z1000 G 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7447 	Used 	NaN 	23499.0 	Suncook, New Hampshire, United States 	2015.0 	16927.0 	Black 	Harley-Davidson 	NaN 	FLHTK ELECTRA GLIDE ULTRA LIMITED 	... 	NaN 	TRUE 	100 	NaN 	1978 	Dealer 	Clear 	False 	FALSE 	NaN
7448 	Used 	Please feel free to contact me if you have any... 	6500.0 	Raymond, New Hampshire, United States 	2007.0 	29541.0 	Burgundy 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7449 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2008.0 	11388.0 	Black 	Harley-Davidson 	NaN 	FXDF 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7450 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2006.0 	28117.0 	Black 	Kawasaki 	NaN 	ZX-10R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7451 	Used 	NaN 	5200.0 	Raymond, New Hampshire, United States 	2006.0 	12876.0 	maroon 	Suzuki 	NaN 	GSX1300R 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7452 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2003.0 	66219.0 	Blue 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7453 	Used 	Please feel free to contact me if you have any... 	8300.0 	Raymond, New Hampshire, United States 	2011.0 	5468.0 	TWO TONE 	Harley-Davidson 	NaN 	Softail 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7454 	Used 	NaN 	7400.0 	Raymond, New Hampshire, United States 	2013.0 	12333.0 	Red 	Harley-Davidson 	NaN 	FLD103 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7455 	Used 	NaN 	4700.0 	Raymond, New Hampshire, United States 	2015.0 	424.0 	Black 	Suzuki 	NaN 	GSX-S750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7456 	Used 	NaN 	4900.0 	Raymond, New Hampshire, United States 	2009.0 	7552.0 	Orange 	Yamaha 	NaN 	YZF-R6 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7457 	Used 	NaN 	8500.0 	Raymond, New Hampshire, United States 	2008.0 	20060.0 	Black 	Harley-Davidson 	NaN 	FXCW 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7458 	Used 	NaN 	9200.0 	Raymond, New Hampshire, United States 	2012.0 	0.0 	Blue 	Harley-Davidson 	NaN 	FLTRX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7459 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	19268.0 	Black 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7460 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2014.0 	703.0 	Black 	Suzuki 	NaN 	GSX-R1000 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7461 	Used 	NaN 	4200.0 	Raymond, New Hampshire, United States 	2008.0 	5883.0 	Gray 	Yamaha 	NaN 	XV1700 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7462 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2006.0 	32267.0 	Blue 	Harley-Davidson 	NaN 	FLSTFI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7463 	Used 	NaN 	7800.0 	Raymond, New Hampshire, United States 	2008.0 	45135.0 	Orange 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7464 	Used 	NaN 	4400.0 	Raymond, New Hampshire, United States 	2015.0 	2059.0 	Black 	Suzuki 	NaN 	GSX-S750 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7465 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2012.0 	11679.0 	Black 	Harley-Davidson 	NaN 	FXDCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7466 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2016.0 	1389.0 	Blue 	Suzuki 	NaN 	GSX-R600 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7467 	Used 	Salvage Rebuildable Repairable No Reserve NR 	7400.0 	Raymond, New Hampshire, United States 	2008.0 	41618.0 	Blue 	Harley-Davidson 	NaN 	Touring 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7468 	Used 	NaN 	8800.0 	Raymond, New Hampshire, United States 	2008.0 	52418.0 	White 	Harley-Davidson 	NaN 	FLHXI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7469 	Used 	NaN 	13570.0 	Scott City, Missouri, United States 	2016.0 	2019.0 	Black 	Harley-Davidson 	Vehicle has an existing warranty 	Dyna Fat Bob 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN
7470 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2007.0 	64724.0 	White 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7471 	Used 	NaN 	6200.0 	Raymond, New Hampshire, United States 	2005.0 	55993.0 	Red 	Harley-Davidson 	NaN 	FLHTCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7472 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2005.0 	32560.0 	TWO TONE 	Harley-Davidson 	NaN 	FLSTNI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7473 	Used 	NaN 	5500.0 	Raymond, New Hampshire, United States 	2000.0 	87123.0 	White 	Harley-Davidson 	NaN 	FLSTC 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7474 	Used 	NaN 	3400.0 	Raymond, New Hampshire, United States 	2006.0 	23865.0 	Blue 	Harley-Davidson 	NaN 	XL 883C 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7475 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	56633.0 	Blue 	Harley-Davidson 	NaN 	FXD 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7476 	Used 	NaN 	8500.0 	Raymond, New Hampshire, United States 	2010.0 	36780.0 	Blue 	Harley-Davidson 	NaN 	FLHTCUI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7477 	Used 	NaN 	4900.0 	Raymond, New Hampshire, United States 	2002.0 	22709.0 	Black 	Harley-Davidson 	NaN 	FXDL 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7478 	Used 	NaN 	9900.0 	Raymond, New Hampshire, United States 	2011.0 	20851.0 	Brown 	Harley-Davidson 	NaN 	FLTRU 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7479 	Used 	NaN 	2900.0 	Raymond, New Hampshire, United States 	2013.0 	2905.0 	Black 	Suzuki 	NaN 	SV 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7480 	Used 	NaN 	6500.0 	Raymond, New Hampshire, United States 	2016.0 	1701.0 	Green 	Harley-Davidson 	NaN 	XL 883N 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7481 	Used 	NaN 	10500.0 	Raymond, New Hampshire, United States 	2013.0 	16231.0 	Black 	Harley-Davidson 	NaN 	FLTRX 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Rebuilt, Rebuildable &amp; Reconstructed 	False 	FALSE 	NaN
7482 	Used 	NaN 	7200.0 	Raymond, New Hampshire, United States 	2006.0 	29201.0 	Black 	Harley-Davidson 	NaN 	FLTRI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7483 	Used 	NaN 	7500.0 	Raymond, New Hampshire, United States 	2007.0 	28716.0 	Purple 	Harley-Davidson 	NaN 	FLHRCI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7484 	Used 	NaN 	5000.0 	Raymond, New Hampshire, United States 	2004.0 	12583.0 	Balck 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7485 	Used 	NaN 	5000.0 	Raymond, New Hampshire, United States 	2006.0 	19931.0 	Black 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7486 	Used 	NaN 	8900.0 	Raymond, New Hampshire, United States 	2012.0 	9305.0 	Black 	Harley-Davidson 	NaN 	FXDWG 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7487 	Used 	Please feel free to contact me if you have any... 	4900.0 	Raymond, New Hampshire, United States 	2013.0 	3475.0 	Gray 	Suzuki 	NaN 	Boulevard 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7488 	Used 	NaN 	3900.0 	Raymond, New Hampshire, United States 	2004.0 	23681.0 	Black 	Harley-Davidson 	NaN 	FXDI 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7489 	Used 	NaN 	8900.0 	Raymond, New Hampshire, United States 	2013.0 	5821.0 	Black 	Suzuki 	NaN 	GSX1300RA 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7490 	Used 	NaN 	7800.0 	Raymond, New Hampshire, United States 	2011.0 	48616.0 	Red 	BMW 	NaN 	R1200GS 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7491 	Used 	NaN 	7900.0 	Raymond, New Hampshire, United States 	2014.0 	6185.0 	TWO TONE 	Yamaha 	NaN 	YZF-R1 	... 	NaN 	TRUE 	4.7 	NaN 	12409 	Dealer 	Salvage 	False 	FALSE 	NaN
7492 	Used 	NaN 	12970.0 	Scott City, Missouri, United States 	2016.0 	448.0 	Gray 	Harley-Davidson 	Vehicle has an existing warranty 	Dyna Street Bob 	... 	NaN 	FALSE 	100 	NaN 	4 	Dealer 	Clear 	False 	FALSE 	NaN

7493 rows × 22 columns

df['Exterior_Color']#第14行是空值

0                              Black
1                              Black
2                        Silver/Blue
3                                Red
4                               Blue
5                                Red
6       Grey / Red / Silver Metallic
7                              Black
8                         Cherry Red
9                              Black
10                          Burgundy
11                             Black
12                RICH RED W/STRIPES
13                   Luxury Rich Red
14                               NaN
15                               Red
16                             White
17                              Blue
18                               Red
19                             Black
20                             Black
21                             Black
22                  Black &amp; Blue
23                            Purple
24                             Black
25                              Blue
26                               Red
27                   Red Hot Sun Glo
28                          Burgundy
29                             Black
30                  Kandy brandywine
31                              Blue
32                               Red
33                             Black
34                              Blue
35                               NaN
36                             Black
37                               Red
38                          Burgundy
39                             Black
40                             Black
41                               NaN
42                             Black
43                             Black
44                             Black
45               Blue/Green Metallic
46                       Vivid Black
47                             Black
48                             Black
49                             Black
                    ...             
7443                           Black
7444                            Gray
7445                             Red
7446                            Gray
7447                           Black
7448                        Burgundy
7449                           Black
7450                           Black
7451                          maroon
7452                            Blue
7453                        TWO TONE
7454                             Red
7455                           Black
7456                          Orange
7457                           Black
7458                            Blue
7459                           Black
7460                           Black
7461                            Gray
7462                            Blue
7463                          Orange
7464                           Black
7465                           Black
7466                            Blue
7467                            Blue
7468                           White
7469                           Black
7470                           White
7471                             Red
7472                        TWO TONE
7473                           White
7474                            Blue
7475                            Blue
7476                            Blue
7477                           Black
7478                           Brown
7479                           Black
7480                           Green
7481                           Black
7482                           Black
7483                          Purple
7484                             NaN
7485                           Black
7486                           Black
7487                            Gray
7488                           Black
7489                           Black
7490                             Red
7491                        TWO TONE
7492                            Gray
Name: Exterior_Color, Length: 7493, dtype: object

df['Exterior_Color'].fillna(method = 'ffill')#前向填补

0                              Black
1                              Black
2                        Silver/Blue
3                                Red
4                               Blue
5                                Red
6       Grey / Red / Silver Metallic
7                              Black
8                         Cherry Red
9                              Black
10                          Burgundy
11                             Black
12                RICH RED W/STRIPES
13                   Luxury Rich Red
14                   Luxury Rich Red
15                               Red
16                             White
17                              Blue
18                               Red
19                             Black
20                             Black
21                             Black
22                  Black &amp; Blue
23                            Purple
24                             Black
25                              Blue
26                               Red
27                   Red Hot Sun Glo
28                          Burgundy
29                             Black
30                  Kandy brandywine
31                              Blue
32                               Red
33                             Black
34                              Blue
35                              Blue
36                             Black
37                               Red
38                          Burgundy
39                             Black
40                             Black
41                             Black
42                             Black
43                             Black
44                             Black
45               Blue/Green Metallic
46                       Vivid Black
47                             Black
48                             Black
49                             Black
                    ...             
7443                           Black
7444                            Gray
7445                             Red
7446                            Gray
7447                           Black
7448                        Burgundy
7449                           Black
7450                           Black
7451                          maroon
7452                            Blue
7453                        TWO TONE
7454                             Red
7455                           Black
7456                          Orange
7457                           Black
7458                            Blue
7459                           Black
7460                           Black
7461                            Gray
7462                            Blue
7463                          Orange
7464                           Black
7465                           Black
7466                            Blue
7467                            Blue
7468                           White
7469                           Black
7470                           White
7471                             Red
7472                        TWO TONE
7473                           White
7474                            Blue
7475                            Blue
7476                            Blue
7477                           Black
7478                           Brown
7479                           Black
7480                           Green
7481                           Black
7482                           Black
7483                          Purple
7484                          Purple
7485                           Black
7486                           Black
7487                            Gray
7488                           Black
7489                           Black
7490                             Red
7491                        TWO TONE
7492                            Gray
Name: Exterior_Color, Length: 7493, dtype: object

df['Exterior_Color'].fillna(method = 'bfill')#后向填补

0                              Black
1                              Black
2                        Silver/Blue
3                                Red
4                               Blue
5                                Red
6       Grey / Red / Silver Metallic
7                              Black
8                         Cherry Red
9                              Black
10                          Burgundy
11                             Black
12                RICH RED W/STRIPES
13                   Luxury Rich Red
14                               Red
15                               Red
16                             White
17                              Blue
18                               Red
19                             Black
20                             Black
21                             Black
22                  Black &amp; Blue
23                            Purple
24                             Black
25                              Blue
26                               Red
27                   Red Hot Sun Glo
28                          Burgundy
29                             Black
30                  Kandy brandywine
31                              Blue
32                               Red
33                             Black
34                              Blue
35                             Black
36                             Black
37                               Red
38                          Burgundy
39                             Black
40                             Black
41                             Black
42                             Black
43                             Black
44                             Black
45               Blue/Green Metallic
46                       Vivid Black
47                             Black
48                             Black
49                             Black
                    ...             
7443                           Black
7444                            Gray
7445                             Red
7446                            Gray
7447                           Black
7448                        Burgundy
7449                           Black
7450                           Black
7451                          maroon
7452                            Blue
7453                        TWO TONE
7454                             Red
7455                           Black
7456                          Orange
7457                           Black
7458                            Blue
7459                           Black
7460                           Black
7461                            Gray
7462                            Blue
7463                          Orange
7464                           Black
7465                           Black
7466                            Blue
7467                            Blue
7468                           White
7469                           Black
7470                           White
7471                             Red
7472                        TWO TONE
7473                           White
7474                            Blue
7475                            Blue
7476                            Blue
7477                           Black
7478                           Brown
7479                           Black
7480                           Green
7481                           Black
7482                           Black
7483                          Purple
7484                           Black
7485                           Black
7486                           Black
7487                            Gray
7488                           Black
7489                           Black
7490                             Red
7491                        TWO TONE
7492                            Gray
Name: Exterior_Color, Length: 7493, dtype: object

欢迎阅读数据清洗系列文章：python数据清洗工具、方法、过程整理归纳

• 一、数据清洗之常用工具——numpy，pandas
• 二、数据清洗之文件读写——读取csv、Excel和MySQL数据
• 三、数据清洗之数据表操作——数据筛选、增加删除、查找修改、数据整理和层次化索引
• 四、数据清洗之数据转换——日期格式数据处理、高阶函数数据处理、字符串数据处理
• 五、数据清洗之数据统计——数据分组运算、聚合函数使用、分组对象和apply函数、透视图与交叉表