{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Python Operators\n",
    "\n",
    "The table below shows what built-in Python operators correspond to\n",
    "in Excel when excelbird objects are used in arithmetic python expressions,\n",
    "i.e. ``product = my_row * my_col``. These rules apply for **any** excelbird object that can handle expressions - **Cell, Col/Row, Frame/VFrame**\n",
    "\n",
    "> Excelbird tries to mimic Excel syntax wherever possible, but in a handful of cases\n",
    "> this cannot be done. The most common example is the array range operator, `:`.\n",
    "> Where in Excel you'd use `a:b`, in excelbird use `a >> b`\n",
    "\n",
    "\n",
    "<style>\n",
    "    .dataframe {\n",
    "        font-size: 18px;\n",
    "    }\n",
    "    html[data-theme=dark] .dataframe code {\n",
    "        color: #A6A6A6 !important;\n",
    "    }\n",
    "    .dataframe code {\n",
    "        color: #013243 !important;\n",
    "    }\n",
    "    /* .testing tbody tr:nth-child(odd) {\n",
    "        background-color: var(--pst-color-border) !important;\n",
    "    } */\n",
    "    div.rendered_html table {\n",
    "        border: none;\n",
    "        border-collapse: collapse;\n",
    "        border-spacing: 0;\n",
    "        color: black;\n",
    "        font-size: 16px;\n",
    "        table-layout: fixed;\n",
    "        width: auto !important;\n",
    "        /* width: 400px !important; */\n",
    "    }\n",
    "    div.rendered_html table td {\n",
    "        min-width: 130px !important;\n",
    "    }\n",
    "    div.rendered_html.wider table td {\n",
    "        min-width: 180px !important;\n",
    "    }\n",
    "    div.rendered_html thead {\n",
    "        border-bottom: 1px solid black;\n",
    "        vertical-align: bottom;\n",
    "    }\n",
    "\n",
    "</style>\n",
    "\n",
    "\n",
    "<!-- REGEX MATCH: -->\n",
    "<!-- :%s/\\(`[^`]\\+`\\)--\\(`[^`]\\+`\\)--\"\\(.\\+\\)\"/<tr>\\r<td>\\1<\\/td>\\r<td>\\2<\\/td>\\r<td>\\3<\\/td>\\r<\\/tr>\\r -->\n",
    "\n",
    "The following are the **same** in excelbird and Excel\n",
    "\n",
    "<div class=\"output_area rendered_html docutils container\">\n",
    "<table class=\"dataframe\">\n",
    "<thead>\n",
    "<tr>\n",
    "<th class=\"code-item\">Python</th>\n",
    "<th class=\"code-item\">Excel</th>\n",
    "<th class=\"notes-item\"></th>\n",
    "</tr>\n",
    "</thead>\n",
    "<tbody>\n",
    "\n",
    "<tr>\n",
    "<td>`a > b`</td>\n",
    "<td>`a > b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a >= b`</td>\n",
    "<td>`a >= b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a + b`</td>\n",
    "<td>`a + b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a & b`</td>\n",
    "<td>`a & b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a - b`</td>\n",
    "<td>`a - b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a * b`</td>\n",
    "<td>`a * b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a / b`</td>\n",
    "<td>`a / b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a ^ b`</td>\n",
    "<td>`a ^ b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "</tbody>\n",
    "</table>\n",
    "</div>\n",
    "\n",
    "---\n",
    "\n",
    "The following are all **different** in excelbird and Excel\n",
    "\n",
    "<div class=\"output_area rendered_html docutils container\">\n",
    "<table class=\"dataframe\">\n",
    "<thead>\n",
    "<tr>\n",
    "<th class=\"code-item\">Python</th>\n",
    "<th class=\"code-item\">Excel</th>\n",
    "<th class=\"notes-item\"></th>\n",
    "</tr>\n",
    "</thead>\n",
    "<tbody>\n",
    "\n",
    "<tr>\n",
    "<td>`a >> b`</td>\n",
    "<td>`a : b`</td>\n",
    "<td></td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a == b`</td>\n",
    "<td>`a = b`</td>\n",
    "<td></td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a != b`</td>\n",
    "<td>`a <> b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a ** b`</td>\n",
    "<td>`a ^ b`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a | b`</td>\n",
    "<td>`OR(a, b)`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a % b`</td>\n",
    "<td>`MOD(a, b)`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`a % a`</td>\n",
    "<td>`a%`</td>\n",
    "<td>Notice same object is on each sides</td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`~ a`</td>\n",
    "<td>`NOT(a)`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "\n",
    "</tbody>\n",
    "</table>\n",
    "</div>\n",
    "\n",
    "---\n",
    "\n",
    "Built-in python functions work as well. **Note**: For `sum()`, you\n",
    "must place your element(s) inside a list, even if there is only one.\n",
    "\n",
    "<div class=\"output_area rendered_html docutils container wider\">\n",
    "<table class=\"dataframe\">\n",
    "<thead>\n",
    "<tr>\n",
    "<th>Python</th>\n",
    "<th>Excel</th>\n",
    "</tr>\n",
    "</thead>\n",
    "<tbody>\n",
    "\n",
    "<tr>\n",
    "<td>`sum(a)`</td>\n",
    "<td>`N/A`</td>\n",
    "<td>Don't do this. Pass list instead</td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`sum([a])`</td>\n",
    "<td>`SUM(a)`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`sum([a, b])`</td>\n",
    "<td>`SUM(a, b)`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`round(a, 2)`</td>\n",
    "<td>`ROUND(a, 2)`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`abs(a)`</td>\n",
    "<td>`ABS(a)`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`math.trunc(a)`</td>\n",
    "<td>`TRUNC(a)`</td>\n",
    "<td> </td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`math.floor(a)`</td>\n",
    "<td>`FLOOR(a, 1)`</td>\n",
    "<td>Excel's floor takes extra param.</td>\n",
    "</tr>\n",
    "\n",
    "<tr>\n",
    "<td>`math.ceil(a)`</td>\n",
    "<td>`CEILING(a, 1)`</td>\n",
    "<td>Excel's ceiling takes extra param.</td>\n",
    "</tr>\n",
    "\n",
    "\n",
    "\n",
    "</tbody>\n",
    "</table>\n",
    "</div>\n",
    "\n",
    "---\n"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "env",
   "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.11.1"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "6ee8c39a5e4f5a5ffe92ac0abdca1f10885ded7e28c74450614be57680931831"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}