title: Convert dates to specific format
body: <p>I have a pandas dataframe that looks like:</p>
  
  <pre><code>import pandas as pd
  df1 = pd.DataFrame({'Counterparty':['Bank','Client','Bank','Bank','Bank','Bank'],
           'Date':['4Q18','1Q19','2Q19','4Q21','FY22','H123']
          })
  </code></pre>
  
  <p>I want to convert the 'Date' column from a string to a date such that the date is the last date for that particular period. ie 'FQ18'= 31st Dec 2018, '1Q19' = 31st Mar 2019, 'FY22' = 31st Dec 2022,'H123'= 30th June 2023</p>
  
  <p>Any suggestions how to achieve this ?</p>