Home Insurance
2007-2012 polices of a Home Insurance company
@kaggle.ycanario_home_insurance
2007-2012 polices of a Home Insurance company
@kaggle.ycanario_home_insurance
Data has always been at the heart of the insurance industry. What has changed in our current reality to create massive disruption is the amount of data generated daily and the speed at which machines can process the info and uncover insights. We can no longer characterize the insurance industry as a sloth when it comes to innovation and technology. Artificial intelligence (AI) and machine learning are transforming the insurance industry in a number of ways.
Source: https://goo.gl/KJrWLb
This is a Home Insurance dataset including police's years between 2007 and 2012. Each police includes some significants characteristics of polices, building's characteristics, the zone, the privileges, the faults, some risk indicators and so on.
This is a Home Insurance dataset from the R class in the "Université de Technologie de Troyes (UTT), France" where i'm coursing a Big Data master. I was assigned this dataset to get insights using R and its machine learning tool Rattle.
With this publication I would like to help those who are starting in the "Data Sciencie World" like me and to get reviews from those who have a major expertise in the subject.
CREATE TABLE home_insurance (
"quote_date" TIMESTAMP,
"cover_start" TIMESTAMP,
"claim3years" VARCHAR,
"p1_emp_status" VARCHAR,
"p1_pt_emp_status" VARCHAR,
"bus_use" VARCHAR,
"clerical" VARCHAR,
"ad_buildings" VARCHAR,
"risk_rated_area_b" DOUBLE,
"sum_insured_buildings" DOUBLE,
"ncd_granted_years_b" DOUBLE,
"ad_contents" VARCHAR,
"risk_rated_area_c" DOUBLE,
"sum_insured_contents" DOUBLE,
"ncd_granted_years_c" DOUBLE,
"contents_cover" VARCHAR,
"buildings_cover" VARCHAR,
"spec_sum_insured" DOUBLE,
"spec_item_prem" DOUBLE,
"unspec_hrp_prem" DOUBLE,
"p1_dob" TIMESTAMP,
"p1_mar_status" VARCHAR,
"p1_policy_refused" VARCHAR,
"p1_sex" VARCHAR,
"appr_alarm" VARCHAR,
"appr_locks" VARCHAR,
"bedrooms" DOUBLE,
"roof_construction" DOUBLE,
"wall_construction" DOUBLE,
"flooding" VARCHAR,
"listed" DOUBLE,
"max_days_unocc" DOUBLE,
"neigh_watch" VARCHAR,
"occ_status" VARCHAR,
"ownership_type" DOUBLE,
"paying_guests" DOUBLE,
"prop_type" DOUBLE,
"safe_installed" VARCHAR,
"sec_disc_req" VARCHAR,
"subsidence" VARCHAR,
"yearbuilt" DOUBLE,
"campaign_desc" VARCHAR,
"payment_method" VARCHAR,
"payment_frequency" DOUBLE,
"legal_addon_pre_ren" VARCHAR,
"legal_addon_post_ren" VARCHAR,
"home_em_addon_pre_ren" VARCHAR,
"home_em_addon_post_ren" VARCHAR,
"garden_addon_pre_ren" VARCHAR,
"garden_addon_post_ren" VARCHAR,
"keycare_addon_pre_ren" VARCHAR,
"keycare_addon_post_ren" VARCHAR,
"hp1_addon_pre_ren" VARCHAR,
"hp1_addon_post_ren" VARCHAR,
"hp2_addon_pre_ren" VARCHAR,
"hp2_addon_post_ren" VARCHAR,
"hp3_addon_pre_ren" VARCHAR,
"hp3_addon_post_ren" VARCHAR,
"mta_flag" VARCHAR,
"mta_fap" DOUBLE,
"mta_aprp" DOUBLE,
"mta_date" TIMESTAMP,
"last_ann_prem_gross" DOUBLE,
"pol_status" VARCHAR,
"i" BIGINT,
"police" VARCHAR
);
Anyone who has the link will be able to view this.