Analytics Vidhya Nov'22 Insurance Claims Dataset

Predict whether the policyholder will file a claim in the next 6 months or not.

@kaggle.avikumart_analytics_vidhya_nov22_insurance_claims_dataset

Table List

3 tables(2.99 MB)

Sample Submission Kvrh9sx

Test Zo1g9sv

Train Qwm28yl

Test Zo1g9sv

@kaggle.avikumart_analytics_vidhya_nov22_insurance_claims_dataset.test_zo1g9sv

1.1 MB
39063 rows
43 columns

policy_id Policy Id	policy_tenure Policy Tenure	age_of_car Age Of Car	age_of_policyholder Age Of Policyholder	area_cluster Area Cluster	population_density Population Density	make Make	segment Segment	model Model	fuel_type Fuel Type	max_torque Max Torque	max_power Max Power	engine_type Engine Type	airbags Airbags	is_esc Is Esc	is_adjustable_steering Is Adjustable Steering	is_tpms Is Tpms	is_parking_sensors Is Parking Sensors	is_parking_camera Is Parking Camera	rear_brakes_type Rear Brakes Type	displacement Displacement	cylinder Cylinder	transmission_type Transmission Type	gear_box Gear Box	steering_type Steering Type	turning_radius Turning Radius	length Length	width Width	height Height	gross_weight Gross Weight	is_front_fog_lights Is Front Fog Lights	is_rear_window_wiper Is Rear Window Wiper	is_rear_window_washer Is Rear Window Washer	is_rear_window_defogger Is Rear Window Defogger	is_brake_assist Is Brake Assist	is_power_door_locks Is Power Door Locks	is_central_locking Is Central Locking	is_power_steering Is Power Steering	is_driver_seat_height_adjustable Is Driver Seat Height Adjustable	is_day_night_rear_view_mirror Is Day Night Rear View Mirror	is_ecw Is Ecw	is_speed_alert Is Speed Alert	ncap_rating Ncap Rating
ID58593	0.341731678878033		0.586538461538462	C3	4076	1	A	M1	CNG	60Nm@3500rpm	40.36bhp@6000rpm	F8D Petrol Engine	2	No	No	No	Yes	No	Drum	796	3	Manual	5	Power	4.6	3445	1515	1475	1185	No	No	No	No	No	No	No	Yes	No	No	No	Yes
ID58594	0.307241443301031	0.13	0.442307692307692	C8	8794	1	B2	M6	Petrol	113Nm@4400rpm	88.50bhp@6000rpm	K Series Dual jet	2	No	Yes	No	Yes	No	Drum	1197	4	Manual	5	Electric	4.8	3845	1735	1530	1335	Yes	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	2
ID58595	0.327923771475999	0.12	0.451923076923077	C8	8794	2	A	M3	Petrol	91Nm@4250rpm	67.06bhp@5500rpm	1.0 SCe	2	No	No	No	No	Yes	Drum	999	3	Automatic	5	Electric	5	3731	1579	1490	1155	No	No	No	No	No	Yes	Yes	Yes	No	Yes	Yes	Yes	2
ID58596	0.78265438076048	0.01	0.461538461538462	C5	34738	1	A	M1	CNG	60Nm@3500rpm	40.36bhp@6000rpm	F8D Petrol Engine	2	No	No	No	Yes	No	Drum	796	3	Manual	5	Power	4.6	3445	1515	1475	1185	No	No	No	No	No	No	No	Yes	No	No	No	Yes
ID58597	1.2334042746457	0.02	0.634615384615385	C5	34738	1	A	M1	CNG	60Nm@3500rpm	40.36bhp@6000rpm	F8D Petrol Engine	2	No	No	No	Yes	No	Drum	796	3	Manual	5	Power	4.6	3445	1515	1475	1185	No	No	No	No	No	No	No	Yes	No	No	No	Yes
ID58598	0.148635401541081	0.15	0.442307692307692	C8	8794	1	B2	M7	Petrol	113Nm@4400rpm	88.50bhp@6000rpm	1.2 L K Series Engine	6	Yes	Yes	No	Yes	Yes	Drum	1197	4	Automatic	5	Electric	4.85	3990	1745	1500	1410	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
ID58599	1.11418166980782	0.09	0.355769230769231	C16	16206	1	B1	M8	CNG	82.1Nm@3400rpm	55.92bhp@5300rpm	K10C	2	No	No	No	Yes	No	Drum	998	3	Manual	5	Power	4.7	3655	1620	1675	1340	No	No	No	No	No	Yes	Yes	Yes	No	No	Yes	Yes	2
ID58600	1.11363760085821	0.01	0.471153846153846	C14	7788	1	B2	M6	Petrol	113Nm@4400rpm	88.50bhp@6000rpm	K Series Dual jet	2	No	Yes	No	Yes	No	Drum	1197	4	Manual	5	Electric	4.8	3845	1735	1530	1335	Yes	No	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	2
ID58601	0.36038517714943	0.15	0.519230769230769	C11	6108	1	B1	M8	CNG	82.1Nm@3400rpm	55.92bhp@5300rpm	K10C	2	No	No	No	Yes	No	Drum	998	3	Manual	5	Power	4.7	3655	1620	1675	1340	No	No	No	No	No	Yes	Yes	Yes	No	No	Yes	Yes	2
ID58602	1.20992210349989	0.06	0.451923076923077	C11	6108	1	B2	M7	Petrol	113Nm@4400rpm	88.50bhp@6000rpm	1.2 L K Series Engine	6	Yes	Yes	No	Yes	Yes	Drum	1197	4	Automatic	5	Electric	4.85	3990	1745	1500	1410	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes


CREATE TABLE test_zo1g9sv (
  "policy_id" VARCHAR,
  "policy_tenure" DOUBLE,
  "age_of_car" DOUBLE,
  "age_of_policyholder" DOUBLE,
  "area_cluster" VARCHAR,
  "population_density" BIGINT,
  "make" BIGINT,
  "segment" VARCHAR,
  "model" VARCHAR,
  "fuel_type" VARCHAR,
  "max_torque" VARCHAR,
  "max_power" VARCHAR,
  "engine_type" VARCHAR,
  "airbags" BIGINT,
  "is_esc" VARCHAR,
  "is_adjustable_steering" VARCHAR,
  "is_tpms" VARCHAR,
  "is_parking_sensors" VARCHAR,
  "is_parking_camera" VARCHAR,
  "rear_brakes_type" VARCHAR,
  "displacement" BIGINT,
  "cylinder" BIGINT,
  "transmission_type" VARCHAR,
  "gear_box" BIGINT,
  "steering_type" VARCHAR,
  "turning_radius" DOUBLE,
  "length" BIGINT,
  "width" BIGINT,
  "height" BIGINT,
  "gross_weight" BIGINT,
  "is_front_fog_lights" VARCHAR,
  "is_rear_window_wiper" VARCHAR,
  "is_rear_window_washer" VARCHAR,
  "is_rear_window_defogger" VARCHAR,
  "is_brake_assist" VARCHAR,
  "is_power_door_locks" VARCHAR,
  "is_central_locking" VARCHAR,
  "is_power_steering" VARCHAR,
  "is_driver_seat_height_adjustable" VARCHAR,
  "is_day_night_rear_view_mirror" VARCHAR,
  "is_ecw" VARCHAR,
  "is_speed_alert" VARCHAR,
  "ncap_rating" BIGINT
);