I have a dataset that has dates of births listed in the column (xx/xx/xxxx). How do I script a code in Python to changes these to single age numbers as of 12/31/2022? (So line zero should read 89) Below is a snapshot of some of my data. I would also like to change the heading to read 'Age' versus DOB. How would I do that? 

 

 

Transcribed Image Text:

Case Number APS Filed 0 2021-10-02949 1 2022-10-03024 2 2022-10-03024 3 2021-06-01815 4 2021-08-02482 Suspicious Activity Gender Suspicious Call Female 5/5/1933 No Unusual/unexplained Activity Female 6/17/1966 No Unusual/unexplained Activity Male 11/14/1963 Fraudulent Patterns Female 6/16/1937 No 2 2 2 No Unknown Source of Funds DOB US Citizen Male 10/29/1962 Yes Yes Yes Yes Yes State Product New Mexico Life Insurance Georgia Fixed Annuity Georgia Fixed Annuity Michigan Life Insurance New York Life Insurance Case Number APS Filed 0 2021-10-02949 1 2022-10-03024 2 2022-10-03024 3 2021-06-01815 4 2021-08-02482 Suspicious Activity Gender Suspicious Call Female 5/5/1933 No Unusual/unexplained Activity Female 6/17/1966 No Unusual/unexplained Activity Male 11/14/1963 Fraudulent Patterns Female 6/16/1937 No 2 2 2 No Unknown Source of Funds DOB US Citizen Male 10/29/1962 Yes Yes Yes Yes Yes State Product New Mexico Life Insurance Georgia Fixed Annuity Georgia Fixed Annuity Michigan Life Insurance New York Life Insurance

Answer rating: 100% (QA)

Python code import pandas as pd from datetime import datetime Sample data data Case Number 20... View the full answer