Hi All,
I'm having a lot of issues using write.table to write the result of twitter data using TwitteR to a csv file. The write.table function keeps overlapping the results and generating Na's. Especially when I append to it.
Here is the code;
#data collector
data <- searchTwitter("endsars", n = 30,
resultType = "recent", lang = "en")
#data %>% twListToDF() %>%
write.table(twListToDF(data), "myDF.csv", sep = ",", col.names = !file.exists("myDF.csv"), append = T, row.names = F)
A lot of the data get's messed up with the text column overlapping other columns. Please help!