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]] ______________________________________________ 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.