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

Train Qwm28yl

@kaggle.avikumart_analytics_vidhya_nov22_insurance_claims_dataset.train_qwm28yl

1.65 MB
58592 rows
44 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
ID00001	0.515873589958172	0.05	0.644230769230769	C1	4990	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
ID00002	0.672618513547733	0.02	0.375	C2	27003	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
ID00003	0.841110255796233	0.02	0.384615384615385	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
ID00004	0.900276558749967	0.11	0.432692307692308	C4	21622	1	C1	M2	Petrol	113Nm@4400rpm	88.50bhp@6000rpm	1.2 L K12N Dualjet	2	Yes	Yes	No	Yes	Yes	Drum	1197	4	Automatic	5	Electric	4.8	3995	1735	1515	1335	Yes	No	No	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	2
ID00005	0.596402813108729	0.11	0.634615384615385	C5	34738	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
ID00006	1.01870853782142	0.07	0.519230769230769	C6	13051	3	C2	M4	Diesel	250Nm@2750rpm	113.45bhp@4000rpm	1.5 L U2 CRDi	6	Yes	Yes	Yes	Yes	Yes	Disc	1493	4	Automatic	6	Power	5.2	4300	1790	1635	1720	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	3
ID00007	0.097992157807911	0.16	0.403846153846154	C7	6112	4	B2	M5	Diesel	200Nm@3000rpm	88.77bhp@4000rpm	1.5 Turbocharged Revotorq	2	No	Yes	No	Yes	No	Drum	1497	4	Manual	5	Electric	5	3990	1755	1523	1490	No	No	No	No	No	Yes	Yes	Yes	No	No	Yes	Yes	5
ID00008	0.509084671398517	0.14	0.423076923076923	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
ID00009	0.282393518287139	0.07	0.298076923076923	C7	6112	3	C2	M4	Diesel	250Nm@2750rpm	113.45bhp@4000rpm	1.5 L U2 CRDi	6	Yes	Yes	Yes	Yes	Yes	Disc	1493	4	Automatic	6	Power	5.2	4300	1790	1635	1720	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	No	Yes	Yes	3
ID00010	0.566255432742967	0.04	0.442307692307692	C9	17804	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 train_qwm28yl (
  "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,
  "is_claim" BIGINT
);