CODEWITHSUNDEEP
pythonpandaspython-datetime
Danlo9
Danlo9

Reputation: 143

Create date column from quarter and year columns

Let's say I have the following columns in a dataframe.

temp = pd.DataFrame({'quarter': [1, 2, 1, 3, 4],
                   'year': [1994, 1995, 2001, 1997, 2014]})

How can I create a new 'date' column that represents the time with a datetime object? Let quarter 1 be Jan 1, quarter 2 be March 1, quarter 3 be June 1, and quarter 4 be Sept 1. For example, if it were quarter 1 in 1994, the 'date' column should have 1994-01-01.

Upvotes: 0

Views: 942

Answers (1)

Quang Hoang
Quang Hoang

Reputation: 150745

You can use pd.to_datetime:

pd.to_datetime(temp['year'].astype(str) + 'Q' + temp['quarter'].astype(str))

Output:

0   1994-01-01
1   1995-04-01
2   2001-01-01
3   1997-07-01
4   2014-10-01
dtype: datetime64[ns]

Upvotes: 1

Related Questions