{ "cells": [ { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 3, "metadata": {}, "outputs": [], "source": [ "from sqlalchemy import create_engine\n", "mysql_user = 'root'\n", "mysql_password = 'qx123456'\n", "mysql_host = 'algo-dev-internal.li-ai.com.cn'\n", "mysql_port = 3306\n", "mysql_db = 'aiomp'\n", "\n", "db_engine = create_engine(\"mysql+pymysql://{}:{}@{}:{}/{}?charset=utf8\".format(mysql_user, mysql_password, mysql_host, mysql_port, mysql_db),\n", " pool_recycle=7200,pool_size=2)" ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [], "source": [ "sql=\"select * from plclog where substr(time,1,10)='2023-05-31' and steps=6 \"" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [], "source": [ "data=pd.read_sql_query(sql, db_engine)" ] }, { "cell_type": "code", "execution_count": 9, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(22180, 114)" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "data.shape" ] }, { "cell_type": "code", "execution_count": 12, "metadata": {}, "outputs": [], "source": [ "tar_list=[\"time\",\"change_flag\",\"pressure_1\",\"pressure_3\"]" ] }, { "cell_type": "code", "execution_count": 13, "metadata": {}, "outputs": [], "source": [ "data_s=data[tar_list]" ] }, { "cell_type": "code", "execution_count": 14, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | time | \n", "change_flag | \n", "pressure_1 | \n", "pressure_3 | \n", "
---|---|---|---|---|
0 | \n", "2023-05-31 00:00:21.738 | \n", "1 | \n", "117.0 | \n", "17.4 | \n", "
1 | \n", "2023-05-31 00:00:21.838 | \n", "1 | \n", "117.0 | \n", "17.4 | \n", "
2 | \n", "2023-05-31 00:00:21.938 | \n", "1 | \n", "118.4 | \n", "17.4 | \n", "
3 | \n", "2023-05-31 00:00:22.038 | \n", "1 | \n", "118.4 | \n", "17.4 | \n", "
4 | \n", "2023-05-31 00:00:22.138 | \n", "1 | \n", "118.4 | \n", "17.4 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
22175 | \n", "2023-05-31 23:57:05.038 | \n", "419 | \n", "868.9 | \n", "635.2 | \n", "
22176 | \n", "2023-05-31 23:57:05.138 | \n", "419 | \n", "868.9 | \n", "641.3 | \n", "
22177 | \n", "2023-05-31 23:57:05.238 | \n", "419 | \n", "868.9 | \n", "641.3 | \n", "
22178 | \n", "2023-05-31 23:57:05.338 | \n", "419 | \n", "873.1 | \n", "641.3 | \n", "
22179 | \n", "2023-05-31 23:57:05.438 | \n", "419 | \n", "873.1 | \n", "641.3 | \n", "
22180 rows × 4 columns
\n", "\n", " | change_flag | \n", "pres_1_max | \n", "pres_1_last | \n", "pres_3_max | \n", "pres_3_last | \n", "
---|---|---|---|---|---|
0 | \n", "1 | \n", "1224.9 | \n", "792.9 | \n", "721.2 | \n", "704.6 | \n", "
1 | \n", "3 | \n", "1377.5 | \n", "852.3 | \n", "674.6 | \n", "622.7 | \n", "
2 | \n", "5 | \n", "1173.4 | \n", "734.1 | \n", "785.8 | \n", "756.3 | \n", "
3 | \n", "7 | \n", "1358.8 | \n", "852.6 | \n", "698.6 | \n", "618.0 | \n", "
4 | \n", "9 | \n", "1171.7 | \n", "805.5 | \n", "713.8 | \n", "674.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
198 | \n", "411 | \n", "1324.8 | \n", "783.8 | \n", "716.9 | \n", "686.9 | \n", "
199 | \n", "413 | \n", "1192.2 | \n", "851.9 | \n", "711.9 | \n", "649.4 | \n", "
200 | \n", "415 | \n", "1444.0 | \n", "865.2 | \n", "665.1 | \n", "625.5 | \n", "
201 | \n", "417 | \n", "1152.1 | \n", "828.1 | \n", "716.7 | \n", "700.6 | \n", "
202 | \n", "419 | \n", "1363.4 | \n", "873.1 | \n", "762.8 | \n", "641.3 | \n", "
203 rows × 5 columns
\n", "\n", " | change_flag | \n", "pres_1_max | \n", "pres_1_last | \n", "pres_3_max | \n", "pres_3_last | \n", "pres_1_delta | \n", "pres_3_delta | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "1 | \n", "1224.9 | \n", "792.9 | \n", "721.2 | \n", "704.6 | \n", "432.0 | \n", "16.6 | \n", "
1 | \n", "3 | \n", "1377.5 | \n", "852.3 | \n", "674.6 | \n", "622.7 | \n", "525.2 | \n", "51.9 | \n", "
2 | \n", "5 | \n", "1173.4 | \n", "734.1 | \n", "785.8 | \n", "756.3 | \n", "439.3 | \n", "29.5 | \n", "
3 | \n", "7 | \n", "1358.8 | \n", "852.6 | \n", "698.6 | \n", "618.0 | \n", "506.2 | \n", "80.6 | \n", "
4 | \n", "9 | \n", "1171.7 | \n", "805.5 | \n", "713.8 | \n", "674.0 | \n", "366.2 | \n", "39.8 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
198 | \n", "411 | \n", "1324.8 | \n", "783.8 | \n", "716.9 | \n", "686.9 | \n", "541.0 | \n", "30.0 | \n", "
199 | \n", "413 | \n", "1192.2 | \n", "851.9 | \n", "711.9 | \n", "649.4 | \n", "340.3 | \n", "62.5 | \n", "
200 | \n", "415 | \n", "1444.0 | \n", "865.2 | \n", "665.1 | \n", "625.5 | \n", "578.8 | \n", "39.6 | \n", "
201 | \n", "417 | \n", "1152.1 | \n", "828.1 | \n", "716.7 | \n", "700.6 | \n", "324.0 | \n", "16.1 | \n", "
202 | \n", "419 | \n", "1363.4 | \n", "873.1 | \n", "762.8 | \n", "641.3 | \n", "490.3 | \n", "121.5 | \n", "
203 rows × 7 columns
\n", "