reduced carsales data (sampled)

	A	B	C	D	E	F	G
1	MAKE	MODEL	CS_PRICE_DAP	COALESCE(EXTERIOR_COLOR,INTERIOR_COLOR)	ODOMETER	RELEASE_YEAR	STATE
2	MERCEDES-BENZ	C-CLASS	193338	BLACK	12	2020	WA
3	MERCEDES-BENZ	C-CLASS	185600	WHITE	28	2020	WA
4	MERCEDES-BENZ	C-CLASS	181800	WHITE	3869	2020	VIC
5	MERCEDES-BENZ	C-CLASS	176363	SILVER	4035	2020	SA
6	MERCEDES-BENZ	C-CLASS	171800	BLUE	7116	2019	VIC
7	MERCEDES-BENZ	C-CLASS	169900	WHITE	4958	2020	QLD
8	MERCEDES-BENZ	C-CLASS	169800	WHITE	2919	2019	VIC
9	MERCEDES-BENZ	C-CLASS	168000	OBSIDIAN BLACK	1950	2020	NSW
10	MERCEDES-BENZ	C-CLASS	164490	GREY	2264	2019	NSW
11	MERCEDES-BENZ	C-CLASS	160000	OBSIDIAN BLACK	5238	2019	NSW
12	MERCEDES-BENZ	C-CLASS	159990	GREY	8035	2018	QLD
13	MERCEDES-BENZ	C-CLASS	159888	SILVER	2654	2019	NSW
14	MERCEDES-BENZ	C-CLASS	155990	BLACK	13463	2019	NSW
15	MERCEDES-BENZ	C-CLASS	155000	SELENITE GREY	5030	2019	VIC
16	MERCEDES-BENZ	C-CLASS	153480	BLUE	5680	2018	QLD
17	MERCEDES-BENZ	C-CLASS	151000	DESIGNO - MAGNO GRAPHITE GREY	21632	2018	VIC
18	MERCEDES-BENZ	C-CLASS	149990	DESIGNO - MAGNO SELENITE GREY	11300	2019	QLD
19	MERCEDES-BENZ	C-CLASS	149888	GREY	6688	2018	SA
20	MERCEDES-BENZ	C-CLASS	145900	BLACK	9106	2019	NSW
21	MERCEDES-BENZ	C-CLASS	142990	GREY	15580	2018	WA
22	MERCEDES-BENZ	C-CLASS	139990	SILVER	7245	2016	NSW
23	MERCEDES-BENZ	C-CLASS	137990	GREY	12718	2016	QLD
24	MERCEDES-BENZ	C-CLASS	135000	OBSIDIAN BLACK	33000	2018	VIC
25	MERCEDES-BENZ	C-CLASS	133672	GREY	100	2020	NSW
26	MERCEDES-BENZ	C-CLASS	129990	BLACK	18274	2018	VIC
27	MERCEDES-BENZ	C-CLASS	129900	WHITE	3500	2020	WA
28	MERCEDES-BENZ	C-CLASS	127990	GREY	21800	2018	QLD
29	MERCEDES-BENZ	C-CLASS	125990	GREY	15625	2017	NSW
30	MERCEDES-BENZ	C-CLASS	125000	DIAMOND WHITE BRIGHT	9850	2016	WA
31	MERCEDES-BENZ	C-CLASS	124950	WHITE	6733	2017	NSW
32	MERCEDES-BENZ	C-CLASS	124000	DIAMOND WHITE BRIGHT	13750	2017	NSW
33	MERCEDES-BENZ	C-CLASS	120000	DESIGNO - MAGNO SELENITE GREY	10500	2017	VIC
34	MERCEDES-BENZ	C-CLASS	120000	GREY	9885	2016	VIC
35	MERCEDES-BENZ	C-CLASS	119990	GREY	1023	2019	NSW
36	MERCEDES-BENZ	C-CLASS	119900	WHITE	13316	2018	VIC
37	MERCEDES-BENZ	C-CLASS	119800	DIAMOND WHITE BRIGHT	28000	2017	NSW
38	MERCEDES-BENZ	C-CLASS	118880	BLACK	23913	2017	NSW
39	MERCEDES-BENZ	C-CLASS	118800	GREY	11054	2017	VIC
40	MERCEDES-BENZ	C-CLASS	117900	BLACK	11945	2016	SA
41	MERCEDES-BENZ	C-CLASS	116850	BLACK	2900	2019	NSW
42	MERCEDES-BENZ	C-CLASS	116500	POLAR WHITE	7005	2016	NSW
43	MERCEDES-BENZ	C-CLASS	115888	GREY	31540	2017	NSW
44	MERCEDES-BENZ	C-CLASS	115000	BLACK	30000	2015	VIC
45	MERCEDES-BENZ	C-CLASS	115000	OBSIDIAN BLACK	21700	2018	NSW
46	MERCEDES-BENZ	C-CLASS	114990	BLACK	24555	2017	QLD
47	MERCEDES-BENZ	C-CLASS	114990	WHITE	29000	2017	NSW
48	MERCEDES-BENZ	C-CLASS	114880	BLUE	2950	2019	VIC
49	MERCEDES-BENZ	C-CLASS	113900	GREY	1600	2020	VIC
50	MERCEDES-BENZ	C-CLASS	113000	POLAR WHITE	23000	2016	NSW
51	MERCEDES-BENZ	C-CLASS	112500	DESIGNO IRIDIUM SILVER MAGNO	30000	2018	QLD
52	MERCEDES-BENZ	C-CLASS	110500	BRILLIANT BLUE	20000	2017	SA
53	MERCEDES-BENZ	C-CLASS	110000	IRIDIUM SILVER	26000	2018	QLD
54	MERCEDES-BENZ	C-CLASS	109990	GREY	1150	2019	VIC
55	MERCEDES-BENZ	C-CLASS	109990	SILVER	51262	2017	QLD
56	MERCEDES-BENZ	C-CLASS	109990	WHITE	38920	2017	VIC
57	MERCEDES-BENZ	C-CLASS	109900	GREY	5994	2019	NSW
58	MERCEDES-BENZ	C-CLASS	109500	OBSIDIAN BLACK	37000	2016	NSW
59	MERCEDES-BENZ	C-CLASS	108900	GREY	54491	2018	VIC
60	MERCEDES-BENZ	C-CLASS	108800	WHITE	26952	2017	NSW
61	MERCEDES-BENZ	C-CLASS	108000	OBSIDIAN BLACK	23019	2015	VIC
62	MERCEDES-BENZ	C-CLASS	107800	BLUE	43636	2016	VIC
63	MERCEDES-BENZ	C-CLASS	106990	WHITE	24845	2017	QLD
64	MERCEDES-BENZ	C-CLASS	105990	WHITE	25111	2019	WA
65	MERCEDES-BENZ	C-CLASS	105000	OBSIDIAN BLACK	31617	2016	NSW
66	MERCEDES-BENZ	C-CLASS	104990	BLUE	24490	2016	NSW
67	MERCEDES-BENZ	C-CLASS	104990	SILVER	53313	2016	NSW
68	MERCEDES-BENZ	C-CLASS	104900	OBSIDIAN BLACK	39900	2017	VIC
69	MERCEDES-BENZ	C-CLASS	104888	WHITE	41085	2017	QLD
70	MERCEDES-BENZ	C-CLASS	104000	OBSIDIAN BLACK	29900	2017	VIC
71	MERCEDES-BENZ	C-CLASS	103000	BLACK	32900	2016	VIC
72	MERCEDES-BENZ	C-CLASS	102990	GREY	6462	2019	VIC
73	MERCEDES-BENZ	C-CLASS	102182	BLACK	42	2020	WA
74	MERCEDES-BENZ	C-CLASS	101800	BLUE	43683	2016	NSW
75	MERCEDES-BENZ	C-CLASS	100000	POLAR WHITE	24700	2019	WA
76	HOLDEN	COMMODORE	99990	RED	50	2017	WA
77	MERCEDES-BENZ	C-CLASS	99990	SILVER	13699	2018	NSW
78	MERCEDES-BENZ	C-CLASS	99950	SILVER	37264	2016	NSW
79	MERCEDES-BENZ	C-CLASS	99900	BLUE	54000	2017	VIC
80	MERCEDES-BENZ	C-CLASS	99900	OBSIDIAN BLACK	41400	2015	QLD
81	MERCEDES-BENZ	C-CLASS	99800	OBSIDIAN BLACK	87000	2015	NSW
82	MERCEDES-BENZ	C-CLASS	99000	OBSIDIAN BLACK	31020	2016	VIC
83	MERCEDES-BENZ	C-CLASS	98900	WHITE	4607	2019	SA
84	MERCEDES-BENZ	C-CLASS	98880	DESIGNO - MAGNO SELENITE GREY	34500	2016	NSW
85	MERCEDES-BENZ	C-CLASS	98500	DESIGNO - DIAMOND WHITE BRIGHT	22500	2018	VIC
86	MERCEDES-BENZ	C-CLASS	98000	OBSIDIAN BLACK	20558	2017	NSW
87	MERCEDES-BENZ	C-CLASS	97900	WHITE	7995	2019	SA
88	MERCEDES-BENZ	C-CLASS	97500	WHITE	55900	2015	VIC
89	MERCEDES-BENZ	C-CLASS	96900	WHITE	17201	2019	VIC
90	MERCEDES-BENZ	C-CLASS	96800	BLACK	37088	2016	NSW
91	MERCEDES-BENZ	C-CLASS	96000	OBSIDIAN BLACK	50796	2015	QLD
92	MERCEDES-BENZ	C-CLASS	95500	OBSIDIAN BLACK	55000	2016	VIC
93	MERCEDES-BENZ	C-CLASS	95000	OBSIDIAN BLACK	64000	2017	NSW
94	MERCEDES-BENZ	C-CLASS	94999	SELENITE GREY	15000	2017	NSW
95	MERCEDES-BENZ	C-CLASS	94990	WHITE	55185	2016	NSW
96	MERCEDES-BENZ	C-CLASS	94900	BLACK	59721	2016	QLD
97	MERCEDES-BENZ	C-CLASS	94888	BLACK	67205	2015	VIC
98	MERCEDES-BENZ	C-CLASS	94800	WHITE	17441	2018	NSW
99	MERCEDES-BENZ	C-CLASS	94000	DIAMOND WHITE BRIGHT	74000	2015	NSW
100	MERCEDES-BENZ	C-CLASS	94000	SILVER	10	2020	QLD