title: How to get country name from country abbreviation in python with mix of alpha_2 and alpha_3 ccodes
body: <p>i have a data frame as below :</p>
  
  <pre><code>df = pd.DataFrame({"country_code": ['AF', 'BEL', 'AUS', 'DE', 'IND', 'US', 'GBR'],
                "amount": [100, 200, 140, 400, 225, 125, 600]})
  </code></pre>
  
  <p>Column country code is a mix of both 2 letter and 3 letter country abbreviation.</p>
  
  <p>Can any one kindly help me how to get the Full Country name in a new column in the same df ?</p>