时间戳

首页 > 解决方案 > 如何在一张图上绘制来自多个 csv 文件的数据

python - 如何在一张图上绘制来自多个 csv 文件的数据

问题描述

使用下面的代码，我可以按照我想要的方式获得两个单独的图，减去轴标签和 x 轴上的正确日期/时间，但接下来我会学习，但我希望将两个系列都绘制在同一个图上.

    import os
    import pandas as pd
    import numpy as np
    import matplotlib.pyplot as plt

    PATH = ('pathname...')
    fileNames = os.listdir(PATH)

    fileNames = [file for file in fileNames if '.csv' in file]

    for file in fileNames:
        df = pd.read_csv(PATH + file)
        df1 = df[df['Station Name'].str.contains('Precip')]

        df1.plot()

    plt.show()

我正在加载的 csv 文件看起来像这样

     Station Name,Sensor Serial Num,model and version,Slope,Offset,Averaging Time,Sampling Interval
     123456789,NA12345,FpRain ver 1.06,-2.4418566 ,-3.3988995 ,2.000 sec,0 ms
     Precip,02/01/2020,09:45:00,-2.19,
     Batt Voltage,02/01/2020,09:45:00,13.4,
     Temp In Box,02/01/2020,09:45:00,-2.58,
     Precip,02/01/2020,10:00:00,-2.19,
     Batt Voltage,02/01/2020,10:00:00,13.6,
     Temp In Box,02/01/2020,10:00:00,-2.17,
     Precip,02/01/2020,10:15:00,-2.19,
     Batt Voltage,02/01/2020,10:15:00,13.7,
     Temp In Box,02/01/2020,10:15:00,-1.72,

标签： pythonpandasmatplotlib

解决方案

推荐阅读