{"cells":[
 {
  "cell_type": "code",
  "execution_count": null,
  "metadata": {
   "collapsed": false
  },
  "outputs": [],
  "source": "import csv\n\nmap = {}\nwith open('../input/cliente_tabla.csv', 'r', encoding='utf-8') as client_name:\n    infile = csv.reader(client_name)\n    for a in infile:\n        b = \" \".join(a[1].split())\n        if b in map.keys():\n            map[b] += 1\n        else:\n            map[b] = 1\n\n# There are 281670 \"NO IDENTIFICADO\" client names\n# Removing from the dictionary\nmap.pop('NO IDENTIFICADO')\n\nprint(\"Total number of unique client names:\", len(map))\n\nfor x in map:\n    if map[x] > 600:\n        print(x,'-', map[x])\n"
 }
],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"}}, "nbformat": 4, "nbformat_minor": 0}