Modifying data in R

Question

I have data set in the following format

Ids                             Country
98643                           USA
98175 98181 98185 98191 98194   AUSTRALIA
98570                           GERMANY
98848 98824                     ITALY

and what I need is the data in the following format

Ids Country
98643   USA
98175   AUSTRALIA
98181   AUSTRALIA
98185   AUSTRALIA
98191   AUSTRALIA
98194   AUSTRALIA
98570   GERMANY
98848   ITALY
98824   ITALY

If anyone could help me in transforming the data in R programming it would be very helpful.

score 0 · Answer 1 · answered Aug 12 '19 at 17:19

0

Using tidyr -

yourdf %>% separate_rows(Ids, sep = " ")

answered Aug 12 '19 at 17:19

Shree

10,835
1
14
36

Modifying data in R

1 Answers1