首页 > 解决方案 > 抖动图中的订单天数

问题描述

我有一个包含两列(工作日和销售)的数据集。所以我的意图是用 ggplot2 制作抖动图。您可以在下面看到数据集。

#DATA

library(ggplot2)
     INPUT_MATRIX_FINAL_GRAPH_test<-structure(list(Weekdays = c("Tuesday", "Thursday", "Thursday", 
                                        "Saturday", "Wednesday", "Sunday", "Friday", "Wednesday", "Sunday", 
                                        "Thursday", "Tuesday", "Friday", "Sunday", "Thursday", "Monday", 
                                        "Thursday", "Friday", "Saturday", "Sunday", "Thursday", "Tuesday", 
                                        "Wednesday", "Tuesday", "Friday", "Saturday", "Tuesday", "Monday", 
                                        "Friday", "Sunday", "Tuesday", "Wednesday", "Wednesday", "Sunday", 
                                        "Monday", "Tuesday", "Tuesday", "Thursday", "Wednesday", "Friday", 
                                        "Thursday", "Monday", "Tuesday", "Thursday", "Saturday", "Tuesday", 
                                        "Friday", "Sunday", "Saturday", "Sunday", "Tuesday", "Tuesday", 
                                        "Friday", "Friday", "Wednesday", "Saturday", "Friday", "Thursday", 
                                        "Friday", "Wednesday", "Wednesday", "Friday", "Friday", "Sunday", 
                                        "Saturday", "Friday", "Thursday", "Monday", "Wednesday", "Tuesday", 
                                        "Sunday", "Thursday", "Sunday", "Monday", "Thursday", "Tuesday", 
                                        "Thursday", "Sunday", "Saturday", "Tuesday", "Wednesday", "Wednesday", 
                                        "Monday", "Saturday", "Monday", "Tuesday", "Thursday", "Friday", 
                                        "Friday", "Sunday", "Tuesday", "Monday", "Saturday", "Wednesday", 
                                        "Thursday", "Friday", "Thursday", "Thursday", "Tuesday", "Friday", 
                                        "Friday", "Sunday", "Tuesday", "Tuesday", "Thursday", "Friday", 
                                        "Monday", "Wednesday", "Sunday", "Sunday", "Thursday", "Tuesday", 
                                        "Tuesday", "Monday", "Wednesday", "Friday", "Friday", "Wednesday", 
                                        "Thursday", "Wednesday", "Sunday", "Monday", "Tuesday", "Wednesday", 
                                        "Saturday", "Saturday", "Tuesday", "Sunday", "Thursday", "Thursday", 
                                        "Friday", "Sunday", "Sunday", "Wednesday", "Friday", "Monday", 
                                        "Saturday", "Monday", "Tuesday", "Saturday", "Monday", "Friday", 
                                        "Tuesday", "Wednesday", "Sunday", "Saturday", "Wednesday", "Thursday", 
                                        "Tuesday", "Saturday", "Tuesday", "Tuesday", "Tuesday", "Sunday", 
                                        "Thursday", "Thursday", "Thursday", "Monday", "Saturday", "Friday", 
                                        "Monday", "Sunday", "Tuesday", "Sunday", "Monday", "Saturday", 
                                        "Tuesday", "Monday", "Sunday", "Thursday", "Wednesday", "Thursday", 
                                        "Friday", "Thursday", "Friday", "Saturday", "Friday", "Friday", 
                                        "Thursday", "Saturday", "Tuesday", "Sunday", "Monday", "Friday", 
                                        "Tuesday", "Friday", "Sunday", "Sunday", "Sunday", "Tuesday", 
                                        "Friday", "Thursday", "Wednesday", "Wednesday", "Monday", "Saturday", 
                                        "Wednesday", "Monday", "Sunday", "Monday", "Wednesday", "Thursday", 
                                        "Saturday", "Saturday", "Tuesday", "Wednesday", "Saturday", "Friday", 
                                        "Monday", "Thursday", "Thursday"), Sales = c(15.9, 16.2, 22.7, 
                                                                                     0, 13.5, 0, 31.3, 13.6, 0, 13, 59.1, 0, 0, 9.9, 29.4, 22.1, 22.4, 
                                                                                     0, 0, 13.4, 19.9, 19, 0, 32.3, 0, 15.1, 0, 24.9, 0, 15.7, 17, 
                                                                                     12, 0, 30.5, 26.6, 0, 23.3, 24.7, 19.7, 27.7, 20.4, 11.4, 20.7, 
                                                                                     0, 23.3, 20.1, 0, 0, 0, 0, 18.1, 14.9, 31.9, 25.5, 0, 24.8, 19, 
                                                                                     17.3, 23.2, 23.1, 16.6, 23.4, 0, 0, 26, 17.6, 22.4, 14.6, 16.2, 
                                                                                     0, 11, 0, 0, 19.8, 19.1, 18.2, 0, 0, 18.8, 0, 14.2, 25.7, 0, 
                                                                                     18.1, 18.6, 19.4, 13.7, 23.5, 0, 72, 18.6, 0, 21.6, 11.1, 14.3, 
                                                                                     21.1, 21.4, 20.6, 25, 23.4, 0, 12.5, 48.7, 25, 15.7, 25, 12.2, 
                                                                                     0, 0, 23.7, 13.4, 17.3, 19.9, 17.3, 18.4, 18.3, 15.2, 25, 21.1, 
                                                                                     0, 25.8, 16.4, 20.5, 0, 0, 14.7, 0, 18.8, 28, 0, 0, 0, 6.4, 28.5, 
                                                                                     0, 0, 23.5, 21, 3.3, 0, 22.4, 21.1, 16.4, 0, 0, 31.8, 21, 14.4, 
                                                                                     0, 25, 16.7, 0, 0, 12.7, 18.7, 14, 22.6, 0, 31.1, 43.2, 0, 19.7, 
                                                                                     0, 25, 0, 17.9, 14.3, 0, 17.3, 13.4, 16.2, 13.7, 21.2, 26.4, 
                                                                                     0, 30.1, 24.5, 18.8, 0, 22.5, 0, 20.9, 0, 16.7, 22.7, 0, 0, 0, 
                                                                                     16.6, 19.7, 18.2, 14.7, 11.7, 16.6, 0, 16.2, 22.3, 0, 19.3, 14.4, 
                                                                                     0, 0, 0, 11.4, 13, 0, 22.9, 24, 19.7, 15)), row.names = c(NA, 
                                                                                                                                               -210L), class = "data.frame")

所以下一步是用这行代码制作抖动图

qplot(Weekdays,Sales,data=INPUT_MATRIX_FINAL_GRAPH_test,geom = "jitter")

到目前为止一切顺利:) 但是这里出现了一个新问题。即天排序不正确,我的下一个陡峭应该是如何按正确的日期名称排序(例如星期一,星期二,星期三,星期四,星期五,星期六,星期日)

在此处输入图像描述

那么有人可以帮我解决这个问题吗?

标签: rggplot2

解决方案


您可以scale_x_discrete通过将正确的顺序传递给limits参数来使用和排序天数:

qplot(Weekdays,Sales,data=INPUT_MATRIX_FINAL_GRAPH_test,geom = "jitter")+
  scale_x_discrete(limits = c("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"))

在此处输入图像描述


推荐阅读