r - 在保留标题的同时用原始数据中的空格替换逗号的有效方法?
问题描述
我有来自我正在使用的旧程序和机器的多个原始数据集。每个数据集都有三个数值变量和大约 90 个观察值,但程序用逗号而不是空格分隔变量。这会导致 r 将其作为一个长变量读取,而我想将它们作为三个单独的变量读取,同时仍将三个标签保留在标题中。
这是其中一个数据集的示例
>dput(head(data))
structure(list(run.size.percent = structure(c(2L, 13L, 24L, 35L,
46L, 57L), .Label = c(",2000,", "1,0.375,0.013", "10,0.868,0.11",
"11,0.953,0.12", "12,1.047,0.12", "13,1.149,0.13", "14,1.261,0.14",
"15,1.385,0.14", "16,1.520,0.15", "17,1.668,0.15", "18,1.832,0.16",
"19,2.011,0.17", "2,0.412,0.023", "20,2.207,0.17", "21,2.423,0.18",
"22,2.660,0.19", "23,2.920,0.20", "24,3.205,0.21", "25,3.519,0.22",
"26,3.863,0.24", "27,4.240,0.25", "28,4.655,0.26", "29,5.110,0.28",
"3,0.452,0.034", "30,5.610,0.30", "31,6.158,0.31", "32,6.760,0.33",
"33,7.421,0.35", "34,8.147,0.37", "35,8.943,0.39", "36,9.817,0.42",
"37,10.78,0.45", "38,11.83,0.47", "39,12.99,0.50", "4,0.496,0.049",
"40,14.26,0.53", "41,15.65,0.56", "42,17.18,0.58", "43,18.86,0.59",
"44,20.70,0.59", "45,22.73,0.58", "46,24.95,0.55", "47,27.39,0.52",
"48,30.07,0.49", "49,33.01,0.46", "5,0.545,0.061", "50,36.24,0.45",
"51,39.78,0.45", "52,43.67,0.45", "53,47.94,0.44", "54,52.62,0.42",
"55,57.77,0.38", "56,63.41,0.35", "57,69.61,0.32", "58,76.42,0.31",
"59,83.89,0.33", "6,0.598,0.072", "60,92.09,0.36", "61,101.1,0.42",
"62,111.0,0.49", "63,121.8,0.59", "64,133.7,0.74", "65,146.8,0.94",
"66,161.2,1.19", "67,176.9,1.49", "68,194.2,1.82", "69,213.2,2.18",
"7,0.656,0.083", "70,234.1,2.55", "71,256.9,2.94", "72,282.1,3.34",
"73,309.6,3.78", "74,339.9,4.25", "75,373.1,4.73", "76,409.6,5.20",
"77,449.7,5.60", "78,493.6,5.87", "79,541.9,5.93", "8,0.721,0.093",
"80,594.9,5.77", "81,653.0,5.37", "82,716.8,4.77", "83,786.9,4.03",
"84,863.9,3.21", "85,948.3,2.36", "86,1041,1.55", "87,1143,0.81",
"88,1255,0.30", "89,1377,0.056", "9,0.791,0.10", "90,1512,0.0044",
"91,1660,0", "92,1822,0"), class = "factor")), row.names = c(NA,
6L), class = "data.frame")
关于快速解决此问题的任何想法?在读取 r 中的数据集后,是否可以输入一行代码?谢谢你的帮助!
解决方案
推荐阅读
- pdf - 数字 PDF 文档签名
- python-3.x - 如何使用谷歌云路径(gs://)获取谷歌云存储桶中的所有训练文件和测试文件来训练ai平台中的作业
- linux - 如何在linux中打印搜索文本的行号
- apache-spark - 如何在每个时间窗口获取记录子集?
- gerrit - 如何在 gerrit 项目中默认启用注释已解析(未解析)标志
- python - 如何以特定方式标记我的重复值
- delphi - Firebird从SQL中的多行构建1个字段的CSV字符串
- jquery - 使用 JQuery 根据 Ajax 结果更新列表框
- java - JavaParser 读取 src 目录
- python - Python 正则表达式性能:使用数千个正则表达式迭代文本的最佳方法