[R] reading in data problems

From: Upasna Sharma <upasna_at_iitb.ac.in>
Date: Sat 12 Mar 2005 - 00:40:33 EST

Hi

I have a dataset (.txt file and .dat file) in which the length of one record is 144. There is no header in the .txt or .dat file itself. When I read this file using the read.table command, and want to drop some coloumns by setting the argument colClasses to "NULL" for the columns that I want to drop, it does not work, because the entire record of the length 144 is being treated as one column only, of the type 'character'. I tried using read.fwf instead of read.table, but that doesn't seem to work either. what should I do, if I want to read in only some columns from the file?

If it helps, the description of the .dat file in the supporting documents if given as follows:

Work-file:01(Wrk101r/u) (person level work-file) record length : 145

No.    field                     	    length 	byte-Position
1.	Id					2	1 - 2
2.	Rnd sch					3	3 - 5
3.	sub-sample-original           	        1       6
4.	sec					1	7
5.	State-reg				3	8 - 10
6.	Stratum					2	11 - 12
7.	Sub-stratum				1	13
8.	Dist					2	14 - 15
9.	Sub rnd					1	16
10.	Sub-sample-revised			1	17
11.	Fsu					5	18 - 22
12.	Segment					1	23
13.	HHd -sl. No.				2	24 - 25
14. 	Survey code				1	26
15.	Reason -sub				1	27
16.	Nss					3	28 - 30
17.	Nsc					3	31 - 33
18.	Mult -ss				10	34 - 43
19.	HHD -size				3	44 - 46
20.	Mpce					8	47 - 54
21.	Mpce code				2	55 - 56
22.	Cmpce code				2	57 - 58
23.	HHd Type				1	59
24.	Religion				1	60
25.	Social group				1	61
26.	Land possessed CODE			2	62 - 63
27.	Dwelling code				1	64
28.	Type dwelling				1	65
29.	Type structure				1	66
30.	Covered area				6	67 - 72
31.	Cook					2	73 - 74
32.	Light					1	75
33.	Meal taken outside			1	76
34.	Ceremony performed			1	77
35.	Pds purchase				1	78
36.	Get food				1	79
37.	Not get food in the month of Jan	2	80 - 81
38.	Not get food in the month of Feb	2	82 - 83
39.	Not get food in the month of Mar	2	84 - 85
40.	Not get food in the month of Apr	2	86 - 87
41.	Not get food in the month of May	2	88 - 89
42.	Not get food in the month of June	2	90 - 91
43.	Not get food in the month of July	2	92 - 93
44.	Not get food in the month of Aug	2	94 - 95
45.	Not get food in the month of Sep	2	96 - 97
46.	Not get food in the month of Oct	2	98 - 99
47.	Not get food in the month of Nov	2	100 -101
48.	Not get food in the month of Dec	2	102 -103
49.	Tot no. of month not getting food	2	104 -105
50.	Whether asked				1	106
51.	Time canvass				3	107 109
52.	Person sl. No.				3	110 -112
53.	Relation				1	113
54.	Sex					1	114
55.	Age					2	115 -116
56.	Marital status				1	117
57.	Edu code				2	118 -119
58.	Upst code 				2	120 -121
59.	Upnic code				2	122 -123
60.	Sbst code				2	124 -125
61.	Sbnic code				2	126 -127
62.	Cwst code 				2	128 -129
63.	Cwnic code 				2	130 -131
64. 	Days stayed away			2	132 -133
65.	No. meal/day				1	134
66.	Meal school				2	135 -136
67.	Meal employer				2	137 -138
68.	Meal other				2	139 -140
69.	Meal on payment				2	141 -142
70.	Meal at home				2	143 -144
_______________________________________________________________________


-- 
"The past is a history, the future is a mystery, and this moment is a
gift. That is why this moment is called 'the present'." Anonymous

______________________________________________
R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
Received on Mon Mar 14 09:57:37 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:30:43 EST