Updating values within python column based on date

Question

I have a dataset where I would like to replace and update values within a column when a data condition is met. Data Desired Doing Still researching, any suggestion is appreciated- Perhaps I need to convert quarters to datetime longdate and base the condition off of this column. Answer here is one way to do it to apply the condition,

Accepted Answer

here is one way to do itto apply the condition, Date need to be in Year and Quarter, and then applying np.where condition.However, you need to put the condition in the same format i.e. YYQ (year, quarter)df['File']= np.where( ( df['ID'] =='AA') &                        ((df['Date'].str[-2:] + df['Date'].str[1:2]).astype(int) <=231)                     , 'yes'                     , df['File'] )df    ID  Date    State   File0   AA  Q122    NY      yes1   AA  Q222    NY      yes2   AA  Q322    NY      yes3   AA  Q422    NY      yes4   AA  Q123    NY      yes5   AA  Q223    NY      closed6   AA  Q323    NY      closed7   AA  Q423    NY      closed8   BB  Q124    CA      closed9   BB  Q224    CA      open10  BB  Q324    CA      open11  BB  Q424    CA      open12  BB  Q125    CA      open13  BB  Q225    CA      open14  BB  Q325    CA      open15  BB  Q425    CA      open

Advertisement

Answer