利用read.csv读入text文件时,读入后的数据总是格式不对,发现与\n(回车符)有关,读入csv格式就没有问题。希望可以正确读入text文件,下面是两次读入的数据及结果,结果都是乱的,求帮助,谢谢!
数据1读入及返回结果:
> datas <- read.csv(file = "accident.txt",header = TRUE,stringsAsFactors = FALSE,encoding = "UTF-8")
Warning message:
In strsplit(code, "\n", fixed = TRUE) :
input string 1 is invalid in this locale
> head(datas)
X.ca.1.U.02B1..e0..U.00BA..c5. X.ca.1.ca..c0..e0..d0..cd.
1 3.10104e+15 <U+04BB><U+00B0><e3>
2 3.10107e+15 <U+04BB><U+00B0><e3>
3 3.10116e+15 <U+04BB><U+00B0><e3>
4 3.10113e+15 <U+04BB><U+00B0><e3>
5 3.10116e+15 <U+04BB><U+00B0><e3>
6 3.10117e+15 <U+04BB><U+00B0><e3>
X.ca.1.U.02B5..U.0635..e3.
1 <d6><d0><U+027D><c4><U+03F6><fe>·<U+00BD><f8><U+00B6><U+00AB><U+00B0><U+00B2>·<ce><f7><U+053C>200<c3><d7>
2 <U+00B1><U+00B1><U+00BE><U+00A9><ce><f7>·<U+00B3><f6><U+036D><c8><ca>·<ce><f7><U+053C>50<c3><d7>
3 <U+00BF><U+00B5><d0>1<U+00AB>·<cf><c2><d1>ι<U+00AB>·<U+00B6><U+00AB><U+053C>5<c3><d7>
4 <d0><U+02FA><e7>·<c9><ea><U+00B1><f5>·<U+00B6><U+00AB><U+053C>200<c3><d7>
5 <U+00BB><U+00A6><c4><U+03F9><U+00AB>·<d0><e3><d1><d8>·<ce><f7><U+053C>5<c3><d7>
6 <d0><c2><c4><cf>·<U+00BD><f8><c3><f7><d0><cb>·<U+00B6><U+00AB><U+053C>120<c3><d7>
X.ca.1.ca..U.02B1..U.00BC..e4.
1 2015-11-28 16:53:00
2 2015-7-11 10:20:00
3 2015-12-28 15:40:00
4 2015-7-6 6:39:00
5 2015-10-26 4:50:00
6 2015-7-1 11:24:00
数据2读入及返回结果:
> dat = read.csv(text = "chengshi,jingdu,weidu
+ 北 京,116.4666667,39.9
+ 上 海,121.4833333,31.23333333
+ 天 津,117.1833333,39.15
+ 重 庆,106.5333333,29.53333333
+ 哈尔滨,126.6833333,45.75")
Warning message:
In strsplit(code, "\n", fixed = TRUE) :
input string 1 is invalid in this locale
> head(dat)
城市 jd wd
1 北 京,116.4666667 39.90000 NA
2 上 海,121.4833333 31.23333 NA
3 天 津,117.1833333 39.15000 NA
4 重 庆,106.5333333 29.53333 NA
5 哈尔滨,126.6833333 45.75000 NA