Skip to content

Instantly share code, notes, and snippets.

@dubeyji10

dubeyji10/prepareclientsjson.ipynb

Created May 19, 2022 12:17
Show Gist options
  • Save dubeyji10/5bf2598eb6c30f7ebaef0ba0576a2bcb to your computer and use it in GitHub Desktop.
Save dubeyji10/5bf2598eb6c30f7ebaef0ba0576a2bcb to your computer and use it in GitHub Desktop.
Download ZIP
prepareClientsJson.ipynb
Display the source blob
Display the rendered blob
Raw
prepareclientsjson.ipynb
{
"nbformat": 4,
"nbformat_minor": 0,
"metadata": {
"colab": {
"name": "prepareClientsJson.ipynb",
"provenance": [],
"collapsed_sections": [],
"authorship_tag": "ABX9TyOy761h9oBOMUyGaVW2hAvC",
"include_colab_link": true
},
"kernelspec": {
"name": "python3",
"display_name": "Python 3"
},
"language_info": {
"name": "python"
}
},
"cells": [
{
"cell_type": "markdown",
"metadata": {
"id": "view-in-github",
"colab_type": "text"
},
"source": [
"<a href=\"https://colab.research.google.com/gist/dubeyji10/5bf2598eb6c30f7ebaef0ba0576a2bcb/prepareclientsjson.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"id": "VnOFsb_w4MAX"
},
"outputs": [],
"source": [
"#for random assignment of Ownerdicts\n",
"import random\n",
"#for easy json csv conversion\n",
"import pandas as pd\n",
"#for json\n",
"import json\n",
"#for arrays\n",
"import numpy as np\n"
]
},
{
"cell_type": "markdown",
"source": [
"read clients csv convert it to json"
],
"metadata": {
"id": "UXpVQKAS4Ora"
}
},
{
"cell_type": "code",
"source": [
"sample_df = pd.read_csv('Clients Sample.csv')\n",
"sample_df.head()"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 473
},
"id": "gj_t0g0J4e7H",
"outputId": "2f55e1a1-ab78-40f2-a1f7-d07331c9570e"
},
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" id contact_person1 contact_person2 company_name company_grade \\\n",
"0 13 Krishan NaN Global Medikit Ltd B \n",
"1 14 Ajay Laddha NaN Neha Collection D \n",
"2 15 Rajaram NaN Hospira Healthcare C \n",
"3 17 D.Vinaykumar prashant Privi Organics Ltd C \n",
"4 18 Michael Gleeson NaN UniGrain Pvt. Ltd C \n",
"\n",
" phone_no mobile_no1 mobile_no2 email \\\n",
"0 1127662182 9.811119e+09 NaN [email protected] \n",
"1 NaN 7.567370e+09 NaN [email protected] \n",
"2 NaN 8.754422e+09 NaN [email protected] \n",
"3 2266023500 9.820804e+09 8.879229e+09 [email protected] \n",
"4 NaN NaN NaN [email protected] \n",
"\n",
" designation ... added_on last_conversation followup_on \\\n",
"0 Director ... 2013-07-24 19:10:58 NaN NaN \n",
"1 NaN ... 2013-07-25 11:57:49 NaN NaN \n",
"2 GM ... 2013-07-25 12:38:37 NaN NaN \n",
"3 Dy. Manager ... 2013-07-26 13:22:42 NaN NaN \n",
"4 NaN ... 2013-07-26 13:24:27 NaN NaN \n",
"\n",
" last_mail_no last_mail_on last_sms_no last_sms_on email2 Country \\\n",
"0 0 NaN 0 NaN NaN India \n",
"1 0 NaN 0 NaN NaN India \n",
"2 0 NaN 0 NaN NaN India \n",
"3 0 NaN 0 NaN NaN India \n",
"4 0 NaN 0 NaN NaN Australia \n",
"\n",
" phonecode \n",
"0 91.0 \n",
"1 91.0 \n",
"2 91.0 \n",
"3 91.0 \n",
"4 61.0 \n",
"\n",
"[5 rows x 23 columns]"
],
"text/html": [
"\n",
" <div id=\"df-659c2945-8ebe-4349-ae85-63e29b12790e\">\n",
" <div class=\"colab-df-container\">\n",
" <div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>id</th>\n",
" <th>contact_person1</th>\n",
" <th>contact_person2</th>\n",
" <th>company_name</th>\n",
" <th>company_grade</th>\n",
" <th>phone_no</th>\n",
" <th>mobile_no1</th>\n",
" <th>mobile_no2</th>\n",
" <th>email</th>\n",
" <th>designation</th>\n",
" <th>...</th>\n",
" <th>added_on</th>\n",
" <th>last_conversation</th>\n",
" <th>followup_on</th>\n",
" <th>last_mail_no</th>\n",
" <th>last_mail_on</th>\n",
" <th>last_sms_no</th>\n",
" <th>last_sms_on</th>\n",
" <th>email2</th>\n",
" <th>Country</th>\n",
" <th>phonecode</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>13</td>\n",
" <td>Krishan</td>\n",
" <td>NaN</td>\n",
" <td>Global Medikit Ltd</td>\n",
" <td>B</td>\n",
" <td>1127662182</td>\n",
" <td>9.811119e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>2013-07-24 19:10:58</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>14</td>\n",
" <td>Ajay Laddha</td>\n",
" <td>NaN</td>\n",
" <td>Neha Collection</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>7.567370e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>2013-07-25 11:57:49</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>15</td>\n",
" <td>Rajaram</td>\n",
" <td>NaN</td>\n",
" <td>Hospira Healthcare</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>8.754422e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>GM</td>\n",
" <td>...</td>\n",
" <td>2013-07-25 12:38:37</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>17</td>\n",
" <td>D.Vinaykumar</td>\n",
" <td>prashant</td>\n",
" <td>Privi Organics Ltd</td>\n",
" <td>C</td>\n",
" <td>2266023500</td>\n",
" <td>9.820804e+09</td>\n",
" <td>8.879229e+09</td>\n",
" <td>[email protected]</td>\n",
" <td>Dy. Manager</td>\n",
" <td>...</td>\n",
" <td>2013-07-26 13:22:42</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>18</td>\n",
" <td>Michael Gleeson</td>\n",
" <td>NaN</td>\n",
" <td>UniGrain Pvt. Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>2013-07-26 13:24:27</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Australia</td>\n",
" <td>61.0</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 23 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-659c2945-8ebe-4349-ae85-63e29b12790e')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-659c2945-8ebe-4349-ae85-63e29b12790e button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-659c2945-8ebe-4349-ae85-63e29b12790e');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 4
}
]
},
{
"cell_type": "code",
"source": [
"sample_df.columns"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "kT-Lt1Xj4tF2",
"outputId": "e1d53092-304a-496e-8a4d-c16b7c670713"
},
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"Index(['id', 'contact_person1', 'contact_person2', 'company_name',\n",
" 'company_grade', 'phone_no', 'mobile_no1', 'mobile_no2', 'email',\n",
" 'designation', 'address', 'website', 'user_id', 'added_on',\n",
" 'last_conversation', 'followup_on', 'last_mail_no', 'last_mail_on',\n",
" 'last_sms_no', 'last_sms_on', 'email2', 'Country', 'phonecode'],\n",
" dtype='object')"
]
},
"metadata": {},
"execution_count": 5
}
]
},
{
"cell_type": "markdown",
"source": [
"# It should have a Name column with same values as company_name"
],
"metadata": {
"id": "xB66ma434ybZ"
}
},
{
"cell_type": "code",
"source": [
"%%time\n",
"company_name = sample_df['company_name']\n",
"print(company_name , '\\n\\n',type(company_name))"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "6F1SMLwZ4xBr",
"outputId": "6074501d-cdad-4ef8-8147-e6c03e548435"
},
"execution_count": null,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"0 Global Medikit Ltd\n",
"1 Neha Collection\n",
"2 Hospira Healthcare\n",
"3 Privi Organics Ltd\n",
"4 UniGrain Pvt. Ltd\n",
"5 Simoncera\n",
"6 Clariant\n",
"7 Din Farm Products \n",
"8 SAI EXPORTERS\n",
"9 Ananta Trading Co\n",
"10 NTL Logistics\n",
"11 Sita Shree Food Product Ltd\n",
"12 Asian Paints\n",
"13 Delta Data Group\n",
"14 pacific multi products pvt ltd\n",
"15 pacific multi products pvt ltd\n",
"16 Fiori Creations Pvt Ltd\n",
"17 MITSUBISHI RAYON AMERICA INC\n",
"18 premex\n",
"19 Nectar Lifescience Limited\n",
"20 Brick Work India\n",
"21 Variety Insulators\n",
"22 Marcegaglia India Pvt.Ltd.\n",
"23 Meher Export\n",
"24 ABN paddy drier\n",
"25 Unique Technology\n",
"26 JUSHI ( I ) FRP ACC PVT LTD\n",
"27 Kushalchand Sons\n",
"28 khosla engineering pvt ltd\n",
"29 ChemoPlast\n",
"30 JBS LOGISTICS\n",
"31 Technical Sales Manager\n",
"32 ISO AUDITOR\n",
"33 credera intl. pvt. ltd\n",
"34 SHIVA BIIOCHEM INDUSTRIES\n",
"35 PRESTO IMPEX\n",
"36 Excel Eltech\n",
"37 newstep international co. ltd.\n",
"38 Apex Tarmac Pvt Ltd\n",
"39 Jumps Auto Industries Limited\n",
"40 L D creation\n",
"41 Kalyani Steels limited\n",
"42 Maharshi Badri Pharma\n",
"43 Cales de Llierca\n",
"44 Business Co-ordination House (BCH) \n",
"45 Gimpex limited\n",
"46 Hong kong Zhong Sheng\n",
"47 KALPANA AGENCIES\n",
"48 NEEL EXPORTS\n",
"49 PT. Kao Indonesia Chemicals\n",
"Name: company_name, dtype: object \n",
"\n",
" <class 'pandas.core.series.Series'>\n",
"CPU times: user 4.21 ms, sys: 11 µs, total: 4.22 ms\n",
"Wall time: 4.33 ms\n"
]
}
]
},
{
"cell_type": "code",
"source": [
"temp_df = pd.DataFrame({'Name':company_name})\n",
"print('new dataframe created')\n",
"temp_df"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
},
"id": "GCJeSiwJ7Fpl",
"outputId": "2ff85ddd-9e5e-4bb4-b1a8-0e1891603de9"
},
"execution_count": null,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"new dataframe created\n"
]
},
{
"output_type": "execute_result",
"data": {
"text/plain": [
" Name\n",
"0 Global Medikit Ltd\n",
"1 Neha Collection\n",
"2 Hospira Healthcare\n",
"3 Privi Organics Ltd\n",
"4 UniGrain Pvt. Ltd\n",
"5 Simoncera\n",
"6 Clariant\n",
"7 Din Farm Products \n",
"8 SAI EXPORTERS\n",
"9 Ananta Trading Co\n",
"10 NTL Logistics\n",
"11 Sita Shree Food Product Ltd\n",
"12 Asian Paints\n",
"13 Delta Data Group\n",
"14 pacific multi products pvt ltd\n",
"15 pacific multi products pvt ltd\n",
"16 Fiori Creations Pvt Ltd\n",
"17 MITSUBISHI RAYON AMERICA INC\n",
"18 premex\n",
"19 Nectar Lifescience Limited\n",
"20 Brick Work India\n",
"21 Variety Insulators\n",
"22 Marcegaglia India Pvt.Ltd.\n",
"23 Meher Export\n",
"24 ABN paddy drier\n",
"25 Unique Technology\n",
"26 JUSHI ( I ) FRP ACC PVT LTD\n",
"27 Kushalchand Sons\n",
"28 khosla engineering pvt ltd\n",
"29 ChemoPlast\n",
"30 JBS LOGISTICS\n",
"31 Technical Sales Manager\n",
"32 ISO AUDITOR\n",
"33 credera intl. pvt. ltd\n",
"34 SHIVA BIIOCHEM INDUSTRIES\n",
"35 PRESTO IMPEX\n",
"36 Excel Eltech\n",
"37 newstep international co. ltd.\n",
"38 Apex Tarmac Pvt Ltd\n",
"39 Jumps Auto Industries Limited\n",
"40 L D creation\n",
"41 Kalyani Steels limited\n",
"42 Maharshi Badri Pharma\n",
"43 Cales de Llierca\n",
"44 Business Co-ordination House (BCH) \n",
"45 Gimpex limited\n",
"46 Hong kong Zhong Sheng\n",
"47 KALPANA AGENCIES\n",
"48 NEEL EXPORTS\n",
"49 PT. Kao Indonesia Chemicals"
],
"text/html": [
"\n",
" <div id=\"df-b7a3cdb6-8ed9-46ad-aece-78ccede15837\">\n",
" <div class=\"colab-df-container\">\n",
" <div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>Global Medikit Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>Neha Collection</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>Hospira Healthcare</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>Privi Organics Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>UniGrain Pvt. Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>Simoncera</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>Clariant</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>Din Farm Products</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>SAI EXPORTERS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>Ananta Trading Co</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>NTL Logistics</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>Sita Shree Food Product Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>Asian Paints</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>Delta Data Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>pacific multi products pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>pacific multi products pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>Fiori Creations Pvt Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>MITSUBISHI RAYON AMERICA INC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>premex</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>Nectar Lifescience Limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>Brick Work India</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>Variety Insulators</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>Marcegaglia India Pvt.Ltd.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>Meher Export</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>ABN paddy drier</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>Unique Technology</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>JUSHI ( I ) FRP ACC PVT LTD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>Kushalchand Sons</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>khosla engineering pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>ChemoPlast</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>JBS LOGISTICS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>Technical Sales Manager</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>ISO AUDITOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>credera intl. pvt. ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>SHIVA BIIOCHEM INDUSTRIES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>PRESTO IMPEX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>Excel Eltech</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>newstep international co. ltd.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>Apex Tarmac Pvt Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>Jumps Auto Industries Limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>L D creation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>Kalyani Steels limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>Maharshi Badri Pharma</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>Cales de Llierca</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>Business Co-ordination House (BCH)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>Gimpex limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>Hong kong Zhong Sheng</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>KALPANA AGENCIES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>NEEL EXPORTS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>PT. Kao Indonesia Chemicals</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b7a3cdb6-8ed9-46ad-aece-78ccede15837')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-b7a3cdb6-8ed9-46ad-aece-78ccede15837 button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-b7a3cdb6-8ed9-46ad-aece-78ccede15837');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 16
}
]
},
{
"cell_type": "markdown",
"source": [
"### add this df to already existing df"
],
"metadata": {
"id": "LOTCVQml7ZIx"
}
},
{
"cell_type": "code",
"source": [
"%time\n",
"\n",
"clients_sample = pd.concat([sample_df , temp_df],axis=1)\n",
"print('done')\n"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "tXEZGRv77dN1",
"outputId": "721c18e0-db5f-4c92-92b6-f2e69dde6432"
},
"execution_count": null,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"CPU times: user 3 µs, sys: 0 ns, total: 3 µs\n",
"Wall time: 7.39 µs\n",
"done\n"
]
}
]
},
{
"cell_type": "code",
"source": [
"clients_sample"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
},
"id": "z1Gginf37oOG",
"outputId": "1c405931-0eae-44bf-f06e-744b9eae6532"
},
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" id contact_person1 contact_person2 \\\n",
"0 13 Krishan NaN \n",
"1 14 Ajay Laddha NaN \n",
"2 15 Rajaram NaN \n",
"3 17 D.Vinaykumar prashant \n",
"4 18 Michael Gleeson NaN \n",
"5 19 Sanjay Pandya \n",
"6 20 Deb Sankar Rana NaN \n",
"7 21 S.M.IMRAN NaN \n",
"8 22 CHANDRA SEKHAR \n",
"9 24 Akshat NaN \n",
"10 29 Moeen Khan NaN \n",
"11 30 Lavish Sharma NaN \n",
"12 31 swapnil NaN \n",
"13 32 Rosa Lago NaN \n",
"14 33 Irshad Adamjee NaN \n",
"15 34 Irshad Adamjee NaN \n",
"16 35 Vikramjit Singh NaN \n",
"17 36 Keiji Obata NaN \n",
"18 37 sebastian villages \n",
"19 38 Udham Singh \n",
"20 39 Sadik Hussain \n",
"21 40 Swetha NaN \n",
"22 41 Deep Shah \n",
"23 42 meher NaN \n",
"24 43 Nilesh NaN \n",
"25 44 Anuj Kumar \n",
"26 45 Ajay NaN \n",
"27 46 Mahendra Mehta \n",
"28 47 Nilesh Patil \n",
"29 48 Dharmesh Damani \n",
"30 49 PROSAD BHATTACHERJEE NaN \n",
"31 50 Ravi M. Macker NaN \n",
"32 51 KHYATI NaN \n",
"33 54 Miss Kani NaN \n",
"34 56 CHANDERBHAN DEMBLA NaN \n",
"35 57 NILESH SHAH NaN \n",
"36 58 Anil NaN \n",
"37 59 kamal lalwani NaN \n",
"38 60 Zulfikar NaN \n",
"39 61 Mohit Mathur NaN \n",
"40 62 shreyanssh NaN \n",
"41 63 vilas patil NaN \n",
"42 64 Ashish NaN \n",
"43 65 Alex Olive NaN \n",
"44 66 Pankaj Sharma NaN \n",
"45 67 Deepak Swami NaN \n",
"46 68 BELINDA NaN \n",
"47 69 KISHORE KUMAR NaN \n",
"48 70 YAGNESH SETH NaN \n",
"49 71 djanaur chalid NaN \n",
"\n",
" company_name company_grade phone_no \\\n",
"0 Global Medikit Ltd B 1127662182 \n",
"1 Neha Collection D NaN \n",
"2 Hospira Healthcare C NaN \n",
"3 Privi Organics Ltd C 2266023500 \n",
"4 UniGrain Pvt. Ltd C NaN \n",
"5 Simoncera B NaN \n",
"6 Clariant B 2225868884 \n",
"7 Din Farm Products C 4253523611 \n",
"8 SAI EXPORTERS B NaN \n",
"9 Ananta Trading Co D NaN \n",
"10 NTL Logistics D NaN \n",
"11 Sita Shree Food Product Ltd C NaN \n",
"12 Asian Paints A 2239818251 \n",
"13 Delta Data Group B 160404670166 \n",
"14 pacific multi products pvt ltd B 3008238779 \n",
"15 pacific multi products pvt ltd B 3008238779 \n",
"16 Fiori Creations Pvt Ltd C NaN \n",
"17 MITSUBISHI RAYON AMERICA INC B 212)2233043(Ext.106) \n",
"18 premex B 3127231488 \n",
"19 Nectar Lifescience Limited B +911723938749   \n",
"20 Brick Work India B NaN \n",
"21 Variety Insulators B NaN \n",
"22 Marcegaglia India Pvt.Ltd. B 020 41500411 \n",
"23 Meher Export B NaN \n",
"24 ABN paddy drier B NaN \n",
"25 Unique Technology B NaN \n",
"26 JUSHI ( I ) FRP ACC PVT LTD B 912240335333 \n",
"27 Kushalchand Sons B 66182113 \n",
"28 khosla engineering pvt ltd B 2135678403 \n",
"29 ChemoPlast B 24044 \n",
"30 JBS LOGISTICS B 33760591 \n",
"31 Technical Sales Manager B +91(011)25551385 \n",
"32 ISO AUDITOR B NaN \n",
"33 credera intl. pvt. ltd B NaN \n",
"34 SHIVA BIIOCHEM INDUSTRIES B NaN \n",
"35 PRESTO IMPEX B 2266375429    \n",
"36 Excel Eltech C NaN \n",
"37 newstep international co. ltd. C NaN \n",
"38 Apex Tarmac Pvt Ltd C NaN \n",
"39 Jumps Auto Industries Limited C NaN \n",
"40 L D creation C NaN \n",
"41 Kalyani Steels limited C 2066215028 \n",
"42 Maharshi Badri Pharma B 911412342402 \n",
"43 Cales de Llierca C NaN \n",
"44 Business Co-ordination House (BCH) C 112332813041520000 \n",
"45 Gimpex limited D NaN \n",
"46 Hong kong Zhong Sheng B NaN \n",
"47 KALPANA AGENCIES B 4424329472 \n",
"48 NEEL EXPORTS B NaN \n",
"49 PT. Kao Indonesia Chemicals B 88324454 \n",
"\n",
" mobile_no1 mobile_no2 email \\\n",
"0 9.811119e+09 NaN [email protected] \n",
"1 7.567370e+09 NaN [email protected] \n",
"2 8.754422e+09 NaN [email protected] \n",
"3 9.820804e+09 8.879229e+09 [email protected] \n",
"4 NaN NaN [email protected] \n",
"5 9.825468e+09 NaN [email protected] \n",
"6 9.920713e+09 NaN [email protected] \n",
"7 NaN NaN [email protected] \n",
"8 9.224689e+09 NaN [email protected] \n",
"9 7.940040e+09 NaN [email protected] \n",
"10 8.376831e+09 NaN [email protected] \n",
"11 9.755441e+09 NaN [email protected] \n",
"12 9.167196e+09 NaN [email protected] \n",
"13 NaN NaN [email protected] \n",
"14 NaN NaN [email protected] \n",
"15 NaN NaN [email protected] \n",
"16 9.811054e+09 NaN [email protected] \n",
"17 NaN NaN [email protected] \n",
"18 NaN NaN [email protected] \n",
"19 9.356691e+09 NaN [email protected] \n",
"20 8.040410e+09 NaN [email protected] \n",
"21 9.949046e+09 NaN [email protected] \n",
"22 9.011097e+09 NaN [email protected] \n",
"23 9.032891e+09 NaN [email protected] \n",
"24 9.620004e+09 NaN [email protected] \n",
"25 9.816185e+09 NaN [email protected] \n",
"26 NaN NaN [email protected] \n",
"27 9.322597e+09 NaN [email protected] \n",
"28 NaN NaN [email protected] \n",
"29 9.820610e+09 NaN [email protected] \n",
"30 NaN NaN [email protected] \n",
"31 9.810183e+09 NaN [email protected] \n",
"32 9.825001e+09 NaN [email protected] \n",
"33 9.841687e+09 NaN [email protected] \n",
"34 9.423124e+09 NaN [email protected] \n",
"35 9.833175e+09 NaN [email protected] \n",
"36 9.299657e+09 NaN [email protected] \n",
"37 9.909512e+09 NaN [email protected] \n",
"38 9.825818e+09 NaN [email protected] \n",
"39 9.910447e+09 NaN [email protected] \n",
"40 9.829025e+09 NaN [email protected] \n",
"41 NaN NaN [email protected] \n",
"42 NaN NaN [email protected] \n",
"43 6.490795e+12 NaN [email protected] \n",
"44 NaN NaN [email protected] \n",
"45 9.979876e+09 NaN [email protected] \n",
"46 1.512097e+13 NaN [email protected] \n",
"47 9.884004e+09 NaN [email protected] \n",
"48 9.820060e+09 NaN [email protected] \n",
"49 NaN NaN [email protected] \n",
"\n",
" designation ... last_conversation \\\n",
"0 Director ... NaN \n",
"1 NaN ... NaN \n",
"2 GM ... NaN \n",
"3 Dy. Manager ... NaN \n",
"4 NaN ... NaN \n",
"5 CEO ... NaN \n",
"6 GM ... NaN \n",
"7 NaN ... NaN \n",
"8 NaN ... NaN \n",
"9 CEO ... NaN \n",
"10 NaN ... NaN \n",
"11 Manager ... NaN \n",
"12 Purchase Manager ... payment received , data sent \n",
"13 NaN ... under process \n",
"14 Director ... NaN \n",
"15 Director ... NaN \n",
"16 NaN ... NaN \n",
"17 NaN ... NaN \n",
"18 NaN ... NaN \n",
"19 NaN ... NaN \n",
"20 NaN ... NaN \n",
"21 NaN ... Revised Sample shared \n",
"22 VP - Sales ... NaN \n",
"23 NaN ... NaN \n",
"24 NaN ... NaN \n",
"25 NaN ... call him tomorrow \n",
"26 NaN ... NaN \n",
"27 NaN ... not responding \n",
"28 NaN ... NaN \n",
"29 NaN ... Again enquiry dropped, reverted with samples a... \n",
"30 NaN ... NaN \n",
"31 NaN ... NaN \n",
"32 CEO ... NaN \n",
"33 NaN ... NaN \n",
"34 NaN ... NaN \n",
"35 PATNER ... NaN \n",
"36 NaN ... NaN \n",
"37 NaN ... NaN \n",
"38 Director ... . \n",
"39 Director ... NaN \n",
"40 NaN ... NaN \n",
"41 Manager ... NaN \n",
"42 NaN ... NaN \n",
"43 Director ... NaN \n",
"44 NaN ... NaN \n",
"45 Manager ... NaN \n",
"46 NaN ... NaN \n",
"47 NaN ... NaN \n",
"48 Chief Executive ... NaN \n",
"49 NaN ... NaN \n",
"\n",
" followup_on last_mail_no last_mail_on last_sms_no \\\n",
"0 NaN 0 NaN 0 \n",
"1 NaN 0 NaN 0 \n",
"2 NaN 0 NaN 0 \n",
"3 NaN 0 NaN 0 \n",
"4 NaN 0 NaN 0 \n",
"5 2014-09-14 18:40:32 0 NaN 0 \n",
"6 NaN 0 NaN 0 \n",
"7 NaN 0 NaN 0 \n",
"8 NaN 0 NaN 0 \n",
"9 NaN 0 NaN 0 \n",
"10 NaN 0 NaN 0 \n",
"11 NaN 0 NaN 0 \n",
"12 2018-09-03 10:34:09 21292 2018-07-19 13:22:48 0 \n",
"13 2019-04-12 12:07:35 21292 2018-07-19 13:22:49 0 \n",
"14 NaN 0 NaN 0 \n",
"15 NaN 0 NaN 0 \n",
"16 NaN 0 NaN 0 \n",
"17 NaN 0 NaN 0 \n",
"18 NaN 0 NaN 0 \n",
"19 2014-09-14 18:40:32 0 NaN 0 \n",
"20 NaN 9001 2016-10-27 15:35:11 0 \n",
"21 2017-12-18 11:47:20 0 NaN 0 \n",
"22 NaN 11054 2017-06-28 13:15:06 0 \n",
"23 NaN 0 NaN 0 \n",
"24 NaN 0 NaN 0 \n",
"25 2017-02-22 11:00:38 21204 2018-03-21 13:46:25 0 \n",
"26 NaN 0 NaN 0 \n",
"27 2018-09-05 10:57:17 30007 2018-10-12 15:01:56 0 \n",
"28 NaN 0 NaN 0 \n",
"29 2019-06-01 11:45:58 21291 2018-07-17 13:48:49 0 \n",
"30 NaN 0 NaN 0 \n",
"31 NaN 0 NaN 0 \n",
"32 2014-09-14 18:40:32 0 NaN 0 \n",
"33 2014-09-14 18:40:32 0 NaN 0 \n",
"34 NaN 0 NaN 0 \n",
"35 NaN 0 NaN 0 \n",
"36 2014-09-14 18:40:32 0 NaN 0 \n",
"37 NaN 0 NaN 0 \n",
"38 2016-05-05 13:22:46 30001 2018-09-13 13:38:19 0 \n",
"39 2014-09-14 18:40:32 0 NaN 0 \n",
"40 NaN 0 NaN 0 \n",
"41 NaN 0 NaN 0 \n",
"42 NaN 0 NaN 0 \n",
"43 NaN 0 NaN 0 \n",
"44 NaN 0 NaN 0 \n",
"45 2014-09-14 18:40:32 0 NaN 0 \n",
"46 2014-09-14 18:40:32 0 NaN 0 \n",
"47 NaN 0 NaN 0 \n",
"48 2014-09-14 18:40:32 0 NaN 0 \n",
"49 NaN 0 NaN 0 \n",
"\n",
" last_sms_on email2 Country phonecode \\\n",
"0 NaN NaN India 91.0 \n",
"1 NaN NaN India 91.0 \n",
"2 NaN NaN India 91.0 \n",
"3 NaN NaN India 91.0 \n",
"4 NaN NaN Australia 61.0 \n",
"5 NaN NaN India 91.0 \n",
"6 NaN NaN India 91.0 \n",
"7 NaN NaN Pakistan 92.0 \n",
"8 NaN NaN India 91.0 \n",
"9 NaN NaN India 91.0 \n",
"10 NaN NaN India 91.0 \n",
"11 NaN NaN India 91.0 \n",
"12 NaN NaN India 91.0 \n",
"13 NaN NaN Canada 1.0 \n",
"14 NaN NaN Pakistan 92.0 \n",
"15 NaN NaN Pakistan 92.0 \n",
"16 NaN NaN India 91.0 \n",
"17 NaN NaN United States 1.0 \n",
"18 NaN NaN Colombia 57.0 \n",
"19 NaN NaN India 91.0 \n",
"20 NaN NaN India 91.0 \n",
"21 NaN NaN India 91.0 \n",
"22 NaN NaN India 91.0 \n",
"23 NaN NaN India 91.0 \n",
"24 NaN NaN India 91.0 \n",
"25 NaN NaN India 91.0 \n",
"26 NaN NaN India 91.0 \n",
"27 NaN NaN India 91.0 \n",
"28 NaN NaN NaN NaN \n",
"29 NaN NaN India 91.0 \n",
"30 NaN NaN India 91.0 \n",
"31 NaN NaN India 91.0 \n",
"32 NaN NaN India 91.0 \n",
"33 NaN NaN India 91.0 \n",
"34 NaN NaN India 91.0 \n",
"35 NaN NaN India 91.0 \n",
"36 NaN NaN India 91.0 \n",
"37 NaN NaN India 91.0 \n",
"38 NaN NaN India 91.0 \n",
"39 NaN NaN India 91.0 \n",
"40 NaN NaN India 91.0 \n",
"41 NaN NaN NaN NaN \n",
"42 NaN NaN India 91.0 \n",
"43 NaN NaN Spain 34.0 \n",
"44 NaN NaN India 91.0 \n",
"45 NaN NaN India 91.0 \n",
"46 NaN NaN China 86.0 \n",
"47 NaN NaN India 91.0 \n",
"48 NaN NaN India 91.0 \n",
"49 NaN NaN Indonesia 62.0 \n",
"\n",
" Name \n",
"0 Global Medikit Ltd \n",
"1 Neha Collection \n",
"2 Hospira Healthcare \n",
"3 Privi Organics Ltd \n",
"4 UniGrain Pvt. Ltd \n",
"5 Simoncera \n",
"6 Clariant \n",
"7 Din Farm Products \n",
"8 SAI EXPORTERS \n",
"9 Ananta Trading Co \n",
"10 NTL Logistics \n",
"11 Sita Shree Food Product Ltd \n",
"12 Asian Paints \n",
"13 Delta Data Group \n",
"14 pacific multi products pvt ltd \n",
"15 pacific multi products pvt ltd \n",
"16 Fiori Creations Pvt Ltd \n",
"17 MITSUBISHI RAYON AMERICA INC \n",
"18 premex \n",
"19 Nectar Lifescience Limited \n",
"20 Brick Work India \n",
"21 Variety Insulators \n",
"22 Marcegaglia India Pvt.Ltd. \n",
"23 Meher Export \n",
"24 ABN paddy drier \n",
"25 Unique Technology \n",
"26 JUSHI ( I ) FRP ACC PVT LTD \n",
"27 Kushalchand Sons \n",
"28 khosla engineering pvt ltd \n",
"29 ChemoPlast \n",
"30 JBS LOGISTICS \n",
"31 Technical Sales Manager \n",
"32 ISO AUDITOR \n",
"33 credera intl. pvt. ltd \n",
"34 SHIVA BIIOCHEM INDUSTRIES \n",
"35 PRESTO IMPEX \n",
"36 Excel Eltech \n",
"37 newstep international co. ltd. \n",
"38 Apex Tarmac Pvt Ltd \n",
"39 Jumps Auto Industries Limited \n",
"40 L D creation \n",
"41 Kalyani Steels limited \n",
"42 Maharshi Badri Pharma \n",
"43 Cales de Llierca \n",
"44 Business Co-ordination House (BCH) \n",
"45 Gimpex limited \n",
"46 Hong kong Zhong Sheng \n",
"47 KALPANA AGENCIES \n",
"48 NEEL EXPORTS \n",
"49 PT. Kao Indonesia Chemicals \n",
"\n",
"[50 rows x 24 columns]"
],
"text/html": [
"\n",
" <div id=\"df-8078f1ae-dd2a-414c-bed7-cdca2ad82381\">\n",
" <div class=\"colab-df-container\">\n",
" <div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>id</th>\n",
" <th>contact_person1</th>\n",
" <th>contact_person2</th>\n",
" <th>company_name</th>\n",
" <th>company_grade</th>\n",
" <th>phone_no</th>\n",
" <th>mobile_no1</th>\n",
" <th>mobile_no2</th>\n",
" <th>email</th>\n",
" <th>designation</th>\n",
" <th>...</th>\n",
" <th>last_conversation</th>\n",
" <th>followup_on</th>\n",
" <th>last_mail_no</th>\n",
" <th>last_mail_on</th>\n",
" <th>last_sms_no</th>\n",
" <th>last_sms_on</th>\n",
" <th>email2</th>\n",
" <th>Country</th>\n",
" <th>phonecode</th>\n",
" <th>Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>13</td>\n",
" <td>Krishan</td>\n",
" <td>NaN</td>\n",
" <td>Global Medikit Ltd</td>\n",
" <td>B</td>\n",
" <td>1127662182</td>\n",
" <td>9.811119e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Global Medikit Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>14</td>\n",
" <td>Ajay Laddha</td>\n",
" <td>NaN</td>\n",
" <td>Neha Collection</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>7.567370e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Neha Collection</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>15</td>\n",
" <td>Rajaram</td>\n",
" <td>NaN</td>\n",
" <td>Hospira Healthcare</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>8.754422e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>GM</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Hospira Healthcare</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>17</td>\n",
" <td>D.Vinaykumar</td>\n",
" <td>prashant</td>\n",
" <td>Privi Organics Ltd</td>\n",
" <td>C</td>\n",
" <td>2266023500</td>\n",
" <td>9.820804e+09</td>\n",
" <td>8.879229e+09</td>\n",
" <td>[email protected]</td>\n",
" <td>Dy. Manager</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Privi Organics Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>18</td>\n",
" <td>Michael Gleeson</td>\n",
" <td>NaN</td>\n",
" <td>UniGrain Pvt. Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Australia</td>\n",
" <td>61.0</td>\n",
" <td>UniGrain Pvt. Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>19</td>\n",
" <td>Sanjay</td>\n",
" <td>Pandya</td>\n",
" <td>Simoncera</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.825468e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>CEO</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Simoncera</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>20</td>\n",
" <td>Deb Sankar Rana</td>\n",
" <td>NaN</td>\n",
" <td>Clariant</td>\n",
" <td>B</td>\n",
" <td>2225868884</td>\n",
" <td>9.920713e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>GM</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Clariant</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>21</td>\n",
" <td>S.M.IMRAN</td>\n",
" <td>NaN</td>\n",
" <td>Din Farm Products</td>\n",
" <td>C</td>\n",
" <td>4253523611</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Pakistan</td>\n",
" <td>92.0</td>\n",
" <td>Din Farm Products</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>22</td>\n",
" <td>CHANDRA</td>\n",
" <td>SEKHAR</td>\n",
" <td>SAI EXPORTERS</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.224689e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>SAI EXPORTERS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>24</td>\n",
" <td>Akshat</td>\n",
" <td>NaN</td>\n",
" <td>Ananta Trading Co</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>7.940040e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>CEO</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Ananta Trading Co</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>29</td>\n",
" <td>Moeen Khan</td>\n",
" <td>NaN</td>\n",
" <td>NTL Logistics</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>8.376831e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>NTL Logistics</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>30</td>\n",
" <td>Lavish Sharma</td>\n",
" <td>NaN</td>\n",
" <td>Sita Shree Food Product Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.755441e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Manager</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Sita Shree Food Product Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>31</td>\n",
" <td>swapnil</td>\n",
" <td>NaN</td>\n",
" <td>Asian Paints</td>\n",
" <td>A</td>\n",
" <td>2239818251</td>\n",
" <td>9.167196e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Purchase Manager</td>\n",
" <td>...</td>\n",
" <td>payment received , data sent</td>\n",
" <td>2018-09-03 10:34:09</td>\n",
" <td>21292</td>\n",
" <td>2018-07-19 13:22:48</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Asian Paints</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>32</td>\n",
" <td>Rosa Lago</td>\n",
" <td>NaN</td>\n",
" <td>Delta Data Group</td>\n",
" <td>B</td>\n",
" <td>160404670166</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>under process</td>\n",
" <td>2019-04-12 12:07:35</td>\n",
" <td>21292</td>\n",
" <td>2018-07-19 13:22:49</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>1.0</td>\n",
" <td>Delta Data Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>33</td>\n",
" <td>Irshad Adamjee</td>\n",
" <td>NaN</td>\n",
" <td>pacific multi products pvt ltd</td>\n",
" <td>B</td>\n",
" <td>3008238779</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Pakistan</td>\n",
" <td>92.0</td>\n",
" <td>pacific multi products pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>34</td>\n",
" <td>Irshad Adamjee</td>\n",
" <td>NaN</td>\n",
" <td>pacific multi products pvt ltd</td>\n",
" <td>B</td>\n",
" <td>3008238779</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Pakistan</td>\n",
" <td>92.0</td>\n",
" <td>pacific multi products pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>35</td>\n",
" <td>Vikramjit Singh</td>\n",
" <td>NaN</td>\n",
" <td>Fiori Creations Pvt Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.811054e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Fiori Creations Pvt Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>36</td>\n",
" <td>Keiji Obata</td>\n",
" <td>NaN</td>\n",
" <td>MITSUBISHI RAYON AMERICA INC</td>\n",
" <td>B</td>\n",
" <td>212)2233043(Ext.106)</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>United States</td>\n",
" <td>1.0</td>\n",
" <td>MITSUBISHI RAYON AMERICA INC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>37</td>\n",
" <td>sebastian</td>\n",
" <td>villages</td>\n",
" <td>premex</td>\n",
" <td>B</td>\n",
" <td>3127231488</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Colombia</td>\n",
" <td>57.0</td>\n",
" <td>premex</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>38</td>\n",
" <td>Udham</td>\n",
" <td>Singh</td>\n",
" <td>Nectar Lifescience Limited</td>\n",
" <td>B</td>\n",
" <td>+911723938749</td>\n",
" <td>9.356691e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Nectar Lifescience Limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>39</td>\n",
" <td>Sadik</td>\n",
" <td>Hussain</td>\n",
" <td>Brick Work India</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>8.040410e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>9001</td>\n",
" <td>2016-10-27 15:35:11</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Brick Work India</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>40</td>\n",
" <td>Swetha</td>\n",
" <td>NaN</td>\n",
" <td>Variety Insulators</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.949046e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Revised Sample shared</td>\n",
" <td>2017-12-18 11:47:20</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Variety Insulators</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>41</td>\n",
" <td>Deep</td>\n",
" <td>Shah</td>\n",
" <td>Marcegaglia India Pvt.Ltd.</td>\n",
" <td>B</td>\n",
" <td>020 41500411</td>\n",
" <td>9.011097e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>VP - Sales</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>11054</td>\n",
" <td>2017-06-28 13:15:06</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Marcegaglia India Pvt.Ltd.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>42</td>\n",
" <td>meher</td>\n",
" <td>NaN</td>\n",
" <td>Meher Export</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.032891e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Meher Export</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>43</td>\n",
" <td>Nilesh</td>\n",
" <td>NaN</td>\n",
" <td>ABN paddy drier</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.620004e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>ABN paddy drier</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>44</td>\n",
" <td>Anuj</td>\n",
" <td>Kumar</td>\n",
" <td>Unique Technology</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.816185e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>call him tomorrow</td>\n",
" <td>2017-02-22 11:00:38</td>\n",
" <td>21204</td>\n",
" <td>2018-03-21 13:46:25</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Unique Technology</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>45</td>\n",
" <td>Ajay</td>\n",
" <td>NaN</td>\n",
" <td>JUSHI ( I ) FRP ACC PVT LTD</td>\n",
" <td>B</td>\n",
" <td>912240335333</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>JUSHI ( I ) FRP ACC PVT LTD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>46</td>\n",
" <td>Mahendra</td>\n",
" <td>Mehta</td>\n",
" <td>Kushalchand Sons</td>\n",
" <td>B</td>\n",
" <td>66182113</td>\n",
" <td>9.322597e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>not responding</td>\n",
" <td>2018-09-05 10:57:17</td>\n",
" <td>30007</td>\n",
" <td>2018-10-12 15:01:56</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Kushalchand Sons</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>47</td>\n",
" <td>Nilesh</td>\n",
" <td>Patil</td>\n",
" <td>khosla engineering pvt ltd</td>\n",
" <td>B</td>\n",
" <td>2135678403</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>khosla engineering pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>48</td>\n",
" <td>Dharmesh</td>\n",
" <td>Damani</td>\n",
" <td>ChemoPlast</td>\n",
" <td>B</td>\n",
" <td>24044</td>\n",
" <td>9.820610e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Again enquiry dropped, reverted with samples a...</td>\n",
" <td>2019-06-01 11:45:58</td>\n",
" <td>21291</td>\n",
" <td>2018-07-17 13:48:49</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>ChemoPlast</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>49</td>\n",
" <td>PROSAD BHATTACHERJEE</td>\n",
" <td>NaN</td>\n",
" <td>JBS LOGISTICS</td>\n",
" <td>B</td>\n",
" <td>33760591</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>JBS LOGISTICS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>50</td>\n",
" <td>Ravi M. Macker</td>\n",
" <td>NaN</td>\n",
" <td>Technical Sales Manager</td>\n",
" <td>B</td>\n",
" <td>+91(011)25551385</td>\n",
" <td>9.810183e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Technical Sales Manager</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>51</td>\n",
" <td>KHYATI</td>\n",
" <td>NaN</td>\n",
" <td>ISO AUDITOR</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.825001e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>CEO</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>ISO AUDITOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>54</td>\n",
" <td>Miss Kani</td>\n",
" <td>NaN</td>\n",
" <td>credera intl. pvt. ltd</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.841687e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>credera intl. pvt. ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>56</td>\n",
" <td>CHANDERBHAN DEMBLA</td>\n",
" <td>NaN</td>\n",
" <td>SHIVA BIIOCHEM INDUSTRIES</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.423124e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>SHIVA BIIOCHEM INDUSTRIES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>57</td>\n",
" <td>NILESH SHAH</td>\n",
" <td>NaN</td>\n",
" <td>PRESTO IMPEX</td>\n",
" <td>B</td>\n",
" <td>2266375429</td>\n",
" <td>9.833175e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>PATNER</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>PRESTO IMPEX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>58</td>\n",
" <td>Anil</td>\n",
" <td>NaN</td>\n",
" <td>Excel Eltech</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.299657e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Excel Eltech</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>59</td>\n",
" <td>kamal lalwani</td>\n",
" <td>NaN</td>\n",
" <td>newstep international co. ltd.</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.909512e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>newstep international co. ltd.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>60</td>\n",
" <td>Zulfikar</td>\n",
" <td>NaN</td>\n",
" <td>Apex Tarmac Pvt Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.825818e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>.</td>\n",
" <td>2016-05-05 13:22:46</td>\n",
" <td>30001</td>\n",
" <td>2018-09-13 13:38:19</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Apex Tarmac Pvt Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>61</td>\n",
" <td>Mohit Mathur</td>\n",
" <td>NaN</td>\n",
" <td>Jumps Auto Industries Limited</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.910447e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Jumps Auto Industries Limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>62</td>\n",
" <td>shreyanssh</td>\n",
" <td>NaN</td>\n",
" <td>L D creation</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.829025e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>L D creation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>63</td>\n",
" <td>vilas patil</td>\n",
" <td>NaN</td>\n",
" <td>Kalyani Steels limited</td>\n",
" <td>C</td>\n",
" <td>2066215028</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Manager</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kalyani Steels limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>64</td>\n",
" <td>Ashish</td>\n",
" <td>NaN</td>\n",
" <td>Maharshi Badri Pharma</td>\n",
" <td>B</td>\n",
" <td>911412342402</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Maharshi Badri Pharma</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>65</td>\n",
" <td>Alex Olive</td>\n",
" <td>NaN</td>\n",
" <td>Cales de Llierca</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>6.490795e+12</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Spain</td>\n",
" <td>34.0</td>\n",
" <td>Cales de Llierca</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>66</td>\n",
" <td>Pankaj Sharma</td>\n",
" <td>NaN</td>\n",
" <td>Business Co-ordination House (BCH)</td>\n",
" <td>C</td>\n",
" <td>112332813041520000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Business Co-ordination House (BCH)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>67</td>\n",
" <td>Deepak Swami</td>\n",
" <td>NaN</td>\n",
" <td>Gimpex limited</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>9.979876e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Manager</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Gimpex limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>68</td>\n",
" <td>BELINDA</td>\n",
" <td>NaN</td>\n",
" <td>Hong kong Zhong Sheng</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>1.512097e+13</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>China</td>\n",
" <td>86.0</td>\n",
" <td>Hong kong Zhong Sheng</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>69</td>\n",
" <td>KISHORE KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>KALPANA AGENCIES</td>\n",
" <td>B</td>\n",
" <td>4424329472</td>\n",
" <td>9.884004e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>KALPANA AGENCIES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>70</td>\n",
" <td>YAGNESH SETH</td>\n",
" <td>NaN</td>\n",
" <td>NEEL EXPORTS</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.820060e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Chief Executive</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>NEEL EXPORTS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>71</td>\n",
" <td>djanaur chalid</td>\n",
" <td>NaN</td>\n",
" <td>PT. Kao Indonesia Chemicals</td>\n",
" <td>B</td>\n",
" <td>88324454</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Indonesia</td>\n",
" <td>62.0</td>\n",
" <td>PT. Kao Indonesia Chemicals</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>50 rows × 24 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8078f1ae-dd2a-414c-bed7-cdca2ad82381')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-8078f1ae-dd2a-414c-bed7-cdca2ad82381 button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-8078f1ae-dd2a-414c-bed7-cdca2ad82381');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 18
}
]
},
{
"cell_type": "markdown",
"source": [
"dummy data pushed\n",
" ``` \"Owner\": {\n",
" \"name\": \"Jitendra Kumar\",\n",
" \"id\": \"348201000000229001\",\n",
" \"email\": \"[email protected]\"\n",
" },\n",
" \"local_id\": 14,\n",
" \"contact_person1\": \"Ajay Laddha\",\n",
" \"contact_person2\": \"\",\n",
" \"company_name\": \"Neha Collection\",\n",
" \"Name\": \"Neha Collection\",\n",
" \"company_grade\": \"D\",\n",
" \"phone_no\": null,\n",
" \"mobile_no1\": \"7567369544\",\n",
" \"mobile_no2\": null,\n",
" \"email\": \"[email protected]\",\n",
" \"designation\": \"N/A\",\n",
" \"address\": \"\",\n",
" \"website\": \"\",\n",
" \"last_conversation\": null,\n",
" \"followup_on\": null,\n",
" \"last_mail_no\": 0,\n",
" \"last_mail_on\": null,\n",
" \"last_sms_no\": 0,\n",
" \"last_sms_on\": null,\n",
" \"email2\": null,\n",
" \"Country\": \"India\",\n",
" \"phonecode\": \"91\"\n",
" ```"
],
"metadata": {
"id": "fDs_LjlT8is3"
}
},
{
"cell_type": "markdown",
"source": [
"### rename id -> local_id"
],
"metadata": {
"id": "-rozb1n58z83"
}
},
{
"cell_type": "code",
"source": [
"clients_sample.rename({'id': 'local_id',}, axis=1, inplace=True)\n",
"print('done')"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "NNKb_yau6qtb",
"outputId": "5b1d7381-e208-41cd-f826-3700b52faeca"
},
"execution_count": null,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
"done\n"
]
}
]
},
{
"cell_type": "code",
"source": [
"clients_sample_copy = clients_sample.copy()\n",
"clients_sample_copy"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 1000
},
"id": "YRcnshMu9P0o",
"outputId": "0fb09471-a860-468a-d6f3-6700de272af3"
},
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" local_id contact_person1 contact_person2 \\\n",
"0 13 Krishan NaN \n",
"1 14 Ajay Laddha NaN \n",
"2 15 Rajaram NaN \n",
"3 17 D.Vinaykumar prashant \n",
"4 18 Michael Gleeson NaN \n",
"5 19 Sanjay Pandya \n",
"6 20 Deb Sankar Rana NaN \n",
"7 21 S.M.IMRAN NaN \n",
"8 22 CHANDRA SEKHAR \n",
"9 24 Akshat NaN \n",
"10 29 Moeen Khan NaN \n",
"11 30 Lavish Sharma NaN \n",
"12 31 swapnil NaN \n",
"13 32 Rosa Lago NaN \n",
"14 33 Irshad Adamjee NaN \n",
"15 34 Irshad Adamjee NaN \n",
"16 35 Vikramjit Singh NaN \n",
"17 36 Keiji Obata NaN \n",
"18 37 sebastian villages \n",
"19 38 Udham Singh \n",
"20 39 Sadik Hussain \n",
"21 40 Swetha NaN \n",
"22 41 Deep Shah \n",
"23 42 meher NaN \n",
"24 43 Nilesh NaN \n",
"25 44 Anuj Kumar \n",
"26 45 Ajay NaN \n",
"27 46 Mahendra Mehta \n",
"28 47 Nilesh Patil \n",
"29 48 Dharmesh Damani \n",
"30 49 PROSAD BHATTACHERJEE NaN \n",
"31 50 Ravi M. Macker NaN \n",
"32 51 KHYATI NaN \n",
"33 54 Miss Kani NaN \n",
"34 56 CHANDERBHAN DEMBLA NaN \n",
"35 57 NILESH SHAH NaN \n",
"36 58 Anil NaN \n",
"37 59 kamal lalwani NaN \n",
"38 60 Zulfikar NaN \n",
"39 61 Mohit Mathur NaN \n",
"40 62 shreyanssh NaN \n",
"41 63 vilas patil NaN \n",
"42 64 Ashish NaN \n",
"43 65 Alex Olive NaN \n",
"44 66 Pankaj Sharma NaN \n",
"45 67 Deepak Swami NaN \n",
"46 68 BELINDA NaN \n",
"47 69 KISHORE KUMAR NaN \n",
"48 70 YAGNESH SETH NaN \n",
"49 71 djanaur chalid NaN \n",
"\n",
" company_name company_grade phone_no \\\n",
"0 Global Medikit Ltd B 1127662182 \n",
"1 Neha Collection D NaN \n",
"2 Hospira Healthcare C NaN \n",
"3 Privi Organics Ltd C 2266023500 \n",
"4 UniGrain Pvt. Ltd C NaN \n",
"5 Simoncera B NaN \n",
"6 Clariant B 2225868884 \n",
"7 Din Farm Products C 4253523611 \n",
"8 SAI EXPORTERS B NaN \n",
"9 Ananta Trading Co D NaN \n",
"10 NTL Logistics D NaN \n",
"11 Sita Shree Food Product Ltd C NaN \n",
"12 Asian Paints A 2239818251 \n",
"13 Delta Data Group B 160404670166 \n",
"14 pacific multi products pvt ltd B 3008238779 \n",
"15 pacific multi products pvt ltd B 3008238779 \n",
"16 Fiori Creations Pvt Ltd C NaN \n",
"17 MITSUBISHI RAYON AMERICA INC B 212)2233043(Ext.106) \n",
"18 premex B 3127231488 \n",
"19 Nectar Lifescience Limited B +911723938749   \n",
"20 Brick Work India B NaN \n",
"21 Variety Insulators B NaN \n",
"22 Marcegaglia India Pvt.Ltd. B 020 41500411 \n",
"23 Meher Export B NaN \n",
"24 ABN paddy drier B NaN \n",
"25 Unique Technology B NaN \n",
"26 JUSHI ( I ) FRP ACC PVT LTD B 912240335333 \n",
"27 Kushalchand Sons B 66182113 \n",
"28 khosla engineering pvt ltd B 2135678403 \n",
"29 ChemoPlast B 24044 \n",
"30 JBS LOGISTICS B 33760591 \n",
"31 Technical Sales Manager B +91(011)25551385 \n",
"32 ISO AUDITOR B NaN \n",
"33 credera intl. pvt. ltd B NaN \n",
"34 SHIVA BIIOCHEM INDUSTRIES B NaN \n",
"35 PRESTO IMPEX B 2266375429    \n",
"36 Excel Eltech C NaN \n",
"37 newstep international co. ltd. C NaN \n",
"38 Apex Tarmac Pvt Ltd C NaN \n",
"39 Jumps Auto Industries Limited C NaN \n",
"40 L D creation C NaN \n",
"41 Kalyani Steels limited C 2066215028 \n",
"42 Maharshi Badri Pharma B 911412342402 \n",
"43 Cales de Llierca C NaN \n",
"44 Business Co-ordination House (BCH) C 112332813041520000 \n",
"45 Gimpex limited D NaN \n",
"46 Hong kong Zhong Sheng B NaN \n",
"47 KALPANA AGENCIES B 4424329472 \n",
"48 NEEL EXPORTS B NaN \n",
"49 PT. Kao Indonesia Chemicals B 88324454 \n",
"\n",
" mobile_no1 mobile_no2 email \\\n",
"0 9.811119e+09 NaN [email protected] \n",
"1 7.567370e+09 NaN [email protected] \n",
"2 8.754422e+09 NaN [email protected] \n",
"3 9.820804e+09 8.879229e+09 [email protected] \n",
"4 NaN NaN [email protected] \n",
"5 9.825468e+09 NaN [email protected] \n",
"6 9.920713e+09 NaN [email protected] \n",
"7 NaN NaN [email protected] \n",
"8 9.224689e+09 NaN [email protected] \n",
"9 7.940040e+09 NaN [email protected] \n",
"10 8.376831e+09 NaN [email protected] \n",
"11 9.755441e+09 NaN [email protected] \n",
"12 9.167196e+09 NaN [email protected] \n",
"13 NaN NaN [email protected] \n",
"14 NaN NaN [email protected] \n",
"15 NaN NaN [email protected] \n",
"16 9.811054e+09 NaN [email protected] \n",
"17 NaN NaN [email protected] \n",
"18 NaN NaN [email protected] \n",
"19 9.356691e+09 NaN [email protected] \n",
"20 8.040410e+09 NaN [email protected] \n",
"21 9.949046e+09 NaN [email protected] \n",
"22 9.011097e+09 NaN [email protected] \n",
"23 9.032891e+09 NaN [email protected] \n",
"24 9.620004e+09 NaN [email protected] \n",
"25 9.816185e+09 NaN [email protected] \n",
"26 NaN NaN [email protected] \n",
"27 9.322597e+09 NaN [email protected] \n",
"28 NaN NaN [email protected] \n",
"29 9.820610e+09 NaN [email protected] \n",
"30 NaN NaN [email protected] \n",
"31 9.810183e+09 NaN [email protected] \n",
"32 9.825001e+09 NaN [email protected] \n",
"33 9.841687e+09 NaN [email protected] \n",
"34 9.423124e+09 NaN [email protected] \n",
"35 9.833175e+09 NaN [email protected] \n",
"36 9.299657e+09 NaN [email protected] \n",
"37 9.909512e+09 NaN [email protected] \n",
"38 9.825818e+09 NaN [email protected] \n",
"39 9.910447e+09 NaN [email protected] \n",
"40 9.829025e+09 NaN [email protected] \n",
"41 NaN NaN [email protected] \n",
"42 NaN NaN [email protected] \n",
"43 6.490795e+12 NaN [email protected] \n",
"44 NaN NaN [email protected] \n",
"45 9.979876e+09 NaN [email protected] \n",
"46 1.512097e+13 NaN [email protected] \n",
"47 9.884004e+09 NaN [email protected] \n",
"48 9.820060e+09 NaN [email protected] \n",
"49 NaN NaN [email protected] \n",
"\n",
" designation ... last_conversation \\\n",
"0 Director ... NaN \n",
"1 NaN ... NaN \n",
"2 GM ... NaN \n",
"3 Dy. Manager ... NaN \n",
"4 NaN ... NaN \n",
"5 CEO ... NaN \n",
"6 GM ... NaN \n",
"7 NaN ... NaN \n",
"8 NaN ... NaN \n",
"9 CEO ... NaN \n",
"10 NaN ... NaN \n",
"11 Manager ... NaN \n",
"12 Purchase Manager ... payment received , data sent \n",
"13 NaN ... under process \n",
"14 Director ... NaN \n",
"15 Director ... NaN \n",
"16 NaN ... NaN \n",
"17 NaN ... NaN \n",
"18 NaN ... NaN \n",
"19 NaN ... NaN \n",
"20 NaN ... NaN \n",
"21 NaN ... Revised Sample shared \n",
"22 VP - Sales ... NaN \n",
"23 NaN ... NaN \n",
"24 NaN ... NaN \n",
"25 NaN ... call him tomorrow \n",
"26 NaN ... NaN \n",
"27 NaN ... not responding \n",
"28 NaN ... NaN \n",
"29 NaN ... Again enquiry dropped, reverted with samples a... \n",
"30 NaN ... NaN \n",
"31 NaN ... NaN \n",
"32 CEO ... NaN \n",
"33 NaN ... NaN \n",
"34 NaN ... NaN \n",
"35 PATNER ... NaN \n",
"36 NaN ... NaN \n",
"37 NaN ... NaN \n",
"38 Director ... . \n",
"39 Director ... NaN \n",
"40 NaN ... NaN \n",
"41 Manager ... NaN \n",
"42 NaN ... NaN \n",
"43 Director ... NaN \n",
"44 NaN ... NaN \n",
"45 Manager ... NaN \n",
"46 NaN ... NaN \n",
"47 NaN ... NaN \n",
"48 Chief Executive ... NaN \n",
"49 NaN ... NaN \n",
"\n",
" followup_on last_mail_no last_mail_on last_sms_no \\\n",
"0 NaN 0 NaN 0 \n",
"1 NaN 0 NaN 0 \n",
"2 NaN 0 NaN 0 \n",
"3 NaN 0 NaN 0 \n",
"4 NaN 0 NaN 0 \n",
"5 2014-09-14 18:40:32 0 NaN 0 \n",
"6 NaN 0 NaN 0 \n",
"7 NaN 0 NaN 0 \n",
"8 NaN 0 NaN 0 \n",
"9 NaN 0 NaN 0 \n",
"10 NaN 0 NaN 0 \n",
"11 NaN 0 NaN 0 \n",
"12 2018-09-03 10:34:09 21292 2018-07-19 13:22:48 0 \n",
"13 2019-04-12 12:07:35 21292 2018-07-19 13:22:49 0 \n",
"14 NaN 0 NaN 0 \n",
"15 NaN 0 NaN 0 \n",
"16 NaN 0 NaN 0 \n",
"17 NaN 0 NaN 0 \n",
"18 NaN 0 NaN 0 \n",
"19 2014-09-14 18:40:32 0 NaN 0 \n",
"20 NaN 9001 2016-10-27 15:35:11 0 \n",
"21 2017-12-18 11:47:20 0 NaN 0 \n",
"22 NaN 11054 2017-06-28 13:15:06 0 \n",
"23 NaN 0 NaN 0 \n",
"24 NaN 0 NaN 0 \n",
"25 2017-02-22 11:00:38 21204 2018-03-21 13:46:25 0 \n",
"26 NaN 0 NaN 0 \n",
"27 2018-09-05 10:57:17 30007 2018-10-12 15:01:56 0 \n",
"28 NaN 0 NaN 0 \n",
"29 2019-06-01 11:45:58 21291 2018-07-17 13:48:49 0 \n",
"30 NaN 0 NaN 0 \n",
"31 NaN 0 NaN 0 \n",
"32 2014-09-14 18:40:32 0 NaN 0 \n",
"33 2014-09-14 18:40:32 0 NaN 0 \n",
"34 NaN 0 NaN 0 \n",
"35 NaN 0 NaN 0 \n",
"36 2014-09-14 18:40:32 0 NaN 0 \n",
"37 NaN 0 NaN 0 \n",
"38 2016-05-05 13:22:46 30001 2018-09-13 13:38:19 0 \n",
"39 2014-09-14 18:40:32 0 NaN 0 \n",
"40 NaN 0 NaN 0 \n",
"41 NaN 0 NaN 0 \n",
"42 NaN 0 NaN 0 \n",
"43 NaN 0 NaN 0 \n",
"44 NaN 0 NaN 0 \n",
"45 2014-09-14 18:40:32 0 NaN 0 \n",
"46 2014-09-14 18:40:32 0 NaN 0 \n",
"47 NaN 0 NaN 0 \n",
"48 2014-09-14 18:40:32 0 NaN 0 \n",
"49 NaN 0 NaN 0 \n",
"\n",
" last_sms_on email2 Country phonecode \\\n",
"0 NaN NaN India 91.0 \n",
"1 NaN NaN India 91.0 \n",
"2 NaN NaN India 91.0 \n",
"3 NaN NaN India 91.0 \n",
"4 NaN NaN Australia 61.0 \n",
"5 NaN NaN India 91.0 \n",
"6 NaN NaN India 91.0 \n",
"7 NaN NaN Pakistan 92.0 \n",
"8 NaN NaN India 91.0 \n",
"9 NaN NaN India 91.0 \n",
"10 NaN NaN India 91.0 \n",
"11 NaN NaN India 91.0 \n",
"12 NaN NaN India 91.0 \n",
"13 NaN NaN Canada 1.0 \n",
"14 NaN NaN Pakistan 92.0 \n",
"15 NaN NaN Pakistan 92.0 \n",
"16 NaN NaN India 91.0 \n",
"17 NaN NaN United States 1.0 \n",
"18 NaN NaN Colombia 57.0 \n",
"19 NaN NaN India 91.0 \n",
"20 NaN NaN India 91.0 \n",
"21 NaN NaN India 91.0 \n",
"22 NaN NaN India 91.0 \n",
"23 NaN NaN India 91.0 \n",
"24 NaN NaN India 91.0 \n",
"25 NaN NaN India 91.0 \n",
"26 NaN NaN India 91.0 \n",
"27 NaN NaN India 91.0 \n",
"28 NaN NaN NaN NaN \n",
"29 NaN NaN India 91.0 \n",
"30 NaN NaN India 91.0 \n",
"31 NaN NaN India 91.0 \n",
"32 NaN NaN India 91.0 \n",
"33 NaN NaN India 91.0 \n",
"34 NaN NaN India 91.0 \n",
"35 NaN NaN India 91.0 \n",
"36 NaN NaN India 91.0 \n",
"37 NaN NaN India 91.0 \n",
"38 NaN NaN India 91.0 \n",
"39 NaN NaN India 91.0 \n",
"40 NaN NaN India 91.0 \n",
"41 NaN NaN NaN NaN \n",
"42 NaN NaN India 91.0 \n",
"43 NaN NaN Spain 34.0 \n",
"44 NaN NaN India 91.0 \n",
"45 NaN NaN India 91.0 \n",
"46 NaN NaN China 86.0 \n",
"47 NaN NaN India 91.0 \n",
"48 NaN NaN India 91.0 \n",
"49 NaN NaN Indonesia 62.0 \n",
"\n",
" Name \n",
"0 Global Medikit Ltd \n",
"1 Neha Collection \n",
"2 Hospira Healthcare \n",
"3 Privi Organics Ltd \n",
"4 UniGrain Pvt. Ltd \n",
"5 Simoncera \n",
"6 Clariant \n",
"7 Din Farm Products \n",
"8 SAI EXPORTERS \n",
"9 Ananta Trading Co \n",
"10 NTL Logistics \n",
"11 Sita Shree Food Product Ltd \n",
"12 Asian Paints \n",
"13 Delta Data Group \n",
"14 pacific multi products pvt ltd \n",
"15 pacific multi products pvt ltd \n",
"16 Fiori Creations Pvt Ltd \n",
"17 MITSUBISHI RAYON AMERICA INC \n",
"18 premex \n",
"19 Nectar Lifescience Limited \n",
"20 Brick Work India \n",
"21 Variety Insulators \n",
"22 Marcegaglia India Pvt.Ltd. \n",
"23 Meher Export \n",
"24 ABN paddy drier \n",
"25 Unique Technology \n",
"26 JUSHI ( I ) FRP ACC PVT LTD \n",
"27 Kushalchand Sons \n",
"28 khosla engineering pvt ltd \n",
"29 ChemoPlast \n",
"30 JBS LOGISTICS \n",
"31 Technical Sales Manager \n",
"32 ISO AUDITOR \n",
"33 credera intl. pvt. ltd \n",
"34 SHIVA BIIOCHEM INDUSTRIES \n",
"35 PRESTO IMPEX \n",
"36 Excel Eltech \n",
"37 newstep international co. ltd. \n",
"38 Apex Tarmac Pvt Ltd \n",
"39 Jumps Auto Industries Limited \n",
"40 L D creation \n",
"41 Kalyani Steels limited \n",
"42 Maharshi Badri Pharma \n",
"43 Cales de Llierca \n",
"44 Business Co-ordination House (BCH) \n",
"45 Gimpex limited \n",
"46 Hong kong Zhong Sheng \n",
"47 KALPANA AGENCIES \n",
"48 NEEL EXPORTS \n",
"49 PT. Kao Indonesia Chemicals \n",
"\n",
"[50 rows x 24 columns]"
],
"text/html": [
"\n",
" <div id=\"df-8c3632a8-7d54-43e8-be30-33938cb639db\">\n",
" <div class=\"colab-df-container\">\n",
" <div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>local_id</th>\n",
" <th>contact_person1</th>\n",
" <th>contact_person2</th>\n",
" <th>company_name</th>\n",
" <th>company_grade</th>\n",
" <th>phone_no</th>\n",
" <th>mobile_no1</th>\n",
" <th>mobile_no2</th>\n",
" <th>email</th>\n",
" <th>designation</th>\n",
" <th>...</th>\n",
" <th>last_conversation</th>\n",
" <th>followup_on</th>\n",
" <th>last_mail_no</th>\n",
" <th>last_mail_on</th>\n",
" <th>last_sms_no</th>\n",
" <th>last_sms_on</th>\n",
" <th>email2</th>\n",
" <th>Country</th>\n",
" <th>phonecode</th>\n",
" <th>Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>13</td>\n",
" <td>Krishan</td>\n",
" <td>NaN</td>\n",
" <td>Global Medikit Ltd</td>\n",
" <td>B</td>\n",
" <td>1127662182</td>\n",
" <td>9.811119e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Global Medikit Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>14</td>\n",
" <td>Ajay Laddha</td>\n",
" <td>NaN</td>\n",
" <td>Neha Collection</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>7.567370e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Neha Collection</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>15</td>\n",
" <td>Rajaram</td>\n",
" <td>NaN</td>\n",
" <td>Hospira Healthcare</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>8.754422e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>GM</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Hospira Healthcare</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>17</td>\n",
" <td>D.Vinaykumar</td>\n",
" <td>prashant</td>\n",
" <td>Privi Organics Ltd</td>\n",
" <td>C</td>\n",
" <td>2266023500</td>\n",
" <td>9.820804e+09</td>\n",
" <td>8.879229e+09</td>\n",
" <td>[email protected]</td>\n",
" <td>Dy. Manager</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Privi Organics Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>18</td>\n",
" <td>Michael Gleeson</td>\n",
" <td>NaN</td>\n",
" <td>UniGrain Pvt. Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Australia</td>\n",
" <td>61.0</td>\n",
" <td>UniGrain Pvt. Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>19</td>\n",
" <td>Sanjay</td>\n",
" <td>Pandya</td>\n",
" <td>Simoncera</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.825468e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>CEO</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Simoncera</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>20</td>\n",
" <td>Deb Sankar Rana</td>\n",
" <td>NaN</td>\n",
" <td>Clariant</td>\n",
" <td>B</td>\n",
" <td>2225868884</td>\n",
" <td>9.920713e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>GM</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Clariant</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>21</td>\n",
" <td>S.M.IMRAN</td>\n",
" <td>NaN</td>\n",
" <td>Din Farm Products</td>\n",
" <td>C</td>\n",
" <td>4253523611</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Pakistan</td>\n",
" <td>92.0</td>\n",
" <td>Din Farm Products</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>22</td>\n",
" <td>CHANDRA</td>\n",
" <td>SEKHAR</td>\n",
" <td>SAI EXPORTERS</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.224689e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>SAI EXPORTERS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>9</th>\n",
" <td>24</td>\n",
" <td>Akshat</td>\n",
" <td>NaN</td>\n",
" <td>Ananta Trading Co</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>7.940040e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>CEO</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Ananta Trading Co</td>\n",
" </tr>\n",
" <tr>\n",
" <th>10</th>\n",
" <td>29</td>\n",
" <td>Moeen Khan</td>\n",
" <td>NaN</td>\n",
" <td>NTL Logistics</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>8.376831e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>NTL Logistics</td>\n",
" </tr>\n",
" <tr>\n",
" <th>11</th>\n",
" <td>30</td>\n",
" <td>Lavish Sharma</td>\n",
" <td>NaN</td>\n",
" <td>Sita Shree Food Product Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.755441e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Manager</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Sita Shree Food Product Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>12</th>\n",
" <td>31</td>\n",
" <td>swapnil</td>\n",
" <td>NaN</td>\n",
" <td>Asian Paints</td>\n",
" <td>A</td>\n",
" <td>2239818251</td>\n",
" <td>9.167196e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Purchase Manager</td>\n",
" <td>...</td>\n",
" <td>payment received , data sent</td>\n",
" <td>2018-09-03 10:34:09</td>\n",
" <td>21292</td>\n",
" <td>2018-07-19 13:22:48</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Asian Paints</td>\n",
" </tr>\n",
" <tr>\n",
" <th>13</th>\n",
" <td>32</td>\n",
" <td>Rosa Lago</td>\n",
" <td>NaN</td>\n",
" <td>Delta Data Group</td>\n",
" <td>B</td>\n",
" <td>160404670166</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>under process</td>\n",
" <td>2019-04-12 12:07:35</td>\n",
" <td>21292</td>\n",
" <td>2018-07-19 13:22:49</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Canada</td>\n",
" <td>1.0</td>\n",
" <td>Delta Data Group</td>\n",
" </tr>\n",
" <tr>\n",
" <th>14</th>\n",
" <td>33</td>\n",
" <td>Irshad Adamjee</td>\n",
" <td>NaN</td>\n",
" <td>pacific multi products pvt ltd</td>\n",
" <td>B</td>\n",
" <td>3008238779</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Pakistan</td>\n",
" <td>92.0</td>\n",
" <td>pacific multi products pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>15</th>\n",
" <td>34</td>\n",
" <td>Irshad Adamjee</td>\n",
" <td>NaN</td>\n",
" <td>pacific multi products pvt ltd</td>\n",
" <td>B</td>\n",
" <td>3008238779</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Pakistan</td>\n",
" <td>92.0</td>\n",
" <td>pacific multi products pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>16</th>\n",
" <td>35</td>\n",
" <td>Vikramjit Singh</td>\n",
" <td>NaN</td>\n",
" <td>Fiori Creations Pvt Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.811054e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Fiori Creations Pvt Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>17</th>\n",
" <td>36</td>\n",
" <td>Keiji Obata</td>\n",
" <td>NaN</td>\n",
" <td>MITSUBISHI RAYON AMERICA INC</td>\n",
" <td>B</td>\n",
" <td>212)2233043(Ext.106)</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>United States</td>\n",
" <td>1.0</td>\n",
" <td>MITSUBISHI RAYON AMERICA INC</td>\n",
" </tr>\n",
" <tr>\n",
" <th>18</th>\n",
" <td>37</td>\n",
" <td>sebastian</td>\n",
" <td>villages</td>\n",
" <td>premex</td>\n",
" <td>B</td>\n",
" <td>3127231488</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Colombia</td>\n",
" <td>57.0</td>\n",
" <td>premex</td>\n",
" </tr>\n",
" <tr>\n",
" <th>19</th>\n",
" <td>38</td>\n",
" <td>Udham</td>\n",
" <td>Singh</td>\n",
" <td>Nectar Lifescience Limited</td>\n",
" <td>B</td>\n",
" <td>+911723938749</td>\n",
" <td>9.356691e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Nectar Lifescience Limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>20</th>\n",
" <td>39</td>\n",
" <td>Sadik</td>\n",
" <td>Hussain</td>\n",
" <td>Brick Work India</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>8.040410e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>9001</td>\n",
" <td>2016-10-27 15:35:11</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Brick Work India</td>\n",
" </tr>\n",
" <tr>\n",
" <th>21</th>\n",
" <td>40</td>\n",
" <td>Swetha</td>\n",
" <td>NaN</td>\n",
" <td>Variety Insulators</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.949046e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Revised Sample shared</td>\n",
" <td>2017-12-18 11:47:20</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Variety Insulators</td>\n",
" </tr>\n",
" <tr>\n",
" <th>22</th>\n",
" <td>41</td>\n",
" <td>Deep</td>\n",
" <td>Shah</td>\n",
" <td>Marcegaglia India Pvt.Ltd.</td>\n",
" <td>B</td>\n",
" <td>020 41500411</td>\n",
" <td>9.011097e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>VP - Sales</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>11054</td>\n",
" <td>2017-06-28 13:15:06</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Marcegaglia India Pvt.Ltd.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>23</th>\n",
" <td>42</td>\n",
" <td>meher</td>\n",
" <td>NaN</td>\n",
" <td>Meher Export</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.032891e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Meher Export</td>\n",
" </tr>\n",
" <tr>\n",
" <th>24</th>\n",
" <td>43</td>\n",
" <td>Nilesh</td>\n",
" <td>NaN</td>\n",
" <td>ABN paddy drier</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.620004e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>ABN paddy drier</td>\n",
" </tr>\n",
" <tr>\n",
" <th>25</th>\n",
" <td>44</td>\n",
" <td>Anuj</td>\n",
" <td>Kumar</td>\n",
" <td>Unique Technology</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.816185e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>call him tomorrow</td>\n",
" <td>2017-02-22 11:00:38</td>\n",
" <td>21204</td>\n",
" <td>2018-03-21 13:46:25</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Unique Technology</td>\n",
" </tr>\n",
" <tr>\n",
" <th>26</th>\n",
" <td>45</td>\n",
" <td>Ajay</td>\n",
" <td>NaN</td>\n",
" <td>JUSHI ( I ) FRP ACC PVT LTD</td>\n",
" <td>B</td>\n",
" <td>912240335333</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>JUSHI ( I ) FRP ACC PVT LTD</td>\n",
" </tr>\n",
" <tr>\n",
" <th>27</th>\n",
" <td>46</td>\n",
" <td>Mahendra</td>\n",
" <td>Mehta</td>\n",
" <td>Kushalchand Sons</td>\n",
" <td>B</td>\n",
" <td>66182113</td>\n",
" <td>9.322597e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>not responding</td>\n",
" <td>2018-09-05 10:57:17</td>\n",
" <td>30007</td>\n",
" <td>2018-10-12 15:01:56</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Kushalchand Sons</td>\n",
" </tr>\n",
" <tr>\n",
" <th>28</th>\n",
" <td>47</td>\n",
" <td>Nilesh</td>\n",
" <td>Patil</td>\n",
" <td>khosla engineering pvt ltd</td>\n",
" <td>B</td>\n",
" <td>2135678403</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>khosla engineering pvt ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>29</th>\n",
" <td>48</td>\n",
" <td>Dharmesh</td>\n",
" <td>Damani</td>\n",
" <td>ChemoPlast</td>\n",
" <td>B</td>\n",
" <td>24044</td>\n",
" <td>9.820610e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>Again enquiry dropped, reverted with samples a...</td>\n",
" <td>2019-06-01 11:45:58</td>\n",
" <td>21291</td>\n",
" <td>2018-07-17 13:48:49</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>ChemoPlast</td>\n",
" </tr>\n",
" <tr>\n",
" <th>30</th>\n",
" <td>49</td>\n",
" <td>PROSAD BHATTACHERJEE</td>\n",
" <td>NaN</td>\n",
" <td>JBS LOGISTICS</td>\n",
" <td>B</td>\n",
" <td>33760591</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>JBS LOGISTICS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>31</th>\n",
" <td>50</td>\n",
" <td>Ravi M. Macker</td>\n",
" <td>NaN</td>\n",
" <td>Technical Sales Manager</td>\n",
" <td>B</td>\n",
" <td>+91(011)25551385</td>\n",
" <td>9.810183e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Technical Sales Manager</td>\n",
" </tr>\n",
" <tr>\n",
" <th>32</th>\n",
" <td>51</td>\n",
" <td>KHYATI</td>\n",
" <td>NaN</td>\n",
" <td>ISO AUDITOR</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.825001e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>CEO</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>ISO AUDITOR</td>\n",
" </tr>\n",
" <tr>\n",
" <th>33</th>\n",
" <td>54</td>\n",
" <td>Miss Kani</td>\n",
" <td>NaN</td>\n",
" <td>credera intl. pvt. ltd</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.841687e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>credera intl. pvt. ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>34</th>\n",
" <td>56</td>\n",
" <td>CHANDERBHAN DEMBLA</td>\n",
" <td>NaN</td>\n",
" <td>SHIVA BIIOCHEM INDUSTRIES</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.423124e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>SHIVA BIIOCHEM INDUSTRIES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>35</th>\n",
" <td>57</td>\n",
" <td>NILESH SHAH</td>\n",
" <td>NaN</td>\n",
" <td>PRESTO IMPEX</td>\n",
" <td>B</td>\n",
" <td>2266375429</td>\n",
" <td>9.833175e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>PATNER</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>PRESTO IMPEX</td>\n",
" </tr>\n",
" <tr>\n",
" <th>36</th>\n",
" <td>58</td>\n",
" <td>Anil</td>\n",
" <td>NaN</td>\n",
" <td>Excel Eltech</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.299657e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Excel Eltech</td>\n",
" </tr>\n",
" <tr>\n",
" <th>37</th>\n",
" <td>59</td>\n",
" <td>kamal lalwani</td>\n",
" <td>NaN</td>\n",
" <td>newstep international co. ltd.</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.909512e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>newstep international co. ltd.</td>\n",
" </tr>\n",
" <tr>\n",
" <th>38</th>\n",
" <td>60</td>\n",
" <td>Zulfikar</td>\n",
" <td>NaN</td>\n",
" <td>Apex Tarmac Pvt Ltd</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.825818e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>.</td>\n",
" <td>2016-05-05 13:22:46</td>\n",
" <td>30001</td>\n",
" <td>2018-09-13 13:38:19</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Apex Tarmac Pvt Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>39</th>\n",
" <td>61</td>\n",
" <td>Mohit Mathur</td>\n",
" <td>NaN</td>\n",
" <td>Jumps Auto Industries Limited</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.910447e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Jumps Auto Industries Limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>40</th>\n",
" <td>62</td>\n",
" <td>shreyanssh</td>\n",
" <td>NaN</td>\n",
" <td>L D creation</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>9.829025e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>L D creation</td>\n",
" </tr>\n",
" <tr>\n",
" <th>41</th>\n",
" <td>63</td>\n",
" <td>vilas patil</td>\n",
" <td>NaN</td>\n",
" <td>Kalyani Steels limited</td>\n",
" <td>C</td>\n",
" <td>2066215028</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Manager</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Kalyani Steels limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>42</th>\n",
" <td>64</td>\n",
" <td>Ashish</td>\n",
" <td>NaN</td>\n",
" <td>Maharshi Badri Pharma</td>\n",
" <td>B</td>\n",
" <td>911412342402</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Maharshi Badri Pharma</td>\n",
" </tr>\n",
" <tr>\n",
" <th>43</th>\n",
" <td>65</td>\n",
" <td>Alex Olive</td>\n",
" <td>NaN</td>\n",
" <td>Cales de Llierca</td>\n",
" <td>C</td>\n",
" <td>NaN</td>\n",
" <td>6.490795e+12</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Spain</td>\n",
" <td>34.0</td>\n",
" <td>Cales de Llierca</td>\n",
" </tr>\n",
" <tr>\n",
" <th>44</th>\n",
" <td>66</td>\n",
" <td>Pankaj Sharma</td>\n",
" <td>NaN</td>\n",
" <td>Business Co-ordination House (BCH)</td>\n",
" <td>C</td>\n",
" <td>112332813041520000</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Business Co-ordination House (BCH)</td>\n",
" </tr>\n",
" <tr>\n",
" <th>45</th>\n",
" <td>67</td>\n",
" <td>Deepak Swami</td>\n",
" <td>NaN</td>\n",
" <td>Gimpex limited</td>\n",
" <td>D</td>\n",
" <td>NaN</td>\n",
" <td>9.979876e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Manager</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Gimpex limited</td>\n",
" </tr>\n",
" <tr>\n",
" <th>46</th>\n",
" <td>68</td>\n",
" <td>BELINDA</td>\n",
" <td>NaN</td>\n",
" <td>Hong kong Zhong Sheng</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>1.512097e+13</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>China</td>\n",
" <td>86.0</td>\n",
" <td>Hong kong Zhong Sheng</td>\n",
" </tr>\n",
" <tr>\n",
" <th>47</th>\n",
" <td>69</td>\n",
" <td>KISHORE KUMAR</td>\n",
" <td>NaN</td>\n",
" <td>KALPANA AGENCIES</td>\n",
" <td>B</td>\n",
" <td>4424329472</td>\n",
" <td>9.884004e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>KALPANA AGENCIES</td>\n",
" </tr>\n",
" <tr>\n",
" <th>48</th>\n",
" <td>70</td>\n",
" <td>YAGNESH SETH</td>\n",
" <td>NaN</td>\n",
" <td>NEEL EXPORTS</td>\n",
" <td>B</td>\n",
" <td>NaN</td>\n",
" <td>9.820060e+09</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>Chief Executive</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>2014-09-14 18:40:32</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>NEEL EXPORTS</td>\n",
" </tr>\n",
" <tr>\n",
" <th>49</th>\n",
" <td>71</td>\n",
" <td>djanaur chalid</td>\n",
" <td>NaN</td>\n",
" <td>PT. Kao Indonesia Chemicals</td>\n",
" <td>B</td>\n",
" <td>88324454</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>[email protected]</td>\n",
" <td>NaN</td>\n",
" <td>...</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>0</td>\n",
" <td>NaN</td>\n",
" <td>NaN</td>\n",
" <td>Indonesia</td>\n",
" <td>62.0</td>\n",
" <td>PT. Kao Indonesia Chemicals</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>50 rows × 24 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8c3632a8-7d54-43e8-be30-33938cb639db')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-8c3632a8-7d54-43e8-be30-33938cb639db button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-8c3632a8-7d54-43e8-be30-33938cb639db');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 25
}
]
},
{
"cell_type": "code",
"source": [
"clients_sample_copy = clients_sample_copy.replace(np.nan, '', regex=True)"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "0N7Jt-Zs-Csg",
"outputId": "a0160715-b98a-41fe-8737-6a017745a09e"
},
"execution_count": null,
"outputs": [
{
"output_type": "stream",
"name": "stdout",
"text": [
" local_id contact_person1 contact_person2 \\\n",
"0 13 Krishan \n",
"1 14 Ajay Laddha \n",
"2 15 Rajaram \n",
"3 17 D.Vinaykumar prashant \n",
"4 18 Michael Gleeson \n",
"5 19 Sanjay Pandya \n",
"6 20 Deb Sankar Rana \n",
"7 21 S.M.IMRAN \n",
"8 22 CHANDRA SEKHAR \n",
"9 24 Akshat \n",
"10 29 Moeen Khan \n",
"11 30 Lavish Sharma \n",
"12 31 swapnil \n",
"13 32 Rosa Lago \n",
"14 33 Irshad Adamjee \n",
"15 34 Irshad Adamjee \n",
"16 35 Vikramjit Singh \n",
"17 36 Keiji Obata \n",
"18 37 sebastian villages \n",
"19 38 Udham Singh \n",
"20 39 Sadik Hussain \n",
"21 40 Swetha \n",
"22 41 Deep Shah \n",
"23 42 meher \n",
"24 43 Nilesh \n",
"25 44 Anuj Kumar \n",
"26 45 Ajay \n",
"27 46 Mahendra Mehta \n",
"28 47 Nilesh Patil \n",
"29 48 Dharmesh Damani \n",
"30 49 PROSAD BHATTACHERJEE \n",
"31 50 Ravi M. Macker \n",
"32 51 KHYATI \n",
"33 54 Miss Kani \n",
"34 56 CHANDERBHAN DEMBLA \n",
"35 57 NILESH SHAH \n",
"36 58 Anil \n",
"37 59 kamal lalwani \n",
"38 60 Zulfikar \n",
"39 61 Mohit Mathur \n",
"40 62 shreyanssh \n",
"41 63 vilas patil \n",
"42 64 Ashish \n",
"43 65 Alex Olive \n",
"44 66 Pankaj Sharma \n",
"45 67 Deepak Swami \n",
"46 68 BELINDA \n",
"47 69 KISHORE KUMAR \n",
"48 70 YAGNESH SETH \n",
"49 71 djanaur chalid \n",
"\n",
" company_name company_grade phone_no \\\n",
"0 Global Medikit Ltd B 1127662182 \n",
"1 Neha Collection D \n",
"2 Hospira Healthcare C \n",
"3 Privi Organics Ltd C 2266023500 \n",
"4 UniGrain Pvt. Ltd C \n",
"5 Simoncera B \n",
"6 Clariant B 2225868884 \n",
"7 Din Farm Products C 4253523611 \n",
"8 SAI EXPORTERS B \n",
"9 Ananta Trading Co D \n",
"10 NTL Logistics D \n",
"11 Sita Shree Food Product Ltd C \n",
"12 Asian Paints A 2239818251 \n",
"13 Delta Data Group B 160404670166 \n",
"14 pacific multi products pvt ltd B 3008238779 \n",
"15 pacific multi products pvt ltd B 3008238779 \n",
"16 Fiori Creations Pvt Ltd C \n",
"17 MITSUBISHI RAYON AMERICA INC B 212)2233043(Ext.106) \n",
"18 premex B 3127231488 \n",
"19 Nectar Lifescience Limited B +911723938749   \n",
"20 Brick Work India B \n",
"21 Variety Insulators B \n",
"22 Marcegaglia India Pvt.Ltd. B 020 41500411 \n",
"23 Meher Export B \n",
"24 ABN paddy drier B \n",
"25 Unique Technology B \n",
"26 JUSHI ( I ) FRP ACC PVT LTD B 912240335333 \n",
"27 Kushalchand Sons B 66182113 \n",
"28 khosla engineering pvt ltd B 2135678403 \n",
"29 ChemoPlast B 24044 \n",
"30 JBS LOGISTICS B 33760591 \n",
"31 Technical Sales Manager B +91(011)25551385 \n",
"32 ISO AUDITOR B \n",
"33 credera intl. pvt. ltd B \n",
"34 SHIVA BIIOCHEM INDUSTRIES B \n",
"35 PRESTO IMPEX B 2266375429    \n",
"36 Excel Eltech C \n",
"37 newstep international co. ltd. C \n",
"38 Apex Tarmac Pvt Ltd C \n",
"39 Jumps Auto Industries Limited C \n",
"40 L D creation C \n",
"41 Kalyani Steels limited C 2066215028 \n",
"42 Maharshi Badri Pharma B 911412342402 \n",
"43 Cales de Llierca C \n",
"44 Business Co-ordination House (BCH) C 112332813041520000 \n",
"45 Gimpex limited D \n",
"46 Hong kong Zhong Sheng B \n",
"47 KALPANA AGENCIES B 4424329472 \n",
"48 NEEL EXPORTS B \n",
"49 PT. Kao Indonesia Chemicals B 88324454 \n",
"\n",
" mobile_no1 mobile_no2 email \\\n",
"0 9811119219.0 [email protected] \n",
"1 7567369544.0 [email protected] \n",
"2 8754421797.0 [email protected] \n",
"3 9820803656.0 8879228875.0 [email protected] \n",
"4 [email protected] \n",
"5 9825467644.0 [email protected] \n",
"6 9920712647.0 [email protected] \n",
"7 [email protected] \n",
"8 9224689219.0 [email protected] \n",
"9 7940039511.0 [email protected] \n",
"10 8376831374.0 [email protected] \n",
"11 9755440965.0 [email protected] \n",
"12 9167196062.0 [email protected] \n",
"13 [email protected] \n",
"14 [email protected] \n",
"15 [email protected] \n",
"16 9811053993.0 [email protected] \n",
"17 [email protected] \n",
"18 [email protected] \n",
"19 9356691472.0 [email protected] \n",
"20 8040409999.0 [email protected] \n",
"21 9949045858.0 [email protected] \n",
"22 9011096550.0 [email protected] \n",
"23 9032891075.0 [email protected] \n",
"24 9620004097.0 [email protected] \n",
"25 9816185020.0 [email protected] \n",
"26 [email protected] \n",
"27 9322597043.0 [email protected] \n",
"28 [email protected] \n",
"29 9820610300.0 [email protected] \n",
"30 [email protected] \n",
"31 9810183259.0 [email protected] \n",
"32 9825000956.0 [email protected] \n",
"33 9841687477.0 [email protected] \n",
"34 9423124285.0 [email protected] \n",
"35 9833175429.0 [email protected] \n",
"36 9299657076.0 [email protected] \n",
"37 9909512121.0 [email protected] \n",
"38 9825817656.0 [email protected] \n",
"39 9910446680.0 [email protected] \n",
"40 9829025431.0 [email protected] \n",
"41 [email protected] \n",
"42 [email protected] \n",
"43 6490795153497.0 [email protected] \n",
"44 [email protected] \n",
"45 9979875519.0 [email protected] \n",
"46 15120969826080.0 [email protected] \n",
"47 9884003557.0 [email protected] \n",
"48 9820059535.0 [email protected] \n",
"49 [email protected] \n",
"\n",
" designation ... last_conversation \\\n",
"0 Director ... \n",
"1 ... \n",
"2 GM ... \n",
"3 Dy. Manager ... \n",
"4 ... \n",
"5 CEO ... \n",
"6 GM ... \n",
"7 ... \n",
"8 ... \n",
"9 CEO ... \n",
"10 ... \n",
"11 Manager ... \n",
"12 Purchase Manager ... payment received , data sent \n",
"13 ... under process \n",
"14 Director ... \n",
"15 Director ... \n",
"16 ... \n",
"17 ... \n",
"18 ... \n",
"19 ... \n",
"20 ... \n",
"21 ... Revised Sample shared \n",
"22 VP - Sales ... \n",
"23 ... \n",
"24 ... \n",
"25 ... call him tomorrow \n",
"26 ... \n",
"27 ... not responding \n",
"28 ... \n",
"29 ... Again enquiry dropped, reverted with samples a... \n",
"30 ... \n",
"31 ... \n",
"32 CEO ... \n",
"33 ... \n",
"34 ... \n",
"35 PATNER ... \n",
"36 ... \n",
"37 ... \n",
"38 Director ... . \n",
"39 Director ... \n",
"40 ... \n",
"41 Manager ... \n",
"42 ... \n",
"43 Director ... \n",
"44 ... \n",
"45 Manager ... \n",
"46 ... \n",
"47 ... \n",
"48 Chief Executive ... \n",
"49 ... \n",
"\n",
" followup_on last_mail_no last_mail_on last_sms_no \\\n",
"0 0 0 \n",
"1 0 0 \n",
"2 0 0 \n",
"3 0 0 \n",
"4 0 0 \n",
"5 2014-09-14 18:40:32 0 0 \n",
"6 0 0 \n",
"7 0 0 \n",
"8 0 0 \n",
"9 0 0 \n",
"10 0 0 \n",
"11 0 0 \n",
"12 2018-09-03 10:34:09 21292 2018-07-19 13:22:48 0 \n",
"13 2019-04-12 12:07:35 21292 2018-07-19 13:22:49 0 \n",
"14 0 0 \n",
"15 0 0 \n",
"16 0 0 \n",
"17 0 0 \n",
"18 0 0 \n",
"19 2014-09-14 18:40:32 0 0 \n",
"20 9001 2016-10-27 15:35:11 0 \n",
"21 2017-12-18 11:47:20 0 0 \n",
"22 11054 2017-06-28 13:15:06 0 \n",
"23 0 0 \n",
"24 0 0 \n",
"25 2017-02-22 11:00:38 21204 2018-03-21 13:46:25 0 \n",
"26 0 0 \n",
"27 2018-09-05 10:57:17 30007 2018-10-12 15:01:56 0 \n",
"28 0 0 \n",
"29 2019-06-01 11:45:58 21291 2018-07-17 13:48:49 0 \n",
"30 0 0 \n",
"31 0 0 \n",
"32 2014-09-14 18:40:32 0 0 \n",
"33 2014-09-14 18:40:32 0 0 \n",
"34 0 0 \n",
"35 0 0 \n",
"36 2014-09-14 18:40:32 0 0 \n",
"37 0 0 \n",
"38 2016-05-05 13:22:46 30001 2018-09-13 13:38:19 0 \n",
"39 2014-09-14 18:40:32 0 0 \n",
"40 0 0 \n",
"41 0 0 \n",
"42 0 0 \n",
"43 0 0 \n",
"44 0 0 \n",
"45 2014-09-14 18:40:32 0 0 \n",
"46 2014-09-14 18:40:32 0 0 \n",
"47 0 0 \n",
"48 2014-09-14 18:40:32 0 0 \n",
"49 0 0 \n",
"\n",
" last_sms_on email2 Country phonecode \\\n",
"0 India 91.0 \n",
"1 India 91.0 \n",
"2 India 91.0 \n",
"3 India 91.0 \n",
"4 Australia 61.0 \n",
"5 India 91.0 \n",
"6 India 91.0 \n",
"7 Pakistan 92.0 \n",
"8 India 91.0 \n",
"9 India 91.0 \n",
"10 India 91.0 \n",
"11 India 91.0 \n",
"12 India 91.0 \n",
"13 Canada 1.0 \n",
"14 Pakistan 92.0 \n",
"15 Pakistan 92.0 \n",
"16 India 91.0 \n",
"17 United States 1.0 \n",
"18 Colombia 57.0 \n",
"19 India 91.0 \n",
"20 India 91.0 \n",
"21 India 91.0 \n",
"22 India 91.0 \n",
"23 India 91.0 \n",
"24 India 91.0 \n",
"25 India 91.0 \n",
"26 India 91.0 \n",
"27 India 91.0 \n",
"28 \n",
"29 India 91.0 \n",
"30 India 91.0 \n",
"31 India 91.0 \n",
"32 India 91.0 \n",
"33 India 91.0 \n",
"34 India 91.0 \n",
"35 India 91.0 \n",
"36 India 91.0 \n",
"37 India 91.0 \n",
"38 India 91.0 \n",
"39 India 91.0 \n",
"40 India 91.0 \n",
"41 \n",
"42 India 91.0 \n",
"43 Spain 34.0 \n",
"44 India 91.0 \n",
"45 India 91.0 \n",
"46 China 86.0 \n",
"47 India 91.0 \n",
"48 India 91.0 \n",
"49 Indonesia 62.0 \n",
"\n",
" Name \n",
"0 Global Medikit Ltd \n",
"1 Neha Collection \n",
"2 Hospira Healthcare \n",
"3 Privi Organics Ltd \n",
"4 UniGrain Pvt. Ltd \n",
"5 Simoncera \n",
"6 Clariant \n",
"7 Din Farm Products \n",
"8 SAI EXPORTERS \n",
"9 Ananta Trading Co \n",
"10 NTL Logistics \n",
"11 Sita Shree Food Product Ltd \n",
"12 Asian Paints \n",
"13 Delta Data Group \n",
"14 pacific multi products pvt ltd \n",
"15 pacific multi products pvt ltd \n",
"16 Fiori Creations Pvt Ltd \n",
"17 MITSUBISHI RAYON AMERICA INC \n",
"18 premex \n",
"19 Nectar Lifescience Limited \n",
"20 Brick Work India \n",
"21 Variety Insulators \n",
"22 Marcegaglia India Pvt.Ltd. \n",
"23 Meher Export \n",
"24 ABN paddy drier \n",
"25 Unique Technology \n",
"26 JUSHI ( I ) FRP ACC PVT LTD \n",
"27 Kushalchand Sons \n",
"28 khosla engineering pvt ltd \n",
"29 ChemoPlast \n",
"30 JBS LOGISTICS \n",
"31 Technical Sales Manager \n",
"32 ISO AUDITOR \n",
"33 credera intl. pvt. ltd \n",
"34 SHIVA BIIOCHEM INDUSTRIES \n",
"35 PRESTO IMPEX \n",
"36 Excel Eltech \n",
"37 newstep international co. ltd. \n",
"38 Apex Tarmac Pvt Ltd \n",
"39 Jumps Auto Industries Limited \n",
"40 L D creation \n",
"41 Kalyani Steels limited \n",
"42 Maharshi Badri Pharma \n",
"43 Cales de Llierca \n",
"44 Business Co-ordination House (BCH) \n",
"45 Gimpex limited \n",
"46 Hong kong Zhong Sheng \n",
"47 KALPANA AGENCIES \n",
"48 NEEL EXPORTS \n",
"49 PT. Kao Indonesia Chemicals \n",
"\n",
"[50 rows x 24 columns]\n"
]
}
]
},
{
"cell_type": "code",
"source": [
"clients_sample_copy.head()\n"
],
"metadata": {
"id": "523Ooz-d-Mi3",
"outputId": "c3fbf791-a4b0-489d-842c-6cb1b4f89034",
"colab": {
"base_uri": "https://localhost:8080/",
"height": 404
}
},
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
" local_id contact_person1 contact_person2 company_name \\\n",
"0 13 Krishan Global Medikit Ltd \n",
"1 14 Ajay Laddha Neha Collection \n",
"2 15 Rajaram Hospira Healthcare \n",
"3 17 D.Vinaykumar prashant Privi Organics Ltd \n",
"4 18 Michael Gleeson UniGrain Pvt. Ltd \n",
"\n",
" company_grade phone_no mobile_no1 mobile_no2 \\\n",
"0 B 1127662182 9811119219.0 \n",
"1 D 7567369544.0 \n",
"2 C 8754421797.0 \n",
"3 C 2266023500 9820803656.0 8879228875.0 \n",
"4 C \n",
"\n",
" email designation ... last_conversation \\\n",
"0 [email protected] Director ... \n",
"1 [email protected] ... \n",
"2 [email protected] GM ... \n",
"3 [email protected] Dy. Manager ... \n",
"4 [email protected] ... \n",
"\n",
" followup_on last_mail_no last_mail_on last_sms_no last_sms_on email2 \\\n",
"0 0 0 \n",
"1 0 0 \n",
"2 0 0 \n",
"3 0 0 \n",
"4 0 0 \n",
"\n",
" Country phonecode Name \n",
"0 India 91.0 Global Medikit Ltd \n",
"1 India 91.0 Neha Collection \n",
"2 India 91.0 Hospira Healthcare \n",
"3 India 91.0 Privi Organics Ltd \n",
"4 Australia 61.0 UniGrain Pvt. Ltd \n",
"\n",
"[5 rows x 24 columns]"
],
"text/html": [
"\n",
" <div id=\"df-b26bc983-cd17-4f12-9278-d53815832e61\">\n",
" <div class=\"colab-df-container\">\n",
" <div>\n",
"<style scoped>\n",
" .dataframe tbody tr th:only-of-type {\n",
" vertical-align: middle;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: right;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>local_id</th>\n",
" <th>contact_person1</th>\n",
" <th>contact_person2</th>\n",
" <th>company_name</th>\n",
" <th>company_grade</th>\n",
" <th>phone_no</th>\n",
" <th>mobile_no1</th>\n",
" <th>mobile_no2</th>\n",
" <th>email</th>\n",
" <th>designation</th>\n",
" <th>...</th>\n",
" <th>last_conversation</th>\n",
" <th>followup_on</th>\n",
" <th>last_mail_no</th>\n",
" <th>last_mail_on</th>\n",
" <th>last_sms_no</th>\n",
" <th>last_sms_on</th>\n",
" <th>email2</th>\n",
" <th>Country</th>\n",
" <th>phonecode</th>\n",
" <th>Name</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>13</td>\n",
" <td>Krishan</td>\n",
" <td></td>\n",
" <td>Global Medikit Ltd</td>\n",
" <td>B</td>\n",
" <td>1127662182</td>\n",
" <td>9811119219.0</td>\n",
" <td></td>\n",
" <td>[email protected]</td>\n",
" <td>Director</td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Global Medikit Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>14</td>\n",
" <td>Ajay Laddha</td>\n",
" <td></td>\n",
" <td>Neha Collection</td>\n",
" <td>D</td>\n",
" <td></td>\n",
" <td>7567369544.0</td>\n",
" <td></td>\n",
" <td>[email protected]</td>\n",
" <td></td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Neha Collection</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>15</td>\n",
" <td>Rajaram</td>\n",
" <td></td>\n",
" <td>Hospira Healthcare</td>\n",
" <td>C</td>\n",
" <td></td>\n",
" <td>8754421797.0</td>\n",
" <td></td>\n",
" <td>[email protected]</td>\n",
" <td>GM</td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Hospira Healthcare</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>17</td>\n",
" <td>D.Vinaykumar</td>\n",
" <td>prashant</td>\n",
" <td>Privi Organics Ltd</td>\n",
" <td>C</td>\n",
" <td>2266023500</td>\n",
" <td>9820803656.0</td>\n",
" <td>8879228875.0</td>\n",
" <td>[email protected]</td>\n",
" <td>Dy. Manager</td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>India</td>\n",
" <td>91.0</td>\n",
" <td>Privi Organics Ltd</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>18</td>\n",
" <td>Michael Gleeson</td>\n",
" <td></td>\n",
" <td>UniGrain Pvt. Ltd</td>\n",
" <td>C</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>[email protected]</td>\n",
" <td></td>\n",
" <td>...</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td>0</td>\n",
" <td></td>\n",
" <td></td>\n",
" <td>Australia</td>\n",
" <td>61.0</td>\n",
" <td>UniGrain Pvt. Ltd</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>5 rows × 24 columns</p>\n",
"</div>\n",
" <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b26bc983-cd17-4f12-9278-d53815832e61')\"\n",
" title=\"Convert this dataframe to an interactive table.\"\n",
" style=\"display:none;\">\n",
" \n",
" <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
" width=\"24px\">\n",
" <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
" <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
" </svg>\n",
" </button>\n",
" \n",
" <style>\n",
" .colab-df-container {\n",
" display:flex;\n",
" flex-wrap:wrap;\n",
" gap: 12px;\n",
" }\n",
"\n",
" .colab-df-convert {\n",
" background-color: #E8F0FE;\n",
" border: none;\n",
" border-radius: 50%;\n",
" cursor: pointer;\n",
" display: none;\n",
" fill: #1967D2;\n",
" height: 32px;\n",
" padding: 0 0 0 0;\n",
" width: 32px;\n",
" }\n",
"\n",
" .colab-df-convert:hover {\n",
" background-color: #E2EBFA;\n",
" box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
" fill: #174EA6;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert {\n",
" background-color: #3B4455;\n",
" fill: #D2E3FC;\n",
" }\n",
"\n",
" [theme=dark] .colab-df-convert:hover {\n",
" background-color: #434B5C;\n",
" box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
" filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
" fill: #FFFFFF;\n",
" }\n",
" </style>\n",
"\n",
" <script>\n",
" const buttonEl =\n",
" document.querySelector('#df-b26bc983-cd17-4f12-9278-d53815832e61 button.colab-df-convert');\n",
" buttonEl.style.display =\n",
" google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
"\n",
" async function convertToInteractive(key) {\n",
" const element = document.querySelector('#df-b26bc983-cd17-4f12-9278-d53815832e61');\n",
" const dataTable =\n",
" await google.colab.kernel.invokeFunction('convertToInteractive',\n",
" [key], {});\n",
" if (!dataTable) return;\n",
"\n",
" const docLinkHtml = 'Like what you see? Visit the ' +\n",
" '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
" + ' to learn more about interactive tables.';\n",
" element.innerHTML = '';\n",
" dataTable['output_type'] = 'display_data';\n",
" await google.colab.output.renderOutput(dataTable, element);\n",
" const docLink = document.createElement('div');\n",
" docLink.innerHTML = docLinkHtml;\n",
" element.appendChild(docLink);\n",
" }\n",
" </script>\n",
" </div>\n",
" </div>\n",
" "
]
},
"metadata": {},
"execution_count": 27
}
]
},
{
"cell_type": "markdown",
"source": [
"# an array of owner dicts"
],
"metadata": {
"id": "zPss6_mo703G"
}
},
{
"cell_type": "code",
"source": [
"owner1 = {\n",
" \"Owner\": {\n",
" \"name\": \"Jitendra Kumar\",\n",
" \"id\": \"348201000000229001\",\n",
" \"email\": \"[email protected]\"\n",
" }\n",
"}\n",
"owner2 = {\n",
" \"Owner\": {\n",
" \"name\": \"Rajat Gupta\",\n",
" \"id\": \"348201000000231176\",\n",
" \"email\": \"[email protected]\"\n",
" }\n",
"}\n",
"owner_array = [ owner1 , owner2 ]"
],
"metadata": {
"id": "onIYG77m72vv"
},
"execution_count": null,
"outputs": []
},
{
"cell_type": "code",
"source": [
"owner_array"
],
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/"
},
"id": "zjILcwd08VG4",
"outputId": "e3a55f85-cc43-4a9b-b339-089eade96ea1"
},
"execution_count": null,
"outputs": [
{
"output_type": "execute_result",
"data": {
"text/plain": [
"[{'Owner': {'email': '[email protected]',\n",
" 'id': '348201000000229001',\n",
" 'name': 'Jitendra Kumar'}},\n",
" {'Owner': {'email': '[email protected]',\n",
" 'id': '348201000000231176',\n",
" 'name': 'Rajat Gupta'}}]"
]
},
"metadata": {},
"execution_count": 20
}
]
},
{
"cell_type": "code",
"source": [
""
],
"metadata": {
"id": "TyJi6nch8XHV"
},
"execution_count": null,
"outputs": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment