Calculate Year wise age in Pandas

Issue

This Content is from Stack Overflow. Question asked by TheSarfaraz

Let’s say I have an Employees Table and yearly survey filled by each person.
I have to transform transactional data into prediction data year wise.

Available Data:

E_IDTestYearDateOfBirth
120101947-01-01
120111947-01-01
120121947-01-01
220101990-01-01
320111999-01-01
420111991-01-01
420121991-01-01
520101989-01-01
520111989-01-01
520121989-01-01
520131989-01-01

DataFrame I need:

E_IDYearAge
1201063
1201164
1201265
2201020
2201121
2201222
3201011
3201112
3201213
4201019
4201120
4201221
5201021
5201122
5201223

In the new df I need all employees, for all 3 years 2010, 2011, 2022 and their relevant ages in the year 2010, 2011, 2022 respectively.

How to achieve this? Since in the transactional data, I have records for some employees for some years and not for other years.



Solution

This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.

This Question and Answer are collected from stackoverflow and tested by JTuto community, is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?