I am curious about the column
pol_no_claims_discount. From the pdf data dictionary, it seems as if it can only decrease by 0.047 or increase by a multiple of 0.203 from year-to-year (unless it would hit 0 or 1).
However, this does not seem to be the case. For example, from
id_policy = PL000000, the sequence goes 0.332, 0.280, 0.225, 0.166 – for differences of -0.052, -0.055, -0.059.
id_policy = “PL000118”,
pol_no_claims_discount is 0 for years 1 and 2. In year 2, there is at least one claim (
claim_amount = 1096.21). However, for year 3,
pol_no_claims_discount is still 0. Moreover, even through there is no claim in year 3, for year 4, `pol_no_claims_discount_ is now 0.196 – not 0.203 or 0.156, as I would have expected.
Is there something I am misunderstanding about how this column works?