examples/databricks/FebrlExample.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "afec4ed8-c1f7-4535-8aff-c438a59f2fd4",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Demo Notebook For Training and Running Zingg Entity Resolution Workflow on Databricks\n",
    "This notebook runs the Zingg Febrl Example on Databricks. \n",
    "Please refer to the \n",
    "1. [Zingg Python API](https://readthedocs.org/projects/zingg/) \n",
    "2. [Zingg Official Documentation](https://www.docs.zingg.ai) \n",
    "for details.\n",
    "\n",
    "Please ensure to follow these prerequisites\n",
    "1. Cluster installed with Zingg from pypi\n",
    "2. Zingg jar from the [repo](https://github.com/zinggAI/zingg/releases)\n, recommended(0.4.0)\n installed in the cluster library\n",
    "3. tabulate from pypi\n",
    "4. Make sure your databricks cluster is spinned up with runtime version 15.4 LTS\n",
    "5. Input csv file been added to DBFS (example csv can be found at ./examples/febrl/test.csv)\n",
    "\n",
    "Please execute each cell one by one as per the instructions provided.\n",
    "\n",
    "If you face any issue, please [log an issue](https://github.com/zinggAI/zingg/issues)\n",
    "\n",
    "You can also join [Zingg's Slack community](https://join.slack.com/t/zinggai/shared_invite/zt-w7zlcnol-vEuqU9m~Q56kLLUVxRgpOA)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "b296c92c-a453-4012-a2b8-5cadb357bc1d",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: zingg in /local_disk0/.ephemeral_nfs/envs/pythonEnv-22a75e71-110b-41de-b590-4de64c3ecf0c/lib/python3.12/site-packages (0.4.0)\nRequirement already satisfied: py4j==0.10.9 in /local_disk0/.ephemeral_nfs/envs/pythonEnv-22a75e71-110b-41de-b590-4de64c3ecf0c/lib/python3.12/site-packages (from zingg) (0.10.9)\n\u001B[43mNote: you may need to restart the kernel using %restart_python or dbutils.library.restartPython() to use updated packages.\u001B[0m\n"
     ]
    }
   ],
   "source": [
    "pip install zingg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "0874b0ef-c643-4b73-9188-d34f31de4ff2",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "dbutils.library.restartPython()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "b7085240-3a7a-4618-8722-b5db097b96fe",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Name: zingg\nVersion: 0.4.0\nSummary: Zingg Entity Resolution, Data Mastering and Deduplication\nHome-page: https://github.com/zinggAI/zingg\nAuthor: Zingg.AI\nAuthor-email: sonalgoyal4@gmail.com\nLicense: https://github.com/zinggAI/zingg/blob/main/LICENSE\nLocation: /local_disk0/.ephemeral_nfs/envs/pythonEnv-22a75e71-110b-41de-b590-4de64c3ecf0c/lib/python3.12/site-packages\nRequires: py4j\nRequired-by: \n"
     ]
    }
   ],
   "source": [
    "pip show zingg"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "7bc6173c-6292-4e0e-b027-1a57736b9bc7",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: tabulate in /databricks/python3/lib/python3.12/site-packages (0.9.0)\n\u001B[43mNote: you may need to restart the kernel using %restart_python or dbutils.library.restartPython() to use updated packages.\u001B[0m\n"
     ]
    }
   ],
   "source": [
    "pip install tabulate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "161b1207-24ff-4943-99d3-a33531f47877",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "dbutils.library.restartPython()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "bddb54f2-2f4b-46df-b636-1f2a2ce31b71",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Name: tabulate\nVersion: 0.9.0\nSummary: Pretty-print tabular data\nHome-page: \nAuthor: \nAuthor-email: Sergey Astanin <s.astanin@gmail.com>\nLicense: MIT\nLocation: /databricks/python3/lib/python3.12/site-packages\nRequires: \nRequired-by: composer\n"
     ]
    }
   ],
   "source": [
    "pip show tabulate"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "db2f411e-d207-4491-be56-dc0017ceed94",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Define locations for the model\n",
    "The Zingg models and training data are persisted in dbfs. \n",
    "\n",
    "**Please edit the model id in the cell below to reflect your model.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "f939d557-3988-443c-a489-c828a93476a4",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "##you can change these to the locations of your choice\n",
    "##these are the only two settings that need to change\n",
    "zinggDir = \"/models\"\n",
    "modelId = \"testModelFebrl\""
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "9332a078-f480-4972-ac23-22790f6aca20",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Setup common functions for use in Zingg. \n",
    "These functions setup the internal folders used by Zingg, and help with labeling and training Zingg. \n",
    "\n",
    "**No change is needed in the cell below.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "37674bf7-57cc-46b7-8052-1134d9b5c045",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/databricks/spark/python/pyspark/sql/context.py:117: FutureWarning: Deprecated in 3.0.0. Use SparkSession.builder.getOrCreate() instead.\n  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "\n",
    "##please leave the following unchanged\n",
    "MARKED_DIR = zinggDir + \"/\" + modelId + \"/trainingData/marked/\"\n",
    "UNMARKED_DIR = zinggDir + \"/\" + modelId + \"/trainingData/unmarked/\"\n",
    "\n",
    "MARKED_DIR_DBFS = \"/dbfs\" + MARKED_DIR\n",
    "UNMARKED_DIR_DBFS = \"/dbfs\" + UNMARKED_DIR  \n",
    "\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    " \n",
    "import time\n",
    "import uuid\n",
    " \n",
    "from tabulate import tabulate\n",
    "from ipywidgets import widgets, interact, GridspecLayout\n",
    "import base64\n",
    "\n",
    "import pyspark.sql.functions as fn\n",
    "\n",
    "##this code sets up the Zingg Python interface\n",
    "from zingg.client import *\n",
    "from zingg.pipes import *\n",
    "\n",
    "def cleanModel():\n",
    "    dbutils.fs.rm(MARKED_DIR, recurse=True)\n",
    "    # drop unmarked data\n",
    "    dbutils.fs.rm(UNMARKED_DIR, recurse=True)\n",
    "    return\n",
    "\n",
    "# assign label to candidate pair\n",
    "def assign_label(candidate_pairs_pd, z_cluster, label):\n",
    "  '''\n",
    "  The purpose of this function is to assign a label to a candidate pair\n",
    "  identified by its z_cluster value.  Valid labels include:\n",
    "     0 - not matched\n",
    "     1 - matched\n",
    "     2 - uncertain\n",
    "  '''\n",
    "  \n",
    "  # assign label\n",
    "  candidate_pairs_pd.loc[ candidate_pairs_pd['z_cluster']==z_cluster, 'z_isMatch'] = label\n",
    "  \n",
    "  return\n",
    " \n",
    "def count_labeled_pairs(marked_pd):\n",
    "  '''\n",
    "  The purpose of this function is to count the labeled pairs in the marked folder.\n",
    "  '''\n",
    "\n",
    "  n_total = len(np.unique(marked_pd['z_cluster']))\n",
    "  n_positive = len(np.unique(marked_pd[marked_pd['z_isMatch']==1]['z_cluster']))\n",
    "  n_negative = len(np.unique(marked_pd[marked_pd['z_isMatch']==0]['z_cluster']))\n",
    "  \n",
    "  return n_positive, n_negative, n_total\n",
    "\n",
    "# setup widget \n",
    "available_labels = {\n",
    "    'No Match':0,\n",
    "    'Match':1,\n",
    "    'Uncertain':2\n",
    "    }\n",
    "#dbutils.widgets.dropdown('label', 'Uncertain', available_labels.keys(), 'Is this pair a match?')\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "694c8a35-a8fc-48f2-8288-e803631fbfe6",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Start building the Zingg program \n",
    "The following cell sets up the initial arguments for Zingg. \n",
    "\n",
    "**No change is needed in the cell below.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "dcc668a0-3e96-4839-9f53-077f56dd25dc",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "\n",
    "#build the arguments for zingg\n",
    "args = Arguments()\n",
    "# Set the modelid and the zingg dir. You can use this as is\n",
    "args.setModelId(modelId)\n",
    "args.setZinggDir(zinggDir)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "7b3eb8bd-d035-413b-84d0-b798e5909335",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Define the input\n",
    "Our data is in csv so we provide a schema. You can choose other formats like parquet by using Pipe with parquet as the format.\n",
    "You can also pass in a dataframe by using a Pipe with the in memory format. \n",
    "Please refer to [Pipes](https://zingg.readthedocs.io/en/latest/zingg.html#zingg.pipes.Pipe) for details on different formats\n",
    "\n",
    "**Please modify this for your data.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "1499f6f7-c9fa-4c95-bc39-7a945cf0758c",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "set schema \n"
     ]
    }
   ],
   "source": [
    "schema = \"rec_id string, fname string, lname string, stNo string, add1 string, add2 string, city string, areaCode string, state string, dob string, ssn string\"\n",
    "inputPipe = CsvPipe(\"zingg_input\", \"/FileStore/tables/test.csv\", schema)\n",
    "\n",
    "args.setData(inputPipe)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "c2c76f3d-6104-4014-b605-f0fe5bcc1650",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Configure the output\n",
    "Here we configure the putput to be a csv, but similar to the input above, the output can be a file format like parquet or delta or a data store like MySQL\n",
    "\n",
    "**Please modify this for your data.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "870e64cd-8053-4c76-bfba-3fe5af44adf4",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "#setting outputpipe in 'args'\n",
    "outputPipe = CsvPipe(\"resultFebrl\", \"/tmp/febrlOutputTest\")\n",
    "args.setOutput(outputPipe)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "98e995ab-fd71-4848-8134-35fabf2ec8c7",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Define the match fields and their types\n",
    "\n",
    "The cell below is used to configure Zingg with the fields for use in matching and the match types.\n",
    "Details on the field definitions can be found at [Zingg official docs](https://www.docs.zingg.ai)\n",
    "\n",
    "**Please modify this for your data.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "e99e237c-7285-4173-91a9-8316fb50f04f",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "#set field definitions \n",
    "#please change these \n",
    "rec_id = FieldDefinition(\"rec_id\", \"string\", MatchType.DONT_USE) \n",
    "fname = FieldDefinition(\"fname\", \"string\", MatchType.FUZZY)\n",
    "lname = FieldDefinition(\"lname\", \"string\", MatchType.FUZZY)\n",
    "stNo = FieldDefinition(\"stNo\", \"string\", MatchType.FUZZY)\n",
    "add1 = FieldDefinition(\"add1\", \"string\", MatchType.FUZZY)\n",
    "add2 = FieldDefinition(\"add2\", \"string\", MatchType.FUZZY)\n",
    "city = FieldDefinition(\"city\", \"string\", MatchType.FUZZY)\n",
    "areaCode = FieldDefinition(\"areaCode\", \"string\", MatchType.FUZZY)\n",
    "state = FieldDefinition(\"state\", \"string\", MatchType.FUZZY)\n",
    "dob = FieldDefinition(\"dob\", \"string\", MatchType.EXACT)\n",
    "ssn = FieldDefinition(\"ssn\", \"string\", MatchType.EXACT) \n",
    "\n",
    "fieldDefs = [recId, fname, lname, stNo, add1, add2, city, areaCode, state, dob, ssn]\n",
    "args.setFieldDefinition(fieldDefs)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "5cecfe15-fe77-4ef3-bde4-818350c0e0bf",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Performance settings\n",
    "\n",
    "The numPartitions define how data is split across the cluster. Please change this as per your data and cluster size by referring to the performance section of the Zingg docs.\n",
    "The labelDataSampleSize is used for sampling in findTrainingData. It lets Zingg select pairs for labeling in a reasonable amount of time. \n",
    "If the findTrainingData phase is taking to much time, please reduce this by atleast 1/10th of its previous value and try again.\n",
    "\n",
    "**Please modify this for your data.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "7841d2ef-c067-45bd-9522-6f318958ed56",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "\n",
    "# The numPartitions define how data is split across the cluster. \n",
    "# Please change the fllowing as per your data and cluster size by referring to the docs.\n",
    "\n",
    "args.setNumPartitions(4)\n",
    "args.setLabelDataSampleSize(0.5)\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "241243b3-1536-467d-89a6-80698e8c57ec",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Get Zingg to find pairs for user labeling\n",
    "**No change is needed in the cell below.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "9747d72e-3330-4b7c-9e60-0e91684eaa3f",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['--phase', 'findTrainingData']\narguments for client options are  ['--phase', 'findTrainingData', '--license', 'zinggLic.txt', '--email', 'zingg@zingg.ai', '--conf', 'dummyConf.json']\n"
     ]
    }
   ],
   "source": [
    "options = ClientOptions([ClientOptions.PHASE,\"findTrainingData\"])\n",
    "\n",
    "#Zingg execution for the given phase\n",
    "zingg = ZinggWithSpark(args, options)\n",
    "zingg.initAndExecute()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "ca70c641-196a-4d17-b14d-43e551aa12c3",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Prepare for user labeling\n",
    "**No change is needed in the cell below.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "25077a5c-1a23-4110-ac7f-819765047839",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['--phase', 'label']\narguments for client options are  ['--phase', 'label', '--license', 'zinggLic.txt', '--email', 'zingg@zingg.ai', '--conf', 'dummyConf.json']\n"
     ]
    }
   ],
   "source": [
    "options = ClientOptions([ClientOptions.PHASE,\"label\"])\n",
    "\n",
    "#Zingg execution for the given phase\n",
    "zingg = ZinggWithSpark(args, options)\n",
    "zingg.init()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "25156ca6-6fe9-4223-b35b-182c371e9c89",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# See if we have records for labeling\n",
    "\n",
    "**No change is needed to the cell below.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "4039051c-1d31-4373-8d53-3955e76b5bba",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/databricks/spark/python/pyspark/sql/dataframe.py:161: UserWarning: DataFrame constructor is internal. Do not directly use it.\n  warnings.warn(\"DataFrame constructor is internal. Do not directly use it.\")\n"
     ]
    },
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "15 candidate pairs found for labeling\n"
     ]
    }
   ],
   "source": [
    "# get candidate pairs\n",
    "candidate_pairs_pd = getPandasDfFromDs(zingg.getUnmarkedRecords())\n",
    " \n",
    "# if no candidate pairs, run job and wait\n",
    "if candidate_pairs_pd.shape[0] == 0:\n",
    "  print('No unlabeled candidate pairs found.  Run findTraining job ...')\n",
    "\n",
    "else:\n",
    "    # get list of pairs (as identified by z_cluster) to label \n",
    "    z_clusters = list(np.unique(candidate_pairs_pd['z_cluster'])) \n",
    "\n",
    "    # identify last reviewed cluster\n",
    "    last_z_cluster = '' # none yet\n",
    "\n",
    "    # print candidate pair stats\n",
    "    print('{0} candidate pairs found for labeling'.format(len(z_clusters)))\n",
    "  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "5b061b19-c2c2-44c8-bc10-716283c48098",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Start labeling to make Zingg learn how we want to match our data\n",
    "\n",
    "**No change is needed to the cell below.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "1d8e5ecf-99dd-4ee1-9dee-5336a27e5746",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "    z_zid         z_cluster  z_prediction  ...  is_matriz     setor    z_zsource\n0      80   1732532356305:0          -1.0  ...      false    Varejo  zingg_input\n1      47   1732532356305:0          -1.0  ...      false  Servicos  zingg_input\n2      72  1732532356305:11          -1.0  ...       true  Servicos  zingg_input\n3      69  1732532356305:11          -1.0  ...      false    Varejo  zingg_input\n4      72  1732532356305:15          -1.0  ...       true  Servicos  zingg_input\n5      17  1732532356305:15          -1.0  ...      false    Varejo  zingg_input\n6      53  1732532356305:19          -1.0  ...      false  Servicos  zingg_input\n7      24  1732532356305:19          -1.0  ...      false  Servicos  zingg_input\n8      43   1732532356305:2          -1.0  ...      false  Servicos  zingg_input\n9      34   1732532356305:2          -1.0  ...      false    Varejo  zingg_input\n10     77  1732532356305:23          -1.0  ...      false    Varejo  zingg_input\n11     39  1732532356305:23          -1.0  ...      false    Varejo  zingg_input\n12     35  1732532356305:27          -1.0  ...      false    Varejo  zingg_input\n13     24  1732532356305:27          -1.0  ...      false  Servicos  zingg_input\n14     45   1732532356305:3          -1.0  ...      false    Varejo  zingg_input\n15     31   1732532356305:3          -1.0  ...       true    Varejo  zingg_input\n16     83  1732532356305:31          -1.0  ...       true    Varejo  zingg_input\n17     15  1732532356305:31          -1.0  ...      false  Servicos  zingg_input\n18     31  1732532356305:35          -1.0  ...       true    Varejo  zingg_input\n19     17  1732532356305:35          -1.0  ...      false    Varejo  zingg_input\n20     57  1732532356305:39          -1.0  ...      false    Varejo  zingg_input\n21     17  1732532356305:39          -1.0  ...      false    Varejo  zingg_input\n22     87  1732532356305:43          -1.0  ...       true    Varejo  zingg_input\n23     49  1732532356305:43          -1.0  ...      false    Varejo  zingg_input\n24     69  1732532356305:47          -1.0  ...      false    Varejo  zingg_input\n25     50  1732532356305:47          -1.0  ...      false    Varejo  zingg_input\n26     69  1732532356305:51          -1.0  ...      false    Varejo  zingg_input\n27     17  1732532356305:51          -1.0  ...      false    Varejo  zingg_input\n28     85   1732532356305:7          -1.0  ...       true  Servicos  zingg_input\n29     18   1732532356305:7          -1.0  ...      false    Varejo  zingg_input\n\n[30 rows x 13 columns]\n['1732532356305:0', '59.265.362/4454-15', 'Padaria da Ana LTDA', 'Loja 72', 'Rua 37, 411', 'Rio de Janeiro', 'false', 'Varejo']\n['1732532356305:0', '59.772.819/4499-52', 'Empresa 187 LTDA', 'Loja 68', 'Rua 35, 289', 'Rio de Janeiro', 'false', 'Servicos']\n['1732532356305:11', '93.535.877/4086-88', 'Empresa 759 LTDA', 'Loja 83', 'Rua 61, 249', 'Curitiba', 'true', 'Servicos']\n['1732532356305:11', '93.577.728/9353-36', 'Padaria da Ana LTDA', 'Padaria da Ana', 'Rua 67, 329', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:15', '93.535.877/4086-88', 'Empresa 759 LTDA', 'Loja 83', 'Rua 61, 249', 'Curitiba', 'true', 'Servicos']\n['1732532356305:15', '90.785.993/1204-12', 'Empresa 207 LTDA', 'Padaria da Ana', 'Rua 41, 154', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:19', '46.591.164/9433-72', 'Mercadinho da Maria LTDA', 'Mercadinho da Maria', 'Rua 96, 562', 'Sao Paulo', 'false', 'Servicos']\n['1732532356305:19', '41.851.530/8120-66', 'Mercadinho da Maria LTDA', 'Mercadinho da Maria', 'Rua 64, 150', 'Rio de Janeiro', 'false', 'Servicos']\n['1732532356305:2', '11.906.791/1647-30', 'Loja do Joao LTDA', 'Loja do Joao', 'Rua 13, 827', 'Rio de Janeiro', 'false', 'Servicos']\n['1732532356305:2', '11.757.809/2364-97', 'Cafe do Pedro LTDA', 'Cafe do Pedro', 'Rua 76, 879', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:23', '80.388.385/2416-64', 'Cafe do Pedro LTDA', 'Cafe do Pedro', 'Rua 92, 254', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:23', '84.112.273/4908-56', 'Empresa 933 LTDA', 'Padaria da Ana', 'Rua 7, 152', 'Curitiba', 'false', 'Varejo']\n['1732532356305:27', '47.704.450/8952-62', 'Empresa 932 LTDA', 'Loja do Joao', 'Rua 50, 293', 'Curitiba', 'false', 'Varejo']\n['1732532356305:27', '41.851.530/8120-66', 'Mercadinho da Maria LTDA', 'Mercadinho da Maria', 'Rua 64, 150', 'Rio de Janeiro', 'false', 'Servicos']\n['1732532356305:3', '98.504.730/1529-12', 'Mercadinho da Maria LTDA', 'Loja 6', 'Rua 28, 278', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:3', '97.583.813/1197-57', 'Loja do Joao LTDA', 'Loja do Joao', 'Rua 52, 268', 'Sao Paulo', 'true', 'Varejo']\n['1732532356305:31', '75.235.903/3955-46', 'Cafe do Pedro LTDA', 'Cafe do Pedro', 'Rua 19, 362', 'Rio de Janeiro', 'true', 'Varejo']\n['1732532356305:31', '74.154.244/4443-83', 'Empresa 48 LTDA', 'Loja do Joao', 'Rua 14, 253', 'Rio de Janeiro', 'false', 'Servicos']\n['1732532356305:35', '97.583.813/1197-57', 'Loja do Joao LTDA', 'Loja do Joao', 'Rua 52, 268', 'Sao Paulo', 'true', 'Varejo']\n['1732532356305:35', '90.785.993/1204-12', 'Empresa 207 LTDA', 'Padaria da Ana', 'Rua 41, 154', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:39', '90.807.122/1966-20', 'Loja do Joao LTDA', 'Loja do Joao', 'Rua 50, 585', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:39', '90.785.993/1204-12', 'Empresa 207 LTDA', 'Padaria da Ana', 'Rua 41, 154', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:43', '82.338.719/6269-83', 'Mercadinho da Maria LTDA', 'Loja 49', 'Rua 41, 581', 'Curitiba', 'true', 'Varejo']\n['1732532356305:43', '83.941.876/9211-76', 'Mercadinho da Maria LTDA', 'Mercadinho da Maria', 'Rua 92, 469', 'Curitiba', 'false', 'Varejo']\n['1732532356305:47', '93.577.728/9353-36', 'Padaria da Ana LTDA', 'Padaria da Ana', 'Rua 67, 329', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:47', '94.992.823/5519-85', 'Loja do Joao LTDA', 'Loja do Joao', 'Rua 83, 928', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:51', '93.577.728/9353-36', 'Padaria da Ana LTDA', 'Padaria da Ana', 'Rua 67, 329', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:51', '90.785.993/1204-12', 'Empresa 207 LTDA', 'Padaria da Ana', 'Rua 41, 154', 'Sao Paulo', 'false', 'Varejo']\n['1732532356305:7', '48.532.785/2851-19', 'Mercadinho da Maria LTDA', 'Loja 74', 'Rua 80, 728', 'Sao Paulo', 'true', 'Servicos']\n['1732532356305:7', '49.412.210/5022-23', 'Cafe do Pedro LTDA', 'Cafe do Pedro', 'Rua 31, 368', 'Belo Horizonte', 'false', 'Varejo']\n"
     ]
    },
    {
     "output_type": "display_data",
     "data": {
      "application/vnd.jupyter.widget-view+json": {
       "model_id": "3be96a85256a4f80a5f54b3cc74ac00f",
       "version_major": 2,
       "version_minor": 0
      },
      "text/plain": [
       "VBox(children=(HTML(value='<h2>Indicate if each of the 15 record pairs is a match or not</h2></p>'), VBox(chil…"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "# Label Training Set\n",
    "\n",
    "# define variable to avoid duplicate saves\n",
    "ready_for_save = False\n",
    "print(candidate_pairs_pd)\n",
    "\n",
    "# user-friendly labels and corresponding zingg numerical value\n",
    "# (the order in the dictionary affects how displayed below)\n",
    "LABELS = {\n",
    "  'Uncertain':2,\n",
    "  'Match':1,\n",
    "  'No Match':0  \n",
    "  }\n",
    "\n",
    "# GET CANDIDATE PAIRS\n",
    "# ========================================================\n",
    "#candidate_pairs_pd = get_candidate_pairs()\n",
    "n_pairs = int(candidate_pairs_pd.shape[0]/2)\n",
    "# ========================================================\n",
    "\n",
    "# DEFINE IPYWIDGET DISPLAY\n",
    "# ========================================================\n",
    "display_pd = candidate_pairs_pd.drop(\n",
    "  labels=[\n",
    "    'z_zid', 'z_prediction', 'z_score', 'z_isMatch', 'z_zsource'\n",
    "    ], \n",
    "  axis=1)\n",
    "\n",
    "# define header to be used with each displayed pair\n",
    "html_prefix = \"<p><span style='font-family:Courier New,Courier,monospace'>\"\n",
    "html_suffix = \"</p></span>\"\n",
    "header = widgets.HTML(value=f\"{html_prefix}<b>\" + \"<br />\".join([str(i)+\"&nbsp;&nbsp;\" for i in display_pd.columns.to_list()]) + f\"</b>{html_suffix}\")\n",
    "\n",
    "# initialize display\n",
    "vContainers = []\n",
    "vContainers.append(widgets.HTML(value=f'<h2>Indicate if each of the {n_pairs} record pairs is a match or not</h2></p>'))\n",
    "\n",
    "# for each set of pairs\n",
    "for n in range(n_pairs):\n",
    "\n",
    "  # get candidate records\n",
    "  candidate_left = display_pd.loc[2*n].to_list()\n",
    "  print(candidate_left)\n",
    "  candidate_right = display_pd.loc[(2*n)+1].to_list()\n",
    "  print(candidate_right)\n",
    "\n",
    "  # define grid to hold values\n",
    "  html = ''\n",
    "\n",
    "  for i in range(display_pd.shape[1]):\n",
    "\n",
    "    # get column name\n",
    "    column_name = display_pd.columns[i]\n",
    "\n",
    "    # if field is image\n",
    "    if column_name == 'image_path':\n",
    "\n",
    "      # define row header\n",
    "      html += '<tr>'\n",
    "      html += '<td><b>image</b></td>'\n",
    "\n",
    "      # read left image to encoded string\n",
    "      l_endcode = ''\n",
    "      if candidate_left[i] != '':\n",
    "        with open(candidate_left[i], \"rb\") as l_file:\n",
    "          l_encode = base64.b64encode( l_file.read() ).decode()\n",
    "\n",
    "      # read right image to encoded string\n",
    "      r_encode = ''\n",
    "      if candidate_right[i] != '':\n",
    "        with open(candidate_right[i], \"rb\") as r_file:\n",
    "          r_encode = base64.b64encode( r_file.read() ).decode()      \n",
    "\n",
    "      # present images\n",
    "      html += f'<td><img src=\"data:image/png;base64,{l_encode}\"></td>'\n",
    "      html += f'<td><img src=\"data:image/png;base64,{r_encode}\"></td>'\n",
    "      html += '</tr>'\n",
    "\n",
    "    elif column_name != 'image_path':  # display text values\n",
    "\n",
    "      if column_name == 'z_cluster': z_cluster = candidate_left[i]\n",
    "\n",
    "      html += '<tr>'\n",
    "      html += f'<td style=\"width:10%\"><b>{column_name}</b></td>'\n",
    "      html += f'<td style=\"width:45%\">{str(candidate_left[i])}</td>'\n",
    "      html += f'<td style=\"width:45%\">{str(candidate_right[i])}</td>'\n",
    "      html += '</tr>'\n",
    "\n",
    "  # insert data table\n",
    "  table = widgets.HTML(value=f'<table data-title=\"{z_cluster}\" style=\"width:100%;border-collapse:collapse\" border=\"1\">'+html+'</table>')\n",
    "  z_cluster = None\n",
    "\n",
    "  # assign label options to pair\n",
    "  label = widgets.ToggleButtons(\n",
    "    options=LABELS.keys(), \n",
    "    button_style='info'\n",
    "    )\n",
    "\n",
    "  # define blank line between displayed pair and next\n",
    "  blankLine=widgets.HTML(value='<br>')\n",
    "\n",
    "  # append pair, label and blank line to widget structure\n",
    "  vContainers.append(widgets.VBox(children=[table, label, blankLine]))\n",
    "\n",
    "# present widget\n",
    "display(widgets.VBox(children=vContainers))\n",
    "# ========================================================\n",
    "\n",
    "# mark flag to allow save \n",
    "ready_for_save = True\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "a9d4a8fd-3ec8-40f9-86ed-4a58cb65d13d",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Save all the labels provided by the user \n",
    "No change is needed to the cell below."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "c420e4b2-d221-46d4-8242-5044becb8d7e",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/databricks/spark/python/pyspark/sql/dataframe.py:154: UserWarning: DataFrame constructor is internal. Do not directly use it.\n  warnings.warn(\"DataFrame constructor is internal. Do not directly use it.\")\n"
     ]
    },
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "You have accumulated 0 pairs labeled as positive matches.\nYou have accumulated 14 pairs labeled as not matches.\nIf you need more pairs to label, re-run the cell for 'findTrainingData'\n"
     ]
    }
   ],
   "source": [
    "if not ready_for_save:\n",
    "  print('No labels have been assigned. Run the previous cell to create candidate pairs and assign labels to them before re-running this cell.')\n",
    "\n",
    "else:\n",
    "\n",
    "  # ASSIGN LABEL VALUE TO CANDIDATE PAIRS IN DATAFRAME\n",
    "  # ========================================================\n",
    "  # for each pair in displayed widget\n",
    "  for pair in vContainers[1:]:\n",
    "\n",
    "    # get pair and assigned label\n",
    "    html_content = pair.children[1].get_interact_value() # the displayed pair as html\n",
    "    user_assigned_label = pair.children[1].get_interact_value() # the assigned label\n",
    "\n",
    "    # extract candidate pair id from html pair content\n",
    "    start = pair.children[0].value.find('data-title=\"')\n",
    "    if start > 0: \n",
    "      start += len('data-title=\"') \n",
    "      end = pair.children[0].value.find('\"', start+2)\n",
    "    pair_id = pair.children[0].value[start:end]\n",
    "\n",
    "\n",
    "\n",
    "    # assign label to candidate pair entry in dataframe\n",
    "    candidate_pairs_pd.loc[candidate_pairs_pd['z_cluster']==pair_id, 'z_isMatch'] = LABELS.get(user_assigned_label)\n",
    "  # ========================================================\n",
    "\n",
    "  # SAVE LABELED DATA TO ZINGG FOLDER\n",
    "  # ========================================================\n",
    "  # make target directory if needed\n",
    "  dbutils.fs.mkdirs(MARKED_DIR)\n",
    "  \n",
    "  # save label assignments\n",
    "  # save labels\n",
    "  zingg.writeLabelledOutputFromPandas(candidate_pairs_pd,args)\n",
    "\n",
    "  # count labels accumulated\n",
    "  marked_pd_df = getPandasDfFromDs(zingg.getMarkedRecords())\n",
    "  n_pos, n_neg, n_tot = count_labeled_pairs(marked_pd_df)\n",
    "  print(f'You have accumulated {n_pos} pairs labeled as positive matches.')\n",
    "  print(f'You have accumulated {n_neg} pairs labeled as not matches.')\n",
    "  print(\"If you need more pairs to label, re-run the cell for 'findTrainingData'\")\n",
    "  # ========================================================  \n",
    "\n",
    "  # save completed\n",
    "  ready_for_save = False"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "5b75993a-d02c-4542-8ddb-dec2440d14e3",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "StructType([StructField('z_zid', LongType(), True), StructField('z_cluster', StringType(), True), StructField('z_prediction', DoubleType(), True), StructField('z_score', DoubleType(), True), StructField('z_isMatch', IntegerType(), True), StructField('fname', StringType(), True), StructField('lname', StringType(), True), StructField('stNo', StringType(), True), StructField('add1', StringType(), True), StructField('add2', StringType(), True), StructField('city', StringType(), True), StructField('areacode', StringType(), True), StructField('state', StringType(), True), StructField('dob', StringType(), True), StructField('ssn', StringType(), True), StructField('z_zsource', StringType(), True)])"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "4c6a7266-658c-4705-9a49-2bb99dcadfe9",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Persist the Zingg models by training on the labels and run them to predict matches\n",
    "No change is needed to the cell below."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "eea6f5f8-12a3-4fbf-be9b-828dbc0e4e62",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['--phase', 'trainMatch']\narguments for client options are  ['--phase', 'trainMatch', '--license', 'zinggLic.txt', '--email', 'zingg@zingg.ai', '--conf', 'dummyConf.json']\n"
     ]
    }
   ],
   "source": [
    "options = ClientOptions([ClientOptions.PHASE,\"trainMatch\"])\n",
    "\n",
    "#Zingg execution for the given phase\n",
    "zingg = ZinggWithSpark(args, options)\n",
    "zingg.initAndExecute()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "d15cba22-baa5-4632-9902-39f8ff7bcabb",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Voila! We are done. Lets check the results. \n",
    "\n",
    "**No change is needed to the cell below.**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "535490e1-a62d-4efb-a2c8-91cf3dcd31ba",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "outputDF = spark.read.csv('/tmp/febrlOutputTest')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "ce5516ed-ee36-4007-89b5-e54d488fed9b",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+------------------+------------------+---------+------------------+--------------------+--------------------+-----------------+--------------+---------+--------+\n|        z_minScore|        z_maxScore|z_cluster|              cnpj|        razao_social|       nome_fantasia|         endereco|        cidade|is_matriz|   setor|\n+------------------+------------------+---------+------------------+--------------------+--------------------+-----------------+--------------+---------+--------+\n|               0.0| 0.999999999999984|        4|98.504.730/1529-12|Mercadinho da Mar...|              Loja 6|      Rua 28, 278|     Sao Paulo|    false|  Varejo|\n|               0.0| 0.996332772575339|       12|89.706.338/5779-60| Padaria da Ana LTDA|      Padaria da Ana|      Rua 34, 686|Belo Horizonte|    false|  Varejo|\n|               0.0|0.9999247047927796|        8|48.532.785/2851-19|Mercadinho da Mar...|             Loja 74|      Rua 80, 728|     Sao Paulo|     true|Servicos|\n|               0.0| 0.999999999712641|        4|91.577.888/4312-98|   Loja do Joao LTDA|        Loja do Joao|      Rua 13, 474|      Curitiba|    false|Servicos|\n|               0.0| 0.999936610104941|        1|50.270.137/5375-88| Padaria da Ana LTDA|             Loja 90|      Rua 21, 193|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9999700428130347|        8|46.591.164/9433-72|Mercadinho da Mar...| Mercadinho da Maria|      Rua 96, 562|     Sao Paulo|    false|Servicos|\n|0.9999992044059407|0.9999992044059407|       51|23.156.999/6614-11|    Empresa 687 LTDA| Mercadinho da Maria|       Rua 8, 176|     Sao Paulo|    false|Servicos|\n|               0.0|0.9999999999044875|        1|58.868.202/8314-71| Padaria da Ana LTDA|             Loja 62|       Rua 3, 599|     Sao Paulo|     true|  Varejo|\n|               0.0|0.8652135659541409|        8|47.689.836/1567-48|    Empresa 425 LTDA|      Padaria da Ana|      Rua 38, 863|Belo Horizonte|    false|Servicos|\n|               0.0|0.9999999975753746|        1|59.772.819/4499-52|    Empresa 187 LTDA|             Loja 68|      Rua 35, 289|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9999946218345989|       10|11.102.630/4468-50|    Empresa 499 LTDA|      Padaria da Ana|      Rua 19, 696|Rio de Janeiro|     true|Servicos|\n|               0.0|0.9999600078506048|       22|69.787.546/4657-71|  Cafe do Pedro LTDA|       Cafe do Pedro|        Rua 13, 5|Rio de Janeiro|    false|  Varejo|\n|               0.0|0.9999999999999988|        4|91.145.892/4234-64|   Loja do Joao LTDA|        Loja do Joao|      Rua 21, 872|     Sao Paulo|     true|  Varejo|\n|               0.0|0.9999999985130463|        1|56.133.896/8746-23|   Loja do Joao LTDA|             Loja 41|      Rua 75, 518|Belo Horizonte|    false|Servicos|\n|               0.0|0.9999999999989102|       12|80.388.385/2416-64|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 92, 254|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999999999963797|       12|87.343.131/6226-59|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 25, 297|      Curitiba|    false|  Varejo|\n|               0.0|0.9999999999999993|       22|64.420.757/6186-92|    Empresa 307 LTDA|             Loja 94|      Rua 30, 408|Rio de Janeiro|    false|  Varejo|\n|               0.0|0.9999936092363207|        8|46.244.615/6020-67|Mercadinho da Mar...| Mercadinho da Maria|      Rua 46, 210|Rio de Janeiro|    false|  Varejo|\n|               0.0|0.9999454416482919|       12|84.112.273/4908-56|    Empresa 933 LTDA|      Padaria da Ana|       Rua 7, 152|      Curitiba|    false|  Varejo|\n|               0.0|0.9999999754250444|        9|70.991.886/7816-85| Padaria da Ana LTDA|      Padaria da Ana|       Rua 2, 473|Belo Horizonte|    false|  Varejo|\n|               1.0|               1.0|      102|44.444.444/0001-44|ARCOS DOURADOS CO...|MCDONALDS COMERCI...|Rua Databricks, 4|Belo Horizonte|     true|  Varejo|\n|               0.0|0.9999972280528362|        1|54.968.184/4232-63|    Empresa 675 LTDA| Mercadinho da Maria|       Rua 5, 982|     Sao Paulo|    false|Servicos|\n|               0.0|0.9999999754250444|        9|72.898.414/4002-52|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 42, 431|Belo Horizonte|    false|  Varejo|\n|               0.0|0.9999999999999178|        1|54.399.726/2008-20|    Empresa 570 LTDA|        Loja do Joao|      Rua 47, 816|      Curitiba|    false|Servicos|\n|               0.0|0.9858312920581145|        4|94.425.185/9192-78| Padaria da Ana LTDA|      Padaria da Ana|      Rua 84, 579|      Curitiba|     true|  Varejo|\n|              NULL|              NULL|      105|33.333.333/0001-33|ARCOS DOURADOS CO...|          MCDONALD S|Rua Databricks, 2|Rio de Janeiro|     true|Servicos|\n|              NULL|              NULL|      103|11.111.111/0001-11|ARCOS DOURADOS RE...|          MACDONALDS|Rua Databricks, 1|     Sao Paulo|    false|Servicos|\n|               0.0|0.9995995303076468|        4|93.679.578/3634-83|  Cafe do Pedro LTDA|             Loja 63|      Rua 78, 903|      Curitiba|    false|  Varejo|\n|               0.0|0.9999999999998744|       27|28.310.624/8510-88| Padaria da Ana LTDA|      Padaria da Ana|      Rua 47, 786|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999999999999996|       10|14.977.673/8238-61|   Loja do Joao LTDA|        Loja do Joao|       Rua 17, 96|Rio de Janeiro|    false|  Varejo|\n|               0.0|0.9999999999999439|        4|97.691.999/2585-78|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 80, 250|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9999999999999644|        1|57.430.216/3509-62|   Loja do Joao LTDA|        Loja do Joao|      Rua 45, 955|Rio de Janeiro|    false|  Varejo|\n|               0.0| 0.999999999999984|        4|90.614.832/2191-55|Mercadinho da Mar...|             Loja 54|      Rua 20, 750|     Sao Paulo|     true|  Varejo|\n|               0.0|0.9999999999989102|       12|82.478.987/6107-15|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 14, 421|Belo Horizonte|    false|  Varejo|\n|               0.0|0.9999950772354037|        2|39.955.477/2184-14|    Empresa 274 LTDA|        Loja do Joao|      Rua 98, 395|Rio de Janeiro|     true|  Varejo|\n|               0.0|0.9999936092363207|        8|45.731.289/7929-92|Mercadinho da Mar...| Mercadinho da Maria|      Rua 24, 469|      Curitiba|     true|  Varejo|\n|               0.0|               1.0|       10|12.709.620/5225-96| Padaria da Ana LTDA|      Padaria da Ana|      Rua 29, 496|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999962140422042|        2|30.945.928/1214-42|Mercadinho da Mar...|             Loja 64|      Rua 73, 783|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9961564947981529|       27|23.863.982/5966-64|Mercadinho da Mar...|             Loja 19|      Rua 41, 697|Belo Horizonte|     true|  Varejo|\n|               0.0|0.9999999994706104|        2|34.458.889/7691-34|   Loja do Joao LTDA|        Loja do Joao|       Rua 6, 525|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999999999999996|        4|97.583.813/1197-57|   Loja do Joao LTDA|        Loja do Joao|      Rua 52, 268|     Sao Paulo|     true|  Varejo|\n|               0.0|0.9997338689401732|       10|11.757.809/2364-97|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 76, 879|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999999999999439|        4|90.478.939/6992-99|  Cafe do Pedro LTDA|       Cafe do Pedro|        Rua 7, 20|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9999999999304957|       12|89.406.368/1136-98|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 95, 573|Belo Horizonte|     true|  Varejo|\n|               0.0|0.9999998627801172|        9|74.154.244/4443-83|     Empresa 48 LTDA|        Loja do Joao|      Rua 14, 253|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9830589810971893|       10|11.706.325/7045-31|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 97, 853|Belo Horizonte|    false|Servicos|\n|               0.0|0.9999999999999859|        1|51.716.465/9202-51|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 12, 490|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999343505598354|        1|58.583.842/7840-54|    Empresa 261 LTDA|             Loja 43|      Rua 50, 903|Belo Horizonte|    false|Servicos|\n|               0.0|0.9999999766151145|       12|81.942.136/8943-46|    Empresa 698 LTDA|      Padaria da Ana|      Rua 15, 214|Belo Horizonte|     true|  Varejo|\n|               0.0|0.5241571186420633|       22|61.953.246/5155-53|    Empresa 666 LTDA|        Loja do Joao|      Rua 75, 651|Belo Horizonte|    false|Servicos|\n|               0.0|               1.0|        4|97.955.672/4528-37|   Loja do Joao LTDA|        Loja do Joao|      Rua 85, 517|Belo Horizonte|    false|  Varejo|\n|               0.0|0.9999999999999178|        1|52.370.706/4754-84|   Loja do Joao LTDA|        Loja do Joao|       Rua 7, 167|      Curitiba|    false|  Varejo|\n|               0.0| 0.999999999712641|        4|90.935.550/3631-10| Padaria da Ana LTDA|             Loja 16|      Rua 90, 446|      Curitiba|    false|Servicos|\n|              NULL|              NULL|       88|60.802.372/8453-10|Mercadinho da Mar...| Mercadinho da Maria|      Rua 81, 731|     Sao Paulo|    false|Servicos|\n|              NULL|              NULL|       73|83.984.702/6838-50|    Empresa 954 LTDA|        Loja do Joao|      Rua 50, 780|      Curitiba|    false|Servicos|\n|               0.0|0.9999995506155736|       10|12.211.137/8055-39| Padaria da Ana LTDA|      Padaria da Ana|      Rua 98, 239|Belo Horizonte|    false|  Varejo|\n|               0.0|               1.0|        1|50.188.970/1403-88|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 77, 677|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9978952848183934|        8|45.995.441/4228-93|    Empresa 224 LTDA| Mercadinho da Maria|      Rua 75, 693|Rio de Janeiro|     true|  Varejo|\n|               0.0|0.9999998627801172|        9|78.484.245/1709-26|    Empresa 143 LTDA|        Loja do Joao|      Rua 47, 495|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9998607722548328|        9|70.666.207/3298-99| Padaria da Ana LTDA|      Padaria da Ana|       Rua 74, 93|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999962140422042|        2|38.840.545/7256-20|   Loja do Joao LTDA|             Loja 40|      Rua 94, 341|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9999998318556281|        2|39.449.808/2015-45| Padaria da Ana LTDA|      Padaria da Ana|      Rua 71, 889|     Sao Paulo|    false|  Varejo|\n|               0.0| 0.999941146113249|       12|83.941.876/9211-76|Mercadinho da Mar...| Mercadinho da Maria|      Rua 92, 469|      Curitiba|    false|  Varejo|\n|0.5241571186420633|0.9999999999999993|       22|69.975.103/4948-32|    Empresa 557 LTDA| Mercadinho da Maria|      Rua 52, 478|Rio de Janeiro|    false|  Varejo|\n|               0.0|0.9999999999999644|        1|55.270.719/9897-15|   Loja do Joao LTDA|             Loja 22|      Rua 55, 817|Rio de Janeiro|     true|  Varejo|\n|               0.0|0.9999999095254406|        1|59.265.362/4454-15| Padaria da Ana LTDA|             Loja 72|      Rua 37, 411|Rio de Janeiro|    false|  Varejo|\n|               0.0|               1.0|       10|18.343.889/8388-93| Padaria da Ana LTDA|      Padaria da Ana|      Rua 59, 732|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999999999999996|       10|11.906.791/1647-30|   Loja do Joao LTDA|        Loja do Joao|      Rua 13, 827|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9999999996323784|        2|39.603.274/8665-85|  Cafe do Pedro LTDA|             Loja 59|      Rua 67, 753|Belo Horizonte|    false|  Varejo|\n|               0.0| 0.999986821535337|        4|93.577.728/9353-36| Padaria da Ana LTDA|      Padaria da Ana|      Rua 67, 329|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9921926647222915|        2|33.519.549/7040-60|    Empresa 274 LTDA| Mercadinho da Maria|      Rua 21, 470|     Sao Paulo|    false|Servicos|\n|               0.0| 0.999999999963192|       27|25.369.399/2202-74|Mercadinho da Mar...| Mercadinho da Maria|      Rua 92, 756|     Sao Paulo|    false|  Varejo|\n|               1.0|               1.0|      102|42.591.651/0001-43|ARCOS DOURADOS CO...|ARCOS DOURADOS CO...|Rua Databricks, 2|Rio de Janeiro|    false|  Varejo|\n|               0.0|0.9999999999566846|       10|18.317.481/4217-84|Mercadinho da Mar...| Mercadinho da Maria|      Rua 13, 730|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999999999981707|       12|80.752.247/6589-26|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 32, 920|     Sao Paulo|    false|Servicos|\n|               0.0|0.9996571592479513|       10|16.159.673/8725-53|Mercadinho da Mar...| Mercadinho da Maria|      Rua 46, 262|      Curitiba|     true|  Varejo|\n|               0.0|0.9999999999999964|       27|26.598.237/1913-72|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 42, 513|Rio de Janeiro|    false|  Varejo|\n|               0.0|               1.0|       27|22.170.359/3169-97|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 47, 820|      Curitiba|    false|  Varejo|\n|              NULL|              NULL|       76|65.136.684/6276-56|   Loja do Joao LTDA|        Loja do Joao|      Rua 42, 212|     Sao Paulo|    false|  Varejo|\n|              NULL|              NULL|        0|              cnpj|        razao_social|       nome_fantasia|         endereco|        cidade|is_matriz|   setor|\n|              NULL|              NULL|      101|05.483.701/0001-42|ARCOS DOURADOS RE...|     COMERCIAL ARCOS|Rua Databricks, 1|     Sao Paulo|     true|Servicos|\n|0.9999992044059407|0.9999992044059407|       51|28.827.734/3725-86|    Empresa 805 LTDA|        Loja do Joao|       Rua 3, 729|Rio de Janeiro|    false|Servicos|\n|               0.0|0.9998607722548328|        9|72.380.533/3476-48|    Empresa 432 LTDA| Mercadinho da Maria|      Rua 33, 828|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9997338689401732|       10|15.998.956/9879-45|  Cafe do Pedro LTDA|             Loja 19|       Rua 6, 443|Belo Horizonte|    false|  Varejo|\n|               0.0|0.9841484001132732|        8|49.412.210/5022-23|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 31, 368|Belo Horizonte|    false|  Varejo|\n|               0.0|0.9999738075577087|        9|75.235.903/3955-46|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 19, 362|Rio de Janeiro|     true|  Varejo|\n|               0.0|0.9999575254921907|       12|84.413.291/7787-39|    Empresa 177 LTDA|             Loja 82|       Rua 6, 757|Rio de Janeiro|     true|  Varejo|\n|               0.0|0.9999999999999996|        4|90.807.122/1966-20|   Loja do Joao LTDA|        Loja do Joao|      Rua 50, 585|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9998206974416198|        9|71.268.421/3492-32|Mercadinho da Mar...|             Loja 48|      Rua 89, 133|     Sao Paulo|     true|  Varejo|\n|               0.0|0.9998325559506628|       12|82.338.719/6269-83|Mercadinho da Mar...|             Loja 49|      Rua 41, 581|      Curitiba|     true|  Varejo|\n|               0.0|0.9990907605150828|        1|53.984.251/3473-52|Mercadinho da Mar...| Mercadinho da Maria|       Rua 38, 53|      Curitiba|    false|  Varejo|\n|               0.0|0.9998521473616109|        4|90.244.302/6641-82|    Empresa 892 LTDA|             Loja 92|      Rua 88, 853|Rio de Janeiro|    false|  Varejo|\n|               0.0|               1.0|       27|22.937.555/6671-55|  Cafe do Pedro LTDA|       Cafe do Pedro|      Rua 60, 859|      Curitiba|    false|  Varejo|\n|               0.0|0.9999999914073926|        8|41.851.530/8120-66|Mercadinho da Mar...| Mercadinho da Maria|      Rua 64, 150|Rio de Janeiro|    false|Servicos|\n|               0.0| 0.999986821535337|        4|90.785.993/1204-12|    Empresa 207 LTDA|      Padaria da Ana|      Rua 41, 154|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9999883609732916|        2|36.532.920/5864-66|   Loja do Joao LTDA|        Loja do Joao|      Rua 80, 262|Rio de Janeiro|    false|  Varejo|\n|               0.0|0.9842794179524295|        8|47.704.450/8952-62|    Empresa 932 LTDA|        Loja do Joao|      Rua 50, 293|      Curitiba|    false|  Varejo|\n|               0.0|0.9999999996323784|        2|32.402.200/9284-71|  Cafe do Pedro LTDA|             Loja 93|       Rua 7, 747|     Sao Paulo|    false|  Varejo|\n|               0.0|               1.0|        1|53.903.257/7973-41|  Cafe do Pedro LTDA|             Loja 49|        Rua 7, 50|     Sao Paulo|    false|  Varejo|\n|               0.0|0.9987668647575745|        4|93.535.877/4086-88|    Empresa 759 LTDA|             Loja 83|      Rua 61, 249|      Curitiba|     true|Servicos|\n+------------------+------------------+---------+------------------+--------------------+--------------------+-----------------+--------------+---------+--------+\nonly showing top 100 rows\n\n"
     ]
    }
   ],
   "source": [
    "\n",
    "colNames = [\"z_minScore\", \"z_maxScore\", \"z_cluster\", \"rec_id\", \"fname\", \"lname\", \"stNo\", \"add1\", \"add2\", \"city\", \"areaCode\", \"state\", \"dob\", \"ssn\"]\n",
    "outputDF.toDF(*colNames).show(100)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "8d1ee2cf-1dba-41a9-a486-5c812f6e221d",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['--phase', 'generateDocs']\narguments for client options are  ['--phase', 'generateDocs', '--license', 'zinggLic.txt', '--email', 'zingg@zingg.ai', '--conf', 'dummyConf.json']\n"
     ]
    }
   ],
   "source": [
    "options = ClientOptions([ClientOptions.PHASE,\"generateDocs\"])\n",
    "\n",
    "#Zingg execution for the given phase\n",
    "zingg = ZinggWithSpark(args, options)\n",
    "zingg.initAndExecute()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "57b08a8d-a9a2-4500-b970-fd13f8cac44c",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": [
    "DOCS_DIR = zinggDir + \"/\" + modelId + \"/docs/\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "4ae05c52-a7c9-4030-865d-7031de977d33",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "[FileInfo(path='file:/models/databricksdemotrial_1/docs/model.html', name='model.html', size=65035, modificationTime=1729144810474),\n",
       " FileInfo(path='file:/models/databricksdemotrial_1/docs/data.html', name='data.html', size=1806, modificationTime=1729144811198)]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# check that docs succesfully generated\n",
    "dbutils.fs.ls('file:'+DOCS_DIR)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "41bbf67c-f576-4075-972d-2fa51ed62528",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "display_data",
     "data": {
      "text/html": [
       "<html>\n",
       "<head>\n",
       "  <title>Zingg Model Documentation</title>\n",
       "  <link rel=\"stylesheet\" href=\"https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css\" integrity=\"sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO\" crossorigin=\"anonymous\">\n",
       "</head>\n",
       "<body>\n",
       "<nav class=\"navbar navbar-light bg-light\">\n",
       "  <a class=\"navbar-brand\" href=\"https://www.zingg.ai\" style=\"float:left;\" >\n",
       "    <img src=\"https://github.com/zinggai/zingg/raw/main/assets/zinggWhiteTransparent.png\" class=\"d-inline-block align-top\" alt=\"\">\n",
       "  </a>\n",
       "  <div class=\"justify-content=flex-end\" style=\"float:right;\" >Model databricksdemotrial_1</div>\n",
       " </nav>\n",
       "  <p>\n",
       "  <table class=\"table table-borderless\">\n",
       "\t  <tbody>\n",
       "\t\t  \t<tr>\n",
       "\t\t\t\t<th class=\"border-right border-white\" style=\"width: 160px;\" >Unmarked 0/24, Marked 24/24 (<font color=\"#28a745\">10 Matches</font>, <font color=\"#FF4500\">14 Non-Matches</font>, 0 Unsure)</th>\n",
       "\t\t  \t</tr>\n",
       "\t  </tbody>\n",
       "  </table>\n",
       " <p>\n",
       "  <table class=\"table table-borderless\">\n",
       "\n",
       "  \n",
       "  <thead class=\"thead thead-dark\">\n",
       "  <tr>\n",
       "    <th class=\"border-right border-white\" style=\"width: 160px;\" >Cluster</th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"z_score.html\"> z_score </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"z_isMatch.html\"> z_isMatch </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"cnpj.html\"> cnpj </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"razao_social.html\"> razao_social </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"nome_fantasia.html\"> nome_fantasia </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"endereco.html\"> endereco </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"cidade.html\"> cidade </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"is_matriz.html\"> is_matriz </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"setor.html\"> setor </a></th>\n",
       "    <th class=\"border-right border-white\" > <a href=\"z_zsource.html\"> z_zsource </a></th>\n",
       "  </tr>\n",
       "  </thead>\n",
       "\n",
       "  <tbody>\n",
       "\n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:0\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "12.709.620/5225-96\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 29, 496\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "11.757.809/2364-97\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 76, 879\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:1\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "22.170.359/3169-97\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 47, 820\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "28.873.607/7955-16\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 22, 332\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:11\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "80.388.385/2416-64\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 92, 254\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "83.984.702/6838-50\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Empresa 954 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 50, 780\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:12\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "11.757.809/2364-97\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 76, 879\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "14.977.673/8238-61\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja do Joao LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 17, 96\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:15\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "93.577.728/9353-36\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 67, 329\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "90.935.550/3631-10\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja 16\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 90, 446\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:16\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "11.102.630/4468-50\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Empresa 499 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 19, 696\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "18.343.889/8388-93\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 59, 732\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:19\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "93.679.578/3634-83\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja 63\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 78, 903\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "90.935.550/3631-10\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja 16\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 90, 446\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:2\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "30.945.928/1214-42\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Mercadinho da Maria LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja 64\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 73, 783\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "39.955.477/2184-14\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Empresa 274 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 98, 395\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:23\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "90.244.302/6641-82\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Empresa 892 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja 92\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 88, 853\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "90.935.550/3631-10\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja 16\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 90, 446\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:27\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "82.338.719/6269-83\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Mercadinho da Maria LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja 49\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 41, 581\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "84.413.291/7787-39\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Empresa 177 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja 82\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 6, 757\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:3\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "61.953.246/5155-53\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Empresa 666 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 75, 651\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Belo Horizonte\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "69.787.546/4657-71\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 13, 5\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:4\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "11.906.791/1647-30\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja do Joao LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 13, 827\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "11.757.809/2364-97\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 76, 879\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:7\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "83.984.702/6838-50\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Empresa 954 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 50, 780\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "81.942.136/8943-46\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Empresa 698 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 15, 214\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Belo Horizonte\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "        class=\"table-danger\" style=\"border-bottom:1px solid #FF4500; border-right: 1px solid #FF4500 ;\"\n",
       "            >\n",
       "      1729141631531:8\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "16.159.673/8725-53\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Mercadinho da Maria LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Mercadinho da Maria\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 46, 262\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "11.757.809/2364-97\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Rua 76, 879\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "        class=\"border-bottom bottom-danger\" style=\"border-right: 1px solid #FF4500  ;\"\n",
       "          > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:1\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "28.310.624/8510-88\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 47, 786\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "28.873.607/7955-16\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 22, 332\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:11\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "44.444.444/0001-44\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "ARCOS DOURADOS COMERCIO DE ALIMENTOS SA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "MCDONALDS COMERCIO DE ALIMENTOS LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua Databricks, 4\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Belo Horizonte\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "42.591.651/0001-43\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "ARCOS DOURADOS COMERCIO DE ALIMENTOS SA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "ARCOS DOURADOS COMERCIO DE ALIMENTOS\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua Databricks, 2\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:13\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "12.211.137/8055-39\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 98, 239\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Belo Horizonte\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "14.977.673/8238-61\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja do Joao LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 17, 96\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:15\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "11.102.630/4468-50\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Empresa 499 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 19, 696\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "14.977.673/8238-61\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja do Joao LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 17, 96\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:17\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "59.265.362/4454-15\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja 72\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 37, 411\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "59.772.819/4499-52\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Empresa 187 LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja 68\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 35, 289\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:19\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "16.159.673/8725-53\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Mercadinho da Maria LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Mercadinho da Maria\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 46, 262\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Curitiba\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "true\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "14.977.673/8238-61\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja do Joao LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 17, 96\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rio de Janeiro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:3\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "80.388.385/2416-64\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 92, 254\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "80.752.247/6589-26\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Cafe do Pedro\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 32, 920\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Servicos\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:5\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "12.211.137/8055-39\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 98, 239\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Belo Horizonte\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "12.709.620/5225-96\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 29, 496\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:7\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "32.402.200/9284-71\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Cafe do Pedro LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja 93\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 7, 747\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "34.458.889/7691-34\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja do Joao LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Loja do Joao\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 6, 525\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "      <td rowspan=\"2\"\n",
       "             class=\"table-success\" style=\"border-bottom:1px solid #28a745; border-right: 1px solid #28a745 ;\"\n",
       "      >\n",
       "      1729143599108:9\n",
       "      </td>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "0\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "1\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "12.709.620/5225-96\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Padaria da Ana\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 29, 496\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "              style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       "  <tr>\n",
       "  \n",
       "  \n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "      \n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "18.317.481/4217-84\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Mercadinho da Maria LTDA\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Mercadinho da Maria\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Rua 13, 730\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Sao Paulo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "false\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "Varejo\n",
       "\n",
       "      \n",
       "    </td>\n",
       "    <td \n",
       "             class=\"border-bottom border-success\" style=\"border-right: 1px solid #28a745  ;\"\n",
       "    > \n",
       "zingg_input\n",
       "\n",
       "      \n",
       "    </td>\n",
       "  </tr>\n",
       "  \n",
       " </tbody>\n",
       "  </table>\n",
       "   \n",
       "\n",
       "</p>\n",
       "</body>\n",
       "</html>\n",
       "<style>\n",
       "    .header{\n",
       "        position:relative;\n",
       "        top: 0 ;\n",
       "    }.table{\n",
       "      table-layout: fixed;\n",
       "      width: 100%;\n",
       "    }\n",
       "</style>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "displayHTML(open(DOCS_DIR+\"model.html\", 'r').read())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "e5bf9f88-df8a-4e5d-aebb-43ed4db2ec9b",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "display_data",
     "data": {
      "text/html": [
       "<html>\n",
       "<head>\n",
       "\t<title>Data Documentation</title>\n",
       "\t<link rel=\"stylesheet\" href=\"https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css\" integrity=\"sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO\" crossorigin=\"anonymous\">\n",
       "</head>\n",
       "<body>\n",
       "\t<nav class=\"navbar navbar-light bg-light\">\n",
       "\t\t<a class=\"navbar-brand\" href=\"https://www.zingg.ai\">\n",
       "\t\t\t<img src=\"https://github.com/zinggai/zingg/raw/main/assets/zinggWhiteTransparent.png\" class=\"d-inline-block align-top\" alt=\"\">\n",
       "\t\t</a>\n",
       "\t\t<h1> Data Documentation </h1>\n",
       "\t\t<a href=\"#\">\n",
       "\t\t<div class=\"justify-content-end\">Model databricksdemotrial_1</div>\n",
       "\t\t</a>\n",
       "\t</nav>\n",
       "\n",
       "\t<table class=\"table table-borderless\" style=\"width:auto\" >\n",
       "\t\t\t<thead class=\"thead thead-dark\">\n",
       "\t\t\t</thead>\n",
       "\t<tbody>\n",
       "\t\t\t<tr>\n",
       "\t\t\t\t<th>Field Name</th>\n",
       "\t\t\t\t<th>Field Type</th>\n",
       "\t\t\t\t<th>Nullable</th>\n",
       "\t\t\t</tr>\n",
       "\t\t\t\t<tr>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tcnpj\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tStringType\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\ttrue\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t</tr>\n",
       "\t\t\t\t<tr>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\trazao_social\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tStringType\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\ttrue\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t</tr>\n",
       "\t\t\t\t<tr>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tnome_fantasia\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tStringType\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\ttrue\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t</tr>\n",
       "\t\t\t\t<tr>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tendereco\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tStringType\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\ttrue\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t</tr>\n",
       "\t\t\t\t<tr>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tcidade\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tStringType\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\ttrue\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t</tr>\n",
       "\t\t\t\t<tr>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tis_matriz\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tStringType\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\ttrue\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t</tr>\n",
       "\t\t\t\t<tr>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tsetor\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\tStringType\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t\t<td>\n",
       "\t\t\t\t\ttrue\n",
       "\t\t\t\t\t</td>\n",
       "\t\t\t\t</tr>\n",
       "\t</tbody>\n",
       "\t</table>\n",
       "\n",
       "</body>\n",
       "</html>\n",
       "<style>\n",
       "\t\t.header{\n",
       "\t\t\t\tposition:sticky;\n",
       "\t\t\t\ttop: 0 ;\n",
       "\t\t}\n",
       "</style>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "displayHTML(open(DOCS_DIR+\"data.html\", 'r').read())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "b52238e9-969e-4761-bb14-43cf264b5770",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# Improve accuracy - ask Zingg to recommend stopwords for a particular column. \n",
    "These are common occuring words like pvt, ltd etc which occur across a lot of rows and do not add any meaning to the matching. You can read more about hese at [the Zingg docs](https://docs.zingg.ai/zingg-0.4.0/improving-accuracy/stopwordsremoval)\n",
    "\n",
    "**In the following cell, we are asking for recommendations for the city column. Please edit as per your needs**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "cbd44d6b-fc9a-4505-a47a-8b862ac2e701",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['--phase', 'recommend', '--column', 'city']\narguments for client options are  ['--phase', 'recommend', '--column', 'city', '--license', 'zinggLic.txt', '--email', 'zingg@zingg.ai', '--conf', 'dummyConf.json']\n"
     ]
    }
   ],
   "source": [
    "options = ClientOptions([ClientOptions.PHASE,\"recommend\", \"--column\", \"city\"])\n",
    "args.setStopWordsCutoff(0.5)\n",
    "#Zingg execution for the given phase\n",
    "zingg = ZinggWithSpark(args, options)\n",
    "zingg.initAndExecute()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "06db7e96-7ba5-430d-88bf-24e51ef4b481",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "source": [
    "# View recommendations and configure them in the Zingg arguments.\n",
    "\n",
    "Please check the FieldDefinition's setStopWords() method to set the stop words for each field\n",
    "\n",
    "**We are using the recommendations as is, but you can massage the values, add or remove words that matter to the dataset to get the best results**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {
      "byteLimit": 2048000,
      "rowLimit": 10000
     },
     "inputWidgets": {},
     "nuid": "5a5d598c-de2f-4182-bf3c-f6727ad4c1b6",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [
    {
     "output_type": "stream",
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+------+-------+\n|   _c0|    _c1|\n+------+-------+\n|z_word|z_count|\n+------+-------+\n\n"
     ]
    }
   ],
   "source": [
    "#dbutils.fs.ls(zinggDir+\"/\"+modelId+\"/stopWords\")\n",
    "stopwordsForCity = spark.read.csv(zinggDir+\"/\"+modelId+\"/stopWords/city\")\n",
    "stopwordsForCity.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "c2c32192-da21-4e9e-b430-ce96e3fd314b",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 0,
   "metadata": {
    "application/vnd.databricks.v1+cell": {
     "cellMetadata": {},
     "inputWidgets": {},
     "nuid": "c7a11a72-e540-4e04-88bf-3b3071e5565a",
     "showTitle": false,
     "tableResultSettingsMap": {},
     "title": ""
    }
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "application/vnd.databricks.v1+notebook": {
   "dashboards": [],
   "environmentMetadata": null,
   "language": "python",
   "notebookMetadata": {
    "pythonIndentUnit": 4
   },
   "notebookName": "FebrlExample",
   "widgets": {
    "label": {
     "currentValue": "No Match",
     "nuid": "19cad016-97e3-4a78-898c-1bb583bf20da",
     "typedWidgetInfo": null,
     "widgetInfo": {
      "widgetType": "dropdown",
      "defaultValue": "Uncertain",
      "label": "Is this pair a match?",
      "name": "label",
      "options": {
       "widgetType": "dropdown",
       "autoCreated": null,
       "choices": [
        "No Match",
        "Match",
        "Uncertain"
       ]
      }
     }
    }
   }
  },
  "language_info": {
   "name": "python"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}