I'm looking for some help with the following.
The data are into two folders. Each file is a txt file containing 16 columns and more than 7000 rows like this:
I want to transform each file into a single long column, using the library data.table like this :
library(data.table) setDT(a1) a1<-melt(a1)[, .(value)]
The idea is to build a for loop that loads each file, transforms it into a single column dataframe and then exports it into another folder.
Any idea from where to start?