i've got a problem with getting the data from https://www.kaggle.com/groffo/ads16-dataset into a usable form.
Here is an example file: https://www.dropbox.com/s/p5bfg3tssec0ow8/U0001-RT.csv?dl=0
i put all 120 *RT.csv files into one folder. One file contains 300 ad ratings.
I imported them with:
temp = list.files(pattern="*.csv")
myfiles = lapply(temp, read.delim, stringsAsFactors = FALSE, sep = ";")
my goal is to get a row per person and the 300 ad ratings as columns (maybe there is some way to use the already existing labels [from Cat0 to Cat19] , but divide it into 15 sub-categories [Cat01, Cat02...Cat11, Cat12]).
Maybe someone got a few tips for me (playing around for one day already - getting serious headache now). That would be great!