Motor Vehicle Insurance Policy and Claim Dataset

This dataset encompasses 105,555 records representing the lifecycle of motor insurance policies. It includes longitudinal data on contract renewals, driver maturity (age and license seniority), and comprehensive vehicle technical attributes such as cylinder capacity, fuel type, and weight. Crucially, the dataset links these profiles to financial outcomes, including annual premium amounts and the cost/frequency of claims both in the current period and historically.

Data Quality

The dataset is highly complete for core fields such as Premium, Dates, and Vehicle specs. Missing values are present in 'Date_lapse' (normal as it only applies to cancelled policies), 'Length' (approx. 10% missing), and 'Type_fuel' (approx. 1.6% missing). Numerical values are consistently formatted, though IDs repeat across multiple renewal periods.

Use Cases

Ideal for building churn prediction models to identify customers likely to lapse, developing actuarial risk models for premium calculation, and performing regression analysis on claim costs based on vehicle technical specs

Limitations

The dataset contains limited geographic granularity, providing only a binary 'Area' code. Specific vehicle makes and models are abstracted into technical specifications, and the 'Lapse' reason is represented by numeric codes without a metadata key.

Methodology

The data was extracted from a centralized insurance policy management system. It captures snapshots of policies at different renewal intervals, maintaining historical claim ratios and vehicle valuation at the time of contract issuance.