PictForPython.ipynb

{
 "cells": [
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-02T01:41:25.557864Z",
     "start_time": "2024-06-02T01:41:24.941121Z"
    }
   },
   "cell_type": "code",
   "source": [
    "import pandas as pd\n",
    "import subprocess\n",
    "from io import StringIO"
   ],
   "id": "3f4c2dff9832abb6",
   "outputs": [],
   "execution_count": 1
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-02T01:41:30.811511Z",
     "start_time": "2024-06-02T01:41:25.560931Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# Documentação https://github.com/Microsoft/pict/blob/main/doc/pict.md\n",
    "command = \"./pict.exe ./possibilities.txt\"\n",
    "result = subprocess.run(command, shell=True, stdout=subprocess.PIPE, stderr=subprocess.PIPE, text=True)\n",
    "data = result.stdout\n",
    "df = pd.read_csv(StringIO(data), sep='\\t')"
   ],
   "id": "dded4d5850296650",
   "outputs": [],
   "execution_count": 2
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-02T01:41:30.825184Z",
     "start_time": "2024-06-02T01:41:30.812649Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# Constraints para as crianças\n",
    "df_filtered = df.query('(Children + Adult) <= 5')\n",
    "\n",
    "# Constraints para os adultos acima de 1 ano\n",
    "df_filtered = df_filtered.query('(Adult) > 0')"
   ],
   "id": "fccc627f4c6f50d5",
   "outputs": [],
   "execution_count": 3
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-02T01:41:30.852562Z",
     "start_time": "2024-06-02T01:41:30.827117Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# Tratamento dos dados da quantidade de pessoas\n",
    "def ajustar_idades_criancas(row):\n",
    "    num_criancas = row['Children']\n",
    "    for i in range(1, 5):\n",
    "        if i <= num_criancas:\n",
    "            continue\n",
    "        else:\n",
    "            row[f'ChildrenAge{i}'] = None\n",
    "    return row\n",
    "\n",
    "# Aplicar a função a cada linha do DataFrame\n",
    "df_filtered = df_filtered.apply(ajustar_idades_criancas, axis=1)"
   ],
   "id": "713954bcdf51ded8",
   "outputs": [],
   "execution_count": 4
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-02T01:41:30.857165Z",
     "start_time": "2024-06-02T01:41:30.854232Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# Lista de todos os mesed o ano\n",
    "todos_os_meses = [\"jun2024\", \"jul2024\", \"ago2024\", \"set2024\", \"out2024\", \"nov2024\", \"dez2024\", \"jan2025\", \"fev2025\",\n",
    "                  \"mar2025\", \"abr2025\", \"mai2025\", \"jun2025\", \"jul2025\", \"ago2025\", \"set2025\", \"out2025\", \"nov2025\"]\n",
    "\n",
    "# Lista padrão que todos precisam para fazer o teste\n",
    "colunas_padrao = ['Children', 'Adult', 'ChildrenAge1', 'ChildrenAge2', 'ChildrenAge3', 'ChildrenAge4', 'Accessibility Room']"
   ],
   "id": "d18b9471b56d6c32",
   "outputs": [],
   "execution_count": 5
  },
  {
   "metadata": {
    "ExecuteTime": {
     "end_time": "2024-06-02T01:41:30.882495Z",
     "start_time": "2024-06-02T01:41:30.858783Z"
    }
   },
   "cell_type": "code",
   "source": [
    "# Criar uma lista dos meses desejados\n",
    "meses_desejados = ['jun2024', 'jul2024', 'ago2024', 'set2024', 'mai2025', 'jun2025', 'jul2025', 'ago2025', 'set2025']\n",
    "locais_desejados = ['Vancouver (British Columbia), Canada']\n",
    "colunas = meses_desejados + locais_desejados + colunas_padrao\n",
    "\n",
    "# Aplicar filtro para cruzeiro específico de destino\n",
    "local_de_destinho = 'Alaska Cruises'\n",
    "df_filtered_cruise = df_filtered[df_filtered[local_de_destinho] == 'Checked'][colunas]\n",
    "\n",
    "# Exibir os resultados\n",
    "df_filtered_cruise"
   ],
   "id": "cb7f1e1a55af7eb0",
   "outputs": [
    {
     "data": {
      "text/plain": [
       "       jun2024    jul2024    ago2024    set2024    mai2025    jun2025  \\\n",
       "1    Unchecked    Checked  Unchecked  Unchecked  Unchecked    Checked   \n",
       "4      Checked    Checked    Checked  Unchecked    Checked    Checked   \n",
       "7      Checked    Checked    Checked  Unchecked  Unchecked    Checked   \n",
       "8      Checked  Unchecked  Unchecked    Checked  Unchecked    Checked   \n",
       "10   Unchecked    Checked  Unchecked    Checked    Checked    Checked   \n",
       "..         ...        ...        ...        ...        ...        ...   \n",
       "345    Checked  Unchecked    Checked    Checked    Checked    Checked   \n",
       "348    Checked  Unchecked  Unchecked    Checked    Checked  Unchecked   \n",
       "349  Unchecked  Unchecked    Checked    Checked  Unchecked  Unchecked   \n",
       "362    Checked    Checked    Checked  Unchecked  Unchecked    Checked   \n",
       "364    Checked  Unchecked    Checked  Unchecked    Checked    Checked   \n",
       "\n",
       "       jul2025    ago2025    set2025 Vancouver (British Columbia), Canada  \\\n",
       "1    Unchecked    Checked  Unchecked                              Checked   \n",
       "4    Unchecked  Unchecked  Unchecked                              Checked   \n",
       "7      Checked  Unchecked    Checked                            Unchecked   \n",
       "8      Checked  Unchecked  Unchecked                              Checked   \n",
       "10     Checked    Checked    Checked                              Checked   \n",
       "..         ...        ...        ...                                  ...   \n",
       "345    Checked    Checked    Checked                              Checked   \n",
       "348  Unchecked    Checked  Unchecked                              Checked   \n",
       "349  Unchecked    Checked    Checked                              Checked   \n",
       "362    Checked    Checked  Unchecked                            Unchecked   \n",
       "364  Unchecked    Checked    Checked                            Unchecked   \n",
       "\n",
       "     Children  Adult ChildrenAge1 ChildrenAge2 ChildrenAge3 ChildrenAge4  \\\n",
       "1           0      5         None         None         None         None   \n",
       "4           1      3           15         None         None         None   \n",
       "7           0      1         None         None         None         None   \n",
       "8           3      2            8            2            6         None   \n",
       "10          2      1           12           10         None         None   \n",
       "..        ...    ...          ...          ...          ...          ...   \n",
       "345         2      1           11            5         None         None   \n",
       "348         2      1           17            9         None         None   \n",
       "349         2      3            5            3         None         None   \n",
       "362         1      3       Infant         None         None         None   \n",
       "364         0      1         None         None         None         None   \n",
       "\n",
       "    Accessibility Room  \n",
       "1              Checked  \n",
       "4            Unchecked  \n",
       "7              Checked  \n",
       "8              Checked  \n",
       "10             Checked  \n",
       "..                 ...  \n",
       "345          Unchecked  \n",
       "348          Unchecked  \n",
       "349            Checked  \n",
       "362          Unchecked  \n",
       "364            Checked  \n",
       "\n",
       "[109 rows x 17 columns]"
      ],
      "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>jun2024</th>\n",
       "      <th>jul2024</th>\n",
       "      <th>ago2024</th>\n",
       "      <th>set2024</th>\n",
       "      <th>mai2025</th>\n",
       "      <th>jun2025</th>\n",
       "      <th>jul2025</th>\n",
       "      <th>ago2025</th>\n",
       "      <th>set2025</th>\n",
       "      <th>Vancouver (British Columbia), Canada</th>\n",
       "      <th>Children</th>\n",
       "      <th>Adult</th>\n",
       "      <th>ChildrenAge1</th>\n",
       "      <th>ChildrenAge2</th>\n",
       "      <th>ChildrenAge3</th>\n",
       "      <th>ChildrenAge4</th>\n",
       "      <th>Accessibility Room</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Checked</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Unchecked</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Checked</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>None</td>\n",
       "      <td>Checked</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Checked</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",
       "      <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>345</th>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Unchecked</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Unchecked</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Checked</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>362</th>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Infant</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Unchecked</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Checked</td>\n",
       "      <td>Unchecked</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>Checked</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>109 rows × 17 columns</p>\n",
       "</div>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "execution_count": 6
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}