[R] So far so good except importing data

From: Rthoughts <seb.brockel_at_northampton.ac.uk>
Date: Mon, 03 Mar 2008 09:37:57 -0800 (PST)

HI, Thanks for your help previously. I can go around R and scilab now, except import my research data.

This is an example dataset (below) of radon radiation levels. How can I import this txt file using Rcmdr?

How do I import .xls files? My alpha guard radon monitors output .dvd files that can be converted into .xls files by adjusting may parameters.

A big earthquake struck last Thursday morning and need to anaylise the data of radon levels from it by means of correlation, mean, standard deviation and to produce relevant graphs/ charts. As meeting one of my PhD project aims.

Thanks if you can help. Here it is, I am using R on windows.

030,08,01,28,10,28, 47.,  28.1,10.7, 4.3, 4.3, 0.0,2236,11, 21.9,21, 1,6.82,
60,005, 22.98137, 25.13785,254
031,08,01,28,10,58, 51.,  28.2,11.8, 2.0, 5.9, 0.0,2218,11, 23.4,13, 1,6.12,
50,005, 29.52128, 27.30572,254
032,08,01,28,11,28, 53.,  28.2, 9.4, 1.9,11.3, 1.9,2218,11, 24.6, 7, 0,6.36,
10,005, 36.08156, 29.28577,254
033,08,01,28,11,58, 56.,  28.2,17.9, 3.6, 7.2, 0.0,2218,10, 25.2, 3, 1,6.21,
40,005, 45.92199, 31.96815,254
034,08,01,28,12,28, 57.,  28.2, 8.8, 0.0,17.6, 0.0,2218,11, 25.5, 0, 1,6.30,
50,005, 49.20213, 32.80142,254
035,08,01,28,12,58, 84.,  28.1, 9.5, 2.4, 9.5, 1.2,2236,11, 25.8, 0, 1,6.42,
60,005, 49.24579, 33.63885,254
036,08,01,28,13,29, 44.,  28.2,22.7, 0.0,15.9, 0.0,2201,11, 26.1, 0, 1,6.36,
50,005, 55.76242, 34.39321,254
037,08,01,28,13,59, 65.,  28.2,10.8, 0.0,18.5, 3.1,2218,11, 26.1, 0, 1,6.45,
50,005, 59.04255, 35.89877,254
038,08,01,28,14,29, 64.,  28.2,15.6, 0.0,15.6, 0.0,2218,11, 26.4, 0, 1,6.52,
60,005, 65.60285, 36.62328,254
039,08,01,28,14,59, 57.,  28.2,10.5, 1.8,10.5, 0.0,2218,11, 26.8, 0, 1,6.36,
50,005, 39.3617, 30.21372,254
040,08,01,28,15,29, 53.,  28.2, 9.4, 3.8,13.2, 0.0,2236,11, 26.8, 0, 1,6.39,
50,005, 39.3617, 30.21372,254
041,08,01,28,15,59, 67.,  28.3, 6.0, 0.0,14.9, 1.5,2218,11, 27.1, 0, 1,6.48,
60,005, 45.75972, 31.85519,254
042,08,01,28,16,29, 55.,  28.5,14.6, 0.0,10.9, 0.0,2236,11, 27.1, 0, 1,6.36,
50,005, 45.4386, 31.63164,254
043,08,01,28,16,59, 53.,  28.5,11.3, 0.0,15.1, 0.0,2218,11, 27.4, 0, 1,6.45,
60,005, 45.4386, 31.63164,254
044,08,01,28,17,29, 70.,  28.4,21.4, 0.0, 7.2, 0.0,2236,11, 27.1, 0, 1,6.39,
50,005, 64.96927, 36.26958,254
045,08,01,28,17,59, 74.,  28.4,12.2, 0.0,14.9, 0.0,2236,11, 27.4, 0, 1,6.48,
50,005, 64.96927, 36.26958,254
046,08,01,28,18,29, 78.,  28.4,18.0, 0.0,14.1, 0.0,2218,11, 26.8, 0, 1,6.58,
60,005, 81.21159, 39.62489,254
047,08,01,28,18,59, 78.,  28.4,14.1, 1.3,16.7, 1.3,2218,11, 26.8, 0, 1,6.52,
50,005, 77.96313, 38.98157,254
048,08,01,28,19,29, 74.,  28.4,14.9, 1.4,13.5, 1.4,2218,11, 26.4, 0, 0,6.55,
50,005, 68.21775, 36.97021,254
049,08,01,28,19,59, 74.,  28.4,13.5, 1.4,20.3, 2.7,2218,11, 26.1, 0, 0,6.88,
60,005, 77.96313, 40.25595,254
050,08,01,28,20,29, 72.,  28.4,18.1, 1.4,18.1, 0.0,2236,11, 25.8, 0, 1,6.82,
50,005, 84.46005, 40.25595,254
051,08,01,28,20,59, 77.,  28.4,24.7, 0.0,10.4, 1.3,2218,10, 25.8, 0, 1,6.91,
50,005, 87.70853, 40.87544,254
052,08,01,28,21,29, 63.,  28.4,14.3, 0.0,19.1, 0.0,2218,10, 25.5, 0, 0,6.85,
50,005, 68.21775, 36.97021,254
053,08,01,28,21,59, 74.,  28.4,18.9, 0.0,14.9, 0.0,2201,11, 25.2, 0, 0,7.03,
70,005, 81.21159, 39.62489,254
054,08,01,28,22,29, 64.,  28.4,23.5, 1.6,21.9, 1.6,2218,11, 25.2, 0, 0,7.03,
60,005, 94.20546, 42.08207,254
055,08,01,28,22,59, 59.,  28.5,17.0, 0.0,18.7, 0.0,2218,11, 24.9, 0, 1,7.03,
60,005, 68.1579, 36.93778,254
056,08,01,28,23,29, 74.,  28.4,21.6, 0.0,23.0, 1.4,2218,11, 24.9, 0, 0,7.00,
70,005, 107.1993, 44.3802,254
057,08,01,28,23,59, 72.,  28.4, 7.0, 4.2,22.2, 0.0,2218,10, 24.9, 0, 0,7.00,
60,005, 68.21775, 36.97021,254
058,08,01,29,00,29, 70.,  28.4,18.6, 1.4,17.2, 0.0,2236,11, 24.6, 0, 0,7.00,
60,005, 81.21159, 39.62489,254
059,08,01,29,00,59, 65.,  28.4,20.0, 0.0,18.5, 0.0,2218,11, 24.9, 0, 0,6.94,
50,005, 81.21159, 39.62489,254
060,08,01,29,01,29, 88.,  28.4,13.6, 0.0,17.1, 0.0,2236,11, 24.9, 0, 0,7.03,
60,005, 87.70853, 40.87544,254
061,08,01,29,01,59, 69.,  28.4,18.9, 1.5,23.2, 0.0,2218,10, 25.2, 0, 0,7.03,
60,005, 94.20546, 42.08207,254
062,08,01,29,02,29, 65.,  28.4,16.9, 1.6,16.9, 1.6,2218,10, 25.5, 0, 0,6.88,
50,005, 68.21775, 37.6551,254
063,08,01,29,02,59, 78.,  28.4,10.3, 1.3,14.1, 1.3,2201,10, 25.8, 0, 1,6.91,
60,005, 61.72082, 35.55207,254
064,08,01,29,03,29, 59.,  28.4,10.2, 0.0,17.0, 0.0,2218,11, 26.1, 0, 0,6.94,
60,005, 51.97542, 33.28445,254
065,08,01,29,03,59, 81.,  28.4,18.5, 0.0,12.4, 2.5,2236,11, 26.4, 0, 0,6.97,
60,005, 77.96313, 39.62489,254
066,08,01,29,04,29, 60.,  28.5,15.0, 1.7,15.0, 1.7,2218,11, 26.4, 0, 0,6.76,
60,005, 58.42105, 34.78584,254
067,08,01,29,04,59, 52.,  28.5, 9.6, 0.0,26.9, 1.9,2218,11, 26.8, 0, 1,6.73,
50,005, 61.66667, 35.52089,254
068,08,01,29,05,29, 74.,  28.4,17.6, 1.4,18.9, 0.0,2218,11, 26.8, 0, 1,6.48,
50,005, 87.70853, 40.87544,254
069,08,01,29,05,59, 62.,  28.4,12.9, 0.0,21.0, 1.6,2218,11, 26.8, 0, 0,6.42,
50,005, 68.21775, 36.97021,254
070,08,01,29,06,29, 70.,  28.4, 8.6, 1.4,11.4, 0.0,2236,11, 26.8, 0, 1,6.48,
50,005, 45.4785, 31.65942,254
071,08,01,29,06,59, 75.,  28.4,12.0, 1.3,16.0, 0.0,2201,11, 26.8, 0, 1,6.39,
50,005, 68.21775, 36.97021,254
072,08,01,29,07,29, 69.,  28.4,13.1, 0.0,13.1, 1.5,2218,11, 26.8, 0, 1,6.36,
50,005, 58.47235, 34.81638,254
073,08,01,29,07,59, 65.,  28.4,24.6, 0.0,13.9, 0.0,2201,11, 27.1, 0, 0,6.36,
50,005, 81.21159, 39.62489,254
074,08,01,29,08,29, 74.,  28.4,14.9, 0.0,18.9, 2.7,2236,11, 27.1, 0, 0,6.48,
60,005, 77.96313, 40.25595,254
075,08,01,29,08,59, 69.,  28.4,14.5, 1.5,14.5, 0.0,2201,12, 27.1, 0, 1,6.42,
50,005, 65.14085, 36.36537,254
076,08,01,29,09,29, 62.,  28.2,16.1, 0.0,21.0, 0.0,2218,11, 27.1, 0, 0,6.48,
50,005, 75.44327, 38.69899,254
077,08,01,29,09,59, 52.,  28.2, 5.8, 0.0,13.5, 0.0,2218,11, 27.4, 0, 1,6.52,
50,005, 32.80142, 28.31829,254
078,08,01,29,10,29, 64.,  28.2,15.6, 1.6,17.2, 1.6,2218,11, 27.7, 0, 1,6.55,
50,005, 68.88299, 37.33074,254
079,08,01,29,10,59, 60.,  28.2,21.7, 1.7,10.0, 0.0,2218,11, 28.0, 0, 1,6.45,
50,005, 62.3227, 35.89877,254
080,08,01,29,11,29, 69.,  28.2,13.1, 0.0,18.9, 1.5,2236,11, 28.0, 0, 1,6.36,
50,005, 72.16313, 38.0223,254
081,08,01,29,11,59, 60.,  28.2,11.7, 0.0,11.7, 0.0,2236,11, 28.3, 0, 1,6.45,
50,005, 45.92199, 31.96815,254
082,08,01,29,12,29, 59.,  28.2,25.4, 1.7, 8.5, 0.0,2218,11, 28.6, 0, 1,6.48,
50,005, 65.60285, 36.62328,254
083,08,01,29,12,59, 50.,  28.2,16.0, 0.0,14.0, 0.0,2201,11, 28.6, 0, 1,6.42,
50,005, 49.20213, 32.80142,254
084,08,01,29,13,29, 62.,  28.2, 4.9, 1.6,22.6, 1.6,2201,11, 28.9, 0, 1,6.52,
50,005, 55.76242, 34.39321,254
085,08,01,29,13,59, 62.,  28.2, 3.2, 0.0,11.3, 3.2,2236,11, 28.9, 0, 1,6.64,
60,005, 26.24114, 28.31829,254
086,08,01,29,14,29, 69.,  28.2,11.6, 0.0,18.9, 0.0,2218,11, 28.9, 0, 1,6.52,
50,005, 68.88299, 37.33074,254
087,08,01,29,14,59, 63.,  28.2,17.5, 0.0,17.5, 0.0,2236,11, 29.2, 0, 1,6.55,
50,005, 72.16313, 38.0223,254
088,08,01,29,15,29, 69.,  28.1, 2.9, 0.0,21.8, 0.0,2218,11, 28.6, 0, 1,6.73,
50,005, 55.96086, 34.5156,254
089,08,01,29,16,29, 121.,  56.3,10.8, 0.8,11.6, 0.0,2218,11, 28.6, 0,
1,6.70, 60,005, 44.30155, 20.64617,254
090,08,01,29,17,29, 111.,  56.3,10.8, 0.0, 6.3, 0.9,2201,11, 28.9, 0,
1,6.76, 60,005, 29.53437, 17.95734,254
091,08,01,29,18,29, 116.,  56.3,22.4, 0.0,13.8, 0.0,2218,11, 28.6, 0,
1,6.70, 50,005, 68.91353, 24.80046,254
092,08,01,29,19,29, 136.,  56.3,18.4, 3.0,15.5, 0.0,2218,11, 28.3, 0,
1,6.67, 50,005, 75.47672, 25.77909,254
093,08,01,29,20,29, 134.,  56.3,14.9, 0.0,15.7, 0.0,2218,11, 28.0, 0,
1,6.58, 50,005, 67.27273, 24.54877,254
094,08,01,29,21,29, 139.,  56.3,15.8, 1.5,15.8, 0.0,2218,11, 27.7, 0,
0,6.58, 60,005, 72.19513, 25.29521,254
095,08,01,29,22,29, 156.,  56.3,15.4, 0.0,22.4, 1.3,2236,11, 27.4, 0,
0,6.61, 50,005, 95.1663, 28.70073,254
096,08,01,29,23,29, 140.,  56.3,15.0, 0.7,15.0, 0.7,2236,11, 27.1, 0,
0,6.52, 50,005, 68.91353, 24.80046,254
097,08,01,30,00,29, 148.,  56.3,14.9, 0.7,22.3, 1.4,2201,11, 27.1, 0,
0,6.61, 60,005, 88.60309, 28.0571,254
098,08,01,30,01,29, 167.,  56.3, 8.4, 1.2,19.8, 0.6,2236,11, 26.8, 0,
2,6.48, 50,005, 75.47672, 26.01716,254
099,08,01,30,02,29, 135.,  56.3,14.1, 0.8,20.0, 0.0,2201,11, 27.4, 0,
0,6.48, 50,005, 75.47672, 25.77909,254
100,08,01,30,03,29, 128.,  56.3,16.4, 2.4,20.3, 0.8,2236,11, 27.7, 0,
0,6.61, 60,005, 77.11751, 26.01716,254
101,08,01,30,04,29, 146.,  56.3,13.0, 2.8,13.0, 2.8,2236,11, 28.0, 0,
0,6.55, 60,005, 59.06873, 24.03623,254
102,08,01,30,05,29, 121.,  56.3,18.2, 0.0,15.7, 3.3,2218,11, 28.3, 0,
1,6.58, 60,005, 63.99113, 24.80046,254
103,08,01,30,06,29, 125.,  56.3,14.4, 1.6,12.8, 0.8,2218,11, 28.3, 0,
0,6.48, 50,005, 55.78713, 22.69578,254
104,08,01,30,07,29, 129.,  56.3,18.6, 2.3,11.6, 0.0,2218,11, 28.3, 0,
1,6.55, 60,005, 63.99113, 24.03623,254
105,08,01,30,08,29, 145.,  56.3,12.4, 0.7,20.0, 0.0,2218,11, 28.6, 0,
1,6.42, 50,005, 77.11751, 26.01716,254
106,08,01,30,09,29, 117.,  56.6,18.0, 1.7,14.5, 2.6,2201,12, 28.6, 0,
1,6.55, 60,005, 60.4415, 23.93012,254
107,08,01,30,10,29, 125.,  56.9,16.0, 0.8,14.4, 0.0,2201,11, 28.6, 0,
1,6.45, 40,005, 61.69373, 23.52479,254
108,08,01,30,11,29, 121.,  56.9,13.2, 3.3,16.5, 0.8,2236,11, 28.6, 0,
1,6.64, 60,005, 58.4467, 22.998,254
109,08,01,30,12,29, 132.,  56.9, 9.1, 0.0,17.4, 1.5,2218,11, 28.9, 0,
1,6.42, 50,005, 55.19965, 22.998,254
110,08,01,30,13,29, 135.,  56.9,13.3, 3.0,12.6, 0.0,2236,12, 28.9, 0,
1,6.55, 50,005, 56.82317, 22.72927,254
111,08,01,30,14,29, 134.,  56.9,15.7, 0.0,16.4, 1.5,2218,11, 29.2, 0,
1,6.55, 60,005, 68.1878, 25.02883,254
112,08,01,30,15,30, 132.,  56.9,12.1, 3.0,15.2, 2.3,2201,12, 29.5, 0,
1,6.42, 50,005, 56.82317, 23.26313,254
113,08,01,30,16,30, 112.,  56.9,15.2, 1.8,18.8, 0.0,2236,11, 29.5, 0,
1,6.48, 60,005, 61.69373, 23.52479,254
114,08,01,30,17,30, 94.,  56.9,11.7, 1.1,14.9, 0.0,2218,11, 29.2, 0, 1,6.52,
60,005, 40.58797, 19.80375,254
115,08,01,30,18,30, 103.,  56.9, 8.8, 0.0, 9.7, 0.0,2218,11, 28.9, 0,
1,6.61, 60,005, 30.84686, 17.76824,254
116,08,01,30,19,30, 124.,  56.9,12.1, 0.8, 9.7, 2.4,2218,11, 28.6, 0,
1,6.42, 50,005, 42.21149, 20.73287,254
117,08,01,30,20,30, 110.,  56.9,10.0, 0.0,11.8, 0.9,2218,11, 28.3, 0,
0,6.64, 60,005, 38.96446, 19.48223,254
118,08,01,30,21,30, 118.,  56.9,14.4, 1.7,10.2, 0.9,2236,11, 28.0, 0,
1,6.61, 60,005, 45.45853, 21.0318,254
119,08,01,30,22,30, 115.,  56.9,19.1, 2.6,11.3, 0.9,2201,12, 27.7, 0,
0,6.58, 50,005, 56.82317, 22.72927,254
120,08,01,30,23,30, 148.,  56.9,16.9, 0.0,14.9, 0.7,2218,11, 27.7, 0,
1,6.36, 50,005, 76.30538, 25.74317,254
121,08,01,31,00,30, 141.,  56.9,22.7, 2.1,17.0, 0.0,2218,11, 27.4, 0,
0,6.52, 50,005, 90.91706, 27.76164,254
122,08,01,31,01,30, 143.,  56.9,11.2, 2.1,23.8, 2.1,2236,11, 27.1, 0,
0,6.39, 60,005, 79.55243, 26.66177,254
123,08,01,31,02,30, 122.,  56.9,15.6, 0.8,13.9, 1.7,2236,11, 27.7, 0,
0,6.39, 50,005, 56.82317, 22.998,254
124,08,01,31,03,30, 103.,  56.9,11.7, 0.0,22.3, 1.0,2218,11, 28.3, 0,
0,6.42, 50,005, 56.82317, 22.72927,254
125,08,01,31,04,30, 105.,  56.9, 6.7, 0.0,14.3, 1.9,2218,11, 28.0, 0,
1,6.45, 40,005, 34.0939, 18.81928,254
-- 
View this message in context: http://www.nabble.com/So-far-so-good-except-importing-data-tp15809179p15809179.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help_at_r-project.org mailing list
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.
Received on Mon 03 Mar 2008 - 18:03:46 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Mon 03 Mar 2008 - 18:30:20 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive