Pandas/SQL-in-Jupyter.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "9da42ada",
   "metadata": {},
   "source": [
    "# Daily-Dose-of-Data-Science\n",
    "\n",
    "[Daily Dose of Data Science](https://avichawla.substack.com) is a publication on Substack that brings together intriguing frameworks, libraries, technologies, and tips that make the life cycle of a Data Science project effortless. \n",
    "\n",
    "Author: Avi Chawla\n",
    "\n",
    "[Medium](https://medium.com/@avi_chawla) | [LinkedIn](https://www.linkedin.com/in/avi-chawla/)\n",
    "\n",
    "# Use SQL in Jupyter To Analyze A Pandas DataFrame\n",
    "\n",
    "Post Link: [Substack](https://avichawla.substack.com/p/sql-in-jupyter)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "4bf2225f",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-12-15T12:52:00.992705Z",
     "start_time": "2022-12-15T12:51:57.458650Z"
    },
    "collapsed": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: duckdb in /Users/avi/anaconda3/lib/python3.9/site-packages (0.6.0)\r\n",
      "Requirement already satisfied: numpy>=1.14 in /Users/avi/anaconda3/lib/python3.9/site-packages (from duckdb) (1.21.5)\r\n"
     ]
    }
   ],
   "source": [
    "!pip install duckdb"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e1a3390a",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-12-15T12:52:03.607026Z",
     "start_time": "2022-12-15T12:52:02.639570Z"
    }
   },
   "outputs": [],
   "source": [
    "import duckdb\n",
    "dbcon = duckdb.connect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b3805a0e",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-12-15T12:55:59.659069Z",
     "start_time": "2022-12-15T12:55:59.466336Z"
    }
   },
   "outputs": [],
   "source": [
    "%load_ext sql"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "9d2a3927",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-12-15T12:56:05.807681Z",
     "start_time": "2022-12-15T12:56:05.608111Z"
    }
   },
   "outputs": [],
   "source": [
    "%config SqlMagic.autopandas = True\n",
    "%config SqlMagic.feedback = False\n",
    "%config SqlMagic.displaycon = False\n",
    "\n",
    "%sql duckdb:///:memory:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "efdccd68",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-12-15T12:55:52.027167Z",
     "start_time": "2022-12-15T12:55:52.006927Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "cbf85050",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-12-15T12:57:19.396609Z",
     "start_time": "2022-12-15T12:57:19.357895Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Company_Name</th>\n",
       "      <th>Employee_Job_Title</th>\n",
       "      <th>Employee_City</th>\n",
       "      <th>Employee_Country</th>\n",
       "      <th>Employee_Salary</th>\n",
       "      <th>Employment_Status</th>\n",
       "      <th>Employee_Rating</th>\n",
       "      <th>Credits</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Johnny Maynard</td>\n",
       "      <td>White, Mcclain and Cobb</td>\n",
       "      <td>Equities trader</td>\n",
       "      <td>New Cindychester</td>\n",
       "      <td>Mongolia</td>\n",
       "      <td>764340</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>3.3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Michael Williams</td>\n",
       "      <td>Scott Inc</td>\n",
       "      <td>Patent examiner</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Guinea-Bissau</td>\n",
       "      <td>929230</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Laura Flynn</td>\n",
       "      <td>Andrade LLC</td>\n",
       "      <td>Equities trader</td>\n",
       "      <td>North Melissafurt</td>\n",
       "      <td>Tonga</td>\n",
       "      <td>606900</td>\n",
       "      <td>Intern</td>\n",
       "      <td>0.3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Stefanie Archer</td>\n",
       "      <td>James and Sons</td>\n",
       "      <td>Retail merchandiser</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>San Marino</td>\n",
       "      <td>775380</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>2.8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Sierra Garcia</td>\n",
       "      <td>Matthews Inc</td>\n",
       "      <td>Armed forces logistics/support/administrative ...</td>\n",
       "      <td>Whitakerbury</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>944480</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>4.5</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Name             Company_Name  \\\n",
       "0    Johnny Maynard  White, Mcclain and Cobb   \n",
       "1  Michael Williams                Scott Inc   \n",
       "2       Laura Flynn              Andrade LLC   \n",
       "3   Stefanie Archer           James and Sons   \n",
       "4     Sierra Garcia             Matthews Inc   \n",
       "\n",
       "                                  Employee_Job_Title      Employee_City  \\\n",
       "0                                    Equities trader   New Cindychester   \n",
       "1                                    Patent examiner       Ricardomouth   \n",
       "2                                    Equities trader  North Melissafurt   \n",
       "3                                Retail merchandiser       Ricardomouth   \n",
       "4  Armed forces logistics/support/administrative ...       Whitakerbury   \n",
       "\n",
       "  Employee_Country  Employee_Salary Employment_Status  Employee_Rating  \\\n",
       "0         Mongolia           764340         Full Time              3.3   \n",
       "1    Guinea-Bissau           929230         Full Time              4.6   \n",
       "2            Tonga           606900            Intern              0.3   \n",
       "3       San Marino           775380         Full Time              2.8   \n",
       "4            Nepal           944480         Full Time              4.5   \n",
       "\n",
       "   Credits  \n",
       "0        1  \n",
       "1        4  \n",
       "2        3  \n",
       "3        5  \n",
       "4        4  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"../_Datasets/employee_dataset.csv\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "e2abbed6",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-12-15T12:57:30.359655Z",
     "start_time": "2022-12-15T12:57:30.331974Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Company_Name</th>\n",
       "      <th>Employee_Job_Title</th>\n",
       "      <th>Employee_City</th>\n",
       "      <th>Employee_Country</th>\n",
       "      <th>Employee_Salary</th>\n",
       "      <th>Employment_Status</th>\n",
       "      <th>Employee_Rating</th>\n",
       "      <th>Credits</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Michael Williams</td>\n",
       "      <td>Scott Inc</td>\n",
       "      <td>Patent examiner</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Guinea-Bissau</td>\n",
       "      <td>929230</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Stefanie Archer</td>\n",
       "      <td>James and Sons</td>\n",
       "      <td>Retail merchandiser</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>San Marino</td>\n",
       "      <td>775380</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>2.8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>Jodi Taylor</td>\n",
       "      <td>Scott Inc</td>\n",
       "      <td>Sales promotion account executive</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Palau</td>\n",
       "      <td>167290</td>\n",
       "      <td>Intern</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Kayla Lewis</td>\n",
       "      <td>Campos, Reynolds and Mccormick</td>\n",
       "      <td>Investment banker, corporate</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Haiti</td>\n",
       "      <td>16049</td>\n",
       "      <td>Intern</td>\n",
       "      <td>0.5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Dillon Davis</td>\n",
       "      <td>Johnston, Fleming and Tanner</td>\n",
       "      <td>Garment/textile technologist</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>386710</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>Charles West</td>\n",
       "      <td>Wallace, Smith and Shepard</td>\n",
       "      <td>Retail merchandiser</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>384000</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>Jeffrey Davis</td>\n",
       "      <td>Johnston, Fleming and Tanner</td>\n",
       "      <td>Regulatory affairs officer</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Niger</td>\n",
       "      <td>153100</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>Corey Davis</td>\n",
       "      <td>Nichols-James</td>\n",
       "      <td>Retail merchandiser</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>903340</td>\n",
       "      <td>Intern</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>Tanner Anderson</td>\n",
       "      <td>Taylor-Ramos</td>\n",
       "      <td>Armed forces logistics/support/administrative ...</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Yemen</td>\n",
       "      <td>15730</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>0.6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>Erica Robinson</td>\n",
       "      <td>Campos, Reynolds and Mccormick</td>\n",
       "      <td>Armed forces logistics/support/administrative ...</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Burundi</td>\n",
       "      <td>11800</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Name                    Company_Name  \\\n",
       "1    Michael Williams                       Scott Inc   \n",
       "3     Stefanie Archer                  James and Sons   \n",
       "46        Jodi Taylor                       Scott Inc   \n",
       "52        Kayla Lewis  Campos, Reynolds and Mccormick   \n",
       "69       Dillon Davis    Johnston, Fleming and Tanner   \n",
       "..                ...                             ...   \n",
       "971      Charles West      Wallace, Smith and Shepard   \n",
       "978     Jeffrey Davis    Johnston, Fleming and Tanner   \n",
       "985       Corey Davis                   Nichols-James   \n",
       "992   Tanner Anderson                    Taylor-Ramos   \n",
       "993    Erica Robinson  Campos, Reynolds and Mccormick   \n",
       "\n",
       "                                    Employee_Job_Title Employee_City  \\\n",
       "1                                      Patent examiner  Ricardomouth   \n",
       "3                                  Retail merchandiser  Ricardomouth   \n",
       "46                   Sales promotion account executive  Ricardomouth   \n",
       "52                        Investment banker, corporate  Ricardomouth   \n",
       "69                        Garment/textile technologist  Ricardomouth   \n",
       "..                                                 ...           ...   \n",
       "971                                Retail merchandiser  Ricardomouth   \n",
       "978                         Regulatory affairs officer  Ricardomouth   \n",
       "985                                Retail merchandiser  Ricardomouth   \n",
       "992  Armed forces logistics/support/administrative ...  Ricardomouth   \n",
       "993  Armed forces logistics/support/administrative ...  Ricardomouth   \n",
       "\n",
       "           Employee_Country  Employee_Salary Employment_Status  \\\n",
       "1             Guinea-Bissau           929230         Full Time   \n",
       "3                San Marino           775380         Full Time   \n",
       "46                    Palau           167290            Intern   \n",
       "52                    Haiti            16049            Intern   \n",
       "69   Bosnia and Herzegovina           386710         Full Time   \n",
       "..                      ...              ...               ...   \n",
       "971           Liechtenstein           384000         Full Time   \n",
       "978                   Niger           153100         Full Time   \n",
       "985          Czech Republic           903340            Intern   \n",
       "992                   Yemen            15730         Full Time   \n",
       "993                 Burundi            11800         Full Time   \n",
       "\n",
       "     Employee_Rating  Credits  \n",
       "1                4.6        4  \n",
       "3                2.8        5  \n",
       "46               3.3        3  \n",
       "52               0.5        3  \n",
       "69               2.5        3  \n",
       "..               ...      ...  \n",
       "971              3.0        5  \n",
       "978              4.1        4  \n",
       "985              4.7        4  \n",
       "992              0.6        4  \n",
       "993              2.3        2  \n",
       "\n",
       "[106 rows x 9 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.Employee_City == \"Ricardomouth\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "ae5d2699",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2022-12-15T12:57:43.797195Z",
     "start_time": "2022-12-15T12:57:43.729177Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Name</th>\n",
       "      <th>Company_Name</th>\n",
       "      <th>Employee_Job_Title</th>\n",
       "      <th>Employee_City</th>\n",
       "      <th>Employee_Country</th>\n",
       "      <th>Employee_Salary</th>\n",
       "      <th>Employment_Status</th>\n",
       "      <th>Employee_Rating</th>\n",
       "      <th>Credits</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Michael Williams</td>\n",
       "      <td>Scott Inc</td>\n",
       "      <td>Patent examiner</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Guinea-Bissau</td>\n",
       "      <td>929230</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>4.6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Stefanie Archer</td>\n",
       "      <td>James and Sons</td>\n",
       "      <td>Retail merchandiser</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>San Marino</td>\n",
       "      <td>775380</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>2.8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jodi Taylor</td>\n",
       "      <td>Scott Inc</td>\n",
       "      <td>Sales promotion account executive</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Palau</td>\n",
       "      <td>167290</td>\n",
       "      <td>Intern</td>\n",
       "      <td>3.3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Kayla Lewis</td>\n",
       "      <td>Campos, Reynolds and Mccormick</td>\n",
       "      <td>Investment banker, corporate</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Haiti</td>\n",
       "      <td>16049</td>\n",
       "      <td>Intern</td>\n",
       "      <td>0.5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Dillon Davis</td>\n",
       "      <td>Johnston, Fleming and Tanner</td>\n",
       "      <td>Garment/textile technologist</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Bosnia and Herzegovina</td>\n",
       "      <td>386710</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Charles West</td>\n",
       "      <td>Wallace, Smith and Shepard</td>\n",
       "      <td>Retail merchandiser</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Liechtenstein</td>\n",
       "      <td>384000</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Jeffrey Davis</td>\n",
       "      <td>Johnston, Fleming and Tanner</td>\n",
       "      <td>Regulatory affairs officer</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Niger</td>\n",
       "      <td>153100</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>4.1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Corey Davis</td>\n",
       "      <td>Nichols-James</td>\n",
       "      <td>Retail merchandiser</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Czech Republic</td>\n",
       "      <td>903340</td>\n",
       "      <td>Intern</td>\n",
       "      <td>4.7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Tanner Anderson</td>\n",
       "      <td>Taylor-Ramos</td>\n",
       "      <td>Armed forces logistics/support/administrative ...</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Yemen</td>\n",
       "      <td>15730</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>0.6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Erica Robinson</td>\n",
       "      <td>Campos, Reynolds and Mccormick</td>\n",
       "      <td>Armed forces logistics/support/administrative ...</td>\n",
       "      <td>Ricardomouth</td>\n",
       "      <td>Burundi</td>\n",
       "      <td>11800</td>\n",
       "      <td>Full Time</td>\n",
       "      <td>2.3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>106 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Name                    Company_Name  \\\n",
       "0    Michael Williams                       Scott Inc   \n",
       "1     Stefanie Archer                  James and Sons   \n",
       "2         Jodi Taylor                       Scott Inc   \n",
       "3         Kayla Lewis  Campos, Reynolds and Mccormick   \n",
       "4        Dillon Davis    Johnston, Fleming and Tanner   \n",
       "..                ...                             ...   \n",
       "101      Charles West      Wallace, Smith and Shepard   \n",
       "102     Jeffrey Davis    Johnston, Fleming and Tanner   \n",
       "103       Corey Davis                   Nichols-James   \n",
       "104   Tanner Anderson                    Taylor-Ramos   \n",
       "105    Erica Robinson  Campos, Reynolds and Mccormick   \n",
       "\n",
       "                                    Employee_Job_Title Employee_City  \\\n",
       "0                                      Patent examiner  Ricardomouth   \n",
       "1                                  Retail merchandiser  Ricardomouth   \n",
       "2                    Sales promotion account executive  Ricardomouth   \n",
       "3                         Investment banker, corporate  Ricardomouth   \n",
       "4                         Garment/textile technologist  Ricardomouth   \n",
       "..                                                 ...           ...   \n",
       "101                                Retail merchandiser  Ricardomouth   \n",
       "102                         Regulatory affairs officer  Ricardomouth   \n",
       "103                                Retail merchandiser  Ricardomouth   \n",
       "104  Armed forces logistics/support/administrative ...  Ricardomouth   \n",
       "105  Armed forces logistics/support/administrative ...  Ricardomouth   \n",
       "\n",
       "           Employee_Country  Employee_Salary Employment_Status  \\\n",
       "0             Guinea-Bissau           929230         Full Time   \n",
       "1                San Marino           775380         Full Time   \n",
       "2                     Palau           167290            Intern   \n",
       "3                     Haiti            16049            Intern   \n",
       "4    Bosnia and Herzegovina           386710         Full Time   \n",
       "..                      ...              ...               ...   \n",
       "101           Liechtenstein           384000         Full Time   \n",
       "102                   Niger           153100         Full Time   \n",
       "103          Czech Republic           903340            Intern   \n",
       "104                   Yemen            15730         Full Time   \n",
       "105                 Burundi            11800         Full Time   \n",
       "\n",
       "     Employee_Rating  Credits  \n",
       "0                4.6        4  \n",
       "1                2.8        5  \n",
       "2                3.3        3  \n",
       "3                0.5        3  \n",
       "4                2.5        3  \n",
       "..               ...      ...  \n",
       "101              3.0        5  \n",
       "102              4.1        4  \n",
       "103              4.7        4  \n",
       "104              0.6        4  \n",
       "105              2.3        2  \n",
       "\n",
       "[106 rows x 9 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "%%sql\n",
    "\n",
    "select * from df\n",
    "where Employee_City = 'Ricardomouth';"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "00ebf022",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}