{ "cells": [ { "cell_type": "code", "execution_count": 10, "metadata": {}, "outputs": [], "source": [ "###分时段预测\n", "###丰都站\n", "###ses算法" ] }, { "cell_type": "code", "execution_count": 11, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "from pandasql import sqldf \n", "from sqlalchemy import create_engine\n", "import statsmodels.api as sm \n", "import numpy as np\n", "\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 = 'algo'\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": 61, "metadata": {}, "outputs": [], "source": [ "sql=\"select * from algo_dwd_station_change_static where organ_code='fengdu2' and algo='tes' and pre_time=1 and data_period=3\"\n", "\n", "change_data=pd.read_sql(sql, db_engine)" ] }, { "cell_type": "code", "execution_count": 62, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(16969, 9)" ] }, "execution_count": 62, "metadata": {}, "output_type": "execute_result" } ], "source": [ "change_data.shape" ] }, { "cell_type": "code", "execution_count": 63, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | id | \n", "day | \n", "slot | \n", "c_b_count | \n", "pre | \n", "pre_time | \n", "organ_code | \n", "algo | \n", "data_period | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "170283 | \n", "2022-02-24 | \n", "22:30-22:59 | \n", "0 | \n", "0 | \n", "1 | \n", "fengdu2 | \n", "tes | \n", "3 | \n", "
1 | \n", "170286 | \n", "2022-02-24 | \n", "23:00-23:29 | \n", "0 | \n", "0 | \n", "1 | \n", "fengdu2 | \n", "tes | \n", "3 | \n", "
2 | \n", "170289 | \n", "2022-02-24 | \n", "23:30-23:59 | \n", "0 | \n", "0 | \n", "1 | \n", "fengdu2 | \n", "tes | \n", "3 | \n", "
3 | \n", "170292 | \n", "2022-02-25 | \n", "00:00-00:29 | \n", "0 | \n", "0 | \n", "1 | \n", "fengdu2 | \n", "tes | \n", "3 | \n", "
4 | \n", "170295 | \n", "2022-02-25 | \n", "00:30-00:59 | \n", "0 | \n", "0 | \n", "1 | \n", "fengdu2 | \n", "tes | \n", "3 | \n", "