r - R 问题,csv 文件中的 JSON 对象,每个单元格一个:
问题描述
{"received":1588687345,"guid":"0CA2F400004","eventtype":"sensor","payload":{"time":1588687345,"sensor":[{"type":"temp","unit":"degc","value":20}]}}
{"received":1588687346,"guid":"0CA2F400004","eventtype":"sensor","payload":{"time":1588687344,"sensor":[{"type":"temp","unit":"degc","value":22}]}}
{"received":1588687346,"guid":"0CA2F400004","eventtype":"sensor","payload":{"time":1588687346,"sensor":[{"type":"temp","unit":"degc","value":22}]}}
{"received":1588687348,"guid":"0CA2F400004","eventtype":"sensor","payload":{"time":1588687347,"sensor":[{"type":"temp","unit":"degc","value":28}]}}
{"received":1588687349,"guid":"0CA2F400004","eventtype":"sensor","payload":{"time":1588687347,"sensor":[{"type":"temp","unit":"degc","value":-667}]}}
所有数据都在 csv 文件的第一列中。我想转换为可读格式,如数据框,并用 write.csv() 保存?谢谢你的帮助
解决方案
library(jsonlite)
df <- read.csv("example.csv", header = FALSE)
jsonlite::stream_in(textConnection(gsub("\\n", "", df)))
推荐阅读
- node.js - 使用 Firebase Cloud Functions 时 Nodemailer 查询 A EREFUSED localhost
- amazon-web-services - Databricks 工作人员和 Elasticsearch 节点是否需要位于 AWS 的同一 VPC 中?
- python - “SyntaxError:无法构建词法分析器”是什么意思?
- integration-testing - 夸库斯。在集成测试中使用 spy 进行测试
- javascript - 如何使用 javaScript 和 jQuery 从 URL 中保存 json 对象
- python - 抑制 keras 消息:(常量):/job/localhost/
- python - “没有找到未找到参数的‘关于’的反向。尝试了 1 种模式:['$about$'] 请求方法:”
- javascript - 在 Discord.js 中接收 TypeError(不是角色/雪花)
- python - 熊猫应用具有多种条件的功能?
- java - 'where 子句'中的未知列'CA1001'