adding a new column using values in another column using pandas

Question

I have a data set

id     Category    Date
1       Sick      2016-10-10
                  12:10:21
2       Active    2017-09-08
                  11:09:06
3       Weak      2018-11-12
                  06:10:04

Now i want to add a new column which only has year in the data set using pandas?

Dani Mesejo · Accepted Answer · 2018-12-21 08:48:15Z

1

You could do:

import pandas as pd
data = [[1, 'Sick  ', '2016-10-10 12:10:21'],
        [2, 'Active', '2017-09-08 11:09:06'],
        [3, 'Weak  ', '2018-11-12 06:10:04']]

df = pd.DataFrame(data=data, columns=['id', 'category', 'date'])

df['year'] =  pd.to_datetime(df['date']).dt.year

print(df)

Output

id category                 date  year
0   1   Sick    2016-10-10 12:10:21  2016
1   2   Active  2017-09-08 11:09:06  2017
2   3   Weak    2018-11-12 06:10:04  2018

answered Dec 21, 2018 at 8:48

Dani Mesejo

62.1k6 gold badges56 silver badges86 bronze badges

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

1 Comment

Dani Mesejo Over a year ago

@shrutyam Glad I could help, if my answer was helpful please consider marking it as accepted.

anky · Accepted Answer · 2018-12-21 08:50:50Z

1

you can just do df['year'] = pd.DatetimeIndex(df['Date']).year

Output:

    id  category    Date                year
0   1   Sick       2016-10-10 12:10:21  2016
1   2   Active     2017-09-08 11:09:06  2017
2   3   Weak       2018-11-12 06:10:04  2018

answered Dec 21, 2018 at 8:50

anky

75.3k11 gold badges46 silver badges76 bronze badges

Collectives™ on Stack Overflow

adding a new column using values in another column using pandas

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related