How to add a prefix string in the values of dataframe

Question

Here I'm having a dataframe which shows only the last two digits of year:

YEAR  DWT   RFR
10    6571  1200
11    6421  1200
98    7786  3000
02    9191  1250

I want to make them as a complete year value, is there any solution for this?

expected output:

YEAR    DWT   RFR
2010    6571  1200
2011    6421  1200
1998    7786  3000
2002    9191  1250

How do you expect to determine whether it's a 2000s value or a 1900s value? — Henry Ecker
– Henry Ecker ♦, Commented Jul 8, 2021 at 20:35
Please repeat on topic and how to ask from the intro tour. “Show me how to solve this coding problem” is not a Stack Overflow issue. We expect you to make an honest attempt, and then ask a specific question about your algorithm or technique. Stack Overflow is not intended to replace existing documentation and tutorials. — Prune
– Prune, Commented Jul 8, 2021 at 20:36

Corralien · Accepted Answer · 2021-07-08 20:39:18Z

2

Is it what you expect? The current year can be the pivot.

>>> pivot_year = pd.Timestamp.now().year % 100

>>> df['YEAR'].astype(int) \
              .apply(lambda y: y + (2000 if y <= pivot_year else 1900))

0    2010
1    2011
2    1998
3    2002
Name: YEAR, dtype: int64

edited Jul 8, 2021 at 20:39

answered Jul 8, 2021 at 20:36

Corralien

121k8 gold badges44 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Felix K Jose · Accepted Answer · 2021-07-08 21:02:52Z

0

You could achieve this as follows:

from datetime import datetime

import pandas as pd

df1 = pd.DataFrame({'YEAR': ['10', '11', '98', '02'], 'DWT': [6571, 6421, 7786, 9191], 'RFR': [1200, 1200, 3000, 1250]})
df1['YEAR'] = [datetime.strptime("01/01/" + yr, "%m/%d/%y").year for yr in df1['YEAR']]
print(df1)

   YEAR   DWT   RFR
0  2010  6571  1200
1  2011  6421  1200
2  1998  7786  3000
3  2002  9191  1250

answered Jul 8, 2021 at 21:02

Felix K Jose

9029 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to add a prefix string in the values of dataframe

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related