title: Removing duplicate columns in pandas dataframe
body: <p>I am trying to parse data, but duplicate names under columns started appearing.
  Code:</p>
  <pre><code>import pandas as pd
  
  def parseData():
    countries = pd.read_csv('Int_Monthly_Visitor.csv')
    cols = [e.strip() for e in list(countries.columns)]
    regions = {
        'Others': cols[30:]
    }
  
    countries.rename(str.strip, axis='columns', inplace=True)
  
    regionlist = pd.DataFrame({'Columns': regions['Others'], 'Non-Null count': countries.loc[0:120, regions['Others']].count()})
  
    print(regionlist)
  
  parseData()
  </code></pre>
  <p>Output:</p>
  <pre><code>                 Columns  Non-Null count
  USA                  USA             121
  Canada            Canada             121
  Australia      Australia             121
  New Zealand  New Zealand             121
  Africa            Africa             121
  </code></pre>
  <p>Expected output:</p>
  <pre><code>Columns        Non-Null count
  USA                       121
  Canada                    121
  Australia                 121
  New Zealand               121
  Africa                    121
  </code></pre>
  <p>Is there a solution to remove the duplicate names under columns?</p>