Create automatically a table from a data output in R

Question

I have some trouble in R and hope to find some help here.

I have a data output from a loop of the following form, whereas the number of countries can vary:

> data
$Australia
   HITTypeId    HITId    Valid
1   123          555     TRUE

$India
   HITTypeId    HITId    Valid
 1  456          888     TRUE

Now what I am looking for, is to create a data table that gives my automatically something of the following form:

  country       HITTypeId      HITId    Valid
1  Austria         123          555     TRUE
2  Belgium         456          888     TRUE

I would appreciate any help!

I think you've got a named list of data.frames. You can use do.call(rbind, yourlist) to convert to a single data.frame where country will be the row.names. If you can provide the output of str(yourlist) or dput(head(yourlist)) you will likely get an even better answer — Justin
– Justin, Commented Apr 3, 2013 at 14:16
@justin, your comment was not visible when I answered. Post it as an answer so I can delete mine. — Ferdinand.kraft
– Ferdinand.kraft, Commented Apr 3, 2013 at 14:19

Ferdinand.kraft · Accepted Answer · 2013-04-03 14:18:21Z

2

Use this function:

do.call(rbind, data)

answered Apr 3, 2013 at 14:18

Ferdinand.kraft

12.8k10 gold badges50 silver badges71 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

joran Over a year ago

Whoever ends up with the answer of record should note that the country names will end up not as a variable but as row names, but that last piece can be added via result$country <- rownames(result) or something.

Collectives™ on Stack Overflow

Create automatically a table from a data output in R

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related