user987875 user987875 - 2 months ago 11x
R Question

R read data from stdout of system command into data frame

I call a system command with

driveFileList <- try("/usr/local/bin/gdrive list "), intern = TRUE, ignore.stderr = TRUE)))

I check the result with


and I see that I have a list with 3 rows and 0 columns.

But the system command gives me actually something like this

1 Id Name Type Created
2 23423423 nameOfFile1.csv doc 2016-08-22 18:40:05
3 2342342 nameOfFile2.csv doc 2016-08-22 18:39:39
4 34323334 nameOfFile3.csv doc 2016-08-23 17:58:46

How can I 'explode' this, that I get a real data frame?


Answer doesn’t do what you think it does. The system command gives you back a character string (of some format), so you need to parse it. Try read.table or a similar function (which exactly to use, and what parameters, depends on the exact output of the call).

You either need to pass the text into the function via its text argument (i.e. result = read.table(text = system_output, …)) or you could usepipeinstead ofsystem`, and read the resulting stream.

Looking at the readme of gdrive, it looks as if read.fwf would be more appropriate than read.table in your instance.