[R] Help on Aggregation
Emeka Don
emekadonn at gmail.com
Mon Mar 12 12:18:22 CET 2018
Dear All,
1.I have been trying to aggregate my data but I have not been getting it
correctly. In the data I want to convert hourly data into daily averages.
Here is a sample of the data:
Neph_no Date Time Temp_C Pressure_kPa RH
9 2014/03/28 10:00:00 38.4 95.9 29.7
9 2014/03/28 11:00:00 37.8 95.8 29.2
9 2014/03/28 12:00:00 36.7 95.8 35.1
9 2014/03/28 13:00:00 35.4 95.8 38.9
9 2014/03/28 14:00:00 34.1 95.8 44
9 2014/03/28 15:00:00 32.7 95.9 52.9
9 2014/03/28 16:00:00 31.8 96 55.1
9 2014/03/28 17:00:00 31.2 96 57.8
9 2014/03/28 18:00:00 30.6 96.1 62.1
9 2014/03/28 19:00:00 29.8 96.1 68.1
9 2014/03/28 20:00:00 29.1 96.1 69.5
9 2014/03/28 21:00:00 28.6 96 68.3
9 2014/03/28 22:00:00 28 96 71.9
9 2014/03/28 23:00:00 27.4 95.9 76.4
9 2014/03/29 00:00:00 27 96 80.6
9 2014/03/29 01:00:00 27.1 96 80.4
9 2014/03/29 02:00:00 27 96.1 80.5
9 2014/03/29 03:00:00 27.8 96.1 78.1
9 2014/03/29 04:00:00 30.4 96.2 66.8
9 2014/03/29 05:00:00 33.7 96.3 54
9 2014/03/29 06:00:00 36.3 96.3 45
9 2014/03/29 07:00:00 37.7 96.3 38.8
9 2014/03/29 08:00:00 38.7 96.3 34.7
9 2014/03/29 09:00:00 38.9 96.1 32.6
9 2014/03/29 10:00:00 39.4 96 30.2
9 2014/03/29 11:00:00 38.9 95.9 31.5
9 2014/03/29 12:00:00 38.2 95.8 33.8
9 2014/03/29 13:00:00 37.4 95.8 35.4
9 2014/03/29 14:00:00 35.8 95.9 39.5
9 2014/03/29 15:00:00 33.9 96 46.9
9 2014/03/29 16:00:00 31.4 96.1 59.8
9 2014/03/29 17:00:00 29.4 96.3 72.9
9 2014/03/29 18:00:00 29 96.3 69.6
9 2014/03/29 19:00:00 26.5 96.2 81.7
9 2014/03/29 20:00:00 27 96.1 82.9
9 2014/03/29 21:00:00 27.5 96.1 81.7
9 2014/03/29 22:00:00 27.4 96 82.6
9 2014/03/29 23:00:00 27.3 96 83.1
9 2014/03/30 00:00:00 27.1 96 84.5
9 2014/03/30 01:00:00 27.6 96.1 81.8
9 2014/03/30 02:00:00 27.8 96.1 81
2. I have some data of about 6100 rows and 6 columns, but anytime i read it
into R, it removes the header and a large chunk of the data.( i:e it will
import from row 3550-6099). This is the code i used for it
"met_data=read.csv(file.choose(),header=TRUE)", so, how do I read the
entire data into R without missing some?
Thank you.
--
Onyeuwaoma Nnaemeka Dom
[[alternative HTML version deleted]]
More information about the R-help
mailing list