{ "cells": [ { "cell_type": "code", "execution_count": null, "metadata": { "id": "BfC7dn-qjJrM" }, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import matplotlib.pyplot as plt" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "id": "DTQ6BsJasE2Z" }, "outputs": [], "source": [ "fpt = pd.read_csv('FPT.csv')" ] }, { "cell_type": "markdown", "metadata": { "id": "LjGL4yrsAXR9" }, "source": [ "#1. Xử lý dữ liệu" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 423 }, "id": "ypZlj49yjTx3", "outputId": "ece9c0f5-0be0-4fe7-a678-fafc023ccc89" }, "outputs": [ { "data": { "application/vnd.google.colaboratory.intrinsic+json": { "summary": "{\n \"name\": \"fpt\",\n \"rows\": 97406,\n \"fields\": [\n {\n \"column\": \"Ticker\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 1,\n \"samples\": [\n \"FPT\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Date/Time\",\n \"properties\": {\n \"dtype\": \"object\",\n \"num_unique_values\": 97406,\n \"samples\": [\n \"9/16/2020 13:28\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Open\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 6.359803058765985,\n \"min\": 30.25,\n \"max\": 58.4,\n \"num_unique_values\": 802,\n \"samples\": [\n 37.68\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"High\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 6.364950227705635,\n \"min\": 30.25,\n \"max\": 58.5,\n \"num_unique_values\": 800,\n \"samples\": [\n 45.35\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Low\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 6.3542454835986675,\n \"min\": 30.22,\n \"max\": 58.4,\n \"num_unique_values\": 802,\n \"samples\": [\n 37.75\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Close\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 6.359798823150364,\n \"min\": 30.25,\n \"max\": 58.4,\n \"num_unique_values\": 802,\n \"samples\": [\n 37.75\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Volume\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 17532,\n \"min\": 10,\n \"max\": 1255930,\n \"num_unique_values\": 6221,\n \"samples\": [\n 46050\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Open Interest\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 0,\n \"min\": 0,\n \"max\": 0,\n \"num_unique_values\": 1,\n \"samples\": [\n 0\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}", "type": "dataframe", "variable_name": "fpt" }, "text/html": [ "\n", "
| \n", " | Ticker | \n", "Date/Time | \n", "Open | \n", "High | \n", "Low | \n", "Close | \n", "Volume | \n", "Open Interest | \n", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "FPT | \n", "12/25/2018 9:15 | \n", "30.89 | \n", "30.89 | \n", "30.89 | \n", "30.89 | \n", "35410 | \n", "0 | \n", "
| 1 | \n", "FPT | \n", "12/25/2018 9:16 | \n", "30.81 | \n", "30.81 | \n", "30.81 | \n", "30.81 | \n", "190 | \n", "0 | \n", "
| 2 | \n", "FPT | \n", "12/25/2018 9:17 | \n", "30.74 | \n", "30.81 | \n", "30.74 | \n", "30.74 | \n", "1120 | \n", "0 | \n", "
| 3 | \n", "FPT | \n", "12/25/2018 9:18 | \n", "30.74 | \n", "30.74 | \n", "30.74 | \n", "30.74 | \n", "2120 | \n", "0 | \n", "
| 4 | \n", "FPT | \n", "12/25/2018 9:19 | \n", "30.74 | \n", "30.74 | \n", "30.74 | \n", "30.74 | \n", "22500 | \n", "0 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 97401 | \n", "FPT | \n", "12/22/2020 14:24 | \n", "58.20 | \n", "58.20 | \n", "58.20 | \n", "58.20 | \n", "27470 | \n", "0 | \n", "
| 97402 | \n", "FPT | \n", "12/22/2020 14:25 | \n", "58.20 | \n", "58.20 | \n", "58.20 | \n", "58.20 | \n", "14820 | \n", "0 | \n", "
| 97403 | \n", "FPT | \n", "12/22/2020 14:26 | \n", "58.20 | \n", "58.20 | \n", "58.20 | \n", "58.20 | \n", "500 | \n", "0 | \n", "
| 97404 | \n", "FPT | \n", "12/22/2020 14:29 | \n", "58.10 | \n", "58.10 | \n", "58.10 | \n", "58.10 | \n", "2500 | \n", "0 | \n", "
| 97405 | \n", "FPT | \n", "12/22/2020 14:46 | \n", "58.10 | \n", "58.10 | \n", "58.10 | \n", "58.10 | \n", "11170 | \n", "0 | \n", "
97406 rows × 8 columns
\n", "| \n", " | Date/Time | \n", "Close | \n", "
|---|---|---|
| 0 | \n", "12/25/2018 9:15 | \n", "30.89 | \n", "
| 1 | \n", "12/25/2018 9:16 | \n", "30.81 | \n", "
| 2 | \n", "12/25/2018 9:17 | \n", "30.74 | \n", "
| 3 | \n", "12/25/2018 9:18 | \n", "30.74 | \n", "
| 4 | \n", "12/25/2018 9:19 | \n", "30.74 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 97401 | \n", "12/22/2020 14:24 | \n", "58.20 | \n", "
| 97402 | \n", "12/22/2020 14:25 | \n", "58.20 | \n", "
| 97403 | \n", "12/22/2020 14:26 | \n", "58.20 | \n", "
| 97404 | \n", "12/22/2020 14:29 | \n", "58.10 | \n", "
| 97405 | \n", "12/22/2020 14:46 | \n", "58.10 | \n", "
97406 rows × 2 columns
\n", "| \n", " | Time | \n", "Close | \n", "
|---|---|---|
| 6 | \n", "12/25/2018 9:21 | \n", "30.66 | \n", "
| 132 | \n", "12/26/2018 14:46 | \n", "30.89 | \n", "
| 266 | \n", "12/27/2018 14:46 | \n", "31.19 | \n", "
| 388 | \n", "12/28/2018 14:46 | \n", "31.49 | \n", "
| 505 | \n", "1/2/2019 14:46 | \n", "30.74 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 96564 | \n", "12/16/2020 14:46 | \n", "57.10 | \n", "
| 96762 | \n", "12/17/2020 14:46 | \n", "56.50 | \n", "
| 96975 | \n", "12/18/2020 14:46 | \n", "56.90 | \n", "
| 97189 | \n", "12/21/2020 14:46 | \n", "57.50 | \n", "
| 97405 | \n", "12/22/2020 14:46 | \n", "58.10 | \n", "
499 rows × 2 columns
\n", "| \n", " | Date | \n", "Close | \n", "
|---|---|---|
| 6 | \n", "12/25/2018 | \n", "30.66 | \n", "
| 132 | \n", "12/26/2018 | \n", "30.89 | \n", "
| 266 | \n", "12/27/2018 | \n", "31.19 | \n", "
| 388 | \n", "12/28/2018 | \n", "31.49 | \n", "
| 505 | \n", "1/2/2019 | \n", "30.74 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 96564 | \n", "12/16/2020 | \n", "57.10 | \n", "
| 96762 | \n", "12/17/2020 | \n", "56.50 | \n", "
| 96975 | \n", "12/18/2020 | \n", "56.90 | \n", "
| 97189 | \n", "12/21/2020 | \n", "57.50 | \n", "
| 97405 | \n", "12/22/2020 | \n", "58.10 | \n", "
499 rows × 2 columns
\n", "| \n", " | Date | \n", "
|---|---|
| 6 | \n", "2018-12-25 | \n", "
| 132 | \n", "2018-12-26 | \n", "
| 266 | \n", "2018-12-27 | \n", "
| 388 | \n", "2018-12-28 | \n", "
| 505 | \n", "2019-01-02 | \n", "
| ... | \n", "... | \n", "
| 96564 | \n", "2020-12-16 | \n", "
| 96762 | \n", "2020-12-17 | \n", "
| 96975 | \n", "2020-12-18 | \n", "
| 97189 | \n", "2020-12-21 | \n", "
| 97405 | \n", "2020-12-22 | \n", "
499 rows × 1 columns
\n", "| \n", " | Close | \n", "
|---|---|
| Date | \n", "\n", " |
| 2018-12-25 | \n", "30.66 | \n", "
| 2018-12-26 | \n", "30.89 | \n", "
| 2018-12-27 | \n", "31.19 | \n", "
| 2018-12-28 | \n", "31.49 | \n", "
| 2019-01-02 | \n", "30.74 | \n", "
| ... | \n", "... | \n", "
| 2020-12-16 | \n", "57.10 | \n", "
| 2020-12-17 | \n", "56.50 | \n", "
| 2020-12-18 | \n", "56.90 | \n", "
| 2020-12-21 | \n", "57.50 | \n", "
| 2020-12-22 | \n", "58.10 | \n", "
499 rows × 1 columns
\n", "| \n", " | Target Date | \n", "Target-3 | \n", "Target-2 | \n", "Target-1 | \n", "Target | \n", "
|---|---|---|---|---|---|
| 0 | \n", "2018-12-28 | \n", "30.66 | \n", "30.89 | \n", "31.19 | \n", "31.49 | \n", "
| 1 | \n", "2019-01-02 | \n", "30.89 | \n", "31.19 | \n", "31.49 | \n", "30.74 | \n", "
| 2 | \n", "2019-01-03 | \n", "31.19 | \n", "31.49 | \n", "30.74 | \n", "30.44 | \n", "
| 3 | \n", "2019-01-04 | \n", "31.49 | \n", "30.74 | \n", "30.44 | \n", "30.66 | \n", "
| 4 | \n", "2019-01-07 | \n", "30.74 | \n", "30.44 | \n", "30.66 | \n", "31.19 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 491 | \n", "2020-12-16 | \n", "57.00 | \n", "57.20 | \n", "56.70 | \n", "57.10 | \n", "
| 492 | \n", "2020-12-17 | \n", "57.20 | \n", "56.70 | \n", "57.10 | \n", "56.50 | \n", "
| 493 | \n", "2020-12-18 | \n", "56.70 | \n", "57.10 | \n", "56.50 | \n", "56.90 | \n", "
| 494 | \n", "2020-12-21 | \n", "57.10 | \n", "56.50 | \n", "56.90 | \n", "57.50 | \n", "
| 495 | \n", "2020-12-22 | \n", "56.50 | \n", "56.90 | \n", "57.50 | \n", "58.10 | \n", "
496 rows × 5 columns
\n", "