Is this what your are expecting?
test <- read.fwf("test.dat", width = c(10, 4, 1, 4, 9,
12,26,1,1,1,1,1,1,3,8))
test
V1 V2 V3 V4 V5 V6 V7 V8 V9 V10 V11 V12 V13 V14 V15
1 1 2015 1 4 0.766696 1 1 0 0 0 0 0 0 0 10
2 2 2015 1 4 1.458186 1 1 0 0 0 1 0 0 0 20
3 3 2015 1 4 0.185492 1 1 0 0 0 0 0 0 0 15
4 4 2015 1 4 0.961584 1 1 0 0 0 0 0 0 0 3
5 5 2015 1 4 0.650091 2 0 0 0 1 0 0 0 0 NA
6 6 2015 1 4 0.430350 1 1 0 0 0 0 0 0 0 20
7 7 2015 1 4 3.192895 2 1 0 1 1 0 0 0 0 0
8 8 2015 1 4 0.617127 1 1 0 1 0 1 0 0 0 15
9 9 2015 1 4 0.399207 1 1 0 0 0 0 0 0 0 10
Clint
Clint Bowman INTERNET: cl...@ecy.wa.gov
Air Quality Modeler INTERNET: cl...@math.utah.edu
Department of Ecology VOICE: (360) 407-6815
PO Box 47600 FAX: (360) 407-7534
Olympia, WA 98504-7600
USPS: PO Box 47600, Olympia, WA 98504-7600
Parcels: 300 Desmond Drive, Lacey, WA 98503-1274
On Fri, 10 Jul 2015, jagadishpchary wrote:
I am beginner in R and I want to read a ASCII file to R environment. However,
the ASCII file is a non delimited and the data is not continuous (have some
blank spaces between the variables) so in order to read the data i have used
the below syntax i.e
test <- read.fwf("D:/R_process/ASCII.txt", width = c(10, 4, 1, 4, 9, 9,
1,1,1,1,1,1,1,3,8))
Now i am able to read it but the data read is wrong. Actually my out put
should have only the applicable variables data but not the blank data.
Attached is the ASCII data. Please let me know how should i write the syntax
to read only the applicable data in the file.
Thanks for your help in advance. test.txt
<http://r.789695.n4.nabble.com/file/n4709699/test.txt>
--
View this message in context:
http://r.789695.n4.nabble.com/Cross-tabulation-with-top-one-variable-and-side-as-multiple-variables-tp4708379p4709699.html
Sent from the R help mailing list archive at Nabble.com.
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
