read.socrata将所有变量格式化为字符

Question

我正在使用read.socrata通过以下代码下载一个私有数据集

# Download private dataset
socrataEmail <- Sys.getenv("SOCRATA_EMAIL", "mark.silverberg+soda.demo@socrata.com")
socrataPassword <- Sys.getenv("SOCRATA_PASSWORD", "7vFDsGFDUG")
privateResourceToReadCsvUrl <- "https://soda.demo.socrata.com/resource/a9g2-feh2.csv" # dataset
read.socrata(url = privateResourceToReadCsvUrl, email = socrataEmail, password = socrataPassword, stringsAsFactors = FALSE)

我想以字符格式下载集合中的所有变量，但current函数没有此选项。有没有人对我如何实现这个目标有什么建议？我知道改变函数是一种选择，但是有没有更简单的呢？

Answer 1

如何使用包装器将列类类强制为字符？

read.socrata.chr <- function( ... )
    data.frame(lapply( read.socrata(...), as.character), stringsAsFactors=FALSE)

# Very light testing:

str(read.socrata.chr(url = privateResourceToReadCsvUrl, email = socrataEmail, password = socrataPassword, stringsAsFactors = FALSE))
'data.frame':   3 obs. of  2 variables:
 $ x: chr  "24323" "4324" "2346"
 $ y: chr  "2432" "2342" "3465"