pnl_value_code.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"authorship_tag":"ABX9TyMkn0hNmvlK0hnjQs/Otku3"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","execution_count":1,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"P31OESamAI1h","executionInfo":{"status":"ok","timestamp":1723188806670,"user_tz":420,"elapsed":21812,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"967ecff1-ef69-4dce-8531-7f56c5cb26b2"},"outputs":[{"output_type":"stream","name":"stdout","text":["Mounted at /content/drive\n"]}],"source":["#Xin cấp quyền máy ảo chạy vào GG drive\n","from google.colab import drive\n","drive.mount('/content/drive')"]},{"cell_type":"code","source":["import pandas as pd\n","import numpy as np"],"metadata":{"id":"4Zjkh_2wAx-E","executionInfo":{"status":"ok","timestamp":1723188810966,"user_tz":420,"elapsed":1169,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}}},"execution_count":2,"outputs":[]},{"cell_type":"code","source":["pnl_sample_df = pd.read_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/PnL.xlsx',sheet_name='pnl_sample')\n","pnl_sample_df.head()\n","#Fill NaN by ' '\n","pnl_sample_df.fillna('', inplace=True)\n","pnl_sample_df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":262},"id":"2tS5mqUOA32M","executionInfo":{"status":"ok","timestamp":1723188814263,"user_tz":420,"elapsed":1201,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"99e62d6d-b649-46cf-bbe9-364fc11a0fd6"},"execution_count":3,"outputs":[{"output_type":"stream","name":"stderr","text":["<ipython-input-3-bfc0f7b94ba0>:4: FutureWarning: Setting an item of incompatible dtype is deprecated and will raise in a future error of pandas. Value '' has dtype incompatible with float64, please explicitly cast to a compatible dtype first.\n","  pnl_sample_df.fillna('', inplace=True)\n"]},{"output_type":"execute_result","data":{"text/plain":["   Mã số                                           Chỉ tiêu Thuyết minh  \\\n","0      1          1. Doanh thu bán hàng và cung cấp dịch vụ       VI.25   \n","1      2                    2. Các khoản giảm trừ doanh thu               \n","2     10  3. Doanh thu thuần về bán hàng và cung cấp dịc...               \n","3     11                                4. Gía vốn hàng bán       VI.27   \n","4     20  5. Lợi nhuận gộp từ bán hàng và cung cấp dịch ...               \n","\n","  Kỳ này Kỳ trước Lũy kế(Năm nay) Lũy kế(Năm trước)  \n","0                                                    \n","1                                                    \n","2                                                    \n","3                                                    \n","4                                                    "],"text/html":["\n","  <div id=\"df-907b6eb0-bc51-4d92-ba54-a0049263ed52\" 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>Mã số</th>\n","      <th>Chỉ tiêu</th>\n","      <th>Thuyết minh</th>\n","      <th>Kỳ này</th>\n","      <th>Kỳ trước</th>\n","      <th>Lũy kế(Năm nay)</th>\n","      <th>Lũy kế(Năm trước)</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>1. Doanh thu bán hàng và cung cấp dịch vụ</td>\n","      <td>VI.25</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>2. Các khoản giảm trừ doanh thu</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>10</td>\n","      <td>3. Doanh thu thuần về bán hàng và cung cấp dịc...</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>11</td>\n","      <td>4. Gía vốn hàng bán</td>\n","      <td>VI.27</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>20</td>\n","      <td>5. Lợi nhuận gộp từ bán hàng và cung cấp dịch ...</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-907b6eb0-bc51-4d92-ba54-a0049263ed52')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-907b6eb0-bc51-4d92-ba54-a0049263ed52 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-907b6eb0-bc51-4d92-ba54-a0049263ed52');\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","\n","\n","<div id=\"df-fc5ad33d-8100-4ca5-b3ce-02e13b4c9089\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-fc5ad33d-8100-4ca5-b3ce-02e13b4c9089')\"\n","            title=\"Suggest charts\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-fc5ad33d-8100-4ca5-b3ce-02e13b4c9089 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"pnl_sample_df","summary":"{\n  \"name\": \"pnl_sample_df\",\n  \"rows\": 23,\n  \"fields\": [\n    {\n      \"column\": \"M\\u00e3 s\\u1ed1\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 21,\n        \"min\": 1,\n        \"max\": 71,\n        \"num_unique_values\": 23,\n        \"samples\": [\n          50,\n          25,\n          1\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Ch\\u1ec9 ti\\u00eau\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 23,\n        \"samples\": [\n          \"15. T\\u1ed5ng l\\u1ee3i nhu\\u1eadn tr\\u01b0\\u1edbc thu\\u1ebf (50 = 30 + 40)\",\n          \"9. Chi ph\\u00ed b\\u00e1n h\\u00e0ng\",\n          \"1. Doanh thu b\\u00e1n h\\u00e0ng v\\u00e0 cung c\\u1ea5p d\\u1ecbch v\\u1ee5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Thuy\\u1ebft minh\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"VI.25\",\n          \"\",\n          \"VI.30\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"K\\u1ef3 n\\u00e0y\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"K\\u1ef3 tr\\u01b0\\u1edbc\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L\\u0169y k\\u1ebf(N\\u0103m nay)\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L\\u0169y k\\u1ebf(N\\u0103m tr\\u01b0\\u1edbc)\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":3}]},{"cell_type":"markdown","source":["**Quý trong năm 2021**"],"metadata":{"id":"jTL39h4GBkgK"}},{"cell_type":"code","source":["quarter_2021_df = pd.read_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/PnL.xlsx',sheet_name='year 2021')\n","quarter_2021_df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"dU3rMjPNBoRz","executionInfo":{"status":"ok","timestamp":1723188818567,"user_tz":420,"elapsed":348,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"b5863adf-27be-47b3-dd92-2ecd23c58e93"},"execution_count":4,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                                            Chỉ tiêu   Quý 1- 2021  \\\n","0          1. Doanh thu bán hàng và cung cấp dịch vụ  3.590063e+11   \n","1                    2. Các khoản giảm trừ doanh thu           NaN   \n","2  3. Doanh thu thuần về bán hàng và cung cấp dịc...  3.590063e+11   \n","3                                4. Giá vốn hàng bán  2.622358e+11   \n","4  5. Lợi nhuận gộp về bán hàng và cung cấp dịch ...  9.677055e+10   \n","\n","    Quý 2- 2021   Quý 3- 2021   Quý 4- 2021  \n","0  4.492668e+11  4.756049e+11  6.714234e+11  \n","1           NaN           NaN           NaN  \n","2  4.492668e+11  4.756049e+11  6.714234e+11  \n","3  3.079875e+11  3.357696e+11  3.348648e+11  \n","4  1.412793e+11  1.398353e+11  3.365587e+11  "],"text/html":["\n","  <div id=\"df-7f291c48-001c-424e-a14e-fa606e1f1715\" 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>Chỉ tiêu</th>\n","      <th>Quý 1- 2021</th>\n","      <th>Quý 2- 2021</th>\n","      <th>Quý 3- 2021</th>\n","      <th>Quý 4- 2021</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1. Doanh thu bán hàng và cung cấp dịch vụ</td>\n","      <td>3.590063e+11</td>\n","      <td>4.492668e+11</td>\n","      <td>4.756049e+11</td>\n","      <td>6.714234e+11</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2. Các khoản giảm trừ doanh thu</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3. Doanh thu thuần về bán hàng và cung cấp dịc...</td>\n","      <td>3.590063e+11</td>\n","      <td>4.492668e+11</td>\n","      <td>4.756049e+11</td>\n","      <td>6.714234e+11</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4. Giá vốn hàng bán</td>\n","      <td>2.622358e+11</td>\n","      <td>3.079875e+11</td>\n","      <td>3.357696e+11</td>\n","      <td>3.348648e+11</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5. Lợi nhuận gộp về bán hàng và cung cấp dịch ...</td>\n","      <td>9.677055e+10</td>\n","      <td>1.412793e+11</td>\n","      <td>1.398353e+11</td>\n","      <td>3.365587e+11</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7f291c48-001c-424e-a14e-fa606e1f1715')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-7f291c48-001c-424e-a14e-fa606e1f1715 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-7f291c48-001c-424e-a14e-fa606e1f1715');\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","\n","\n","<div id=\"df-bec44c23-6fc8-4680-8b80-575bde2a7109\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-bec44c23-6fc8-4680-8b80-575bde2a7109')\"\n","            title=\"Suggest charts\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-bec44c23-6fc8-4680-8b80-575bde2a7109 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"quarter_2021_df","summary":"{\n  \"name\": \"quarter_2021_df\",\n  \"rows\": 23,\n  \"fields\": [\n    {\n      \"column\": \"Ch\\u1ec9 ti\\u00eau\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 23,\n        \"samples\": [\n          \"15. T\\u1ed5ng l\\u1ee3i nhu\\u1eadn k\\u1ebf to\\u00e1n tr\\u01b0\\u1edbc thu\\u1ebf(50=30+40)\",\n          \"9. Chi ph\\u00ed b\\u00e1n h\\u00e0ng\",\n          \"1. Doanh thu b\\u00e1n h\\u00e0ng v\\u00e0 cung c\\u1ea5p d\\u1ecbch v\\u1ee5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 1- 2021\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 114706090173.66063,\n        \"min\": 1324.0,\n        \"max\": 359006318695.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          359006318695.0,\n          262235767434.0,\n          79697016307.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 2- 2021\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 143912512909.03616,\n        \"min\": -3198600430.0,\n        \"max\": 449266808575.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          449266808575.0,\n          307987468765.0,\n          119595683192.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 3- 2021\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 153274554561.98395,\n        \"min\": 1841.0,\n        \"max\": 475604864604.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          475604864604.0,\n          335769570168.0,\n          119887692672.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 4- 2021\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 218374674562.34,\n        \"min\": 3945.0,\n        \"max\": 671423427439.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          671423427439.0,\n          334864757335.0,\n          322748043768.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":4}]},{"cell_type":"code","source":["#pnl_20210331\n","pnl_sample_df['Kỳ này']=quarter_2021_df['Quý 1- 2021']\n","pnl_20210331 = pnl_sample_df.copy()\n","pnl_20210331.head()\n","#pnl_20210630\n","pnl_sample_df['Kỳ này']=quarter_2021_df['Quý 2- 2021']\n","pnl_20210630 = pnl_sample_df.copy()\n","#pnl_20210930\n","pnl_sample_df['Kỳ này']=quarter_2021_df['Quý 3- 2021']\n","pnl_20210930 = pnl_sample_df.copy()\n","#pnl_20211231\n","pnl_sample_df['Kỳ này']=quarter_2021_df['Quý 4- 2021']\n","pnl_20211231 = pnl_sample_df.copy()"],"metadata":{"id":"G_kVex_iB45g","executionInfo":{"status":"ok","timestamp":1723188848138,"user_tz":420,"elapsed":320,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}}},"execution_count":5,"outputs":[]},{"cell_type":"markdown","source":["**Quý trong năm 2022**"],"metadata":{"id":"XiF5Fd0cCsrs"}},{"cell_type":"code","source":["quarter_2022_df = pd.read_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/PnL.xlsx',sheet_name='year 2022')\n","quarter_2022_df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"g2L7RILnC3il","executionInfo":{"status":"ok","timestamp":1723188851470,"user_tz":420,"elapsed":356,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"f07b0c7b-3e3a-49e7-f7d2-c1dc437497ac"},"execution_count":6,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                                            Chỉ tiêu   Quý 1- 2022  \\\n","0          1. Doanh thu bán hàng và cung cấp dịch vụ  6.524512e+11   \n","1                    2. Các khoản giảm trừ doanh thu           NaN   \n","2  3. Doanh thu thuần về bán hàng và cung cấp dịc...  6.524512e+11   \n","3                                4. Giá vốn hàng bán  3.124711e+11   \n","4  5. Lợi nhuận gộp về bán hàng và cung cấp dịch ...  3.399801e+11   \n","\n","    Quý 2- 2022   Quý 3- 2022   Quý 4- 2022  \n","0  9.292210e+11  7.785723e+11  8.453655e+11  \n","1           NaN           NaN           NaN  \n","2  9.292210e+11  7.785723e+11  8.453655e+11  \n","3  4.952052e+11  4.016990e+11  5.744898e+11  \n","4  4.340158e+11  3.768733e+11  2.708757e+11  "],"text/html":["\n","  <div id=\"df-327e6c71-b485-4148-a9bf-9b979434df68\" 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>Chỉ tiêu</th>\n","      <th>Quý 1- 2022</th>\n","      <th>Quý 2- 2022</th>\n","      <th>Quý 3- 2022</th>\n","      <th>Quý 4- 2022</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1. Doanh thu bán hàng và cung cấp dịch vụ</td>\n","      <td>6.524512e+11</td>\n","      <td>9.292210e+11</td>\n","      <td>7.785723e+11</td>\n","      <td>8.453655e+11</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2. Các khoản giảm trừ doanh thu</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3. Doanh thu thuần về bán hàng và cung cấp dịc...</td>\n","      <td>6.524512e+11</td>\n","      <td>9.292210e+11</td>\n","      <td>7.785723e+11</td>\n","      <td>8.453655e+11</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4. Giá vốn hàng bán</td>\n","      <td>3.124711e+11</td>\n","      <td>4.952052e+11</td>\n","      <td>4.016990e+11</td>\n","      <td>5.744898e+11</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5. Lợi nhuận gộp về bán hàng và cung cấp dịch ...</td>\n","      <td>3.399801e+11</td>\n","      <td>4.340158e+11</td>\n","      <td>3.768733e+11</td>\n","      <td>2.708757e+11</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-327e6c71-b485-4148-a9bf-9b979434df68')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-327e6c71-b485-4148-a9bf-9b979434df68 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-327e6c71-b485-4148-a9bf-9b979434df68');\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","\n","\n","<div id=\"df-48c351ee-992e-4188-8fbc-e726f03ee223\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-48c351ee-992e-4188-8fbc-e726f03ee223')\"\n","            title=\"Suggest charts\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-48c351ee-992e-4188-8fbc-e726f03ee223 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"quarter_2022_df","summary":"{\n  \"name\": \"quarter_2022_df\",\n  \"rows\": 23,\n  \"fields\": [\n    {\n      \"column\": \"Ch\\u1ec9 ti\\u00eau\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 23,\n        \"samples\": [\n          \"15. T\\u1ed5ng l\\u1ee3i nhu\\u1eadn k\\u1ebf to\\u00e1n tr\\u01b0\\u1edbc thu\\u1ebf(50=30+40)\",\n          \"9. Chi ph\\u00ed b\\u00e1n h\\u00e0ng\",\n          \"1. Doanh thu b\\u00e1n h\\u00e0ng v\\u00e0 cung c\\u1ea5p d\\u1ecbch v\\u1ee5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 1- 2022\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 213109230560.81354,\n        \"min\": 3836.0,\n        \"max\": 652451203036.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          652451203036.0,\n          312471135599.0,\n          320165894969.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 2- 2022\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 299004933097.5,\n        \"min\": -19110418342.0,\n        \"max\": 929221008140.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          929221008140.0,\n          495205225043.0,\n          415434859198.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 3- 2022\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 250582512105.18155,\n        \"min\": -12801572152.0,\n        \"max\": 778572254585.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          778572254585.0,\n          401698978553.0,\n          347039584535.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 4- 2022\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 269038508159.09134,\n        \"min\": -188941016.0,\n        \"max\": 845365455294.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          845365455294.0,\n          574489804568.0,\n          230479974397.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":6}]},{"cell_type":"code","source":["#pnl_20220331\n","pnl_sample_df['Kỳ này']=quarter_2022_df['Quý 1- 2022']\n","pnl_20220331 = pnl_sample_df.copy()\n","#pnl_20220630\n","pnl_sample_df['Kỳ này']=quarter_2022_df['Quý 2- 2022']\n","pnl_20220630 = pnl_sample_df.copy()\n","#pnl_20220930\n","pnl_sample_df['Kỳ này']=quarter_2022_df['Quý 3- 2022']\n","pnl_20220930 = pnl_sample_df.copy()\n","#pnl_20221231\n","pnl_sample_df['Kỳ này']=quarter_2022_df['Quý 4- 2022']\n","pnl_20221231 = pnl_sample_df.copy()\n","pnl_20221231.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"ykvKAYVcDWJX","executionInfo":{"status":"ok","timestamp":1723188876579,"user_tz":420,"elapsed":332,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"7d2e5754-227e-41d3-8864-2c516dece7d0"},"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   Mã số                                           Chỉ tiêu Thuyết minh  \\\n","0      1          1. Doanh thu bán hàng và cung cấp dịch vụ       VI.25   \n","1      2                    2. Các khoản giảm trừ doanh thu               \n","2     10  3. Doanh thu thuần về bán hàng và cung cấp dịc...               \n","3     11                                4. Gía vốn hàng bán       VI.27   \n","4     20  5. Lợi nhuận gộp từ bán hàng và cung cấp dịch ...               \n","\n","         Kỳ này Kỳ trước Lũy kế(Năm nay) Lũy kế(Năm trước)  \n","0  8.453655e+11                                             \n","1           NaN                                             \n","2  8.453655e+11                                             \n","3  5.744898e+11                                             \n","4  2.708757e+11                                             "],"text/html":["\n","  <div id=\"df-883df199-66a7-4012-bb22-68f56d305f67\" 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>Mã số</th>\n","      <th>Chỉ tiêu</th>\n","      <th>Thuyết minh</th>\n","      <th>Kỳ này</th>\n","      <th>Kỳ trước</th>\n","      <th>Lũy kế(Năm nay)</th>\n","      <th>Lũy kế(Năm trước)</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>1. Doanh thu bán hàng và cung cấp dịch vụ</td>\n","      <td>VI.25</td>\n","      <td>8.453655e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>2. Các khoản giảm trừ doanh thu</td>\n","      <td></td>\n","      <td>NaN</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>10</td>\n","      <td>3. Doanh thu thuần về bán hàng và cung cấp dịc...</td>\n","      <td></td>\n","      <td>8.453655e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>11</td>\n","      <td>4. Gía vốn hàng bán</td>\n","      <td>VI.27</td>\n","      <td>5.744898e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>20</td>\n","      <td>5. Lợi nhuận gộp từ bán hàng và cung cấp dịch ...</td>\n","      <td></td>\n","      <td>2.708757e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-883df199-66a7-4012-bb22-68f56d305f67')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-883df199-66a7-4012-bb22-68f56d305f67 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-883df199-66a7-4012-bb22-68f56d305f67');\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","\n","\n","<div id=\"df-4c07c54e-2375-464d-9e62-1051506bd372\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-4c07c54e-2375-464d-9e62-1051506bd372')\"\n","            title=\"Suggest charts\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-4c07c54e-2375-464d-9e62-1051506bd372 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"pnl_20221231","summary":"{\n  \"name\": \"pnl_20221231\",\n  \"rows\": 23,\n  \"fields\": [\n    {\n      \"column\": \"M\\u00e3 s\\u1ed1\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 21,\n        \"min\": 1,\n        \"max\": 71,\n        \"num_unique_values\": 23,\n        \"samples\": [\n          50,\n          25,\n          1\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Ch\\u1ec9 ti\\u00eau\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 23,\n        \"samples\": [\n          \"15. T\\u1ed5ng l\\u1ee3i nhu\\u1eadn tr\\u01b0\\u1edbc thu\\u1ebf (50 = 30 + 40)\",\n          \"9. Chi ph\\u00ed b\\u00e1n h\\u00e0ng\",\n          \"1. Doanh thu b\\u00e1n h\\u00e0ng v\\u00e0 cung c\\u1ea5p d\\u1ecbch v\\u1ee5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Thuy\\u1ebft minh\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"VI.25\",\n          \"\",\n          \"VI.30\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"K\\u1ef3 n\\u00e0y\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 269038508159.09134,\n        \"min\": -188941016.0,\n        \"max\": 845365455294.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          845365455294.0,\n          574489804568.0,\n          230479974397.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"K\\u1ef3 tr\\u01b0\\u1edbc\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L\\u0169y k\\u1ebf(N\\u0103m nay)\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L\\u0169y k\\u1ebf(N\\u0103m tr\\u01b0\\u1edbc)\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":7}]},{"cell_type":"markdown","source":["**Quý trong năm 2023**"],"metadata":{"id":"88hLMOuqFcv5"}},{"cell_type":"code","source":["quarter_2023_df = pd.read_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/PnL.xlsx',sheet_name='year 2023')\n","quarter_2023_df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"UzJUJ-m6FfrM","executionInfo":{"status":"ok","timestamp":1723188881613,"user_tz":420,"elapsed":313,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"af7aecab-333f-470b-ba4f-5d462285c199"},"execution_count":8,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                                            Chỉ tiêu   Quý 1- 2023  \\\n","0          1. Doanh thu bán hàng và cung cấp dịch vụ  6.551415e+11   \n","1                    2. Các khoản giảm trừ doanh thu           NaN   \n","2  3. Doanh thu thuần về bán hàng và cung cấp dịc...  6.551415e+11   \n","3                                4. Giá vốn hàng bán  4.626867e+11   \n","4  5. Lợi nhuận gộp về bán hàng và cung cấp dịch ...  1.924548e+11   \n","\n","    Quý 2- 2023   Quý 3- 2023   Quý 4- 2023  \n","0  6.114235e+11  6.813604e+11  6.647643e+11  \n","1           NaN           NaN           NaN  \n","2  6.114235e+11  6.813604e+11  6.647643e+11  \n","3  4.642443e+11  5.231369e+11  5.516168e+11  \n","4  1.471792e+11  1.582236e+11  1.131475e+11  "],"text/html":["\n","  <div id=\"df-8b2f3e5d-710f-4774-b78a-3197d0d9d9da\" 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>Chỉ tiêu</th>\n","      <th>Quý 1- 2023</th>\n","      <th>Quý 2- 2023</th>\n","      <th>Quý 3- 2023</th>\n","      <th>Quý 4- 2023</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1. Doanh thu bán hàng và cung cấp dịch vụ</td>\n","      <td>6.551415e+11</td>\n","      <td>6.114235e+11</td>\n","      <td>6.813604e+11</td>\n","      <td>6.647643e+11</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2. Các khoản giảm trừ doanh thu</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3. Doanh thu thuần về bán hàng và cung cấp dịc...</td>\n","      <td>6.551415e+11</td>\n","      <td>6.114235e+11</td>\n","      <td>6.813604e+11</td>\n","      <td>6.647643e+11</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4. Giá vốn hàng bán</td>\n","      <td>4.626867e+11</td>\n","      <td>4.642443e+11</td>\n","      <td>5.231369e+11</td>\n","      <td>5.516168e+11</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5. Lợi nhuận gộp về bán hàng và cung cấp dịch ...</td>\n","      <td>1.924548e+11</td>\n","      <td>1.471792e+11</td>\n","      <td>1.582236e+11</td>\n","      <td>1.131475e+11</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8b2f3e5d-710f-4774-b78a-3197d0d9d9da')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-8b2f3e5d-710f-4774-b78a-3197d0d9d9da 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-8b2f3e5d-710f-4774-b78a-3197d0d9d9da');\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","\n","\n","<div id=\"df-ce4d5209-8f3a-47e3-b412-36bfea3a9551\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-ce4d5209-8f3a-47e3-b412-36bfea3a9551')\"\n","            title=\"Suggest charts\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-ce4d5209-8f3a-47e3-b412-36bfea3a9551 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"quarter_2023_df","summary":"{\n  \"name\": \"quarter_2023_df\",\n  \"rows\": 23,\n  \"fields\": [\n    {\n      \"column\": \"Ch\\u1ec9 ti\\u00eau\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 23,\n        \"samples\": [\n          \"15. T\\u1ed5ng l\\u1ee3i nhu\\u1eadn k\\u1ebf to\\u00e1n tr\\u01b0\\u1edbc thu\\u1ebf(50=30+40)\",\n          \"9. Chi ph\\u00ed b\\u00e1n h\\u00e0ng\",\n          \"1. Doanh thu b\\u00e1n h\\u00e0ng v\\u00e0 cung c\\u1ea5p d\\u1ecbch v\\u1ee5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 1- 2023\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 210480827251.0242,\n        \"min\": 1588.0,\n        \"max\": 655141507370.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          655141507370.0,\n          462686693770.0,\n          150724691005.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 2- 2023\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 199759753750.1868,\n        \"min\": -16799438024.0,\n        \"max\": 611423483517.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          611423483517.0,\n          464244290822.0,\n          108822686637.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 3- 2023\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 221815204953.5315,\n        \"min\": 922.0,\n        \"max\": 681360441155.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          681360441155.0,\n          523136859205.0,\n          131700597930.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 4- 2023\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 222777115681.62357,\n        \"min\": -10415567079.0,\n        \"max\": 664764301616.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          664764301616.0,\n          551616816677.0,\n          69212452170.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":8}]},{"cell_type":"code","source":["#pnl_20230331\n","pnl_sample_df['Kỳ này']=quarter_2023_df['Quý 1- 2023']\n","pnl_20230331 = pnl_sample_df.copy()\n","#pnl_20230630\n","pnl_sample_df['Kỳ này']=quarter_2023_df['Quý 2- 2023']\n","pnl_20230630 = pnl_sample_df.copy()\n","#pnl_20220930\n","pnl_sample_df['Kỳ này']=quarter_2023_df['Quý 3- 2023']\n","pnl_20230930 = pnl_sample_df.copy()\n","#pnl_20221231\n","pnl_sample_df['Kỳ này']=quarter_2023_df['Quý 4- 2023']\n","pnl_20231231 = pnl_sample_df.copy()\n","pnl_20231231.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"fTx9QHAQFpzy","executionInfo":{"status":"ok","timestamp":1723188970672,"user_tz":420,"elapsed":311,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"211140fb-c236-473a-df10-2dac2f782da1"},"execution_count":12,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   Mã số                                           Chỉ tiêu Thuyết minh  \\\n","0      1          1. Doanh thu bán hàng và cung cấp dịch vụ       VI.25   \n","1      2                    2. Các khoản giảm trừ doanh thu               \n","2     10  3. Doanh thu thuần về bán hàng và cung cấp dịc...               \n","3     11                                4. Gía vốn hàng bán       VI.27   \n","4     20  5. Lợi nhuận gộp từ bán hàng và cung cấp dịch ...               \n","\n","         Kỳ này Kỳ trước Lũy kế(Năm nay) Lũy kế(Năm trước)  \n","0  6.647643e+11                                             \n","1           NaN                                             \n","2  6.647643e+11                                             \n","3  5.516168e+11                                             \n","4  1.131475e+11                                             "],"text/html":["\n","  <div id=\"df-3546827e-0ced-44b8-a4b1-ed6f5fded381\" 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>Mã số</th>\n","      <th>Chỉ tiêu</th>\n","      <th>Thuyết minh</th>\n","      <th>Kỳ này</th>\n","      <th>Kỳ trước</th>\n","      <th>Lũy kế(Năm nay)</th>\n","      <th>Lũy kế(Năm trước)</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>1. Doanh thu bán hàng và cung cấp dịch vụ</td>\n","      <td>VI.25</td>\n","      <td>6.647643e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>2. Các khoản giảm trừ doanh thu</td>\n","      <td></td>\n","      <td>NaN</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>10</td>\n","      <td>3. Doanh thu thuần về bán hàng và cung cấp dịc...</td>\n","      <td></td>\n","      <td>6.647643e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>11</td>\n","      <td>4. Gía vốn hàng bán</td>\n","      <td>VI.27</td>\n","      <td>5.516168e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>20</td>\n","      <td>5. Lợi nhuận gộp từ bán hàng và cung cấp dịch ...</td>\n","      <td></td>\n","      <td>1.131475e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3546827e-0ced-44b8-a4b1-ed6f5fded381')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-3546827e-0ced-44b8-a4b1-ed6f5fded381 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-3546827e-0ced-44b8-a4b1-ed6f5fded381');\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","\n","\n","<div id=\"df-8b7a063a-ed40-4f12-8301-33a0a5fcae11\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-8b7a063a-ed40-4f12-8301-33a0a5fcae11')\"\n","            title=\"Suggest charts\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-8b7a063a-ed40-4f12-8301-33a0a5fcae11 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"pnl_20231231","summary":"{\n  \"name\": \"pnl_20231231\",\n  \"rows\": 23,\n  \"fields\": [\n    {\n      \"column\": \"M\\u00e3 s\\u1ed1\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 21,\n        \"min\": 1,\n        \"max\": 71,\n        \"num_unique_values\": 23,\n        \"samples\": [\n          50,\n          25,\n          1\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Ch\\u1ec9 ti\\u00eau\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 23,\n        \"samples\": [\n          \"15. T\\u1ed5ng l\\u1ee3i nhu\\u1eadn tr\\u01b0\\u1edbc thu\\u1ebf (50 = 30 + 40)\",\n          \"9. Chi ph\\u00ed b\\u00e1n h\\u00e0ng\",\n          \"1. Doanh thu b\\u00e1n h\\u00e0ng v\\u00e0 cung c\\u1ea5p d\\u1ecbch v\\u1ee5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Thuy\\u1ebft minh\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"VI.25\",\n          \"\",\n          \"VI.30\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"K\\u1ef3 n\\u00e0y\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 222777115681.62357,\n        \"min\": -10415567079.0,\n        \"max\": 664764301616.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          664764301616.0,\n          551616816677.0,\n          69212452170.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"K\\u1ef3 tr\\u01b0\\u1edbc\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L\\u0169y k\\u1ebf(N\\u0103m nay)\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L\\u0169y k\\u1ebf(N\\u0103m tr\\u01b0\\u1edbc)\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":12}]},{"cell_type":"markdown","source":["**Quý trong năm 2024**"],"metadata":{"id":"K89QbHT9F6Lp"}},{"cell_type":"code","source":["quarter_2024_df = pd.read_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/PnL.xlsx',sheet_name='year 2024')\n","quarter_2024_df.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"geDzBAQVF86b","executionInfo":{"status":"ok","timestamp":1723188986528,"user_tz":420,"elapsed":316,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"97a9692a-e9a4-4205-ac71-e67d4d2ca9f5"},"execution_count":13,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                                            Chỉ tiêu   Quý 1- 2024  \\\n","0          1. Doanh thu bán hàng và cung cấp dịch vụ  7.041011e+11   \n","1                    2. Các khoản giảm trừ doanh thu           NaN   \n","2  3. Doanh thu thuần về bán hàng và cung cấp dịc...  7.041011e+11   \n","3                                4. Giá vốn hàng bán  5.978567e+11   \n","4  5. Lợi nhuận gộp về bán hàng và cung cấp dịch ...  1.062444e+11   \n","\n","    Quý 2- 2024  \n","0  9.487856e+11  \n","1           NaN  \n","2  9.487856e+11  \n","3  6.988943e+11  \n","4  2.498913e+11  "],"text/html":["\n","  <div id=\"df-f2734a6a-0879-4180-b495-74382147f74e\" 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>Chỉ tiêu</th>\n","      <th>Quý 1- 2024</th>\n","      <th>Quý 2- 2024</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1. Doanh thu bán hàng và cung cấp dịch vụ</td>\n","      <td>7.041011e+11</td>\n","      <td>9.487856e+11</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2. Các khoản giảm trừ doanh thu</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3. Doanh thu thuần về bán hàng và cung cấp dịc...</td>\n","      <td>7.041011e+11</td>\n","      <td>9.487856e+11</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4. Giá vốn hàng bán</td>\n","      <td>5.978567e+11</td>\n","      <td>6.988943e+11</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5. Lợi nhuận gộp về bán hàng và cung cấp dịch ...</td>\n","      <td>1.062444e+11</td>\n","      <td>2.498913e+11</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f2734a6a-0879-4180-b495-74382147f74e')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-f2734a6a-0879-4180-b495-74382147f74e 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-f2734a6a-0879-4180-b495-74382147f74e');\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","\n","\n","<div id=\"df-796926c4-4ccd-42d2-8f74-2888054ec94b\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-796926c4-4ccd-42d2-8f74-2888054ec94b')\"\n","            title=\"Suggest charts\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-796926c4-4ccd-42d2-8f74-2888054ec94b button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"quarter_2024_df","summary":"{\n  \"name\": \"quarter_2024_df\",\n  \"rows\": 23,\n  \"fields\": [\n    {\n      \"column\": \"Ch\\u1ec9 ti\\u00eau\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 23,\n        \"samples\": [\n          \"15. T\\u1ed5ng l\\u1ee3i nhu\\u1eadn k\\u1ebf to\\u00e1n tr\\u01b0\\u1edbc thu\\u1ebf(50=30+40)\",\n          \"9. Chi ph\\u00ed b\\u00e1n h\\u00e0ng\",\n          \"1. Doanh thu b\\u00e1n h\\u00e0ng v\\u00e0 cung c\\u1ea5p d\\u1ecbch v\\u1ee5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 1- 2024\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 237812544236.26556,\n        \"min\": -11909597455.0,\n        \"max\": 704101114408.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          704101114408.0,\n          597856715279.0,\n          66844624644.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Qu\\u00fd 2- 2024\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 307734410117.5397,\n        \"min\": -1475280870.0,\n        \"max\": 948785573107.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          948785573107.0,\n          698894294932.0,\n          172818555285.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":13}]},{"cell_type":"code","source":["#pnl_20240331\n","pnl_sample_df['Kỳ này']=quarter_2024_df['Quý 1- 2024']\n","pnl_20240331 = pnl_sample_df.copy()\n","#pnl_20240631\n","pnl_sample_df['Kỳ này']=quarter_2024_df['Quý 2- 2024']\n","pnl_20240630 = pnl_sample_df.copy()\n","pnl_20240630.head()"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":206},"id":"KnPTD349GJON","executionInfo":{"status":"ok","timestamp":1723188989936,"user_tz":420,"elapsed":347,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}},"outputId":"af7ed496-2655-4674-bb02-03cc2f5b22ec"},"execution_count":14,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   Mã số                                           Chỉ tiêu Thuyết minh  \\\n","0      1          1. Doanh thu bán hàng và cung cấp dịch vụ       VI.25   \n","1      2                    2. Các khoản giảm trừ doanh thu               \n","2     10  3. Doanh thu thuần về bán hàng và cung cấp dịc...               \n","3     11                                4. Gía vốn hàng bán       VI.27   \n","4     20  5. Lợi nhuận gộp từ bán hàng và cung cấp dịch ...               \n","\n","         Kỳ này Kỳ trước Lũy kế(Năm nay) Lũy kế(Năm trước)  \n","0  9.487856e+11                                             \n","1           NaN                                             \n","2  9.487856e+11                                             \n","3  6.988943e+11                                             \n","4  2.498913e+11                                             "],"text/html":["\n","  <div id=\"df-f3a9d85d-d60f-4daf-a7ab-cfa99ab7319f\" 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>Mã số</th>\n","      <th>Chỉ tiêu</th>\n","      <th>Thuyết minh</th>\n","      <th>Kỳ này</th>\n","      <th>Kỳ trước</th>\n","      <th>Lũy kế(Năm nay)</th>\n","      <th>Lũy kế(Năm trước)</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>1. Doanh thu bán hàng và cung cấp dịch vụ</td>\n","      <td>VI.25</td>\n","      <td>9.487856e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2</td>\n","      <td>2. Các khoản giảm trừ doanh thu</td>\n","      <td></td>\n","      <td>NaN</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>10</td>\n","      <td>3. Doanh thu thuần về bán hàng và cung cấp dịc...</td>\n","      <td></td>\n","      <td>9.487856e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>11</td>\n","      <td>4. Gía vốn hàng bán</td>\n","      <td>VI.27</td>\n","      <td>6.988943e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>20</td>\n","      <td>5. Lợi nhuận gộp từ bán hàng và cung cấp dịch ...</td>\n","      <td></td>\n","      <td>2.498913e+11</td>\n","      <td></td>\n","      <td></td>\n","      <td></td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","    <div class=\"colab-df-buttons\">\n","\n","  <div class=\"colab-df-container\">\n","    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-f3a9d85d-d60f-4daf-a7ab-cfa99ab7319f')\"\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 -960 960 960\">\n","    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n","  </svg>\n","    </button>\n","\n","  <style>\n","    .colab-df-container {\n","      display:flex;\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","    .colab-df-buttons div {\n","      margin-bottom: 4px;\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-f3a9d85d-d60f-4daf-a7ab-cfa99ab7319f 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-f3a9d85d-d60f-4daf-a7ab-cfa99ab7319f');\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","\n","\n","<div id=\"df-71b9f969-c5e1-493d-8399-ca081a0df6e2\">\n","  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-71b9f969-c5e1-493d-8399-ca081a0df6e2')\"\n","            title=\"Suggest charts\"\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","    <g>\n","        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n","    </g>\n","</svg>\n","  </button>\n","\n","<style>\n","  .colab-df-quickchart {\n","      --bg-color: #E8F0FE;\n","      --fill-color: #1967D2;\n","      --hover-bg-color: #E2EBFA;\n","      --hover-fill-color: #174EA6;\n","      --disabled-fill-color: #AAA;\n","      --disabled-bg-color: #DDD;\n","  }\n","\n","  [theme=dark] .colab-df-quickchart {\n","      --bg-color: #3B4455;\n","      --fill-color: #D2E3FC;\n","      --hover-bg-color: #434B5C;\n","      --hover-fill-color: #FFFFFF;\n","      --disabled-bg-color: #3B4455;\n","      --disabled-fill-color: #666;\n","  }\n","\n","  .colab-df-quickchart {\n","    background-color: var(--bg-color);\n","    border: none;\n","    border-radius: 50%;\n","    cursor: pointer;\n","    display: none;\n","    fill: var(--fill-color);\n","    height: 32px;\n","    padding: 0;\n","    width: 32px;\n","  }\n","\n","  .colab-df-quickchart:hover {\n","    background-color: var(--hover-bg-color);\n","    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n","    fill: var(--button-hover-fill-color);\n","  }\n","\n","  .colab-df-quickchart-complete:disabled,\n","  .colab-df-quickchart-complete:disabled:hover {\n","    background-color: var(--disabled-bg-color);\n","    fill: var(--disabled-fill-color);\n","    box-shadow: none;\n","  }\n","\n","  .colab-df-spinner {\n","    border: 2px solid var(--fill-color);\n","    border-color: transparent;\n","    border-bottom-color: var(--fill-color);\n","    animation:\n","      spin 1s steps(1) infinite;\n","  }\n","\n","  @keyframes spin {\n","    0% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","      border-left-color: var(--fill-color);\n","    }\n","    20% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    30% {\n","      border-color: transparent;\n","      border-left-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","      border-right-color: var(--fill-color);\n","    }\n","    40% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-top-color: var(--fill-color);\n","    }\n","    60% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","    }\n","    80% {\n","      border-color: transparent;\n","      border-right-color: var(--fill-color);\n","      border-bottom-color: var(--fill-color);\n","    }\n","    90% {\n","      border-color: transparent;\n","      border-bottom-color: var(--fill-color);\n","    }\n","  }\n","</style>\n","\n","  <script>\n","    async function quickchart(key) {\n","      const quickchartButtonEl =\n","        document.querySelector('#' + key + ' button');\n","      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n","      quickchartButtonEl.classList.add('colab-df-spinner');\n","      try {\n","        const charts = await google.colab.kernel.invokeFunction(\n","            'suggestCharts', [key], {});\n","      } catch (error) {\n","        console.error('Error during call to suggestCharts:', error);\n","      }\n","      quickchartButtonEl.classList.remove('colab-df-spinner');\n","      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n","    }\n","    (() => {\n","      let quickchartButtonEl =\n","        document.querySelector('#df-71b9f969-c5e1-493d-8399-ca081a0df6e2 button');\n","      quickchartButtonEl.style.display =\n","        google.colab.kernel.accessAllowed ? 'block' : 'none';\n","    })();\n","  </script>\n","</div>\n","\n","    </div>\n","  </div>\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"pnl_20240630","summary":"{\n  \"name\": \"pnl_20240630\",\n  \"rows\": 23,\n  \"fields\": [\n    {\n      \"column\": \"M\\u00e3 s\\u1ed1\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 21,\n        \"min\": 1,\n        \"max\": 71,\n        \"num_unique_values\": 23,\n        \"samples\": [\n          50,\n          25,\n          1\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Ch\\u1ec9 ti\\u00eau\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 23,\n        \"samples\": [\n          \"15. T\\u1ed5ng l\\u1ee3i nhu\\u1eadn tr\\u01b0\\u1edbc thu\\u1ebf (50 = 30 + 40)\",\n          \"9. Chi ph\\u00ed b\\u00e1n h\\u00e0ng\",\n          \"1. Doanh thu b\\u00e1n h\\u00e0ng v\\u00e0 cung c\\u1ea5p d\\u1ecbch v\\u1ee5\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Thuy\\u1ebft minh\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 6,\n        \"samples\": [\n          \"VI.25\",\n          \"\",\n          \"VI.30\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"K\\u1ef3 n\\u00e0y\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 307734410117.5397,\n        \"min\": -1475280870.0,\n        \"max\": 948785573107.0,\n        \"num_unique_values\": 18,\n        \"samples\": [\n          948785573107.0,\n          698894294932.0,\n          172818555285.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"K\\u1ef3 tr\\u01b0\\u1edbc\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L\\u0169y k\\u1ebf(N\\u0103m nay)\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"L\\u0169y k\\u1ebf(N\\u0103m tr\\u01b0\\u1edbc)\",\n      \"properties\": {\n        \"dtype\": \"object\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"}},"metadata":{},"execution_count":14}]},{"cell_type":"code","source":["#Lưu vào file excel\n","pnl_20210331.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20210331.xlsx',index=False)\n","pnl_20210630.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20210630.xlsx',index=False)\n","pnl_20210930.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20210930.xlsx',index=False)\n","pnl_20211231.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20211231.xlsx',index=False)\n","pnl_20220331.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20220331.xlsx',index=False)\n","pnl_20220630.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20220630.xlsx',index=False)\n","pnl_20220930.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20220930.xlsx',index=False)\n","pnl_20221231.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20221231.xlsx',index=False)\n","pnl_20230331.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20230331.xlsx',index=False)\n","pnl_20230630.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20230630.xlsx',index=False)\n","pnl_20230930.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20230930.xlsx',index=False)\n","pnl_20231231.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20231231.xlsx',index=False)\n","pnl_20240331.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20240331.xlsx',index=False)\n","pnl_20240630.to_excel('/content/drive/MyDrive/CTCP Vận tải và xếp dỡ Hải An/Báo cáo kết quả hoạt động kinh doanh/pnl_20240630.xlsx',index=False)\n"],"metadata":{"id":"ImrN-wrAGSKA","executionInfo":{"status":"ok","timestamp":1723189041830,"user_tz":420,"elapsed":301,"user":{"displayName":"Nguễn NAm","userId":"04347634520201467535"}}},"execution_count":15,"outputs":[]}]}