Hello,
I am working with some 2700 files in .xlsx format
Like the one attached below
I want to transform all tabular data to a single row as shown below in
example or in attachment
so that all data can be used as a variable.
and replicate all to make a single csv file which has all the data
Hi samarvir,
Your attachment didn't make it through the list filter. From your
example, you seem to want something like this:
# assume you are using the readxl package to read the data in
mydf-read_excel(mydata.xlsx,col_types=rep(character,11))
mydatavector-as.vector(as.matrix(mydf))
This is
2 matches
Mail list logo