使用pandas dataframe python创建实时更新图

我正试图通过从pandas数据框中提取结果来创建一个实时更新图,该数据框存储从本地服务器中获取的动态数据值。

使用pandas dataframe,需要时间并将其存储在一列中,然后将其使用情况存储在另一列中。然后,将其转储到结果表中。2秒后,它将花费时间并再次使用,然后将其追加到结果数据帧/表中。最终,它将在结果表中保留一个运行表:

    >>> print(results)
        time  kW
0   00:32:40   9
1   00:32:42  11
2   00:32:44  10
3   00:32:46  27
4   00:32:48  18
5   00:32:50  11

下面是我的代码,它可以清理本地服务器并将数据存储到这个数据框中。每次我重新运行脚本时,它都会获取存储的以前的数据并将新数据附加到其中,然后将csv文件(包含time&kw数据)写入指定的文件路径:

import requests
import bs4 
import time
import pandas as pd
from datetime import datetime
import glob
import os




def hasNumbers(inputString):
    return any(char.isdigit() for char in inputString)

def get_count():
    url = "http://10.0.0.206/temp_report.html"

    # request with fake header, otherwise you will get an 403 HTTP error
    r = requests.get(url, headers={'User-Agent': 'Mozilla/5.0'})
    page_source = r.text
    # print(page_source)

    soup = bs4.BeautifulSoup(page_source, 'html.parser')
    #print(soup)


    data = soup.find_all('p')

    # Pull time
    data_time = data[0].text.split()
    data_time = [element for element in data_time if hasNumbers(element)][0]

    # Pull date
    data_date = data[1].text.split()
    data_date = [element for element in data_date if hasNumbers(element)][0]

    # Convert date and time to datetime data type
    data_datetime = data_date +' '+ data_time
    data_datetime = datetime.strptime(data_datetime, '%Y-%m-%d %H:%M:%S')

    # Pull usage and convert to data type int
    data_usage = data[2].text.split()
    data_usage = [element for element in data_usage if hasNumbers(element)][0]
    data_usage = int(data_usage)


    temp_df = pd.DataFrame(data = [[data_time, data_usage]], columns = ['time', 'kW'] )
    print('Date: %s     Time: %s      Usage: %s kW' %(data_date, data_time, data_usage))
    return temp_df



# change path_to_file string
path_to_file = 'C:/seniord/csusite/'    

# If folder doesn't exist, create it
if not os.path.exists(path_to_file):
    os.makedirs(path_to_file)

# get all files in that folder
fnames = glob.glob('*.csv')

# if there are no files, start with new dataframe
# else, get the most recently saved data and read that to continue appending
if fnames == []:
    results = pd.DataFrame()
else: 
    latest_file = max(fnames, key=os.path.getctime)
    results = pd.read_csv(path_to_file+latest_file)


date_stored = datetime.now().strftime('%Y_%m_%d_%HH_%M_%S') 
while True:
    df = get_count()
    results = results.append(df).reset_index(drop=True)
    #results.to_csv(path_to_file+'%s_kW_usage.csv' %(date_stored),index=False) #If you want to create a new csv file to the folder, uncomment this. Otherwise use the code below
    results.to_csv(path_to_file+'kW_usage.csv',index=False)

    time.sleep(2)

需要 :图形的y轴显示kw列,x轴显示相应的时间列。然后,我只想在图形或其他东西上方自动打印出日期戳(仅限日期)。

我非常感谢你们的指导