r - 预期和实际列在解析 R 中的错误时没有意义
问题描述
我的代码通过一长串 URL 来制作空气质量数据表。但是,我不断收到我不理解的解析错误。
这是我的图书馆:
library(tidyverse)
library(lubridate)
library(chron)
library(lemon)
生成 URL,然后创建表的代码如下所示:
i = 1
tempList <- list()
for(p in Pollutants){
for(s in Stations){
for(y in Years){
# Build URL
url_download <- paste("http://www.airqualityontario.com/history/index.php?s=",s,"&y=",y,"&p=",p,"&m=",mS,"&e=",mE,"&t=csv&submitter=Search&i=1", sep = "")
print(url_download)
# Read in File
if(p == 124){
MOE_download <- read_csv(file = url_download ,skip = 15 , na = c("9999", "-999"))
}else{
MOE_download <- read_csv(file = url_download ,skip = 14 , na = c("9999", "-999"))
}
}
}
}
但是,我收到一个奇怪的解析错误,我不明白。它看起来像这样:
-- Column specification -------------------------------------------------------------------------------------------------------
cols(
`Chatham (13001)` = col_character()
)
Warning: 379 parsing failures.
row col expected actual file
2 -- 1 columns 2 columns 'http://www.airqualityontario.com/history/index.php?s=13001&y=2020&p=124&m=1&e=12&t=csv&submitter=Search&i=1'
3 -- 1 columns 2 columns 'http://www.airqualityontario.com/history/index.php?s=13001&y=2020&p=124&m=1&e=12&t=csv&submitter=Search&i=1'
4 -- 1 columns 2 columns 'http://www.airqualityontario.com/history/index.php?s=13001&y=2020&p=124&m=1&e=12&t=csv&submitter=Search&i=1'
5 -- 1 columns 2 columns 'http://www.airqualityontario.com/history/index.php?s=13001&y=2020&p=124&m=1&e=12&t=csv&submitter=Search&i=1'
6 -- 1 columns 2 columns 'http://www.airqualityontario.com/history/index.php?s=13001&y=2020&p=124&m=1&e=12&t=csv&submitter=Search&i=1'
它说它有 2 列,预期为 1,但这对我来说没有意义,因为当我检查数据框的大小时,它看起来像这样:
dim(MOE_download_test)
[1] 384 1
如果有人可以帮助我解决这个问题,我将非常感谢一些指导。