我有一个数据集,类似于:
Asset Name Time Usage
A 10:39:49 CPU usage
A 10:46:35 CPU usage
B 11:06:55 CPU usage
C 11:24:05 Memory usage
A 11:31:35 Memory usage
B 13:46:17 CPU usage
A 10:35:43 Virtual Machine Failover Failed
C 10:40:55 CPU usage
B 10:45:05 CPU usage
A 11:31:35 CPU usage
B 10:59:44 Memory usage
B 11:44:36 CPU usage
A 11:49:22 Memory usage
我想根据使用情况绘制资产名称与时间的对比图。我用了密码:
ggplot(DTPlot, aes(DTPlot$Time, Asset.Name, color = Usage)) + geom_point() +
scale_x_time() + xlab("") + ylab("Asset Name")
我上X轴的时间从00:00到00:00:24.我怎样才能在绘图集中得到时间序列呢?
提前感谢!
发布于 2018-05-03 03:45:48
你是说像这样的事吗?
df %>%
mutate(Time = as.POSIXct(Time, format = "%H:%M:%S")) %>%
ggplot(aes(Time, Asset.Name, color = Usage)) +
geom_point() +
labs(x = "", y = "Asset Name")
样本数据
df <-read.table(text =
"'Asset Name' Time Usage
A 10:39:49 'CPU usage'
A 10:46:35 'CPU usage'
B 11:06:55 'CPU usage'
C 11:24:05 'Memory usage'
A 11:31:35 'Memory usage'
B 13:46:17 'CPU usage'
A 10:35:43 'Virtual Machine Failover Failed'
C 10:40:55 'CPU usage'
B 10:45:05 'CPU usage'
A 11:31:35 'CPU usage'
B 10:59:44 'Memory usage'
B 11:44:36 'CPU usage'
A 11:49:22 'Memory usage'", header = T)
https://stackoverflow.com/questions/50146498
复制相似问题