将.csv转换为Json，多个属性值

Question

我正在尝试将电子表格转换为json文件，该文件将用Exhibit 3.0读取。这是一个样本电子表格(候选人的技能1-6)：

label   Skills
1       SQL
2       SQL, SAS
3   
4       MS Office
5       MS Office, SQL
6       SAS

每当我尝试转换时，我都会得到：

[{"label":"1","Skills":"SQL"},
{"label":"2","Skills":"SQL, SAS"},
{"label":"3","Skills":""},
{"label":"4","Skills":"MS Office"},
{"label":"5","Skills":"MS Office, SQL"},
{"label":"6","Skills":"SAS"}]

我需要的是(注意方括号)：

 [{"label":"1","Skills":"SQL"},
{"label":"2","Skills":["SQL", "SAS"]},
{"label":"3","Skills":""},
{"label":"4","Skills":"MS Office"},
{"label":"5","Skills":["MS Office", "SQL"]},
{"label":"6","Skills":"SAS"}]

只有这样，Exhibit才会接受候选人可以拥有多项技能。有没有办法创建这些方括号？或者，有没有其他方法可以设计电子表格，这样Exhibit就会认识到2号候选人有两项技能？我一直在使用R和Excel，到目前为止还没有找到解决方案。

谢谢!

Answer 1

我尝试过重现您的代码，您的问题是您将技能看作是一列字符，如果您将每个元素都看作是一个向量，那么jsonlite包中的函数toJSON就做得很好，并且在将数组转换为JSON时将“”

df <- data.frame(
  label=1:6, 
  Skills2=c("SQL","SQL, SAS","","MS Office","MS Office, SQL","SAS"),
  stringsAsFactors=F)

df$Skills <- strsplit(df$Skills2, ", ")
df$Skills2 <- NULL

toJSON(df)

我希望它适用于你的

[{"label":1,"Skills":["SQL"]},
{"label":2,"Skills":["SQL","SAS"]},
{"label":3,"Skills":[]},
{"label":4,"Skills":["MS Office"]},
{"label":5,"Skills":["MS Office","SQL"]},
{"label":6,"Skills":["SAS"]}]