title: Get value and line number for non unique parameters in csv file
body: <p>I need to check the csv file for uniqueness of all values in each column and get the number of the row where the nonunique parameter is located and its value. Example file</p>
  
  <pre><code>Vendor,Email,Country
  Nick,nick@gmail.com,US
  Joe,joe@gmail.com,NL
  Nick,nk@gmail.com,GB
  Mary,nk@gmail.com,AU
  </code></pre>
  
  <p>Expected result</p>
  
  <pre><code>name = [{'Nick':3},]
  email = [{'nk@gmail.com':4},]
  </code></pre>
  
  <p>or something like that, this output format is optional</p>
  
  <p>All I was able to do was pass the uniqueness test. I did it in two ways.</p>
  
  <p><strong>1.Using python csv library</strong></p>
  
  <pre><code>with open(file) as csvfile:
      reader = csv.DictReader(csvfile)
      # Check uniques vendor name and email in file without request to DB
      vendor_list = []
      email_list = []
      for count, rows in enumerate(reader, 1):
          vendor_list.append(rows['Vendor'])
          email_list.append(rows['Email'])
      vendor_unique = set(vendor_list)
      email_unique = set(email_list)
      if len(vendor_list) != len(vendor_unique) or len(email_list) != len(email_unique):
          raise ParseError('Your name and email should be unique')
  </code></pre>
  
  <p><strong>2. Using pandas</strong></p>
  
  <pre><code>import pandas as pd
  record = pd.read_csv(file)
  if ((len(record['Email'])) != (len(record['Email'].unique())):
      raise ParseError('Your email should be unique')
  elif (len(record['Vendor']) != len(record['Vendor'].unique())):
      raise ParseError('Your name should be unique')
  </code></pre>