Function of strings to tibble

Question

I need to define a function f(x,y) such that:

x = "col1,1,2,3,4"
y = "col2,a,b,c,d"

becomes:

# A tibble: 4 x 2
   col1  col2
  <int> <chr>
1     1     a
2     2     b
3     3     c
4     4     d

Any thoughts? Thanks.

Why do you need to do that? What's the actual problem you're trying to solve? Have you tried anything so far? — A5C1D2H2I1M1N2O1R2T1, Feb 14 '18 at 17:07
please post what you've already done to try to solve the issue! — Matt W., Feb 14 '18 at 17:15

score 1 · Answer 1 · answered Feb 14 '18 at 17:42

The most obvious idea that comes to mind is to split the input by comma, use paste to combine the output into a single string, and read that using read_csv.

Example:

paste(do.call(paste, c(strsplit(c(x, y), ","), sep = ", ")), collapse = "\n")
# [1] "col1, col2\n1, a\n2, b\n3, c\n4, d"

library(tidyverse)
read_csv(paste(do.call(paste, c(strsplit(c(x, y), ","), sep = ", ")), collapse = "\n"))
# # A tibble: 4 x 2
#    col1 col2 
#   <int> <chr>
# 1     1 a    
# 2     2 b    
# 3     3 c    
# 4     4 d

From there, I hope you're able to convert the approach to a function.

Function of strings to tibble

1 Answers1