二次指数平滑算法Python实现

最新推荐文章于 2024-08-02 09:40:54 发布

EdwardLorenz

最新推荐文章于 2024-08-02 09:40:54 发布

阅读量4.3k

点赞数 1

分类专栏：机器学习

本文链接：https://blog.csdn.net/EdwardLorenz/article/details/62237565

版权

本文介绍了如何使用Python编程语言实现二次指数平滑算法，该算法常用于时间序列预测，通过平滑数据来减少噪声并捕捉趋势。

摘要由CSDN通过智能技术生成

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import pymysql
# Read data from csv files
# df = pd.read_csv('E://CapacityData/test-data-set/MeishanRenshou.csv')
# Read data from mysql, including downstream_userplane_flux, max_rrc_connection_number.
conn = pymysql.connect(user='root', passwd='root123',
host='localhost', db='capacitypredict', charset='utf8')
cur = conn.cursor()
cur.execute("select concat(netelement,cellid)as id , max_rrc_connection_number from table"
"where DATE_FORMAT(starttime, '%Y-%m-%d')>='2016-11-01' "
"and DATE_FORMAT(starttime, '%Y-%m-%d')<='2016-12-07'"
"order by id ")
sqlData = cur.fetchall()
cur.close()