ACT 210 · Year 2 · Semester 2 · 2 credits · Integration & Practice
R & Python for Actuaries
Bridging classical actuarial mathematics and modern predictive engineering through bilingual, reproducible computation in R and Python.
The Actuarial Codebase
When an eight-million-dollar spreadsheet error threatens Northbridge Mutual with regulatory seizure, second-year actuarial analyst Maya Lin must rebuild the insurer's entire computational core across R and Python into an auditable, reproducible production engine.
At seven forty-five on a rainy Monday morning, Maya Lin opens Northbridge's master commercial auto workbook. Cell F-one-hundred-and-forty-two displays an eight-point-four million dollar reserve deficit, caused entirely by an intern dragging an unanchored VLOOKUP formula across forty-eight accident quarters.
Transcript
At seven forty-five on a rainy Monday morning, Maya Lin opens Northbridge's master commercial auto workbook. Cell F-one-hundred-and-forty-two displays an eight-point-four million dollar reserve deficit, caused entirely by an intern dragging an unanchored VLOOKUP formula across forty-eight accident quarters.
- Structure tabular insurance data according to tidy data principles using tibbles
- Manipulate and transform policyholder and claims records using core dplyr verbs
- Reshape development triangles and multi-year rating tables using tidyr pivot functions
- Apply vectorised operations to compute actuarial metrics such as loss ratios and pure premiums efficiently