138 lines
160 KiB
Plaintext
138 lines
160 KiB
Plaintext
|
{
|
||
|
|
"cells": [
|
||
|
|
{
|
||
|
|
"cell_type": "markdown",
|
||
|
|
"metadata": {},
|
||
|
|
"source": [
|
||
|
|
"Лабораторная работа 1\n",
|
||
|
|
"Мониторинг акций Ямана Голд Инк"
|
||
|
|
]
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"cell_type": "code",
|
||
|
|
"execution_count": 2,
|
||
|
|
"metadata": {},
|
||
|
|
"outputs": [
|
||
|
|
{
|
||
|
|
"data": {
|
||
|
|
"text/plain": [
|
||
|
|
"<Axes: xlabel='Date', ylabel='Volume'>"
|
||
|
|
]
|
||
|
|
},
|
||
|
|
"execution_count": 2,
|
||
|
|
"metadata": {},
|
||
|
|
"output_type": "execute_result"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"data": {
|
||
|
|
"image/png": "iVBORw0KGgoAAAANSUhEUgAACVwAAAGCCAYAAAAW4Zo2AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjkuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8hTgPZAAAACXBIWXMAAA9hAAAPYQGoP6dpAABVyklEQVR4nO39eZRU9Z0//r+aBpq1W6GhWWxZFDRGBFwggKJMUDSIMZNRBjUgwczouEVioiQqahJR4/YJoo4YUaOCS6ISg7ggyIh8gyLEnUAAcdgEDd3QKEv3/f2RHzWWzVIN3RTL43FOnWO/7/veet06vKyqdz/73pwkSZIAAAAAAAAAAABgh2pluwAAAAAAAAAAAIC9hcAVAAAAAAAAAABAhgSuAAAAAAAAAAAAMiRwBQAAAAAAAAAAkCGBKwAAAAAAAAAAgAwJXAEAAAAAAAAAAGRI4AoAAAAAAAAAACBDAlcAAAAAAAAAAAAZErgCAAAAAAAAAADIkMAVAAAAAAAAAABAhvbrwNX06dNjwIAB0apVq8jJyYlnn322Svtff/31kZOTU+nRsGHDmikYAAAAAAAAAADIqv06cFVWVhadO3eOMWPG7NT+V155ZSxfvjztccQRR8RZZ51VzZUCAAAAAAAAAAB7gv06cHXaaafFr371q/je97631e0bNmyIK6+8Mlq3bh0NGzaM7t27x7Rp01LbGzVqFC1atEg9Vq5cGR988EEMGzZsN50BAAAAAAAAAACwO+3XgasdueSSS2LmzJkxYcKEeOedd+Kss86KU089NebPn7/V+Q888EB07NgxTjjhhN1cKQAAAAAAAAAAsDsIXG3DkiVLYty4cfHUU0/FCSecEIccckhceeWVcfzxx8e4ceMqzf/yyy/jsccec3UrAAAAAAAAAADYh9XOdgF7qnfffTfKy8ujY8eOaeMbNmyIpk2bVpr/zDPPxNq1a2PIkCG7q0QAAAAAAAAAAGA3E7jahnXr1kVubm7Mnj07cnNz07Y1atSo0vwHHnggTj/99CgqKtpdJQIAAAAAAAAAALuZwNU2dO3aNcrLy+PTTz+NE044YbtzFy1aFFOnTo2JEyfupuoAAAAAAAAAAIBs2K8DV+vWrYsFCxakfl60aFHMnTs3mjRpEh07doxzzz03Bg8eHLfffnt07do1Vq1aFVOmTImjjjoq+vfvn9rvwQcfjJYtW8Zpp52WjdMAAAAAAAAAAAB2k5wkSZJsF5Et06ZNiz59+lQaHzJkSDz00EOxadOm+NWvfhWPPPJILF26NAoLC+Nb3/pW3HDDDdGpU6eIiKioqIg2bdrE4MGD49e//vXuPgUAAAAAAAAAAGA32q8DVwAAAAAAAAAAAFVRK9sFAAAAAAAAAAAA7C0ErgAAAAAAAAAAADJUO9sF7G4VFRWxbNmyaNy4ceTk5GS7HAAAAAAAAAAAIMuSJIm1a9dGq1atolat7V/Dar8LXC1btiyKi4uzXQYAAAAAAAAAALCH+eSTT+Kggw7a7pz9LnDVuHHjiPjni5Ofn5/lagAAAAAAAAAAgGwrLS2N4uLiVLZoe/a7wNWW2wjm5+cLXAEAAAAAAAAAAClbskXbs/0bDgIAAAAAAAAAAJAicAUAAAAAAAAAAJAhgSsAAAAAAAAAAIAMCVwBAAAAAAAAAABkSOAKAAAAAAAAAAAgQwJXAAAAAAAAAAAAGRK4AgAAAAAAAAAAyFDtbBcAAAAAAAAAAAD7soWr1sXHn6+Ptk0bRrvChtkuh10kcAUAAAAAAAAAADVgzfqNcdn4uTF9/qrUWO8OzWL0oK5R0KBOFitjV7ilIAAAAAAAAAAA1IDLxs+NGQtWp43NWLA6Lh0/J0sVUR0ErgAAAAAAAAAAoJotXLUups9fFeVJkjZeniQxff6qWLS6LEuVsasErgAAAAAAAAAAoJp9/Pn67W5f/JnA1d5K4AoAAAAAAAAAAKpZmyYNtru9bdOGu6kSqpvAFQAAAAAAAAAAVLP2zRpF7w7NIjcnJ208NycnendoFu0KBa72VgJXAAAAAAAAAABQA0YP6hq9Di1MG+t1aGGMHtQ1SxVRHWpnuwAAAAAAAAAAANgXFTSoE48M6xaLVpfF4s/Kom3Thq5stQ8QuAIAAAAAAAAAgBrUrlDQal+S1VsKTp8+PQYMGBCtWrWKnJycePbZZzPed8aMGVG7du3o0qVLjdUHAAAAAAAAAADwVVkNXJWVlUXnzp1jzJgxVdpvzZo1MXjw4Pj2t79dQ5UBAAAAAAAAAABUltVbCp522mlx2mmnVXm/Cy+8MM4555zIzc2t0lWxAAAAAAAAAAAAdkVWr3C1M8aNGxcLFy6MkSNHZjR/w4YNUVpamvYAAAAAAAAAAADYGXtV4Gr+/Plx9dVXx6OPPhq1a2d2ca5Ro0ZFQUFB6lFcXFzDVQIAAAAAAAAAAPuqvSZwVV5eHuecc07ccMMN0bFjx4z3GzFiRJSUlKQen3zySQ1WCQAAAAAAAAAA7Msyu0zUHmDt2rXx1ltvxZw5c+KSSy6JiIiKiopIkiRq164dL730UvzLv/xLpf3y8vIiLy9vd5cLAAAAAAAAAADsg/aawFV+fn68++67aWP33HNPvPrqq/H0009Hu3btslQZAAAAAAAAAACwv8hq4GrdunWxYMGC1M+LFi2KuXPnRpMmTeLggw+OESNGxNKlS+ORRx6JWrVqxZFHHpm2f/PmzaNevXqVxgEAAAAAAAAAAGpCVgNXb731VvTp0yf18/DhwyMiYsiQIfHQQw/F8uXLY8mSJdkqDwAAAAAAAAAAIE1OkiRJtovYnUpLS6OgoCBKSkoiPz8/2+UAAAAAAAAAAABZVpVMUa3dVBMAAAAAAAAAAMBeT+AKAAAAAAAAAAAgQwJXAAAAAAAAAAAAGRK4AgAAAAAAAAAAyJDAFQAAAAAAAAAAQIYErgAAAAAAAAAAADIkcAUAAAAAAAAAAJAhgSsAAAAAAAAAAIAMCVwBAAAAAAAAAABkSOAKAAAAAAAAAAAgQwJXAAAAAAAAAAAAGRK4AgAAAAAAAAAAyJDAFQAAAAAAAAAAQIYErgAAAAAAAAAAADIkcAUAAAAAAAAAAJAhgSsAAAAAAAAAAIAMCVwBAAAAAAAAAABkSOAKAAAAAAAAAAAgQwJXAAAAAAAAAAAAGRK4AgAAAAAAAAAAyJDAFQAAAAAAAAAAQIYErgAAAAAAAAAAADIkcAUAAAAAAAAAAJAhgSsAAAAAAAAAAIAMCVwBAAAAAAAAAABkSOAKAAAAAAAAAAAgQwJXAAAAAAAAAAAAGRK4AgAAAAAAAAAAyFBWA1fTp0+PAQMGRKtWrSInJyeeffbZ7c7/4x//GCeffHI0a9Ys8vPzo0ePHvHiiy/unmIBAAAAAAAAAID9XlYDV2VlZdG5c+cYM2ZMRvOnT58eJ598ckyaNClmz54dffr0iQEDBsScOXNquFIAAAAAAAAAAICInCRJkmwXERGRk5MTzzzzTJx55plV2u+b3/xmDBw4MK677rqM5peWlkZBQUGUlJREfn7+TlQKAAAAAAAAAADsS6qSKaq9m2qqERUVFbF27dpo0qTJNuds2LAhNmzYkPq5tLR0d5QGAAAAAAAAAADsg7J6S8Fdddttt8W6devi7LPP3uacUaNGRUFBQepRXFy8GysEAAAAAAAAAAD2JXtt4Orxxx+PG264IZ588slo3rz5NueNGDEiSkpKUo9PPvlkN1YJAAAAAAAAAADsS/bKWwpOmDAhLrjggnjqqaeib9++252bl5cXeXl5u6kyAAAAAAAAINsWrloXH3++Pto2bRjtChtmuxwAYB+z1wWuxo8fHz/84Q9jwoQJ0b9//2yXAwAAAAAAAOwh1qzfGJeNnxvT569KjfXu0CxGD+oaBQ3qZLEyAGBfktVbCq5bty7mzp0bc+fOjYiIRYsWxdy5c2PJkiUR8c/bAQ4ePDg1//HHH4/BgwfH7bffHt27d48VK1bEihUroqSkJBvlAwAAAAAAAHuQy8bPjRkLVqeNzViwOi4dPydLFQEA+6KsBq7eeuut6Nq1a3Tt2jUiIoYPHx5
|
||
|
|
"text/plain": [
|
||
|
|
"<Figure size 3000x400 with 1 Axes>"
|
||
|
|
]
|
||
|
|
},
|
||
|
|
"metadata": {},
|
||
|
|
"output_type": "display_data"
|
||
|
|
}
|
||
|
|
],
|
||
|
|
"source": [
|
||
|
|
"\n",
|
||
|
|
"import pandas as pd\n",
|
||
|
|
"import matplotlib.pyplot as plt\n",
|
||
|
|
"from datetime import date\n",
|
||
|
|
"\n",
|
||
|
|
"df = pd.read_csv(\".//static//csv//Yamana_Gold_Inc._AUY.csv\")\n",
|
||
|
|
"\n",
|
||
|
|
"viborka = df.groupby(df.index // 500).head(1)\n",
|
||
|
|
"viborka.plot.scatter(x=\"Date\", y=\"Volume\", figsize=(30, 4))\n",
|
||
|
|
"# Диаграмма объема каждые 2 года:"
|
||
|
|
]
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"cell_type": "code",
|
||
|
|
"execution_count": 3,
|
||
|
|
"metadata": {},
|
||
|
|
"outputs": [
|
||
|
|
{
|
||
|
|
"data": {
|
||
|
|
"image/png": "iVBORw0KGgoAAAANSUhEUgAABJgAAASXCAYAAACtAsVlAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjkuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8hTgPZAAAACXBIWXMAAA9hAAAPYQGoP6dpAAD1tElEQVR4nOzdd3hUddrG8Xsmkx4Sem+iYmMtLNZ17XV9194L9rV3EV1Fd21rW2XtvYOCglJEEBRp0pvUBBICIb23ydRz3j8CUaQFUn5Tvp/r8hKSyeQOIpzc8zy/47Bt2xYAAAAAAACwl5ymAwAAAAAAACC8UTABAAAAAACgSSiYAAAAAAAA0CQUTAAAAAAAAGgSCiYAAAAAAAA0CQUTAAAAAAAAmoSCCQAAAAAAAE1CwQQAAAAAAIAmoWACAAAAAABAk1AwAQAAAAAAoEkomAAAAAAAANAkFEwAAAAAAABoEgomAAAAAAAANAkFEwAAAAAAAJqEggkAAAAAAABNQsEEAAAAAACAJqFgAgAAAAAAQJNQMAEAAAAAAKBJKJgAAAAAAADQJBRMAAAAAAAAaBIKJgAAAAAAADQJBRMAAAAAAACahIIJAAAAAAAATULBBAAAAAAAgCahYAIAAAAAAECTUDABAAAAAACgSSiYAAAAAAAA0CQUTAAAAAAAAGgSCiYAAAAAAAA0CQUTAAAAAAAAmoSCCQAAAAAAAE1CwQQAAAAAAIAmoWACAAAAAABAk1AwAQAAAAAAoEkomAAAAAAAANAkFEwAAAAAAABoEgomAAAAAAAANAkFEwAAAAAAAJqEggkAAAAAAABNQsEEAAAAAACAJqFgAgAAAAAAQJNQMAEAAAAAAKBJKJgAAAAAAADQJBRMAAAAAAAAaBIKJgAAAAAAADQJBRMAAAAAAACahIIJAAAAAAAATULBBAAAAAAAgCahYAIAAAAAAECTUDABAAAAAACgSSiYAAAAAAAA0CQUTAAAAAAAAGgSCiYAAAAAAAA0CQUTAAAAAAAAmoSCCQAAAAAAAE1CwQQAAAAAAIAmoWACAAAAAABAk1AwAQAAAAAAoEkomAAAAAAAANAkFEwAAAAAAABoEgomAAAAAAAANAkFEwAAAAAAAJqEggkAAAAAAABNQsEEAAAAAACAJqFgAgAAAAAAQJNQMAEAAAAAAKBJKJgAAAAAAADQJBRMAAAAAAAAaBIKJgAAAAAAADQJBRMAAAAAAACahIIJAAAAAAAATULBBAAAAAAAgCahYAIAAAAAAECTUDABAAAAAACgSSiYAAAAAAAA0CQUTAAAAAAAAGgSCiYAAAAAAAA0CQUTAAAAAAAAmoSCCQAAAAAAAE1CwQQAAAAAAIAmoWACAAAAAABAk1AwAQAAAAAAoEkomAAAAAAAANAkFEwAAAAAAABoEgomAAAAAAAANAkFEwAAAAAAAJqEggkAAAAAAABNQsEEAAAAAACAJqFgAgAAAAAAQJNQMAEAAAAAAKBJKJgAAAAAAADQJBRMAAAAAAAAaBIKJgAAAAAAADQJBRMAAAAAAACahIIJAAAAAAAATULBBAAAAAAAgCahYAIAAAAAAECTUDABAAAAAACgSSiYAAAAAAAA0CQUTAAAAAAAAGgSCiYAAAAAAAA0CQUTAAAAAAAAmoSCCQAAAAAAAE1CwQQAAAAAAIAmoWACAAAAAABAk1AwAVEsPT1dJSUlpmMAAAAAAMIcBRMQhXw+n0aNGqXLLrtM55xzjuk4AAAAAIAwR8EERJn8/HwNGTJETz31lAYMGKCcnBzdddddpmMBAAAAAMKYy3QAAK1r1apVWrBggZKTk/X5559r3bp1OvDAA3XRRRfppJNOMh0PAAAAABCGmGACokAgEGj48QknnKAnn3xSBQUFmjlzpvbff3898cQTuuyyywwmBAAAAACEM4dt27bpEABahm3b+vDDD2Xbtm666aZt3nfnnXeqqKhIo0aNksPh0CeffKJrr71Wtm3L4XAYSgwAAAAACEdMMAERzOFwaMSIEcrKypIkWZYly7Ik1U81/b5Muvbaa43lBAAAAACENwomIEJtLZIef/xxDR8+XIsXL5bT6ZTT6VROTo4mT56s1NRUSVIwGGz4GKaXAAAAAAB7ihU5IIJZliWn06khQ4Zo2rRpOuGEE9SpUyd98803Sk5O1qeffqq+ffs2PN7tdsvj8WjChAlMNAEAAAAAGo2CCYhgv1+BGz58uMaNG6cNGzbojDPO0C233KI///nPsixLGzdu1Pvvv6+KigqNGTNGvXr10pgxY9S7d2/DXwEAAAAAIBxQMAERbusU01aBQEAOh0MZGRkaNWqUNm3apC+//FLnnXeeDjvsMB133HE64YQTVFRUpDZt2igxMdFgegAAAABAOHCZDgCgZf2+XBo/fryWLVum5cuXa9KkSbr66qvVt29f/fLLLzr88MMbyqjCwkK9/fbbysjI0IgRIwymBwAAAACEAyaYgChg27Y+/PBDPfnkk/r73/+uzp0767rrrttmBS4YDMrpdMrhcMiyLM2cOVP33HOPzj33XD311FMG0wMAAAAAQh0FExAlqqur5XA4FBcXp7i4uG3e9/s1Oq/Xq/j4eEnS7NmzdfbZZ2vOnDk69NBDWz0zAAAAACA8OHf/EACRoE2bNkpJSdmmXAoEAvJ4PHI6nbJtW5s3b9aFF16oqqoqSdLxxx+vU089VZMmTTIVGwAAAAAQBiiYgChVV1enkSNHasaMGZIkh8Ohnj17KiYmRuedd54kae7cuVq6dKm6dOliMioAAAAAIMRxyDcQpRISEvTjjz+qS5cuOvPMMxvW5J555hkdf/zxOuWUU1RSUqLOnTvroIMOMh0XAAAAABDCKJiAKGTbthwOh66++mpdcsklGjx4sAYMGCBJKisrU4cOHfT0009rw4YN2nfffXXMMccYTgwAAAAACGUc8g1Eqa0l0y233KIVK1boiSeeUO/evTVq1ChNnTpVU6ZMUUpKiiSptrZWubm58vv96tatm9q3b284PQAAAAAglFAwAVFqa8EkSTfddJPmzp2r0tJSFRUV6Z133tHNN98sSRozZoxefPFF+Xw+/frrrzr++ON166236vLLLzcZHwB2yg4GZbndstx1suvcsurq6v9x18mqc8t2u2V5vZJlyQ4GpaAl29r230GXQ2OPDMqh+j8nHXI0/Jn5+x9v/XmsM1aJsYlKiElQkitJia7Ehp8nuhIbfp4Yk6jYmFgjvy4AAAAtiYIJiGJbz11yu90qKCjQ3LlzdcIJJ6hXr16ybVtXX321vvrqKw0ePFgnn3yy9tlnH82dO1f/+te/tH79eg7/BtAiLLdbgbJyBcvLFCwrU6C8XMEtPw+Ul8uqqd1SFNXVF0lbCiR7y49tn6/JGRxtUnTJnZ5m+Gq253K4GkqnBFfCDn+89Z+0+DR1SOygDgkdtvl3oiuxRbIBAADsLQomANtMM0nS+vXrdeONN6qgoECPP/64zjjjDHXq1EmSFAwGdeKJJ+rKK6/U7bffbioygDBiB4MKFBbKX1hYXxiVldUXRmVlCpSXKVhe8duPy8ple1qm2NkTjpRkXXKX13SMnUpyJe2weGr49+9+nBybbDouAACIAhzyDWCbckmSvvvuO/l8Pr388ss6/fTTFRcX1/C+iooKrV69Wmlpaa0dE0CIsurq5M/Lkz8vv/7f+Xlbfp6nQF6+/EVFUiBgOuaeCfGX39wBt9zVbuVU5+z2sQkxCeqQ2EHtE9qrQ0IHdUzqqB4pPdSrTa+Gf9rEtWmF1AAAIJJRMAHYRnV1td544w2dffbZOuecc7Z5X15enl588UX17t1bp512mqGEAFpbsKpKvk058ufl1pdG+VuKpNw8+fPzFSwvNx2x+VmW6QTNxhP0KLcmV7k1uTt9TLv4durVppd6tum5TfHUO7W3OiZ2bMW0AAAgXFEwAdhGbW2t0tLSdN555zW8zbZtrVmzRp999pkmTZqk66+/vmFlDkBksG1bgfx8ebM2yJeVJW9WpnxZG+TNylKwpMR0PANCfISpmZV7y1XuLdevJb9u975EV2J98ZTyW+m0tYj
|
||
|
|
"text/plain": [
|
||
|
|
"<Figure size 1500x1500 with 1 Axes>"
|
||
|
|
]
|
||
|
|
},
|
||
|
|
"metadata": {},
|
||
|
|
"output_type": "display_data"
|
||
|
|
}
|
||
|
|
],
|
||
|
|
"source": [
|
||
|
|
"df_subset = df.groupby(df.index // 1000).head(1)\n",
|
||
|
|
"\n",
|
||
|
|
"value_counts = df_subset['Volume'].value_counts()\n",
|
||
|
|
"year = df_subset[\"Date\"]\n",
|
||
|
|
"\n",
|
||
|
|
"plt.figure(figsize=(15, 15))\n",
|
||
|
|
"plt.pie(\n",
|
||
|
|
" df_subset[\"Volume\"],\n",
|
||
|
|
" labels= df_subset[\"Date\"], # type: ignore\n",
|
||
|
|
" autopct=\"%1.1f%%\", rotatelabels=True\n",
|
||
|
|
")\n",
|
||
|
|
"plt.show()\n",
|
||
|
|
"#Сравнение объема продаж каждые 4 года:"
|
||
|
|
]
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"cell_type": "code",
|
||
|
|
"execution_count": 11,
|
||
|
|
"metadata": {},
|
||
|
|
"outputs": [
|
||
|
|
{
|
||
|
|
"data": {
|
||
|
|
"text/plain": [
|
||
|
|
"<Axes: xlabel='Date'>"
|
||
|
|
]
|
||
|
|
},
|
||
|
|
"execution_count": 11,
|
||
|
|
"metadata": {},
|
||
|
|
"output_type": "execute_result"
|
||
|
|
},
|
||
|
|
{
|
||
|
|
"data": {
|
||
|
|
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAjQAAAGwCAYAAAC+Qv9QAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjkuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8hTgPZAAAACXBIWXMAAA9hAAAPYQGoP6dpAACJKElEQVR4nOzdd3gU1dfA8e/upocUID2EEiChd0GaiJSA0hEUKeqLWMCCigUboCJWrGD9KYoISkeBgKCgCIgSeg2BEAKBkIT0vjvvH5MEIglkySazuzmf59nHS3Z25uyOZA8z596jUxRFQQghhBDChum1DkAIIYQQorIkoRFCCCGEzZOERgghhBA2TxIaIYQQQtg8SWiEEEIIYfMkoRFCCCGEzZOERgghhBA2z0HrACzBZDJx7tw5PDw80Ol0WocjhBBCiApQFIWMjAyCgoLQ6yt3jcUuEppz584REhKidRhCCCGEuAFnzpyhXr16ldqHXSQ0Hh4egPqBeHp6ahyNEEIIISoiPT2dkJCQku/xyrCLhKb4NpOnp6ckNEIIIYSNsUS5iBQFCyGEEMLmSUIjhBBCCJsnCY0QQgghbJ4kNEIIIYSweZLQCCGEEMLmSUIjhBBCCJsnCY0QQgghbJ4kNEIIIYSweZLQCCGEEMLmSUIjhBBCCJsnCY0QQgghbJ4kNEIIIYSweZLQXEdWXiG7T1/SOgwhhBBCXIMkNNdwIjGTTq9v4r5vdpFbYNQ6HCGEEEKUQxKaawj1caeOuxMZuYVsOnJB63CEEEIIUQ5JaK5Br9cxrH0QACuizmocjRBCCCHKIwnNdQxvXw+ArccvkpSZp3E0QgghhCiLJDTX0cSvFm1DvDGaFNbsPad1OEIIIYQogyQ0FTCifTAAK/bEaxyJEEIIIcoiCU0FDG4bhINex8Gz6Ry/kKF1OEIIIYT4D7MSmpkzZ6LT6Uo9mjVrds3XpKamMmXKFAIDA3F2diYsLIx169ZVap/VrY67E72b+QFSHCyEEEJYIwdzX9CyZUs2bdp0eQcO5e8iPz+ffv364efnx7JlywgODub06dN4e3vf8D61MrJDML8evsCqPWd5JiIcg16ndUhCCCGEKGJ25uDg4EBAQECFtv36669JSUlh+/btODo6AtCwYcNK7RMgLy+PvLzLM47S09Mr/Nob1buZH16ujpxPz2VHTDI9mvpU+TGFEEIIUTFm19BER0cTFBREaGgoY8eOJS4urtxt16xZQ9euXZkyZQr+/v60atWKN954A6Ox9Kq75uwTYM6cOXh5eZU8QkJCzH0bZnN2MDCoTSAgxcFCCCGEtdEpiqJUdOP169eTmZlJeHg4CQkJzJo1i7Nnz3Lw4EE8PDyu2r5Zs2bExsYyduxYJk+ezIkTJ5g8eTKPP/44M2bMuKF9QtlXaEJCQkhLS8PT09Pcz6DCdp++xMhPt+PmZOCfF/vi7mx9t8aEEEIIW5Geno6Xl5dFvr/NSmj+KzU1lQYNGjB37lwmTpx41fNhYWHk5uZy6tQpDAYDAHPnzuWdd94hISHhhvZZFkt+INeiKAq9391CbHI2c0e3ZUSHelV2LCGEEMLeWfL7u1LTtr29vQkLC+PEiRNlPh8YGEhYWFhJMgPQvHlzzp8/T35+/g3tU0s6na5k5eCVe2S2kxBCCGEtKpXQZGZmEhMTQ2BgYJnPd+/enRMnTmAymUp+dvz4cQIDA3FycrqhfWpteNEie9tOJHE+LVfjaIQQQggBZiY006ZNY+vWrcTGxrJ9+3aGDx+OwWBgzJgxAEyYMIHp06eXbP/II4+QkpLCE088wfHjx1m7di1vvPEGU6ZMqfA+rU39um7c1LA2igKr9spVGiGEEMIamFXVGh8fz5gxY0hOTsbX15cePXqwc+dOfH19AYiLi0Ovv5wjhYSEsGHDBp588knatGlDcHAwTzzxBM8991yF92mNRnSoxz+xl1gRFc9Dt4Si08maNEIIIYSWKlUUbC2qqyi4WFpOATfN3kR+oYlfHutBq2CvKj+mEEIIYW+spii4pvJydaRfC39AWiEIIYQQ1kASmhtU3IF7zb6zFBpN19laCCGEEFVJEpobdEuYL3XdnUjKzOfP6CStwxFCCCFqNElobpCjQc+QdkEALI+SVghCCCGEliShqYQRRYvsbTx8gfTcAo2jEUIIIWouSWgqoVWwJ039apFfaGL9gbJbOQghhBCi6klCUwk6na6kn9Nyme0khBBCaEYSmkoa1j4InQ52nUrhTEq21uEIIYQQNZIkNJUU6OVKt8Z1AVglDSuFEEIITUhCYwHFxcEr9pzFDhZeFkIIIUr5NzaFS1n5WodxTZLQWMCAVgG4Oho4lZTFnjOpWocjhBBCWMyZlGzuX/APgz7exunkLK3DKZckNBbg7uzAgFYBAKyQNWmEEELYibxCI1N+iCIjtxA/T2eCvF21DqlcktBYyIgOaiuEX/YnkFdo1DgaIYQQovLmrDvK/vg0vN0c+eSeDjgarDdtsN7IbEy3xj74ezqTml3A70cvah2OEEIIUSlr9yewYHssAHNHtyXYiq/OgCQ0FmPQ6xjWTr1KI7edhBBC2LLYpCyeW74fgId7Nea2Zv4aR3R9ktBYUPEie78fS7T6anAhhBCiLLkFRiYviiIzr5CbGtZmWv8wrUOqEEloLCg8wIOWQZ4UGBV+2X9O63CEEEIIs732y2EOJ6RTx92Jj8d0wMGK62auZBtR2pDh7dXbTtIKQQghhK1Zvfcsi/6OQ6eDD+5qR4CXi9YhVZgkNBY2pF0QBr2OvWdSOXkxU+twhBBCiAqJuZjJCysOAPBo7ybcEuarcUTmkYTGwvw8XLilqQ8AK6UVghBCCBuQk29kyqIosvKN3Bxah6l9baNu5kqS0FSB4UXFwSuizmIySSsEIYQQ1m3mmkMcPZ+BTy1nPrq7PQa9TuuQzCYJTRXo38IfD2cHzqbmsCs2RetwhBBCiHIt3x3Pj/+eQaeDj+5uh5+n7dTNXEkSmirg4mjg9taBAKyU4mAhhBBWKvpCBi+tOgjA1D5hdGvio3FEN04SmipS3Aph7YEEcgukFYIQQgjrkp1fyORFUeQUGOnRxIdHb2uidUiVIglNFbmpYR2CvV3JzCtk4+ELWocjhBBClFAUhZdWHiQ6MRM/D2c+uLudTdbNXEkSmiqi1+tKrtKslFYIQgghrMhP/55hxZ6z6HXw8Zj2+NRy1jqkSpOEpgoVL7L3R3QSiRm5GkcjhBBCwJGEdF5ZfQiAp/uH0yW0rsYRWYYkNFUo1LcW7UK8MZoU1uyVVghCCCG0lZlXyJRFUeQVmrg13JdHejXWOiSLkYSmio0svu0ki+wJIYTQkKIoTF9xgJNJWQR6uTB3dDv0Nl43cyVJaKrYoDZBOBp0HDqXztHz6VqHI4QQooZa9HccP+87h4Nexyf3tKeOu5PWIVmUJDRVrLa7E73D/QBZk0YIIYQ2Dp5N49VfDgPw7IBwOjaoo3FElicJTTUYUdQKYdXesxilFYIQQohqlJ5bwJQfosgvNNG3uR+TeoZqHVKVkISmGvRu5ou3myMX0vPYHpOkdThCCCFqCEVReH75fk4nZxPs7cq7o9qi09lP3cyVJKGpBs4OBga1UVshrJDbTkIIIarJt9tjWXfgPI4GtW7G282+6mauJAlNNSm+7RR58DxZeYUaRyOEEMLe7TuTyux1RwCYPrA57evX1jiiqmVWQjNz5kx0Ol2pR7Nmza75mtTUVKZMmUJgYCDOzs6EhYWxbt26UtvMmzePhg0b4uLiQpcuXdi1a5f578TKtQ/xppGPOzkFRiIPntc6HCGEEHYsLVutmykwKgxoGcD93RtqHVKVM/sKTcuWLUlISCh5bNu2rdxt8/Pz6devH7GxsSxbtoxjx47x5ZdfEhwcXLLNjz/+yFNPPcWMGTOIioqibdu2REREkJiYeGPvyErpdDpGFK0cvGKPtEIQQghRNRRFYdqyfcRfyiGkjitv3dnGbutmruRg9gscHAgICKjQtl9//TUpKSls374dR0dHABo2bFhqm7lz5zJp0iTuv/9+AD777DPWrl3L119/zfP
|
||
|
|
"text/plain": [
|
||
|
|
"<Figure size 640x480 with 1 Axes>"
|
||
|
|
]
|
||
|
|
},
|
||
|
|
"metadata": {},
|
||
|
|
"output_type": "display_data"
|
||
|
|
}
|
||
|
|
],
|
||
|
|
"source": [
|
||
|
|
"from sqlite3 import Date\n",
|
||
|
|
"\n",
|
||
|
|
"#Цены открытия и закрытия за последние 5 дней\n",
|
||
|
|
"df.tail(5).plot(x=\"Date\", y=[\"Open\", \"Close\"])"
|
||
|
|
]
|
||
|
|
}
|
||
|
|
],
|
||
|
|
"metadata": {
|
||
|
|
"kernelspec": {
|
||
|
|
"display_name": "aisenv",
|
||
|
|
"language": "python",
|
||
|
|
"name": "python3"
|
||
|
|
},
|
||
|
|
"language_info": {
|
||
|
|
"codemirror_mode": {
|
||
|
|
"name": "ipython",
|
||
|
|
"version": 3
|
||
|
|
},
|
||
|
|
"file_extension": ".py",
|
||
|
|
"mimetype": "text/x-python",
|
||
|
|
"name": "python",
|
||
|
|
"nbconvert_exporter": "python",
|
||
|
|
"pygments_lexer": "ipython3",
|
||
|
|
"version": "3.12.6"
|
||
|
|
}
|
||
|
|
},
|
||
|
|
"nbformat": 4,
|
||
|
|
"nbformat_minor": 2
|
||
|
|
}
|