Auto Insurance Claim

predict customers how are take auto insurance nect year

@kaggle.bharatnatrayn_auto_insurance_claim

Table List

1 table(16.46 MB)

Autoinsuranceclaim

@kaggle.bharatnatrayn_auto_insurance_claim.autoinsuranceclaim

16.46 MB
595212 rows
59 columns

id Id	target Target	ps_ind_01 Ps Ind 01	ps_ind_02_cat Ps Ind 02 Cat	ps_ind_03 Ps Ind 03	ps_ind_04_cat Ps Ind 04 Cat	ps_ind_06_bin Ps Ind 06 Bin	ps_ind_07_bin Ps Ind 07 Bin	ps_ind_08_bin Ps Ind 08 Bin	ps_ind_09_bin Ps Ind 09 Bin	ps_ind_15 Ps Ind 15	ps_ind_16_bin Ps Ind 16 Bin	ps_ind_17_bin Ps Ind 17 Bin	ps_ind_18_bin Ps Ind 18 Bin	ps_reg_01 Ps Reg 01	ps_reg_02 Ps Reg 02	ps_reg_03 Ps Reg 03	ps_car_01_cat Ps Car 01 Cat	ps_car_02_cat Ps Car 02 Cat	ps_car_04_cat Ps Car 04 Cat	ps_car_05_cat Ps Car 05 Cat	ps_car_06_cat Ps Car 06 Cat	ps_car_07_cat Ps Car 07 Cat	ps_car_08_cat Ps Car 08 Cat	ps_car_09_cat Ps Car 09 Cat	ps_car_10_cat Ps Car 10 Cat	ps_car_11_cat Ps Car 11 Cat	ps_car_11 Ps Car 11	ps_car_12 Ps Car 12	ps_car_13 Ps Car 13	ps_car_14 Ps Car 14	ps_car_15 Ps Car 15	ps_calc_01 Ps Calc 01	ps_calc_02 Ps Calc 02	ps_calc_03 Ps Calc 03	ps_calc_04 Ps Calc 04	ps_calc_05 Ps Calc 05	ps_calc_06 Ps Calc 06	ps_calc_07 Ps Calc 07	ps_calc_08 Ps Calc 08	ps_calc_09 Ps Calc 09	ps_calc_10 Ps Calc 10	ps_calc_11 Ps Calc 11	ps_calc_12 Ps Calc 12	ps_calc_13 Ps Calc 13	ps_calc_14 Ps Calc 14	ps_calc_15_bin Ps Calc 15 Bin	ps_calc_16_bin Ps Calc 16 Bin	ps_calc_17_bin Ps Calc 17 Bin	ps_calc_18_bin Ps Calc 18 Bin	ps_calc_19_bin Ps Calc 19 Bin	ps_calc_20_bin Ps Calc 20 Bin
7		2	2	5	1		1			11		1		0.7	0.2	0.718070331	10	1		1	4	1			1	12	2	0.4	0.883678918	0.3708099239999999	3.605551276	0.6	0.5	0.2	3	1	10	1	10	1	5	9	1	5	8		1	1			1
9		1	1	7				1		3			1	0.8	0.4	0.766077672	11	1			11	1	1	2	1	19	3	0.316227766	0.618816519	0.388715835	2.449489743	0.3	0.1	0.3	2	1	9	5	8	1	7	3	1	1	9		1	1		1
13		5	4	9	1			1		12	1						7	1			14	1	1	2	1	60	1	0.316227766	0.641585716	0.347275107	3.31662479	0.5	0.7	0.1	2	2	9	1	8	2	7	4	2	7	7		1	1		1
16			1	2		1				8	1			0.9	0.2	0.580947502	7	1		1	11	1	1	3	1	104	1	0.374165739	0.54294879	0.294957624	2	0.6	0.9	0.1	2	4	7	1	8	4	2	2	2	4	9
17			2		1	1				9	1			0.7	0.6	0.840758586	11	1			14	1	1	2	1	82	3	0.316069613	0.565831503	0.365102725	2	0.4	0.6		2	2	6	3	10	2	12	3	1	1	3				1	1
19		5	1	4					1	6	1			0.9	1.8	2.332648709	10				14	1	1		1	104	2	0.445982062	0.879049073	0.40620192	3	0.7	0.8	0.4	3	1	8	2	11	3	8	4	2		9		1		1	1	1
20		2	1	3	1		1			8	1			0.6	0.1	0.617454452	6	1		1	11	1	1		1	99	2	0.316227766	0.639682902	0.3687817779999999	3.16227766	0.2	0.6	0.5	2	2	8	1	8	3	10	3			10		1			1
22		5	1	4		1				13	1			0.7	0.4	0.60724789	11	1			11	1	1	2	1	30	3	0.4469899329999999	0.900573738	0.374833296	3.31662479	0.1	0.5	0.1	1	2	7	1	6	1	13	7	1	3	6	1		1		1
26		5	1	3	1			1		6	1			0.9	0.7	0.901387819	10	1		1	14	1	1		1	68	3	0.4	0.780641292	0.407430976	2.828427125	0.9	0.8	0.6	3	1	7	3	9	4	11	4	2	1	5		1				1
28	1	1	1	2			1			4			1	0.9	1.4	2.316651679	11		1		14	1	1	2	1	104	2	0.447213595	1.458184369	0.390256326	3.605551276	0.7	0.8	0.8	2	2	8	2	9	1	11	3	5		6		1			1


CREATE TABLE autoinsuranceclaim (
  "id" BIGINT,
  "target" BIGINT,
  "ps_ind_01" BIGINT,
  "ps_ind_02_cat" DOUBLE,
  "ps_ind_03" BIGINT,
  "ps_ind_04_cat" DOUBLE,
  "ps_ind_05_cat" DOUBLE,
  "ps_ind_06_bin" BIGINT,
  "ps_ind_07_bin" BIGINT,
  "ps_ind_08_bin" BIGINT,
  "ps_ind_09_bin" BIGINT,
  "ps_ind_10_bin" BIGINT,
  "ps_ind_11_bin" BIGINT,
  "ps_ind_12_bin" BIGINT,
  "ps_ind_13_bin" BIGINT,
  "ps_ind_14" BIGINT,
  "ps_ind_15" BIGINT,
  "ps_ind_16_bin" BIGINT,
  "ps_ind_17_bin" BIGINT,
  "ps_ind_18_bin" BIGINT,
  "ps_reg_01" DOUBLE,
  "ps_reg_02" DOUBLE,
  "ps_reg_03" DOUBLE,
  "ps_car_01_cat" DOUBLE,
  "ps_car_02_cat" BIGINT,
  "ps_car_03_cat" DOUBLE,
  "ps_car_04_cat" BIGINT,
  "ps_car_05_cat" DOUBLE,
  "ps_car_06_cat" BIGINT,
  "ps_car_07_cat" DOUBLE,
  "ps_car_08_cat" BIGINT,
  "ps_car_09_cat" DOUBLE,
  "ps_car_10_cat" BIGINT,
  "ps_car_11_cat" BIGINT,
  "ps_car_11" DOUBLE,
  "ps_car_12" DOUBLE,
  "ps_car_13" DOUBLE,
  "ps_car_14" DOUBLE,
  "ps_car_15" DOUBLE,
  "ps_calc_01" DOUBLE,
  "ps_calc_02" DOUBLE,
  "ps_calc_03" DOUBLE,
  "ps_calc_04" BIGINT,
  "ps_calc_05" BIGINT,
  "ps_calc_06" BIGINT,
  "ps_calc_07" BIGINT,
  "ps_calc_08" BIGINT,
  "ps_calc_09" BIGINT,
  "ps_calc_10" BIGINT,
  "ps_calc_11" BIGINT,
  "ps_calc_12" BIGINT,
  "ps_calc_13" BIGINT,
  "ps_calc_14" BIGINT,
  "ps_calc_15_bin" BIGINT,
  "ps_calc_16_bin" BIGINT,
  "ps_calc_17_bin" BIGINT,
  "ps_calc_18_bin" BIGINT,
  "ps_calc_19_bin" BIGINT,
  "ps_calc_20_bin" BIGINT
);