Actuarium
← All video courses

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.

Season 1 · 8 episodes

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.

Protagonist · Maya Lin, an ambitious second-year actuarial analyst at Northbridge Mutual with dual training in loss modeling and software engineering.
Setting · Northbridge Mutual's high-pressure actuarial department in Chicago, navigating state regulatory audits, legacy mainframes, and modern polyglot data stacks.
Stakes · A looming state insurance department audit threatens to revoke Northbridge's commercial underwriting license unless every reserve, pricing model, and life valuation is proved fully reproducible under actuarial standards of practice.
Pick an episode
Cold open

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
Ask the tutor