separate columns with condition

Question

I have a csv file from movielens that i'm trying to manipulate.

The movie list in my data.frame contains movie title and the year of movie and what i'm trying to separate the year and title to separate columns.

I used the folowing code:

movies <- extract(movies, title, c("title", "year"), "^(.*) \\(([0-9 \\-]*)\\)$")

I succeded to that but there is movies that contains only names and for those movies i get NA for the hole rows instead of getting NA for only "Year" column.

Could you provide a [mcve]? Then people will be better able to help. — , Apr 02 '18 at 12:27
In particular, please include the output of `dput(movies[1:10,])` in your question. — G5W, Apr 02 '18 at 12:32

score 0 · Answer 1 · answered Apr 02 '18 at 12:51

0

enter image description here

This is how the results looks

answered Apr 02 '18 at 12:51

mono1401

1

separate columns with condition

1 Answers1