reza.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ArezaB/Copulas/blob/master/reza.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "I7FeoyhmqoXp"
      },
      "outputs": [],
      "source": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "PGSChKuIoiQW"
      },
      "source": [
        "**Learning Altair**\n",
        "\n",
        "I am going to learn how to work with Altair\n"
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "1-NADKAM0hVX"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import files\n",
        "\n",
        "uploaded = files.upload()\n",
        "\n",
        "for fn in uploaded.keys():\n",
        "  print('User uploaded file \"{name}\" with length {length} bytes'.format(\n",
        "      name=fn, length=len(uploaded[fn])))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 108
        },
        "id": "iuOEmpGr0nbh",
        "outputId": "f054fd6d-9ac5-48f7-a0ff-2d867e58ffe4"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ],
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-a570c237-67f2-4667-861c-c13dfb93f62d\" name=\"files[]\" multiple disabled\n",
              "        style=\"border:none\" />\n",
              "     <output id=\"result-a570c237-67f2-4667-861c-c13dfb93f62d\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script>// Copyright 2017 Google LLC\n",
              "//\n",
              "// Licensed under the Apache License, Version 2.0 (the \"License\");\n",
              "// you may not use this file except in compliance with the License.\n",
              "// You may obtain a copy of the License at\n",
              "//\n",
              "//      http://www.apache.org/licenses/LICENSE-2.0\n",
              "//\n",
              "// Unless required by applicable law or agreed to in writing, software\n",
              "// distributed under the License is distributed on an \"AS IS\" BASIS,\n",
              "// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n",
              "// See the License for the specific language governing permissions and\n",
              "// limitations under the License.\n",
              "\n",
              "/**\n",
              " * @fileoverview Helpers for google.colab Python module.\n",
              " */\n",
              "(function(scope) {\n",
              "function span(text, styleAttributes = {}) {\n",
              "  const element = document.createElement('span');\n",
              "  element.textContent = text;\n",
              "  for (const key of Object.keys(styleAttributes)) {\n",
              "    element.style[key] = styleAttributes[key];\n",
              "  }\n",
              "  return element;\n",
              "}\n",
              "\n",
              "// Max number of bytes which will be uploaded at a time.\n",
              "const MAX_PAYLOAD_SIZE = 100 * 1024;\n",
              "\n",
              "function _uploadFiles(inputId, outputId) {\n",
              "  const steps = uploadFilesStep(inputId, outputId);\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  // Cache steps on the outputElement to make it available for the next call\n",
              "  // to uploadFilesContinue from Python.\n",
              "  outputElement.steps = steps;\n",
              "\n",
              "  return _uploadFilesContinue(outputId);\n",
              "}\n",
              "\n",
              "// This is roughly an async generator (not supported in the browser yet),\n",
              "// where there are multiple asynchronous steps and the Python side is going\n",
              "// to poll for completion of each step.\n",
              "// This uses a Promise to block the python side on completion of each step,\n",
              "// then passes the result of the previous step as the input to the next step.\n",
              "function _uploadFilesContinue(outputId) {\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  const steps = outputElement.steps;\n",
              "\n",
              "  const next = steps.next(outputElement.lastPromiseValue);\n",
              "  return Promise.resolve(next.value.promise).then((value) => {\n",
              "    // Cache the last promise value to make it available to the next\n",
              "    // step of the generator.\n",
              "    outputElement.lastPromiseValue = value;\n",
              "    return next.value.response;\n",
              "  });\n",
              "}\n",
              "\n",
              "/**\n",
              " * Generator function which is called between each async step of the upload\n",
              " * process.\n",
              " * @param {string} inputId Element ID of the input file picker element.\n",
              " * @param {string} outputId Element ID of the output display.\n",
              " * @return {!Iterable<!Object>} Iterable of next steps.\n",
              " */\n",
              "function* uploadFilesStep(inputId, outputId) {\n",
              "  const inputElement = document.getElementById(inputId);\n",
              "  inputElement.disabled = false;\n",
              "\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  outputElement.innerHTML = '';\n",
              "\n",
              "  const pickedPromise = new Promise((resolve) => {\n",
              "    inputElement.addEventListener('change', (e) => {\n",
              "      resolve(e.target.files);\n",
              "    });\n",
              "  });\n",
              "\n",
              "  const cancel = document.createElement('button');\n",
              "  inputElement.parentElement.appendChild(cancel);\n",
              "  cancel.textContent = 'Cancel upload';\n",
              "  const cancelPromise = new Promise((resolve) => {\n",
              "    cancel.onclick = () => {\n",
              "      resolve(null);\n",
              "    };\n",
              "  });\n",
              "\n",
              "  // Wait for the user to pick the files.\n",
              "  const files = yield {\n",
              "    promise: Promise.race([pickedPromise, cancelPromise]),\n",
              "    response: {\n",
              "      action: 'starting',\n",
              "    }\n",
              "  };\n",
              "\n",
              "  cancel.remove();\n",
              "\n",
              "  // Disable the input element since further picks are not allowed.\n",
              "  inputElement.disabled = true;\n",
              "\n",
              "  if (!files) {\n",
              "    return {\n",
              "      response: {\n",
              "        action: 'complete',\n",
              "      }\n",
              "    };\n",
              "  }\n",
              "\n",
              "  for (const file of files) {\n",
              "    const li = document.createElement('li');\n",
              "    li.append(span(file.name, {fontWeight: 'bold'}));\n",
              "    li.append(span(\n",
              "        `(${file.type || 'n/a'}) - ${file.size} bytes, ` +\n",
              "        `last modified: ${\n",
              "            file.lastModifiedDate ? file.lastModifiedDate.toLocaleDateString() :\n",
              "                                    'n/a'} - `));\n",
              "    const percent = span('0% done');\n",
              "    li.appendChild(percent);\n",
              "\n",
              "    outputElement.appendChild(li);\n",
              "\n",
              "    const fileDataPromise = new Promise((resolve) => {\n",
              "      const reader = new FileReader();\n",
              "      reader.onload = (e) => {\n",
              "        resolve(e.target.result);\n",
              "      };\n",
              "      reader.readAsArrayBuffer(file);\n",
              "    });\n",
              "    // Wait for the data to be ready.\n",
              "    let fileData = yield {\n",
              "      promise: fileDataPromise,\n",
              "      response: {\n",
              "        action: 'continue',\n",
              "      }\n",
              "    };\n",
              "\n",
              "    // Use a chunked sending to avoid message size limits. See b/62115660.\n",
              "    let position = 0;\n",
              "    do {\n",
              "      const length = Math.min(fileData.byteLength - position, MAX_PAYLOAD_SIZE);\n",
              "      const chunk = new Uint8Array(fileData, position, length);\n",
              "      position += length;\n",
              "\n",
              "      const base64 = btoa(String.fromCharCode.apply(null, chunk));\n",
              "      yield {\n",
              "        response: {\n",
              "          action: 'append',\n",
              "          file: file.name,\n",
              "          data: base64,\n",
              "        },\n",
              "      };\n",
              "\n",
              "      let percentDone = fileData.byteLength === 0 ?\n",
              "          100 :\n",
              "          Math.round((position / fileData.byteLength) * 100);\n",
              "      percent.textContent = `${percentDone}% done`;\n",
              "\n",
              "    } while (position < fileData.byteLength);\n",
              "  }\n",
              "\n",
              "  // All done.\n",
              "  yield {\n",
              "    response: {\n",
              "      action: 'complete',\n",
              "    }\n",
              "  };\n",
              "}\n",
              "\n",
              "scope.google = scope.google || {};\n",
              "scope.google.colab = scope.google.colab || {};\n",
              "scope.google.colab._files = {\n",
              "  _uploadFiles,\n",
              "  _uploadFilesContinue,\n",
              "};\n",
              "})(self);\n",
              "</script> "
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Saving rezadata.xlsx to rezadata.xlsx\n",
            "User uploaded file \"rezadata.xlsx\" with length 14042 bytes\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 369
        },
        "id": "pj57ureZof-5",
        "outputId": "372b7976-09e9-421c-f7e7-f5808a2b64c2"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "\n",
              "<div id=\"altair-viz-221c7e5ff8274d3a9102fcfe6cd488f3\"></div>\n",
              "<script type=\"text/javascript\">\n",
              "  var VEGA_DEBUG = (typeof VEGA_DEBUG == \"undefined\") ? {} : VEGA_DEBUG;\n",
              "  (function(spec, embedOpt){\n",
              "    let outputDiv = document.currentScript.previousElementSibling;\n",
              "    if (outputDiv.id !== \"altair-viz-221c7e5ff8274d3a9102fcfe6cd488f3\") {\n",
              "      outputDiv = document.getElementById(\"altair-viz-221c7e5ff8274d3a9102fcfe6cd488f3\");\n",
              "    }\n",
              "    const paths = {\n",
              "      \"vega\": \"https://cdn.jsdelivr.net/npm//vega@5?noext\",\n",
              "      \"vega-lib\": \"https://cdn.jsdelivr.net/npm//vega-lib?noext\",\n",
              "      \"vega-lite\": \"https://cdn.jsdelivr.net/npm//vega-lite@4.17.0?noext\",\n",
              "      \"vega-embed\": \"https://cdn.jsdelivr.net/npm//vega-embed@6?noext\",\n",
              "    };\n",
              "\n",
              "    function maybeLoadScript(lib, version) {\n",
              "      var key = `${lib.replace(\"-\", \"\")}_version`;\n",
              "      return (VEGA_DEBUG[key] == version) ?\n",
              "        Promise.resolve(paths[lib]) :\n",
              "        new Promise(function(resolve, reject) {\n",
              "          var s = document.createElement('script');\n",
              "          document.getElementsByTagName(\"head\")[0].appendChild(s);\n",
              "          s.async = true;\n",
              "          s.onload = () => {\n",
              "            VEGA_DEBUG[key] = version;\n",
              "            return resolve(paths[lib]);\n",
              "          };\n",
              "          s.onerror = () => reject(`Error loading script: ${paths[lib]}`);\n",
              "          s.src = paths[lib];\n",
              "        });\n",
              "    }\n",
              "\n",
              "    function showError(err) {\n",
              "      outputDiv.innerHTML = `<div class=\"error\" style=\"color:red;\">${err}</div>`;\n",
              "      throw err;\n",
              "    }\n",
              "\n",
              "    function displayChart(vegaEmbed) {\n",
              "      vegaEmbed(outputDiv, spec, embedOpt)\n",
              "        .catch(err => showError(`Javascript Error: ${err.message}<br>This usually means there's a typo in your chart specification. See the javascript console for the full traceback.`));\n",
              "    }\n",
              "\n",
              "    if(typeof define === \"function\" && define.amd) {\n",
              "      requirejs.config({paths});\n",
              "      require([\"vega-embed\"], displayChart, err => showError(`Error loading script: ${err.message}`));\n",
              "    } else {\n",
              "      maybeLoadScript(\"vega\", \"5\")\n",
              "        .then(() => maybeLoadScript(\"vega-lite\", \"4.17.0\"))\n",
              "        .then(() => maybeLoadScript(\"vega-embed\", \"6\"))\n",
              "        .catch(showError)\n",
              "        .then(() => displayChart(vegaEmbed));\n",
              "    }\n",
              "  })({\"config\": {\"view\": {\"continuousWidth\": 400, \"continuousHeight\": 300}}, \"data\": {\"name\": \"data-a3bf37431e987cf50722130c2873c034\"}, \"mark\": \"point\", \"encoding\": {\"x\": {\"field\": \"YT\", \"type\": \"quantitative\"}, \"y\": {\"field\": \"K\", \"type\": \"quantitative\"}}, \"selection\": {\"selector002\": {\"type\": \"interval\", \"bind\": \"scales\", \"encodings\": [\"x\", \"y\"]}}, \"$schema\": \"https://vega.github.io/schema/vega-lite/v4.17.0.json\", \"datasets\": {\"data-a3bf37431e987cf50722130c2873c034\": [{\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"river\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"station\", \"\\u0643\\u062f\": \"code\", \"\\u0633\\u0627\\u0644\": \"sal\", \"\\u0622\\u0628\\u06cc\": \"abi\", \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": \"peak_debi\", \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": null, \"Unnamed: 8\": null, \"T\": 2.0, \"YT\": 0.367, \"Y\\u0304N\": 0.5481, \"SN\": 1.159, \"K\": -0.15625539257981022, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": \"Q2\", \"Unnamed: 17\": 36.73136265525274}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1348, \"\\u0622\\u0628\\u06cc\": 49, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 11.2, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1062.600332528113, \"Unnamed: 8\": null, \"T\": 5.0, \"YT\": 1.5, \"Y\\u0304N\": 0.5481, \"SN\": 1.159, \"K\": 0.8213114754098361, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": \"Q5\", \"Unnamed: 17\": 80.93893536492195}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1349, \"\\u0622\\u0628\\u06cc\": 50, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 9.94, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1146.333761099542, \"Unnamed: 8\": null, \"T\": 10.0, \"YT\": 2.25, \"Y\\u0304N\": 0.5481, \"SN\": 1.159, \"K\": 1.4684210526315788, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": \"Q10\", \"Unnamed: 17\": 110.2025536634673}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1350, \"\\u0622\\u0628\\u06cc\": 51, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 61.6, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 316.92718967097045, \"Unnamed: 8\": null, \"T\": 50.0, \"YT\": 3.902, \"Y\\u0304N\": 0.5481, \"SN\": 1.159, \"K\": 2.8937877480586716, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": \"Q50\", \"Unnamed: 17\": 174.66055023572994}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1351, \"\\u0622\\u0628\\u06cc\": 52, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 6.12, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1419.5978508954604, \"Unnamed: 8\": null, \"T\": 100.0, \"YT\": 4.6, \"Y\\u0304N\": 0.5481, \"SN\": 1.159, \"K\": 3.4960310612597065, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": \"Q100\", \"Unnamed: 17\": 201.89522433224278}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1352, \"\\u0622\\u0628\\u06cc\": 53, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 68, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 585.7585366097459, \"Unnamed: 8\": null, \"T\": 200.0, \"YT\": 5.296, \"Y\\u0304N\": 0.5481, \"SN\": 1.159, \"K\": 4.096548748921484, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": \"Q200\", \"Unnamed: 17\": 229.05186211329288}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1353, \"\\u0622\\u0628\\u06cc\": 54, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 12.6, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 973.2871896709704, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1354, \"\\u0622\\u0628\\u06cc\": 55, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 6.32, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1404.566830487297, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1355, \"\\u0622\\u0628\\u06cc\": 56, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 10.79, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1089.498424364848, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1356, \"\\u0622\\u0628\\u06cc\": 57, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 18.3, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 650.1251080383174, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1357, \"\\u0622\\u0628\\u06cc\": 58, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 13.5, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 917.9415978342358, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1358, \"\\u0622\\u0628\\u06cc\": 59, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 10.4, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1115.3964141607664, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1359, \"\\u0622\\u0628\\u06cc\": 60, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 38.4, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 29.133557017909233, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1360, \"\\u0622\\u0628\\u06cc\": 61, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 13.5, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 917.9415978342358, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1361, \"\\u0622\\u0628\\u06cc\": 62, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 17.5, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 691.5611896709705, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1362, \"\\u0622\\u0628\\u06cc\": 63, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 25.5, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 334.80037334443983, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1363, \"\\u0622\\u0628\\u06cc\": 64, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 132, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 7779.6720059975005, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1364, \"\\u0622\\u0628\\u06cc\": 65, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 61, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 295.9242508954602, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1365, \"\\u0622\\u0628\\u06cc\": 66, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 6.33, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1403.817379466889, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1366, \"\\u0622\\u0628\\u06cc\": 67, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 6.28, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1407.5666345689297, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1367, \"\\u0622\\u0628\\u06cc\": 68, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 93.9, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 2510.2553937526036, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1368, \"\\u0622\\u0628\\u06cc\": 69, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 19.9, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 571.0929447730114, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1369, \"\\u0622\\u0628\\u06cc\": 70, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 30, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 190.37241416076637, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1370, \"\\u0622\\u0628\\u06cc\": 71, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 181, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 18824.512005997505, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1371, \"\\u0622\\u0628\\u06cc\": 72, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 23.4, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 416.0600876301542, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1372, \"\\u0622\\u0628\\u06cc\": 73, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 118, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 5506.003434568929, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1373, \"\\u0622\\u0628\\u06cc\": 74, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 18.2, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 655.234618242399, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1374, \"\\u0622\\u0628\\u06cc\": 75, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 200, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 24399.205067221996, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1375, \"\\u0622\\u0628\\u06cc\": 76, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 14.6, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 852.4969855893378, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1376, \"\\u0622\\u0628\\u06cc\": 77, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 150, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 11278.960169262808, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1377, \"\\u0622\\u0628\\u06cc\": 78, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 72, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 795.3781284464806, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1378, \"\\u0622\\u0628\\u06cc\": 79, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 41, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 7.826291711786761, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1379, \"\\u0622\\u0628\\u06cc\": 80, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 32.3, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 132.19367946688888, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1380, \"\\u0622\\u0628\\u06cc\": 81, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 18, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 665.5136386505624, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1381, \"\\u0622\\u0628\\u06cc\": 82, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 22.5, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 453.58567946688885, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1382, \"\\u0622\\u0628\\u06cc\": 83, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 17.3, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 702.1202100791337, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1383, \"\\u0622\\u0628\\u06cc\": 84, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 44, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 0.04098558933777547, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1384, \"\\u0622\\u0628\\u06cc\": 85, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 16.9, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 723.4782508954604, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1385, \"\\u0622\\u0628\\u06cc\": 86, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 50.5, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 44.922822324031635, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1386, \"\\u0622\\u0628\\u06cc\": 87, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 47.9, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 16.830087630154082, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1387, \"\\u0622\\u0628\\u06cc\": 88, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 13.1, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 942.3396386505623, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1388, \"\\u0622\\u0628\\u06cc\": 89, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 62.3, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 342.3406182423989, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1389, \"\\u0622\\u0628\\u06cc\": 90, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 35, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 77.39690395668474, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1390, \"\\u0622\\u0628\\u06cc\": 91, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 37, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 46.206699875052074, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1391, \"\\u0622\\u0628\\u06cc\": 92, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 65, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 449.5438427321949, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1392, \"\\u0622\\u0628\\u06cc\": 93, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 27, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 282.1577202832154, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1393, \"\\u0622\\u0628\\u06cc\": 94, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 11, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1075.6793529362767, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1394, \"\\u0622\\u0628\\u06cc\": 95, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 100, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 3158.7152713036235, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1395, \"\\u0622\\u0628\\u06cc\": 96, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 50, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 38.4703733444398, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": \"\\u0686\\u0647\\u0644 \\u0686\\u0627\\u064a\", \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": \"\\u0644\\u0632\\u0648\\u0631\\u0647\", \"\\u0643\\u062f\": \"12-013\", \"\\u0633\\u0627\\u0644\": 1396, \"\\u0622\\u0628\\u06cc\": 97, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 5, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 1505.2499651811745, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": null, \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": null, \"\\u0643\\u062f\": null, \"\\u0633\\u0627\\u0644\": null, \"\\u0622\\u0628\\u06cc\": null, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 43.797551020408164, \"Unnamed: 6\": null, \"(Xi-X\\u0304)^2\": 2045.0333368596418, \"Unnamed: 8\": \"Variance\", \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}, {\"\\u0631\\u0648\\u062f\\u062e\\u0627\\u0646\\u0647\": null, \"\\u0627\\u064a\\u0633\\u062a\\u06af\\u0627\\u0647\": null, \"\\u0643\\u062f\": null, \"\\u0633\\u0627\\u0644\": null, \"\\u0622\\u0628\\u06cc\": null, \" \\u062d\\u062f\\u0627\\u0643\\u062b\\u0631 \\u0644\\u062d\\u0638\\u0647 \\u0627\\u064a\": 45.69067955332048, \"Unnamed: 6\": \"Standard Deviation\", \"(Xi-X\\u0304)^2\": 45.22204481068544, \"Unnamed: 8\": null, \"T\": null, \"YT\": null, \"Y\\u0304N\": null, \"SN\": null, \"K\": null, \"Unnamed: 14\": null, \"Unnamed: 15\": null, \"Unnamed: 16\": null, \"Unnamed: 17\": null}]}}, {\"mode\": \"vega-lite\"});\n",
              "</script>"
            ],
            "text/plain": [
              "alt.Chart(...)"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ],
      "source": [
        "#@title Default title text\n",
        "import pandas as pd\n",
        "\n",
        "df = pd.read_excel(r'rezadata.xlsx')\n",
        "import altair as alt\n",
        "alt.Chart(df).mark_point().encode(\n",
        "    x='YT',\n",
        "    y='K',\n",
        "   \n",
        ").interactive()"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "ls"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "5tsuKQ5FUkJv",
        "outputId": "490d5436-cba9-4955-8f6d-e3d72e4e809c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "rezadata.xlsx  \u001b[0m\u001b[01;34msample_data\u001b[0m/\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pd.read_excel('rezadata.xlsx').head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 357
        },
        "id": "O1b8uTtg16dW",
        "outputId": "84708b52-9591-4ac1-d8ae-5859e6dc221b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   رودخانه  ايستگاه      كد   سال  آبی  حداكثر لحظه اي Unnamed: 6  \\\n",
              "0    river  station    code   sal  abi       peak_debi        NaN   \n",
              "1  چهل چاي    لزوره  12-013  1348   49            11.2        NaN   \n",
              "2  چهل چاي    لزوره  12-013  1349   50            9.94        NaN   \n",
              "3  چهل چاي    لزوره  12-013  1350   51            61.6        NaN   \n",
              "4  چهل چاي    لزوره  12-013  1351   52            6.12        NaN   \n",
              "\n",
              "     (Xi-X̄)^2 Unnamed: 8      T     YT     ȲN     SN         K  Unnamed: 14  \\\n",
              "0          NaN        NaN    2.0  0.367  0.5481  1.159 -0.156255          NaN   \n",
              "1  1062.600333        NaN    5.0  1.500  0.5481  1.159  0.821311          NaN   \n",
              "2  1146.333761        NaN   10.0  2.250  0.5481  1.159  1.468421          NaN   \n",
              "3   316.927190        NaN   50.0  3.902  0.5481  1.159  2.893788          NaN   \n",
              "4  1419.597851        NaN  100.0  4.600  0.5481  1.159  3.496031          NaN   \n",
              "\n",
              "   Unnamed: 15 Unnamed: 16  Unnamed: 17  \n",
              "0          NaN          Q2    36.731363  \n",
              "1          NaN          Q5    80.938935  \n",
              "2          NaN         Q10   110.202554  \n",
              "3          NaN         Q50   174.660550  \n",
              "4          NaN        Q100   201.895224  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-4030a8f7-1717-4957-a7d9-6a8cf6b4222e\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>رودخانه</th>\n",
              "      <th>ايستگاه</th>\n",
              "      <th>كد</th>\n",
              "      <th>سال</th>\n",
              "      <th>آبی</th>\n",
              "      <th>حداكثر لحظه اي</th>\n",
              "      <th>Unnamed: 6</th>\n",
              "      <th>(Xi-X̄)^2</th>\n",
              "      <th>Unnamed: 8</th>\n",
              "      <th>T</th>\n",
              "      <th>YT</th>\n",
              "      <th>ȲN</th>\n",
              "      <th>SN</th>\n",
              "      <th>K</th>\n",
              "      <th>Unnamed: 14</th>\n",
              "      <th>Unnamed: 15</th>\n",
              "      <th>Unnamed: 16</th>\n",
              "      <th>Unnamed: 17</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>river</td>\n",
              "      <td>station</td>\n",
              "      <td>code</td>\n",
              "      <td>sal</td>\n",
              "      <td>abi</td>\n",
              "      <td>peak_debi</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.367</td>\n",
              "      <td>0.5481</td>\n",
              "      <td>1.159</td>\n",
              "      <td>-0.156255</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Q2</td>\n",
              "      <td>36.731363</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>چهل چاي</td>\n",
              "      <td>لزوره</td>\n",
              "      <td>12-013</td>\n",
              "      <td>1348</td>\n",
              "      <td>49</td>\n",
              "      <td>11.2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1062.600333</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5.0</td>\n",
              "      <td>1.500</td>\n",
              "      <td>0.5481</td>\n",
              "      <td>1.159</td>\n",
              "      <td>0.821311</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Q5</td>\n",
              "      <td>80.938935</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>چهل چاي</td>\n",
              "      <td>لزوره</td>\n",
              "      <td>12-013</td>\n",
              "      <td>1349</td>\n",
              "      <td>50</td>\n",
              "      <td>9.94</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1146.333761</td>\n",
              "      <td>NaN</td>\n",
              "      <td>10.0</td>\n",
              "      <td>2.250</td>\n",
              "      <td>0.5481</td>\n",
              "      <td>1.159</td>\n",
              "      <td>1.468421</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Q10</td>\n",
              "      <td>110.202554</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>چهل چاي</td>\n",
              "      <td>لزوره</td>\n",
              "      <td>12-013</td>\n",
              "      <td>1350</td>\n",
              "      <td>51</td>\n",
              "      <td>61.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>316.927190</td>\n",
              "      <td>NaN</td>\n",
              "      <td>50.0</td>\n",
              "      <td>3.902</td>\n",
              "      <td>0.5481</td>\n",
              "      <td>1.159</td>\n",
              "      <td>2.893788</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Q50</td>\n",
              "      <td>174.660550</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>چهل چاي</td>\n",
              "      <td>لزوره</td>\n",
              "      <td>12-013</td>\n",
              "      <td>1351</td>\n",
              "      <td>52</td>\n",
              "      <td>6.12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1419.597851</td>\n",
              "      <td>NaN</td>\n",
              "      <td>100.0</td>\n",
              "      <td>4.600</td>\n",
              "      <td>0.5481</td>\n",
              "      <td>1.159</td>\n",
              "      <td>3.496031</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Q100</td>\n",
              "      <td>201.895224</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4030a8f7-1717-4957-a7d9-6a8cf6b4222e')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-4030a8f7-1717-4957-a7d9-6a8cf6b4222e 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-4030a8f7-1717-4957-a7d9-6a8cf6b4222e');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "D4nJDxkH4Jit"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/drive')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Yp76wAFS4oYb",
        "outputId": "c81973b8-4426-4055-a31e-ec71da240af5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Drive already mounted at /content/drive; to attempt to forcibly remount, call drive.mount(\"/content/drive\", force_remount=True).\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "ls"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "RR6ZAQPA-7Am",
        "outputId": "b842ffca-2e8a-442b-d50a-ae891a53048a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\u001b[0m\u001b[01;34mdrive\u001b[0m/  mm.xlsx  rezadata.xlsx  \u001b[01;34msample_data\u001b[0m/\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pd.read_excel('mm.xlsx').head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 175
        },
        "id": "jbrfDXZN_YwZ",
        "outputId": "951f5080-a4a1-438c-e3cd-2ef86dea183b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Unnamed: 0  Assign1 /2  Assign2 /1  Assign3 /6\n",
              "0      Radkani        1.70         1.0         NaN\n",
              "1       Naghdi        2.00         1.0         NaN\n",
              "2       Nasiri        1.95         1.0         NaN\n",
              "3  Hashemzadeh        2.00         1.0         NaN"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-92542da1-9d45-444d-8c1b-7c8aa42198f0\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>Assign1 /2</th>\n",
              "      <th>Assign2 /1</th>\n",
              "      <th>Assign3 /6</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Radkani</td>\n",
              "      <td>1.70</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Naghdi</td>\n",
              "      <td>2.00</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Nasiri</td>\n",
              "      <td>1.95</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Hashemzadeh</td>\n",
              "      <td>2.00</td>\n",
              "      <td>1.0</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-92542da1-9d45-444d-8c1b-7c8aa42198f0')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-92542da1-9d45-444d-8c1b-7c8aa42198f0 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-92542da1-9d45-444d-8c1b-7c8aa42198f0');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ]
    }
  ],
  "metadata": {
    "colab": {
      "provenance": [],
      "mount_file_id": "1J7KokHmUpm75_luxm20DN5tUfe3Y3R2x",
      "authorship_tag": "ABX9TyOxN4fvouGJFpI2NjbLBBhO",
      "include_colab_link": true
    },
    "kernelspec": {
      "display_name": "Python 3",
      "name": "python3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}