I am trying to separate the second column ('text') of this tibble into multiple columns based on the "," separator in using separate(). However, the output I am getting has "wins = 4" etc. instead of just "4" in each cell. How do I get around this so the cells are not modified in this way?
This is the initial tibble I am trying to change:
Initial tibble
This is my code:
'''
new_all_team_tbl <- all_team_tbl %>%
separate(text, c("col1", "col2", "col3", "col4", "col5", "col6", "col7",
"col8"), ",")
new_all_team_tbl
'''
This is the output I am getting:
New tibble