Python Practical $3$: Top Percentile Fraud

TP Service a large number for FSA regulated companies across UK and Europe.

One of the challenges within the Claims programs is identifying fraud trends and flagging these to our clients.

The Problem Statement

We are given a DataFrame with information about claims made by an insurance company.

The company wants to identify the top $5$ percentile of claims from each state based on the

fraud score.

We need to write a program to accomplish this task and output the :

$-$ policy number

$-$ state

$-$ claim cost

$-$ fraud score for those claims.

Your objective is to identify the top $5$ percentile of claims from each state.

Your output should be policy number, state, claim cost, and fraud score.

HINT $1$:

To identify the top $5$ percentile of claims from each state, we need to calculate the percentile rank of the fraud scores within each state.

This can be done using the rank function in pandas.

Hint $2$:

Keep going! Now let's calculate the percentile rank of the fraud scores within each state.

We can do this by grouping the data by the 'state' column and applying the rank function to

the 'fraud$\_$score' column with the argument pct$=$True.

This will give us the percentile rank of each fraud score within its respective state.