91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 0.05M
    文件類型: .rar
    金幣: 1
    下載: 0 次
    發(fā)布日期: 2024-05-07
  • 語言: Python
  • 標(biāo)簽: 負(fù)荷一寸??

資源簡介

實時負(fù)荷預(yù)測,15分鐘到4小時

資源截圖

代碼片段和文件信息

import?MySQLdb
import?pandas?as?pd

class?Data():

????def?connect(self):
????????self.db?=?MySQLdb.Connect(“192.168.0.250“?“mywind“?“123456“?“pems“)
????????self.cursor?=?self.db.cursor()
????????#?print(“連接數(shù)據(jù)庫成功“)

????def?getModelData(self):
????????self.connect()
????????self.cursor.execute(
????????????“SELECT?time?volum?FROM?data_load“)
????????data?=?self.cursor.fetchall()
????????self.db.close()
????????data?=?self.prefixData(data)
????????return?data

????def?getPredictData(self?startTime?endTime):
????????self.connect()

????????sql?=?“SELECT?time?volum?FROM?data_load?where?time?between?‘“?+?startTime?+?“‘?and?‘“?+?endTime?+?“‘“

????????self.cursor.execute(sql)
????????data?=?self.cursor.fetchall()
????????self.db.close()
????????data?=?self.prefixData(data)

????????return?data

????def?savePredictData(self?time?value):
????????#?self.connect()

????????sql?=?‘‘

????????id?=?self.countTime(time)

????????if?self.countTime(time)?>?0:
????????????sql?=?“UPDATE?data_load?set?predict?=?“?+?str(value)?+?“?where?id=“?+?str(id)
????????else:
????????????sql?=?“INSERT?INTO?data_load(time?predict)?VALUES?(‘“?+?time?+?“‘“?+?str(value)?+?“)“

????????print(sql)

????????self.cursor.execute(sql)
????????self.db.commit()
????????self.db.close()

????????#?sql?=?“““?insert?into?%s?%s?values?%s?“““?%?(dbName?dbField?data_values)

????def?countTime(self?time):
????????self.connect()
????????sql?=?“SELECT?id?FROM?pems.data_load?where?time?=?‘“?+?time?+?“‘“

????????self.cursor.execute(sql)
????????data?=?self.cursor.fetchone()[0]

????????print(data)

????????return?data


????def?prefixData(self?data):
????????ret?=?[];

????????for?i?in?range(len(data)):
????????????ret.append(data[i][1])

????????return?ret;





?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????36963??2020-11-23?14:41??數(shù)據(jù)集\data_load.csv

?????文件?????144919??2019-08-14?22:43??數(shù)據(jù)集\loaddata.txt

?????文件???????1844??2020-09-02?17:41??源碼\data.py

?????文件???????3777??2020-09-02?17:41??源碼\LSTM.py

?????文件???????2413??2020-09-02?17:41??源碼\predict.py

?????目錄??????????0??2020-11-23?14:46??數(shù)據(jù)集

?????目錄??????????0??2020-11-23?14:46??源碼

-----------?---------??----------?-----??----

???????????????189916????????????????????7


評論

共有 條評論

相關(guān)資源