如何解决RStudio中绘制肠球菌浓度与月份散点图的报错问题？

错误原因分析 #

1. 变量名不匹配：代码里写的Enterococci..cfu.100ml.多了一个末尾的点，但数据集里对应的列名是Enterococci..cfu.100ml，R找不到对应变量，导致绘图时数据缺失，触发x轴范围错误。
2. 月份列类型问题：Month列是字符型，基础plot()函数处理字符型x轴时容易出现范围识别异常，而且默认会按字母顺序排列月份，不符合实际逻辑。

解决步骤 #

步骤1：修正变量名并转换月份为有序因子

先把月份转换成按自然顺序排列的有序因子，同时确保变量名匹配：

# 加载你的数据集
df <- structure(list(Site = c("Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach", "Avalon Beach"), Longitude = c(151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324, 151.3324), Latitude = c(-33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587, -33.63587), Date = c("2018-01-25", "2018-02-07", "2018-02-19", "2018-01-19", "2018-02-01", "2018-03-08", "2018-03-14", "2018-10-09", "2018-10-31", "2018-11-07", "2018-11-19", "2018-05-21", "2018-05-25", "2018-06-07", "2018-06-13", "2018-03-26", "2018-04-10", "2018-05-09", "2018-09-10", "2018-09-14"), Enterococci..cfu.100ml = c(6L, 0L, 1L, 1L, 2L, 0L, 33L, 5L, 0L, 0L, 1L, 0L, 0L, 1L, 0L, 2L, 0L, 0L, 0L, 0L), Month = c("January", "February", "February", "January", "February", "March", "March", "October", "October", "November", "November", "May", "May", "June", "June", "March", "April", "May", "September", "September"), Day.of.Week = c("Thursday", "Wednesday", "Monday", "Friday", "Thursday", "Thursday", "Wednesday", "Tuesday", "Wednesday", "Wednesday", "Monday", "Monday", "Friday", "Thursday", "Wednesday", "Monday", "Tuesday", "Wednesday", "Monday", "Friday")), class = "data.frame", row.names = c(NA, -20L))

# 转换Month为有序因子，按自然月份顺序排列
df$Month <- factor(df$Month, 
                   levels = c("January", "February", "March", "April", "May", "June", 
                              "July", "August", "September", "October", "November", "December"),
                   ordered = TRUE)

步骤2：用基础plot函数绘制散点图

修正变量名后直接绘图：

plot(Enterococci..cfu.100ml ~ Month, data = df)

可选：用ggplot2绘制更美观的散点图

如果想要更清晰的可视化效果，避免点重叠，可以用ggplot2包：

# 未安装ggplot2的话先执行安装
# install.packages("ggplot2")
library(ggplot2)

ggplot(df, aes(x = Month, y = Enterococci..cfu.100ml)) +
  geom_jitter(width = 0.2) +  # 添加偏移避免点重叠
  labs(x = "月份", y = "肠球菌浓度(cfu/100ml)") +
  theme(axis.text.x = element_text(angle = 45, hjust = 1))

关键说明 #

• 转换为有序因子后，x轴会按实际月份顺序排列，而非默认的字母顺序，更符合分析逻辑。
• 变量名的细微差异很容易被忽略，一定要确保代码中的变量名和数据集列名完全一致。

内容的提问来源于stack exchange，提问作者user20297887