pandas 多折线图_pandas 数据可视化之折线图

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","timeStamp","el