دنبال کننده ها

۱۳۹۶ مرداد ۱۰, سه‌شنبه

subset - Transform a column values

[ad_1]



Hello my question is: I have a column that has monthly, quarters and years e.g.



Time



2017 Q1
2017 Q2
2017
2016
Mar-07
Apr-07



I want to create another column such that: if it is a month then it should became the first day of the month 2015-03-01, if it is a year it shoul became the first day of the year 2017-01-01, and if it is a quarter1 then the 2017-01-01, if it is quarter 2 then 2017-04-01, if quarter 3 then 2017-07-01,if quarter 4 then 2017-10-2017. Thanks




[ad_2]

لینک منبع