/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

2 votes160 views2 answers
How to play audio in python
Python
0 vote228 views3 answers
How to create a User and User profile in django rest framework
Python Django
-1 vote194 views1 answer
Import csv from google drive python
Python
1 vote183 views1 answer
[Solved] TypeError: ‘numpy.float64’ object cannot be interpreted as an integer
Python
2 votes231 views2 answers
Pandas if nan, then the row above
Python
0 vote232 views1 answer
Difference between __gte and __lte in Django
Python
0 vote197 views2 answers
How to create a file in a specific location in python
Python
0 vote201 views1 answer
Pandas dataframe to parquet s3
Python
0 vote195 views1 answer
Python create tuple from input
Python
0 vote203 views1 answer
Python sum of 10 numbers from user input
Python