[R] Problem reading mixed CSV file
Ashish Agarwal
ashish.agarwala at gmail.com
Fri Mar 16 18:11:31 CET 2012
I want to import this CSV file into R.
The CSV file is
,,,1968,21,0
,,Boston,1968,13,0
,,Boston,1968,18,0
,,Chicago,1967,44,0
,,Providence,1968,17,0
,,Providence,1969,48,0
,,Binky,1968,24,0
,,Chicago,1968,23,0
,,Dally,1968,7,0
,,Raleigh, North Carol,1968,25,0
Addy ABC-Dogs Stars-W8.1,,Providence,1968,38,0
DEF_REQPRF/,,Dartmouth,1967,31,1
PL,,,1967,38,1
XY,PopatLal,,1967,5,1
XY,PopatLal,,1967,6,8
XY,PopatLal,,1967,7,7
XY,PopatLal,,1967,9,1
XY,PopatLal,,1967,10,1
XY,PopatLal,,1967,13,1
XY,PopatLal,Boston,1967,6,1
XY,PopatLal,Boston,1967,7,11
XY,PopatLal,Boston,1967,9,2
XY,PopatLal,Boston,1967,10,3
XY,PopatLal,Boston,1967,7,2
I tried using scan and read.table but results are not visible :(
> scan("D:/data/temp.csv",list("","","",0,0,0),sep=",") ->x
Read 51 records
> x
[[1]]
[1] "ÿþ" "" "" "" "" "" "" "" "" "" "" "" "" "" ""
[16] "" "" "" "" "" "" "" "" "" "" "" "" "" "" ""
[31] "" "" "" "" "" "" "" "" "" "" "" "" "" "" ""
[46] "" "" "" "" "" ""
....
> read.table("D:/data/temp.csv",header=F,sep=",") ->x
> x
V1 V2
1 ÿþ NA
2 NA
3 NA
4 NA
Can somebody please help in importing this CSV file?
More information about the R-help
mailing list