[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