我正在尝试使用pandas绘制一个数据框。我使用的csv文件是:
我的代码到目前为止是:
我想在X轴上绘制这个数据框中的所有时间值。 因此,我从“Time”列中创建了一个列表,并将其设置为x轴的值,如下所示:
以下是我目前能够获取到的图表: 所以X轴的标签显示为“时间”。我如何在X轴上显示“时间”列中的时间值?
Time,Total cpu%,Used mem(k),Cache mem(k),Net mem Used%,Total mem Used%,Swap mem(%),process1 cpu%,process1 mem%,
4:19:25,12.5,885324,1249960,38.38,38.38,0,6.2,34.7
4:19:28,0.4,885460,1249804,38.39,38.39,0,5.3,34.7
4:19:31,1.8,885700,1249528,38.4,38.4,0,5,34.7
4:19:34,0.7,885700,1249528,38.4,38.4,0,5.3,34.7
4:19:37,0.4,885708,1249528,38.4,38.4,0,5.3,34.7
4:19:40,2.1,885704,1249528,38.4,38.4,0,5.3,34.7
4:19:43,0.4,885704,1249528,38.4,38.4,0,5,34.7
4:19:47,0.7,885700,1249528,38.4,38.4,0,5.3,34.7
4:19:50,13.8,885704,1249528,38.4,38.4,0,16,34.7
我的代码到目前为止是:
import pandas as pd
import matplotlib.pyplot as plt
# create dataframe
df = pd.read_csv('sample_csv.csv')
# select only cpu columns
cpu_columns = ['Total cpu%', 'process1 cpu%']
# dataframe from cpu columns
df1 = df[cpu_columns]
我想在X轴上绘制这个数据框中的所有时间值。 因此,我从“Time”列中创建了一个列表,并将其设置为x轴的值,如下所示:
x_axis = df["Time"].values
# plot dataframe
df1.plot(x=df["Time"])
plt.show()
以下是我目前能够获取到的图表: 所以X轴的标签显示为“时间”。我如何在X轴上显示“时间”列中的时间值?
FutureWarning: Passing timedelta64-dtype data is deprecated, will raise a TypeError in a future version
- gies0r