我有一個 csv，其中每個值都包含在一個引號中，前面有一個等號，如下所示：
="#",="NAME",="SM",="SRM",="SNM",="TMG",="PIL",="TIP",="TIZ"
="1",="A.Aaronsen",="0",="0",="0",="0",="0",="0",="0"
="2",="J.Jeff",="0",="0",="0",="0",="3",="0",="0"
="4",="C.Corr",="0",="0",="0",="0",="1",="0",="0"
="5",="F.Taylor",="0",="0",="0",="0",="2",="0",="0"
="6",="J.Morris",="0",="0",="0",="0",="3",="0",="0"
我不知道如何閱讀它，所以我只有值并且列是適當的型別。第一列是列名。
uj5u.com熱心網友回復：
您可以使用 讀取檔案readLines，洗掉=符號并使用 讀取read.csv。
read.csv(text = gsub('=', '', readLines('data.csv'), fixed = TRUE))
將此作為文本進行測驗-
text <- '="#",="NAME",="SM",="SRM",="SNM",="TMG",="PIL",="TIP",="TIZ"
="1",="A.Aaronsen",="0",="0",="0",="0",="0",="0",="0"
="2",="J.Jeff",="0",="0",="0",="0",="3",="0",="0"
="4",="C.Corr",="0",="0",="0",="0",="1",="0",="0"
="5",="F.Taylor",="0",="0",="0",="0",="2",="0",="0"
="6",="J.Morris",="0",="0",="0",="0",="3",="0",="0"'
read.csv(text = gsub('=', '', text, fixed = TRUE))
# X. NAME SM SRM SNM TMG PIL TIP TIZ
#1 1 A.Aaronsen 0 0 0 0 0 0 0
#2 2 J.Jeff 0 0 0 0 3 0 0
#3 4 C.Corr 0 0 0 0 1 0 0
#4 5 F.Taylor 0 0 0 0 2 0 0
#5 6 J.Morris 0 0 0 0 3 0 0
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/433947.html