Created
January 16, 2019 19:43
-
-
Save pybokeh/4537c02da5c2b962eca67e74a0be0613 to your computer and use it in GitHub Desktop.
BRG_BRAIN/1_Member_List_Consolidation.ipynb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"cells": [ | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "## Script to help identify mis-match between database and SharePoint Member List" | |
}, | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "### Obtain members' information from BRG SharePoint member directory:" | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "import requests\nfrom requests_ntlm import HttpNtlmAuth # SharePoint authentication uses NTLM authentication protocol\nfrom getpass import getpass # allows user to enter their user ID and password without displaying it to console\nimport pandas as pd\nimport sqlite3\npd.set_option(\"display.max_rows\",1000) # or pd.options.display.max_rows=1000\npd.set_option(\"display.max_columns\",20) # or pd.options.display.max_columns=20\n\n\nSITE = \"http://hondateamlink.ham.am.honda.com//hna/sites/Brain/SitePages/Member+Directory.aspx\"\n\nUSERNAME = \"AMU\\\\\" + getpass(\"Enter your Windows user ID: \") # need to provide domain also when using NTML\nPW = getpass(\"Enter your Windows NT password: \")\n\nresponse = requests.get(SITE, auth=HttpNtlmAuth(USERNAME, PW))\nif response.status_code == 200:\n print(\"Status code:\", \"200\", \"- server has accepted your request\\n\")\nelse:\n print(\"Problem accessing site\")", | |
"execution_count": 1, | |
"outputs": [ | |
{ | |
"name": "stdout", | |
"output_type": "stream", | |
"text": "Enter your Windows user ID: ········\nEnter your Windows NT password: ········\nStatus code: 200 - server has accepted your request\n\n" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "tables = pd.read_html(response.content, header=1)", | |
"execution_count": 3, | |
"outputs": [] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "type(tables)", | |
"execution_count": 74, | |
"outputs": [ | |
{ | |
"data": { | |
"text/plain": "list" | |
}, | |
"execution_count": 74, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "len(tables)", | |
"execution_count": 75, | |
"outputs": [ | |
{ | |
"data": { | |
"text/plain": "2" | |
}, | |
"execution_count": 75, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "tables[0]", | |
"execution_count": 79, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": "<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 <th>Interest</th>\n <th>Expertise</th>\n <th>Company</th>\n <th>Functional Area</th>\n <th>Email</th>\n <th>Unnamed: 6</th>\n <th>Unnamed: 7</th>\n <th>Unnamed: 8</th>\n <th>Unnamed: 9</th>\n <th>...</th>\n <th>Unnamed: 519</th>\n <th>Unnamed: 520</th>\n <th>Unnamed: 521</th>\n <th>Unnamed: 522</th>\n <th>Unnamed: 523</th>\n <th>Unnamed: 524</th>\n <th>Unnamed: 525</th>\n <th>Unnamed: 526</th>\n <th>Unnamed: 527</th>\n <th>Unnamed: 528</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>Adam Wilson</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>HPO</td>\n <td>adam_wilson@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>1</th>\n <td>Alex Bredyuk</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>alex_bredyuk@ega.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>2</th>\n <td>Alex Dailey</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>alex_dailey@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Andrew Wendling</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td>Purchasing</td>\n <td>Andrew_Wendling@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>4</th>\n <td>Andy Winger</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>andy_winger@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>5</th>\n <td>Asif Shaikh</td>\n <td></td>\n <td>BI & DW</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>Asif_Shaikh@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>6</th>\n <td>Bob Voyles</td>\n <td></td>\n <td>SQL</td>\n <td>HNA-O NAQC</td>\n <td></td>\n <td>bob_voyles@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>7</th>\n <td>Brad Kukula</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td></td>\n <td>brad_kukula@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>8</th>\n <td>Brian Bodor</td>\n <td></td>\n <td>Parametric Cost Estimation</td>\n <td>HRA-O R&D</td>\n <td>Resource Management</td>\n <td>bbodor@oh.hra.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>9</th>\n <td>Brian Papesh</td>\n <td></td>\n <td>Quality</td>\n <td>HNA-O QTC</td>\n <td>Market Quality</td>\n <td>brian_papesh@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>10</th>\n <td>Bryan Speasmaker</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td>Purchasing</td>\n <td>Bryan_Speasmaker@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>11</th>\n <td>Bryce Soelberg</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>bryce_soelberg@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>12</th>\n <td>Carl Sommerville</td>\n <td></td>\n <td>Smart Factory</td>\n <td>HNA-O HHC</td>\n <td>IT</td>\n <td>Carl_Sommerville@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>13</th>\n <td>Casey Fulton</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>casey_r_fulton@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>14</th>\n <td>Cate Whitfield</td>\n <td></td>\n <td>Knowlege management</td>\n <td>HNA-O HHC</td>\n <td>ASK Network</td>\n <td>cate_whitfield@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>15</th>\n <td>Chelsea Nungesser</td>\n <td></td>\n <td>Data analyst</td>\n <td>HAM-O ELP</td>\n <td>Bumper Paint</td>\n <td>chelsea_nungesser@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>16</th>\n <td>Cheri Brumbaugh</td>\n <td>PR/Communications Chair</td>\n <td>Analytics</td>\n <td>HAM-O HOO</td>\n <td>HR</td>\n <td>cheri_brumbaugh@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>17</th>\n <td>Cherie Drees</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td>MFG IT</td>\n <td>cherie_drees@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>18</th>\n <td>Chris</td>\n <td></td>\n <td></td>\n <td>HAM-O HSO</td>\n <td>HPO</td>\n <td>chris_roush@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>19</th>\n <td>Cody Manger</td>\n <td></td>\n <td>Capacity Management</td>\n <td>HNA-O MMC</td>\n <td>Procurement</td>\n <td>cody_manger@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>20</th>\n <td>Cortney McClure</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>HPO</td>\n <td>cortney_mcclure@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>21</th>\n <td>Dale Malony</td>\n <td></td>\n <td>Asset health analytics</td>\n <td>HAM-O ELP</td>\n <td></td>\n <td>Dale_Malony@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>22</th>\n <td>Daniel Kim</td>\n <td>Technology Committee Chair</td>\n <td>Quality data analyst</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>daniel_j_kim@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>23</th>\n <td>Daniela Evans</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td></td>\n <td>daniela_evans@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>24</th>\n <td>Danny Carroll</td>\n <td></td>\n <td>BI & Analytics tools</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>Danny_Carroll@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>25</th>\n <td>David Plonski</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td></td>\n <td>David_Plonski@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>26</th>\n <td>Deedat Choudhury</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>Deedat_Choudhury@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>27</th>\n <td>Derek Davis</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td></td>\n <td>Derek_Davis@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>28</th>\n <td>Derrick Cobb</td>\n <td>Machine Intelligence Chair</td>\n <td>Machine Intelligence</td>\n <td>EGA-O EG</td>\n <td>Research</td>\n <td>Derrick_Cobb@ega.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>29</th>\n <td>Diego Hildebrandt</td>\n <td></td>\n <td>Simulation</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>diego_hildebrandt@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>30</th>\n <td>Dillon Brancheau</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td></td>\n <td>dillon_brancheau@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>31</th>\n <td>Doug Kremer</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>doug_kremer@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>32</th>\n <td>Drew Kennedy</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>drew_kennedy@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>33</th>\n <td>Drew Paroz</td>\n <td></td>\n <td>Statistical experiments, delivery</td>\n <td>HAM-O HSO</td>\n <td>Purchasing New Model Delivery</td>\n <td>drew_paroz@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>34</th>\n <td>Eric Roby</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>Eric_Roby@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>35</th>\n <td>Glen Wang</td>\n <td>Chair</td>\n <td>Analytics process & strategies</td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>glen_wang@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>36</th>\n <td>Greg Cottrill</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>greg_cottrill@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>37</th>\n <td>Greta Backus</td>\n <td></td>\n <td>Forecasting</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>greta_backus@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>38</th>\n <td>Harry Wagner</td>\n <td></td>\n <td>Tech Fest</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>harry_wagner@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>39</th>\n <td>Hiroshi Hayashi</td>\n <td></td>\n <td>Technologist</td>\n <td>HNA-O HHC</td>\n <td>IT</td>\n <td>hiroshi_hayashi@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>40</th>\n <td>Jake Coloney</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td></td>\n <td>jake_coloney@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>41</th>\n <td>James Brooks</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td>Internal Audit</td>\n <td>james_f_brooks@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>42</th>\n <td>Jennifer Bell</td>\n <td></td>\n <td></td>\n <td>HMA</td>\n <td>IT</td>\n <td>Jennifer_Bell@hma.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>43</th>\n <td>Jen Harper</td>\n <td></td>\n <td>Data/process analyst</td>\n <td>HNA-O HHC</td>\n <td>HR</td>\n <td>Jen_Harper@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>44</th>\n <td>Jeremy Block</td>\n <td></td>\n <td>Data science</td>\n <td>HRA-O R&D</td>\n <td>Infotainment</td>\n <td>JBlock@oh.hra.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>45</th>\n <td>Joe Mazzocchi</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>E-Planning</td>\n <td>Joe_Mazzocchi@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>46</th>\n <td>Jordan Tipton</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>NAP MRO</td>\n <td>jordan_tipton@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>47</th>\n <td>Jonathan Alvarez</td>\n <td>Career Committee Chair</td>\n <td>Quality Data Analysis</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>jonathan_alvarez@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>48</th>\n <td>Jonathon Pack</td>\n <td></td>\n <td>Quality BI</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>jonathon_pack@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>49</th>\n <td>Kazue Motoki</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>kazue_motoki@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>50</th>\n <td>Kevin Girard</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>Weld Quality</td>\n <td>kevin_girard@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>51</th>\n <td>Kristen Vilt</td>\n <td></td>\n <td>Simulation</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>Kristen_Vilt@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>52</th>\n <td>Landon Small</td>\n <td></td>\n <td>Logistics Analytics</td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>landon_small@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>53</th>\n <td>Larry Roudebush</td>\n <td></td>\n <td></td>\n <td>HNA-O NAQC</td>\n <td></td>\n <td>Larry_roudebush@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>54</th>\n <td>Lorie Austin</td>\n <td></td>\n <td>Spec Control</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>lorie_austin@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>55</th>\n <td>Mark Bar</td>\n <td></td>\n <td>Forecasting</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>mark_bar@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>56</th>\n <td>May Markusic</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>HPO</td>\n <td>mayflor_markusic@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>57</th>\n <td>Michelle Witte</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>Weld Quality</td>\n <td>michelle_witte@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>58</th>\n <td>Mike Ramsey</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Engineering Center</td>\n <td>mike_ramsey@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>59</th>\n <td>Mitch Komine</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td></td>\n <td>mitch_komine@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>60</th>\n <td>Nick Allen</td>\n <td>Impact Committee Advisor</td>\n <td>Discrete Simulations</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>Nick_Allen@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>61</th>\n <td>Noah Ronneberg</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>noah_ronneberg@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>62</th>\n <td>Pavithra Ramamurthy</td>\n <td></td>\n <td>BI & Analytics tools</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>pavithra_ramamurthy@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>63</th>\n <td>Pete Edwards</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>pete_edwards@ega.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>64</th>\n <td>Philip Wilson</td>\n <td>Commerce Committee Chair</td>\n <td>Quality Data Analysis</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>philip_wilson@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>65</th>\n <td>Rajeev Chhajer</td>\n <td></td>\n <td>Big data, emerging technologies, data service</td>\n <td>HRA-O R&D</td>\n <td>IT</td>\n <td>rajeev_chhajer@oh.hra.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>66</th>\n <td>Rick Carlisle</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>rick_carlisle@ega.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>67</th>\n <td>Riley Hohman</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td></td>\n <td>riley_hohman@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>68</th>\n <td>Roy Daikuzono</td>\n <td></td>\n <td>Resource Management Analytics</td>\n <td>HRA-O R&D</td>\n <td>Resource Management</td>\n <td>RDaikuzono@oh.hra.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>69</th>\n <td>RW Powers</td>\n <td></td>\n <td>Purchasing Business Analyst</td>\n <td>HNA-O NAP</td>\n <td>Procurement</td>\n <td>RW_Powers@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>70</th>\n <td>Ryan Danley</td>\n <td></td>\n <td></td>\n <td>HMIN</td>\n <td>HR</td>\n <td>ryan_danley@hmin.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>71</th>\n <td>Ryan Smith</td>\n <td></td>\n <td>Supplier quality BI</td>\n <td>HNA-O MMC</td>\n <td>Procurement</td>\n <td>ryan_smith@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>72</th>\n <td>Sam Gronow</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td>NAAP</td>\n <td>sam_gronow@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>73</th>\n <td>Sarah Legatt</td>\n <td></td>\n <td>Virtual factory, fluid dynamics</td>\n <td>HNA-O R&D</td>\n <td>New Model</td>\n <td>sarah_legatt@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>74</th>\n <td>Sean Holshu</td>\n <td></td>\n <td>Information Security Office</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>sean_holshu@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>75</th>\n <td>Scott Carter</td>\n <td></td>\n <td>Competitive Intelligence</td>\n <td>HNA-O MMC</td>\n <td>E-Planning</td>\n <td>Scott_Carter@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>76</th>\n <td>Scott Nourse</td>\n <td>Vice-Chair</td>\n <td>Logistics projects</td>\n <td>HNA-O MMP</td>\n <td>Logistics</td>\n <td>Scott_Nourse@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>77</th>\n <td>Shawnee Moseman</td>\n <td></td>\n <td>Logistics Systems</td>\n <td>HNA-O MMP</td>\n <td>Logistics</td>\n <td>Shawnee_Moseman@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>78</th>\n <td>Steve Baker</td>\n <td></td>\n <td>Machine data analytics</td>\n <td>HAM-O AEP</td>\n <td>IT</td>\n <td>Steve_J_Baker@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>79</th>\n <td>Thomas Hendel</td>\n <td></td>\n <td>Supply Chain Systems, Business Analyst</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>thomas_hendel@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>80</th>\n <td>Tom Crawford</td>\n <td></td>\n <td>Virtual Factory/VMC</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>tom_crawford@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>81</th>\n <td>Tom Harris</td>\n <td></td>\n <td>Spec Control applications</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>Tom_Harris@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>82</th>\n <td>Traviss Alexander</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Purchasing</td>\n <td>traviss_alexander@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>83</th>\n <td>Mabe Fujita</td>\n <td></td>\n <td>SQL & SCM Systems</td>\n <td>HNA-O</td>\n <td>NA-IOO KD Export</td>\n <td>Mabe_Fujita@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>84</th>\n <td>Ronald Armstrong</td>\n <td></td>\n <td></td>\n <td>HNA-HHC</td>\n <td>HNA Audit</td>\n <td>brent_armstrong@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>85</th>\n <td>Farhan Ahmed</td>\n <td></td>\n <td></td>\n <td>HNA-O</td>\n <td>HR</td>\n <td>farhan_ahmed@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>86</th>\n <td>Edward Malek</td>\n <td></td>\n <td>HAM Forming-NM</td>\n <td>HAM-MAP NM</td>\n <td>NM</td>\n <td>Edward_Malek@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>87</th>\n <td>Name</td>\n <td>Interest</td>\n <td>Expertise</td>\n <td>Company</td>\n <td>Functional Area</td>\n <td>Email</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>88</th>\n <td>Adam Wilson</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>HPO</td>\n <td>adam_wilson@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>89</th>\n <td>Alex Bredyuk</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>alex_bredyuk@ega.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>90</th>\n <td>Alex Dailey</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>alex_dailey@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>91</th>\n <td>Andrew Wendling</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td>Purchasing</td>\n <td>Andrew_Wendling@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>92</th>\n <td>Andy Winger</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>andy_winger@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>93</th>\n <td>Asif Shaikh</td>\n <td></td>\n <td>BI & DW</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>Asif_Shaikh@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>94</th>\n <td>Bob Voyles</td>\n <td></td>\n <td>SQL</td>\n <td>HNA-O NAQC</td>\n <td></td>\n <td>bob_voyles@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>95</th>\n <td>Brad Kukula</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td></td>\n <td>brad_kukula@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>96</th>\n <td>Brian Bodor</td>\n <td></td>\n <td>Parametric Cost Estimation</td>\n <td>HRA-O R&D</td>\n <td>Resource Management</td>\n <td>bbodor@oh.hra.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>97</th>\n <td>Brian Papesh</td>\n <td></td>\n <td>Quality</td>\n <td>HNA-O QTC</td>\n <td>Market Quality</td>\n <td>brian_papesh@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>98</th>\n <td>Bryan Speasmaker</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td>Purchasing</td>\n <td>Bryan_Speasmaker@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>99</th>\n <td>Bryce Soelberg</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>bryce_soelberg@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>100</th>\n <td>Carl Sommerville</td>\n <td></td>\n <td>Smart Factory</td>\n <td>HNA-O HHC</td>\n <td>IT</td>\n <td>Carl_Sommerville@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>101</th>\n <td>Casey Fulton</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>casey_r_fulton@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>102</th>\n <td>Cate Whitfield</td>\n <td></td>\n <td>Knowlege management</td>\n <td>HNA-O HHC</td>\n <td>ASK Network</td>\n <td>cate_whitfield@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>103</th>\n <td>Chelsea Nungesser</td>\n <td></td>\n <td>Data analyst</td>\n <td>HAM-O ELP</td>\n <td>Bumper Paint</td>\n <td>chelsea_nungesser@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>104</th>\n <td>Cheri Brumbaugh</td>\n <td>PR/Communications Chair</td>\n <td>Analytics</td>\n <td>HAM-O HOO</td>\n <td>HR</td>\n <td>cheri_brumbaugh@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>105</th>\n <td>Cherie Drees</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td>MFG IT</td>\n <td>cherie_drees@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>106</th>\n <td>Chris</td>\n <td></td>\n <td></td>\n <td>HAM-O HSO</td>\n <td>HPO</td>\n <td>chris_roush@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>107</th>\n <td>Cody Manger</td>\n <td></td>\n <td>Capacity Management</td>\n <td>HNA-O MMC</td>\n <td>Procurement</td>\n <td>cody_manger@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>108</th>\n <td>Cortney McClure</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>HPO</td>\n <td>cortney_mcclure@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>109</th>\n <td>Dale Malony</td>\n <td></td>\n <td>Asset health analytics</td>\n <td>HAM-O ELP</td>\n <td></td>\n <td>Dale_Malony@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>110</th>\n <td>Daniel Kim</td>\n <td>Technology Committee Chair</td>\n <td>Quality data analyst</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>daniel_j_kim@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>111</th>\n <td>Daniela Evans</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td></td>\n <td>daniela_evans@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>112</th>\n <td>Danny Carroll</td>\n <td></td>\n <td>BI & Analytics tools</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>Danny_Carroll@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>113</th>\n <td>David Plonski</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td></td>\n <td>David_Plonski@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>114</th>\n <td>Deedat Choudhury</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>Deedat_Choudhury@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>115</th>\n <td>Derek Davis</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td></td>\n <td>Derek_Davis@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>116</th>\n <td>Derrick Cobb</td>\n <td>Machine Intelligence Chair</td>\n <td>Machine Intelligence</td>\n <td>EGA-O EG</td>\n <td>Research</td>\n <td>Derrick_Cobb@ega.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>117</th>\n <td>Diego Hildebrandt</td>\n <td></td>\n <td>Simulation</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>diego_hildebrandt@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>118</th>\n <td>Dillon Brancheau</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td></td>\n <td>dillon_brancheau@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>119</th>\n <td>Doug Kremer</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>doug_kremer@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>120</th>\n <td>Drew Kennedy</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>drew_kennedy@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>121</th>\n <td>Drew Paroz</td>\n <td></td>\n <td>Statistical experiments, delivery</td>\n <td>HAM-O HSO</td>\n <td>Purchasing New Model Delivery</td>\n <td>drew_paroz@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>122</th>\n <td>Eric Roby</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>Eric_Roby@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>123</th>\n <td>Glen Wang</td>\n <td>Chair</td>\n <td>Analytics process & strategies</td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>glen_wang@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>124</th>\n <td>Greg Cottrill</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>greg_cottrill@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>125</th>\n <td>Greta Backus</td>\n <td></td>\n <td>Forecasting</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>greta_backus@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>126</th>\n <td>Harry Wagner</td>\n <td></td>\n <td>Tech Fest</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>harry_wagner@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>127</th>\n <td>Hiroshi Hayashi</td>\n <td></td>\n <td>Technologist</td>\n <td>HNA-O HHC</td>\n <td>IT</td>\n <td>hiroshi_hayashi@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>128</th>\n <td>Jake Coloney</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td></td>\n <td>jake_coloney@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>129</th>\n <td>James Brooks</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td>Internal Audit</td>\n <td>james_f_brooks@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>130</th>\n <td>Jennifer Bell</td>\n <td></td>\n <td></td>\n <td>HMA</td>\n <td>IT</td>\n <td>Jennifer_Bell@hma.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>131</th>\n <td>Jen Harper</td>\n <td></td>\n <td>Data/process analyst</td>\n <td>HNA-O HHC</td>\n <td>HR</td>\n <td>Jen_Harper@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>132</th>\n <td>Jeremy Block</td>\n <td></td>\n <td>Data science</td>\n <td>HRA-O R&D</td>\n <td>Infotainment</td>\n <td>JBlock@oh.hra.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>133</th>\n <td>Joe Mazzocchi</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>E-Planning</td>\n <td>Joe_Mazzocchi@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>134</th>\n <td>Jordan Tipton</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>NAP MRO</td>\n <td>jordan_tipton@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>135</th>\n <td>Jonathan Alvarez</td>\n <td>Career Committee Chair</td>\n <td>Quality Data Analysis</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>jonathan_alvarez@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>136</th>\n <td>Jonathon Pack</td>\n <td></td>\n <td>Quality BI</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>jonathon_pack@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>137</th>\n <td>Kazue Motoki</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>kazue_motoki@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>138</th>\n <td>Kevin Girard</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>Weld Quality</td>\n <td>kevin_girard@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>139</th>\n <td>Kristen Vilt</td>\n <td></td>\n <td>Simulation</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>Kristen_Vilt@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>140</th>\n <td>Landon Small</td>\n <td></td>\n <td>Logistics Analytics</td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>landon_small@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>141</th>\n <td>Larry Roudebush</td>\n <td></td>\n <td></td>\n <td>HNA-O NAQC</td>\n <td></td>\n <td>Larry_roudebush@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>142</th>\n <td>Lorie Austin</td>\n <td></td>\n <td>Spec Control</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>lorie_austin@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>143</th>\n <td>Mark Bar</td>\n <td></td>\n <td>Forecasting</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>mark_bar@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>144</th>\n <td>May Markusic</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>HPO</td>\n <td>mayflor_markusic@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>145</th>\n <td>Michelle Witte</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>Weld Quality</td>\n <td>michelle_witte@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>146</th>\n <td>Mike Ramsey</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Engineering Center</td>\n <td>mike_ramsey@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>147</th>\n <td>Mitch Komine</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td></td>\n <td>mitch_komine@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>148</th>\n <td>Nick Allen</td>\n <td>Impact Committee Advisor</td>\n <td>Discrete Simulations</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>Nick_Allen@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>149</th>\n <td>Noah Ronneberg</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>noah_ronneberg@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>150</th>\n <td>Pavithra Ramamurthy</td>\n <td></td>\n <td>BI & Analytics tools</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>pavithra_ramamurthy@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>151</th>\n <td>Pete Edwards</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>pete_edwards@ega.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>152</th>\n <td>Philip Wilson</td>\n <td>Commerce Committee Chair</td>\n <td>Quality Data Analysis</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>philip_wilson@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>153</th>\n <td>Rajeev Chhajer</td>\n <td></td>\n <td>Big data, emerging technologies, data service</td>\n <td>HRA-O R&D</td>\n <td>IT</td>\n <td>rajeev_chhajer@oh.hra.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>154</th>\n <td>Rick Carlisle</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>rick_carlisle@ega.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>155</th>\n <td>Riley Hohman</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td></td>\n <td>riley_hohman@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>156</th>\n <td>Roy Daikuzono</td>\n <td></td>\n <td>Resource Management Analytics</td>\n <td>HRA-O R&D</td>\n <td>Resource Management</td>\n <td>RDaikuzono@oh.hra.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>157</th>\n <td>RW Powers</td>\n <td></td>\n <td>Purchasing Business Analyst</td>\n <td>HNA-O NAP</td>\n <td>Procurement</td>\n <td>RW_Powers@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>158</th>\n <td>Ryan Danley</td>\n <td></td>\n <td></td>\n <td>HMIN</td>\n <td>HR</td>\n <td>ryan_danley@hmin.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>159</th>\n <td>Ryan Smith</td>\n <td></td>\n <td>Supplier quality BI</td>\n <td>HNA-O MMC</td>\n <td>Procurement</td>\n <td>ryan_smith@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>160</th>\n <td>Sam Gronow</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td>NAAP</td>\n <td>sam_gronow@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>161</th>\n <td>Sarah Legatt</td>\n <td></td>\n <td>Virtual factory, fluid dynamics</td>\n <td>HNA-O R&D</td>\n <td>New Model</td>\n <td>sarah_legatt@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>162</th>\n <td>Sean Holshu</td>\n <td></td>\n <td>Information Security Office</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>sean_holshu@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>163</th>\n <td>Scott Carter</td>\n <td></td>\n <td>Competitive Intelligence</td>\n <td>HNA-O MMC</td>\n <td>E-Planning</td>\n <td>Scott_Carter@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>164</th>\n <td>Scott Nourse</td>\n <td>Vice-Chair</td>\n <td>Logistics projects</td>\n <td>HNA-O MMP</td>\n <td>Logistics</td>\n <td>Scott_Nourse@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>165</th>\n <td>Shawnee Moseman</td>\n <td></td>\n <td>Logistics Systems</td>\n <td>HNA-O MMP</td>\n <td>Logistics</td>\n <td>Shawnee_Moseman@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>166</th>\n <td>Steve Baker</td>\n <td></td>\n <td>Machine data analytics</td>\n <td>HAM-O AEP</td>\n <td>IT</td>\n <td>Steve_J_Baker@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>167</th>\n <td>Thomas Hendel</td>\n <td></td>\n <td>Supply Chain Systems, Business Analyst</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>thomas_hendel@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>168</th>\n <td>Tom Crawford</td>\n <td></td>\n <td>Virtual Factory/VMC</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>tom_crawford@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>169</th>\n <td>Tom Harris</td>\n <td></td>\n <td>Spec Control applications</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>Tom_Harris@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>170</th>\n <td>Traviss Alexander</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Purchasing</td>\n <td>traviss_alexander@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>171</th>\n <td>Mabe Fujita</td>\n <td></td>\n <td>SQL & SCM Systems</td>\n <td>HNA-O</td>\n <td>NA-IOO KD Export</td>\n <td>Mabe_Fujita@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>172</th>\n <td>Ronald Armstrong</td>\n <td></td>\n <td></td>\n <td>HNA-HHC</td>\n <td>HNA Audit</td>\n <td>brent_armstrong@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>173</th>\n <td>Farhan Ahmed</td>\n <td></td>\n <td></td>\n <td>HNA-O</td>\n <td>HR</td>\n <td>farhan_ahmed@hna.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n <tr>\n <th>174</th>\n <td>Edward Malek</td>\n <td></td>\n <td>HAM Forming-NM</td>\n <td>HAM-MAP NM</td>\n <td>NM</td>\n <td>Edward_Malek@ham.honda.com</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>...</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>NaN</td>\n </tr>\n </tbody>\n</table>\n<p>175 rows × 529 columns</p>\n</div>", | |
"text/plain": " Name Interest \\\n0 Adam Wilson \n1 Alex Bredyuk \n2 Alex Dailey \n3 Andrew Wendling \n4 Andy Winger \n5 Asif Shaikh \n6 Bob Voyles \n7 Brad Kukula \n8 Brian Bodor \n9 Brian Papesh \n10 Bryan Speasmaker \n11 Bryce Soelberg \n12 Carl Sommerville \n13 Casey Fulton \n14 Cate Whitfield \n15 Chelsea Nungesser \n16 Cheri Brumbaugh PR/Communications Chair \n17 Cherie Drees \n18 Chris \n19 Cody Manger \n20 Cortney McClure \n21 Dale Malony \n22 Daniel Kim Technology Committee Chair \n23 Daniela Evans \n24 Danny Carroll \n25 David Plonski \n26 Deedat Choudhury \n27 Derek Davis \n28 Derrick Cobb Machine Intelligence Chair \n29 Diego Hildebrandt \n30 Dillon Brancheau \n31 Doug Kremer \n32 Drew Kennedy \n33 Drew Paroz \n34 Eric Roby \n35 Glen Wang Chair \n36 Greg Cottrill \n37 Greta Backus \n38 Harry Wagner \n39 Hiroshi Hayashi \n40 Jake Coloney \n41 James Brooks \n42 Jennifer Bell \n43 Jen Harper \n44 Jeremy Block \n45 Joe Mazzocchi \n46 Jordan Tipton \n47 Jonathan Alvarez Career Committee Chair \n48 Jonathon Pack \n49 Kazue Motoki \n50 Kevin Girard \n51 Kristen Vilt \n52 Landon Small \n53 Larry Roudebush \n54 Lorie Austin \n55 Mark Bar \n56 May Markusic \n57 Michelle Witte \n58 Mike Ramsey \n59 Mitch Komine \n60 Nick Allen Impact Committee Advisor \n61 Noah Ronneberg \n62 Pavithra Ramamurthy \n63 Pete Edwards \n64 Philip Wilson Commerce Committee Chair \n65 Rajeev Chhajer \n66 Rick Carlisle \n67 Riley Hohman \n68 Roy Daikuzono \n69 RW Powers \n70 Ryan Danley \n71 Ryan Smith \n72 Sam Gronow \n73 Sarah Legatt \n74 Sean Holshu \n75 Scott Carter \n76 Scott Nourse Vice-Chair \n77 Shawnee Moseman \n78 Steve Baker \n79 Thomas Hendel \n80 Tom Crawford \n81 Tom Harris \n82 Traviss Alexander \n83 Mabe Fujita \n84 Ronald Armstrong \n85 Farhan Ahmed \n86 Edward Malek \n87 Name Interest \n88 Adam Wilson \n89 Alex Bredyuk \n90 Alex Dailey \n91 Andrew Wendling \n92 Andy Winger \n93 Asif Shaikh \n94 Bob Voyles \n95 Brad Kukula \n96 Brian Bodor \n97 Brian Papesh \n98 Bryan Speasmaker \n99 Bryce Soelberg \n100 Carl Sommerville \n101 Casey Fulton \n102 Cate Whitfield \n103 Chelsea Nungesser \n104 Cheri Brumbaugh PR/Communications Chair \n105 Cherie Drees \n106 Chris \n107 Cody Manger \n108 Cortney McClure \n109 Dale Malony \n110 Daniel Kim Technology Committee Chair \n111 Daniela Evans \n112 Danny Carroll \n113 David Plonski \n114 Deedat Choudhury \n115 Derek Davis \n116 Derrick Cobb Machine Intelligence Chair \n117 Diego Hildebrandt \n118 Dillon Brancheau \n119 Doug Kremer \n120 Drew Kennedy \n121 Drew Paroz \n122 Eric Roby \n123 Glen Wang Chair \n124 Greg Cottrill \n125 Greta Backus \n126 Harry Wagner \n127 Hiroshi Hayashi \n128 Jake Coloney \n129 James Brooks \n130 Jennifer Bell \n131 Jen Harper \n132 Jeremy Block \n133 Joe Mazzocchi \n134 Jordan Tipton \n135 Jonathan Alvarez Career Committee Chair \n136 Jonathon Pack \n137 Kazue Motoki \n138 Kevin Girard \n139 Kristen Vilt \n140 Landon Small \n141 Larry Roudebush \n142 Lorie Austin \n143 Mark Bar \n144 May Markusic \n145 Michelle Witte \n146 Mike Ramsey \n147 Mitch Komine \n148 Nick Allen Impact Committee Advisor \n149 Noah Ronneberg \n150 Pavithra Ramamurthy \n151 Pete Edwards \n152 Philip Wilson Commerce Committee Chair \n153 Rajeev Chhajer \n154 Rick Carlisle \n155 Riley Hohman \n156 Roy Daikuzono \n157 RW Powers \n158 Ryan Danley \n159 Ryan Smith \n160 Sam Gronow \n161 Sarah Legatt \n162 Sean Holshu \n163 Scott Carter \n164 Scott Nourse Vice-Chair \n165 Shawnee Moseman \n166 Steve Baker \n167 Thomas Hendel \n168 Tom Crawford \n169 Tom Harris \n170 Traviss Alexander \n171 Mabe Fujita \n172 Ronald Armstrong \n173 Farhan Ahmed \n174 Edward Malek \n\n Expertise Company \\\n0 HAM-O ELP \n1 EGA-O EG \n2 HNA-O MMC \n3 HAM-O AEP \n4 HNA-O MMC \n5 BI & DW HNA-O NAQC \n6 SQL HNA-O NAQC \n7 HNA-O R&D \n8 Parametric Cost Estimation HRA-O R&D \n9 Quality HNA-O QTC \n10 HNA-O NAP \n11 HAM-O MAP \n12 Smart Factory HNA-O HHC \n13 HAM-O MAP \n14 Knowlege management HNA-O HHC \n15 Data analyst HAM-O ELP \n16 Analytics HAM-O HOO \n17 HAM-O AEP \n18 HAM-O HSO \n19 Capacity Management HNA-O MMC \n20 HAM-O ELP \n21 Asset health analytics HAM-O ELP \n22 Quality data analyst HNA-O NAQC \n23 HNA-O HHC \n24 BI & Analytics tools HNA-O MMC \n25 HAM-O AEP \n26 HAM-O MAP \n27 HNA-O NAP \n28 Machine Intelligence EGA-O EG \n29 Simulation HNA-O HHC \n30 HAM-O AEP \n31 HAM-O MAP \n32 HAM-O MAP \n33 Statistical experiments, delivery HAM-O HSO \n34 HNA-O MMC \n35 Analytics process & strategies HNA-O MMC \n36 HNA-O MMC \n37 Forecasting HNA-O NAQC \n38 Tech Fest HNA-O HHC \n39 Technologist HNA-O HHC \n40 HNA-O R&D \n41 HNA-O HHC \n42 HMA \n43 Data/process analyst HNA-O HHC \n44 Data science HRA-O R&D \n45 HNA-O MMC \n46 HNA-O MMC \n47 Quality Data Analysis HNA-O NAQC \n48 Quality BI HNA-O NAQC \n49 HNA-O MMC \n50 HAM-O ELP \n51 Simulation HNA-O HHC \n52 Logistics Analytics HNA-O MMC \n53 HNA-O NAQC \n54 Spec Control HNA-O MMC \n55 Forecasting HNA-O NAQC \n56 HAM-O ELP \n57 HAM-O ELP \n58 HNA-O MMC \n59 HNA-O HHC \n60 Discrete Simulations HNA-O HHC \n61 HNA-O HHC \n62 BI & Analytics tools HNA-O MMC \n63 EGA-O EG \n64 Quality Data Analysis HNA-O NAQC \n65 Big data, emerging technologies, data service HRA-O R&D \n66 EGA-O EG \n67 HNA-O NAP \n68 Resource Management Analytics HRA-O R&D \n69 Purchasing Business Analyst HNA-O NAP \n70 HMIN \n71 Supplier quality BI HNA-O MMC \n72 HNA-O R&D \n73 Virtual factory, fluid dynamics HNA-O R&D \n74 Information Security Office HNA-O MMC \n75 Competitive Intelligence HNA-O MMC \n76 Logistics projects HNA-O MMP \n77 Logistics Systems HNA-O MMP \n78 Machine data analytics HAM-O AEP \n79 Supply Chain Systems, Business Analyst HNA-O MMC \n80 Virtual Factory/VMC HNA-O MMC \n81 Spec Control applications HNA-O MMC \n82 HNA-O MMC \n83 SQL & SCM Systems HNA-O \n84 HNA-HHC \n85 HNA-O \n86 HAM Forming-NM HAM-MAP NM \n87 Expertise Company \n88 HAM-O ELP \n89 EGA-O EG \n90 HNA-O MMC \n91 HAM-O AEP \n92 HNA-O MMC \n93 BI & DW HNA-O NAQC \n94 SQL HNA-O NAQC \n95 HNA-O R&D \n96 Parametric Cost Estimation HRA-O R&D \n97 Quality HNA-O QTC \n98 HNA-O NAP \n99 HAM-O MAP \n100 Smart Factory HNA-O HHC \n101 HAM-O MAP \n102 Knowlege management HNA-O HHC \n103 Data analyst HAM-O ELP \n104 Analytics HAM-O HOO \n105 HAM-O AEP \n106 HAM-O HSO \n107 Capacity Management HNA-O MMC \n108 HAM-O ELP \n109 Asset health analytics HAM-O ELP \n110 Quality data analyst HNA-O NAQC \n111 HNA-O HHC \n112 BI & Analytics tools HNA-O MMC \n113 HAM-O AEP \n114 HAM-O MAP \n115 HNA-O NAP \n116 Machine Intelligence EGA-O EG \n117 Simulation HNA-O HHC \n118 HAM-O AEP \n119 HAM-O MAP \n120 HAM-O MAP \n121 Statistical experiments, delivery HAM-O HSO \n122 HNA-O MMC \n123 Analytics process & strategies HNA-O MMC \n124 HNA-O MMC \n125 Forecasting HNA-O NAQC \n126 Tech Fest HNA-O HHC \n127 Technologist HNA-O HHC \n128 HNA-O R&D \n129 HNA-O HHC \n130 HMA \n131 Data/process analyst HNA-O HHC \n132 Data science HRA-O R&D \n133 HNA-O MMC \n134 HNA-O MMC \n135 Quality Data Analysis HNA-O NAQC \n136 Quality BI HNA-O NAQC \n137 HNA-O MMC \n138 HAM-O ELP \n139 Simulation HNA-O HHC \n140 Logistics Analytics HNA-O MMC \n141 HNA-O NAQC \n142 Spec Control HNA-O MMC \n143 Forecasting HNA-O NAQC \n144 HAM-O ELP \n145 HAM-O ELP \n146 HNA-O MMC \n147 HNA-O HHC \n148 Discrete Simulations HNA-O HHC \n149 HNA-O HHC \n150 BI & Analytics tools HNA-O MMC \n151 EGA-O EG \n152 Quality Data Analysis HNA-O NAQC \n153 Big data, emerging technologies, data service HRA-O R&D \n154 EGA-O EG \n155 HNA-O NAP \n156 Resource Management Analytics HRA-O R&D \n157 Purchasing Business Analyst HNA-O NAP \n158 HMIN \n159 Supplier quality BI HNA-O MMC \n160 HNA-O R&D \n161 Virtual factory, fluid dynamics HNA-O R&D \n162 Information Security Office HNA-O MMC \n163 Competitive Intelligence HNA-O MMC \n164 Logistics projects HNA-O MMP \n165 Logistics Systems HNA-O MMP \n166 Machine data analytics HAM-O AEP \n167 Supply Chain Systems, Business Analyst HNA-O MMC \n168 Virtual Factory/VMC HNA-O MMC \n169 Spec Control applications HNA-O MMC \n170 HNA-O MMC \n171 SQL & SCM Systems HNA-O \n172 HNA-HHC \n173 HNA-O \n174 HAM Forming-NM HAM-MAP NM \n\n Functional Area Email \\\n0 HPO adam_wilson@ham.honda.com \n1 alex_bredyuk@ega.honda.com \n2 alex_dailey@hna.honda.com \n3 Purchasing Andrew_Wendling@ham.honda.com \n4 Logistics andy_winger@hna.honda.com \n5 Market Quality Asif_Shaikh@hna.honda.com \n6 bob_voyles@hna.honda.com \n7 brad_kukula@hna.honda.com \n8 Resource Management bbodor@oh.hra.com \n9 Market Quality brian_papesh@hna.honda.com \n10 Purchasing Bryan_Speasmaker@hna.honda.com \n11 bryce_soelberg@ham.honda.com \n12 IT Carl_Sommerville@hna.honda.com \n13 casey_r_fulton@ham.honda.com \n14 ASK Network cate_whitfield@hna.honda.com \n15 Bumper Paint chelsea_nungesser@ham.honda.com \n16 HR cheri_brumbaugh@ham.honda.com \n17 MFG IT cherie_drees@ham.honda.com \n18 HPO chris_roush@ham.honda.com \n19 Procurement cody_manger@hna.honda.com \n20 HPO cortney_mcclure@ham.honda.com \n21 Dale_Malony@ham.honda.com \n22 Market Quality daniel_j_kim@hna.honda.com \n23 daniela_evans@hna.honda.com \n24 IT Danny_Carroll@hna.honda.com \n25 David_Plonski@ham.honda.com \n26 Deedat_Choudhury@ham.honda.com \n27 Derek_Davis@hna.honda.com \n28 Research Derrick_Cobb@ega.honda.com \n29 Engineering Center diego_hildebrandt@hna.honda.com \n30 dillon_brancheau@ham.honda.com \n31 doug_kremer@ham.honda.com \n32 drew_kennedy@ham.honda.com \n33 Purchasing New Model Delivery drew_paroz@ham.honda.com \n34 Eric_Roby@hna.honda.com \n35 glen_wang@hna.honda.com \n36 Logistics greg_cottrill@hna.honda.com \n37 Market Quality greta_backus@hna.honda.com \n38 Engineering Center harry_wagner@hna.honda.com \n39 IT hiroshi_hayashi@hna.honda.com \n40 jake_coloney@hna.honda.com \n41 Internal Audit james_f_brooks@hna.honda.com \n42 IT Jennifer_Bell@hma.honda.com \n43 HR Jen_Harper@hna.honda.com \n44 Infotainment JBlock@oh.hra.com \n45 E-Planning Joe_Mazzocchi@hna.honda.com \n46 NAP MRO jordan_tipton@hna.honda.com \n47 Market Quality jonathan_alvarez@hna.honda.com \n48 Market Quality jonathon_pack@hna.honda.com \n49 kazue_motoki@hna.honda.com \n50 Weld Quality kevin_girard@ham.honda.com \n51 Engineering Center Kristen_Vilt@hna.honda.com \n52 Logistics landon_small@hna.honda.com \n53 Larry_roudebush@hna.honda.com \n54 New Model lorie_austin@hna.honda.com \n55 Market Quality mark_bar@hna.honda.com \n56 HPO mayflor_markusic@ham.honda.com \n57 Weld Quality michelle_witte@ham.honda.com \n58 Engineering Center mike_ramsey@hna.honda.com \n59 mitch_komine@hna.honda.com \n60 Engineering Center Nick_Allen@hna.honda.com \n61 Engineering Center noah_ronneberg@hna.honda.com \n62 IT pavithra_ramamurthy@hna.honda.com \n63 pete_edwards@ega.honda.com \n64 Market Quality philip_wilson@hna.honda.com \n65 IT rajeev_chhajer@oh.hra.com \n66 rick_carlisle@ega.honda.com \n67 riley_hohman@hna.honda.com \n68 Resource Management RDaikuzono@oh.hra.com \n69 Procurement RW_Powers@hna.honda.com \n70 HR ryan_danley@hmin.honda.com \n71 Procurement ryan_smith@hna.honda.com \n72 NAAP sam_gronow@hna.honda.com \n73 New Model sarah_legatt@hna.honda.com \n74 IT sean_holshu@hna.honda.com \n75 E-Planning Scott_Carter@hna.honda.com \n76 Logistics Scott_Nourse@hna.honda.com \n77 Logistics Shawnee_Moseman@hna.honda.com \n78 IT Steve_J_Baker@ham.honda.com \n79 IT thomas_hendel@hna.honda.com \n80 New Model tom_crawford@hna.honda.com \n81 New Model Tom_Harris@hna.honda.com \n82 Purchasing traviss_alexander@hna.honda.com \n83 NA-IOO KD Export Mabe_Fujita@hna.honda.com \n84 HNA Audit brent_armstrong@hna.honda.com \n85 HR farhan_ahmed@hna.honda.com \n86 NM Edward_Malek@ham.honda.com \n87 Functional Area Email \n88 HPO adam_wilson@ham.honda.com \n89 alex_bredyuk@ega.honda.com \n90 alex_dailey@hna.honda.com \n91 Purchasing Andrew_Wendling@ham.honda.com \n92 Logistics andy_winger@hna.honda.com \n93 Market Quality Asif_Shaikh@hna.honda.com \n94 bob_voyles@hna.honda.com \n95 brad_kukula@hna.honda.com \n96 Resource Management bbodor@oh.hra.com \n97 Market Quality brian_papesh@hna.honda.com \n98 Purchasing Bryan_Speasmaker@hna.honda.com \n99 bryce_soelberg@ham.honda.com \n100 IT Carl_Sommerville@hna.honda.com \n101 casey_r_fulton@ham.honda.com \n102 ASK Network cate_whitfield@hna.honda.com \n103 Bumper Paint chelsea_nungesser@ham.honda.com \n104 HR cheri_brumbaugh@ham.honda.com \n105 MFG IT cherie_drees@ham.honda.com \n106 HPO chris_roush@ham.honda.com \n107 Procurement cody_manger@hna.honda.com \n108 HPO cortney_mcclure@ham.honda.com \n109 Dale_Malony@ham.honda.com \n110 Market Quality daniel_j_kim@hna.honda.com \n111 daniela_evans@hna.honda.com \n112 IT Danny_Carroll@hna.honda.com \n113 David_Plonski@ham.honda.com \n114 Deedat_Choudhury@ham.honda.com \n115 Derek_Davis@hna.honda.com \n116 Research Derrick_Cobb@ega.honda.com \n117 Engineering Center diego_hildebrandt@hna.honda.com \n118 dillon_brancheau@ham.honda.com \n119 doug_kremer@ham.honda.com \n120 drew_kennedy@ham.honda.com \n121 Purchasing New Model Delivery drew_paroz@ham.honda.com \n122 Eric_Roby@hna.honda.com \n123 glen_wang@hna.honda.com \n124 Logistics greg_cottrill@hna.honda.com \n125 Market Quality greta_backus@hna.honda.com \n126 Engineering Center harry_wagner@hna.honda.com \n127 IT hiroshi_hayashi@hna.honda.com \n128 jake_coloney@hna.honda.com \n129 Internal Audit james_f_brooks@hna.honda.com \n130 IT Jennifer_Bell@hma.honda.com \n131 HR Jen_Harper@hna.honda.com \n132 Infotainment JBlock@oh.hra.com \n133 E-Planning Joe_Mazzocchi@hna.honda.com \n134 NAP MRO jordan_tipton@hna.honda.com \n135 Market Quality jonathan_alvarez@hna.honda.com \n136 Market Quality jonathon_pack@hna.honda.com \n137 kazue_motoki@hna.honda.com \n138 Weld Quality kevin_girard@ham.honda.com \n139 Engineering Center Kristen_Vilt@hna.honda.com \n140 Logistics landon_small@hna.honda.com \n141 Larry_roudebush@hna.honda.com \n142 New Model lorie_austin@hna.honda.com \n143 Market Quality mark_bar@hna.honda.com \n144 HPO mayflor_markusic@ham.honda.com \n145 Weld Quality michelle_witte@ham.honda.com \n146 Engineering Center mike_ramsey@hna.honda.com \n147 mitch_komine@hna.honda.com \n148 Engineering Center Nick_Allen@hna.honda.com \n149 Engineering Center noah_ronneberg@hna.honda.com \n150 IT pavithra_ramamurthy@hna.honda.com \n151 pete_edwards@ega.honda.com \n152 Market Quality philip_wilson@hna.honda.com \n153 IT rajeev_chhajer@oh.hra.com \n154 rick_carlisle@ega.honda.com \n155 riley_hohman@hna.honda.com \n156 Resource Management RDaikuzono@oh.hra.com \n157 Procurement RW_Powers@hna.honda.com \n158 HR ryan_danley@hmin.honda.com \n159 Procurement ryan_smith@hna.honda.com \n160 NAAP sam_gronow@hna.honda.com \n161 New Model sarah_legatt@hna.honda.com \n162 IT sean_holshu@hna.honda.com \n163 E-Planning Scott_Carter@hna.honda.com \n164 Logistics Scott_Nourse@hna.honda.com \n165 Logistics Shawnee_Moseman@hna.honda.com \n166 IT Steve_J_Baker@ham.honda.com \n167 IT thomas_hendel@hna.honda.com \n168 New Model tom_crawford@hna.honda.com \n169 New Model Tom_Harris@hna.honda.com \n170 Purchasing traviss_alexander@hna.honda.com \n171 NA-IOO KD Export Mabe_Fujita@hna.honda.com \n172 HNA Audit brent_armstrong@hna.honda.com \n173 HR farhan_ahmed@hna.honda.com \n174 NM Edward_Malek@ham.honda.com \n\n Unnamed: 6 Unnamed: 7 Unnamed: 8 Unnamed: 9 ... \\\n0 NaN NaN NaN NaN ... \n1 NaN NaN NaN NaN ... \n2 NaN NaN NaN NaN ... \n3 NaN NaN NaN NaN ... \n4 NaN NaN NaN NaN ... \n5 NaN NaN NaN NaN ... \n6 NaN NaN NaN NaN ... \n7 NaN NaN NaN NaN ... \n8 NaN NaN NaN NaN ... \n9 NaN NaN NaN NaN ... \n10 NaN NaN NaN NaN ... \n11 NaN NaN NaN NaN ... \n12 NaN NaN NaN NaN ... \n13 NaN NaN NaN NaN ... \n14 NaN NaN NaN NaN ... \n15 NaN NaN NaN NaN ... \n16 NaN NaN NaN NaN ... \n17 NaN NaN NaN NaN ... \n18 NaN NaN NaN NaN ... \n19 NaN NaN NaN NaN ... \n20 NaN NaN NaN NaN ... \n21 NaN NaN NaN NaN ... \n22 NaN NaN NaN NaN ... \n23 NaN NaN NaN NaN ... \n24 NaN NaN NaN NaN ... \n25 NaN NaN NaN NaN ... \n26 NaN NaN NaN NaN ... \n27 NaN NaN NaN NaN ... \n28 NaN NaN NaN NaN ... \n29 NaN NaN NaN NaN ... \n30 NaN NaN NaN NaN ... \n31 NaN NaN NaN NaN ... \n32 NaN NaN NaN NaN ... \n33 NaN NaN NaN NaN ... \n34 NaN NaN NaN NaN ... \n35 NaN NaN NaN NaN ... \n36 NaN NaN NaN NaN ... \n37 NaN NaN NaN NaN ... \n38 NaN NaN NaN NaN ... \n39 NaN NaN NaN NaN ... \n40 NaN NaN NaN NaN ... \n41 NaN NaN NaN NaN ... \n42 NaN NaN NaN NaN ... \n43 NaN NaN NaN NaN ... \n44 NaN NaN NaN NaN ... \n45 NaN NaN NaN NaN ... \n46 NaN NaN NaN NaN ... \n47 NaN NaN NaN NaN ... \n48 NaN NaN NaN NaN ... \n49 NaN NaN NaN NaN ... \n50 NaN NaN NaN NaN ... \n51 NaN NaN NaN NaN ... \n52 NaN NaN NaN NaN ... \n53 NaN NaN NaN NaN ... \n54 NaN NaN NaN NaN ... \n55 NaN NaN NaN NaN ... \n56 NaN NaN NaN NaN ... \n57 NaN NaN NaN NaN ... \n58 NaN NaN NaN NaN ... \n59 NaN NaN NaN NaN ... \n60 NaN NaN NaN NaN ... \n61 NaN NaN NaN NaN ... \n62 NaN NaN NaN NaN ... \n63 NaN NaN NaN NaN ... \n64 NaN NaN NaN NaN ... \n65 NaN NaN NaN NaN ... \n66 NaN NaN NaN NaN ... \n67 NaN NaN NaN NaN ... \n68 NaN NaN NaN NaN ... \n69 NaN NaN NaN NaN ... \n70 NaN NaN NaN NaN ... \n71 NaN NaN NaN NaN ... \n72 NaN NaN NaN NaN ... \n73 NaN NaN NaN NaN ... \n74 NaN NaN NaN NaN ... \n75 NaN NaN NaN NaN ... \n76 NaN NaN NaN NaN ... \n77 NaN NaN NaN NaN ... \n78 NaN NaN NaN NaN ... \n79 NaN NaN NaN NaN ... \n80 NaN NaN NaN NaN ... \n81 NaN NaN NaN NaN ... \n82 NaN NaN NaN NaN ... \n83 NaN NaN NaN NaN ... \n84 NaN NaN NaN NaN ... \n85 NaN NaN NaN NaN ... \n86 NaN NaN NaN NaN ... \n87 NaN NaN NaN NaN ... \n88 NaN NaN NaN NaN ... \n89 NaN NaN NaN NaN ... \n90 NaN NaN NaN NaN ... \n91 NaN NaN NaN NaN ... \n92 NaN NaN NaN NaN ... \n93 NaN NaN NaN NaN ... \n94 NaN NaN NaN NaN ... \n95 NaN NaN NaN NaN ... \n96 NaN NaN NaN NaN ... \n97 NaN NaN NaN NaN ... \n98 NaN NaN NaN NaN ... \n99 NaN NaN NaN NaN ... \n100 NaN NaN NaN NaN ... \n101 NaN NaN NaN NaN ... \n102 NaN NaN NaN NaN ... \n103 NaN NaN NaN NaN ... \n104 NaN NaN NaN NaN ... \n105 NaN NaN NaN NaN ... \n106 NaN NaN NaN NaN ... \n107 NaN NaN NaN NaN ... \n108 NaN NaN NaN NaN ... \n109 NaN NaN NaN NaN ... \n110 NaN NaN NaN NaN ... \n111 NaN NaN NaN NaN ... \n112 NaN NaN NaN NaN ... \n113 NaN NaN NaN NaN ... \n114 NaN NaN NaN NaN ... \n115 NaN NaN NaN NaN ... \n116 NaN NaN NaN NaN ... \n117 NaN NaN NaN NaN ... \n118 NaN NaN NaN NaN ... \n119 NaN NaN NaN NaN ... \n120 NaN NaN NaN NaN ... \n121 NaN NaN NaN NaN ... \n122 NaN NaN NaN NaN ... \n123 NaN NaN NaN NaN ... \n124 NaN NaN NaN NaN ... \n125 NaN NaN NaN NaN ... \n126 NaN NaN NaN NaN ... \n127 NaN NaN NaN NaN ... \n128 NaN NaN NaN NaN ... \n129 NaN NaN NaN NaN ... \n130 NaN NaN NaN NaN ... \n131 NaN NaN NaN NaN ... \n132 NaN NaN NaN NaN ... \n133 NaN NaN NaN NaN ... \n134 NaN NaN NaN NaN ... \n135 NaN NaN NaN NaN ... \n136 NaN NaN NaN NaN ... \n137 NaN NaN NaN NaN ... \n138 NaN NaN NaN NaN ... \n139 NaN NaN NaN NaN ... \n140 NaN NaN NaN NaN ... \n141 NaN NaN NaN NaN ... \n142 NaN NaN NaN NaN ... \n143 NaN NaN NaN NaN ... \n144 NaN NaN NaN NaN ... \n145 NaN NaN NaN NaN ... \n146 NaN NaN NaN NaN ... \n147 NaN NaN NaN NaN ... \n148 NaN NaN NaN NaN ... \n149 NaN NaN NaN NaN ... \n150 NaN NaN NaN NaN ... \n151 NaN NaN NaN NaN ... \n152 NaN NaN NaN NaN ... \n153 NaN NaN NaN NaN ... \n154 NaN NaN NaN NaN ... \n155 NaN NaN NaN NaN ... \n156 NaN NaN NaN NaN ... \n157 NaN NaN NaN NaN ... \n158 NaN NaN NaN NaN ... \n159 NaN NaN NaN NaN ... \n160 NaN NaN NaN NaN ... \n161 NaN NaN NaN NaN ... \n162 NaN NaN NaN NaN ... \n163 NaN NaN NaN NaN ... \n164 NaN NaN NaN NaN ... \n165 NaN NaN NaN NaN ... \n166 NaN NaN NaN NaN ... \n167 NaN NaN NaN NaN ... \n168 NaN NaN NaN NaN ... \n169 NaN NaN NaN NaN ... \n170 NaN NaN NaN NaN ... \n171 NaN NaN NaN NaN ... \n172 NaN NaN NaN NaN ... \n173 NaN NaN NaN NaN ... \n174 NaN NaN NaN NaN ... \n\n Unnamed: 519 Unnamed: 520 Unnamed: 521 Unnamed: 522 Unnamed: 523 \\\n0 NaN NaN NaN NaN NaN \n1 NaN NaN NaN NaN NaN \n2 NaN NaN NaN NaN NaN \n3 NaN NaN NaN NaN NaN \n4 NaN NaN NaN NaN NaN \n5 NaN NaN NaN NaN NaN \n6 NaN NaN NaN NaN NaN \n7 NaN NaN NaN NaN NaN \n8 NaN NaN NaN NaN NaN \n9 NaN NaN NaN NaN NaN \n10 NaN NaN NaN NaN NaN \n11 NaN NaN NaN NaN NaN \n12 NaN NaN NaN NaN NaN \n13 NaN NaN NaN NaN NaN \n14 NaN NaN NaN NaN NaN \n15 NaN NaN NaN NaN NaN \n16 NaN NaN NaN NaN NaN \n17 NaN NaN NaN NaN NaN \n18 NaN NaN NaN NaN NaN \n19 NaN NaN NaN NaN NaN \n20 NaN NaN NaN NaN NaN \n21 NaN NaN NaN NaN NaN \n22 NaN NaN NaN NaN NaN \n23 NaN NaN NaN NaN NaN \n24 NaN NaN NaN NaN NaN \n25 NaN NaN NaN NaN NaN \n26 NaN NaN NaN NaN NaN \n27 NaN NaN NaN NaN NaN \n28 NaN NaN NaN NaN NaN \n29 NaN NaN NaN NaN NaN \n30 NaN NaN NaN NaN NaN \n31 NaN NaN NaN NaN NaN \n32 NaN NaN NaN NaN NaN \n33 NaN NaN NaN NaN NaN \n34 NaN NaN NaN NaN NaN \n35 NaN NaN NaN NaN NaN \n36 NaN NaN NaN NaN NaN \n37 NaN NaN NaN NaN NaN \n38 NaN NaN NaN NaN NaN \n39 NaN NaN NaN NaN NaN \n40 NaN NaN NaN NaN NaN \n41 NaN NaN NaN NaN NaN \n42 NaN NaN NaN NaN NaN \n43 NaN NaN NaN NaN NaN \n44 NaN NaN NaN NaN NaN \n45 NaN NaN NaN NaN NaN \n46 NaN NaN NaN NaN NaN \n47 NaN NaN NaN NaN NaN \n48 NaN NaN NaN NaN NaN \n49 NaN NaN NaN NaN NaN \n50 NaN NaN NaN NaN NaN \n51 NaN NaN NaN NaN NaN \n52 NaN NaN NaN NaN NaN \n53 NaN NaN NaN NaN NaN \n54 NaN NaN NaN NaN NaN \n55 NaN NaN NaN NaN NaN \n56 NaN NaN NaN NaN NaN \n57 NaN NaN NaN NaN NaN \n58 NaN NaN NaN NaN NaN \n59 NaN NaN NaN NaN NaN \n60 NaN NaN NaN NaN NaN \n61 NaN NaN NaN NaN NaN \n62 NaN NaN NaN NaN NaN \n63 NaN NaN NaN NaN NaN \n64 NaN NaN NaN NaN NaN \n65 NaN NaN NaN NaN NaN \n66 NaN NaN NaN NaN NaN \n67 NaN NaN NaN NaN NaN \n68 NaN NaN NaN NaN NaN \n69 NaN NaN NaN NaN NaN \n70 NaN NaN NaN NaN NaN \n71 NaN NaN NaN NaN NaN \n72 NaN NaN NaN NaN NaN \n73 NaN NaN NaN NaN NaN \n74 NaN NaN NaN NaN NaN \n75 NaN NaN NaN NaN NaN \n76 NaN NaN NaN NaN NaN \n77 NaN NaN NaN NaN NaN \n78 NaN NaN NaN NaN NaN \n79 NaN NaN NaN NaN NaN \n80 NaN NaN NaN NaN NaN \n81 NaN NaN NaN NaN NaN \n82 NaN NaN NaN NaN NaN \n83 NaN NaN NaN NaN NaN \n84 NaN NaN NaN NaN NaN \n85 NaN NaN NaN NaN NaN \n86 NaN NaN NaN NaN NaN \n87 NaN NaN NaN NaN NaN \n88 NaN NaN NaN NaN NaN \n89 NaN NaN NaN NaN NaN \n90 NaN NaN NaN NaN NaN \n91 NaN NaN NaN NaN NaN \n92 NaN NaN NaN NaN NaN \n93 NaN NaN NaN NaN NaN \n94 NaN NaN NaN NaN NaN \n95 NaN NaN NaN NaN NaN \n96 NaN NaN NaN NaN NaN \n97 NaN NaN NaN NaN NaN \n98 NaN NaN NaN NaN NaN \n99 NaN NaN NaN NaN NaN \n100 NaN NaN NaN NaN NaN \n101 NaN NaN NaN NaN NaN \n102 NaN NaN NaN NaN NaN \n103 NaN NaN NaN NaN NaN \n104 NaN NaN NaN NaN NaN \n105 NaN NaN NaN NaN NaN \n106 NaN NaN NaN NaN NaN \n107 NaN NaN NaN NaN NaN \n108 NaN NaN NaN NaN NaN \n109 NaN NaN NaN NaN NaN \n110 NaN NaN NaN NaN NaN \n111 NaN NaN NaN NaN NaN \n112 NaN NaN NaN NaN NaN \n113 NaN NaN NaN NaN NaN \n114 NaN NaN NaN NaN NaN \n115 NaN NaN NaN NaN NaN \n116 NaN NaN NaN NaN NaN \n117 NaN NaN NaN NaN NaN \n118 NaN NaN NaN NaN NaN \n119 NaN NaN NaN NaN NaN \n120 NaN NaN NaN NaN NaN \n121 NaN NaN NaN NaN NaN \n122 NaN NaN NaN NaN NaN \n123 NaN NaN NaN NaN NaN \n124 NaN NaN NaN NaN NaN \n125 NaN NaN NaN NaN NaN \n126 NaN NaN NaN NaN NaN \n127 NaN NaN NaN NaN NaN \n128 NaN NaN NaN NaN NaN \n129 NaN NaN NaN NaN NaN \n130 NaN NaN NaN NaN NaN \n131 NaN NaN NaN NaN NaN \n132 NaN NaN NaN NaN NaN \n133 NaN NaN NaN NaN NaN \n134 NaN NaN NaN NaN NaN \n135 NaN NaN NaN NaN NaN \n136 NaN NaN NaN NaN NaN \n137 NaN NaN NaN NaN NaN \n138 NaN NaN NaN NaN NaN \n139 NaN NaN NaN NaN NaN \n140 NaN NaN NaN NaN NaN \n141 NaN NaN NaN NaN NaN \n142 NaN NaN NaN NaN NaN \n143 NaN NaN NaN NaN NaN \n144 NaN NaN NaN NaN NaN \n145 NaN NaN NaN NaN NaN \n146 NaN NaN NaN NaN NaN \n147 NaN NaN NaN NaN NaN \n148 NaN NaN NaN NaN NaN \n149 NaN NaN NaN NaN NaN \n150 NaN NaN NaN NaN NaN \n151 NaN NaN NaN NaN NaN \n152 NaN NaN NaN NaN NaN \n153 NaN NaN NaN NaN NaN \n154 NaN NaN NaN NaN NaN \n155 NaN NaN NaN NaN NaN \n156 NaN NaN NaN NaN NaN \n157 NaN NaN NaN NaN NaN \n158 NaN NaN NaN NaN NaN \n159 NaN NaN NaN NaN NaN \n160 NaN NaN NaN NaN NaN \n161 NaN NaN NaN NaN NaN \n162 NaN NaN NaN NaN NaN \n163 NaN NaN NaN NaN NaN \n164 NaN NaN NaN NaN NaN \n165 NaN NaN NaN NaN NaN \n166 NaN NaN NaN NaN NaN \n167 NaN NaN NaN NaN NaN \n168 NaN NaN NaN NaN NaN \n169 NaN NaN NaN NaN NaN \n170 NaN NaN NaN NaN NaN \n171 NaN NaN NaN NaN NaN \n172 NaN NaN NaN NaN NaN \n173 NaN NaN NaN NaN NaN \n174 NaN NaN NaN NaN NaN \n\n Unnamed: 524 Unnamed: 525 Unnamed: 526 Unnamed: 527 Unnamed: 528 \n0 NaN NaN NaN NaN NaN \n1 NaN NaN NaN NaN NaN \n2 NaN NaN NaN NaN NaN \n3 NaN NaN NaN NaN NaN \n4 NaN NaN NaN NaN NaN \n5 NaN NaN NaN NaN NaN \n6 NaN NaN NaN NaN NaN \n7 NaN NaN NaN NaN NaN \n8 NaN NaN NaN NaN NaN \n9 NaN NaN NaN NaN NaN \n10 NaN NaN NaN NaN NaN \n11 NaN NaN NaN NaN NaN \n12 NaN NaN NaN NaN NaN \n13 NaN NaN NaN NaN NaN \n14 NaN NaN NaN NaN NaN \n15 NaN NaN NaN NaN NaN \n16 NaN NaN NaN NaN NaN \n17 NaN NaN NaN NaN NaN \n18 NaN NaN NaN NaN NaN \n19 NaN NaN NaN NaN NaN \n20 NaN NaN NaN NaN NaN \n21 NaN NaN NaN NaN NaN \n22 NaN NaN NaN NaN NaN \n23 NaN NaN NaN NaN NaN \n24 NaN NaN NaN NaN NaN \n25 NaN NaN NaN NaN NaN \n26 NaN NaN NaN NaN NaN \n27 NaN NaN NaN NaN NaN \n28 NaN NaN NaN NaN NaN \n29 NaN NaN NaN NaN NaN \n30 NaN NaN NaN NaN NaN \n31 NaN NaN NaN NaN NaN \n32 NaN NaN NaN NaN NaN \n33 NaN NaN NaN NaN NaN \n34 NaN NaN NaN NaN NaN \n35 NaN NaN NaN NaN NaN \n36 NaN NaN NaN NaN NaN \n37 NaN NaN NaN NaN NaN \n38 NaN NaN NaN NaN NaN \n39 NaN NaN NaN NaN NaN \n40 NaN NaN NaN NaN NaN \n41 NaN NaN NaN NaN NaN \n42 NaN NaN NaN NaN NaN \n43 NaN NaN NaN NaN NaN \n44 NaN NaN NaN NaN NaN \n45 NaN NaN NaN NaN NaN \n46 NaN NaN NaN NaN NaN \n47 NaN NaN NaN NaN NaN \n48 NaN NaN NaN NaN NaN \n49 NaN NaN NaN NaN NaN \n50 NaN NaN NaN NaN NaN \n51 NaN NaN NaN NaN NaN \n52 NaN NaN NaN NaN NaN \n53 NaN NaN NaN NaN NaN \n54 NaN NaN NaN NaN NaN \n55 NaN NaN NaN NaN NaN \n56 NaN NaN NaN NaN NaN \n57 NaN NaN NaN NaN NaN \n58 NaN NaN NaN NaN NaN \n59 NaN NaN NaN NaN NaN \n60 NaN NaN NaN NaN NaN \n61 NaN NaN NaN NaN NaN \n62 NaN NaN NaN NaN NaN \n63 NaN NaN NaN NaN NaN \n64 NaN NaN NaN NaN NaN \n65 NaN NaN NaN NaN NaN \n66 NaN NaN NaN NaN NaN \n67 NaN NaN NaN NaN NaN \n68 NaN NaN NaN NaN NaN \n69 NaN NaN NaN NaN NaN \n70 NaN NaN NaN NaN NaN \n71 NaN NaN NaN NaN NaN \n72 NaN NaN NaN NaN NaN \n73 NaN NaN NaN NaN NaN \n74 NaN NaN NaN NaN NaN \n75 NaN NaN NaN NaN NaN \n76 NaN NaN NaN NaN NaN \n77 NaN NaN NaN NaN NaN \n78 NaN NaN NaN NaN NaN \n79 NaN NaN NaN NaN NaN \n80 NaN NaN NaN NaN NaN \n81 NaN NaN NaN NaN NaN \n82 NaN NaN NaN NaN NaN \n83 NaN NaN NaN NaN NaN \n84 NaN NaN NaN NaN NaN \n85 NaN NaN NaN NaN NaN \n86 NaN NaN NaN NaN NaN \n87 NaN NaN NaN NaN NaN \n88 NaN NaN NaN NaN NaN \n89 NaN NaN NaN NaN NaN \n90 NaN NaN NaN NaN NaN \n91 NaN NaN NaN NaN NaN \n92 NaN NaN NaN NaN NaN \n93 NaN NaN NaN NaN NaN \n94 NaN NaN NaN NaN NaN \n95 NaN NaN NaN NaN NaN \n96 NaN NaN NaN NaN NaN \n97 NaN NaN NaN NaN NaN \n98 NaN NaN NaN NaN NaN \n99 NaN NaN NaN NaN NaN \n100 NaN NaN NaN NaN NaN \n101 NaN NaN NaN NaN NaN \n102 NaN NaN NaN NaN NaN \n103 NaN NaN NaN NaN NaN \n104 NaN NaN NaN NaN NaN \n105 NaN NaN NaN NaN NaN \n106 NaN NaN NaN NaN NaN \n107 NaN NaN NaN NaN NaN \n108 NaN NaN NaN NaN NaN \n109 NaN NaN NaN NaN NaN \n110 NaN NaN NaN NaN NaN \n111 NaN NaN NaN NaN NaN \n112 NaN NaN NaN NaN NaN \n113 NaN NaN NaN NaN NaN \n114 NaN NaN NaN NaN NaN \n115 NaN NaN NaN NaN NaN \n116 NaN NaN NaN NaN NaN \n117 NaN NaN NaN NaN NaN \n118 NaN NaN NaN NaN NaN \n119 NaN NaN NaN NaN NaN \n120 NaN NaN NaN NaN NaN \n121 NaN NaN NaN NaN NaN \n122 NaN NaN NaN NaN NaN \n123 NaN NaN NaN NaN NaN \n124 NaN NaN NaN NaN NaN \n125 NaN NaN NaN NaN NaN \n126 NaN NaN NaN NaN NaN \n127 NaN NaN NaN NaN NaN \n128 NaN NaN NaN NaN NaN \n129 NaN NaN NaN NaN NaN \n130 NaN NaN NaN NaN NaN \n131 NaN NaN NaN NaN NaN \n132 NaN NaN NaN NaN NaN \n133 NaN NaN NaN NaN NaN \n134 NaN NaN NaN NaN NaN \n135 NaN NaN NaN NaN NaN \n136 NaN NaN NaN NaN NaN \n137 NaN NaN NaN NaN NaN \n138 NaN NaN NaN NaN NaN \n139 NaN NaN NaN NaN NaN \n140 NaN NaN NaN NaN NaN \n141 NaN NaN NaN NaN NaN \n142 NaN NaN NaN NaN NaN \n143 NaN NaN NaN NaN NaN \n144 NaN NaN NaN NaN NaN \n145 NaN NaN NaN NaN NaN \n146 NaN NaN NaN NaN NaN \n147 NaN NaN NaN NaN NaN \n148 NaN NaN NaN NaN NaN \n149 NaN NaN NaN NaN NaN \n150 NaN NaN NaN NaN NaN \n151 NaN NaN NaN NaN NaN \n152 NaN NaN NaN NaN NaN \n153 NaN NaN NaN NaN NaN \n154 NaN NaN NaN NaN NaN \n155 NaN NaN NaN NaN NaN \n156 NaN NaN NaN NaN NaN \n157 NaN NaN NaN NaN NaN \n158 NaN NaN NaN NaN NaN \n159 NaN NaN NaN NaN NaN \n160 NaN NaN NaN NaN NaN \n161 NaN NaN NaN NaN NaN \n162 NaN NaN NaN NaN NaN \n163 NaN NaN NaN NaN NaN \n164 NaN NaN NaN NaN NaN \n165 NaN NaN NaN NaN NaN \n166 NaN NaN NaN NaN NaN \n167 NaN NaN NaN NaN NaN \n168 NaN NaN NaN NaN NaN \n169 NaN NaN NaN NaN NaN \n170 NaN NaN NaN NaN NaN \n171 NaN NaN NaN NaN NaN \n172 NaN NaN NaN NaN NaN \n173 NaN NaN NaN NaN NaN \n174 NaN NaN NaN NaN NaN \n\n[175 rows x 529 columns]" | |
}, | |
"execution_count": 79, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "tables[1]", | |
"execution_count": 77, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": "<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>Adam Wilson</th>\n <th></th>\n <th>.1</th>\n <th>HAM-O ELP</th>\n <th>HPO</th>\n <th>adam_wilson@ham.honda.com</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>Alex Bredyuk</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>alex_bredyuk@ega.honda.com</td>\n </tr>\n <tr>\n <th>1</th>\n <td>Alex Dailey</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>alex_dailey@hna.honda.com</td>\n </tr>\n <tr>\n <th>2</th>\n <td>Andrew Wendling</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td>Purchasing</td>\n <td>Andrew_Wendling@ham.honda.com</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Andy Winger</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>andy_winger@hna.honda.com</td>\n </tr>\n <tr>\n <th>4</th>\n <td>Asif Shaikh</td>\n <td></td>\n <td>BI & DW</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>Asif_Shaikh@hna.honda.com</td>\n </tr>\n <tr>\n <th>5</th>\n <td>Bob Voyles</td>\n <td></td>\n <td>SQL</td>\n <td>HNA-O NAQC</td>\n <td></td>\n <td>bob_voyles@hna.honda.com</td>\n </tr>\n <tr>\n <th>6</th>\n <td>Brad Kukula</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td></td>\n <td>brad_kukula@hna.honda.com</td>\n </tr>\n <tr>\n <th>7</th>\n <td>Brian Bodor</td>\n <td></td>\n <td>Parametric Cost Estimation</td>\n <td>HRA-O R&D</td>\n <td>Resource Management</td>\n <td>bbodor@oh.hra.com</td>\n </tr>\n <tr>\n <th>8</th>\n <td>Brian Papesh</td>\n <td></td>\n <td>Quality</td>\n <td>HNA-O QTC</td>\n <td>Market Quality</td>\n <td>brian_papesh@hna.honda.com</td>\n </tr>\n <tr>\n <th>9</th>\n <td>Bryan Speasmaker</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td>Purchasing</td>\n <td>Bryan_Speasmaker@hna.honda.com</td>\n </tr>\n <tr>\n <th>10</th>\n <td>Bryce Soelberg</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>bryce_soelberg@ham.honda.com</td>\n </tr>\n <tr>\n <th>11</th>\n <td>Carl Sommerville</td>\n <td></td>\n <td>Smart Factory</td>\n <td>HNA-O HHC</td>\n <td>IT</td>\n <td>Carl_Sommerville@hna.honda.com</td>\n </tr>\n <tr>\n <th>12</th>\n <td>Casey Fulton</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>casey_r_fulton@ham.honda.com</td>\n </tr>\n <tr>\n <th>13</th>\n <td>Cate Whitfield</td>\n <td></td>\n <td>Knowlege management</td>\n <td>HNA-O HHC</td>\n <td>ASK Network</td>\n <td>cate_whitfield@hna.honda.com</td>\n </tr>\n <tr>\n <th>14</th>\n <td>Chelsea Nungesser</td>\n <td></td>\n <td>Data analyst</td>\n <td>HAM-O ELP</td>\n <td>Bumper Paint</td>\n <td>chelsea_nungesser@ham.honda.com</td>\n </tr>\n <tr>\n <th>15</th>\n <td>Cheri Brumbaugh</td>\n <td>PR/Communications Chair</td>\n <td>Analytics</td>\n <td>HAM-O HOO</td>\n <td>HR</td>\n <td>cheri_brumbaugh@ham.honda.com</td>\n </tr>\n <tr>\n <th>16</th>\n <td>Cherie Drees</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td>MFG IT</td>\n <td>cherie_drees@ham.honda.com</td>\n </tr>\n <tr>\n <th>17</th>\n <td>Chris</td>\n <td></td>\n <td></td>\n <td>HAM-O HSO</td>\n <td>HPO</td>\n <td>chris_roush@ham.honda.com</td>\n </tr>\n <tr>\n <th>18</th>\n <td>Cody Manger</td>\n <td></td>\n <td>Capacity Management</td>\n <td>HNA-O MMC</td>\n <td>Procurement</td>\n <td>cody_manger@hna.honda.com</td>\n </tr>\n <tr>\n <th>19</th>\n <td>Cortney McClure</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>HPO</td>\n <td>cortney_mcclure@ham.honda.com</td>\n </tr>\n <tr>\n <th>20</th>\n <td>Dale Malony</td>\n <td></td>\n <td>Asset health analytics</td>\n <td>HAM-O ELP</td>\n <td></td>\n <td>Dale_Malony@ham.honda.com</td>\n </tr>\n <tr>\n <th>21</th>\n <td>Daniel Kim</td>\n <td>Technology Committee Chair</td>\n <td>Quality data analyst</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>daniel_j_kim@hna.honda.com</td>\n </tr>\n <tr>\n <th>22</th>\n <td>Daniela Evans</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td></td>\n <td>daniela_evans@hna.honda.com</td>\n </tr>\n <tr>\n <th>23</th>\n <td>Danny Carroll</td>\n <td></td>\n <td>BI & Analytics tools</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>Danny_Carroll@hna.honda.com</td>\n </tr>\n <tr>\n <th>24</th>\n <td>David Plonski</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td></td>\n <td>David_Plonski@ham.honda.com</td>\n </tr>\n <tr>\n <th>25</th>\n <td>Deedat Choudhury</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>Deedat_Choudhury@ham.honda.com</td>\n </tr>\n <tr>\n <th>26</th>\n <td>Derek Davis</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td></td>\n <td>Derek_Davis@hna.honda.com</td>\n </tr>\n <tr>\n <th>27</th>\n <td>Derrick Cobb</td>\n <td>Machine Intelligence Chair</td>\n <td>Machine Intelligence</td>\n <td>EGA-O EG</td>\n <td>Research</td>\n <td>Derrick_Cobb@ega.honda.com</td>\n </tr>\n <tr>\n <th>28</th>\n <td>Diego Hildebrandt</td>\n <td></td>\n <td>Simulation</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>diego_hildebrandt@hna.honda.com</td>\n </tr>\n <tr>\n <th>29</th>\n <td>Dillon Brancheau</td>\n <td></td>\n <td></td>\n <td>HAM-O AEP</td>\n <td></td>\n <td>dillon_brancheau@ham.honda.com</td>\n </tr>\n <tr>\n <th>30</th>\n <td>Doug Kremer</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>doug_kremer@ham.honda.com</td>\n </tr>\n <tr>\n <th>31</th>\n <td>Drew Kennedy</td>\n <td></td>\n <td></td>\n <td>HAM-O MAP</td>\n <td></td>\n <td>drew_kennedy@ham.honda.com</td>\n </tr>\n <tr>\n <th>32</th>\n <td>Drew Paroz</td>\n <td></td>\n <td>Statistical experiments, delivery</td>\n <td>HAM-O HSO</td>\n <td>Purchasing New Model Delivery</td>\n <td>drew_paroz@ham.honda.com</td>\n </tr>\n <tr>\n <th>33</th>\n <td>Eric Roby</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>Eric_Roby@hna.honda.com</td>\n </tr>\n <tr>\n <th>34</th>\n <td>Glen Wang</td>\n <td>Chair</td>\n <td>Analytics process & strategies</td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>glen_wang@hna.honda.com</td>\n </tr>\n <tr>\n <th>35</th>\n <td>Greg Cottrill</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>greg_cottrill@hna.honda.com</td>\n </tr>\n <tr>\n <th>36</th>\n <td>Greta Backus</td>\n <td></td>\n <td>Forecasting</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>greta_backus@hna.honda.com</td>\n </tr>\n <tr>\n <th>37</th>\n <td>Harry Wagner</td>\n <td></td>\n <td>Tech Fest</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>harry_wagner@hna.honda.com</td>\n </tr>\n <tr>\n <th>38</th>\n <td>Hiroshi Hayashi</td>\n <td></td>\n <td>Technologist</td>\n <td>HNA-O HHC</td>\n <td>IT</td>\n <td>hiroshi_hayashi@hna.honda.com</td>\n </tr>\n <tr>\n <th>39</th>\n <td>Jake Coloney</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td></td>\n <td>jake_coloney@hna.honda.com</td>\n </tr>\n <tr>\n <th>40</th>\n <td>James Brooks</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td>Internal Audit</td>\n <td>james_f_brooks@hna.honda.com</td>\n </tr>\n <tr>\n <th>41</th>\n <td>Jennifer Bell</td>\n <td></td>\n <td></td>\n <td>HMA</td>\n <td>IT</td>\n <td>Jennifer_Bell@hma.honda.com</td>\n </tr>\n <tr>\n <th>42</th>\n <td>Jen Harper</td>\n <td></td>\n <td>Data/process analyst</td>\n <td>HNA-O HHC</td>\n <td>HR</td>\n <td>Jen_Harper@hna.honda.com</td>\n </tr>\n <tr>\n <th>43</th>\n <td>Jeremy Block</td>\n <td></td>\n <td>Data science</td>\n <td>HRA-O R&D</td>\n <td>Infotainment</td>\n <td>JBlock@oh.hra.com</td>\n </tr>\n <tr>\n <th>44</th>\n <td>Joe Mazzocchi</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>E-Planning</td>\n <td>Joe_Mazzocchi@hna.honda.com</td>\n </tr>\n <tr>\n <th>45</th>\n <td>Jordan Tipton</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>NAP MRO</td>\n <td>jordan_tipton@hna.honda.com</td>\n </tr>\n <tr>\n <th>46</th>\n <td>Jonathan Alvarez</td>\n <td>Career Committee Chair</td>\n <td>Quality Data Analysis</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>jonathan_alvarez@hna.honda.com</td>\n </tr>\n <tr>\n <th>47</th>\n <td>Jonathon Pack</td>\n <td></td>\n <td>Quality BI</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>jonathon_pack@hna.honda.com</td>\n </tr>\n <tr>\n <th>48</th>\n <td>Kazue Motoki</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td></td>\n <td>kazue_motoki@hna.honda.com</td>\n </tr>\n <tr>\n <th>49</th>\n <td>Kevin Girard</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>Weld Quality</td>\n <td>kevin_girard@ham.honda.com</td>\n </tr>\n <tr>\n <th>50</th>\n <td>Kristen Vilt</td>\n <td></td>\n <td>Simulation</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>Kristen_Vilt@hna.honda.com</td>\n </tr>\n <tr>\n <th>51</th>\n <td>Landon Small</td>\n <td></td>\n <td>Logistics Analytics</td>\n <td>HNA-O MMC</td>\n <td>Logistics</td>\n <td>landon_small@hna.honda.com</td>\n </tr>\n <tr>\n <th>52</th>\n <td>Larry Roudebush</td>\n <td></td>\n <td></td>\n <td>HNA-O NAQC</td>\n <td></td>\n <td>Larry_roudebush@hna.honda.com</td>\n </tr>\n <tr>\n <th>53</th>\n <td>Lorie Austin</td>\n <td></td>\n <td>Spec Control</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>lorie_austin@hna.honda.com</td>\n </tr>\n <tr>\n <th>54</th>\n <td>Mark Bar</td>\n <td></td>\n <td>Forecasting</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>mark_bar@hna.honda.com</td>\n </tr>\n <tr>\n <th>55</th>\n <td>May Markusic</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>HPO</td>\n <td>mayflor_markusic@ham.honda.com</td>\n </tr>\n <tr>\n <th>56</th>\n <td>Michelle Witte</td>\n <td></td>\n <td></td>\n <td>HAM-O ELP</td>\n <td>Weld Quality</td>\n <td>michelle_witte@ham.honda.com</td>\n </tr>\n <tr>\n <th>57</th>\n <td>Mike Ramsey</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Engineering Center</td>\n <td>mike_ramsey@hna.honda.com</td>\n </tr>\n <tr>\n <th>58</th>\n <td>Mitch Komine</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td></td>\n <td>mitch_komine@hna.honda.com</td>\n </tr>\n <tr>\n <th>59</th>\n <td>Nick Allen</td>\n <td>Impact Committee Advisor</td>\n <td>Discrete Simulations</td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>Nick_Allen@hna.honda.com</td>\n </tr>\n <tr>\n <th>60</th>\n <td>Noah Ronneberg</td>\n <td></td>\n <td></td>\n <td>HNA-O HHC</td>\n <td>Engineering Center</td>\n <td>noah_ronneberg@hna.honda.com</td>\n </tr>\n <tr>\n <th>61</th>\n <td>Pavithra Ramamurthy</td>\n <td></td>\n <td>BI & Analytics tools</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>pavithra_ramamurthy@hna.honda.com</td>\n </tr>\n <tr>\n <th>62</th>\n <td>Pete Edwards</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>pete_edwards@ega.honda.com</td>\n </tr>\n <tr>\n <th>63</th>\n <td>Philip Wilson</td>\n <td>Commerce Committee Chair</td>\n <td>Quality Data Analysis</td>\n <td>HNA-O NAQC</td>\n <td>Market Quality</td>\n <td>philip_wilson@hna.honda.com</td>\n </tr>\n <tr>\n <th>64</th>\n <td>Rajeev Chhajer</td>\n <td></td>\n <td>Big data, emerging technologies, data service</td>\n <td>HRA-O R&D</td>\n <td>IT</td>\n <td>rajeev_chhajer@oh.hra.com</td>\n </tr>\n <tr>\n <th>65</th>\n <td>Rick Carlisle</td>\n <td></td>\n <td></td>\n <td>EGA-O EG</td>\n <td></td>\n <td>rick_carlisle@ega.honda.com</td>\n </tr>\n <tr>\n <th>66</th>\n <td>Riley Hohman</td>\n <td></td>\n <td></td>\n <td>HNA-O NAP</td>\n <td></td>\n <td>riley_hohman@hna.honda.com</td>\n </tr>\n <tr>\n <th>67</th>\n <td>Roy Daikuzono</td>\n <td></td>\n <td>Resource Management Analytics</td>\n <td>HRA-O R&D</td>\n <td>Resource Management</td>\n <td>RDaikuzono@oh.hra.com</td>\n </tr>\n <tr>\n <th>68</th>\n <td>RW Powers</td>\n <td></td>\n <td>Purchasing Business Analyst</td>\n <td>HNA-O NAP</td>\n <td>Procurement</td>\n <td>RW_Powers@hna.honda.com</td>\n </tr>\n <tr>\n <th>69</th>\n <td>Ryan Danley</td>\n <td></td>\n <td></td>\n <td>HMIN</td>\n <td>HR</td>\n <td>ryan_danley@hmin.honda.com</td>\n </tr>\n <tr>\n <th>70</th>\n <td>Ryan Smith</td>\n <td></td>\n <td>Supplier quality BI</td>\n <td>HNA-O MMC</td>\n <td>Procurement</td>\n <td>ryan_smith@hna.honda.com</td>\n </tr>\n <tr>\n <th>71</th>\n <td>Sam Gronow</td>\n <td></td>\n <td></td>\n <td>HNA-O R&D</td>\n <td>NAAP</td>\n <td>sam_gronow@hna.honda.com</td>\n </tr>\n <tr>\n <th>72</th>\n <td>Sarah Legatt</td>\n <td></td>\n <td>Virtual factory, fluid dynamics</td>\n <td>HNA-O R&D</td>\n <td>New Model</td>\n <td>sarah_legatt@hna.honda.com</td>\n </tr>\n <tr>\n <th>73</th>\n <td>Sean Holshu</td>\n <td></td>\n <td>Information Security Office</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>sean_holshu@hna.honda.com</td>\n </tr>\n <tr>\n <th>74</th>\n <td>Scott Carter</td>\n <td></td>\n <td>Competitive Intelligence</td>\n <td>HNA-O MMC</td>\n <td>E-Planning</td>\n <td>Scott_Carter@hna.honda.com</td>\n </tr>\n <tr>\n <th>75</th>\n <td>Scott Nourse</td>\n <td>Vice-Chair</td>\n <td>Logistics projects</td>\n <td>HNA-O MMP</td>\n <td>Logistics</td>\n <td>Scott_Nourse@hna.honda.com</td>\n </tr>\n <tr>\n <th>76</th>\n <td>Shawnee Moseman</td>\n <td></td>\n <td>Logistics Systems</td>\n <td>HNA-O MMP</td>\n <td>Logistics</td>\n <td>Shawnee_Moseman@hna.honda.com</td>\n </tr>\n <tr>\n <th>77</th>\n <td>Steve Baker</td>\n <td></td>\n <td>Machine data analytics</td>\n <td>HAM-O AEP</td>\n <td>IT</td>\n <td>Steve_J_Baker@ham.honda.com</td>\n </tr>\n <tr>\n <th>78</th>\n <td>Thomas Hendel</td>\n <td></td>\n <td>Supply Chain Systems, Business Analyst</td>\n <td>HNA-O MMC</td>\n <td>IT</td>\n <td>thomas_hendel@hna.honda.com</td>\n </tr>\n <tr>\n <th>79</th>\n <td>Tom Crawford</td>\n <td></td>\n <td>Virtual Factory/VMC</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>tom_crawford@hna.honda.com</td>\n </tr>\n <tr>\n <th>80</th>\n <td>Tom Harris</td>\n <td></td>\n <td>Spec Control applications</td>\n <td>HNA-O MMC</td>\n <td>New Model</td>\n <td>Tom_Harris@hna.honda.com</td>\n </tr>\n <tr>\n <th>81</th>\n <td>Traviss Alexander</td>\n <td></td>\n <td></td>\n <td>HNA-O MMC</td>\n <td>Purchasing</td>\n <td>traviss_alexander@hna.honda.com</td>\n </tr>\n <tr>\n <th>82</th>\n <td>Mabe Fujita</td>\n <td></td>\n <td>SQL & SCM Systems</td>\n <td>HNA-O</td>\n <td>NA-IOO KD Export</td>\n <td>Mabe_Fujita@hna.honda.com</td>\n </tr>\n <tr>\n <th>83</th>\n <td>Ronald Armstrong</td>\n <td></td>\n <td></td>\n <td>HNA-HHC</td>\n <td>HNA Audit</td>\n <td>brent_armstrong@hna.honda.com</td>\n </tr>\n <tr>\n <th>84</th>\n <td>Farhan Ahmed</td>\n <td></td>\n <td></td>\n <td>HNA-O</td>\n <td>HR</td>\n <td>farhan_ahmed@hna.honda.com</td>\n </tr>\n <tr>\n <th>85</th>\n <td>Edward Malek</td>\n <td></td>\n <td>HAM Forming-NM</td>\n <td>HAM-MAP NM</td>\n <td>NM</td>\n <td>Edward_Malek@ham.honda.com</td>\n </tr>\n </tbody>\n</table>\n</div>", | |
"text/plain": " Adam Wilson \\\n0 Alex Bredyuk \n1 Alex Dailey \n2 Andrew Wendling \n3 Andy Winger \n4 Asif Shaikh \n5 Bob Voyles \n6 Brad Kukula \n7 Brian Bodor \n8 Brian Papesh \n9 Bryan Speasmaker \n10 Bryce Soelberg \n11 Carl Sommerville \n12 Casey Fulton \n13 Cate Whitfield \n14 Chelsea Nungesser \n15 Cheri Brumbaugh PR/Communications Chair \n16 Cherie Drees \n17 Chris \n18 Cody Manger \n19 Cortney McClure \n20 Dale Malony \n21 Daniel Kim Technology Committee Chair \n22 Daniela Evans \n23 Danny Carroll \n24 David Plonski \n25 Deedat Choudhury \n26 Derek Davis \n27 Derrick Cobb Machine Intelligence Chair \n28 Diego Hildebrandt \n29 Dillon Brancheau \n30 Doug Kremer \n31 Drew Kennedy \n32 Drew Paroz \n33 Eric Roby \n34 Glen Wang Chair \n35 Greg Cottrill \n36 Greta Backus \n37 Harry Wagner \n38 Hiroshi Hayashi \n39 Jake Coloney \n40 James Brooks \n41 Jennifer Bell \n42 Jen Harper \n43 Jeremy Block \n44 Joe Mazzocchi \n45 Jordan Tipton \n46 Jonathan Alvarez Career Committee Chair \n47 Jonathon Pack \n48 Kazue Motoki \n49 Kevin Girard \n50 Kristen Vilt \n51 Landon Small \n52 Larry Roudebush \n53 Lorie Austin \n54 Mark Bar \n55 May Markusic \n56 Michelle Witte \n57 Mike Ramsey \n58 Mitch Komine \n59 Nick Allen Impact Committee Advisor \n60 Noah Ronneberg \n61 Pavithra Ramamurthy \n62 Pete Edwards \n63 Philip Wilson Commerce Committee Chair \n64 Rajeev Chhajer \n65 Rick Carlisle \n66 Riley Hohman \n67 Roy Daikuzono \n68 RW Powers \n69 Ryan Danley \n70 Ryan Smith \n71 Sam Gronow \n72 Sarah Legatt \n73 Sean Holshu \n74 Scott Carter \n75 Scott Nourse Vice-Chair \n76 Shawnee Moseman \n77 Steve Baker \n78 Thomas Hendel \n79 Tom Crawford \n80 Tom Harris \n81 Traviss Alexander \n82 Mabe Fujita \n83 Ronald Armstrong \n84 Farhan Ahmed \n85 Edward Malek \n\n .1 HAM-O ELP \\\n0 EGA-O EG \n1 HNA-O MMC \n2 HAM-O AEP \n3 HNA-O MMC \n4 BI & DW HNA-O NAQC \n5 SQL HNA-O NAQC \n6 HNA-O R&D \n7 Parametric Cost Estimation HRA-O R&D \n8 Quality HNA-O QTC \n9 HNA-O NAP \n10 HAM-O MAP \n11 Smart Factory HNA-O HHC \n12 HAM-O MAP \n13 Knowlege management HNA-O HHC \n14 Data analyst HAM-O ELP \n15 Analytics HAM-O HOO \n16 HAM-O AEP \n17 HAM-O HSO \n18 Capacity Management HNA-O MMC \n19 HAM-O ELP \n20 Asset health analytics HAM-O ELP \n21 Quality data analyst HNA-O NAQC \n22 HNA-O HHC \n23 BI & Analytics tools HNA-O MMC \n24 HAM-O AEP \n25 HAM-O MAP \n26 HNA-O NAP \n27 Machine Intelligence EGA-O EG \n28 Simulation HNA-O HHC \n29 HAM-O AEP \n30 HAM-O MAP \n31 HAM-O MAP \n32 Statistical experiments, delivery HAM-O HSO \n33 HNA-O MMC \n34 Analytics process & strategies HNA-O MMC \n35 HNA-O MMC \n36 Forecasting HNA-O NAQC \n37 Tech Fest HNA-O HHC \n38 Technologist HNA-O HHC \n39 HNA-O R&D \n40 HNA-O HHC \n41 HMA \n42 Data/process analyst HNA-O HHC \n43 Data science HRA-O R&D \n44 HNA-O MMC \n45 HNA-O MMC \n46 Quality Data Analysis HNA-O NAQC \n47 Quality BI HNA-O NAQC \n48 HNA-O MMC \n49 HAM-O ELP \n50 Simulation HNA-O HHC \n51 Logistics Analytics HNA-O MMC \n52 HNA-O NAQC \n53 Spec Control HNA-O MMC \n54 Forecasting HNA-O NAQC \n55 HAM-O ELP \n56 HAM-O ELP \n57 HNA-O MMC \n58 HNA-O HHC \n59 Discrete Simulations HNA-O HHC \n60 HNA-O HHC \n61 BI & Analytics tools HNA-O MMC \n62 EGA-O EG \n63 Quality Data Analysis HNA-O NAQC \n64 Big data, emerging technologies, data service HRA-O R&D \n65 EGA-O EG \n66 HNA-O NAP \n67 Resource Management Analytics HRA-O R&D \n68 Purchasing Business Analyst HNA-O NAP \n69 HMIN \n70 Supplier quality BI HNA-O MMC \n71 HNA-O R&D \n72 Virtual factory, fluid dynamics HNA-O R&D \n73 Information Security Office HNA-O MMC \n74 Competitive Intelligence HNA-O MMC \n75 Logistics projects HNA-O MMP \n76 Logistics Systems HNA-O MMP \n77 Machine data analytics HAM-O AEP \n78 Supply Chain Systems, Business Analyst HNA-O MMC \n79 Virtual Factory/VMC HNA-O MMC \n80 Spec Control applications HNA-O MMC \n81 HNA-O MMC \n82 SQL & SCM Systems HNA-O \n83 HNA-HHC \n84 HNA-O \n85 HAM Forming-NM HAM-MAP NM \n\n HPO adam_wilson@ham.honda.com \n0 alex_bredyuk@ega.honda.com \n1 alex_dailey@hna.honda.com \n2 Purchasing Andrew_Wendling@ham.honda.com \n3 Logistics andy_winger@hna.honda.com \n4 Market Quality Asif_Shaikh@hna.honda.com \n5 bob_voyles@hna.honda.com \n6 brad_kukula@hna.honda.com \n7 Resource Management bbodor@oh.hra.com \n8 Market Quality brian_papesh@hna.honda.com \n9 Purchasing Bryan_Speasmaker@hna.honda.com \n10 bryce_soelberg@ham.honda.com \n11 IT Carl_Sommerville@hna.honda.com \n12 casey_r_fulton@ham.honda.com \n13 ASK Network cate_whitfield@hna.honda.com \n14 Bumper Paint chelsea_nungesser@ham.honda.com \n15 HR cheri_brumbaugh@ham.honda.com \n16 MFG IT cherie_drees@ham.honda.com \n17 HPO chris_roush@ham.honda.com \n18 Procurement cody_manger@hna.honda.com \n19 HPO cortney_mcclure@ham.honda.com \n20 Dale_Malony@ham.honda.com \n21 Market Quality daniel_j_kim@hna.honda.com \n22 daniela_evans@hna.honda.com \n23 IT Danny_Carroll@hna.honda.com \n24 David_Plonski@ham.honda.com \n25 Deedat_Choudhury@ham.honda.com \n26 Derek_Davis@hna.honda.com \n27 Research Derrick_Cobb@ega.honda.com \n28 Engineering Center diego_hildebrandt@hna.honda.com \n29 dillon_brancheau@ham.honda.com \n30 doug_kremer@ham.honda.com \n31 drew_kennedy@ham.honda.com \n32 Purchasing New Model Delivery drew_paroz@ham.honda.com \n33 Eric_Roby@hna.honda.com \n34 glen_wang@hna.honda.com \n35 Logistics greg_cottrill@hna.honda.com \n36 Market Quality greta_backus@hna.honda.com \n37 Engineering Center harry_wagner@hna.honda.com \n38 IT hiroshi_hayashi@hna.honda.com \n39 jake_coloney@hna.honda.com \n40 Internal Audit james_f_brooks@hna.honda.com \n41 IT Jennifer_Bell@hma.honda.com \n42 HR Jen_Harper@hna.honda.com \n43 Infotainment JBlock@oh.hra.com \n44 E-Planning Joe_Mazzocchi@hna.honda.com \n45 NAP MRO jordan_tipton@hna.honda.com \n46 Market Quality jonathan_alvarez@hna.honda.com \n47 Market Quality jonathon_pack@hna.honda.com \n48 kazue_motoki@hna.honda.com \n49 Weld Quality kevin_girard@ham.honda.com \n50 Engineering Center Kristen_Vilt@hna.honda.com \n51 Logistics landon_small@hna.honda.com \n52 Larry_roudebush@hna.honda.com \n53 New Model lorie_austin@hna.honda.com \n54 Market Quality mark_bar@hna.honda.com \n55 HPO mayflor_markusic@ham.honda.com \n56 Weld Quality michelle_witte@ham.honda.com \n57 Engineering Center mike_ramsey@hna.honda.com \n58 mitch_komine@hna.honda.com \n59 Engineering Center Nick_Allen@hna.honda.com \n60 Engineering Center noah_ronneberg@hna.honda.com \n61 IT pavithra_ramamurthy@hna.honda.com \n62 pete_edwards@ega.honda.com \n63 Market Quality philip_wilson@hna.honda.com \n64 IT rajeev_chhajer@oh.hra.com \n65 rick_carlisle@ega.honda.com \n66 riley_hohman@hna.honda.com \n67 Resource Management RDaikuzono@oh.hra.com \n68 Procurement RW_Powers@hna.honda.com \n69 HR ryan_danley@hmin.honda.com \n70 Procurement ryan_smith@hna.honda.com \n71 NAAP sam_gronow@hna.honda.com \n72 New Model sarah_legatt@hna.honda.com \n73 IT sean_holshu@hna.honda.com \n74 E-Planning Scott_Carter@hna.honda.com \n75 Logistics Scott_Nourse@hna.honda.com \n76 Logistics Shawnee_Moseman@hna.honda.com \n77 IT Steve_J_Baker@ham.honda.com \n78 IT thomas_hendel@hna.honda.com \n79 New Model tom_crawford@hna.honda.com \n80 New Model Tom_Harris@hna.honda.com \n81 Purchasing traviss_alexander@hna.honda.com \n82 NA-IOO KD Export Mabe_Fujita@hna.honda.com \n83 HNA Audit brent_armstrong@hna.honda.com \n84 HR farhan_ahmed@hna.honda.com \n85 NM Edward_Malek@ham.honda.com " | |
}, | |
"execution_count": 77, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "# Create dataframe consisting of just name and email\nmembers_sp = tables[0][['Name', 'Email']].query(\"Name!='Name'\")\nmembers_sp", | |
"execution_count": 4, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": "<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 <th>Email</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>Adam Wilson</td>\n <td>adam_wilson@ham.honda.com</td>\n </tr>\n <tr>\n <th>1</th>\n <td>Alex Bredyuk</td>\n <td>alex_bredyuk@ega.honda.com</td>\n </tr>\n <tr>\n <th>2</th>\n <td>Alex Dailey</td>\n <td>alex_dailey@hna.honda.com</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Andrew Wendling</td>\n <td>Andrew_Wendling@ham.honda.com</td>\n </tr>\n <tr>\n <th>4</th>\n <td>Andy Winger</td>\n <td>andy_winger@hna.honda.com</td>\n </tr>\n <tr>\n <th>5</th>\n <td>Asif Shaikh</td>\n <td>Asif_Shaikh@hna.honda.com</td>\n </tr>\n <tr>\n <th>6</th>\n <td>Bob Voyles</td>\n <td>bob_voyles@hna.honda.com</td>\n </tr>\n <tr>\n <th>7</th>\n <td>Brad Kukula</td>\n <td>brad_kukula@hna.honda.com</td>\n </tr>\n <tr>\n <th>8</th>\n <td>Brian Bodor</td>\n <td>bbodor@oh.hra.com</td>\n </tr>\n <tr>\n <th>9</th>\n <td>Brian Papesh</td>\n <td>brian_papesh@hna.honda.com</td>\n </tr>\n <tr>\n <th>10</th>\n <td>Bryan Speasmaker</td>\n <td>Bryan_Speasmaker@hna.honda.com</td>\n </tr>\n <tr>\n <th>11</th>\n <td>Bryce Soelberg</td>\n <td>bryce_soelberg@ham.honda.com</td>\n </tr>\n <tr>\n <th>12</th>\n <td>Carl Sommerville</td>\n <td>Carl_Sommerville@hna.honda.com</td>\n </tr>\n <tr>\n <th>13</th>\n <td>Casey Fulton</td>\n <td>casey_r_fulton@ham.honda.com</td>\n </tr>\n <tr>\n <th>14</th>\n <td>Cate Whitfield</td>\n <td>cate_whitfield@hna.honda.com</td>\n </tr>\n <tr>\n <th>15</th>\n <td>Chelsea Nungesser</td>\n <td>chelsea_nungesser@ham.honda.com</td>\n </tr>\n <tr>\n <th>16</th>\n <td>Cheri Brumbaugh</td>\n <td>cheri_brumbaugh@ham.honda.com</td>\n </tr>\n <tr>\n <th>17</th>\n <td>Cherie Drees</td>\n <td>cherie_drees@ham.honda.com</td>\n </tr>\n <tr>\n <th>18</th>\n <td>Chris</td>\n <td>chris_roush@ham.honda.com</td>\n </tr>\n <tr>\n <th>19</th>\n <td>Cody Manger</td>\n <td>cody_manger@hna.honda.com</td>\n </tr>\n <tr>\n <th>20</th>\n <td>Cortney McClure</td>\n <td>cortney_mcclure@ham.honda.com</td>\n </tr>\n <tr>\n <th>21</th>\n <td>Dale Malony</td>\n <td>Dale_Malony@ham.honda.com</td>\n </tr>\n <tr>\n <th>22</th>\n <td>Daniel Kim</td>\n <td>daniel_j_kim@hna.honda.com</td>\n </tr>\n <tr>\n <th>23</th>\n <td>Daniela Evans</td>\n <td>daniela_evans@hna.honda.com</td>\n </tr>\n <tr>\n <th>24</th>\n <td>Danny Carroll</td>\n <td>Danny_Carroll@hna.honda.com</td>\n </tr>\n <tr>\n <th>25</th>\n <td>David Plonski</td>\n <td>David_Plonski@ham.honda.com</td>\n </tr>\n <tr>\n <th>26</th>\n <td>Deedat Choudhury</td>\n <td>Deedat_Choudhury@ham.honda.com</td>\n </tr>\n <tr>\n <th>27</th>\n <td>Derek Davis</td>\n <td>Derek_Davis@hna.honda.com</td>\n </tr>\n <tr>\n <th>28</th>\n <td>Derrick Cobb</td>\n <td>Derrick_Cobb@ega.honda.com</td>\n </tr>\n <tr>\n <th>29</th>\n <td>Diego Hildebrandt</td>\n <td>diego_hildebrandt@hna.honda.com</td>\n </tr>\n <tr>\n <th>30</th>\n <td>Dillon Brancheau</td>\n <td>dillon_brancheau@ham.honda.com</td>\n </tr>\n <tr>\n <th>31</th>\n <td>Doug Kremer</td>\n <td>doug_kremer@ham.honda.com</td>\n </tr>\n <tr>\n <th>32</th>\n <td>Drew Kennedy</td>\n <td>drew_kennedy@ham.honda.com</td>\n </tr>\n <tr>\n <th>33</th>\n <td>Drew Paroz</td>\n <td>drew_paroz@ham.honda.com</td>\n </tr>\n <tr>\n <th>34</th>\n <td>Eric Roby</td>\n <td>Eric_Roby@hna.honda.com</td>\n </tr>\n <tr>\n <th>35</th>\n <td>Glen Wang</td>\n <td>glen_wang@hna.honda.com</td>\n </tr>\n <tr>\n <th>36</th>\n <td>Greg Cottrill</td>\n <td>greg_cottrill@hna.honda.com</td>\n </tr>\n <tr>\n <th>37</th>\n <td>Greta Backus</td>\n <td>greta_backus@hna.honda.com</td>\n </tr>\n <tr>\n <th>38</th>\n <td>Harry Wagner</td>\n <td>harry_wagner@hna.honda.com</td>\n </tr>\n <tr>\n <th>39</th>\n <td>Hiroshi Hayashi</td>\n <td>hiroshi_hayashi@hna.honda.com</td>\n </tr>\n <tr>\n <th>40</th>\n <td>Jake Coloney</td>\n <td>jake_coloney@hna.honda.com</td>\n </tr>\n <tr>\n <th>41</th>\n <td>James Brooks</td>\n <td>james_f_brooks@hna.honda.com</td>\n </tr>\n <tr>\n <th>42</th>\n <td>Jennifer Bell</td>\n <td>Jennifer_Bell@hma.honda.com</td>\n </tr>\n <tr>\n <th>43</th>\n <td>Jen Harper</td>\n <td>Jen_Harper@hna.honda.com</td>\n </tr>\n <tr>\n <th>44</th>\n <td>Jeremy Block</td>\n <td>JBlock@oh.hra.com</td>\n </tr>\n <tr>\n <th>45</th>\n <td>Joe Mazzocchi</td>\n <td>Joe_Mazzocchi@hna.honda.com</td>\n </tr>\n <tr>\n <th>46</th>\n <td>Jordan Tipton</td>\n <td>jordan_tipton@hna.honda.com</td>\n </tr>\n <tr>\n <th>47</th>\n <td>Jonathan Alvarez</td>\n <td>jonathan_alvarez@hna.honda.com</td>\n </tr>\n <tr>\n <th>48</th>\n <td>Jonathon Pack</td>\n <td>jonathon_pack@hna.honda.com</td>\n </tr>\n <tr>\n <th>49</th>\n <td>Kazue Motoki</td>\n <td>kazue_motoki@hna.honda.com</td>\n </tr>\n <tr>\n <th>50</th>\n <td>Kevin Girard</td>\n <td>kevin_girard@ham.honda.com</td>\n </tr>\n <tr>\n <th>51</th>\n <td>Kristen Vilt</td>\n <td>Kristen_Vilt@hna.honda.com</td>\n </tr>\n <tr>\n <th>52</th>\n <td>Landon Small</td>\n <td>landon_small@hna.honda.com</td>\n </tr>\n <tr>\n <th>53</th>\n <td>Larry Roudebush</td>\n <td>Larry_roudebush@hna.honda.com</td>\n </tr>\n <tr>\n <th>54</th>\n <td>Lorie Austin</td>\n <td>lorie_austin@hna.honda.com</td>\n </tr>\n <tr>\n <th>55</th>\n <td>Mark Bar</td>\n <td>mark_bar@hna.honda.com</td>\n </tr>\n <tr>\n <th>56</th>\n <td>May Markusic</td>\n <td>mayflor_markusic@ham.honda.com</td>\n </tr>\n <tr>\n <th>57</th>\n <td>Michelle Witte</td>\n <td>michelle_witte@ham.honda.com</td>\n </tr>\n <tr>\n <th>58</th>\n <td>Mike Ramsey</td>\n <td>mike_ramsey@hna.honda.com</td>\n </tr>\n <tr>\n <th>59</th>\n <td>Mitch Komine</td>\n <td>mitch_komine@hna.honda.com</td>\n </tr>\n <tr>\n <th>60</th>\n <td>Nick Allen</td>\n <td>Nick_Allen@hna.honda.com</td>\n </tr>\n <tr>\n <th>61</th>\n <td>Noah Ronneberg</td>\n <td>noah_ronneberg@hna.honda.com</td>\n </tr>\n <tr>\n <th>62</th>\n <td>Pavithra Ramamurthy</td>\n <td>pavithra_ramamurthy@hna.honda.com</td>\n </tr>\n <tr>\n <th>63</th>\n <td>Pete Edwards</td>\n <td>pete_edwards@ega.honda.com</td>\n </tr>\n <tr>\n <th>64</th>\n <td>Rajeev Chhajer</td>\n <td>rajeev_chhajer@oh.hra.com</td>\n </tr>\n <tr>\n <th>65</th>\n <td>Rick Carlisle</td>\n <td>rick_carlisle@ega.honda.com</td>\n </tr>\n <tr>\n <th>66</th>\n <td>Riley Hohman</td>\n <td>riley_hohman@hna.honda.com</td>\n </tr>\n <tr>\n <th>67</th>\n <td>Roy Daikuzono</td>\n <td>RDaikuzono@oh.hra.com</td>\n </tr>\n <tr>\n <th>68</th>\n <td>RW Powers</td>\n <td>RW_Powers@hna.honda.com</td>\n </tr>\n <tr>\n <th>69</th>\n <td>Ryan Danley</td>\n <td>ryan_danley@hmin.honda.com</td>\n </tr>\n <tr>\n <th>70</th>\n <td>Ryan Smith</td>\n <td>ryan_smith@hna.honda.com</td>\n </tr>\n <tr>\n <th>71</th>\n <td>Sam Gronow</td>\n <td>sam_gronow@hna.honda.com</td>\n </tr>\n <tr>\n <th>72</th>\n <td>Sarah Legatt</td>\n <td>sarah_legatt@hna.honda.com</td>\n </tr>\n <tr>\n <th>73</th>\n <td>Sean Holshu</td>\n <td>sean_holshu@hna.honda.com</td>\n </tr>\n <tr>\n <th>74</th>\n <td>Scott Carter</td>\n <td>Scott_Carter@hna.honda.com</td>\n </tr>\n <tr>\n <th>75</th>\n <td>Scott Nourse</td>\n <td>Scott_Nourse@hna.honda.com</td>\n </tr>\n <tr>\n <th>76</th>\n <td>Shawnee Moseman</td>\n <td>Shawnee_Moseman@hna.honda.com</td>\n </tr>\n <tr>\n <th>77</th>\n <td>Steve Baker</td>\n <td>Steve_J_Baker@ham.honda.com</td>\n </tr>\n <tr>\n <th>78</th>\n <td>Thomas Hendel</td>\n <td>thomas_hendel@hna.honda.com</td>\n </tr>\n <tr>\n <th>79</th>\n <td>Tom Crawford</td>\n <td>tom_crawford@hna.honda.com</td>\n </tr>\n <tr>\n <th>80</th>\n <td>Tom Harris</td>\n <td>Tom_Harris@hna.honda.com</td>\n </tr>\n <tr>\n <th>81</th>\n <td>Traviss Alexander</td>\n <td>traviss_alexander@hna.honda.com</td>\n </tr>\n <tr>\n <th>82</th>\n <td>Mabe Fujita</td>\n <td>Mabe_Fujita@hna.honda.com</td>\n </tr>\n <tr>\n <th>83</th>\n <td>Ronald Armstrong</td>\n <td>brent_armstrong@hna.honda.com</td>\n </tr>\n <tr>\n <th>84</th>\n <td>Farhan Ahmed</td>\n <td>farhan_ahmed@hna.honda.com</td>\n </tr>\n <tr>\n <th>85</th>\n <td>Edward Malek</td>\n <td>Edward_Malek@ham.honda.com</td>\n </tr>\n <tr>\n <th>87</th>\n <td>Adam Wilson</td>\n <td>adam_wilson@ham.honda.com</td>\n </tr>\n <tr>\n <th>88</th>\n <td>Alex Bredyuk</td>\n <td>alex_bredyuk@ega.honda.com</td>\n </tr>\n <tr>\n <th>89</th>\n <td>Alex Dailey</td>\n <td>alex_dailey@hna.honda.com</td>\n </tr>\n <tr>\n <th>90</th>\n <td>Andrew Wendling</td>\n <td>Andrew_Wendling@ham.honda.com</td>\n </tr>\n <tr>\n <th>91</th>\n <td>Andy Winger</td>\n <td>andy_winger@hna.honda.com</td>\n </tr>\n <tr>\n <th>92</th>\n <td>Asif Shaikh</td>\n <td>Asif_Shaikh@hna.honda.com</td>\n </tr>\n <tr>\n <th>93</th>\n <td>Bob Voyles</td>\n <td>bob_voyles@hna.honda.com</td>\n </tr>\n <tr>\n <th>94</th>\n <td>Brad Kukula</td>\n <td>brad_kukula@hna.honda.com</td>\n </tr>\n <tr>\n <th>95</th>\n <td>Brian Bodor</td>\n <td>bbodor@oh.hra.com</td>\n </tr>\n <tr>\n <th>96</th>\n <td>Brian Papesh</td>\n <td>brian_papesh@hna.honda.com</td>\n </tr>\n <tr>\n <th>97</th>\n <td>Bryan Speasmaker</td>\n <td>Bryan_Speasmaker@hna.honda.com</td>\n </tr>\n <tr>\n <th>98</th>\n <td>Bryce Soelberg</td>\n <td>bryce_soelberg@ham.honda.com</td>\n </tr>\n <tr>\n <th>99</th>\n <td>Carl Sommerville</td>\n <td>Carl_Sommerville@hna.honda.com</td>\n </tr>\n <tr>\n <th>100</th>\n <td>Casey Fulton</td>\n <td>casey_r_fulton@ham.honda.com</td>\n </tr>\n <tr>\n <th>101</th>\n <td>Cate Whitfield</td>\n <td>cate_whitfield@hna.honda.com</td>\n </tr>\n <tr>\n <th>102</th>\n <td>Chelsea Nungesser</td>\n <td>chelsea_nungesser@ham.honda.com</td>\n </tr>\n <tr>\n <th>103</th>\n <td>Cheri Brumbaugh</td>\n <td>cheri_brumbaugh@ham.honda.com</td>\n </tr>\n <tr>\n <th>104</th>\n <td>Cherie Drees</td>\n <td>cherie_drees@ham.honda.com</td>\n </tr>\n <tr>\n <th>105</th>\n <td>Chris</td>\n <td>chris_roush@ham.honda.com</td>\n </tr>\n <tr>\n <th>106</th>\n <td>Cody Manger</td>\n <td>cody_manger@hna.honda.com</td>\n </tr>\n <tr>\n <th>107</th>\n <td>Cortney McClure</td>\n <td>cortney_mcclure@ham.honda.com</td>\n </tr>\n <tr>\n <th>108</th>\n <td>Dale Malony</td>\n <td>Dale_Malony@ham.honda.com</td>\n </tr>\n <tr>\n <th>109</th>\n <td>Daniel Kim</td>\n <td>daniel_j_kim@hna.honda.com</td>\n </tr>\n <tr>\n <th>110</th>\n <td>Daniela Evans</td>\n <td>daniela_evans@hna.honda.com</td>\n </tr>\n <tr>\n <th>111</th>\n <td>Danny Carroll</td>\n <td>Danny_Carroll@hna.honda.com</td>\n </tr>\n <tr>\n <th>112</th>\n <td>David Plonski</td>\n <td>David_Plonski@ham.honda.com</td>\n </tr>\n <tr>\n <th>113</th>\n <td>Deedat Choudhury</td>\n <td>Deedat_Choudhury@ham.honda.com</td>\n </tr>\n <tr>\n <th>114</th>\n <td>Derek Davis</td>\n <td>Derek_Davis@hna.honda.com</td>\n </tr>\n <tr>\n <th>115</th>\n <td>Derrick Cobb</td>\n <td>Derrick_Cobb@ega.honda.com</td>\n </tr>\n <tr>\n <th>116</th>\n <td>Diego Hildebrandt</td>\n <td>diego_hildebrandt@hna.honda.com</td>\n </tr>\n <tr>\n <th>117</th>\n <td>Dillon Brancheau</td>\n <td>dillon_brancheau@ham.honda.com</td>\n </tr>\n <tr>\n <th>118</th>\n <td>Doug Kremer</td>\n <td>doug_kremer@ham.honda.com</td>\n </tr>\n <tr>\n <th>119</th>\n <td>Drew Kennedy</td>\n <td>drew_kennedy@ham.honda.com</td>\n </tr>\n <tr>\n <th>120</th>\n <td>Drew Paroz</td>\n <td>drew_paroz@ham.honda.com</td>\n </tr>\n <tr>\n <th>121</th>\n <td>Eric Roby</td>\n <td>Eric_Roby@hna.honda.com</td>\n </tr>\n <tr>\n <th>122</th>\n <td>Glen Wang</td>\n <td>glen_wang@hna.honda.com</td>\n </tr>\n <tr>\n <th>123</th>\n <td>Greg Cottrill</td>\n <td>greg_cottrill@hna.honda.com</td>\n </tr>\n <tr>\n <th>124</th>\n <td>Greta Backus</td>\n <td>greta_backus@hna.honda.com</td>\n </tr>\n <tr>\n <th>125</th>\n <td>Harry Wagner</td>\n <td>harry_wagner@hna.honda.com</td>\n </tr>\n <tr>\n <th>126</th>\n <td>Hiroshi Hayashi</td>\n <td>hiroshi_hayashi@hna.honda.com</td>\n </tr>\n <tr>\n <th>127</th>\n <td>Jake Coloney</td>\n <td>jake_coloney@hna.honda.com</td>\n </tr>\n <tr>\n <th>128</th>\n <td>James Brooks</td>\n <td>james_f_brooks@hna.honda.com</td>\n </tr>\n <tr>\n <th>129</th>\n <td>Jennifer Bell</td>\n <td>Jennifer_Bell@hma.honda.com</td>\n </tr>\n <tr>\n <th>130</th>\n <td>Jen Harper</td>\n <td>Jen_Harper@hna.honda.com</td>\n </tr>\n <tr>\n <th>131</th>\n <td>Jeremy Block</td>\n <td>JBlock@oh.hra.com</td>\n </tr>\n <tr>\n <th>132</th>\n <td>Joe Mazzocchi</td>\n <td>Joe_Mazzocchi@hna.honda.com</td>\n </tr>\n <tr>\n <th>133</th>\n <td>Jordan Tipton</td>\n <td>jordan_tipton@hna.honda.com</td>\n </tr>\n <tr>\n <th>134</th>\n <td>Jonathan Alvarez</td>\n <td>jonathan_alvarez@hna.honda.com</td>\n </tr>\n <tr>\n <th>135</th>\n <td>Jonathon Pack</td>\n <td>jonathon_pack@hna.honda.com</td>\n </tr>\n <tr>\n <th>136</th>\n <td>Kazue Motoki</td>\n <td>kazue_motoki@hna.honda.com</td>\n </tr>\n <tr>\n <th>137</th>\n <td>Kevin Girard</td>\n <td>kevin_girard@ham.honda.com</td>\n </tr>\n <tr>\n <th>138</th>\n <td>Kristen Vilt</td>\n <td>Kristen_Vilt@hna.honda.com</td>\n </tr>\n <tr>\n <th>139</th>\n <td>Landon Small</td>\n <td>landon_small@hna.honda.com</td>\n </tr>\n <tr>\n <th>140</th>\n <td>Larry Roudebush</td>\n <td>Larry_roudebush@hna.honda.com</td>\n </tr>\n <tr>\n <th>141</th>\n <td>Lorie Austin</td>\n <td>lorie_austin@hna.honda.com</td>\n </tr>\n <tr>\n <th>142</th>\n <td>Mark Bar</td>\n <td>mark_bar@hna.honda.com</td>\n </tr>\n <tr>\n <th>143</th>\n <td>May Markusic</td>\n <td>mayflor_markusic@ham.honda.com</td>\n </tr>\n <tr>\n <th>144</th>\n <td>Michelle Witte</td>\n <td>michelle_witte@ham.honda.com</td>\n </tr>\n <tr>\n <th>145</th>\n <td>Mike Ramsey</td>\n <td>mike_ramsey@hna.honda.com</td>\n </tr>\n <tr>\n <th>146</th>\n <td>Mitch Komine</td>\n <td>mitch_komine@hna.honda.com</td>\n </tr>\n <tr>\n <th>147</th>\n <td>Nick Allen</td>\n <td>Nick_Allen@hna.honda.com</td>\n </tr>\n <tr>\n <th>148</th>\n <td>Noah Ronneberg</td>\n <td>noah_ronneberg@hna.honda.com</td>\n </tr>\n <tr>\n <th>149</th>\n <td>Pavithra Ramamurthy</td>\n <td>pavithra_ramamurthy@hna.honda.com</td>\n </tr>\n <tr>\n <th>150</th>\n <td>Pete Edwards</td>\n <td>pete_edwards@ega.honda.com</td>\n </tr>\n <tr>\n <th>151</th>\n <td>Rajeev Chhajer</td>\n <td>rajeev_chhajer@oh.hra.com</td>\n </tr>\n <tr>\n <th>152</th>\n <td>Rick Carlisle</td>\n <td>rick_carlisle@ega.honda.com</td>\n </tr>\n <tr>\n <th>153</th>\n <td>Riley Hohman</td>\n <td>riley_hohman@hna.honda.com</td>\n </tr>\n <tr>\n <th>154</th>\n <td>Roy Daikuzono</td>\n <td>RDaikuzono@oh.hra.com</td>\n </tr>\n <tr>\n <th>155</th>\n <td>RW Powers</td>\n <td>RW_Powers@hna.honda.com</td>\n </tr>\n <tr>\n <th>156</th>\n <td>Ryan Danley</td>\n <td>ryan_danley@hmin.honda.com</td>\n </tr>\n <tr>\n <th>157</th>\n <td>Ryan Smith</td>\n <td>ryan_smith@hna.honda.com</td>\n </tr>\n <tr>\n <th>158</th>\n <td>Sam Gronow</td>\n <td>sam_gronow@hna.honda.com</td>\n </tr>\n <tr>\n <th>159</th>\n <td>Sarah Legatt</td>\n <td>sarah_legatt@hna.honda.com</td>\n </tr>\n <tr>\n <th>160</th>\n <td>Sean Holshu</td>\n <td>sean_holshu@hna.honda.com</td>\n </tr>\n <tr>\n <th>161</th>\n <td>Scott Carter</td>\n <td>Scott_Carter@hna.honda.com</td>\n </tr>\n <tr>\n <th>162</th>\n <td>Scott Nourse</td>\n <td>Scott_Nourse@hna.honda.com</td>\n </tr>\n <tr>\n <th>163</th>\n <td>Shawnee Moseman</td>\n <td>Shawnee_Moseman@hna.honda.com</td>\n </tr>\n <tr>\n <th>164</th>\n <td>Steve Baker</td>\n <td>Steve_J_Baker@ham.honda.com</td>\n </tr>\n <tr>\n <th>165</th>\n <td>Thomas Hendel</td>\n <td>thomas_hendel@hna.honda.com</td>\n </tr>\n <tr>\n <th>166</th>\n <td>Tom Crawford</td>\n <td>tom_crawford@hna.honda.com</td>\n </tr>\n <tr>\n <th>167</th>\n <td>Tom Harris</td>\n <td>Tom_Harris@hna.honda.com</td>\n </tr>\n <tr>\n <th>168</th>\n <td>Traviss Alexander</td>\n <td>traviss_alexander@hna.honda.com</td>\n </tr>\n <tr>\n <th>169</th>\n <td>Mabe Fujita</td>\n <td>Mabe_Fujita@hna.honda.com</td>\n </tr>\n <tr>\n <th>170</th>\n <td>Ronald Armstrong</td>\n <td>brent_armstrong@hna.honda.com</td>\n </tr>\n <tr>\n <th>171</th>\n <td>Farhan Ahmed</td>\n <td>farhan_ahmed@hna.honda.com</td>\n </tr>\n <tr>\n <th>172</th>\n <td>Edward Malek</td>\n <td>Edward_Malek@ham.honda.com</td>\n </tr>\n </tbody>\n</table>\n</div>", | |
"text/plain": " Name Email\n0 Adam Wilson adam_wilson@ham.honda.com\n1 Alex Bredyuk alex_bredyuk@ega.honda.com\n2 Alex Dailey alex_dailey@hna.honda.com\n3 Andrew Wendling Andrew_Wendling@ham.honda.com\n4 Andy Winger andy_winger@hna.honda.com\n5 Asif Shaikh Asif_Shaikh@hna.honda.com\n6 Bob Voyles bob_voyles@hna.honda.com\n7 Brad Kukula brad_kukula@hna.honda.com\n8 Brian Bodor bbodor@oh.hra.com\n9 Brian Papesh brian_papesh@hna.honda.com\n10 Bryan Speasmaker Bryan_Speasmaker@hna.honda.com\n11 Bryce Soelberg bryce_soelberg@ham.honda.com\n12 Carl Sommerville Carl_Sommerville@hna.honda.com\n13 Casey Fulton casey_r_fulton@ham.honda.com\n14 Cate Whitfield cate_whitfield@hna.honda.com\n15 Chelsea Nungesser chelsea_nungesser@ham.honda.com\n16 Cheri Brumbaugh cheri_brumbaugh@ham.honda.com\n17 Cherie Drees cherie_drees@ham.honda.com\n18 Chris chris_roush@ham.honda.com\n19 Cody Manger cody_manger@hna.honda.com\n20 Cortney McClure cortney_mcclure@ham.honda.com\n21 Dale Malony Dale_Malony@ham.honda.com\n22 Daniel Kim daniel_j_kim@hna.honda.com\n23 Daniela Evans daniela_evans@hna.honda.com\n24 Danny Carroll Danny_Carroll@hna.honda.com\n25 David Plonski David_Plonski@ham.honda.com\n26 Deedat Choudhury Deedat_Choudhury@ham.honda.com\n27 Derek Davis Derek_Davis@hna.honda.com\n28 Derrick Cobb Derrick_Cobb@ega.honda.com\n29 Diego Hildebrandt diego_hildebrandt@hna.honda.com\n30 Dillon Brancheau dillon_brancheau@ham.honda.com\n31 Doug Kremer doug_kremer@ham.honda.com\n32 Drew Kennedy drew_kennedy@ham.honda.com\n33 Drew Paroz drew_paroz@ham.honda.com\n34 Eric Roby Eric_Roby@hna.honda.com\n35 Glen Wang glen_wang@hna.honda.com\n36 Greg Cottrill greg_cottrill@hna.honda.com\n37 Greta Backus greta_backus@hna.honda.com\n38 Harry Wagner harry_wagner@hna.honda.com\n39 Hiroshi Hayashi hiroshi_hayashi@hna.honda.com\n40 Jake Coloney jake_coloney@hna.honda.com\n41 James Brooks james_f_brooks@hna.honda.com\n42 Jennifer Bell Jennifer_Bell@hma.honda.com\n43 Jen Harper Jen_Harper@hna.honda.com\n44 Jeremy Block JBlock@oh.hra.com\n45 Joe Mazzocchi Joe_Mazzocchi@hna.honda.com\n46 Jordan Tipton jordan_tipton@hna.honda.com\n47 Jonathan Alvarez jonathan_alvarez@hna.honda.com\n48 Jonathon Pack jonathon_pack@hna.honda.com\n49 Kazue Motoki kazue_motoki@hna.honda.com\n50 Kevin Girard kevin_girard@ham.honda.com\n51 Kristen Vilt Kristen_Vilt@hna.honda.com\n52 Landon Small landon_small@hna.honda.com\n53 Larry Roudebush Larry_roudebush@hna.honda.com\n54 Lorie Austin lorie_austin@hna.honda.com\n55 Mark Bar mark_bar@hna.honda.com\n56 May Markusic mayflor_markusic@ham.honda.com\n57 Michelle Witte michelle_witte@ham.honda.com\n58 Mike Ramsey mike_ramsey@hna.honda.com\n59 Mitch Komine mitch_komine@hna.honda.com\n60 Nick Allen Nick_Allen@hna.honda.com\n61 Noah Ronneberg noah_ronneberg@hna.honda.com\n62 Pavithra Ramamurthy pavithra_ramamurthy@hna.honda.com\n63 Pete Edwards pete_edwards@ega.honda.com\n64 Rajeev Chhajer rajeev_chhajer@oh.hra.com\n65 Rick Carlisle rick_carlisle@ega.honda.com\n66 Riley Hohman riley_hohman@hna.honda.com\n67 Roy Daikuzono RDaikuzono@oh.hra.com\n68 RW Powers RW_Powers@hna.honda.com\n69 Ryan Danley ryan_danley@hmin.honda.com\n70 Ryan Smith ryan_smith@hna.honda.com\n71 Sam Gronow sam_gronow@hna.honda.com\n72 Sarah Legatt sarah_legatt@hna.honda.com\n73 Sean Holshu sean_holshu@hna.honda.com\n74 Scott Carter Scott_Carter@hna.honda.com\n75 Scott Nourse Scott_Nourse@hna.honda.com\n76 Shawnee Moseman Shawnee_Moseman@hna.honda.com\n77 Steve Baker Steve_J_Baker@ham.honda.com\n78 Thomas Hendel thomas_hendel@hna.honda.com\n79 Tom Crawford tom_crawford@hna.honda.com\n80 Tom Harris Tom_Harris@hna.honda.com\n81 Traviss Alexander traviss_alexander@hna.honda.com\n82 Mabe Fujita Mabe_Fujita@hna.honda.com\n83 Ronald Armstrong brent_armstrong@hna.honda.com\n84 Farhan Ahmed farhan_ahmed@hna.honda.com\n85 Edward Malek Edward_Malek@ham.honda.com\n87 Adam Wilson adam_wilson@ham.honda.com\n88 Alex Bredyuk alex_bredyuk@ega.honda.com\n89 Alex Dailey alex_dailey@hna.honda.com\n90 Andrew Wendling Andrew_Wendling@ham.honda.com\n91 Andy Winger andy_winger@hna.honda.com\n92 Asif Shaikh Asif_Shaikh@hna.honda.com\n93 Bob Voyles bob_voyles@hna.honda.com\n94 Brad Kukula brad_kukula@hna.honda.com\n95 Brian Bodor bbodor@oh.hra.com\n96 Brian Papesh brian_papesh@hna.honda.com\n97 Bryan Speasmaker Bryan_Speasmaker@hna.honda.com\n98 Bryce Soelberg bryce_soelberg@ham.honda.com\n99 Carl Sommerville Carl_Sommerville@hna.honda.com\n100 Casey Fulton casey_r_fulton@ham.honda.com\n101 Cate Whitfield cate_whitfield@hna.honda.com\n102 Chelsea Nungesser chelsea_nungesser@ham.honda.com\n103 Cheri Brumbaugh cheri_brumbaugh@ham.honda.com\n104 Cherie Drees cherie_drees@ham.honda.com\n105 Chris chris_roush@ham.honda.com\n106 Cody Manger cody_manger@hna.honda.com\n107 Cortney McClure cortney_mcclure@ham.honda.com\n108 Dale Malony Dale_Malony@ham.honda.com\n109 Daniel Kim daniel_j_kim@hna.honda.com\n110 Daniela Evans daniela_evans@hna.honda.com\n111 Danny Carroll Danny_Carroll@hna.honda.com\n112 David Plonski David_Plonski@ham.honda.com\n113 Deedat Choudhury Deedat_Choudhury@ham.honda.com\n114 Derek Davis Derek_Davis@hna.honda.com\n115 Derrick Cobb Derrick_Cobb@ega.honda.com\n116 Diego Hildebrandt diego_hildebrandt@hna.honda.com\n117 Dillon Brancheau dillon_brancheau@ham.honda.com\n118 Doug Kremer doug_kremer@ham.honda.com\n119 Drew Kennedy drew_kennedy@ham.honda.com\n120 Drew Paroz drew_paroz@ham.honda.com\n121 Eric Roby Eric_Roby@hna.honda.com\n122 Glen Wang glen_wang@hna.honda.com\n123 Greg Cottrill greg_cottrill@hna.honda.com\n124 Greta Backus greta_backus@hna.honda.com\n125 Harry Wagner harry_wagner@hna.honda.com\n126 Hiroshi Hayashi hiroshi_hayashi@hna.honda.com\n127 Jake Coloney jake_coloney@hna.honda.com\n128 James Brooks james_f_brooks@hna.honda.com\n129 Jennifer Bell Jennifer_Bell@hma.honda.com\n130 Jen Harper Jen_Harper@hna.honda.com\n131 Jeremy Block JBlock@oh.hra.com\n132 Joe Mazzocchi Joe_Mazzocchi@hna.honda.com\n133 Jordan Tipton jordan_tipton@hna.honda.com\n134 Jonathan Alvarez jonathan_alvarez@hna.honda.com\n135 Jonathon Pack jonathon_pack@hna.honda.com\n136 Kazue Motoki kazue_motoki@hna.honda.com\n137 Kevin Girard kevin_girard@ham.honda.com\n138 Kristen Vilt Kristen_Vilt@hna.honda.com\n139 Landon Small landon_small@hna.honda.com\n140 Larry Roudebush Larry_roudebush@hna.honda.com\n141 Lorie Austin lorie_austin@hna.honda.com\n142 Mark Bar mark_bar@hna.honda.com\n143 May Markusic mayflor_markusic@ham.honda.com\n144 Michelle Witte michelle_witte@ham.honda.com\n145 Mike Ramsey mike_ramsey@hna.honda.com\n146 Mitch Komine mitch_komine@hna.honda.com\n147 Nick Allen Nick_Allen@hna.honda.com\n148 Noah Ronneberg noah_ronneberg@hna.honda.com\n149 Pavithra Ramamurthy pavithra_ramamurthy@hna.honda.com\n150 Pete Edwards pete_edwards@ega.honda.com\n151 Rajeev Chhajer rajeev_chhajer@oh.hra.com\n152 Rick Carlisle rick_carlisle@ega.honda.com\n153 Riley Hohman riley_hohman@hna.honda.com\n154 Roy Daikuzono RDaikuzono@oh.hra.com\n155 RW Powers RW_Powers@hna.honda.com\n156 Ryan Danley ryan_danley@hmin.honda.com\n157 Ryan Smith ryan_smith@hna.honda.com\n158 Sam Gronow sam_gronow@hna.honda.com\n159 Sarah Legatt sarah_legatt@hna.honda.com\n160 Sean Holshu sean_holshu@hna.honda.com\n161 Scott Carter Scott_Carter@hna.honda.com\n162 Scott Nourse Scott_Nourse@hna.honda.com\n163 Shawnee Moseman Shawnee_Moseman@hna.honda.com\n164 Steve Baker Steve_J_Baker@ham.honda.com\n165 Thomas Hendel thomas_hendel@hna.honda.com\n166 Tom Crawford tom_crawford@hna.honda.com\n167 Tom Harris Tom_Harris@hna.honda.com\n168 Traviss Alexander traviss_alexander@hna.honda.com\n169 Mabe Fujita Mabe_Fujita@hna.honda.com\n170 Ronald Armstrong brent_armstrong@hna.honda.com\n171 Farhan Ahmed farhan_ahmed@hna.honda.com\n172 Edward Malek Edward_Malek@ham.honda.com" | |
}, | |
"execution_count": 4, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "members_sp.drop_duplicates(inplace=True)", | |
"execution_count": 5, | |
"outputs": [] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "members_sp", | |
"execution_count": 6, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": "<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 <th>Email</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>Adam Wilson</td>\n <td>adam_wilson@ham.honda.com</td>\n </tr>\n <tr>\n <th>1</th>\n <td>Alex Bredyuk</td>\n <td>alex_bredyuk@ega.honda.com</td>\n </tr>\n <tr>\n <th>2</th>\n <td>Alex Dailey</td>\n <td>alex_dailey@hna.honda.com</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Andrew Wendling</td>\n <td>Andrew_Wendling@ham.honda.com</td>\n </tr>\n <tr>\n <th>4</th>\n <td>Andy Winger</td>\n <td>andy_winger@hna.honda.com</td>\n </tr>\n <tr>\n <th>5</th>\n <td>Asif Shaikh</td>\n <td>Asif_Shaikh@hna.honda.com</td>\n </tr>\n <tr>\n <th>6</th>\n <td>Bob Voyles</td>\n <td>bob_voyles@hna.honda.com</td>\n </tr>\n <tr>\n <th>7</th>\n <td>Brad Kukula</td>\n <td>brad_kukula@hna.honda.com</td>\n </tr>\n <tr>\n <th>8</th>\n <td>Brian Bodor</td>\n <td>bbodor@oh.hra.com</td>\n </tr>\n <tr>\n <th>9</th>\n <td>Brian Papesh</td>\n <td>brian_papesh@hna.honda.com</td>\n </tr>\n <tr>\n <th>10</th>\n <td>Bryan Speasmaker</td>\n <td>Bryan_Speasmaker@hna.honda.com</td>\n </tr>\n <tr>\n <th>11</th>\n <td>Bryce Soelberg</td>\n <td>bryce_soelberg@ham.honda.com</td>\n </tr>\n <tr>\n <th>12</th>\n <td>Carl Sommerville</td>\n <td>Carl_Sommerville@hna.honda.com</td>\n </tr>\n <tr>\n <th>13</th>\n <td>Casey Fulton</td>\n <td>casey_r_fulton@ham.honda.com</td>\n </tr>\n <tr>\n <th>14</th>\n <td>Cate Whitfield</td>\n <td>cate_whitfield@hna.honda.com</td>\n </tr>\n <tr>\n <th>15</th>\n <td>Chelsea Nungesser</td>\n <td>chelsea_nungesser@ham.honda.com</td>\n </tr>\n <tr>\n <th>16</th>\n <td>Cheri Brumbaugh</td>\n <td>cheri_brumbaugh@ham.honda.com</td>\n </tr>\n <tr>\n <th>17</th>\n <td>Cherie Drees</td>\n <td>cherie_drees@ham.honda.com</td>\n </tr>\n <tr>\n <th>18</th>\n <td>Chris</td>\n <td>chris_roush@ham.honda.com</td>\n </tr>\n <tr>\n <th>19</th>\n <td>Cody Manger</td>\n <td>cody_manger@hna.honda.com</td>\n </tr>\n <tr>\n <th>20</th>\n <td>Cortney McClure</td>\n <td>cortney_mcclure@ham.honda.com</td>\n </tr>\n <tr>\n <th>21</th>\n <td>Dale Malony</td>\n <td>Dale_Malony@ham.honda.com</td>\n </tr>\n <tr>\n <th>22</th>\n <td>Daniel Kim</td>\n <td>daniel_j_kim@hna.honda.com</td>\n </tr>\n <tr>\n <th>23</th>\n <td>Daniela Evans</td>\n <td>daniela_evans@hna.honda.com</td>\n </tr>\n <tr>\n <th>24</th>\n <td>Danny Carroll</td>\n <td>Danny_Carroll@hna.honda.com</td>\n </tr>\n <tr>\n <th>25</th>\n <td>David Plonski</td>\n <td>David_Plonski@ham.honda.com</td>\n </tr>\n <tr>\n <th>26</th>\n <td>Deedat Choudhury</td>\n <td>Deedat_Choudhury@ham.honda.com</td>\n </tr>\n <tr>\n <th>27</th>\n <td>Derek Davis</td>\n <td>Derek_Davis@hna.honda.com</td>\n </tr>\n <tr>\n <th>28</th>\n <td>Derrick Cobb</td>\n <td>Derrick_Cobb@ega.honda.com</td>\n </tr>\n <tr>\n <th>29</th>\n <td>Diego Hildebrandt</td>\n <td>diego_hildebrandt@hna.honda.com</td>\n </tr>\n <tr>\n <th>30</th>\n <td>Dillon Brancheau</td>\n <td>dillon_brancheau@ham.honda.com</td>\n </tr>\n <tr>\n <th>31</th>\n <td>Doug Kremer</td>\n <td>doug_kremer@ham.honda.com</td>\n </tr>\n <tr>\n <th>32</th>\n <td>Drew Kennedy</td>\n <td>drew_kennedy@ham.honda.com</td>\n </tr>\n <tr>\n <th>33</th>\n <td>Drew Paroz</td>\n <td>drew_paroz@ham.honda.com</td>\n </tr>\n <tr>\n <th>34</th>\n <td>Eric Roby</td>\n <td>Eric_Roby@hna.honda.com</td>\n </tr>\n <tr>\n <th>35</th>\n <td>Glen Wang</td>\n <td>glen_wang@hna.honda.com</td>\n </tr>\n <tr>\n <th>36</th>\n <td>Greg Cottrill</td>\n <td>greg_cottrill@hna.honda.com</td>\n </tr>\n <tr>\n <th>37</th>\n <td>Greta Backus</td>\n <td>greta_backus@hna.honda.com</td>\n </tr>\n <tr>\n <th>38</th>\n <td>Harry Wagner</td>\n <td>harry_wagner@hna.honda.com</td>\n </tr>\n <tr>\n <th>39</th>\n <td>Hiroshi Hayashi</td>\n <td>hiroshi_hayashi@hna.honda.com</td>\n </tr>\n <tr>\n <th>40</th>\n <td>Jake Coloney</td>\n <td>jake_coloney@hna.honda.com</td>\n </tr>\n <tr>\n <th>41</th>\n <td>James Brooks</td>\n <td>james_f_brooks@hna.honda.com</td>\n </tr>\n <tr>\n <th>42</th>\n <td>Jennifer Bell</td>\n <td>Jennifer_Bell@hma.honda.com</td>\n </tr>\n <tr>\n <th>43</th>\n <td>Jen Harper</td>\n <td>Jen_Harper@hna.honda.com</td>\n </tr>\n <tr>\n <th>44</th>\n <td>Jeremy Block</td>\n <td>JBlock@oh.hra.com</td>\n </tr>\n <tr>\n <th>45</th>\n <td>Joe Mazzocchi</td>\n <td>Joe_Mazzocchi@hna.honda.com</td>\n </tr>\n <tr>\n <th>46</th>\n <td>Jordan Tipton</td>\n <td>jordan_tipton@hna.honda.com</td>\n </tr>\n <tr>\n <th>47</th>\n <td>Jonathan Alvarez</td>\n <td>jonathan_alvarez@hna.honda.com</td>\n </tr>\n <tr>\n <th>48</th>\n <td>Jonathon Pack</td>\n <td>jonathon_pack@hna.honda.com</td>\n </tr>\n <tr>\n <th>49</th>\n <td>Kazue Motoki</td>\n <td>kazue_motoki@hna.honda.com</td>\n </tr>\n <tr>\n <th>50</th>\n <td>Kevin Girard</td>\n <td>kevin_girard@ham.honda.com</td>\n </tr>\n <tr>\n <th>51</th>\n <td>Kristen Vilt</td>\n <td>Kristen_Vilt@hna.honda.com</td>\n </tr>\n <tr>\n <th>52</th>\n <td>Landon Small</td>\n <td>landon_small@hna.honda.com</td>\n </tr>\n <tr>\n <th>53</th>\n <td>Larry Roudebush</td>\n <td>Larry_roudebush@hna.honda.com</td>\n </tr>\n <tr>\n <th>54</th>\n <td>Lorie Austin</td>\n <td>lorie_austin@hna.honda.com</td>\n </tr>\n <tr>\n <th>55</th>\n <td>Mark Bar</td>\n <td>mark_bar@hna.honda.com</td>\n </tr>\n <tr>\n <th>56</th>\n <td>May Markusic</td>\n <td>mayflor_markusic@ham.honda.com</td>\n </tr>\n <tr>\n <th>57</th>\n <td>Michelle Witte</td>\n <td>michelle_witte@ham.honda.com</td>\n </tr>\n <tr>\n <th>58</th>\n <td>Mike Ramsey</td>\n <td>mike_ramsey@hna.honda.com</td>\n </tr>\n <tr>\n <th>59</th>\n <td>Mitch Komine</td>\n <td>mitch_komine@hna.honda.com</td>\n </tr>\n <tr>\n <th>60</th>\n <td>Nick Allen</td>\n <td>Nick_Allen@hna.honda.com</td>\n </tr>\n <tr>\n <th>61</th>\n <td>Noah Ronneberg</td>\n <td>noah_ronneberg@hna.honda.com</td>\n </tr>\n <tr>\n <th>62</th>\n <td>Pavithra Ramamurthy</td>\n <td>pavithra_ramamurthy@hna.honda.com</td>\n </tr>\n <tr>\n <th>63</th>\n <td>Pete Edwards</td>\n <td>pete_edwards@ega.honda.com</td>\n </tr>\n <tr>\n <th>64</th>\n <td>Rajeev Chhajer</td>\n <td>rajeev_chhajer@oh.hra.com</td>\n </tr>\n <tr>\n <th>65</th>\n <td>Rick Carlisle</td>\n <td>rick_carlisle@ega.honda.com</td>\n </tr>\n <tr>\n <th>66</th>\n <td>Riley Hohman</td>\n <td>riley_hohman@hna.honda.com</td>\n </tr>\n <tr>\n <th>67</th>\n <td>Roy Daikuzono</td>\n <td>RDaikuzono@oh.hra.com</td>\n </tr>\n <tr>\n <th>68</th>\n <td>RW Powers</td>\n <td>RW_Powers@hna.honda.com</td>\n </tr>\n <tr>\n <th>69</th>\n <td>Ryan Danley</td>\n <td>ryan_danley@hmin.honda.com</td>\n </tr>\n <tr>\n <th>70</th>\n <td>Ryan Smith</td>\n <td>ryan_smith@hna.honda.com</td>\n </tr>\n <tr>\n <th>71</th>\n <td>Sam Gronow</td>\n <td>sam_gronow@hna.honda.com</td>\n </tr>\n <tr>\n <th>72</th>\n <td>Sarah Legatt</td>\n <td>sarah_legatt@hna.honda.com</td>\n </tr>\n <tr>\n <th>73</th>\n <td>Sean Holshu</td>\n <td>sean_holshu@hna.honda.com</td>\n </tr>\n <tr>\n <th>74</th>\n <td>Scott Carter</td>\n <td>Scott_Carter@hna.honda.com</td>\n </tr>\n <tr>\n <th>75</th>\n <td>Scott Nourse</td>\n <td>Scott_Nourse@hna.honda.com</td>\n </tr>\n <tr>\n <th>76</th>\n <td>Shawnee Moseman</td>\n <td>Shawnee_Moseman@hna.honda.com</td>\n </tr>\n <tr>\n <th>77</th>\n <td>Steve Baker</td>\n <td>Steve_J_Baker@ham.honda.com</td>\n </tr>\n <tr>\n <th>78</th>\n <td>Thomas Hendel</td>\n <td>thomas_hendel@hna.honda.com</td>\n </tr>\n <tr>\n <th>79</th>\n <td>Tom Crawford</td>\n <td>tom_crawford@hna.honda.com</td>\n </tr>\n <tr>\n <th>80</th>\n <td>Tom Harris</td>\n <td>Tom_Harris@hna.honda.com</td>\n </tr>\n <tr>\n <th>81</th>\n <td>Traviss Alexander</td>\n <td>traviss_alexander@hna.honda.com</td>\n </tr>\n <tr>\n <th>82</th>\n <td>Mabe Fujita</td>\n <td>Mabe_Fujita@hna.honda.com</td>\n </tr>\n <tr>\n <th>83</th>\n <td>Ronald Armstrong</td>\n <td>brent_armstrong@hna.honda.com</td>\n </tr>\n <tr>\n <th>84</th>\n <td>Farhan Ahmed</td>\n <td>farhan_ahmed@hna.honda.com</td>\n </tr>\n <tr>\n <th>85</th>\n <td>Edward Malek</td>\n <td>Edward_Malek@ham.honda.com</td>\n </tr>\n </tbody>\n</table>\n</div>", | |
"text/plain": " Name Email\n0 Adam Wilson adam_wilson@ham.honda.com\n1 Alex Bredyuk alex_bredyuk@ega.honda.com\n2 Alex Dailey alex_dailey@hna.honda.com\n3 Andrew Wendling Andrew_Wendling@ham.honda.com\n4 Andy Winger andy_winger@hna.honda.com\n5 Asif Shaikh Asif_Shaikh@hna.honda.com\n6 Bob Voyles bob_voyles@hna.honda.com\n7 Brad Kukula brad_kukula@hna.honda.com\n8 Brian Bodor bbodor@oh.hra.com\n9 Brian Papesh brian_papesh@hna.honda.com\n10 Bryan Speasmaker Bryan_Speasmaker@hna.honda.com\n11 Bryce Soelberg bryce_soelberg@ham.honda.com\n12 Carl Sommerville Carl_Sommerville@hna.honda.com\n13 Casey Fulton casey_r_fulton@ham.honda.com\n14 Cate Whitfield cate_whitfield@hna.honda.com\n15 Chelsea Nungesser chelsea_nungesser@ham.honda.com\n16 Cheri Brumbaugh cheri_brumbaugh@ham.honda.com\n17 Cherie Drees cherie_drees@ham.honda.com\n18 Chris chris_roush@ham.honda.com\n19 Cody Manger cody_manger@hna.honda.com\n20 Cortney McClure cortney_mcclure@ham.honda.com\n21 Dale Malony Dale_Malony@ham.honda.com\n22 Daniel Kim daniel_j_kim@hna.honda.com\n23 Daniela Evans daniela_evans@hna.honda.com\n24 Danny Carroll Danny_Carroll@hna.honda.com\n25 David Plonski David_Plonski@ham.honda.com\n26 Deedat Choudhury Deedat_Choudhury@ham.honda.com\n27 Derek Davis Derek_Davis@hna.honda.com\n28 Derrick Cobb Derrick_Cobb@ega.honda.com\n29 Diego Hildebrandt diego_hildebrandt@hna.honda.com\n30 Dillon Brancheau dillon_brancheau@ham.honda.com\n31 Doug Kremer doug_kremer@ham.honda.com\n32 Drew Kennedy drew_kennedy@ham.honda.com\n33 Drew Paroz drew_paroz@ham.honda.com\n34 Eric Roby Eric_Roby@hna.honda.com\n35 Glen Wang glen_wang@hna.honda.com\n36 Greg Cottrill greg_cottrill@hna.honda.com\n37 Greta Backus greta_backus@hna.honda.com\n38 Harry Wagner harry_wagner@hna.honda.com\n39 Hiroshi Hayashi hiroshi_hayashi@hna.honda.com\n40 Jake Coloney jake_coloney@hna.honda.com\n41 James Brooks james_f_brooks@hna.honda.com\n42 Jennifer Bell Jennifer_Bell@hma.honda.com\n43 Jen Harper Jen_Harper@hna.honda.com\n44 Jeremy Block JBlock@oh.hra.com\n45 Joe Mazzocchi Joe_Mazzocchi@hna.honda.com\n46 Jordan Tipton jordan_tipton@hna.honda.com\n47 Jonathan Alvarez jonathan_alvarez@hna.honda.com\n48 Jonathon Pack jonathon_pack@hna.honda.com\n49 Kazue Motoki kazue_motoki@hna.honda.com\n50 Kevin Girard kevin_girard@ham.honda.com\n51 Kristen Vilt Kristen_Vilt@hna.honda.com\n52 Landon Small landon_small@hna.honda.com\n53 Larry Roudebush Larry_roudebush@hna.honda.com\n54 Lorie Austin lorie_austin@hna.honda.com\n55 Mark Bar mark_bar@hna.honda.com\n56 May Markusic mayflor_markusic@ham.honda.com\n57 Michelle Witte michelle_witte@ham.honda.com\n58 Mike Ramsey mike_ramsey@hna.honda.com\n59 Mitch Komine mitch_komine@hna.honda.com\n60 Nick Allen Nick_Allen@hna.honda.com\n61 Noah Ronneberg noah_ronneberg@hna.honda.com\n62 Pavithra Ramamurthy pavithra_ramamurthy@hna.honda.com\n63 Pete Edwards pete_edwards@ega.honda.com\n64 Rajeev Chhajer rajeev_chhajer@oh.hra.com\n65 Rick Carlisle rick_carlisle@ega.honda.com\n66 Riley Hohman riley_hohman@hna.honda.com\n67 Roy Daikuzono RDaikuzono@oh.hra.com\n68 RW Powers RW_Powers@hna.honda.com\n69 Ryan Danley ryan_danley@hmin.honda.com\n70 Ryan Smith ryan_smith@hna.honda.com\n71 Sam Gronow sam_gronow@hna.honda.com\n72 Sarah Legatt sarah_legatt@hna.honda.com\n73 Sean Holshu sean_holshu@hna.honda.com\n74 Scott Carter Scott_Carter@hna.honda.com\n75 Scott Nourse Scott_Nourse@hna.honda.com\n76 Shawnee Moseman Shawnee_Moseman@hna.honda.com\n77 Steve Baker Steve_J_Baker@ham.honda.com\n78 Thomas Hendel thomas_hendel@hna.honda.com\n79 Tom Crawford tom_crawford@hna.honda.com\n80 Tom Harris Tom_Harris@hna.honda.com\n81 Traviss Alexander traviss_alexander@hna.honda.com\n82 Mabe Fujita Mabe_Fujita@hna.honda.com\n83 Ronald Armstrong brent_armstrong@hna.honda.com\n84 Farhan Ahmed farhan_ahmed@hna.honda.com\n85 Edward Malek Edward_Malek@ham.honda.com" | |
}, | |
"execution_count": 6, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "**When entering data into the SharePoint member directory, for some reason, it inserts an \"unprintable\"/\"zero-width\" Unicode character. So need to ensure it is removed.**" | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "[name for name in members_sp['Name']][:10]", | |
"execution_count": 105, | |
"outputs": [ | |
{ | |
"data": { | |
"text/plain": "['\\u200bAdam Wilson',\n '\\u200bAlex Bredyuk',\n '\\u200bAlex Dailey',\n '\\u200bAndrew Wendling',\n '\\u200bAndy Winger',\n '\\u200bAsif Shaikh',\n '\\u200bBob Voyles',\n '\\u200bBrad Kukula',\n '\\u200bBrian Bodor',\n '\\u200bBrian Papesh']" | |
}, | |
"execution_count": 105, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "[email for email in members_sp['Email']][:10]", | |
"execution_count": 106, | |
"outputs": [ | |
{ | |
"data": { | |
"text/plain": "['\\u200badam_wilson@ham.honda.com',\n '\\u200balex_bredyuk@ega.honda.com',\n '\\u200balex_dailey@hna.honda.com',\n 'Andrew_Wendling@ham.honda.com',\n '\\u200bandy_winger@hna.honda.com',\n '\\u200bAsif_Shaikh@hna.honda.com',\n '\\u200bbob_voyles@hna.honda.com',\n '\\u200bbrad_kukula@hna.honda.com',\n '\\u200bbbodor@oh.hra.com',\n '\\u200bbrian_papesh@hna.honda.com']" | |
}, | |
"execution_count": 106, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "members_sp = members_sp.assign(Name = members_sp['Name'].str.replace(u'\\u200b', ''))", | |
"execution_count": 107, | |
"outputs": [] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "[name for name in members_sp['Name']][:10]", | |
"execution_count": 108, | |
"outputs": [ | |
{ | |
"data": { | |
"text/plain": "['Adam Wilson',\n 'Alex Bredyuk',\n 'Alex Dailey',\n 'Andrew Wendling',\n 'Andy Winger',\n 'Asif Shaikh',\n 'Bob Voyles',\n 'Brad Kukula',\n 'Brian Bodor',\n 'Brian Papesh']" | |
}, | |
"execution_count": 108, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "members_sp = members_sp.assign(Email = members_sp['Email'].str.replace(u'\\u200b', '').str.lower())", | |
"execution_count": 109, | |
"outputs": [] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "[email for email in members_sp['Email']][-10:]", | |
"execution_count": 110, | |
"outputs": [ | |
{ | |
"data": { | |
"text/plain": "['shawnee_moseman@hna.honda.com',\n 'steve_j_baker@ham.honda.com',\n 'thomas_hendel@hna.honda.com',\n 'tom_crawford@hna.honda.com',\n 'tom_harris@hna.honda.com',\n 'traviss_alexander@hna.honda.com',\n 'mabe_fujita@hna.honda.com',\n 'brent_armstrong@hna.honda.com',\n 'farhan_ahmed@hna.honda.com',\n 'edward_malek@ham.honda.com']" | |
}, | |
"execution_count": 110, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "**As seen above, the SharePoint member list can allow or more blank rows at the bottom of the list for some reason. So need to ensure we remove any empty rows.**" | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "# Drop any rows with missing Email or if Email is an empty space.\n# Unfortunately, the SharePoint member directory does not validate the manual entry of associate's information\nmembers_sp = members_sp.dropna(subset=['Email'], how='any').query(\"not Email == ''\")", | |
"execution_count": 111, | |
"outputs": [] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "members_sp", | |
"execution_count": 112, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": "<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 <th>Email</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>Adam Wilson</td>\n <td>adam_wilson@ham.honda.com</td>\n </tr>\n <tr>\n <th>1</th>\n <td>Alex Bredyuk</td>\n <td>alex_bredyuk@ega.honda.com</td>\n </tr>\n <tr>\n <th>2</th>\n <td>Alex Dailey</td>\n <td>alex_dailey@hna.honda.com</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Andrew Wendling</td>\n <td>andrew_wendling@ham.honda.com</td>\n </tr>\n <tr>\n <th>4</th>\n <td>Andy Winger</td>\n <td>andy_winger@hna.honda.com</td>\n </tr>\n <tr>\n <th>5</th>\n <td>Asif Shaikh</td>\n <td>asif_shaikh@hna.honda.com</td>\n </tr>\n <tr>\n <th>6</th>\n <td>Bob Voyles</td>\n <td>bob_voyles@hna.honda.com</td>\n </tr>\n <tr>\n <th>7</th>\n <td>Brad Kukula</td>\n <td>brad_kukula@hna.honda.com</td>\n </tr>\n <tr>\n <th>8</th>\n <td>Brian Bodor</td>\n <td>bbodor@oh.hra.com</td>\n </tr>\n <tr>\n <th>9</th>\n <td>Brian Papesh</td>\n <td>brian_papesh@hna.honda.com</td>\n </tr>\n <tr>\n <th>10</th>\n <td>Bryan Speasmaker</td>\n <td>bryan_speasmaker@hna.honda.com</td>\n </tr>\n <tr>\n <th>11</th>\n <td>Bryce Soelberg</td>\n <td>bryce_soelberg@ham.honda.com</td>\n </tr>\n <tr>\n <th>12</th>\n <td>Carl Sommerville</td>\n <td>carl_sommerville@hna.honda.com</td>\n </tr>\n <tr>\n <th>13</th>\n <td>Casey Fulton</td>\n <td>casey_r_fulton@ham.honda.com</td>\n </tr>\n <tr>\n <th>14</th>\n <td>Cate Whitfield</td>\n <td>cate_whitfield@hna.honda.com</td>\n </tr>\n <tr>\n <th>15</th>\n <td>Chelsea Nungesser</td>\n <td>chelsea_nungesser@ham.honda.com</td>\n </tr>\n <tr>\n <th>16</th>\n <td>Cheri Brumbaugh</td>\n <td>cheri_brumbaugh@ham.honda.com</td>\n </tr>\n <tr>\n <th>17</th>\n <td>Cherie Drees</td>\n <td>cherie_drees@ham.honda.com</td>\n </tr>\n <tr>\n <th>18</th>\n <td>Chris</td>\n <td>chris_roush@ham.honda.com</td>\n </tr>\n <tr>\n <th>19</th>\n <td>Cody Manger</td>\n <td>cody_manger@hna.honda.com</td>\n </tr>\n <tr>\n <th>20</th>\n <td>Cortney McClure</td>\n <td>cortney_mcclure@ham.honda.com</td>\n </tr>\n <tr>\n <th>21</th>\n <td>Dale Malony</td>\n <td>dale_malony@ham.honda.com</td>\n </tr>\n <tr>\n <th>22</th>\n <td>Daniel Kim</td>\n <td>daniel_j_kim@hna.honda.com</td>\n </tr>\n <tr>\n <th>23</th>\n <td>Daniela Evans</td>\n <td>daniela_evans@hna.honda.com</td>\n </tr>\n <tr>\n <th>24</th>\n <td>Danny Carroll</td>\n <td>danny_carroll@hna.honda.com</td>\n </tr>\n <tr>\n <th>25</th>\n <td>David Plonski</td>\n <td>david_plonski@ham.honda.com</td>\n </tr>\n <tr>\n <th>26</th>\n <td>Deedat Choudhury</td>\n <td>deedat_choudhury@ham.honda.com</td>\n </tr>\n <tr>\n <th>27</th>\n <td>Derek Davis</td>\n <td>derek_davis@hna.honda.com</td>\n </tr>\n <tr>\n <th>28</th>\n <td>Derrick Cobb</td>\n <td>derrick_cobb@ega.honda.com</td>\n </tr>\n <tr>\n <th>29</th>\n <td>Diego Hildebrandt</td>\n <td>diego_hildebrandt@hna.honda.com</td>\n </tr>\n <tr>\n <th>30</th>\n <td>Dillon Brancheau</td>\n <td>dillon_brancheau@ham.honda.com</td>\n </tr>\n <tr>\n <th>31</th>\n <td>Doug Kremer</td>\n <td>doug_kremer@ham.honda.com</td>\n </tr>\n <tr>\n <th>32</th>\n <td>Drew Kennedy</td>\n <td>drew_kennedy@ham.honda.com</td>\n </tr>\n <tr>\n <th>33</th>\n <td>Drew Paroz</td>\n <td>drew_paroz@ham.honda.com</td>\n </tr>\n <tr>\n <th>34</th>\n <td>Eric Roby</td>\n <td>eric_roby@hna.honda.com</td>\n </tr>\n <tr>\n <th>35</th>\n <td>Glen Wang</td>\n <td>glen_wang@hna.honda.com</td>\n </tr>\n <tr>\n <th>36</th>\n <td>Greg Cottrill</td>\n <td>greg_cottrill@hna.honda.com</td>\n </tr>\n <tr>\n <th>37</th>\n <td>Greta Backus</td>\n <td>greta_backus@hna.honda.com</td>\n </tr>\n <tr>\n <th>38</th>\n <td>Harry Wagner</td>\n <td>harry_wagner@hna.honda.com</td>\n </tr>\n <tr>\n <th>39</th>\n <td>Hiroshi Hayashi</td>\n <td>hiroshi_hayashi@hna.honda.com</td>\n </tr>\n <tr>\n <th>40</th>\n <td>Jake Coloney</td>\n <td>jake_coloney@hna.honda.com</td>\n </tr>\n <tr>\n <th>41</th>\n <td>James Brooks</td>\n <td>james_f_brooks@hna.honda.com</td>\n </tr>\n <tr>\n <th>42</th>\n <td>Jennifer Bell</td>\n <td>jennifer_bell@hma.honda.com</td>\n </tr>\n <tr>\n <th>43</th>\n <td>Jen Harper</td>\n <td>jen_harper@hna.honda.com</td>\n </tr>\n <tr>\n <th>44</th>\n <td>Jeremy Block</td>\n <td>jblock@oh.hra.com</td>\n </tr>\n <tr>\n <th>45</th>\n <td>Joe Mazzocchi</td>\n <td>joe_mazzocchi@hna.honda.com</td>\n </tr>\n <tr>\n <th>46</th>\n <td>Jordan Tipton</td>\n <td>jordan_tipton@hna.honda.com</td>\n </tr>\n <tr>\n <th>47</th>\n <td>Jonathan Alvarez</td>\n <td>jonathan_alvarez@hna.honda.com</td>\n </tr>\n <tr>\n <th>48</th>\n <td>Jonathon Pack</td>\n <td>jonathon_pack@hna.honda.com</td>\n </tr>\n <tr>\n <th>49</th>\n <td>Kazue Motoki</td>\n <td>kazue_motoki@hna.honda.com</td>\n </tr>\n <tr>\n <th>50</th>\n <td>Kevin Girard</td>\n <td>kevin_girard@ham.honda.com</td>\n </tr>\n <tr>\n <th>51</th>\n <td>Kristen Vilt</td>\n <td>kristen_vilt@hna.honda.com</td>\n </tr>\n <tr>\n <th>52</th>\n <td>Landon Small</td>\n <td>landon_small@hna.honda.com</td>\n </tr>\n <tr>\n <th>53</th>\n <td>Larry Roudebush</td>\n <td>larry_roudebush@hna.honda.com</td>\n </tr>\n <tr>\n <th>54</th>\n <td>Lorie Austin</td>\n <td>lorie_austin@hna.honda.com</td>\n </tr>\n <tr>\n <th>55</th>\n <td>Mark Bar</td>\n <td>mark_bar@hna.honda.com</td>\n </tr>\n <tr>\n <th>56</th>\n <td>May Markusic</td>\n <td>mayflor_markusic@ham.honda.com</td>\n </tr>\n <tr>\n <th>57</th>\n <td>Michelle Witte</td>\n <td>michelle_witte@ham.honda.com</td>\n </tr>\n <tr>\n <th>58</th>\n <td>Mike Ramsey</td>\n <td>mike_ramsey@hna.honda.com</td>\n </tr>\n <tr>\n <th>59</th>\n <td>Mitch Komine</td>\n <td>mitch_komine@hna.honda.com</td>\n </tr>\n <tr>\n <th>60</th>\n <td>Nick Allen</td>\n <td>nick_allen@hna.honda.com</td>\n </tr>\n <tr>\n <th>61</th>\n <td>Noah Ronneberg</td>\n <td>noah_ronneberg@hna.honda.com</td>\n </tr>\n <tr>\n <th>62</th>\n <td>Pavithra Ramamurthy</td>\n <td>pavithra_ramamurthy@hna.honda.com</td>\n </tr>\n <tr>\n <th>63</th>\n <td>Pete Edwards</td>\n <td>pete_edwards@ega.honda.com</td>\n </tr>\n <tr>\n <th>64</th>\n <td>Philip Wilson</td>\n <td>philip_wilson@hna.honda.com</td>\n </tr>\n <tr>\n <th>65</th>\n <td>Rajeev Chhajer</td>\n <td>rajeev_chhajer@oh.hra.com</td>\n </tr>\n <tr>\n <th>66</th>\n <td>Rick Carlisle</td>\n <td>rick_carlisle@ega.honda.com</td>\n </tr>\n <tr>\n <th>67</th>\n <td>Riley Hohman</td>\n <td>riley_hohman@hna.honda.com</td>\n </tr>\n <tr>\n <th>68</th>\n <td>Roy Daikuzono</td>\n <td>rdaikuzono@oh.hra.com</td>\n </tr>\n <tr>\n <th>69</th>\n <td>RW Powers</td>\n <td>rw_powers@hna.honda.com</td>\n </tr>\n <tr>\n <th>70</th>\n <td>Ryan Danley</td>\n <td>ryan_danley@hmin.honda.com</td>\n </tr>\n <tr>\n <th>71</th>\n <td>Ryan Smith</td>\n <td>ryan_smith@hna.honda.com</td>\n </tr>\n <tr>\n <th>72</th>\n <td>Sam Gronow</td>\n <td>sam_gronow@hna.honda.com</td>\n </tr>\n <tr>\n <th>73</th>\n <td>Sarah Legatt</td>\n <td>sarah_legatt@hna.honda.com</td>\n </tr>\n <tr>\n <th>74</th>\n <td>Sean Holshu</td>\n <td>sean_holshu@hna.honda.com</td>\n </tr>\n <tr>\n <th>75</th>\n <td>Scott Carter</td>\n <td>scott_carter@hna.honda.com</td>\n </tr>\n <tr>\n <th>76</th>\n <td>Scott Nourse</td>\n <td>scott_nourse@hna.honda.com</td>\n </tr>\n <tr>\n <th>77</th>\n <td>Shawnee Moseman</td>\n <td>shawnee_moseman@hna.honda.com</td>\n </tr>\n <tr>\n <th>78</th>\n <td>Steve Baker</td>\n <td>steve_j_baker@ham.honda.com</td>\n </tr>\n <tr>\n <th>79</th>\n <td>Thomas Hendel</td>\n <td>thomas_hendel@hna.honda.com</td>\n </tr>\n <tr>\n <th>80</th>\n <td>Tom Crawford</td>\n <td>tom_crawford@hna.honda.com</td>\n </tr>\n <tr>\n <th>81</th>\n <td>Tom Harris</td>\n <td>tom_harris@hna.honda.com</td>\n </tr>\n <tr>\n <th>82</th>\n <td>Traviss Alexander</td>\n <td>traviss_alexander@hna.honda.com</td>\n </tr>\n <tr>\n <th>83</th>\n <td>Mabe Fujita</td>\n <td>mabe_fujita@hna.honda.com</td>\n </tr>\n <tr>\n <th>84</th>\n <td>Ronald Armstrong</td>\n <td>brent_armstrong@hna.honda.com</td>\n </tr>\n <tr>\n <th>85</th>\n <td>Farhan Ahmed</td>\n <td>farhan_ahmed@hna.honda.com</td>\n </tr>\n <tr>\n <th>86</th>\n <td>Edward Malek</td>\n <td>edward_malek@ham.honda.com</td>\n </tr>\n </tbody>\n</table>\n</div>", | |
"text/plain": " Name Email\n0 Adam Wilson adam_wilson@ham.honda.com\n1 Alex Bredyuk alex_bredyuk@ega.honda.com\n2 Alex Dailey alex_dailey@hna.honda.com\n3 Andrew Wendling andrew_wendling@ham.honda.com\n4 Andy Winger andy_winger@hna.honda.com\n5 Asif Shaikh asif_shaikh@hna.honda.com\n6 Bob Voyles bob_voyles@hna.honda.com\n7 Brad Kukula brad_kukula@hna.honda.com\n8 Brian Bodor bbodor@oh.hra.com\n9 Brian Papesh brian_papesh@hna.honda.com\n10 Bryan Speasmaker bryan_speasmaker@hna.honda.com\n11 Bryce Soelberg bryce_soelberg@ham.honda.com\n12 Carl Sommerville carl_sommerville@hna.honda.com\n13 Casey Fulton casey_r_fulton@ham.honda.com\n14 Cate Whitfield cate_whitfield@hna.honda.com\n15 Chelsea Nungesser chelsea_nungesser@ham.honda.com\n16 Cheri Brumbaugh cheri_brumbaugh@ham.honda.com\n17 Cherie Drees cherie_drees@ham.honda.com\n18 Chris chris_roush@ham.honda.com\n19 Cody Manger cody_manger@hna.honda.com\n20 Cortney McClure cortney_mcclure@ham.honda.com\n21 Dale Malony dale_malony@ham.honda.com\n22 Daniel Kim daniel_j_kim@hna.honda.com\n23 Daniela Evans daniela_evans@hna.honda.com\n24 Danny Carroll danny_carroll@hna.honda.com\n25 David Plonski david_plonski@ham.honda.com\n26 Deedat Choudhury deedat_choudhury@ham.honda.com\n27 Derek Davis derek_davis@hna.honda.com\n28 Derrick Cobb derrick_cobb@ega.honda.com\n29 Diego Hildebrandt diego_hildebrandt@hna.honda.com\n30 Dillon Brancheau dillon_brancheau@ham.honda.com\n31 Doug Kremer doug_kremer@ham.honda.com\n32 Drew Kennedy drew_kennedy@ham.honda.com\n33 Drew Paroz drew_paroz@ham.honda.com\n34 Eric Roby eric_roby@hna.honda.com\n35 Glen Wang glen_wang@hna.honda.com\n36 Greg Cottrill greg_cottrill@hna.honda.com\n37 Greta Backus greta_backus@hna.honda.com\n38 Harry Wagner harry_wagner@hna.honda.com\n39 Hiroshi Hayashi hiroshi_hayashi@hna.honda.com\n40 Jake Coloney jake_coloney@hna.honda.com\n41 James Brooks james_f_brooks@hna.honda.com\n42 Jennifer Bell jennifer_bell@hma.honda.com\n43 Jen Harper jen_harper@hna.honda.com\n44 Jeremy Block jblock@oh.hra.com\n45 Joe Mazzocchi joe_mazzocchi@hna.honda.com\n46 Jordan Tipton jordan_tipton@hna.honda.com\n47 Jonathan Alvarez jonathan_alvarez@hna.honda.com\n48 Jonathon Pack jonathon_pack@hna.honda.com\n49 Kazue Motoki kazue_motoki@hna.honda.com\n50 Kevin Girard kevin_girard@ham.honda.com\n51 Kristen Vilt kristen_vilt@hna.honda.com\n52 Landon Small landon_small@hna.honda.com\n53 Larry Roudebush larry_roudebush@hna.honda.com\n54 Lorie Austin lorie_austin@hna.honda.com\n55 Mark Bar mark_bar@hna.honda.com\n56 May Markusic mayflor_markusic@ham.honda.com\n57 Michelle Witte michelle_witte@ham.honda.com\n58 Mike Ramsey mike_ramsey@hna.honda.com\n59 Mitch Komine mitch_komine@hna.honda.com\n60 Nick Allen nick_allen@hna.honda.com\n61 Noah Ronneberg noah_ronneberg@hna.honda.com\n62 Pavithra Ramamurthy pavithra_ramamurthy@hna.honda.com\n63 Pete Edwards pete_edwards@ega.honda.com\n64 Philip Wilson philip_wilson@hna.honda.com\n65 Rajeev Chhajer rajeev_chhajer@oh.hra.com\n66 Rick Carlisle rick_carlisle@ega.honda.com\n67 Riley Hohman riley_hohman@hna.honda.com\n68 Roy Daikuzono rdaikuzono@oh.hra.com\n69 RW Powers rw_powers@hna.honda.com\n70 Ryan Danley ryan_danley@hmin.honda.com\n71 Ryan Smith ryan_smith@hna.honda.com\n72 Sam Gronow sam_gronow@hna.honda.com\n73 Sarah Legatt sarah_legatt@hna.honda.com\n74 Sean Holshu sean_holshu@hna.honda.com\n75 Scott Carter scott_carter@hna.honda.com\n76 Scott Nourse scott_nourse@hna.honda.com\n77 Shawnee Moseman shawnee_moseman@hna.honda.com\n78 Steve Baker steve_j_baker@ham.honda.com\n79 Thomas Hendel thomas_hendel@hna.honda.com\n80 Tom Crawford tom_crawford@hna.honda.com\n81 Tom Harris tom_harris@hna.honda.com\n82 Traviss Alexander traviss_alexander@hna.honda.com\n83 Mabe Fujita mabe_fujita@hna.honda.com\n84 Ronald Armstrong brent_armstrong@hna.honda.com\n85 Farhan Ahmed farhan_ahmed@hna.honda.com\n86 Edward Malek edward_malek@ham.honda.com" | |
}, | |
"execution_count": 112, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "**Finally, the SharePoint member list is cleaned up, no missing rows or funky characters! Next we can match this list up with the data in the sqlite database.**" | |
}, | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "### Generate members table from database:" | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "conn = sqlite3.connect(r'\\\\hondateamlink.ham.am.honda.com\\hna\\sites\\Brain\\Shared Documents\\sqlite\\brg.db')\n\nsql = \"\"\"\nSELECT\n Name,\n lower(Email) as Email\n\nFROM\n members\n\nWHERE\n Member = 'X'\n \nORDER BY\nName\n\"\"\"\n\nmembers_sqlite = pd.read_sql_query(sql, conn).iloc[:, 0:4]\nconn.close()", | |
"execution_count": 113, | |
"outputs": [] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "members_sqlite", | |
"execution_count": 114, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": "<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 <th>Email</th>\n </tr>\n </thead>\n <tbody>\n <tr>\n <th>0</th>\n <td>Adam Wilson</td>\n <td>adam_wilson@ham.honda.com</td>\n </tr>\n <tr>\n <th>1</th>\n <td>Alex Bredyuk</td>\n <td>alex_bredyuk@ega.honda.com</td>\n </tr>\n <tr>\n <th>2</th>\n <td>Alex Dailey</td>\n <td>alex_dailey@hna.honda.com</td>\n </tr>\n <tr>\n <th>3</th>\n <td>Andrew Wendling</td>\n <td>andrew_wendling@ham.honda.com</td>\n </tr>\n <tr>\n <th>4</th>\n <td>Andrew Winger</td>\n <td>andy_winger@hna.honda.com</td>\n </tr>\n <tr>\n <th>5</th>\n <td>Asif Shaikh</td>\n <td>asif_shaikh@hna.honda.com</td>\n </tr>\n <tr>\n <th>6</th>\n <td>Bob Voyles</td>\n <td>bob_voyles@hna.honda.com</td>\n </tr>\n <tr>\n <th>7</th>\n <td>Brad Kukula</td>\n <td>brad_kukula@hna.honda.com</td>\n </tr>\n <tr>\n <th>8</th>\n <td>Brent Armstrong</td>\n <td>brent_armstrong@hna.honda.com</td>\n </tr>\n <tr>\n <th>9</th>\n <td>Brian Bodor</td>\n <td>bbodor@oh.hra.com</td>\n </tr>\n <tr>\n <th>10</th>\n <td>Brian Papesh</td>\n <td>brian_papesh@hna.honda.com</td>\n </tr>\n <tr>\n <th>11</th>\n <td>Bryan Speasmaker</td>\n <td>bryan_speasmaker@hna.honda.com</td>\n </tr>\n <tr>\n <th>12</th>\n <td>Bryce Soelberg</td>\n <td>bryce_soelberg@ham.honda.com</td>\n </tr>\n <tr>\n <th>13</th>\n <td>Carl Sommerville</td>\n <td>carl_sommerville@hna.honda.com</td>\n </tr>\n <tr>\n <th>14</th>\n <td>Casey Fulton</td>\n <td>casey_r_fulton@ham.honda.com</td>\n </tr>\n <tr>\n <th>15</th>\n <td>Cate Whitfield</td>\n <td>cate_whitfield@hna.honda.com</td>\n </tr>\n <tr>\n <th>16</th>\n <td>Chelsea Nungesser</td>\n <td>chelsea_nungesser@ham.honda.com</td>\n </tr>\n <tr>\n <th>17</th>\n <td>Cheri Brumbaugh</td>\n <td>cheri_brumbaugh@ham.honda.com</td>\n </tr>\n <tr>\n <th>18</th>\n <td>Cherie Drees</td>\n <td>cherie_drees@ham.honda.com</td>\n </tr>\n <tr>\n <th>19</th>\n <td>Chris Roush</td>\n <td>chris_roush@ham.honda.com</td>\n </tr>\n <tr>\n <th>20</th>\n <td>Cody Manger</td>\n <td>cody_manger@hna.honda.com</td>\n </tr>\n <tr>\n <th>21</th>\n <td>Cortney McClure</td>\n <td>cortney_mcclure@ham.honda.com</td>\n </tr>\n <tr>\n <th>22</th>\n <td>Dale Malony</td>\n <td>dale_malony@ham.honda.com</td>\n </tr>\n <tr>\n <th>23</th>\n <td>Daniel Kim</td>\n <td>daniel_j_kim@hna.honda.com</td>\n </tr>\n <tr>\n <th>24</th>\n <td>Daniela Evans</td>\n <td>daniela_evans@hna.honda.com</td>\n </tr>\n <tr>\n <th>25</th>\n <td>Danny Carroll</td>\n <td>danny_carroll@hna.honda.com</td>\n </tr>\n <tr>\n <th>26</th>\n <td>David Plonski</td>\n <td>david_plonski@ham.honda.com</td>\n </tr>\n <tr>\n <th>27</th>\n <td>Deedat Choudhury</td>\n <td>deedat_choudhury@ham.honda.com</td>\n </tr>\n <tr>\n <th>28</th>\n <td>Derek Davis</td>\n <td>derek_davis@hna.honda.com</td>\n </tr>\n <tr>\n <th>29</th>\n <td>Derrick Cobb</td>\n <td>derrick_cobb@ega.honda.com</td>\n </tr>\n <tr>\n <th>30</th>\n <td>Diego Hildebrandt</td>\n <td>diego_hildebrandt@hna.honda.com</td>\n </tr>\n <tr>\n <th>31</th>\n <td>Dillon Brancheau</td>\n <td>dillon_brancheau@ham.honda.com</td>\n </tr>\n <tr>\n <th>32</th>\n <td>Doug Kremer</td>\n <td>doug_kremer@ham.honda.com</td>\n </tr>\n <tr>\n <th>33</th>\n <td>Drew Kennedy</td>\n <td>drew_kennedy@ham.honda.com</td>\n </tr>\n <tr>\n <th>34</th>\n <td>Drew Paroz</td>\n <td>drew_paroz@ham.honda.com</td>\n </tr>\n <tr>\n <th>35</th>\n <td>Edward Malek</td>\n <td>edward_malek@ham.honda.com</td>\n </tr>\n <tr>\n <th>36</th>\n <td>Eric Roby</td>\n <td>eric_roby@hna.honda.com</td>\n </tr>\n <tr>\n <th>37</th>\n <td>Farhan Ahmed</td>\n <td>farhan_ahmed@hna.honda.com</td>\n </tr>\n <tr>\n <th>38</th>\n <td>Glen Wang</td>\n <td>glen_wang@hna.honda.com</td>\n </tr>\n <tr>\n <th>39</th>\n <td>Greg Cottrill</td>\n <td>greg_cottrill@hna.honda.com</td>\n </tr>\n <tr>\n <th>40</th>\n <td>Greta Backus</td>\n <td>greta_backus@hna.honda.com</td>\n </tr>\n <tr>\n <th>41</th>\n <td>Harry Wagner</td>\n <td>harry_wagner@hna.honda.com</td>\n </tr>\n <tr>\n <th>42</th>\n <td>Hiroshi Hayashi</td>\n <td>hiroshi_hayashi@hna.honda.com</td>\n </tr>\n <tr>\n <th>43</th>\n <td>Jake Coloney</td>\n <td>jake_coloney@hna.honda.com</td>\n </tr>\n <tr>\n <th>44</th>\n <td>James Brooks</td>\n <td>james_f_brooks@hna.honda.com</td>\n </tr>\n <tr>\n <th>45</th>\n <td>Jenifer Harper</td>\n <td>jen_harper@hna.honda.com</td>\n </tr>\n <tr>\n <th>46</th>\n <td>Jennifer Bell</td>\n <td>jennifer_bell@hma.honda.com</td>\n </tr>\n <tr>\n <th>47</th>\n <td>Jeremy Block</td>\n <td>jblock@oh.hra.com</td>\n </tr>\n <tr>\n <th>48</th>\n <td>Joe Mazzocchi</td>\n <td>joe_mazzocchi@hna.honda.com</td>\n </tr>\n <tr>\n <th>49</th>\n <td>Jonathan Alvarez</td>\n <td>jonathan_alvarez@hna.honda.com</td>\n </tr>\n <tr>\n <th>50</th>\n <td>Jonathon Pack</td>\n <td>jonathon_pack@hna.honda.com</td>\n </tr>\n <tr>\n <th>51</th>\n <td>Jordan Tipton</td>\n <td>jordan_tipton@hna.honda.com</td>\n </tr>\n <tr>\n <th>52</th>\n <td>Kazue Motoki</td>\n <td>kazue_motoki@hna.honda.com</td>\n </tr>\n <tr>\n <th>53</th>\n <td>Kevin Girard</td>\n <td>kevin_girard@ham.honda.com</td>\n </tr>\n <tr>\n <th>54</th>\n <td>Kristen Vilt</td>\n <td>kristen_vilt@hna.honda.com</td>\n </tr>\n <tr>\n <th>55</th>\n <td>Landon Small</td>\n <td>landon_small@hna.honda.com</td>\n </tr>\n <tr>\n <th>56</th>\n <td>Larry Roudebush</td>\n <td>larry_roudebush@hna.honda.com</td>\n </tr>\n <tr>\n <th>57</th>\n <td>Lorie Austin</td>\n <td>lorie_austin@hna.honda.com</td>\n </tr>\n <tr>\n <th>58</th>\n <td>Mabe Fujita</td>\n <td>mabe_fujita@hna.honda.com</td>\n </tr>\n <tr>\n <th>59</th>\n <td>Mark Bar</td>\n <td>mark_bar@hna.honda.com</td>\n </tr>\n <tr>\n <th>60</th>\n <td>May Markusic</td>\n <td>mayflor_markusic@ham.honda.com</td>\n </tr>\n <tr>\n <th>61</th>\n <td>Michelle Witte</td>\n <td>michelle_witte@ham.honda.com</td>\n </tr>\n <tr>\n <th>62</th>\n <td>Mike Ramsey</td>\n <td>mike_ramsey@hna.honda.com</td>\n </tr>\n <tr>\n <th>63</th>\n <td>Mitch Komine</td>\n <td>mitch_komine@hna.honda.com</td>\n </tr>\n <tr>\n <th>64</th>\n <td>Nick Allen</td>\n <td>nick_allen@hna.honda.com</td>\n </tr>\n <tr>\n <th>65</th>\n <td>Noah Ronneberg</td>\n <td>noah_ronneberg@hna.honda.com</td>\n </tr>\n <tr>\n <th>66</th>\n <td>Pavithra Ramamurthy</td>\n <td>pavithra_ramamurthy@hna.honda.com</td>\n </tr>\n <tr>\n <th>67</th>\n <td>Pete Edwards</td>\n <td>pete_edwards@ega.honda.com</td>\n </tr>\n <tr>\n <th>68</th>\n <td>Philip Wilson</td>\n <td>philip_wilson@hna.honda.com</td>\n </tr>\n <tr>\n <th>69</th>\n <td>RW Powers</td>\n <td>rw_powers@hna.honda.com</td>\n </tr>\n <tr>\n <th>70</th>\n <td>Rajeev Chhajer</td>\n <td>rajeev_chhajer@oh.hra.com</td>\n </tr>\n <tr>\n <th>71</th>\n <td>Rick Carlisle</td>\n <td>rick_carlisle@ega.honda.com</td>\n </tr>\n <tr>\n <th>72</th>\n <td>Riley Hohman</td>\n <td>riley_hohman@hna.honda.com</td>\n </tr>\n <tr>\n <th>73</th>\n <td>Roy Daikuzono</td>\n <td>rdaikuzono@oh.hra.com</td>\n </tr>\n <tr>\n <th>74</th>\n <td>Ryan Danley</td>\n <td>ryan_danley@hmin.honda.com</td>\n </tr>\n <tr>\n <th>75</th>\n <td>Ryan Smith</td>\n <td>ryan_smith@hna.honda.com</td>\n </tr>\n <tr>\n <th>76</th>\n <td>Sam Gronow</td>\n <td>sam_gronow@hna.honda.com</td>\n </tr>\n <tr>\n <th>77</th>\n <td>Sarah Legatt</td>\n <td>sarah_legatt@hna.honda.com</td>\n </tr>\n <tr>\n <th>78</th>\n <td>Scott Carter</td>\n <td>scott_carter@hna.honda.com</td>\n </tr>\n <tr>\n <th>79</th>\n <td>Scott Nourse</td>\n <td>scott_nourse@hna.honda.com</td>\n </tr>\n <tr>\n <th>80</th>\n <td>Sean Holshu</td>\n <td>sean_holshu@hna.honda.com</td>\n </tr>\n <tr>\n <th>81</th>\n <td>Shawnee Moseman</td>\n <td>shawnee_moseman@hna.honda.com</td>\n </tr>\n <tr>\n <th>82</th>\n <td>Steve Baker</td>\n <td>steve_j_baker@ham.honda.com</td>\n </tr>\n <tr>\n <th>83</th>\n <td>Thomas Hendel</td>\n <td>thomas_hendel@hna.honda.com</td>\n </tr>\n <tr>\n <th>84</th>\n <td>Tom Crawford</td>\n <td>tom_crawford@hna.honda.com</td>\n </tr>\n <tr>\n <th>85</th>\n <td>Tom Harris</td>\n <td>tom_harris@hna.honda.com</td>\n </tr>\n <tr>\n <th>86</th>\n <td>Traviss Alexander</td>\n <td>traviss_alexander@hna.honda.com</td>\n </tr>\n </tbody>\n</table>\n</div>", | |
"text/plain": " Name Email\n0 Adam Wilson adam_wilson@ham.honda.com\n1 Alex Bredyuk alex_bredyuk@ega.honda.com\n2 Alex Dailey alex_dailey@hna.honda.com\n3 Andrew Wendling andrew_wendling@ham.honda.com\n4 Andrew Winger andy_winger@hna.honda.com\n5 Asif Shaikh asif_shaikh@hna.honda.com\n6 Bob Voyles bob_voyles@hna.honda.com\n7 Brad Kukula brad_kukula@hna.honda.com\n8 Brent Armstrong brent_armstrong@hna.honda.com\n9 Brian Bodor bbodor@oh.hra.com\n10 Brian Papesh brian_papesh@hna.honda.com\n11 Bryan Speasmaker bryan_speasmaker@hna.honda.com\n12 Bryce Soelberg bryce_soelberg@ham.honda.com\n13 Carl Sommerville carl_sommerville@hna.honda.com\n14 Casey Fulton casey_r_fulton@ham.honda.com\n15 Cate Whitfield cate_whitfield@hna.honda.com\n16 Chelsea Nungesser chelsea_nungesser@ham.honda.com\n17 Cheri Brumbaugh cheri_brumbaugh@ham.honda.com\n18 Cherie Drees cherie_drees@ham.honda.com\n19 Chris Roush chris_roush@ham.honda.com\n20 Cody Manger cody_manger@hna.honda.com\n21 Cortney McClure cortney_mcclure@ham.honda.com\n22 Dale Malony dale_malony@ham.honda.com\n23 Daniel Kim daniel_j_kim@hna.honda.com\n24 Daniela Evans daniela_evans@hna.honda.com\n25 Danny Carroll danny_carroll@hna.honda.com\n26 David Plonski david_plonski@ham.honda.com\n27 Deedat Choudhury deedat_choudhury@ham.honda.com\n28 Derek Davis derek_davis@hna.honda.com\n29 Derrick Cobb derrick_cobb@ega.honda.com\n30 Diego Hildebrandt diego_hildebrandt@hna.honda.com\n31 Dillon Brancheau dillon_brancheau@ham.honda.com\n32 Doug Kremer doug_kremer@ham.honda.com\n33 Drew Kennedy drew_kennedy@ham.honda.com\n34 Drew Paroz drew_paroz@ham.honda.com\n35 Edward Malek edward_malek@ham.honda.com\n36 Eric Roby eric_roby@hna.honda.com\n37 Farhan Ahmed farhan_ahmed@hna.honda.com\n38 Glen Wang glen_wang@hna.honda.com\n39 Greg Cottrill greg_cottrill@hna.honda.com\n40 Greta Backus greta_backus@hna.honda.com\n41 Harry Wagner harry_wagner@hna.honda.com\n42 Hiroshi Hayashi hiroshi_hayashi@hna.honda.com\n43 Jake Coloney jake_coloney@hna.honda.com\n44 James Brooks james_f_brooks@hna.honda.com\n45 Jenifer Harper jen_harper@hna.honda.com\n46 Jennifer Bell jennifer_bell@hma.honda.com\n47 Jeremy Block jblock@oh.hra.com\n48 Joe Mazzocchi joe_mazzocchi@hna.honda.com\n49 Jonathan Alvarez jonathan_alvarez@hna.honda.com\n50 Jonathon Pack jonathon_pack@hna.honda.com\n51 Jordan Tipton jordan_tipton@hna.honda.com\n52 Kazue Motoki kazue_motoki@hna.honda.com\n53 Kevin Girard kevin_girard@ham.honda.com\n54 Kristen Vilt kristen_vilt@hna.honda.com\n55 Landon Small landon_small@hna.honda.com\n56 Larry Roudebush larry_roudebush@hna.honda.com\n57 Lorie Austin lorie_austin@hna.honda.com\n58 Mabe Fujita mabe_fujita@hna.honda.com\n59 Mark Bar mark_bar@hna.honda.com\n60 May Markusic mayflor_markusic@ham.honda.com\n61 Michelle Witte michelle_witte@ham.honda.com\n62 Mike Ramsey mike_ramsey@hna.honda.com\n63 Mitch Komine mitch_komine@hna.honda.com\n64 Nick Allen nick_allen@hna.honda.com\n65 Noah Ronneberg noah_ronneberg@hna.honda.com\n66 Pavithra Ramamurthy pavithra_ramamurthy@hna.honda.com\n67 Pete Edwards pete_edwards@ega.honda.com\n68 Philip Wilson philip_wilson@hna.honda.com\n69 RW Powers rw_powers@hna.honda.com\n70 Rajeev Chhajer rajeev_chhajer@oh.hra.com\n71 Rick Carlisle rick_carlisle@ega.honda.com\n72 Riley Hohman riley_hohman@hna.honda.com\n73 Roy Daikuzono rdaikuzono@oh.hra.com\n74 Ryan Danley ryan_danley@hmin.honda.com\n75 Ryan Smith ryan_smith@hna.honda.com\n76 Sam Gronow sam_gronow@hna.honda.com\n77 Sarah Legatt sarah_legatt@hna.honda.com\n78 Scott Carter scott_carter@hna.honda.com\n79 Scott Nourse scott_nourse@hna.honda.com\n80 Sean Holshu sean_holshu@hna.honda.com\n81 Shawnee Moseman shawnee_moseman@hna.honda.com\n82 Steve Baker steve_j_baker@ham.honda.com\n83 Thomas Hendel thomas_hendel@hna.honda.com\n84 Tom Crawford tom_crawford@hna.honda.com\n85 Tom Harris tom_harris@hna.honda.com\n86 Traviss Alexander traviss_alexander@hna.honda.com" | |
}, | |
"execution_count": 114, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "### Identify members in SharePoint directory, but not in database:" | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "left_joined = pd.merge(members_sp, members_sqlite, how='left', on='Email', indicator=True)", | |
"execution_count": 115, | |
"outputs": [] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "left_joined.query(\"_merge == 'left_only'\")", | |
"execution_count": 116, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": "<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_x</th>\n <th>Email</th>\n <th>Name_y</th>\n <th>_merge</th>\n </tr>\n </thead>\n <tbody>\n </tbody>\n</table>\n</div>", | |
"text/plain": "Empty DataFrame\nColumns: [Name_x, Email, Name_y, _merge]\nIndex: []" | |
}, | |
"execution_count": 116, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "### Identify members in database, but not in SharePoint directory:" | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "right_joined = pd.merge(members_sp, members_sqlite, how='right', on='Email', indicator=True)", | |
"execution_count": 117, | |
"outputs": [] | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "right_joined.query(\"_merge == 'right_only'\")", | |
"execution_count": 118, | |
"outputs": [ | |
{ | |
"data": { | |
"text/html": "<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_x</th>\n <th>Email</th>\n <th>Name_y</th>\n <th>_merge</th>\n </tr>\n </thead>\n <tbody>\n </tbody>\n</table>\n</div>", | |
"text/plain": "Empty DataFrame\nColumns: [Name_x, Email, Name_y, _merge]\nIndex: []" | |
}, | |
"execution_count": 118, | |
"metadata": {}, | |
"output_type": "execute_result" | |
} | |
] | |
}, | |
{ | |
"metadata": {}, | |
"cell_type": "markdown", | |
"source": "### Check if there is any discrepancies between the member database and SharePoint member directory:" | |
}, | |
{ | |
"metadata": { | |
"trusted": false | |
}, | |
"cell_type": "code", | |
"source": "if len(left_joined.query(\"_merge == 'left_only'\")) == 0 and len(right_joined.query(\"_merge == 'right_only'\")) == 0:\n print(\"Members information is synced in both the database and SharePoint directory, no action required.\")\nelse:\n print(\"In Sharepoint, but not in sqlite database:\")\n print(left_joined.query(\"_merge == 'left_only'\"))\n print(\"\\n\")\n print(\"In sqlite database, but in Sharepoint:\")\n print(right_joined.query(\"_merge == 'right_only'\"))", | |
"execution_count": 22, | |
"outputs": [ | |
{ | |
"name": "stdout", | |
"output_type": "stream", | |
"text": "In Sharepoint, but not in sqlite database:\n Name_x Email Name_y _merge\n15 Creg Cottrill creg_cottrill@hna.honda.com NaN left_only\n18 Daniela Evans daniela_evans@hna.honda.com NaN left_only\n55 Riley Hohman riley_hohman@hna.honda.com NaN left_only\n\n\nIn sqlite database, but in Sharepoint:\nEmpty DataFrame\nColumns: [Name_x, Email, Name_y, _merge]\nIndex: []\n" | |
} | |
] | |
} | |
], | |
"metadata": { | |
"hide_input": false, | |
"kernelspec": { | |
"name": "python3", | |
"display_name": "Python 3", | |
"language": "python" | |
}, | |
"language_info": { | |
"codemirror_mode": { | |
"name": "ipython", | |
"version": 3 | |
}, | |
"file_extension": ".py", | |
"mimetype": "text/x-python", | |
"name": "python", | |
"nbconvert_exporter": "python", | |
"pygments_lexer": "ipython3", | |
"version": "3.6.3" | |
}, | |
"gist": { | |
"id": "", | |
"data": { | |
"description": "BRG_BRAIN/1_Member_List_Consolidation.ipynb", | |
"public": true | |
} | |
} | |
}, | |
"nbformat": 4, | |
"nbformat_minor": 2 | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment