/Python/Convert birth date column to age pandas

Convert birth date column to age pandas

Convert birth date to age pandas

(pd.to_datetime('today').year-pd.to_datetime('1956-07-01').year)

Out[83]: 61

Source: stackoverflow.com

Convert birth date column to age pandas

import datetime as DT
import io
import numpy as np
import pandas as pd

pd.options.mode.chained_assignment = 'warn'

content = '''     ssno        lname         fname    pos_title             ser  gender  dob 
0    23456789    PLILEY     JODY        BUDG ANAL             0560  F      031871 
1    987654321   NOEL       HEATHER     PRTG SRVCS SPECLST    1654  F      120852
2    234567891   SONJU      LAURIE      SUPVY CONTR SPECLST   1102  F      010999
3    345678912   MANNING    CYNTHIA     SOC SCNTST            0101  F      081692
4    456789123   NAUERTZ    ELIZABETH   OFF AUTOMATION ASST   0326  F      031387'''

df = pd.read_csv(io.StringIO(content), sep='\s{2,}')
df['dob'] = df['dob'].apply('{:06}'.format)

now = pd.Timestamp('now')
df['dob'] = pd.to_datetime(df['dob'], format='%m%d%y')    # 1
df['dob'] = df['dob'].where(df['dob'] < now, df['dob'] -  np.timedelta64(100, 'Y'))   # 2
df['age'] = (now - df['dob']).astype('<m8[Y]')    # 3
print(df)

Source: stackoverflow.com

Similar codes

0 vote278 views1 answer
Block encoding request python
Python
46 votes261 views6 answers
Dataframe to CSV
Python
1 vote258 views1 answer
Jupyter notebook "TypeError: 'numpy.ndarray' object is not callable"
Python
1 vote255 views1 answer
Convert url to base64 image py
Python
0 vote269 views1 answer
Login system user exist in textfile python
Python
3 votes250 views3 answers
Django.db.utils.OperationalError: no such table:
Python
0 vote230 views1 answer
Zip used in python stack overflow
Python
12 votes276 views6 answers
Python merge dictionaries
Python
46 votes284 views3 answers
Pandas apply function to every row
Python
225 votes456 views6 answers
Random number generator python
Python