Relative Content

Tag Archive for rtidyverseread.csv

strip.white doesn’t work in r if the data frame is too large

I import, clean, and merge two different data sets that are created from Qualtrics surveys. I use read.csv to load the data, and I have strip.white=TRUE to remove leading and trailing spaces. If I filter the import data down to a normal day’s import (30 rows or so), this works fine and there is no white space. If I import the entire dataset without filtering the date first in excel (about 1100 rows), it doesn’t strip the white space. I can’t figure it out at all.

strip.white doesn’t work in r if the data frame is too large

I import, clean, and merge two different data sets that are created from Qualtrics surveys. I use read.csv to load the data, and I have strip.white=TRUE to remove leading and trailing spaces. If I filter the import data down to a normal day’s import (30 rows or so), this works fine and there is no white space. If I import the entire dataset without filtering the date first in excel (about 1100 rows), it doesn’t strip the white space. I can’t figure it out at all.