Hi,
I have a bunch of csv files to read in R. I'm unable to read them correctly
because in some of the files, there is a column ("Role") which has comma in
the values.
Sample data:
User, Role, Rule, GAPId
Sam, [HadoopAnalyst, DBA, Developer], R46443
I'm trying to play with the below code but it doesnt work:
files <- list.files(pattern='.*REDUNDANT(.*).csv$')
tbl <- sapply(files, function(f) {
gsub('\\[|\\]', '"', readLines(f)) %>%
read.csv(text = ., check.names = FALSE)
}) %>%
bind_rows(.id = "id") %>%
select(id, User, Rule) %>%
distinct()
Please assist.
Thanks
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
