openpyxl+pandas
# coding=utf-8
import pandas as pd
import time
from openpyxl import Workbook
from openpyxl.chart import (
LineChart,
Reference,
)
from openpyxl.chart.axis import DateAxis
def cpu_info(csv_path="./datas-permon/CPU_20200111005156.csv"):
df = pd.read_csv(csv_path) #dtype={'timeStamp':str}
df['timeStamp'] = df['timeStamp'].apply(lambda x:time.strftime('%Y%m%d%H%M%S'
,time.localtime(int(str(x)[:10]))))
user=df.loc[df.label=="192.168.110.151 CPU user"][["label","timeStamp","elapsed"]]
iowait=df.loc[df.label=="192.168.110.151 CPU iowait"][["label","timeStamp","elapsed"]]
idle=df.loc[df.label=="192.168.110.151 CPU idle"][["label&