pacman::p_load(readr)
pacman::p_load(stringr)
pacman::p_load(lubridate)
raw_cast <- read.csv("raw_cast.csv")
str(raw_cast)
cast_revised <- str_split_fixed(raw_cast$Name.2, "\n", 2)
class(cast_revised)
[1] "matrix" "array"
raw_cast$Name2 <- cast_revised[,1]
raw_cast$Episode <- cast_revised[,2]
str_trim(raw_cast$Episode, side="both")
LS0tCnRpdGxlOiAiV29ya3Nob3AgNCAtIE9jdG9iZXIsIDQiCm91dHB1dDogaHRtbF9ub3RlYm9vawotLS0KCmBgYHtyfQpwYWNtYW46OnBfbG9hZChyZWFkcikKcGFjbWFuOjpwX2xvYWQoc3RyaW5ncikKcGFjbWFuOjpwX2xvYWQobHVicmlkYXRlKQpgYGAKCmBgYHtyfQpyYXdfY2FzdCA8LSByZWFkLmNzdigicmF3X2Nhc3QuY3N2IikKc3RyKHJhd19jYXN0KQpgYGAKCmBgYHtyfQpjYXN0X3JldmlzZWQgPC0gc3RyX3NwbGl0X2ZpeGVkKHJhd19jYXN0JE5hbWUuMiwgIlxuIiwgMikKY2xhc3MoY2FzdF9yZXZpc2VkKQpgYGAKCmBgYHtyfQpyYXdfY2FzdCROYW1lMiA8LSBjYXN0X3JldmlzZWRbLDFdCnJhd19jYXN0JEVwaXNvZGUgPC0gY2FzdF9yZXZpc2VkWywyXQpgYGAKCmBgYHtyfQpzdHJfdHJpbShyYXdfY2FzdCRFcGlzb2RlLCBzaWRlPSJib3RoIikKYGBgCgo=