sod.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyNLO5PUvU1GYfpxU466CECk"
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "source": [
        "import numpy as np\n",
        "import pandas as pd"
      ],
      "metadata": {
        "id": "Wn4x5mmcYIa0"
      },
      "execution_count": 42,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "Read the Excel files downloaded form NetSuite, remove admins from the list of users (since they have full accces to all permissions), and merge the files into a single df."
      ],
      "metadata": {
        "id": "13pDlWNyajg8"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# read files\n",
        "employees = pd.read_excel('EmployeeRoles.xlsx')\n",
        "permissions = pd.read_excel('RolePermissions.xlsx')\n",
        "\n",
        "# remove the admins and keep just the 'Name', 'Role', 'Permission', and 'Level' columns of the df\n",
        "admins = employees[employees['Role'] == 'Administrator']['Name'].unique().tolist()\n",
        "employees = employees[~employees['Name'].isin(admins)][['Name', 'Role']]\n",
        "\n",
        "# combine the employee file and the permissions file\n",
        "all_permissions = employees.merge(permissions, how='outer', on='Role')\n",
        "all_permissions.head()"
      ],
      "metadata": {
        "id": "Ox3IiFBEYme1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "274b17c6-f9dd-4f78-a7f7-c10b9f9863cd"
      },
      "execution_count": 45,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                   Name                     Role  Edit Custom/Standard  \\\n",
              "0  Janice Henderson PhD  Company Production View  Edit          Custom   \n",
              "1  Janice Henderson PhD  Company Production View  Edit          Custom   \n",
              "2  Janice Henderson PhD  Company Production View  Edit          Custom   \n",
              "3  Janice Henderson PhD  Company Production View  Edit          Custom   \n",
              "4  Janice Henderson PhD  Company Production View  Edit          Custom   \n",
              "\n",
              "      Center Type           Permission Level  \n",
              "0  Classic Center  SAML Single Sign-on  Full  \n",
              "1  Classic Center              Classes  View  \n",
              "2  Classic Center                Cases  View  \n",
              "3  Classic Center          Phone Calls  View  \n",
              "4  Classic Center                 Bins  View  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-054bca14-20b0-457e-b476-cf92693ef775\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>Role</th>\n",
              "      <th>Edit</th>\n",
              "      <th>Custom/Standard</th>\n",
              "      <th>Center Type</th>\n",
              "      <th>Permission</th>\n",
              "      <th>Level</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Janice Henderson PhD</td>\n",
              "      <td>Company Production View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Custom</td>\n",
              "      <td>Classic Center</td>\n",
              "      <td>SAML Single Sign-on</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Janice Henderson PhD</td>\n",
              "      <td>Company Production View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Custom</td>\n",
              "      <td>Classic Center</td>\n",
              "      <td>Classes</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Janice Henderson PhD</td>\n",
              "      <td>Company Production View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Custom</td>\n",
              "      <td>Classic Center</td>\n",
              "      <td>Cases</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Janice Henderson PhD</td>\n",
              "      <td>Company Production View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Custom</td>\n",
              "      <td>Classic Center</td>\n",
              "      <td>Phone Calls</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Janice Henderson PhD</td>\n",
              "      <td>Company Production View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Custom</td>\n",
              "      <td>Classic Center</td>\n",
              "      <td>Bins</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-054bca14-20b0-457e-b476-cf92693ef775')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-054bca14-20b0-457e-b476-cf92693ef775 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-054bca14-20b0-457e-b476-cf92693ef775');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 45
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Create a pivot table that contains one row for each user and whether or not their role, or combination of roles, give them access to a specific permission."
      ],
      "metadata": {
        "id": "ezBBFTCaZ8HE"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# some users have multiple roles, each with a differnt permissions level. we need to replace the pmermission levels with a binary (1=edit access or 0=no edit access); those values will be summed when we pivot the data; a user that has a permission that sums > 0 has access to that permission across any of their roles\n",
        "df = all_permissions.replace({'Level': {'Full': 1, 'Edit': 1, 'Create': 1, 'View': 0, 'None': 0}})\n",
        "\n",
        "# pivot the all_permissions df to get the permissions in the column headers; the index variable is all of the columns that we need to keep from the raw data\n",
        "df = df.pivot_table(index='Name', values='Level', columns='Permission', aggfunc='sum').reset_index().rename_axis(None, axis=1).fillna(0)\n",
        "for col in df.columns:\n",
        "  if col != 'Name':\n",
        "    df[col] = np.where(df[col] > 0, 'Yes', 'No')\n",
        "df.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 473
        },
        "id": "T6-bc7JyYpEc",
        "outputId": "d070ac6e-4271-4bc0-e8b9-fd5b6f03c08a"
      },
      "execution_count": 46,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              Name AV6 Dunning Customizing AV6 Dunning Run AV6 Dunning Texts  \\\n",
              "0     Aaron Cooper                      No              No                No   \n",
              "1     Aaron Valdez                      No              No                No   \n",
              "2  Abigail Johnson                      No              No                No   \n",
              "3    Adriana Green                      No              No                No   \n",
              "4   Adrienne Mejia                      No              No                No   \n",
              "\n",
              "  AV6 Label, Help and Error Texts AV6 Statement Run AVAADDRESSVALFLAG  \\\n",
              "0                              No                No                No   \n",
              "1                              No                No                No   \n",
              "2                              No                No                No   \n",
              "3                              No                No                No   \n",
              "4                              No                No                No   \n",
              "\n",
              "  AVAADDRESSVALIDATIONBATCH AVAADDVALIDATIONBATCHRECORDS AVACERTEMAIL  ...  \\\n",
              "0                        No                           No           No  ...   \n",
              "1                        No                           No           No  ...   \n",
              "2                        No                           No           No  ...   \n",
              "3                        No                           No           No  ...   \n",
              "4                        No                           No           No  ...   \n",
              "\n",
              "  Web Site Report Web Store Report Website (External) publisher Work Calendar  \\\n",
              "0              No               No                           No            No   \n",
              "1              No               No                           No            No   \n",
              "2              No               No                           No            No   \n",
              "3              No               No                           No            No   \n",
              "4              No               No                           No            No   \n",
              "\n",
              "  Work Order Work Order Close Work Order Completion Work Order Issue Workflow  \\\n",
              "0         No               No                    No               No       No   \n",
              "1        Yes               No                    No               No       No   \n",
              "2         No               No                   Yes              Yes       No   \n",
              "3         No               No                    No               No       No   \n",
              "4         No               No                    No              Yes       No   \n",
              "\n",
              "  Zengin Bank Fee Schedule  \n",
              "0                       No  \n",
              "1                       No  \n",
              "2                       No  \n",
              "3                       No  \n",
              "4                       No  \n",
              "\n",
              "[5 rows x 542 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b307fede-36d3-4aae-972d-a5d889b9069c\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>AV6 Dunning Customizing</th>\n",
              "      <th>AV6 Dunning Run</th>\n",
              "      <th>AV6 Dunning Texts</th>\n",
              "      <th>AV6 Label, Help and Error Texts</th>\n",
              "      <th>AV6 Statement Run</th>\n",
              "      <th>AVAADDRESSVALFLAG</th>\n",
              "      <th>AVAADDRESSVALIDATIONBATCH</th>\n",
              "      <th>AVAADDVALIDATIONBATCHRECORDS</th>\n",
              "      <th>AVACERTEMAIL</th>\n",
              "      <th>...</th>\n",
              "      <th>Web Site Report</th>\n",
              "      <th>Web Store Report</th>\n",
              "      <th>Website (External) publisher</th>\n",
              "      <th>Work Calendar</th>\n",
              "      <th>Work Order</th>\n",
              "      <th>Work Order Close</th>\n",
              "      <th>Work Order Completion</th>\n",
              "      <th>Work Order Issue</th>\n",
              "      <th>Workflow</th>\n",
              "      <th>Zengin Bank Fee Schedule</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Aaron Cooper</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>...</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Aaron Valdez</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>...</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Abigail Johnson</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>...</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Adriana Green</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>...</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Adrienne Mejia</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>...</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 542 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b307fede-36d3-4aae-972d-a5d889b9069c')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-b307fede-36d3-4aae-972d-a5d889b9069c button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-b307fede-36d3-4aae-972d-a5d889b9069c');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 46
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Create a pivot table that contains all users and their roles. The end user will want to see which roles are assinged to each user and the max level of access that each user has for each permission."
      ],
      "metadata": {
        "id": "jYm-c0b-ZtxQ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# pivot the all_permissions df with the role included for presentation purposes\n",
        "df2 = all_permissions.pivot_table(index=['Name','Role'], values='Level', columns='Permission', aggfunc=','.join).reset_index().rename_axis(None, axis=1).fillna(0).replace({0 : 'None'})\n",
        "df2.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 577
        },
        "id": "NeUkYS1AYwDk",
        "outputId": "69a7083f-8206-4d3b-96d8-d9aed495127c"
      },
      "execution_count": 47,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              Name                                     Role  \\\n",
              "0     Aaron Cooper   Company Accounting - Controller - ODBC   \n",
              "1     Aaron Cooper  Company Accounting - Revenue Accountant   \n",
              "2     Aaron Valdez                            Company Buyer   \n",
              "3     Aaron Valdez                  Company Employee Center   \n",
              "4  Abigail Johnson                Company Inventory Control   \n",
              "\n",
              "  AV6 Dunning Customizing AV6 Dunning Run AV6 Dunning Texts  \\\n",
              "0                    None            None              None   \n",
              "1                    None            None              None   \n",
              "2                    None            None              None   \n",
              "3                    None            None              None   \n",
              "4                    None            None              None   \n",
              "\n",
              "  AV6 Label, Help and Error Texts AV6 Statement Run AVAADDRESSVALFLAG  \\\n",
              "0                            None              None              View   \n",
              "1                            None              None              None   \n",
              "2                            None              None              None   \n",
              "3                            None              None              None   \n",
              "4                            None              None              None   \n",
              "\n",
              "  AVAADDRESSVALIDATIONBATCH AVAADDVALIDATIONBATCHRECORDS  ... Web Site Report  \\\n",
              "0                      View                         View  ...            None   \n",
              "1                      None                         None  ...            None   \n",
              "2                      None                         None  ...            None   \n",
              "3                      None                         None  ...            None   \n",
              "4                      None                         None  ...            None   \n",
              "\n",
              "  Web Store Report Website (External) publisher Work Calendar Work Order  \\\n",
              "0             None                         None          View       View   \n",
              "1             None                         None          None       View   \n",
              "2             None                         None          None       Full   \n",
              "3             None                         None          View       None   \n",
              "4             None                         None          None       View   \n",
              "\n",
              "  Work Order Close Work Order Completion Work Order Issue Workflow  \\\n",
              "0             View                  View             View     None   \n",
              "1             View                  View             None     None   \n",
              "2             View                  View             View     None   \n",
              "3             None                  None             None     None   \n",
              "4             View                  Edit             View     None   \n",
              "\n",
              "  Zengin Bank Fee Schedule  \n",
              "0                     None  \n",
              "1                     None  \n",
              "2                     None  \n",
              "3                     None  \n",
              "4                     None  \n",
              "\n",
              "[5 rows x 543 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-dbed2fc4-0396-4416-98b4-5f17f14e1b32\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>Role</th>\n",
              "      <th>AV6 Dunning Customizing</th>\n",
              "      <th>AV6 Dunning Run</th>\n",
              "      <th>AV6 Dunning Texts</th>\n",
              "      <th>AV6 Label, Help and Error Texts</th>\n",
              "      <th>AV6 Statement Run</th>\n",
              "      <th>AVAADDRESSVALFLAG</th>\n",
              "      <th>AVAADDRESSVALIDATIONBATCH</th>\n",
              "      <th>AVAADDVALIDATIONBATCHRECORDS</th>\n",
              "      <th>...</th>\n",
              "      <th>Web Site Report</th>\n",
              "      <th>Web Store Report</th>\n",
              "      <th>Website (External) publisher</th>\n",
              "      <th>Work Calendar</th>\n",
              "      <th>Work Order</th>\n",
              "      <th>Work Order Close</th>\n",
              "      <th>Work Order Completion</th>\n",
              "      <th>Work Order Issue</th>\n",
              "      <th>Workflow</th>\n",
              "      <th>Zengin Bank Fee Schedule</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Aaron Cooper</td>\n",
              "      <td>Company Accounting - Controller - ODBC</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Aaron Cooper</td>\n",
              "      <td>Company Accounting - Revenue Accountant</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Aaron Valdez</td>\n",
              "      <td>Company Buyer</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>Full</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Aaron Valdez</td>\n",
              "      <td>Company Employee Center</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Abigail Johnson</td>\n",
              "      <td>Company Inventory Control</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>...</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 543 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-dbed2fc4-0396-4416-98b4-5f17f14e1b32')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-dbed2fc4-0396-4416-98b4-5f17f14e1b32 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-dbed2fc4-0396-4416-98b4-5f17f14e1b32');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Filter the df to those users that can create journal entries (Make Journal Entry) and approve journal entries (Journal Approval)"
      ],
      "metadata": {
        "id": "CMfa6YEJZq4n"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# filter the df to those users that can create journal entries (Make Journal Entry) and approve journal entries (Journal Approval)\n",
        "vf = pd.unique(df[(df['Make Journal Entry'] == \"Yes\") & (df['Journal Approval'] == \"Yes\")]['Name']).tolist()\n",
        "lf = df2[df2['Name'].isin(vf)][['Name', 'Role', 'Make Journal Entry', 'Journal Approval']]\n",
        "lf"
      ],
      "metadata": {
        "id": "Z2gF2TsfbdXG",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "577904d0-5248-4ce3-cba2-fd703efb3429"
      },
      "execution_count": 48,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  Name                                               Role  \\\n",
              "34          Amber Gray  Company Accounting - Dir of Shared Services - ...   \n",
              "35          Amber Gray  Company Accounting - Maint and Invoicing - Europe   \n",
              "36          Amber Gray                                    Custom EFT Role   \n",
              "90    Brandon Martinez  Company Accounting - Dir of Shared Services - ...   \n",
              "91    Brandon Martinez                  Company VP of Operations - Europe   \n",
              "132      Charles Young                                    Custom EFT Role   \n",
              "133      Charles Young      Entity Accounting - Maintenance and Invoicing   \n",
              "134      Charles Young                  Entity Accounting - AP & Cash App   \n",
              "135      Charles Young                 Entity Director of Shared Services   \n",
              "136      Charles Young                     Entity Fixed Assets Management   \n",
              "161  Christopher Lynch          Company Accounting - Assistant Controller   \n",
              "162  Christopher Lynch                        Company Accounting - Celigo   \n",
              "163  Christopher Lynch                    Company Accounting - Controller   \n",
              "164  Christopher Lynch                    Company Fixed Assets Management   \n",
              "191      Crystal Jones          Company Accounting - Assistant Controller   \n",
              "284    Felicia Francis  Company Accounting - Dir of Shared Services - ...   \n",
              "378      Jessica Chase          Company Accounting - Assistant Controller   \n",
              "379      Jessica Chase                        Company Accounting - Celigo   \n",
              "380      Jessica Chase                    Company Fixed Assets Management   \n",
              "472  Kathleen Williams                                    Custom EFT Role   \n",
              "473  Kathleen Williams                     Company Production View - MIST   \n",
              "474  Kathleen Williams  Company Accounting - Credit & Collections Mgr ...   \n",
              "475  Kathleen Williams   Company Accounting - Director of Shared Services   \n",
              "476  Kathleen Williams       Company Accounting - Shared Services Manager   \n",
              "509      Laura Higgins             Company Accounting - Controller - ODBC   \n",
              "510      Laura Higgins          Company Accounting - Assistant Controller   \n",
              "511      Laura Higgins                        Company Accounting - Celigo   \n",
              "512      Laura Higgins                    Company Fixed Assets Management   \n",
              "513         Lauren Lin     Company Accounting - Maintenance and Invoicing   \n",
              "514         Lauren Lin  Company Accounting - Credit & Collections Manager   \n",
              "534   Margaret Sanders                            Company Employee Center   \n",
              "535   Margaret Sanders                                    Custom EFT Role   \n",
              "536   Margaret Sanders       Company Accounting - Shared Services Manager   \n",
              "537   Margaret Sanders                            Company Custom EFT Role   \n",
              "607       Morgan Moore                            Company Employee Center   \n",
              "608       Morgan Moore                                    Custom EFT Role   \n",
              "609       Morgan Moore                       NetSuite Implementation Team   \n",
              "610       Morgan Moore   Company Accounting - Director of Shared Services   \n",
              "814      Thomas Reeves      Entity Accounting - Maintenance and Invoicing   \n",
              "815      Thomas Reeves                 Entity Director of Shared Services   \n",
              "816      Thomas Reeves                     Entity Fixed Assets Management   \n",
              "817      Thomas Reeves                            Entity China Accountant   \n",
              "818      Thomas Reeves                Entity Accounting Director Approval   \n",
              "\n",
              "    Make Journal Entry Journal Approval  \n",
              "34                Edit             Full  \n",
              "35                View             View  \n",
              "36                View             None  \n",
              "90                Edit             Full  \n",
              "91                View             View  \n",
              "132               View             None  \n",
              "133               Edit             View  \n",
              "134               Edit             View  \n",
              "135               Edit             Full  \n",
              "136               Full             None  \n",
              "161               Edit             Full  \n",
              "162               Edit             Full  \n",
              "163               Edit             Full  \n",
              "164               Full             None  \n",
              "191               Edit             Full  \n",
              "284               Edit             Full  \n",
              "378               Edit             Full  \n",
              "379               Edit             Full  \n",
              "380               Full             None  \n",
              "472               View             None  \n",
              "473               None             None  \n",
              "474               Edit             Full  \n",
              "475               Edit             Full  \n",
              "476               Edit             Full  \n",
              "509               View             View  \n",
              "510               Edit             Full  \n",
              "511               Edit             Full  \n",
              "512               Full             None  \n",
              "513               View             View  \n",
              "514               Edit             Full  \n",
              "534               None             None  \n",
              "535               View             None  \n",
              "536               Edit             Full  \n",
              "537               View             None  \n",
              "607               None             None  \n",
              "608               View             None  \n",
              "609               None             None  \n",
              "610               Edit             Full  \n",
              "814               Edit             View  \n",
              "815               Edit             Full  \n",
              "816               Full             None  \n",
              "817               View             None  \n",
              "818               None             None  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2426b05c-bf2f-4734-812f-09aa254d4e24\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>Role</th>\n",
              "      <th>Make Journal Entry</th>\n",
              "      <th>Journal Approval</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Company Accounting - Dir of Shared Services - ...</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>90</th>\n",
              "      <td>Brandon Martinez</td>\n",
              "      <td>Company Accounting - Dir of Shared Services - ...</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91</th>\n",
              "      <td>Brandon Martinez</td>\n",
              "      <td>Company VP of Operations - Europe</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>Full</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>161</th>\n",
              "      <td>Christopher Lynch</td>\n",
              "      <td>Company Accounting - Assistant Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>162</th>\n",
              "      <td>Christopher Lynch</td>\n",
              "      <td>Company Accounting - Celigo</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>163</th>\n",
              "      <td>Christopher Lynch</td>\n",
              "      <td>Company Accounting - Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>164</th>\n",
              "      <td>Christopher Lynch</td>\n",
              "      <td>Company Fixed Assets Management</td>\n",
              "      <td>Full</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>191</th>\n",
              "      <td>Crystal Jones</td>\n",
              "      <td>Company Accounting - Assistant Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>284</th>\n",
              "      <td>Felicia Francis</td>\n",
              "      <td>Company Accounting - Dir of Shared Services - ...</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>378</th>\n",
              "      <td>Jessica Chase</td>\n",
              "      <td>Company Accounting - Assistant Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>379</th>\n",
              "      <td>Jessica Chase</td>\n",
              "      <td>Company Accounting - Celigo</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>380</th>\n",
              "      <td>Jessica Chase</td>\n",
              "      <td>Company Fixed Assets Management</td>\n",
              "      <td>Full</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>472</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>473</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Company Production View - MIST</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>474</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Company Accounting - Credit &amp; Collections Mgr ...</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>475</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Company Accounting - Director of Shared Services</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>476</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Company Accounting - Shared Services Manager</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>509</th>\n",
              "      <td>Laura Higgins</td>\n",
              "      <td>Company Accounting - Controller - ODBC</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>510</th>\n",
              "      <td>Laura Higgins</td>\n",
              "      <td>Company Accounting - Assistant Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>511</th>\n",
              "      <td>Laura Higgins</td>\n",
              "      <td>Company Accounting - Celigo</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>512</th>\n",
              "      <td>Laura Higgins</td>\n",
              "      <td>Company Fixed Assets Management</td>\n",
              "      <td>Full</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>513</th>\n",
              "      <td>Lauren Lin</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>514</th>\n",
              "      <td>Lauren Lin</td>\n",
              "      <td>Company Accounting - Credit &amp; Collections Manager</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>534</th>\n",
              "      <td>Margaret Sanders</td>\n",
              "      <td>Company Employee Center</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>535</th>\n",
              "      <td>Margaret Sanders</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>536</th>\n",
              "      <td>Margaret Sanders</td>\n",
              "      <td>Company Accounting - Shared Services Manager</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>537</th>\n",
              "      <td>Margaret Sanders</td>\n",
              "      <td>Company Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>607</th>\n",
              "      <td>Morgan Moore</td>\n",
              "      <td>Company Employee Center</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>608</th>\n",
              "      <td>Morgan Moore</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>609</th>\n",
              "      <td>Morgan Moore</td>\n",
              "      <td>NetSuite Implementation Team</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>610</th>\n",
              "      <td>Morgan Moore</td>\n",
              "      <td>Company Accounting - Director of Shared Services</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>814</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>815</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Full</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>816</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>Full</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>817</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity China Accountant</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>818</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Accounting Director Approval</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2426b05c-bf2f-4734-812f-09aa254d4e24')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-2426b05c-bf2f-4734-812f-09aa254d4e24 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-2426b05c-bf2f-4734-812f-09aa254d4e24');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Filter the df to those users users that can create customer invoices (Invoice) and can either receive customer payments (Customer Deposit) or record customer payments (Customer Payment)"
      ],
      "metadata": {
        "id": "iu_7LsPcZova"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# filter the df to those users users that can create customer invoices (Invoice) and can either receive customer payments (Customer Deposit) or record customer payments (Customer Payment)\n",
        "vf = pd.unique(df[(df['Invoice'] == \"Yes\") & ((df['Customer Deposit'] == \"Yes\") | (df['Customer Payment'] == \"Yes\"))]['Name']).tolist()\n",
        "lf = df2[df2['Name'].isin(vf)][['Name', 'Role', 'Invoice', 'Customer Deposit', 'Customer Payment']]\n",
        "lf"
      ],
      "metadata": {
        "id": "atveJgwKb9I8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 551
        },
        "outputId": "79edb794-9f53-4bbf-aff8-d69472844b83"
      },
      "execution_count": 49,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  Name                                               Role  \\\n",
              "44   Andrea Villarreal  Company Accounting - Maint and Invoicing - Europe   \n",
              "45   Andrea Villarreal                                    Custom EFT Role   \n",
              "46   Andrea Villarreal        Company Accounting - AP & Cash App - Europe   \n",
              "47   Andrea Villarreal                            Company Human Resources   \n",
              "48   Andrea Villarreal      Entity Accounting - Maintenance and Invoicing   \n",
              "49   Andrea Villarreal                            Fixed Assets Management   \n",
              "132      Charles Young                                    Custom EFT Role   \n",
              "133      Charles Young      Entity Accounting - Maintenance and Invoicing   \n",
              "134      Charles Young                  Entity Accounting - AP & Cash App   \n",
              "135      Charles Young                 Entity Director of Shared Services   \n",
              "136      Charles Young                     Entity Fixed Assets Management   \n",
              "507       Latoya Gates                    Company Credit Card Integration   \n",
              "731       Sean Collins      Entity Accounting - Maintenance and Invoicing   \n",
              "732       Sean Collins                  Entity Accounting - AP & Cash App   \n",
              "733       Sean Collins                     Entity Fixed Assets Management   \n",
              "734       Sean Collins                            Entity China Accountant   \n",
              "\n",
              "    Invoice Customer Deposit Customer Payment  \n",
              "44     Edit             View             View  \n",
              "45     View             None             View  \n",
              "46     View             Edit             Edit  \n",
              "47     None             None             None  \n",
              "48     Edit             View             View  \n",
              "49     Full             None             None  \n",
              "132    View             None             View  \n",
              "133    Edit             View             View  \n",
              "134    View             Edit             Edit  \n",
              "135    View             View             View  \n",
              "136    View             None             None  \n",
              "507    Edit             None             Edit  \n",
              "731    Edit             View             View  \n",
              "732    View             Edit             Edit  \n",
              "733    View             None             None  \n",
              "734    View             View             View  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-c8050006-5a7a-4567-bb26-b871265eba0d\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>Role</th>\n",
              "      <th>Invoice</th>\n",
              "      <th>Customer Deposit</th>\n",
              "      <th>Customer Payment</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Accounting - AP &amp; Cash App - Europe</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Human Resources</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Fixed Assets Management</td>\n",
              "      <td>Full</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>507</th>\n",
              "      <td>Latoya Gates</td>\n",
              "      <td>Company Credit Card Integration</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>731</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>732</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>733</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>734</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity China Accountant</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-c8050006-5a7a-4567-bb26-b871265eba0d')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-c8050006-5a7a-4567-bb26-b871265eba0d button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-c8050006-5a7a-4567-bb26-b871265eba0d');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 49
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Filter the df to those users that can create vendors (Vendors) and pay vendors (Pay Bills)"
      ],
      "metadata": {
        "id": "qh86H76DZmbT"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# filter the df to those users that can create vendors (Vendors) and pay vendors (Pay Bills)\n",
        "vf = pd.unique(df[(df['Vendors'] == \"Yes\") & (df['Pay Bills'] == \"Yes\")]['Name']).tolist()\n",
        "lf = df2[df2['Name'].isin(vf)][['Name', 'Role', 'Customers', 'Customer Refund']]\n",
        "lf"
      ],
      "metadata": {
        "id": "4g22EDVDcW2N",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "c4015f74-0131-4fab-b5a0-e2525ff2aa77"
      },
      "execution_count": 50,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  Name                                               Role  \\\n",
              "34          Amber Gray  Company Accounting - Dir of Shared Services - ...   \n",
              "35          Amber Gray  Company Accounting - Maint and Invoicing - Europe   \n",
              "36          Amber Gray                                    Custom EFT Role   \n",
              "44   Andrea Villarreal  Company Accounting - Maint and Invoicing - Europe   \n",
              "45   Andrea Villarreal                                    Custom EFT Role   \n",
              "46   Andrea Villarreal        Company Accounting - AP & Cash App - Europe   \n",
              "47   Andrea Villarreal                            Company Human Resources   \n",
              "48   Andrea Villarreal      Entity Accounting - Maintenance and Invoicing   \n",
              "49   Andrea Villarreal                            Fixed Assets Management   \n",
              "65   Antonio Cervantes     Company Accounting - Maintenance and Invoicing   \n",
              "119    Carla Walton MD      Entity Accounting - Maintenance and Invoicing   \n",
              "132      Charles Young                                    Custom EFT Role   \n",
              "133      Charles Young      Entity Accounting - Maintenance and Invoicing   \n",
              "134      Charles Young                  Entity Accounting - AP & Cash App   \n",
              "135      Charles Young                 Entity Director of Shared Services   \n",
              "136      Charles Young                     Entity Fixed Assets Management   \n",
              "256        Dylan Berry     Company Accounting - Maintenance and Invoicing   \n",
              "285         Gary Nolan     Company Accounting - Maintenance and Invoicing   \n",
              "286          Gary Wong     Company Accounting - Maintenance and Invoicing   \n",
              "407    Jordan Martinez                             Entity Employee Center   \n",
              "408    Jordan Martinez      Entity Accounting - Maintenance and Invoicing   \n",
              "409    Jordan Martinez                        Entity Customer Service Rep   \n",
              "410    Jordan Martinez                        Entity Warehouse Operations   \n",
              "411    Jordan Martinez                               Entity Buyer/Planner   \n",
              "459    Karina Espinoza                                  Divvy Integration   \n",
              "513         Lauren Lin     Company Accounting - Maintenance and Invoicing   \n",
              "514         Lauren Lin  Company Accounting - Credit & Collections Manager   \n",
              "541        Maria Young        Company Shipping & Receiving Clerk - Europe   \n",
              "542        Maria Young  Company Accounting - Maint and Invoicing - Europe   \n",
              "547        Mary Wilson     Company Accounting - Maintenance and Invoicing   \n",
              "611  Mr. James Harding  Company Accounting - Maint and Invoicing - Europe   \n",
              "612  Mr. James Harding                                    Custom EFT Role   \n",
              "623       Natasha Moon                             Entity Employee Center   \n",
              "624       Natasha Moon      Entity Accounting - Maintenance and Invoicing   \n",
              "625       Natasha Moon                        Entity Customer Service Rep   \n",
              "626       Natasha Moon                        Entity Warehouse Operations   \n",
              "731       Sean Collins      Entity Accounting - Maintenance and Invoicing   \n",
              "732       Sean Collins                  Entity Accounting - AP & Cash App   \n",
              "733       Sean Collins                     Entity Fixed Assets Management   \n",
              "734       Sean Collins                            Entity China Accountant   \n",
              "814      Thomas Reeves      Entity Accounting - Maintenance and Invoicing   \n",
              "815      Thomas Reeves                 Entity Director of Shared Services   \n",
              "816      Thomas Reeves                     Entity Fixed Assets Management   \n",
              "817      Thomas Reeves                            Entity China Accountant   \n",
              "818      Thomas Reeves                Entity Accounting Director Approval   \n",
              "\n",
              "    Customers Customer Refund  \n",
              "34       View            Edit  \n",
              "35       Edit            None  \n",
              "36       View            View  \n",
              "44       Edit            None  \n",
              "45       View            View  \n",
              "46       Edit            None  \n",
              "47       None            None  \n",
              "48       Edit            None  \n",
              "49       View            None  \n",
              "65       Edit            None  \n",
              "119      Edit            None  \n",
              "132      View            View  \n",
              "133      Edit            None  \n",
              "134      Edit            None  \n",
              "135      View            Edit  \n",
              "136      View            None  \n",
              "256      Edit            None  \n",
              "285      Edit            None  \n",
              "286      Edit            None  \n",
              "407      None            None  \n",
              "408      Edit            None  \n",
              "409      Edit            None  \n",
              "410      View            None  \n",
              "411      View            None  \n",
              "459      Edit            None  \n",
              "513      Edit            None  \n",
              "514      Edit            None  \n",
              "541      View            None  \n",
              "542      Edit            None  \n",
              "547      Edit            None  \n",
              "611      Edit            None  \n",
              "612      View            View  \n",
              "623      None            None  \n",
              "624      Edit            None  \n",
              "625      Edit            None  \n",
              "626      View            None  \n",
              "731      Edit            None  \n",
              "732      Edit            None  \n",
              "733      View            None  \n",
              "734      View            None  \n",
              "814      Edit            None  \n",
              "815      View            Edit  \n",
              "816      View            None  \n",
              "817      View            None  \n",
              "818      None            None  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-8589d8cc-7300-4eee-98be-babc0b6c5f4e\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>Role</th>\n",
              "      <th>Customers</th>\n",
              "      <th>Customer Refund</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Company Accounting - Dir of Shared Services - ...</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Accounting - AP &amp; Cash App - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Human Resources</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>Antonio Cervantes</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>119</th>\n",
              "      <td>Carla Walton MD</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>256</th>\n",
              "      <td>Dylan Berry</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>285</th>\n",
              "      <td>Gary Nolan</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>286</th>\n",
              "      <td>Gary Wong</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>407</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Employee Center</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>408</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>409</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Customer Service Rep</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>410</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Warehouse Operations</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>411</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Buyer/Planner</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>459</th>\n",
              "      <td>Karina Espinoza</td>\n",
              "      <td>Divvy Integration</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>513</th>\n",
              "      <td>Lauren Lin</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>514</th>\n",
              "      <td>Lauren Lin</td>\n",
              "      <td>Company Accounting - Credit &amp; Collections Manager</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>541</th>\n",
              "      <td>Maria Young</td>\n",
              "      <td>Company Shipping &amp; Receiving Clerk - Europe</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>542</th>\n",
              "      <td>Maria Young</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>547</th>\n",
              "      <td>Mary Wilson</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>611</th>\n",
              "      <td>Mr. James Harding</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>612</th>\n",
              "      <td>Mr. James Harding</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>623</th>\n",
              "      <td>Natasha Moon</td>\n",
              "      <td>Entity Employee Center</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>624</th>\n",
              "      <td>Natasha Moon</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>625</th>\n",
              "      <td>Natasha Moon</td>\n",
              "      <td>Entity Customer Service Rep</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>626</th>\n",
              "      <td>Natasha Moon</td>\n",
              "      <td>Entity Warehouse Operations</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>731</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>732</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>733</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>734</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity China Accountant</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>814</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>815</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>816</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>817</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity China Accountant</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>818</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Accounting Director Approval</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8589d8cc-7300-4eee-98be-babc0b6c5f4e')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-8589d8cc-7300-4eee-98be-babc0b6c5f4e button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-8589d8cc-7300-4eee-98be-babc0b6c5f4e');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Filter the df to those users that can create credit memos (Credit Memo) and can either receive customer payments (Customer Deposit) or record customer payments (Customer Payment)"
      ],
      "metadata": {
        "id": "ooJoq_B-Zj3v"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# filter the df to those users that can create credit memos (Credit Memo) and can either receive customer payments (Customer Deposit) or record customer payments (Customer Payment)\n",
        "vf = pd.unique(df[(df['Credit Memo'] == \"Yes\") & ((df['Customer Deposit'] == \"Yes\") | (df['Customer Payment'] == \"Yes\"))]['Name']).tolist()\n",
        "lf = df2[df2['Name'].isin(vf)][['Name', 'Role', 'Credit Memo', 'Customer Deposit', 'Customer Payment']]\n",
        "lf"
      ],
      "metadata": {
        "id": "NT_D6IRxcA7n",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 520
        },
        "outputId": "861a98b3-0e51-493f-f6dc-56e4f9b79db0"
      },
      "execution_count": 51,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  Name                                               Role  \\\n",
              "44   Andrea Villarreal  Company Accounting - Maint and Invoicing - Europe   \n",
              "45   Andrea Villarreal                                    Custom EFT Role   \n",
              "46   Andrea Villarreal        Company Accounting - AP & Cash App - Europe   \n",
              "47   Andrea Villarreal                            Company Human Resources   \n",
              "48   Andrea Villarreal      Entity Accounting - Maintenance and Invoicing   \n",
              "49   Andrea Villarreal                            Fixed Assets Management   \n",
              "132      Charles Young                                    Custom EFT Role   \n",
              "133      Charles Young      Entity Accounting - Maintenance and Invoicing   \n",
              "134      Charles Young                  Entity Accounting - AP & Cash App   \n",
              "135      Charles Young                 Entity Director of Shared Services   \n",
              "136      Charles Young                     Entity Fixed Assets Management   \n",
              "731       Sean Collins      Entity Accounting - Maintenance and Invoicing   \n",
              "732       Sean Collins                  Entity Accounting - AP & Cash App   \n",
              "733       Sean Collins                     Entity Fixed Assets Management   \n",
              "734       Sean Collins                            Entity China Accountant   \n",
              "\n",
              "    Credit Memo Customer Deposit Customer Payment  \n",
              "44         Edit             View             View  \n",
              "45         View             None             View  \n",
              "46         View             Edit             Edit  \n",
              "47         None             None             None  \n",
              "48         Edit             View             View  \n",
              "49         None             None             None  \n",
              "132        View             None             View  \n",
              "133        Edit             View             View  \n",
              "134        View             Edit             Edit  \n",
              "135        View             View             View  \n",
              "136        None             None             None  \n",
              "731        Edit             View             View  \n",
              "732        View             Edit             Edit  \n",
              "733        None             None             None  \n",
              "734        View             View             View  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-1ef15170-6a13-4327-b7cd-48887097f6ea\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>Role</th>\n",
              "      <th>Credit Memo</th>\n",
              "      <th>Customer Deposit</th>\n",
              "      <th>Customer Payment</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Accounting - AP &amp; Cash App - Europe</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Human Resources</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Fixed Assets Management</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>731</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>732</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>733</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>734</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity China Accountant</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-1ef15170-6a13-4327-b7cd-48887097f6ea')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-1ef15170-6a13-4327-b7cd-48887097f6ea button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-1ef15170-6a13-4327-b7cd-48887097f6ea');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 51
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Filter the df to those users that can create customers (Customers) and issue customer refunds (Customer Refund)"
      ],
      "metadata": {
        "id": "vcOIpOs4ZglL"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# filter the df to those users that can create customers (Customers) and issue customer refunds (Customer Refund)\n",
        "vf = pd.unique(df[(df['Customers'] == \"Yes\") & (df['Customer Refund'] == \"Yes\")]['Name']).tolist()\n",
        "lf = df2[df2['Name'].isin(vf)][['Name', 'Role', 'Customers', 'Customer Refund']]\n",
        "lf"
      ],
      "metadata": {
        "id": "gBgEi5NAcEAO",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 739
        },
        "outputId": "6111dbfb-9140-4516-ae99-dd9811b824a9"
      },
      "execution_count": 52,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  Name                                               Role  \\\n",
              "34          Amber Gray  Company Accounting - Dir of Shared Services - ...   \n",
              "35          Amber Gray  Company Accounting - Maint and Invoicing - Europe   \n",
              "36          Amber Gray                                    Custom EFT Role   \n",
              "132      Charles Young                                    Custom EFT Role   \n",
              "133      Charles Young      Entity Accounting - Maintenance and Invoicing   \n",
              "134      Charles Young                  Entity Accounting - AP & Cash App   \n",
              "135      Charles Young                 Entity Director of Shared Services   \n",
              "136      Charles Young                     Entity Fixed Assets Management   \n",
              "472  Kathleen Williams                                    Custom EFT Role   \n",
              "473  Kathleen Williams                     Company Production View - MIST   \n",
              "474  Kathleen Williams  Company Accounting - Credit & Collections Mgr ...   \n",
              "475  Kathleen Williams   Company Accounting - Director of Shared Services   \n",
              "476  Kathleen Williams       Company Accounting - Shared Services Manager   \n",
              "534   Margaret Sanders                            Company Employee Center   \n",
              "535   Margaret Sanders                                    Custom EFT Role   \n",
              "536   Margaret Sanders       Company Accounting - Shared Services Manager   \n",
              "537   Margaret Sanders                            Company Custom EFT Role   \n",
              "814      Thomas Reeves      Entity Accounting - Maintenance and Invoicing   \n",
              "815      Thomas Reeves                 Entity Director of Shared Services   \n",
              "816      Thomas Reeves                     Entity Fixed Assets Management   \n",
              "817      Thomas Reeves                            Entity China Accountant   \n",
              "818      Thomas Reeves                Entity Accounting Director Approval   \n",
              "\n",
              "    Customers Customer Refund  \n",
              "34       View            Edit  \n",
              "35       Edit            None  \n",
              "36       View            View  \n",
              "132      View            View  \n",
              "133      Edit            None  \n",
              "134      Edit            None  \n",
              "135      View            Edit  \n",
              "136      View            None  \n",
              "472      View            View  \n",
              "473      View            None  \n",
              "474      Edit            None  \n",
              "475      View            Edit  \n",
              "476      Edit            Edit  \n",
              "534      None            None  \n",
              "535      View            View  \n",
              "536      Edit            Edit  \n",
              "537      View            View  \n",
              "814      Edit            None  \n",
              "815      View            Edit  \n",
              "816      View            None  \n",
              "817      View            None  \n",
              "818      None            None  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-2c9a75b7-e0c7-4d74-8028-bfdc0678aef6\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>Role</th>\n",
              "      <th>Customers</th>\n",
              "      <th>Customer Refund</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Company Accounting - Dir of Shared Services - ...</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>472</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>473</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Company Production View - MIST</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>474</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Company Accounting - Credit &amp; Collections Mgr ...</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>475</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Company Accounting - Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>476</th>\n",
              "      <td>Kathleen Williams</td>\n",
              "      <td>Company Accounting - Shared Services Manager</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>534</th>\n",
              "      <td>Margaret Sanders</td>\n",
              "      <td>Company Employee Center</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>535</th>\n",
              "      <td>Margaret Sanders</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>536</th>\n",
              "      <td>Margaret Sanders</td>\n",
              "      <td>Company Accounting - Shared Services Manager</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>537</th>\n",
              "      <td>Margaret Sanders</td>\n",
              "      <td>Company Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>814</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>815</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>816</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>817</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity China Accountant</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>818</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Accounting Director Approval</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-2c9a75b7-e0c7-4d74-8028-bfdc0678aef6')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-2c9a75b7-e0c7-4d74-8028-bfdc0678aef6 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-2c9a75b7-e0c7-4d74-8028-bfdc0678aef6');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 52
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Filter the df to those users that can create customers (Customers) and credit memos (Credit Memo)"
      ],
      "metadata": {
        "id": "c7JfIwU2ZfCI"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# filter the df to those users that can create customers (Customers) and credit memos (Credit Memo)\n",
        "vf = pd.unique(df[(df['Customers'] == \"Yes\") & (df['Credit Memo'] == \"Yes\")]['Name']).tolist()\n",
        "lf = df2[df2['Name'].isin(vf)][['Name', 'Role', 'Customers', 'Credit Memo']]\n",
        "lf"
      ],
      "metadata": {
        "id": "v7arijOUcG4c",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "outputId": "66caa1e4-db03-4b2d-ca67-51771c09fff9"
      },
      "execution_count": 53,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                  Name                                               Role  \\\n",
              "0         Aaron Cooper             Company Accounting - Controller - ODBC   \n",
              "1         Aaron Cooper            Company Accounting - Revenue Accountant   \n",
              "34          Amber Gray  Company Accounting - Dir of Shared Services - ...   \n",
              "35          Amber Gray  Company Accounting - Maint and Invoicing - Europe   \n",
              "36          Amber Gray                                    Custom EFT Role   \n",
              "44   Andrea Villarreal  Company Accounting - Maint and Invoicing - Europe   \n",
              "45   Andrea Villarreal                                    Custom EFT Role   \n",
              "46   Andrea Villarreal        Company Accounting - AP & Cash App - Europe   \n",
              "47   Andrea Villarreal                            Company Human Resources   \n",
              "48   Andrea Villarreal      Entity Accounting - Maintenance and Invoicing   \n",
              "49   Andrea Villarreal                            Fixed Assets Management   \n",
              "65   Antonio Cervantes     Company Accounting - Maintenance and Invoicing   \n",
              "119    Carla Walton MD      Entity Accounting - Maintenance and Invoicing   \n",
              "132      Charles Young                                    Custom EFT Role   \n",
              "133      Charles Young      Entity Accounting - Maintenance and Invoicing   \n",
              "134      Charles Young                  Entity Accounting - AP & Cash App   \n",
              "135      Charles Young                 Entity Director of Shared Services   \n",
              "136      Charles Young                     Entity Fixed Assets Management   \n",
              "161  Christopher Lynch          Company Accounting - Assistant Controller   \n",
              "162  Christopher Lynch                        Company Accounting - Celigo   \n",
              "163  Christopher Lynch                    Company Accounting - Controller   \n",
              "164  Christopher Lynch                    Company Fixed Assets Management   \n",
              "191      Crystal Jones          Company Accounting - Assistant Controller   \n",
              "256        Dylan Berry     Company Accounting - Maintenance and Invoicing   \n",
              "285         Gary Nolan     Company Accounting - Maintenance and Invoicing   \n",
              "286          Gary Wong     Company Accounting - Maintenance and Invoicing   \n",
              "378      Jessica Chase          Company Accounting - Assistant Controller   \n",
              "379      Jessica Chase                        Company Accounting - Celigo   \n",
              "380      Jessica Chase                    Company Fixed Assets Management   \n",
              "407    Jordan Martinez                             Entity Employee Center   \n",
              "408    Jordan Martinez      Entity Accounting - Maintenance and Invoicing   \n",
              "409    Jordan Martinez                        Entity Customer Service Rep   \n",
              "410    Jordan Martinez                        Entity Warehouse Operations   \n",
              "411    Jordan Martinez                               Entity Buyer/Planner   \n",
              "419     Joseph Harding                 Company Messenger Integration Role   \n",
              "420     Joseph Harding                              Company REST API Role   \n",
              "509      Laura Higgins             Company Accounting - Controller - ODBC   \n",
              "510      Laura Higgins          Company Accounting - Assistant Controller   \n",
              "511      Laura Higgins                        Company Accounting - Celigo   \n",
              "512      Laura Higgins                    Company Fixed Assets Management   \n",
              "513         Lauren Lin     Company Accounting - Maintenance and Invoicing   \n",
              "514         Lauren Lin  Company Accounting - Credit & Collections Manager   \n",
              "541        Maria Young        Company Shipping & Receiving Clerk - Europe   \n",
              "542        Maria Young  Company Accounting - Maint and Invoicing - Europe   \n",
              "547        Mary Wilson     Company Accounting - Maintenance and Invoicing   \n",
              "611  Mr. James Harding  Company Accounting - Maint and Invoicing - Europe   \n",
              "612  Mr. James Harding                                    Custom EFT Role   \n",
              "623       Natasha Moon                             Entity Employee Center   \n",
              "624       Natasha Moon      Entity Accounting - Maintenance and Invoicing   \n",
              "625       Natasha Moon                        Entity Customer Service Rep   \n",
              "626       Natasha Moon                        Entity Warehouse Operations   \n",
              "731       Sean Collins      Entity Accounting - Maintenance and Invoicing   \n",
              "732       Sean Collins                  Entity Accounting - AP & Cash App   \n",
              "733       Sean Collins                     Entity Fixed Assets Management   \n",
              "734       Sean Collins                            Entity China Accountant   \n",
              "814      Thomas Reeves      Entity Accounting - Maintenance and Invoicing   \n",
              "815      Thomas Reeves                 Entity Director of Shared Services   \n",
              "816      Thomas Reeves                     Entity Fixed Assets Management   \n",
              "817      Thomas Reeves                            Entity China Accountant   \n",
              "818      Thomas Reeves                Entity Accounting Director Approval   \n",
              "\n",
              "    Customers Credit Memo  \n",
              "0        View        View  \n",
              "1        Edit        Edit  \n",
              "34       View        View  \n",
              "35       Edit        Edit  \n",
              "36       View        View  \n",
              "44       Edit        Edit  \n",
              "45       View        View  \n",
              "46       Edit        View  \n",
              "47       None        None  \n",
              "48       Edit        Edit  \n",
              "49       View        None  \n",
              "65       Edit        Edit  \n",
              "119      Edit        Edit  \n",
              "132      View        View  \n",
              "133      Edit        Edit  \n",
              "134      Edit        View  \n",
              "135      View        View  \n",
              "136      View        None  \n",
              "161      Edit        Edit  \n",
              "162      Edit        Edit  \n",
              "163      Edit        Edit  \n",
              "164      View        None  \n",
              "191      Edit        Edit  \n",
              "256      Edit        Edit  \n",
              "285      Edit        Edit  \n",
              "286      Edit        Edit  \n",
              "378      Edit        Edit  \n",
              "379      Edit        Edit  \n",
              "380      View        None  \n",
              "407      None        None  \n",
              "408      Edit        Edit  \n",
              "409      Edit        View  \n",
              "410      View        None  \n",
              "411      View        None  \n",
              "419      None        None  \n",
              "420      Edit        Edit  \n",
              "509      View        View  \n",
              "510      Edit        Edit  \n",
              "511      Edit        Edit  \n",
              "512      View        None  \n",
              "513      Edit        Edit  \n",
              "514      Edit        Edit  \n",
              "541      View        None  \n",
              "542      Edit        Edit  \n",
              "547      Edit        Edit  \n",
              "611      Edit        Edit  \n",
              "612      View        View  \n",
              "623      None        None  \n",
              "624      Edit        Edit  \n",
              "625      Edit        View  \n",
              "626      View        None  \n",
              "731      Edit        Edit  \n",
              "732      Edit        View  \n",
              "733      View        None  \n",
              "734      View        View  \n",
              "814      Edit        Edit  \n",
              "815      View        View  \n",
              "816      View        None  \n",
              "817      View        View  \n",
              "818      None        None  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-7d76c1f1-c778-4c34-b8f5-ad19f7f03234\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Name</th>\n",
              "      <th>Role</th>\n",
              "      <th>Customers</th>\n",
              "      <th>Credit Memo</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Aaron Cooper</td>\n",
              "      <td>Company Accounting - Controller - ODBC</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Aaron Cooper</td>\n",
              "      <td>Company Accounting - Revenue Accountant</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Company Accounting - Dir of Shared Services - ...</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>Amber Gray</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Accounting - AP &amp; Cash App - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Company Human Resources</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>Andrea Villarreal</td>\n",
              "      <td>Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>Antonio Cervantes</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>119</th>\n",
              "      <td>Carla Walton MD</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>132</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>133</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>134</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>135</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>Charles Young</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>161</th>\n",
              "      <td>Christopher Lynch</td>\n",
              "      <td>Company Accounting - Assistant Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>162</th>\n",
              "      <td>Christopher Lynch</td>\n",
              "      <td>Company Accounting - Celigo</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>163</th>\n",
              "      <td>Christopher Lynch</td>\n",
              "      <td>Company Accounting - Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>164</th>\n",
              "      <td>Christopher Lynch</td>\n",
              "      <td>Company Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>191</th>\n",
              "      <td>Crystal Jones</td>\n",
              "      <td>Company Accounting - Assistant Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>256</th>\n",
              "      <td>Dylan Berry</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>285</th>\n",
              "      <td>Gary Nolan</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>286</th>\n",
              "      <td>Gary Wong</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>378</th>\n",
              "      <td>Jessica Chase</td>\n",
              "      <td>Company Accounting - Assistant Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>379</th>\n",
              "      <td>Jessica Chase</td>\n",
              "      <td>Company Accounting - Celigo</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>380</th>\n",
              "      <td>Jessica Chase</td>\n",
              "      <td>Company Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>407</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Employee Center</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>408</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>409</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Customer Service Rep</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>410</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Warehouse Operations</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>411</th>\n",
              "      <td>Jordan Martinez</td>\n",
              "      <td>Entity Buyer/Planner</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>419</th>\n",
              "      <td>Joseph Harding</td>\n",
              "      <td>Company Messenger Integration Role</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>420</th>\n",
              "      <td>Joseph Harding</td>\n",
              "      <td>Company REST API Role</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>509</th>\n",
              "      <td>Laura Higgins</td>\n",
              "      <td>Company Accounting - Controller - ODBC</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>510</th>\n",
              "      <td>Laura Higgins</td>\n",
              "      <td>Company Accounting - Assistant Controller</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>511</th>\n",
              "      <td>Laura Higgins</td>\n",
              "      <td>Company Accounting - Celigo</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>512</th>\n",
              "      <td>Laura Higgins</td>\n",
              "      <td>Company Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>513</th>\n",
              "      <td>Lauren Lin</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>514</th>\n",
              "      <td>Lauren Lin</td>\n",
              "      <td>Company Accounting - Credit &amp; Collections Manager</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>541</th>\n",
              "      <td>Maria Young</td>\n",
              "      <td>Company Shipping &amp; Receiving Clerk - Europe</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>542</th>\n",
              "      <td>Maria Young</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>547</th>\n",
              "      <td>Mary Wilson</td>\n",
              "      <td>Company Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>611</th>\n",
              "      <td>Mr. James Harding</td>\n",
              "      <td>Company Accounting - Maint and Invoicing - Europe</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>612</th>\n",
              "      <td>Mr. James Harding</td>\n",
              "      <td>Custom EFT Role</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>623</th>\n",
              "      <td>Natasha Moon</td>\n",
              "      <td>Entity Employee Center</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>624</th>\n",
              "      <td>Natasha Moon</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>625</th>\n",
              "      <td>Natasha Moon</td>\n",
              "      <td>Entity Customer Service Rep</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>626</th>\n",
              "      <td>Natasha Moon</td>\n",
              "      <td>Entity Warehouse Operations</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>731</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>732</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Accounting - AP &amp; Cash App</td>\n",
              "      <td>Edit</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>733</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>734</th>\n",
              "      <td>Sean Collins</td>\n",
              "      <td>Entity China Accountant</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>814</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Accounting - Maintenance and Invoicing</td>\n",
              "      <td>Edit</td>\n",
              "      <td>Edit</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>815</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Director of Shared Services</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>816</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Fixed Assets Management</td>\n",
              "      <td>View</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>817</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity China Accountant</td>\n",
              "      <td>View</td>\n",
              "      <td>View</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>818</th>\n",
              "      <td>Thomas Reeves</td>\n",
              "      <td>Entity Accounting Director Approval</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7d76c1f1-c778-4c34-b8f5-ad19f7f03234')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-7d76c1f1-c778-4c34-b8f5-ad19f7f03234 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-7d76c1f1-c778-4c34-b8f5-ad19f7f03234');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 53
        }
      ]
    }
  ]
}