Dear all, I have 51 years of data (1960 - 2010) in csv format, where each file represents one year of data. Below is what each file looks like. These are temperature data by coordinates, my goal is to to compute max, min, and mean by year for each of the coordinates and construct a panel dataset. Any help will be appreciated, thank you! Sincerely, Milu temp <- dput(head(df,5)) structure(list(ISO3 = structure(c(28L, 28L, 28L, NA, 28L), .Label c("AFG", "AGO", "ALB", "ARE", "ARG", "ARM", "AUS", "AUT", "AZE", "BDI", "BEL", "BEN", "BFA", "BGD", "BGR", "BHS", "BIH", "BLR", "BLZ", "BOL", "BRA", "BRN", "BTN", "BWA", "CAF", "CAN", "CHE", "CHL", "CHN", "CIV", "CMR", "COD", "COG", "COL", "CRI", "CUB", "CYP", "CZE", "DEU", "DJI", "DNK", "DOM", "DZA", "ECU", "EGY", "ERI", "ESH", "ESP", "EST", "ETH", "FIN", "FJI", "FLK", "FRA", "GAB", "GBR", "GEO", "GHA", "GIN", "GNB", "GNQ", "GRC", "GRL", "GTM", "GUF", "GUY", "HND", "HRV", "HTI", "HUN", "IDN", "IND", "IRL", "IRN", "IRQ", "ISL", "ISR", "ITA", "JAM", "JOR", "JPN", "KAZ", "KEN", "KGZ", "KHM", "KIR", "KOR", "KWT", "LAO", "LBN", "LBR", "LBY", "LCA", "LKA", "LSO", "LTU", "LUX", "LVA", "MAR", "MDA", "MDG", "MEX", "MKD", "MLI", "MMR", "MNE", "MNG", "MOZ", "MRT", "MWI", "MYS", "NAM", "NCL", "NER", "NGA", "NIC", "NLD", "NOR", "NPL", "NZL", "OMN", "PAK", "PAN", "PER", "PHL", "PNG", "POL", "PRI", "PRK", "PRT", "PRY", "QAT", "ROU", "RUS", "RWA", "SAU", "SDN", "SEN", "SJM", "SLB", "SLE", "SLV", "SOM", "SRB", "SUR", "SVK", "SVN", "SWE", "SWZ", "SYR", "TCD", "TGO", "THA", "TJK", "TKM", "TLS", "TUN", "TUR", "TWN", "TZA", "UGA", "UKR", "URY", "USA", "UZB", "VEN", "VNM", "VUT", "YEM", "ZAF", "ZMB", "ZWE" ), class = "factor"), lon = c(-69L, -68L, -72L, -71L, -70L), lat = c(-55L, -55L, -54L, -54L, -54L), day_1 = c(NA, NA, 0, 0, 0), day_2 = c(NA, NA, 0, 0, 0), day_3 = c(NA, NA, 0, 23.37984, 0), day_4 = c(NA, NA, 0, 0, 0), day_5 = c(NA, NA, 0, 0, 0), day_6 = c(NA, NA, 0, 0, 0), day_7 = c(NA, NA, 2.83824, 11.80116, 1.24956), day_8 = c(NA, NA, 0, 1.68588, 14.69448 ), day_9 = c(NA, NA, 0, 0, 1.09296), day_10 = c(NA, NA, 0, 0, 0), day_11 = c(NA, NA, 3.78, 3.7422, 0), day_12 = c(NA, NA, 0.54, 0, 0), day_13 = c(NA, NA, 0, 0, 0), day_14 = c(NA, NA, 0, 0, 0.39204), day_15 = c(NA, NA, 0, 0, 11.58732), day_16 = c(NA, NA, 0, 0, 0), day_17 = c(NA, NA, 0, 1.14048, 12.26448), day_18 = c(NA, NA, 0, 1.1934, 7.59024), day_19 = c(NA, NA, 9.74268, 0, 0 ), day_20 = c(NA, NA, 0, 0, 0), day_21 = c(NA, NA, 1.96776, 0, 0), day_22 = c(NA, NA, 0, 0, 0), day_23 = c(NA, NA, 0, 0, 0), day_24 = c(NA, NA, 6.21756, 2.74752, 0), day_25 = c(NA, NA, 0, 0, 3.37932), day_26 = c(NA, NA, 4.8384, 0, 0), day_27 = c(NA, NA, 0, 0, 0), day_28 = c(NA, NA, 0, 0, 0), day_29 = c(NA, NA, 22.37328, 0, 0), day_30 = c(NA, NA, 28.97424, 11.25468, 0), day_31 = c(NA, NA, 0, 0, 0), day_32 = c(NA, NA, 0, 0, 2.00448), day_33 = c(NA, NA, 0, 0, 0), day_34 = c(NA, NA, 0, 0, 0), day_35 = c(NA, NA, 0, 0, 0), day_36 = c(NA, NA, 0, 0, 0), day_37 = c(NA, NA, 0, 0, 0), day_38 = c(NA, NA, 32.7132, 31.71852, 0), day_39 = c(NA, NA, 0, 0, 5.84604), day_40 = c(NA, NA, 0, 0, 0), day_41 = c(NA, NA, 0, 0, 0), day_42 = c(NA, NA, 0, 0, 0), day_43 = c(NA, NA, 0, 0, 0), day_44 = c(NA, NA, 0, 0, 1.78416), day_45 = c(NA, NA, 0, 0, 0), day_46 = c(NA, NA, 33.84504, 0, 0), day_47 = c(NA, NA, 0, 0, 0), day_48 = c(NA, NA, 0, 0, 0), day_49 = c(NA, NA, 0, 0, 0), day_50 = c(NA, NA, 0, 0.4752, 0), day_51 = c(NA, NA, 0, 0, 22.02012), day_52 = c(NA, NA, 0, 0, 0), day_53 = c(NA, NA, 0, 0, 3.48084), day_54 = c(NA, NA, 0, 0, 0), day_55 = c(NA, NA, 0.58212, 0, 0), day_56 = c(NA, NA, 0.35316, 0, 0), day_57 = c(NA, NA, 0, 0, 12.65436), day_58 = c(NA, NA, 0, 0, 0), day_59 = c(NA, NA, 0, 0, 0), day_60 = c(NA, NA, 3.03372, 22.05576, 0), day_61 = c(NA, NA, 2.5758, 0, 0), day_62 = c(NA, NA, 0, 0, 0), day_63 = c(NA, NA, 3.67416, 25.22016, 4.21524), day_64 = c(NA, NA, 0.52488, 3.60288, 0), day_65 = c(NA, NA, 12.82608, 0, 0), day_66 = c(NA, NA, 0, 0, 0), day_67 = c(NA, NA, 0, 0, 0), day_68 = c(NA, NA, 0, 0, 0), day_69 = c(NA, NA, 0, 0, 0), day_70 = c(NA, NA, 1.11564, 5.17536, 0), day_71 = c(NA, NA, 1.18584, 0, 0), day_72 = c(NA, NA, 0, 0, 0.10584), day_73 = c(NA, NA, 0.62748, 14.39748, 7.50708), day_74 = c(NA, NA, 7.20252, 20.02644, 1.07244), day_75 = c(NA, NA, 1.87488, 0, 0), day_76 = c(NA, NA, 0.26784, 0, 0), day_77 = c(NA, NA, 0, 0, 0), day_78 = c(NA, NA, 0, 0, 2.81664), day_79 = c(NA, NA, 0, 0, 0), day_80 = c(NA, NA, 0, 0, 0), day_81 = c(NA, NA, 0, 0, 0), day_82 = c(NA, NA, 1.29276, 0, 0), day_83 = c(NA, NA, 0.18468, 0, 1.46124 ), day_84 = c(NA, NA, 0, 0, 0), day_85 = c(NA, NA, 0, 0, 0), day_86 = c(NA, NA, 57.36528, 0, 0), day_87 = c(NA, NA, 8.19504, 0, 0), day_88 = c(NA, NA, 0, 0, 0), day_89 = c(NA, NA, 6.45732, 0, 0), day_90 = c(NA, NA, 0, 0, 0), day_91 = c(NA, NA, 0, 0, 44.20332), day_92 = c(NA, NA, 0, 0, 6.31476), day_93 = c(NA, NA, 0, 0, 0.35748), day_94 = c(NA, NA, 16.74972, 30.35988, 5.0436), day_95 = c(NA, NA, 4.93992, 1.46556, 19.86768), day_96 = c(NA, NA, 0, 0, 0.88128), day_97 = c(NA, NA, 5.751, 19.02096, 0), day_98 = c(NA, NA, 11.5452, 13.37148, 0), day_99 = c(NA, NA, 0, 0, 0), day_100 = c(NA, NA, 0, 0, 0), day_101 = c(NA, NA, 4.70124, 23.80644, 7.61832), day_102 = c(NA, NA, 0, 1.02492, 0), day_103 = c(NA, NA, 0, 0, 15.86304), day_104 = c(NA, NA, 0, 0, 0.26352), day_105 = c(NA, NA, 0, 0, 21.60864), day_106 = c(NA, NA, 56.93436, 0, 0.22464), day_107 = c(NA, NA, 8.13348, 0, 0), day_108 = c(NA, NA, 6.83748, 0, 0), day_109 = c(NA, NA, 0, 0, 0), day_110 = c(NA, NA, 14.36724, 0, 0), day_111 = c(NA, NA, 0.63936, 2.43864, 4.0554), day_112 = c(NA, NA, 1.21392, 1.15452, 0), day_113 = c(NA, NA, 0.7722, 0, 0), day_114 = c(NA, NA, 0, 0, 1.08864), day_115 = c(NA, NA, 1.47528, 0, 0), day_116 = c(NA, NA, 0, 1.73124, 0), day_117 = c(NA, NA, 0, 0, 0), day_118 = c(NA, NA, 2.4516, 0, 0), day_119 = c(NA, NA, 0, 3.14388, 0), day_120 = c(NA, NA, 1.81872, 0, 0), day_121 = c(NA, NA, 2.77236, 0, 0), day_122 = c(NA, NA, 1.34028, 0.70632, 0), day_123 = c(NA, NA, 0, 0, 0), day_124 = c(NA, NA, 0, 0, 0), day_125 = c(NA, NA, 0.56484, 0.74412, 0), day_126 = c(NA, NA, 1.11888, 0.06264, 0), day_127 = c(NA, NA, 0, 0, 0), day_128 = c(NA, NA, 1.05624, 0, 0), day_129 = c(NA, NA, 26.63928, 34.04268, 0), day_130 = c(NA, NA, 6.89796, 0, 0), day_131 = c(NA, NA, 1.91592, 2.241, 0), day_132 = c(NA, NA, 0, 2.23668, 45.23904 ), day_133 = c(NA, NA, 0, 0, 6.46272), day_134 = c(NA, NA, 0, 0, 0), day_135 = c(NA, NA, 0, 0, 0), day_136 = c(NA, NA, 0, 0, 0), day_137 = c(NA, NA, 0, 0, 0), day_138 = c(NA, NA, 0, 0, 0), day_139 = c(NA, NA, 0, 0, 0), day_140 = c(NA, NA, 0, 0, 0), day_141 = c(NA, NA, 0, 0, 0), day_142 = c(NA, NA, 0, 0, 0), day_143 = c(NA, NA, 0, 0, 0), day_144 = c(NA, NA, 2.943, 5.17536, 0), day_145 = c(NA, NA, 0, 0, 0), day_146 = c(NA, NA, 0, 0, 0), day_147 = c(NA, NA, 0, 0, 0), day_148 = c(NA, NA, 10.96308, 2.98188, 0), day_149 = c(NA, NA, 20.4822, 0.43632, 0), day_150 = c(NA, NA, 1.5282, 0, 0), day_151 = c(NA, NA, 0, 0, 0), day_152 = c(NA, NA, 0, 0, 0), day_153 = c(NA, NA, 0, 0, 0), day_154 = c(NA, NA, 0, 0, 0), day_155 = c(NA, NA, 0, 0, 0), day_156 = c(NA, NA, 0, 0, 0), day_157 = c(NA, NA, 0, 0, 0), day_158 = c(NA, NA, 0, 0, 0), day_159 = c(NA, NA, 0, 0, 0), day_160 = c(NA, NA, 0, 0, 0), day_161 = c(NA, NA, 0, 0, 0), day_162 = c(NA, NA, 0, 0, 0), day_163 = c(NA, NA, 0, 26.3412, 4.07376), day_164 = c(NA, NA, 0, 4.28328, 3.03156 ), day_165 = c(NA, NA, 0, 0, 0), day_166 = c(NA, NA, 0, 0, 4.60404), day_167 = c(NA, NA, 0, 0, 0.70848), day_168 = c(NA, NA, 0, 0, 0), day_169 = c(NA, NA, 0, 0, 0), day_170 = c(NA, NA, 0, 0, 0), day_171 = c(NA, NA, 0, 0, 0), day_172 = c(NA, NA, 0, 0, 0), day_173 = c(NA, NA, 0, 0, 3.7854), day_174 = c(NA, NA, 0, 0, 0), day_175 = c(NA, NA, 0, 0, 0), day_176 = c(NA, NA, 0, 0, 0), day_177 = c(NA, NA, 0, 0, 0), day_178 = c(NA, NA, 0, 0, 0), day_179 = c(NA, NA, 0, 0, 0), day_180 = c(NA, NA, 0, 0, 0), day_181 = c(NA, NA, 0, 0, 0), day_182 = c(NA, NA, 0, 0, 0), day_183 = c(NA, NA, 0, 0, 0), day_184 = c(NA, NA, 0, 0, 0), day_185 = c(NA, NA, 0, 0, 0), day_186 = c(NA, NA, 0, 0, 0), day_187 = c(NA, NA, 7.30728, 4.1202, 0), day_188 = c(NA, NA, 2.56608, 0.5886, 0), day_189 = c(NA, NA, 0, 0, 0), day_190 = c(NA, NA, 21.93156, 8.0082, 11.4318), day_191 = c(NA, NA, 3.13308, 0, 0), day_192 = c(NA, NA, 0, 0, 0.10692), day_193 = c(NA, NA, 0, 0, 4.65912), day_194 = c(NA, NA, 0, 0, 0), day_195 = c(NA, NA, 0, 0, 0), day_196 = c(NA, NA, 0, 0, 0), day_197 = c(NA, NA, 0, 0, 0), day_198 = c(NA, NA, 0, 0, 0), day_199 = c(NA, NA, 0, 0, 0), day_200 = c(NA, NA, 0, 0, 0), day_201 = c(NA, NA, 0, 0, 0), day_202 = c(NA, NA, 0, 7.77276, 4.6602), day_203 = c(NA, NA, 0, 0.86292, 0), day_204 = c(NA, NA, 0, 0, 0), day_205 = c(NA, NA, 21.45528, 8.69616, 0), day_206 = c(NA, NA, 0, 0, 0), day_207 = c(NA, NA, 0, 0, 0), day_208 = c(NA, NA, 0, 0, 0 ), day_209 = c(NA, NA, 0, 0, 0), day_210 = c(NA, NA, 0, 0, 0), day_211 = c(NA, NA, 0, 0, 0), day_212 = c(NA, NA, 0, 0, 0), day_213 = c(NA, NA, 0, 0, 0), day_214 = c(NA, NA, 0, 0, 0), day_215 = c(NA, NA, 0, 0, 0), day_216 = c(NA, NA, 0, 0, 0), day_217 = c(NA, NA, 0, 0, 0), day_218 = c(NA, NA, 0, 0, 0), day_219 = c(NA, NA, 0, 0, 0), day_220 = c(NA, NA, 6.10092, 10.85508, 13.22244), day_221 = c(NA, NA, 0.87156, 0, 0), day_222 = c(NA, NA, 0, 0, 15.46452), day_223 = c(NA, NA, 0, 0, 9.83664), day_224 = c(NA, NA, 0, 0, 0), day_225 = c(NA, NA, 0, 0, 0), day_226 = c(NA, NA, 16.46028, 0, 0), day_227 = c(NA, NA, 0, 0, 0), day_228 = c(NA, NA, 0, 0, 0), day_229 = c(NA, NA, 0, 0, 0), day_230 = c(NA, NA, 0, 0, 0), day_231 = c(NA, NA, 2.7108, 0, 0), day_232 = c(NA, NA, 0, 0, 0), day_233 = c(NA, NA, 0, 0, 0), day_234 = c(NA, NA, 0, 0, 0), day_235 = c(NA, NA, 0, 0, 0), day_236 = c(NA, NA, 0, 0, 3.5586), day_237 = c(NA, NA, 0, 0, 0), day_238 = c(NA, NA, 0, 0, 0), day_239 = c(NA, NA, 10.23192, 0, 0), day_240 = c(NA, NA, 0, 0, 0), day_241 = c(NA, NA, 0, 0, 0), day_242 = c(NA, NA, 0, 0, 0), day_243 = c(NA, NA, 0, 0, 0), day_244 = c(NA, NA, 0, 0, 0), day_245 = c(NA, NA, 0, 0, 0), day_246 = c(NA, NA, 0, 0, 0), day_247 = c(NA, NA, 0, 0, 0), day_248 = c(NA, NA, 0, 0, 0), day_249 = c(NA, NA, 0.50544, 0, 0), day_250 = c(NA, NA, 0.12636, 0, 0), day_251 = c(NA, NA, 7.02432, 0, 5.39784), day_252 = c(NA, NA, 3.33828, 8.00064, 7.08372), day_253 = c(NA, NA, 0, 0, 0), day_254 = c(NA, NA, 0, 0, 0), day_255 = c(NA, NA, 2.5704, 4.71636, 11.99772), day_256 = c(NA, NA, 0.3672, 0.75384, 0), day_257 = c(NA, NA, 0, 0, 0), day_258 = c(NA, NA, 0.50328, 0, 0), day_259 = c(NA, NA, 6.78888, 0, 0), day_260 = c(NA, NA, 0.96984, 0, 0), day_261 = c(NA, NA, 4.62672, 0, 0), day_262 = c(NA, NA, 0, 0, 0), day_263 = c(NA, NA, 3.16224, 0.27864, 0), day_264 = c(NA, NA, 0, 1.31112, 0), day_265 = c(NA, NA, 0.37692, 0, 0), day_266 = c(NA, NA, 0, 0, 0), day_267 = c(NA, NA, 0.70524, 0.43524, 0), day_268 = c(NA, NA, 0.18792, 0.12744, 0), day_269 = c(NA, NA, 0, 1.79064, 0.96012), day_270 = c(NA, NA, 0, 0, 0.58644), day_271 = c(NA, NA, 4.4982, 0, 0), day_272 = c(NA, NA, 0, 0, 0), day_273 = c(NA, NA, 2.04552, 6.56964, 0), day_274 = c(NA, NA, 0.71712, 0.93852, 0), day_275 = c(NA, NA, 0, 0, 0), day_276 = c(NA, NA, 0, 0, 0), day_277 = c(NA, NA, 3.31452, 0, 0), day_278 = c(NA, NA, 1.20204, 0, 0), day_279 = c(NA, NA, 0, 0, 0), day_280 = c(NA, NA, 0, 0, 0), day_281 = c(NA, NA, 0, 0, 0), day_282 = c(NA, NA, 17.955, 5.7942, 9.93816), day_283 = c(NA, NA, 4.79304, 4.8006, 0), day_284 = c(NA, NA, 3.9366, 0.78084, 0), day_285 = c(NA, NA, 0, 0, 0), day_286 = c(NA, NA, 0, 0, 0), day_287 = c(NA, NA, 0, 0, 0), day_288 = c(NA, NA, 0, 0, 0), day_289 = c(NA, NA, 0, 0, 0), day_290 = c(NA, NA, 0, 0, 0), day_291 = c(NA, NA, 0, 0, 0), day_292 = c(NA, NA, 0, 0, 0), day_293 = c(NA, NA, 1.55736, 0, 0), day_294 = c(NA, NA, 4.28328, 0, 0), day_295 = c(NA, NA, 0, 0, 0), day_296 = c(NA, NA, 0, 0, 0), day_297 = c(NA, NA, 1.6362, 0, 0), day_298 = c(NA, NA, 1.28844, 0, 6.14088 ), day_299 = c(NA, NA, 0, 0, 0.50112), day_300 = c(NA, NA, 0, 0, 0), day_301 = c(NA, NA, 0, 0.13824, 0.03456), day_302 = c(NA, NA, 0, 2.92572, 9.24264), day_303 = c(NA, NA, 2.8188, 0.41796, 0), day_304 = c(NA, NA, 2.04876, 11.28384, 0), day_305 = c(NA, NA, 0, 0.3564, 0), day_306 = c(NA, NA, 0, 0, 0), day_307 = c(NA, NA, 0, 2.36736, 0), day_308 = c(NA, NA, 0, 0, 0), day_309 = c(NA, NA, 34.91856, 20.42604, 0), day_310 = c(NA, NA, 0, 0, 0), day_311 = c(NA, NA, 0, 0, 0), day_312 = c(NA, NA, 0, 0.40392, 0), day_313 = c(NA, NA, 0, 0.5292, 0), day_314 = c(NA, NA, 0, 0, 5.21424), day_315 = c(NA, NA, 0, 0, 0), day_316 = c(NA, NA, 0, 0, 0.4266), day_317 = c(NA, NA, 0, 0, 0), day_318 = c(NA, NA, 0, 0, 0), day_319 = c(NA, NA, 0, 0, 0), day_320 = c(NA, NA, 0.23436, 0.6048, 14.9256), day_321 = c(NA, NA, 0, 0.10908, 0), day_322 = c(NA, NA, 7.68096, 6.66036, 4.53924), day_323 = c(NA, NA, 1.09728, 1.59732, 8.51148), day_324 = c(NA, NA, 0, 0, 0), day_325 = c(NA, NA, 1.46016, 0, 0), day_326 = c(NA, NA, 0, 0, 8.70048), day_327 = c(NA, NA, 0, 0, 0), day_328 = c(NA, NA, 0, 0, 0), day_329 = c(NA, NA, 0, 0, 0), day_330 = c(NA, NA, 5.3082, 0, 0), day_331 = c(NA, NA, 2.5866, 0, 0), day_332 = c(NA, NA, 8.03628, 6.3666, 4.3308), day_333 = c(NA, NA, 0, 0, 0 ), day_334 = c(NA, NA, 0, 0, 0), day_335 = c(NA, NA, 0, 0, 0), day_336 = c(NA, NA, 0, 0, 5.29632), day_337 = c(NA, NA, 0, 1.77444, 2.7216), day_338 = c(NA, NA, 0.40608, 0, 0.83052 ), day_339 = c(NA, NA, 0, 0, 0), day_340 = c(NA, NA, 0, 0, 0), day_341 = c(NA, NA, 0, 0, 0), day_342 = c(NA, NA, 0, 0, 0), day_343 = c(NA, NA, 0, 0, 0), day_344 = c(NA, NA, 7.73388, 0, 0), day_345 = c(NA, NA, 4.80384, 0, 0), day_346 = c(NA, NA, 4.374, 0.09288, 0), day_347 = c(NA, NA, 6.42924, 3.2022, 0), day_348 = c(NA, NA, 0, 16.27668, 0), day_349 = c(NA, NA, 0, 0.90072, 9.36684), day_350 = c(NA, NA, 0.135, 1.87272, 2.49048), day_351 = c(NA, NA, 0, 0, 0), day_352 = c(NA, NA, 0, 0, 0), day_353 = c(NA, NA, 0, 0, 0), day_354 = c(NA, NA, 0, 0, 0), day_355 = c(NA, NA, 0, 0, 0), day_356 = c(NA, NA, 0, 0, 0), day_357 = c(NA, NA, 2.82636, 39.45348, 26.08848 ), day_358 = c(NA, NA, 0, 0, 22.8582), day_359 = c(NA, NA, 0, 0, 1.34028), day_360 = c(NA, NA, 30.03804, 0, 3.49704), day_361 = c(NA, NA, 0.13392, 4.941, 4.94424), day_362 = c(NA, NA, 0.92016, 0, 0.70632), day_363 = c(NA, NA, 0, 0, 0), day_364 = c(NA, NA, 0, 0, 0), day_365 = c(NA, NA, 0, 0, 0), day_366 = c(NA, NA, 21.42072, 0, 0)), .Names = c("ISO3", "lon", "lat", "day_1", "day_2", "day_3", "day_4", "day_5", "day_6", "day_7", "day_8", "day_9", "day_10", "day_11", "day_12", "day_13", "day_14", "day_15", "day_16", "day_17", "day_18", "day_19", "day_20", "day_21", "day_22", "day_23", "day_24", "day_25", "day_26", "day_27", "day_28", "day_29", "day_30", "day_31", "day_32", "day_33", "day_34", "day_35", "day_36", "day_37", "day_38", "day_39", "day_40", "day_41", "day_42", "day_43", "day_44", "day_45", "day_46", "day_47", "day_48", "day_49", "day_50", "day_51", "day_52", "day_53", "day_54", "day_55", "day_56", "day_57", "day_58", "day_59", "day_60", "day_61", "day_62", "day_63", "day_64", "day_65", "day_66", "day_67", "day_68", "day_69", "day_70", "day_71", "day_72", "day_73", "day_74", "day_75", "day_76", "day_77", "day_78", "day_79", "day_80", "day_81", "day_82", "day_83", "day_84", "day_85", "day_86", "day_87", "day_88", "day_89", "day_90", "day_91", "day_92", "day_93", "day_94", "day_95", "day_96", "day_97", "day_98", "day_99", "day_100", "day_101", "day_102", "day_103", "day_104", "day_105", "day_106", "day_107", "day_108", "day_109", "day_110", "day_111", "day_112", "day_113", "day_114", "day_115", "day_116", "day_117", "day_118", "day_119", "day_120", "day_121", "day_122", "day_123", "day_124", "day_125", "day_126", "day_127", "day_128", "day_129", "day_130", "day_131", "day_132", "day_133", "day_134", "day_135", "day_136", "day_137", "day_138", "day_139", "day_140", "day_141", "day_142", "day_143", "day_144", "day_145", "day_146", "day_147", "day_148", "day_149", "day_150", "day_151", "day_152", "day_153", "day_154", "day_155", "day_156", "day_157", "day_158", "day_159", "day_160", "day_161", "day_162", "day_163", "day_164", "day_165", "day_166", "day_167", "day_168", "day_169", "day_170", "day_171", "day_172", "day_173", "day_174", "day_175", "day_176", "day_177", "day_178", "day_179", "day_180", "day_181", "day_182", "day_183", "day_184", "day_185", "day_186", "day_187", "day_188", "day_189", "day_190", "day_191", "day_192", "day_193", "day_194", "day_195", "day_196", "day_197", "day_198", "day_199", "day_200", "day_201", "day_202", "day_203", "day_204", "day_205", "day_206", "day_207", "day_208", "day_209", "day_210", "day_211", "day_212", "day_213", "day_214", "day_215", "day_216", "day_217", "day_218", "day_219", "day_220", "day_221", "day_222", "day_223", "day_224", "day_225", "day_226", "day_227", "day_228", "day_229", "day_230", "day_231", "day_232", "day_233", "day_234", "day_235", "day_236", "day_237", "day_238", "day_239", "day_240", "day_241", "day_242", "day_243", "day_244", "day_245", "day_246", "day_247", "day_248", "day_249", "day_250", "day_251", "day_252", "day_253", "day_254", "day_255", "day_256", "day_257", "day_258", "day_259", "day_260", "day_261", "day_262", "day_263", "day_264", "day_265", "day_266", "day_267", "day_268", "day_269", "day_270", "day_271", "day_272", "day_273", "day_274", "day_275", "day_276", "day_277", "day_278", "day_279", "day_280", "day_281", "day_282", "day_283", "day_284", "day_285", "day_286", "day_287", "day_288", "day_289", "day_290", "day_291", "day_292", "day_293", "day_294", "day_295", "day_296", "day_297", "day_298", "day_299", "day_300", "day_301", "day_302", "day_303", "day_304", "day_305", "day_306", "day_307", "day_308", "day_309", "day_310", "day_311", "day_312", "day_313", "day_314", "day_315", "day_316", "day_317", "day_318", "day_319", "day_320", "day_321", "day_322", "day_323", "day_324", "day_325", "day_326", "day_327", "day_328", "day_329", "day_330", "day_331", "day_332", "day_333", "day_334", "day_335", "day_336", "day_337", "day_338", "day_339", "day_340", "day_341", "day_342", "day_343", "day_344", "day_345", "day_346", "day_347", "day_348", "day_349", "day_350", "day_351", "day_352", "day_353", "day_354", "day_355", "day_356", "day_357", "day_358", "day_359", "day_360", "day_361", "day_362", "day_363", "day_364", "day_365", "day_366"), row.names = c(NA, 5L), class "data.frame") [[alternative HTML version deleted]]
Milu, I am unsure what you are trying to do. Please provide a minimal reproducible example, and someone will likely be able to help you with the R code. What have you tried so far? kindest regards, Stephen On 11/18/2016 06:49 AM, Miluji Sb wrote:> Dear all, > > I have 51 years of data (1960 - 2010) in csv format, where each file > represents one year of data. Below is what each file looks like. > > These are temperature data by coordinates, my goal is to to compute max, > min, and mean by year for each of the coordinates and construct a panel > dataset. Any help will be appreciated, thank you! > > Sincerely, > > Milu > > temp <- dput(head(df,5)) > structure(list(ISO3 = structure(c(28L, 28L, 28L, NA, 28L), .Label > c("AFG", > "AGO", "ALB", "ARE", "ARG", "ARM", "AUS", "AUT", "AZE", "BDI", > "BEL", "BEN", "BFA", "BGD", "BGR", "BHS", "BIH", "BLR", "BLZ", > "BOL", "BRA", "BRN", "BTN", "BWA", "CAF", "CAN", "CHE", "CHL", > "CHN", "CIV", "CMR", "COD", "COG", "COL", "CRI", "CUB", "CYP", > "CZE", "DEU", "DJI", "DNK", "DOM", "DZA", "ECU", "EGY", "ERI", > "ESH", "ESP", "EST", "ETH", "FIN", "FJI", "FLK", "FRA", "GAB", > "GBR", "GEO", "GHA", "GIN", "GNB", "GNQ", "GRC", "GRL", "GTM", > "GUF", "GUY", "HND", "HRV", "HTI", "HUN", "IDN", "IND", "IRL", > "IRN", "IRQ", "ISL", "ISR", "ITA", "JAM", "JOR", "JPN", "KAZ", > "KEN", "KGZ", "KHM", "KIR", "KOR", "KWT", "LAO", "LBN", "LBR", > "LBY", "LCA", "LKA", "LSO", "LTU", "LUX", "LVA", "MAR", "MDA", > "MDG", "MEX", "MKD", "MLI", "MMR", "MNE", "MNG", "MOZ", "MRT", > "MWI", "MYS", "NAM", "NCL", "NER", "NGA", "NIC", "NLD", "NOR", > "NPL", "NZL", "OMN", "PAK", "PAN", "PER", "PHL", "PNG", "POL", > "PRI", "PRK", "PRT", "PRY", "QAT", "ROU", "RUS", "RWA", "SAU", > "SDN", "SEN", "SJM", "SLB", "SLE", "SLV", "SOM", "SRB", "SUR", > "SVK", "SVN", "SWE", "SWZ", "SYR", "TCD", "TGO", "THA", "TJK", > "TKM", "TLS", "TUN", "TUR", "TWN", "TZA", "UGA", "UKR", "URY", > "USA", "UZB", "VEN", "VNM", "VUT", "YEM", "ZAF", "ZMB", "ZWE" > ), class = "factor"), lon = c(-69L, -68L, -72L, -71L, -70L), > lat = c(-55L, -55L, -54L, -54L, -54L), day_1 = c(NA, NA, > 0, 0, 0), day_2 = c(NA, NA, 0, 0, 0), day_3 = c(NA, NA, 0, > 23.37984, 0), day_4 = c(NA, NA, 0, 0, 0), day_5 = c(NA, NA, > 0, 0, 0), day_6 = c(NA, NA, 0, 0, 0), day_7 = c(NA, NA, 2.83824, > 11.80116, 1.24956), day_8 = c(NA, NA, 0, 1.68588, 14.69448 > ), day_9 = c(NA, NA, 0, 0, 1.09296), day_10 = c(NA, NA, 0, > 0, 0), day_11 = c(NA, NA, 3.78, 3.7422, 0), day_12 = c(NA, > NA, 0.54, 0, 0), day_13 = c(NA, NA, 0, 0, 0), day_14 = c(NA, > NA, 0, 0, 0.39204), day_15 = c(NA, NA, 0, 0, 11.58732), day_16 = c(NA, > NA, 0, 0, 0), day_17 = c(NA, NA, 0, 1.14048, 12.26448), day_18 = c(NA, > NA, 0, 1.1934, 7.59024), day_19 = c(NA, NA, 9.74268, 0, 0 > ), day_20 = c(NA, NA, 0, 0, 0), day_21 = c(NA, NA, 1.96776, > 0, 0), day_22 = c(NA, NA, 0, 0, 0), day_23 = c(NA, NA, 0, > 0, 0), day_24 = c(NA, NA, 6.21756, 2.74752, 0), day_25 = c(NA, > NA, 0, 0, 3.37932), day_26 = c(NA, NA, 4.8384, 0, 0), day_27 = c(NA, > NA, 0, 0, 0), day_28 = c(NA, NA, 0, 0, 0), day_29 = c(NA, > NA, 22.37328, 0, 0), day_30 = c(NA, NA, 28.97424, 11.25468, > 0), day_31 = c(NA, NA, 0, 0, 0), day_32 = c(NA, NA, 0, 0, > 2.00448), day_33 = c(NA, NA, 0, 0, 0), day_34 = c(NA, NA, > 0, 0, 0), day_35 = c(NA, NA, 0, 0, 0), day_36 = c(NA, NA, > 0, 0, 0), day_37 = c(NA, NA, 0, 0, 0), day_38 = c(NA, NA, > 32.7132, 31.71852, 0), day_39 = c(NA, NA, 0, 0, 5.84604), > day_40 = c(NA, NA, 0, 0, 0), day_41 = c(NA, NA, 0, 0, 0), > day_42 = c(NA, NA, 0, 0, 0), day_43 = c(NA, NA, 0, 0, 0), > day_44 = c(NA, NA, 0, 0, 1.78416), day_45 = c(NA, NA, 0, > 0, 0), day_46 = c(NA, NA, 33.84504, 0, 0), day_47 = c(NA, > NA, 0, 0, 0), day_48 = c(NA, NA, 0, 0, 0), day_49 = c(NA, > NA, 0, 0, 0), day_50 = c(NA, NA, 0, 0.4752, 0), day_51 = c(NA, > NA, 0, 0, 22.02012), day_52 = c(NA, NA, 0, 0, 0), day_53 = c(NA, > NA, 0, 0, 3.48084), day_54 = c(NA, NA, 0, 0, 0), day_55 = c(NA, > NA, 0.58212, 0, 0), day_56 = c(NA, NA, 0.35316, 0, 0), day_57 = c(NA, > NA, 0, 0, 12.65436), day_58 = c(NA, NA, 0, 0, 0), day_59 = c(NA, > NA, 0, 0, 0), day_60 = c(NA, NA, 3.03372, 22.05576, 0), day_61 = c(NA, > NA, 2.5758, 0, 0), day_62 = c(NA, NA, 0, 0, 0), day_63 = c(NA, > NA, 3.67416, 25.22016, 4.21524), day_64 = c(NA, NA, 0.52488, > 3.60288, 0), day_65 = c(NA, NA, 12.82608, 0, 0), day_66 = c(NA, > NA, 0, 0, 0), day_67 = c(NA, NA, 0, 0, 0), day_68 = c(NA, > NA, 0, 0, 0), day_69 = c(NA, NA, 0, 0, 0), day_70 = c(NA, > NA, 1.11564, 5.17536, 0), day_71 = c(NA, NA, 1.18584, 0, > 0), day_72 = c(NA, NA, 0, 0, 0.10584), day_73 = c(NA, NA, > 0.62748, 14.39748, 7.50708), day_74 = c(NA, NA, 7.20252, > 20.02644, 1.07244), day_75 = c(NA, NA, 1.87488, 0, 0), day_76 = c(NA, > NA, 0.26784, 0, 0), day_77 = c(NA, NA, 0, 0, 0), day_78 = c(NA, > NA, 0, 0, 2.81664), day_79 = c(NA, NA, 0, 0, 0), day_80 = c(NA, > NA, 0, 0, 0), day_81 = c(NA, NA, 0, 0, 0), day_82 = c(NA, > NA, 1.29276, 0, 0), day_83 = c(NA, NA, 0.18468, 0, 1.46124 > ), day_84 = c(NA, NA, 0, 0, 0), day_85 = c(NA, NA, 0, 0, > 0), day_86 = c(NA, NA, 57.36528, 0, 0), day_87 = c(NA, NA, > 8.19504, 0, 0), day_88 = c(NA, NA, 0, 0, 0), day_89 = c(NA, > NA, 6.45732, 0, 0), day_90 = c(NA, NA, 0, 0, 0), day_91 = c(NA, > NA, 0, 0, 44.20332), day_92 = c(NA, NA, 0, 0, 6.31476), day_93 = c(NA, > NA, 0, 0, 0.35748), day_94 = c(NA, NA, 16.74972, 30.35988, > 5.0436), day_95 = c(NA, NA, 4.93992, 1.46556, 19.86768), > day_96 = c(NA, NA, 0, 0, 0.88128), day_97 = c(NA, NA, 5.751, > 19.02096, 0), day_98 = c(NA, NA, 11.5452, 13.37148, 0), day_99 = c(NA, > NA, 0, 0, 0), day_100 = c(NA, NA, 0, 0, 0), day_101 = c(NA, > NA, 4.70124, 23.80644, 7.61832), day_102 = c(NA, NA, 0, 1.02492, > 0), day_103 = c(NA, NA, 0, 0, 15.86304), day_104 = c(NA, > NA, 0, 0, 0.26352), day_105 = c(NA, NA, 0, 0, 21.60864), > day_106 = c(NA, NA, 56.93436, 0, 0.22464), day_107 = c(NA, > NA, 8.13348, 0, 0), day_108 = c(NA, NA, 6.83748, 0, 0), day_109 = c(NA, > NA, 0, 0, 0), day_110 = c(NA, NA, 14.36724, 0, 0), day_111 = c(NA, > NA, 0.63936, 2.43864, 4.0554), day_112 = c(NA, NA, 1.21392, > 1.15452, 0), day_113 = c(NA, NA, 0.7722, 0, 0), day_114 = c(NA, > NA, 0, 0, 1.08864), day_115 = c(NA, NA, 1.47528, 0, 0), day_116 = c(NA, > NA, 0, 1.73124, 0), day_117 = c(NA, NA, 0, 0, 0), day_118 = c(NA, > NA, 2.4516, 0, 0), day_119 = c(NA, NA, 0, 3.14388, 0), day_120 = c(NA, > NA, 1.81872, 0, 0), day_121 = c(NA, NA, 2.77236, 0, 0), day_122 = c(NA, > NA, 1.34028, 0.70632, 0), day_123 = c(NA, NA, 0, 0, 0), day_124 = c(NA, > NA, 0, 0, 0), day_125 = c(NA, NA, 0.56484, 0.74412, 0), day_126 = c(NA, > NA, 1.11888, 0.06264, 0), day_127 = c(NA, NA, 0, 0, 0), day_128 = c(NA, > NA, 1.05624, 0, 0), day_129 = c(NA, NA, 26.63928, 34.04268, > 0), day_130 = c(NA, NA, 6.89796, 0, 0), day_131 = c(NA, NA, > 1.91592, 2.241, 0), day_132 = c(NA, NA, 0, 2.23668, 45.23904 > ), day_133 = c(NA, NA, 0, 0, 6.46272), day_134 = c(NA, NA, > 0, 0, 0), day_135 = c(NA, NA, 0, 0, 0), day_136 = c(NA, NA, > 0, 0, 0), day_137 = c(NA, NA, 0, 0, 0), day_138 = c(NA, NA, > 0, 0, 0), day_139 = c(NA, NA, 0, 0, 0), day_140 = c(NA, NA, > 0, 0, 0), day_141 = c(NA, NA, 0, 0, 0), day_142 = c(NA, NA, > 0, 0, 0), day_143 = c(NA, NA, 0, 0, 0), day_144 = c(NA, NA, > 2.943, 5.17536, 0), day_145 = c(NA, NA, 0, 0, 0), day_146 = c(NA, > NA, 0, 0, 0), day_147 = c(NA, NA, 0, 0, 0), day_148 = c(NA, > NA, 10.96308, 2.98188, 0), day_149 = c(NA, NA, 20.4822, 0.43632, > 0), day_150 = c(NA, NA, 1.5282, 0, 0), day_151 = c(NA, NA, > 0, 0, 0), day_152 = c(NA, NA, 0, 0, 0), day_153 = c(NA, NA, > 0, 0, 0), day_154 = c(NA, NA, 0, 0, 0), day_155 = c(NA, NA, > 0, 0, 0), day_156 = c(NA, NA, 0, 0, 0), day_157 = c(NA, NA, > 0, 0, 0), day_158 = c(NA, NA, 0, 0, 0), day_159 = c(NA, NA, > 0, 0, 0), day_160 = c(NA, NA, 0, 0, 0), day_161 = c(NA, NA, > 0, 0, 0), day_162 = c(NA, NA, 0, 0, 0), day_163 = c(NA, NA, > 0, 26.3412, 4.07376), day_164 = c(NA, NA, 0, 4.28328, 3.03156 > ), day_165 = c(NA, NA, 0, 0, 0), day_166 = c(NA, NA, 0, 0, > 4.60404), day_167 = c(NA, NA, 0, 0, 0.70848), day_168 = c(NA, > NA, 0, 0, 0), day_169 = c(NA, NA, 0, 0, 0), day_170 = c(NA, > NA, 0, 0, 0), day_171 = c(NA, NA, 0, 0, 0), day_172 = c(NA, > NA, 0, 0, 0), day_173 = c(NA, NA, 0, 0, 3.7854), day_174 = c(NA, > NA, 0, 0, 0), day_175 = c(NA, NA, 0, 0, 0), day_176 = c(NA, > NA, 0, 0, 0), day_177 = c(NA, NA, 0, 0, 0), day_178 = c(NA, > NA, 0, 0, 0), day_179 = c(NA, NA, 0, 0, 0), day_180 = c(NA, > NA, 0, 0, 0), day_181 = c(NA, NA, 0, 0, 0), day_182 = c(NA, > NA, 0, 0, 0), day_183 = c(NA, NA, 0, 0, 0), day_184 = c(NA, > NA, 0, 0, 0), day_185 = c(NA, NA, 0, 0, 0), day_186 = c(NA, > NA, 0, 0, 0), day_187 = c(NA, NA, 7.30728, 4.1202, 0), day_188 = c(NA, > NA, 2.56608, 0.5886, 0), day_189 = c(NA, NA, 0, 0, 0), day_190 = c(NA, > NA, 21.93156, 8.0082, 11.4318), day_191 = c(NA, NA, 3.13308, > 0, 0), day_192 = c(NA, NA, 0, 0, 0.10692), day_193 = c(NA, > NA, 0, 0, 4.65912), day_194 = c(NA, NA, 0, 0, 0), day_195 = c(NA, > NA, 0, 0, 0), day_196 = c(NA, NA, 0, 0, 0), day_197 = c(NA, > NA, 0, 0, 0), day_198 = c(NA, NA, 0, 0, 0), day_199 = c(NA, > NA, 0, 0, 0), day_200 = c(NA, NA, 0, 0, 0), day_201 = c(NA, > NA, 0, 0, 0), day_202 = c(NA, NA, 0, 7.77276, 4.6602), day_203 = c(NA, > NA, 0, 0.86292, 0), day_204 = c(NA, NA, 0, 0, 0), day_205 = c(NA, > NA, 21.45528, 8.69616, 0), day_206 = c(NA, NA, 0, 0, 0), > day_207 = c(NA, NA, 0, 0, 0), day_208 = c(NA, NA, 0, 0, 0 > ), day_209 = c(NA, NA, 0, 0, 0), day_210 = c(NA, NA, 0, 0, > 0), day_211 = c(NA, NA, 0, 0, 0), day_212 = c(NA, NA, 0, > 0, 0), day_213 = c(NA, NA, 0, 0, 0), day_214 = c(NA, NA, > 0, 0, 0), day_215 = c(NA, NA, 0, 0, 0), day_216 = c(NA, NA, > 0, 0, 0), day_217 = c(NA, NA, 0, 0, 0), day_218 = c(NA, NA, > 0, 0, 0), day_219 = c(NA, NA, 0, 0, 0), day_220 = c(NA, NA, > 6.10092, 10.85508, 13.22244), day_221 = c(NA, NA, 0.87156, > 0, 0), day_222 = c(NA, NA, 0, 0, 15.46452), day_223 = c(NA, > NA, 0, 0, 9.83664), day_224 = c(NA, NA, 0, 0, 0), day_225 = c(NA, > NA, 0, 0, 0), day_226 = c(NA, NA, 16.46028, 0, 0), day_227 = c(NA, > NA, 0, 0, 0), day_228 = c(NA, NA, 0, 0, 0), day_229 = c(NA, > NA, 0, 0, 0), day_230 = c(NA, NA, 0, 0, 0), day_231 = c(NA, > NA, 2.7108, 0, 0), day_232 = c(NA, NA, 0, 0, 0), day_233 = c(NA, > NA, 0, 0, 0), day_234 = c(NA, NA, 0, 0, 0), day_235 = c(NA, > NA, 0, 0, 0), day_236 = c(NA, NA, 0, 0, 3.5586), day_237 = c(NA, > NA, 0, 0, 0), day_238 = c(NA, NA, 0, 0, 0), day_239 = c(NA, > NA, 10.23192, 0, 0), day_240 = c(NA, NA, 0, 0, 0), day_241 = c(NA, > NA, 0, 0, 0), day_242 = c(NA, NA, 0, 0, 0), day_243 = c(NA, > NA, 0, 0, 0), day_244 = c(NA, NA, 0, 0, 0), day_245 = c(NA, > NA, 0, 0, 0), day_246 = c(NA, NA, 0, 0, 0), day_247 = c(NA, > NA, 0, 0, 0), day_248 = c(NA, NA, 0, 0, 0), day_249 = c(NA, > NA, 0.50544, 0, 0), day_250 = c(NA, NA, 0.12636, 0, 0), day_251 = c(NA, > NA, 7.02432, 0, 5.39784), day_252 = c(NA, NA, 3.33828, 8.00064, > 7.08372), day_253 = c(NA, NA, 0, 0, 0), day_254 = c(NA, NA, > 0, 0, 0), day_255 = c(NA, NA, 2.5704, 4.71636, 11.99772), > day_256 = c(NA, NA, 0.3672, 0.75384, 0), day_257 = c(NA, > NA, 0, 0, 0), day_258 = c(NA, NA, 0.50328, 0, 0), day_259 = c(NA, > NA, 6.78888, 0, 0), day_260 = c(NA, NA, 0.96984, 0, 0), day_261 = c(NA, > NA, 4.62672, 0, 0), day_262 = c(NA, NA, 0, 0, 0), day_263 = c(NA, > NA, 3.16224, 0.27864, 0), day_264 = c(NA, NA, 0, 1.31112, > 0), day_265 = c(NA, NA, 0.37692, 0, 0), day_266 = c(NA, NA, > 0, 0, 0), day_267 = c(NA, NA, 0.70524, 0.43524, 0), day_268 = c(NA, > NA, 0.18792, 0.12744, 0), day_269 = c(NA, NA, 0, 1.79064, > 0.96012), day_270 = c(NA, NA, 0, 0, 0.58644), day_271 = c(NA, > NA, 4.4982, 0, 0), day_272 = c(NA, NA, 0, 0, 0), day_273 = c(NA, > NA, 2.04552, 6.56964, 0), day_274 = c(NA, NA, 0.71712, 0.93852, > 0), day_275 = c(NA, NA, 0, 0, 0), day_276 = c(NA, NA, 0, > 0, 0), day_277 = c(NA, NA, 3.31452, 0, 0), day_278 = c(NA, > NA, 1.20204, 0, 0), day_279 = c(NA, NA, 0, 0, 0), day_280 = c(NA, > NA, 0, 0, 0), day_281 = c(NA, NA, 0, 0, 0), day_282 = c(NA, > NA, 17.955, 5.7942, 9.93816), day_283 = c(NA, NA, 4.79304, > 4.8006, 0), day_284 = c(NA, NA, 3.9366, 0.78084, 0), day_285 = c(NA, > NA, 0, 0, 0), day_286 = c(NA, NA, 0, 0, 0), day_287 = c(NA, > NA, 0, 0, 0), day_288 = c(NA, NA, 0, 0, 0), day_289 = c(NA, > NA, 0, 0, 0), day_290 = c(NA, NA, 0, 0, 0), day_291 = c(NA, > NA, 0, 0, 0), day_292 = c(NA, NA, 0, 0, 0), day_293 = c(NA, > NA, 1.55736, 0, 0), day_294 = c(NA, NA, 4.28328, 0, 0), day_295 = c(NA, > NA, 0, 0, 0), day_296 = c(NA, NA, 0, 0, 0), day_297 = c(NA, > NA, 1.6362, 0, 0), day_298 = c(NA, NA, 1.28844, 0, 6.14088 > ), day_299 = c(NA, NA, 0, 0, 0.50112), day_300 = c(NA, NA, > 0, 0, 0), day_301 = c(NA, NA, 0, 0.13824, 0.03456), day_302 = c(NA, > NA, 0, 2.92572, 9.24264), day_303 = c(NA, NA, 2.8188, 0.41796, > 0), day_304 = c(NA, NA, 2.04876, 11.28384, 0), day_305 = c(NA, > NA, 0, 0.3564, 0), day_306 = c(NA, NA, 0, 0, 0), day_307 = c(NA, > NA, 0, 2.36736, 0), day_308 = c(NA, NA, 0, 0, 0), day_309 = c(NA, > NA, 34.91856, 20.42604, 0), day_310 = c(NA, NA, 0, 0, 0), > day_311 = c(NA, NA, 0, 0, 0), day_312 = c(NA, NA, 0, 0.40392, > 0), day_313 = c(NA, NA, 0, 0.5292, 0), day_314 = c(NA, NA, > 0, 0, 5.21424), day_315 = c(NA, NA, 0, 0, 0), day_316 = c(NA, > NA, 0, 0, 0.4266), day_317 = c(NA, NA, 0, 0, 0), day_318 = c(NA, > NA, 0, 0, 0), day_319 = c(NA, NA, 0, 0, 0), day_320 = c(NA, > NA, 0.23436, 0.6048, 14.9256), day_321 = c(NA, NA, 0, 0.10908, > 0), day_322 = c(NA, NA, 7.68096, 6.66036, 4.53924), day_323 = c(NA, > NA, 1.09728, 1.59732, 8.51148), day_324 = c(NA, NA, 0, 0, > 0), day_325 = c(NA, NA, 1.46016, 0, 0), day_326 = c(NA, NA, > 0, 0, 8.70048), day_327 = c(NA, NA, 0, 0, 0), day_328 = c(NA, > NA, 0, 0, 0), day_329 = c(NA, NA, 0, 0, 0), day_330 = c(NA, > NA, 5.3082, 0, 0), day_331 = c(NA, NA, 2.5866, 0, 0), day_332 = c(NA, > NA, 8.03628, 6.3666, 4.3308), day_333 = c(NA, NA, 0, 0, 0 > ), day_334 = c(NA, NA, 0, 0, 0), day_335 = c(NA, NA, 0, 0, > 0), day_336 = c(NA, NA, 0, 0, 5.29632), day_337 = c(NA, NA, > 0, 1.77444, 2.7216), day_338 = c(NA, NA, 0.40608, 0, 0.83052 > ), day_339 = c(NA, NA, 0, 0, 0), day_340 = c(NA, NA, 0, 0, > 0), day_341 = c(NA, NA, 0, 0, 0), day_342 = c(NA, NA, 0, > 0, 0), day_343 = c(NA, NA, 0, 0, 0), day_344 = c(NA, NA, > 7.73388, 0, 0), day_345 = c(NA, NA, 4.80384, 0, 0), day_346 = c(NA, > NA, 4.374, 0.09288, 0), day_347 = c(NA, NA, 6.42924, 3.2022, > 0), day_348 = c(NA, NA, 0, 16.27668, 0), day_349 = c(NA, > NA, 0, 0.90072, 9.36684), day_350 = c(NA, NA, 0.135, 1.87272, > 2.49048), day_351 = c(NA, NA, 0, 0, 0), day_352 = c(NA, NA, > 0, 0, 0), day_353 = c(NA, NA, 0, 0, 0), day_354 = c(NA, NA, > 0, 0, 0), day_355 = c(NA, NA, 0, 0, 0), day_356 = c(NA, NA, > 0, 0, 0), day_357 = c(NA, NA, 2.82636, 39.45348, 26.08848 > ), day_358 = c(NA, NA, 0, 0, 22.8582), day_359 = c(NA, NA, > 0, 0, 1.34028), day_360 = c(NA, NA, 30.03804, 0, 3.49704), > day_361 = c(NA, NA, 0.13392, 4.941, 4.94424), day_362 = c(NA, > NA, 0.92016, 0, 0.70632), day_363 = c(NA, NA, 0, 0, 0), day_364 = c(NA, > NA, 0, 0, 0), day_365 = c(NA, NA, 0, 0, 0), day_366 = c(NA, > NA, 21.42072, 0, 0)), .Names = c("ISO3", "lon", "lat", "day_1", > "day_2", "day_3", "day_4", "day_5", "day_6", "day_7", "day_8", > "day_9", "day_10", "day_11", "day_12", "day_13", "day_14", "day_15", > "day_16", "day_17", "day_18", "day_19", "day_20", "day_21", "day_22", > "day_23", "day_24", "day_25", "day_26", "day_27", "day_28", "day_29", > "day_30", "day_31", "day_32", "day_33", "day_34", "day_35", "day_36", > "day_37", "day_38", "day_39", "day_40", "day_41", "day_42", "day_43", > "day_44", "day_45", "day_46", "day_47", "day_48", "day_49", "day_50", > "day_51", "day_52", "day_53", "day_54", "day_55", "day_56", "day_57", > "day_58", "day_59", "day_60", "day_61", "day_62", "day_63", "day_64", > "day_65", "day_66", "day_67", "day_68", "day_69", "day_70", "day_71", > "day_72", "day_73", "day_74", "day_75", "day_76", "day_77", "day_78", > "day_79", "day_80", "day_81", "day_82", "day_83", "day_84", "day_85", > "day_86", "day_87", "day_88", "day_89", "day_90", "day_91", "day_92", > "day_93", "day_94", "day_95", "day_96", "day_97", "day_98", "day_99", > "day_100", "day_101", "day_102", "day_103", "day_104", "day_105", > "day_106", "day_107", "day_108", "day_109", "day_110", "day_111", > "day_112", "day_113", "day_114", "day_115", "day_116", "day_117", > "day_118", "day_119", "day_120", "day_121", "day_122", "day_123", > "day_124", "day_125", "day_126", "day_127", "day_128", "day_129", > "day_130", "day_131", "day_132", "day_133", "day_134", "day_135", > "day_136", "day_137", "day_138", "day_139", "day_140", "day_141", > "day_142", "day_143", "day_144", "day_145", "day_146", "day_147", > "day_148", "day_149", "day_150", "day_151", "day_152", "day_153", > "day_154", "day_155", "day_156", "day_157", "day_158", "day_159", > "day_160", "day_161", "day_162", "day_163", "day_164", "day_165", > "day_166", "day_167", "day_168", "day_169", "day_170", "day_171", > "day_172", "day_173", "day_174", "day_175", "day_176", "day_177", > "day_178", "day_179", "day_180", "day_181", "day_182", "day_183", > "day_184", "day_185", "day_186", "day_187", "day_188", "day_189", > "day_190", "day_191", "day_192", "day_193", "day_194", "day_195", > "day_196", "day_197", "day_198", "day_199", "day_200", "day_201", > "day_202", "day_203", "day_204", "day_205", "day_206", "day_207", > "day_208", "day_209", "day_210", "day_211", "day_212", "day_213", > "day_214", "day_215", "day_216", "day_217", "day_218", "day_219", > "day_220", "day_221", "day_222", "day_223", "day_224", "day_225", > "day_226", "day_227", "day_228", "day_229", "day_230", "day_231", > "day_232", "day_233", "day_234", "day_235", "day_236", "day_237", > "day_238", "day_239", "day_240", "day_241", "day_242", "day_243", > "day_244", "day_245", "day_246", "day_247", "day_248", "day_249", > "day_250", "day_251", "day_252", "day_253", "day_254", "day_255", > "day_256", "day_257", "day_258", "day_259", "day_260", "day_261", > "day_262", "day_263", "day_264", "day_265", "day_266", "day_267", > "day_268", "day_269", "day_270", "day_271", "day_272", "day_273", > "day_274", "day_275", "day_276", "day_277", "day_278", "day_279", > "day_280", "day_281", "day_282", "day_283", "day_284", "day_285", > "day_286", "day_287", "day_288", "day_289", "day_290", "day_291", > "day_292", "day_293", "day_294", "day_295", "day_296", "day_297", > "day_298", "day_299", "day_300", "day_301", "day_302", "day_303", > "day_304", "day_305", "day_306", "day_307", "day_308", "day_309", > "day_310", "day_311", "day_312", "day_313", "day_314", "day_315", > "day_316", "day_317", "day_318", "day_319", "day_320", "day_321", > "day_322", "day_323", "day_324", "day_325", "day_326", "day_327", > "day_328", "day_329", "day_330", "day_331", "day_332", "day_333", > "day_334", "day_335", "day_336", "day_337", "day_338", "day_339", > "day_340", "day_341", "day_342", "day_343", "day_344", "day_345", > "day_346", "day_347", "day_348", "day_349", "day_350", "day_351", > "day_352", "day_353", "day_354", "day_355", "day_356", "day_357", > "day_358", "day_359", "day_360", "day_361", "day_362", "day_363", > "day_364", "day_365", "day_366"), row.names = c(NA, 5L), class > "data.frame") > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at 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.-- Let's not spend our time and resources thinking about things that are so little or so large that all they really do for us is puff us up and make us feel like gods. We are mammals, and have not exhausted the annoying little problems of being mammals. -K. Mullis "A big computer, a complex algorithm and a long time does not equal science." -Robert Gentleman
Hi I am not completely sure what you want to do but> apply(temp[,-(1:3)],1, mean, na.rm=T)1 2 3 4 5 NaN NaN 2.159516 1.519914 1.514007> apply(temp[,-(1:3)],1, max, na.rm=T)1 2 3 4 5 -Inf -Inf 57.36528 39.45348 45.23904 Warning messages: 1: In FUN(newX[, i], ...) : no non-missing arguments to max; returning -Inf 2: In FUN(newX[, i], ...) : no non-missing arguments to max; returning -Inf> apply(temp[,-(1:3)],1, min, na.rm=T)1 2 3 4 5 Inf Inf 0 0 0 gives you mentioned summary for each row. If you have duplicate rows you shall first aggregate them. However, it seems to me that your data are not correct. It is quite strange that for given lat/lon you have one day value 23 and the next day 0. temp[1:5, 1:10] ISO3 lon lat day_1 day_2 day_3 day_4 day_5 day_6 day_7 1 CHL -69 -55 NA NA NA NA NA NA NA 2 CHL -68 -55 NA NA NA NA NA NA NA 3 CHL -72 -54 0 0 0.00000 0 0 0 2.83824 4 <NA> -71 -54 0 0 23.37984 0 0 0 11.80116 5 CHL -70 -54 0 0 0.00000 0 0 0 1.24956 If you want to process all your files you can do it in cycle. The function list.files() can be handy for that task. Cheers Petr> -----Original Message----- > From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Miluji Sb > Sent: Friday, November 18, 2016 1:49 PM > To: r-help mailing list <r-help at r-project.org> > Subject: [R] Melt and compute Max, Mean, Min > > Dear all, > > I have 51 years of data (1960 - 2010) in csv format, where each file represents > one year of data. Below is what each file looks like. > > These are temperature data by coordinates, my goal is to to compute max, > min, and mean by year for each of the coordinates and construct a panel > dataset. Any help will be appreciated, thank you! > > Sincerely, > > Milu > > temp <- dput(head(df,5)) > structure(list(ISO3 = structure(c(28L, 28L, 28L, NA, 28L), .Label = c("AFG", > "AGO", "ALB", "ARE", "ARG", "ARM", "AUS", "AUT", "AZE", "BDI", "BEL", > "BEN", "BFA", "BGD", "BGR", "BHS", "BIH", "BLR", "BLZ", "BOL", "BRA", > "BRN", "BTN", "BWA", "CAF", "CAN", "CHE", "CHL", "CHN", "CIV", "CMR", > "COD", "COG", "COL", "CRI", "CUB", "CYP", "CZE", "DEU", "DJI", "DNK", > "DOM", "DZA", "ECU", "EGY", "ERI", "ESH", "ESP", "EST", "ETH", "FIN", "FJI", > "FLK", "FRA", "GAB", "GBR", "GEO", "GHA", "GIN", "GNB", "GNQ", "GRC", > "GRL", "GTM", "GUF", "GUY", "HND", "HRV", "HTI", "HUN", "IDN", "IND", > "IRL", "IRN", "IRQ", "ISL", "ISR", "ITA", "JAM", "JOR", "JPN", "KAZ", "KEN", > "KGZ", "KHM", "KIR", "KOR", "KWT", "LAO", "LBN", "LBR", "LBY", "LCA", > "LKA", "LSO", "LTU", "LUX", "LVA", "MAR", "MDA", "MDG", "MEX", "MKD", > "MLI", "MMR", "MNE", "MNG", "MOZ", "MRT", "MWI", "MYS", "NAM", > "NCL", "NER", "NGA", "NIC", "NLD", "NOR", "NPL", "NZL", "OMN", "PAK", > "PAN", "PER", "PHL", "PNG", "POL", "PRI", "PRK", "PRT", "PRY", "QAT", > "ROU", "RUS", "RWA", "SAU", "SDN", "SEN", "SJM", "SLB", "SLE", "SLV", > "SOM", "SRB", "SUR", "SVK", "SVN", "SWE", "SWZ", "SYR", "TCD", "TGO", > "THA", "TJK", "TKM", "TLS", "TUN", "TUR", "TWN", "TZA", "UGA", "UKR", > "URY", "USA", "UZB", "VEN", "VNM", "VUT", "YEM", "ZAF", "ZMB", "ZWE" > ), class = "factor"), lon = c(-69L, -68L, -72L, -71L, -70L), > lat = c(-55L, -55L, -54L, -54L, -54L), day_1 = c(NA, NA, > 0, 0, 0), day_2 = c(NA, NA, 0, 0, 0), day_3 = c(NA, NA, 0, > 23.37984, 0), day_4 = c(NA, NA, 0, 0, 0), day_5 = c(NA, NA, > 0, 0, 0), day_6 = c(NA, NA, 0, 0, 0), day_7 = c(NA, NA, 2.83824, > 11.80116, 1.24956), day_8 = c(NA, NA, 0, 1.68588, 14.69448 > ), day_9 = c(NA, NA, 0, 0, 1.09296), day_10 = c(NA, NA, 0, > 0, 0), day_11 = c(NA, NA, 3.78, 3.7422, 0), day_12 = c(NA, > NA, 0.54, 0, 0), day_13 = c(NA, NA, 0, 0, 0), day_14 = c(NA, > NA, 0, 0, 0.39204), day_15 = c(NA, NA, 0, 0, 11.58732), day_16 = c(NA, > NA, 0, 0, 0), day_17 = c(NA, NA, 0, 1.14048, 12.26448), day_18 = c(NA, > NA, 0, 1.1934, 7.59024), day_19 = c(NA, NA, 9.74268, 0, 0 > ), day_20 = c(NA, NA, 0, 0, 0), day_21 = c(NA, NA, 1.96776, > 0, 0), day_22 = c(NA, NA, 0, 0, 0), day_23 = c(NA, NA, 0, > 0, 0), day_24 = c(NA, NA, 6.21756, 2.74752, 0), day_25 = c(NA, > NA, 0, 0, 3.37932), day_26 = c(NA, NA, 4.8384, 0, 0), day_27 = c(NA, > NA, 0, 0, 0), day_28 = c(NA, NA, 0, 0, 0), day_29 = c(NA, > NA, 22.37328, 0, 0), day_30 = c(NA, NA, 28.97424, 11.25468, > 0), day_31 = c(NA, NA, 0, 0, 0), day_32 = c(NA, NA, 0, 0, > 2.00448), day_33 = c(NA, NA, 0, 0, 0), day_34 = c(NA, NA, > 0, 0, 0), day_35 = c(NA, NA, 0, 0, 0), day_36 = c(NA, NA, > 0, 0, 0), day_37 = c(NA, NA, 0, 0, 0), day_38 = c(NA, NA, > 32.7132, 31.71852, 0), day_39 = c(NA, NA, 0, 0, 5.84604), > day_40 = c(NA, NA, 0, 0, 0), day_41 = c(NA, NA, 0, 0, 0), > day_42 = c(NA, NA, 0, 0, 0), day_43 = c(NA, NA, 0, 0, 0), > day_44 = c(NA, NA, 0, 0, 1.78416), day_45 = c(NA, NA, 0, > 0, 0), day_46 = c(NA, NA, 33.84504, 0, 0), day_47 = c(NA, > NA, 0, 0, 0), day_48 = c(NA, NA, 0, 0, 0), day_49 = c(NA, > NA, 0, 0, 0), day_50 = c(NA, NA, 0, 0.4752, 0), day_51 = c(NA, > NA, 0, 0, 22.02012), day_52 = c(NA, NA, 0, 0, 0), day_53 = c(NA, > NA, 0, 0, 3.48084), day_54 = c(NA, NA, 0, 0, 0), day_55 = c(NA, > NA, 0.58212, 0, 0), day_56 = c(NA, NA, 0.35316, 0, 0), day_57 = c(NA, > NA, 0, 0, 12.65436), day_58 = c(NA, NA, 0, 0, 0), day_59 = c(NA, > NA, 0, 0, 0), day_60 = c(NA, NA, 3.03372, 22.05576, 0), day_61 = c(NA, > NA, 2.5758, 0, 0), day_62 = c(NA, NA, 0, 0, 0), day_63 = c(NA, > NA, 3.67416, 25.22016, 4.21524), day_64 = c(NA, NA, 0.52488, > 3.60288, 0), day_65 = c(NA, NA, 12.82608, 0, 0), day_66 = c(NA, > NA, 0, 0, 0), day_67 = c(NA, NA, 0, 0, 0), day_68 = c(NA, > NA, 0, 0, 0), day_69 = c(NA, NA, 0, 0, 0), day_70 = c(NA, > NA, 1.11564, 5.17536, 0), day_71 = c(NA, NA, 1.18584, 0, > 0), day_72 = c(NA, NA, 0, 0, 0.10584), day_73 = c(NA, NA, > 0.62748, 14.39748, 7.50708), day_74 = c(NA, NA, 7.20252, > 20.02644, 1.07244), day_75 = c(NA, NA, 1.87488, 0, 0), day_76 = c(NA, > NA, 0.26784, 0, 0), day_77 = c(NA, NA, 0, 0, 0), day_78 = c(NA, > NA, 0, 0, 2.81664), day_79 = c(NA, NA, 0, 0, 0), day_80 = c(NA, > NA, 0, 0, 0), day_81 = c(NA, NA, 0, 0, 0), day_82 = c(NA, > NA, 1.29276, 0, 0), day_83 = c(NA, NA, 0.18468, 0, 1.46124 > ), day_84 = c(NA, NA, 0, 0, 0), day_85 = c(NA, NA, 0, 0, > 0), day_86 = c(NA, NA, 57.36528, 0, 0), day_87 = c(NA, NA, > 8.19504, 0, 0), day_88 = c(NA, NA, 0, 0, 0), day_89 = c(NA, > NA, 6.45732, 0, 0), day_90 = c(NA, NA, 0, 0, 0), day_91 = c(NA, > NA, 0, 0, 44.20332), day_92 = c(NA, NA, 0, 0, 6.31476), day_93 = c(NA, > NA, 0, 0, 0.35748), day_94 = c(NA, NA, 16.74972, 30.35988, > 5.0436), day_95 = c(NA, NA, 4.93992, 1.46556, 19.86768), > day_96 = c(NA, NA, 0, 0, 0.88128), day_97 = c(NA, NA, 5.751, > 19.02096, 0), day_98 = c(NA, NA, 11.5452, 13.37148, 0), day_99 = c(NA, > NA, 0, 0, 0), day_100 = c(NA, NA, 0, 0, 0), day_101 = c(NA, > NA, 4.70124, 23.80644, 7.61832), day_102 = c(NA, NA, 0, 1.02492, > 0), day_103 = c(NA, NA, 0, 0, 15.86304), day_104 = c(NA, > NA, 0, 0, 0.26352), day_105 = c(NA, NA, 0, 0, 21.60864), > day_106 = c(NA, NA, 56.93436, 0, 0.22464), day_107 = c(NA, > NA, 8.13348, 0, 0), day_108 = c(NA, NA, 6.83748, 0, 0), day_109 = c(NA, > NA, 0, 0, 0), day_110 = c(NA, NA, 14.36724, 0, 0), day_111 = c(NA, > NA, 0.63936, 2.43864, 4.0554), day_112 = c(NA, NA, 1.21392, > 1.15452, 0), day_113 = c(NA, NA, 0.7722, 0, 0), day_114 = c(NA, > NA, 0, 0, 1.08864), day_115 = c(NA, NA, 1.47528, 0, 0), day_116 = c(NA, > NA, 0, 1.73124, 0), day_117 = c(NA, NA, 0, 0, 0), day_118 = c(NA, > NA, 2.4516, 0, 0), day_119 = c(NA, NA, 0, 3.14388, 0), day_120 = c(NA, > NA, 1.81872, 0, 0), day_121 = c(NA, NA, 2.77236, 0, 0), day_122 = c(NA, > NA, 1.34028, 0.70632, 0), day_123 = c(NA, NA, 0, 0, 0), day_124 = c(NA, > NA, 0, 0, 0), day_125 = c(NA, NA, 0.56484, 0.74412, 0), day_126 = c(NA, > NA, 1.11888, 0.06264, 0), day_127 = c(NA, NA, 0, 0, 0), day_128 = c(NA, > NA, 1.05624, 0, 0), day_129 = c(NA, NA, 26.63928, 34.04268, > 0), day_130 = c(NA, NA, 6.89796, 0, 0), day_131 = c(NA, NA, > 1.91592, 2.241, 0), day_132 = c(NA, NA, 0, 2.23668, 45.23904 > ), day_133 = c(NA, NA, 0, 0, 6.46272), day_134 = c(NA, NA, > 0, 0, 0), day_135 = c(NA, NA, 0, 0, 0), day_136 = c(NA, NA, > 0, 0, 0), day_137 = c(NA, NA, 0, 0, 0), day_138 = c(NA, NA, > 0, 0, 0), day_139 = c(NA, NA, 0, 0, 0), day_140 = c(NA, NA, > 0, 0, 0), day_141 = c(NA, NA, 0, 0, 0), day_142 = c(NA, NA, > 0, 0, 0), day_143 = c(NA, NA, 0, 0, 0), day_144 = c(NA, NA, > 2.943, 5.17536, 0), day_145 = c(NA, NA, 0, 0, 0), day_146 = c(NA, > NA, 0, 0, 0), day_147 = c(NA, NA, 0, 0, 0), day_148 = c(NA, > NA, 10.96308, 2.98188, 0), day_149 = c(NA, NA, 20.4822, 0.43632, > 0), day_150 = c(NA, NA, 1.5282, 0, 0), day_151 = c(NA, NA, > 0, 0, 0), day_152 = c(NA, NA, 0, 0, 0), day_153 = c(NA, NA, > 0, 0, 0), day_154 = c(NA, NA, 0, 0, 0), day_155 = c(NA, NA, > 0, 0, 0), day_156 = c(NA, NA, 0, 0, 0), day_157 = c(NA, NA, > 0, 0, 0), day_158 = c(NA, NA, 0, 0, 0), day_159 = c(NA, NA, > 0, 0, 0), day_160 = c(NA, NA, 0, 0, 0), day_161 = c(NA, NA, > 0, 0, 0), day_162 = c(NA, NA, 0, 0, 0), day_163 = c(NA, NA, > 0, 26.3412, 4.07376), day_164 = c(NA, NA, 0, 4.28328, 3.03156 > ), day_165 = c(NA, NA, 0, 0, 0), day_166 = c(NA, NA, 0, 0, > 4.60404), day_167 = c(NA, NA, 0, 0, 0.70848), day_168 = c(NA, > NA, 0, 0, 0), day_169 = c(NA, NA, 0, 0, 0), day_170 = c(NA, > NA, 0, 0, 0), day_171 = c(NA, NA, 0, 0, 0), day_172 = c(NA, > NA, 0, 0, 0), day_173 = c(NA, NA, 0, 0, 3.7854), day_174 = c(NA, > NA, 0, 0, 0), day_175 = c(NA, NA, 0, 0, 0), day_176 = c(NA, > NA, 0, 0, 0), day_177 = c(NA, NA, 0, 0, 0), day_178 = c(NA, > NA, 0, 0, 0), day_179 = c(NA, NA, 0, 0, 0), day_180 = c(NA, > NA, 0, 0, 0), day_181 = c(NA, NA, 0, 0, 0), day_182 = c(NA, > NA, 0, 0, 0), day_183 = c(NA, NA, 0, 0, 0), day_184 = c(NA, > NA, 0, 0, 0), day_185 = c(NA, NA, 0, 0, 0), day_186 = c(NA, > NA, 0, 0, 0), day_187 = c(NA, NA, 7.30728, 4.1202, 0), day_188 = c(NA, > NA, 2.56608, 0.5886, 0), day_189 = c(NA, NA, 0, 0, 0), day_190 = c(NA, > NA, 21.93156, 8.0082, 11.4318), day_191 = c(NA, NA, 3.13308, > 0, 0), day_192 = c(NA, NA, 0, 0, 0.10692), day_193 = c(NA, > NA, 0, 0, 4.65912), day_194 = c(NA, NA, 0, 0, 0), day_195 = c(NA, > NA, 0, 0, 0), day_196 = c(NA, NA, 0, 0, 0), day_197 = c(NA, > NA, 0, 0, 0), day_198 = c(NA, NA, 0, 0, 0), day_199 = c(NA, > NA, 0, 0, 0), day_200 = c(NA, NA, 0, 0, 0), day_201 = c(NA, > NA, 0, 0, 0), day_202 = c(NA, NA, 0, 7.77276, 4.6602), day_203 = c(NA, > NA, 0, 0.86292, 0), day_204 = c(NA, NA, 0, 0, 0), day_205 = c(NA, > NA, 21.45528, 8.69616, 0), day_206 = c(NA, NA, 0, 0, 0), > day_207 = c(NA, NA, 0, 0, 0), day_208 = c(NA, NA, 0, 0, 0 > ), day_209 = c(NA, NA, 0, 0, 0), day_210 = c(NA, NA, 0, 0, > 0), day_211 = c(NA, NA, 0, 0, 0), day_212 = c(NA, NA, 0, > 0, 0), day_213 = c(NA, NA, 0, 0, 0), day_214 = c(NA, NA, > 0, 0, 0), day_215 = c(NA, NA, 0, 0, 0), day_216 = c(NA, NA, > 0, 0, 0), day_217 = c(NA, NA, 0, 0, 0), day_218 = c(NA, NA, > 0, 0, 0), day_219 = c(NA, NA, 0, 0, 0), day_220 = c(NA, NA, > 6.10092, 10.85508, 13.22244), day_221 = c(NA, NA, 0.87156, > 0, 0), day_222 = c(NA, NA, 0, 0, 15.46452), day_223 = c(NA, > NA, 0, 0, 9.83664), day_224 = c(NA, NA, 0, 0, 0), day_225 = c(NA, > NA, 0, 0, 0), day_226 = c(NA, NA, 16.46028, 0, 0), day_227 = c(NA, > NA, 0, 0, 0), day_228 = c(NA, NA, 0, 0, 0), day_229 = c(NA, > NA, 0, 0, 0), day_230 = c(NA, NA, 0, 0, 0), day_231 = c(NA, > NA, 2.7108, 0, 0), day_232 = c(NA, NA, 0, 0, 0), day_233 = c(NA, > NA, 0, 0, 0), day_234 = c(NA, NA, 0, 0, 0), day_235 = c(NA, > NA, 0, 0, 0), day_236 = c(NA, NA, 0, 0, 3.5586), day_237 = c(NA, > NA, 0, 0, 0), day_238 = c(NA, NA, 0, 0, 0), day_239 = c(NA, > NA, 10.23192, 0, 0), day_240 = c(NA, NA, 0, 0, 0), day_241 = c(NA, > NA, 0, 0, 0), day_242 = c(NA, NA, 0, 0, 0), day_243 = c(NA, > NA, 0, 0, 0), day_244 = c(NA, NA, 0, 0, 0), day_245 = c(NA, > NA, 0, 0, 0), day_246 = c(NA, NA, 0, 0, 0), day_247 = c(NA, > NA, 0, 0, 0), day_248 = c(NA, NA, 0, 0, 0), day_249 = c(NA, > NA, 0.50544, 0, 0), day_250 = c(NA, NA, 0.12636, 0, 0), day_251 = c(NA, > NA, 7.02432, 0, 5.39784), day_252 = c(NA, NA, 3.33828, 8.00064, > 7.08372), day_253 = c(NA, NA, 0, 0, 0), day_254 = c(NA, NA, > 0, 0, 0), day_255 = c(NA, NA, 2.5704, 4.71636, 11.99772), > day_256 = c(NA, NA, 0.3672, 0.75384, 0), day_257 = c(NA, > NA, 0, 0, 0), day_258 = c(NA, NA, 0.50328, 0, 0), day_259 = c(NA, > NA, 6.78888, 0, 0), day_260 = c(NA, NA, 0.96984, 0, 0), day_261 = c(NA, > NA, 4.62672, 0, 0), day_262 = c(NA, NA, 0, 0, 0), day_263 = c(NA, > NA, 3.16224, 0.27864, 0), day_264 = c(NA, NA, 0, 1.31112, > 0), day_265 = c(NA, NA, 0.37692, 0, 0), day_266 = c(NA, NA, > 0, 0, 0), day_267 = c(NA, NA, 0.70524, 0.43524, 0), day_268 = c(NA, > NA, 0.18792, 0.12744, 0), day_269 = c(NA, NA, 0, 1.79064, > 0.96012), day_270 = c(NA, NA, 0, 0, 0.58644), day_271 = c(NA, > NA, 4.4982, 0, 0), day_272 = c(NA, NA, 0, 0, 0), day_273 = c(NA, > NA, 2.04552, 6.56964, 0), day_274 = c(NA, NA, 0.71712, 0.93852, > 0), day_275 = c(NA, NA, 0, 0, 0), day_276 = c(NA, NA, 0, > 0, 0), day_277 = c(NA, NA, 3.31452, 0, 0), day_278 = c(NA, > NA, 1.20204, 0, 0), day_279 = c(NA, NA, 0, 0, 0), day_280 = c(NA, > NA, 0, 0, 0), day_281 = c(NA, NA, 0, 0, 0), day_282 = c(NA, > NA, 17.955, 5.7942, 9.93816), day_283 = c(NA, NA, 4.79304, > 4.8006, 0), day_284 = c(NA, NA, 3.9366, 0.78084, 0), day_285 = c(NA, > NA, 0, 0, 0), day_286 = c(NA, NA, 0, 0, 0), day_287 = c(NA, > NA, 0, 0, 0), day_288 = c(NA, NA, 0, 0, 0), day_289 = c(NA, > NA, 0, 0, 0), day_290 = c(NA, NA, 0, 0, 0), day_291 = c(NA, > NA, 0, 0, 0), day_292 = c(NA, NA, 0, 0, 0), day_293 = c(NA, > NA, 1.55736, 0, 0), day_294 = c(NA, NA, 4.28328, 0, 0), day_295 = c(NA, > NA, 0, 0, 0), day_296 = c(NA, NA, 0, 0, 0), day_297 = c(NA, > NA, 1.6362, 0, 0), day_298 = c(NA, NA, 1.28844, 0, 6.14088 > ), day_299 = c(NA, NA, 0, 0, 0.50112), day_300 = c(NA, NA, > 0, 0, 0), day_301 = c(NA, NA, 0, 0.13824, 0.03456), day_302 = c(NA, > NA, 0, 2.92572, 9.24264), day_303 = c(NA, NA, 2.8188, 0.41796, > 0), day_304 = c(NA, NA, 2.04876, 11.28384, 0), day_305 = c(NA, > NA, 0, 0.3564, 0), day_306 = c(NA, NA, 0, 0, 0), day_307 = c(NA, > NA, 0, 2.36736, 0), day_308 = c(NA, NA, 0, 0, 0), day_309 = c(NA, > NA, 34.91856, 20.42604, 0), day_310 = c(NA, NA, 0, 0, 0), > day_311 = c(NA, NA, 0, 0, 0), day_312 = c(NA, NA, 0, 0.40392, > 0), day_313 = c(NA, NA, 0, 0.5292, 0), day_314 = c(NA, NA, > 0, 0, 5.21424), day_315 = c(NA, NA, 0, 0, 0), day_316 = c(NA, > NA, 0, 0, 0.4266), day_317 = c(NA, NA, 0, 0, 0), day_318 = c(NA, > NA, 0, 0, 0), day_319 = c(NA, NA, 0, 0, 0), day_320 = c(NA, > NA, 0.23436, 0.6048, 14.9256), day_321 = c(NA, NA, 0, 0.10908, > 0), day_322 = c(NA, NA, 7.68096, 6.66036, 4.53924), day_323 = c(NA, > NA, 1.09728, 1.59732, 8.51148), day_324 = c(NA, NA, 0, 0, > 0), day_325 = c(NA, NA, 1.46016, 0, 0), day_326 = c(NA, NA, > 0, 0, 8.70048), day_327 = c(NA, NA, 0, 0, 0), day_328 = c(NA, > NA, 0, 0, 0), day_329 = c(NA, NA, 0, 0, 0), day_330 = c(NA, > NA, 5.3082, 0, 0), day_331 = c(NA, NA, 2.5866, 0, 0), day_332 = c(NA, > NA, 8.03628, 6.3666, 4.3308), day_333 = c(NA, NA, 0, 0, 0 > ), day_334 = c(NA, NA, 0, 0, 0), day_335 = c(NA, NA, 0, 0, > 0), day_336 = c(NA, NA, 0, 0, 5.29632), day_337 = c(NA, NA, > 0, 1.77444, 2.7216), day_338 = c(NA, NA, 0.40608, 0, 0.83052 > ), day_339 = c(NA, NA, 0, 0, 0), day_340 = c(NA, NA, 0, 0, > 0), day_341 = c(NA, NA, 0, 0, 0), day_342 = c(NA, NA, 0, > 0, 0), day_343 = c(NA, NA, 0, 0, 0), day_344 = c(NA, NA, > 7.73388, 0, 0), day_345 = c(NA, NA, 4.80384, 0, 0), day_346 = c(NA, > NA, 4.374, 0.09288, 0), day_347 = c(NA, NA, 6.42924, 3.2022, > 0), day_348 = c(NA, NA, 0, 16.27668, 0), day_349 = c(NA, > NA, 0, 0.90072, 9.36684), day_350 = c(NA, NA, 0.135, 1.87272, > 2.49048), day_351 = c(NA, NA, 0, 0, 0), day_352 = c(NA, NA, > 0, 0, 0), day_353 = c(NA, NA, 0, 0, 0), day_354 = c(NA, NA, > 0, 0, 0), day_355 = c(NA, NA, 0, 0, 0), day_356 = c(NA, NA, > 0, 0, 0), day_357 = c(NA, NA, 2.82636, 39.45348, 26.08848 > ), day_358 = c(NA, NA, 0, 0, 22.8582), day_359 = c(NA, NA, > 0, 0, 1.34028), day_360 = c(NA, NA, 30.03804, 0, 3.49704), > day_361 = c(NA, NA, 0.13392, 4.941, 4.94424), day_362 = c(NA, > NA, 0.92016, 0, 0.70632), day_363 = c(NA, NA, 0, 0, 0), day_364 = c(NA, > NA, 0, 0, 0), day_365 = c(NA, NA, 0, 0, 0), day_366 = c(NA, > NA, 21.42072, 0, 0)), .Names = c("ISO3", "lon", "lat", "day_1", "day_2", > "day_3", "day_4", "day_5", "day_6", "day_7", "day_8", "day_9", "day_10", > "day_11", "day_12", "day_13", "day_14", "day_15", "day_16", "day_17", > "day_18", "day_19", "day_20", "day_21", "day_22", "day_23", "day_24", > "day_25", "day_26", "day_27", "day_28", "day_29", "day_30", "day_31", > "day_32", "day_33", "day_34", "day_35", "day_36", "day_37", "day_38", > "day_39", "day_40", "day_41", "day_42", "day_43", "day_44", "day_45", > "day_46", "day_47", "day_48", "day_49", "day_50", "day_51", "day_52", > "day_53", "day_54", "day_55", "day_56", "day_57", "day_58", "day_59", > "day_60", "day_61", "day_62", "day_63", "day_64", "day_65", "day_66", > "day_67", "day_68", "day_69", "day_70", "day_71", "day_72", "day_73", > "day_74", "day_75", "day_76", "day_77", "day_78", "day_79", "day_80", > "day_81", "day_82", "day_83", "day_84", "day_85", "day_86", "day_87", > "day_88", "day_89", "day_90", "day_91", "day_92", "day_93", "day_94", > "day_95", "day_96", "day_97", "day_98", "day_99", "day_100", "day_101", > "day_102", "day_103", "day_104", "day_105", "day_106", "day_107", > "day_108", "day_109", "day_110", "day_111", "day_112", "day_113", > "day_114", "day_115", "day_116", "day_117", "day_118", "day_119", > "day_120", "day_121", "day_122", "day_123", "day_124", "day_125", > "day_126", "day_127", "day_128", "day_129", "day_130", "day_131", > "day_132", "day_133", "day_134", "day_135", "day_136", "day_137", > "day_138", "day_139", "day_140", "day_141", "day_142", "day_143", > "day_144", "day_145", "day_146", "day_147", "day_148", "day_149", > "day_150", "day_151", "day_152", "day_153", "day_154", "day_155", > "day_156", "day_157", "day_158", "day_159", "day_160", "day_161", > "day_162", "day_163", "day_164", "day_165", "day_166", "day_167", > "day_168", "day_169", "day_170", "day_171", "day_172", "day_173", > "day_174", "day_175", "day_176", "day_177", "day_178", "day_179", > "day_180", "day_181", "day_182", "day_183", "day_184", "day_185", > "day_186", "day_187", "day_188", "day_189", "day_190", "day_191", > "day_192", "day_193", "day_194", "day_195", "day_196", "day_197", > "day_198", "day_199", "day_200", "day_201", "day_202", "day_203", > "day_204", "day_205", "day_206", "day_207", "day_208", "day_209", > "day_210", "day_211", "day_212", "day_213", "day_214", "day_215", > "day_216", "day_217", "day_218", "day_219", "day_220", "day_221", > "day_222", "day_223", "day_224", "day_225", "day_226", "day_227", > "day_228", "day_229", "day_230", "day_231", "day_232", "day_233", > "day_234", "day_235", "day_236", "day_237", "day_238", "day_239", > "day_240", "day_241", "day_242", "day_243", "day_244", "day_245", > "day_246", "day_247", "day_248", "day_249", "day_250", "day_251", > "day_252", "day_253", "day_254", "day_255", "day_256", "day_257", > "day_258", "day_259", "day_260", "day_261", "day_262", "day_263", > "day_264", "day_265", "day_266", "day_267", "day_268", "day_269", > "day_270", "day_271", "day_272", "day_273", "day_274", "day_275", > "day_276", "day_277", "day_278", "day_279", "day_280", "day_281", > "day_282", "day_283", "day_284", "day_285", "day_286", "day_287", > "day_288", "day_289", "day_290", "day_291", "day_292", "day_293", > "day_294", "day_295", "day_296", "day_297", "day_298", "day_299", > "day_300", "day_301", "day_302", "day_303", "day_304", "day_305", > "day_306", "day_307", "day_308", "day_309", "day_310", "day_311", > "day_312", "day_313", "day_314", "day_315", "day_316", "day_317", > "day_318", "day_319", "day_320", "day_321", "day_322", "day_323", > "day_324", "day_325", "day_326", "day_327", "day_328", "day_329", > "day_330", "day_331", "day_332", "day_333", "day_334", "day_335", > "day_336", "day_337", "day_338", "day_339", "day_340", "day_341", > "day_342", "day_343", "day_344", "day_345", "day_346", "day_347", > "day_348", "day_349", "day_350", "day_351", "day_352", "day_353", > "day_354", "day_355", "day_356", "day_357", "day_358", "day_359", > "day_360", "day_361", "day_362", "day_363", "day_364", "day_365", > "day_366"), row.names = c(NA, 5L), class > "data.frame") > > [[alternative HTML version deleted]] > > ______________________________________________ > R-help at 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.________________________________ Tento e-mail a jak?koliv k n?mu p?ipojen? dokumenty jsou d?v?rn? a jsou ur?eny pouze jeho adres?t?m. Jestli?e jste obdr?el(a) tento e-mail omylem, informujte laskav? neprodlen? jeho odes?latele. Obsah tohoto emailu i s p??lohami a jeho kopie vyma?te ze sv?ho syst?mu. Nejste-li zam??len?m adres?tem tohoto emailu, nejste opr?vn?ni tento email jakkoliv u??vat, roz?i?ovat, kop?rovat ?i zve?ej?ovat. Odes?latel e-mailu neodpov?d? za eventu?ln? ?kodu zp?sobenou modifikacemi ?i zpo?d?n?m p?enosu e-mailu. V p??pad?, ?e je tento e-mail sou??st? obchodn?ho jedn?n?: - vyhrazuje si odes?latel pr?vo ukon?it kdykoliv jedn?n? o uzav?en? smlouvy, a to z jak?hokoliv d?vodu i bez uveden? d?vodu. - a obsahuje-li nab?dku, je adres?t opr?vn?n nab?dku bezodkladn? p?ijmout; Odes?latel tohoto e-mailu (nab?dky) vylu?uje p?ijet? nab?dky ze strany p??jemce s dodatkem ?i odchylkou. - trv? odes?latel na tom, ?e p??slu?n? smlouva je uzav?ena teprve v?slovn?m dosa?en?m shody na v?ech jej?ch n?le?itostech. - odes?latel tohoto emailu informuje, ?e nen? opr?vn?n uzav?rat za spole?nost ??dn? smlouvy s v?jimkou p??pad?, kdy k tomu byl p?semn? zmocn?n nebo p?semn? pov??en a takov? pov??en? nebo pln? moc byly adres?tovi tohoto emailu p??padn? osob?, kterou adres?t zastupuje, p?edlo?eny nebo jejich existence je adres?tovi ?i osob? j?m zastoupen? zn?m?. This e-mail and any documents attached to it may be confidential and are intended only for its intended recipients. If you received this e-mail by mistake, please immediately inform its sender. Delete the contents of this e-mail with all attachments and its copies from your system. If you are not the intended recipient of this e-mail, you are not authorized to use, disseminate, copy or disclose this e-mail in any manner. The sender of this e-mail shall not be liable for any possible damage caused by modifications of the e-mail or by delay with transfer of the email. In case that this e-mail forms part of business dealings: - the sender reserves the right to end negotiations about entering into a contract in any time, for any reason, and without stating any reasoning. - if the e-mail contains an offer, the recipient is entitled to immediately accept such offer; The sender of this e-mail (offer) excludes any acceptance of the offer on the part of the recipient containing any amendment or variation. - the sender insists on that the respective contract is concluded only upon an express mutual agreement on all its aspects. - the sender of this e-mail informs that he/she is not authorized to enter into any contracts on behalf of the company except for cases in which he/she is expressly authorized to do so in writing, and such authorization or power of attorney is submitted to the recipient or the person represented by the recipient, or the existence of such authorization is known to the recipient of the person represented by the recipient.
Dear Petr, Thank you for the code, apologies though as I copied the wrong data, This is precipitation data and not temperature. For the loop, could I do something like this? filelist <- list.files(pattern=".csv") myDTs <- lapply(filelist, function(.file) { apply(temp[,-(1:3)],1, mean, na.rm=T) } Thanks again! Sincerely, Milu On Fri, Nov 18, 2016 at 2:46 PM, PIKAL Petr <petr.pikal at precheza.cz> wrote:> Hi > > I am not completely sure what you want to do but > > > apply(temp[,-(1:3)],1, mean, na.rm=T) > 1 2 3 4 5 > NaN NaN 2.159516 1.519914 1.514007 > > apply(temp[,-(1:3)],1, max, na.rm=T) > 1 2 3 4 5 > -Inf -Inf 57.36528 39.45348 45.23904 > Warning messages: > 1: In FUN(newX[, i], ...) : > no non-missing arguments to max; returning -Inf > 2: In FUN(newX[, i], ...) : > no non-missing arguments to max; returning -Inf > > apply(temp[,-(1:3)],1, min, na.rm=T) > 1 2 3 4 5 > Inf Inf 0 0 0 > > gives you mentioned summary for each row. If you have duplicate rows you > shall first aggregate them. However, it seems to me that your data are not > correct. It is quite strange that for given lat/lon you have one day value > 23 and the next day 0. > > temp[1:5, 1:10] > ISO3 lon lat day_1 day_2 day_3 day_4 day_5 day_6 day_7 > 1 CHL -69 -55 NA NA NA NA NA NA NA > 2 CHL -68 -55 NA NA NA NA NA NA NA > 3 CHL -72 -54 0 0 0.00000 0 0 0 2.83824 > 4 <NA> -71 -54 0 0 23.37984 0 0 0 11.80116 > 5 CHL -70 -54 0 0 0.00000 0 0 0 1.24956 > > If you want to process all your files you can do it in cycle. The function > > list.files() > > can be handy for that task. > > Cheers > Petr > > > -----Original Message----- > > From: R-help [mailto:r-help-bounces at r-project.org] On Behalf Of Miluji > Sb > > Sent: Friday, November 18, 2016 1:49 PM > > To: r-help mailing list <r-help at r-project.org> > > Subject: [R] Melt and compute Max, Mean, Min > > > > Dear all, > > > > I have 51 years of data (1960 - 2010) in csv format, where each file > represents > > one year of data. Below is what each file looks like. > > > > These are temperature data by coordinates, my goal is to to compute max, > > min, and mean by year for each of the coordinates and construct a panel > > dataset. Any help will be appreciated, thank you! > > > > Sincerely, > > > > Milu > > > > temp <- dput(head(df,5)) > > structure(list(ISO3 = structure(c(28L, 28L, 28L, NA, 28L), .Label > c("AFG", > > "AGO", "ALB", "ARE", "ARG", "ARM", "AUS", "AUT", "AZE", "BDI", "BEL", > > "BEN", "BFA", "BGD", "BGR", "BHS", "BIH", "BLR", "BLZ", "BOL", "BRA", > > "BRN", "BTN", "BWA", "CAF", "CAN", "CHE", "CHL", "CHN", "CIV", "CMR", > > "COD", "COG", "COL", "CRI", "CUB", "CYP", "CZE", "DEU", "DJI", "DNK", > > "DOM", "DZA", "ECU", "EGY", "ERI", "ESH", "ESP", "EST", "ETH", "FIN", > "FJI", > > "FLK", "FRA", "GAB", "GBR", "GEO", "GHA", "GIN", "GNB", "GNQ", "GRC", > > "GRL", "GTM", "GUF", "GUY", "HND", "HRV", "HTI", "HUN", "IDN", "IND", > > "IRL", "IRN", "IRQ", "ISL", "ISR", "ITA", "JAM", "JOR", "JPN", "KAZ", > "KEN", > > "KGZ", "KHM", "KIR", "KOR", "KWT", "LAO", "LBN", "LBR", "LBY", "LCA", > > "LKA", "LSO", "LTU", "LUX", "LVA", "MAR", "MDA", "MDG", "MEX", "MKD", > > "MLI", "MMR", "MNE", "MNG", "MOZ", "MRT", "MWI", "MYS", "NAM", > > "NCL", "NER", "NGA", "NIC", "NLD", "NOR", "NPL", "NZL", "OMN", "PAK", > > "PAN", "PER", "PHL", "PNG", "POL", "PRI", "PRK", "PRT", "PRY", "QAT", > > "ROU", "RUS", "RWA", "SAU", "SDN", "SEN", "SJM", "SLB", "SLE", "SLV", > > "SOM", "SRB", "SUR", "SVK", "SVN", "SWE", "SWZ", "SYR", "TCD", "TGO", > > "THA", "TJK", "TKM", "TLS", "TUN", "TUR", "TWN", "TZA", "UGA", "UKR", > > "URY", "USA", "UZB", "VEN", "VNM", "VUT", "YEM", "ZAF", "ZMB", "ZWE" > > ), class = "factor"), lon = c(-69L, -68L, -72L, -71L, -70L), > > lat = c(-55L, -55L, -54L, -54L, -54L), day_1 = c(NA, NA, > > 0, 0, 0), day_2 = c(NA, NA, 0, 0, 0), day_3 = c(NA, NA, 0, > > 23.37984, 0), day_4 = c(NA, NA, 0, 0, 0), day_5 = c(NA, NA, > > 0, 0, 0), day_6 = c(NA, NA, 0, 0, 0), day_7 = c(NA, NA, 2.83824, > > 11.80116, 1.24956), day_8 = c(NA, NA, 0, 1.68588, 14.69448 > > ), day_9 = c(NA, NA, 0, 0, 1.09296), day_10 = c(NA, NA, 0, > > 0, 0), day_11 = c(NA, NA, 3.78, 3.7422, 0), day_12 = c(NA, > > NA, 0.54, 0, 0), day_13 = c(NA, NA, 0, 0, 0), day_14 = c(NA, > > NA, 0, 0, 0.39204), day_15 = c(NA, NA, 0, 0, 11.58732), day_16 > c(NA, > > NA, 0, 0, 0), day_17 = c(NA, NA, 0, 1.14048, 12.26448), day_18 > c(NA, > > NA, 0, 1.1934, 7.59024), day_19 = c(NA, NA, 9.74268, 0, 0 > > ), day_20 = c(NA, NA, 0, 0, 0), day_21 = c(NA, NA, 1.96776, > > 0, 0), day_22 = c(NA, NA, 0, 0, 0), day_23 = c(NA, NA, 0, > > 0, 0), day_24 = c(NA, NA, 6.21756, 2.74752, 0), day_25 = c(NA, > > NA, 0, 0, 3.37932), day_26 = c(NA, NA, 4.8384, 0, 0), day_27 = c(NA, > > NA, 0, 0, 0), day_28 = c(NA, NA, 0, 0, 0), day_29 = c(NA, > > NA, 22.37328, 0, 0), day_30 = c(NA, NA, 28.97424, 11.25468, > > 0), day_31 = c(NA, NA, 0, 0, 0), day_32 = c(NA, NA, 0, 0, > > 2.00448), day_33 = c(NA, NA, 0, 0, 0), day_34 = c(NA, NA, > > 0, 0, 0), day_35 = c(NA, NA, 0, 0, 0), day_36 = c(NA, NA, > > 0, 0, 0), day_37 = c(NA, NA, 0, 0, 0), day_38 = c(NA, NA, > > 32.7132, 31.71852, 0), day_39 = c(NA, NA, 0, 0, 5.84604), > > day_40 = c(NA, NA, 0, 0, 0), day_41 = c(NA, NA, 0, 0, 0), > > day_42 = c(NA, NA, 0, 0, 0), day_43 = c(NA, NA, 0, 0, 0), > > day_44 = c(NA, NA, 0, 0, 1.78416), day_45 = c(NA, NA, 0, > > 0, 0), day_46 = c(NA, NA, 33.84504, 0, 0), day_47 = c(NA, > > NA, 0, 0, 0), day_48 = c(NA, NA, 0, 0, 0), day_49 = c(NA, > > NA, 0, 0, 0), day_50 = c(NA, NA, 0, 0.4752, 0), day_51 = c(NA, > > NA, 0, 0, 22.02012), day_52 = c(NA, NA, 0, 0, 0), day_53 = c(NA, > > NA, 0, 0, 3.48084), day_54 = c(NA, NA, 0, 0, 0), day_55 = c(NA, > > NA, 0.58212, 0, 0), day_56 = c(NA, NA, 0.35316, 0, 0), day_57 = c(NA, > > NA, 0, 0, 12.65436), day_58 = c(NA, NA, 0, 0, 0), day_59 = c(NA, > > NA, 0, 0, 0), day_60 = c(NA, NA, 3.03372, 22.05576, 0), day_61 > c(NA, > > NA, 2.5758, 0, 0), day_62 = c(NA, NA, 0, 0, 0), day_63 = c(NA, > > NA, 3.67416, 25.22016, 4.21524), day_64 = c(NA, NA, 0.52488, > > 3.60288, 0), day_65 = c(NA, NA, 12.82608, 0, 0), day_66 = c(NA, > > NA, 0, 0, 0), day_67 = c(NA, NA, 0, 0, 0), day_68 = c(NA, > > NA, 0, 0, 0), day_69 = c(NA, NA, 0, 0, 0), day_70 = c(NA, > > NA, 1.11564, 5.17536, 0), day_71 = c(NA, NA, 1.18584, 0, > > 0), day_72 = c(NA, NA, 0, 0, 0.10584), day_73 = c(NA, NA, > > 0.62748, 14.39748, 7.50708), day_74 = c(NA, NA, 7.20252, > > 20.02644, 1.07244), day_75 = c(NA, NA, 1.87488, 0, 0), day_76 = c(NA, > > NA, 0.26784, 0, 0), day_77 = c(NA, NA, 0, 0, 0), day_78 = c(NA, > > NA, 0, 0, 2.81664), day_79 = c(NA, NA, 0, 0, 0), day_80 = c(NA, > > NA, 0, 0, 0), day_81 = c(NA, NA, 0, 0, 0), day_82 = c(NA, > > NA, 1.29276, 0, 0), day_83 = c(NA, NA, 0.18468, 0, 1.46124 > > ), day_84 = c(NA, NA, 0, 0, 0), day_85 = c(NA, NA, 0, 0, > > 0), day_86 = c(NA, NA, 57.36528, 0, 0), day_87 = c(NA, NA, > > 8.19504, 0, 0), day_88 = c(NA, NA, 0, 0, 0), day_89 = c(NA, > > NA, 6.45732, 0, 0), day_90 = c(NA, NA, 0, 0, 0), day_91 = c(NA, > > NA, 0, 0, 44.20332), day_92 = c(NA, NA, 0, 0, 6.31476), day_93 > c(NA, > > NA, 0, 0, 0.35748), day_94 = c(NA, NA, 16.74972, 30.35988, > > 5.0436), day_95 = c(NA, NA, 4.93992, 1.46556, 19.86768), > > day_96 = c(NA, NA, 0, 0, 0.88128), day_97 = c(NA, NA, 5.751, > > 19.02096, 0), day_98 = c(NA, NA, 11.5452, 13.37148, 0), day_99 > c(NA, > > NA, 0, 0, 0), day_100 = c(NA, NA, 0, 0, 0), day_101 = c(NA, > > NA, 4.70124, 23.80644, 7.61832), day_102 = c(NA, NA, 0, 1.02492, > > 0), day_103 = c(NA, NA, 0, 0, 15.86304), day_104 = c(NA, > > NA, 0, 0, 0.26352), day_105 = c(NA, NA, 0, 0, 21.60864), > > day_106 = c(NA, NA, 56.93436, 0, 0.22464), day_107 = c(NA, > > NA, 8.13348, 0, 0), day_108 = c(NA, NA, 6.83748, 0, 0), day_109 > c(NA, > > NA, 0, 0, 0), day_110 = c(NA, NA, 14.36724, 0, 0), day_111 = c(NA, > > NA, 0.63936, 2.43864, 4.0554), day_112 = c(NA, NA, 1.21392, > > 1.15452, 0), day_113 = c(NA, NA, 0.7722, 0, 0), day_114 = c(NA, > > NA, 0, 0, 1.08864), day_115 = c(NA, NA, 1.47528, 0, 0), day_116 > c(NA, > > NA, 0, 1.73124, 0), day_117 = c(NA, NA, 0, 0, 0), day_118 = c(NA, > > NA, 2.4516, 0, 0), day_119 = c(NA, NA, 0, 3.14388, 0), day_120 > c(NA, > > NA, 1.81872, 0, 0), day_121 = c(NA, NA, 2.77236, 0, 0), day_122 > c(NA, > > NA, 1.34028, 0.70632, 0), day_123 = c(NA, NA, 0, 0, 0), day_124 > c(NA, > > NA, 0, 0, 0), day_125 = c(NA, NA, 0.56484, 0.74412, 0), day_126 > c(NA, > > NA, 1.11888, 0.06264, 0), day_127 = c(NA, NA, 0, 0, 0), day_128 > c(NA, > > NA, 1.05624, 0, 0), day_129 = c(NA, NA, 26.63928, 34.04268, > > 0), day_130 = c(NA, NA, 6.89796, 0, 0), day_131 = c(NA, NA, > > 1.91592, 2.241, 0), day_132 = c(NA, NA, 0, 2.23668, 45.23904 > > ), day_133 = c(NA, NA, 0, 0, 6.46272), day_134 = c(NA, NA, > > 0, 0, 0), day_135 = c(NA, NA, 0, 0, 0), day_136 = c(NA, NA, > > 0, 0, 0), day_137 = c(NA, NA, 0, 0, 0), day_138 = c(NA, NA, > > 0, 0, 0), day_139 = c(NA, NA, 0, 0, 0), day_140 = c(NA, NA, > > 0, 0, 0), day_141 = c(NA, NA, 0, 0, 0), day_142 = c(NA, NA, > > 0, 0, 0), day_143 = c(NA, NA, 0, 0, 0), day_144 = c(NA, NA, > > 2.943, 5.17536, 0), day_145 = c(NA, NA, 0, 0, 0), day_146 = c(NA, > > NA, 0, 0, 0), day_147 = c(NA, NA, 0, 0, 0), day_148 = c(NA, > > NA, 10.96308, 2.98188, 0), day_149 = c(NA, NA, 20.4822, 0.43632, > > 0), day_150 = c(NA, NA, 1.5282, 0, 0), day_151 = c(NA, NA, > > 0, 0, 0), day_152 = c(NA, NA, 0, 0, 0), day_153 = c(NA, NA, > > 0, 0, 0), day_154 = c(NA, NA, 0, 0, 0), day_155 = c(NA, NA, > > 0, 0, 0), day_156 = c(NA, NA, 0, 0, 0), day_157 = c(NA, NA, > > 0, 0, 0), day_158 = c(NA, NA, 0, 0, 0), day_159 = c(NA, NA, > > 0, 0, 0), day_160 = c(NA, NA, 0, 0, 0), day_161 = c(NA, NA, > > 0, 0, 0), day_162 = c(NA, NA, 0, 0, 0), day_163 = c(NA, NA, > > 0, 26.3412, 4.07376), day_164 = c(NA, NA, 0, 4.28328, 3.03156 > > ), day_165 = c(NA, NA, 0, 0, 0), day_166 = c(NA, NA, 0, 0, > > 4.60404), day_167 = c(NA, NA, 0, 0, 0.70848), day_168 = c(NA, > > NA, 0, 0, 0), day_169 = c(NA, NA, 0, 0, 0), day_170 = c(NA, > > NA, 0, 0, 0), day_171 = c(NA, NA, 0, 0, 0), day_172 = c(NA, > > NA, 0, 0, 0), day_173 = c(NA, NA, 0, 0, 3.7854), day_174 = c(NA, > > NA, 0, 0, 0), day_175 = c(NA, NA, 0, 0, 0), day_176 = c(NA, > > NA, 0, 0, 0), day_177 = c(NA, NA, 0, 0, 0), day_178 = c(NA, > > NA, 0, 0, 0), day_179 = c(NA, NA, 0, 0, 0), day_180 = c(NA, > > NA, 0, 0, 0), day_181 = c(NA, NA, 0, 0, 0), day_182 = c(NA, > > NA, 0, 0, 0), day_183 = c(NA, NA, 0, 0, 0), day_184 = c(NA, > > NA, 0, 0, 0), day_185 = c(NA, NA, 0, 0, 0), day_186 = c(NA, > > NA, 0, 0, 0), day_187 = c(NA, NA, 7.30728, 4.1202, 0), day_188 > c(NA, > > NA, 2.56608, 0.5886, 0), day_189 = c(NA, NA, 0, 0, 0), day_190 > c(NA, > > NA, 21.93156, 8.0082, 11.4318), day_191 = c(NA, NA, 3.13308, > > 0, 0), day_192 = c(NA, NA, 0, 0, 0.10692), day_193 = c(NA, > > NA, 0, 0, 4.65912), day_194 = c(NA, NA, 0, 0, 0), day_195 = c(NA, > > NA, 0, 0, 0), day_196 = c(NA, NA, 0, 0, 0), day_197 = c(NA, > > NA, 0, 0, 0), day_198 = c(NA, NA, 0, 0, 0), day_199 = c(NA, > > NA, 0, 0, 0), day_200 = c(NA, NA, 0, 0, 0), day_201 = c(NA, > > NA, 0, 0, 0), day_202 = c(NA, NA, 0, 7.77276, 4.6602), day_203 > c(NA, > > NA, 0, 0.86292, 0), day_204 = c(NA, NA, 0, 0, 0), day_205 = c(NA, > > NA, 21.45528, 8.69616, 0), day_206 = c(NA, NA, 0, 0, 0), > > day_207 = c(NA, NA, 0, 0, 0), day_208 = c(NA, NA, 0, 0, 0 > > ), day_209 = c(NA, NA, 0, 0, 0), day_210 = c(NA, NA, 0, 0, > > 0), day_211 = c(NA, NA, 0, 0, 0), day_212 = c(NA, NA, 0, > > 0, 0), day_213 = c(NA, NA, 0, 0, 0), day_214 = c(NA, NA, > > 0, 0, 0), day_215 = c(NA, NA, 0, 0, 0), day_216 = c(NA, NA, > > 0, 0, 0), day_217 = c(NA, NA, 0, 0, 0), day_218 = c(NA, NA, > > 0, 0, 0), day_219 = c(NA, NA, 0, 0, 0), day_220 = c(NA, NA, > > 6.10092, 10.85508, 13.22244), day_221 = c(NA, NA, 0.87156, > > 0, 0), day_222 = c(NA, NA, 0, 0, 15.46452), day_223 = c(NA, > > NA, 0, 0, 9.83664), day_224 = c(NA, NA, 0, 0, 0), day_225 = c(NA, > > NA, 0, 0, 0), day_226 = c(NA, NA, 16.46028, 0, 0), day_227 = c(NA, > > NA, 0, 0, 0), day_228 = c(NA, NA, 0, 0, 0), day_229 = c(NA, > > NA, 0, 0, 0), day_230 = c(NA, NA, 0, 0, 0), day_231 = c(NA, > > NA, 2.7108, 0, 0), day_232 = c(NA, NA, 0, 0, 0), day_233 = c(NA, > > NA, 0, 0, 0), day_234 = c(NA, NA, 0, 0, 0), day_235 = c(NA, > > NA, 0, 0, 0), day_236 = c(NA, NA, 0, 0, 3.5586), day_237 = c(NA, > > NA, 0, 0, 0), day_238 = c(NA, NA, 0, 0, 0), day_239 = c(NA, > > NA, 10.23192, 0, 0), day_240 = c(NA, NA, 0, 0, 0), day_241 = c(NA, > > NA, 0, 0, 0), day_242 = c(NA, NA, 0, 0, 0), day_243 = c(NA, > > NA, 0, 0, 0), day_244 = c(NA, NA, 0, 0, 0), day_245 = c(NA, > > NA, 0, 0, 0), day_246 = c(NA, NA, 0, 0, 0), day_247 = c(NA, > > NA, 0, 0, 0), day_248 = c(NA, NA, 0, 0, 0), day_249 = c(NA, > > NA, 0.50544, 0, 0), day_250 = c(NA, NA, 0.12636, 0, 0), day_251 > c(NA, > > NA, 7.02432, 0, 5.39784), day_252 = c(NA, NA, 3.33828, 8.00064, > > 7.08372), day_253 = c(NA, NA, 0, 0, 0), day_254 = c(NA, NA, > > 0, 0, 0), day_255 = c(NA, NA, 2.5704, 4.71636, 11.99772), > > day_256 = c(NA, NA, 0.3672, 0.75384, 0), day_257 = c(NA, > > NA, 0, 0, 0), day_258 = c(NA, NA, 0.50328, 0, 0), day_259 = c(NA, > > NA, 6.78888, 0, 0), day_260 = c(NA, NA, 0.96984, 0, 0), day_261 > c(NA, > > NA, 4.62672, 0, 0), day_262 = c(NA, NA, 0, 0, 0), day_263 = c(NA, > > NA, 3.16224, 0.27864, 0), day_264 = c(NA, NA, 0, 1.31112, > > 0), day_265 = c(NA, NA, 0.37692, 0, 0), day_266 = c(NA, NA, > > 0, 0, 0), day_267 = c(NA, NA, 0.70524, 0.43524, 0), day_268 = c(NA, > > NA, 0.18792, 0.12744, 0), day_269 = c(NA, NA, 0, 1.79064, > > 0.96012), day_270 = c(NA, NA, 0, 0, 0.58644), day_271 = c(NA, > > NA, 4.4982, 0, 0), day_272 = c(NA, NA, 0, 0, 0), day_273 = c(NA, > > NA, 2.04552, 6.56964, 0), day_274 = c(NA, NA, 0.71712, 0.93852, > > 0), day_275 = c(NA, NA, 0, 0, 0), day_276 = c(NA, NA, 0, > > 0, 0), day_277 = c(NA, NA, 3.31452, 0, 0), day_278 = c(NA, > > NA, 1.20204, 0, 0), day_279 = c(NA, NA, 0, 0, 0), day_280 = c(NA, > > NA, 0, 0, 0), day_281 = c(NA, NA, 0, 0, 0), day_282 = c(NA, > > NA, 17.955, 5.7942, 9.93816), day_283 = c(NA, NA, 4.79304, > > 4.8006, 0), day_284 = c(NA, NA, 3.9366, 0.78084, 0), day_285 = c(NA, > > NA, 0, 0, 0), day_286 = c(NA, NA, 0, 0, 0), day_287 = c(NA, > > NA, 0, 0, 0), day_288 = c(NA, NA, 0, 0, 0), day_289 = c(NA, > > NA, 0, 0, 0), day_290 = c(NA, NA, 0, 0, 0), day_291 = c(NA, > > NA, 0, 0, 0), day_292 = c(NA, NA, 0, 0, 0), day_293 = c(NA, > > NA, 1.55736, 0, 0), day_294 = c(NA, NA, 4.28328, 0, 0), day_295 > c(NA, > > NA, 0, 0, 0), day_296 = c(NA, NA, 0, 0, 0), day_297 = c(NA, > > NA, 1.6362, 0, 0), day_298 = c(NA, NA, 1.28844, 0, 6.14088 > > ), day_299 = c(NA, NA, 0, 0, 0.50112), day_300 = c(NA, NA, > > 0, 0, 0), day_301 = c(NA, NA, 0, 0.13824, 0.03456), day_302 = c(NA, > > NA, 0, 2.92572, 9.24264), day_303 = c(NA, NA, 2.8188, 0.41796, > > 0), day_304 = c(NA, NA, 2.04876, 11.28384, 0), day_305 = c(NA, > > NA, 0, 0.3564, 0), day_306 = c(NA, NA, 0, 0, 0), day_307 = c(NA, > > NA, 0, 2.36736, 0), day_308 = c(NA, NA, 0, 0, 0), day_309 = c(NA, > > NA, 34.91856, 20.42604, 0), day_310 = c(NA, NA, 0, 0, 0), > > day_311 = c(NA, NA, 0, 0, 0), day_312 = c(NA, NA, 0, 0.40392, > > 0), day_313 = c(NA, NA, 0, 0.5292, 0), day_314 = c(NA, NA, > > 0, 0, 5.21424), day_315 = c(NA, NA, 0, 0, 0), day_316 = c(NA, > > NA, 0, 0, 0.4266), day_317 = c(NA, NA, 0, 0, 0), day_318 = c(NA, > > NA, 0, 0, 0), day_319 = c(NA, NA, 0, 0, 0), day_320 = c(NA, > > NA, 0.23436, 0.6048, 14.9256), day_321 = c(NA, NA, 0, 0.10908, > > 0), day_322 = c(NA, NA, 7.68096, 6.66036, 4.53924), day_323 = c(NA, > > NA, 1.09728, 1.59732, 8.51148), day_324 = c(NA, NA, 0, 0, > > 0), day_325 = c(NA, NA, 1.46016, 0, 0), day_326 = c(NA, NA, > > 0, 0, 8.70048), day_327 = c(NA, NA, 0, 0, 0), day_328 = c(NA, > > NA, 0, 0, 0), day_329 = c(NA, NA, 0, 0, 0), day_330 = c(NA, > > NA, 5.3082, 0, 0), day_331 = c(NA, NA, 2.5866, 0, 0), day_332 = c(NA, > > NA, 8.03628, 6.3666, 4.3308), day_333 = c(NA, NA, 0, 0, 0 > > ), day_334 = c(NA, NA, 0, 0, 0), day_335 = c(NA, NA, 0, 0, > > 0), day_336 = c(NA, NA, 0, 0, 5.29632), day_337 = c(NA, NA, > > 0, 1.77444, 2.7216), day_338 = c(NA, NA, 0.40608, 0, 0.83052 > > ), day_339 = c(NA, NA, 0, 0, 0), day_340 = c(NA, NA, 0, 0, > > 0), day_341 = c(NA, NA, 0, 0, 0), day_342 = c(NA, NA, 0, > > 0, 0), day_343 = c(NA, NA, 0, 0, 0), day_344 = c(NA, NA, > > 7.73388, 0, 0), day_345 = c(NA, NA, 4.80384, 0, 0), day_346 = c(NA, > > NA, 4.374, 0.09288, 0), day_347 = c(NA, NA, 6.42924, 3.2022, > > 0), day_348 = c(NA, NA, 0, 16.27668, 0), day_349 = c(NA, > > NA, 0, 0.90072, 9.36684), day_350 = c(NA, NA, 0.135, 1.87272, > > 2.49048), day_351 = c(NA, NA, 0, 0, 0), day_352 = c(NA, NA, > > 0, 0, 0), day_353 = c(NA, NA, 0, 0, 0), day_354 = c(NA, NA, > > 0, 0, 0), day_355 = c(NA, NA, 0, 0, 0), day_356 = c(NA, NA, > > 0, 0, 0), day_357 = c(NA, NA, 2.82636, 39.45348, 26.08848 > > ), day_358 = c(NA, NA, 0, 0, 22.8582), day_359 = c(NA, NA, > > 0, 0, 1.34028), day_360 = c(NA, NA, 30.03804, 0, 3.49704), > > day_361 = c(NA, NA, 0.13392, 4.941, 4.94424), day_362 = c(NA, > > NA, 0.92016, 0, 0.70632), day_363 = c(NA, NA, 0, 0, 0), day_364 > c(NA, > > NA, 0, 0, 0), day_365 = c(NA, NA, 0, 0, 0), day_366 = c(NA, > > NA, 21.42072, 0, 0)), .Names = c("ISO3", "lon", "lat", "day_1", > "day_2", > > "day_3", "day_4", "day_5", "day_6", "day_7", "day_8", "day_9", "day_10", > > "day_11", "day_12", "day_13", "day_14", "day_15", "day_16", "day_17", > > "day_18", "day_19", "day_20", "day_21", "day_22", "day_23", "day_24", > > "day_25", "day_26", "day_27", "day_28", "day_29", "day_30", "day_31", > > "day_32", "day_33", "day_34", "day_35", "day_36", "day_37", "day_38", > > "day_39", "day_40", "day_41", "day_42", "day_43", "day_44", "day_45", > > "day_46", "day_47", "day_48", "day_49", "day_50", "day_51", "day_52", > > "day_53", "day_54", "day_55", "day_56", "day_57", "day_58", "day_59", > > "day_60", "day_61", "day_62", "day_63", "day_64", "day_65", "day_66", > > "day_67", "day_68", "day_69", "day_70", "day_71", "day_72", "day_73", > > "day_74", "day_75", "day_76", "day_77", "day_78", "day_79", "day_80", > > "day_81", "day_82", "day_83", "day_84", "day_85", "day_86", "day_87", > > "day_88", "day_89", "day_90", "day_91", "day_92", "day_93", "day_94", > > "day_95", "day_96", "day_97", "day_98", "day_99", "day_100", "day_101", > > "day_102", "day_103", "day_104", "day_105", "day_106", "day_107", > > "day_108", "day_109", "day_110", "day_111", "day_112", "day_113", > > "day_114", "day_115", "day_116", "day_117", "day_118", "day_119", > > "day_120", "day_121", "day_122", "day_123", "day_124", "day_125", > > "day_126", "day_127", "day_128", "day_129", "day_130", "day_131", > > "day_132", "day_133", "day_134", "day_135", "day_136", "day_137", > > "day_138", "day_139", "day_140", "day_141", "day_142", "day_143", > > "day_144", "day_145", "day_146", "day_147", "day_148", "day_149", > > "day_150", "day_151", "day_152", "day_153", "day_154", "day_155", > > "day_156", "day_157", "day_158", "day_159", "day_160", "day_161", > > "day_162", "day_163", "day_164", "day_165", "day_166", "day_167", > > "day_168", "day_169", "day_170", "day_171", "day_172", "day_173", > > "day_174", "day_175", "day_176", "day_177", "day_178", "day_179", > > "day_180", "day_181", "day_182", "day_183", "day_184", "day_185", > > "day_186", "day_187", "day_188", "day_189", "day_190", "day_191", > > "day_192", "day_193", "day_194", "day_195", "day_196", "day_197", > > "day_198", "day_199", "day_200", "day_201", "day_202", "day_203", > > "day_204", "day_205", "day_206", "day_207", "day_208", "day_209", > > "day_210", "day_211", "day_212", "day_213", "day_214", "day_215", > > "day_216", "day_217", "day_218", "day_219", "day_220", "day_221", > > "day_222", "day_223", "day_224", "day_225", "day_226", "day_227", > > "day_228", "day_229", "day_230", "day_231", "day_232", "day_233", > > "day_234", "day_235", "day_236", "day_237", "day_238", "day_239", > > "day_240", "day_241", "day_242", "day_243", "day_244", "day_245", > > "day_246", "day_247", "day_248", "day_249", "day_250", "day_251", > > "day_252", "day_253", "day_254", "day_255", "day_256", "day_257", > > "day_258", "day_259", "day_260", "day_261", "day_262", "day_263", > > "day_264", "day_265", "day_266", "day_267", "day_268", "day_269", > > "day_270", "day_271", "day_272", "day_273", "day_274", "day_275", > > "day_276", "day_277", "day_278", "day_279", "day_280", "day_281", > > "day_282", "day_283", "day_284", "day_285", "day_286", "day_287", > > "day_288", "day_289", "day_290", "day_291", "day_292", "day_293", > > "day_294", "day_295", "day_296", "day_297", "day_298", "day_299", > > "day_300", "day_301", "day_302", "day_303", "day_304", "day_305", > > "day_306", "day_307", "day_308", "day_309", "day_310", "day_311", > > "day_312", "day_313", "day_314", "day_315", "day_316", "day_317", > > "day_318", "day_319", "day_320", "day_321", "day_322", "day_323", > > "day_324", "day_325", "day_326", "day_327", "day_328", "day_329", > > "day_330", "day_331", "day_332", "day_333", "day_334", "day_335", > > "day_336", "day_337", "day_338", "day_339", "day_340", "day_341", > > "day_342", "day_343", "day_344", "day_345", "day_346", "day_347", > > "day_348", "day_349", "day_350", "day_351", "day_352", "day_353", > > "day_354", "day_355", "day_356", "day_357", "day_358", "day_359", > > "day_360", "day_361", "day_362", "day_363", "day_364", "day_365", > > "day_366"), row.names = c(NA, 5L), class > > "data.frame") > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help at 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. > > ________________________________ > Tento e-mail a jak?koliv k n?mu p?ipojen? dokumenty jsou d?v?rn? a jsou > ur?eny pouze jeho adres?t?m. > Jestli?e jste obdr?el(a) tento e-mail omylem, informujte laskav? > neprodlen? jeho odes?latele. Obsah tohoto emailu i s p??lohami a jeho kopie > vyma?te ze sv?ho syst?mu. > Nejste-li zam??len?m adres?tem tohoto emailu, nejste opr?vn?ni tento email > jakkoliv u??vat, roz?i?ovat, kop?rovat ?i zve?ej?ovat. > Odes?latel e-mailu neodpov?d? za eventu?ln? ?kodu zp?sobenou modifikacemi > ?i zpo?d?n?m p?enosu e-mailu. > > V p??pad?, ?e je tento e-mail sou??st? obchodn?ho jedn?n?: > - vyhrazuje si odes?latel pr?vo ukon?it kdykoliv jedn?n? o uzav?en? > smlouvy, a to z jak?hokoliv d?vodu i bez uveden? d?vodu. > - a obsahuje-li nab?dku, je adres?t opr?vn?n nab?dku bezodkladn? p?ijmout; > Odes?latel tohoto e-mailu (nab?dky) vylu?uje p?ijet? nab?dky ze strany > p??jemce s dodatkem ?i odchylkou. > - trv? odes?latel na tom, ?e p??slu?n? smlouva je uzav?ena teprve > v?slovn?m dosa?en?m shody na v?ech jej?ch n?le?itostech. > - odes?latel tohoto emailu informuje, ?e nen? opr?vn?n uzav?rat za > spole?nost ??dn? smlouvy s v?jimkou p??pad?, kdy k tomu byl p?semn? zmocn?n > nebo p?semn? pov??en a takov? pov??en? nebo pln? moc byly adres?tovi tohoto > emailu p??padn? osob?, kterou adres?t zastupuje, p?edlo?eny nebo jejich > existence je adres?tovi ?i osob? j?m zastoupen? zn?m?. > > This e-mail and any documents attached to it may be confidential and are > intended only for its intended recipients. > If you received this e-mail by mistake, please immediately inform its > sender. Delete the contents of this e-mail with all attachments and its > copies from your system. > If you are not the intended recipient of this e-mail, you are not > authorized to use, disseminate, copy or disclose this e-mail in any manner. > The sender of this e-mail shall not be liable for any possible damage > caused by modifications of the e-mail or by delay with transfer of the > email. > > In case that this e-mail forms part of business dealings: > - the sender reserves the right to end negotiations about entering into a > contract in any time, for any reason, and without stating any reasoning. > - if the e-mail contains an offer, the recipient is entitled to > immediately accept such offer; The sender of this e-mail (offer) excludes > any acceptance of the offer on the part of the recipient containing any > amendment or variation. > - the sender insists on that the respective contract is concluded only > upon an express mutual agreement on all its aspects. > - the sender of this e-mail informs that he/she is not authorized to enter > into any contracts on behalf of the company except for cases in which > he/she is expressly authorized to do so in writing, and such authorization > or power of attorney is submitted to the recipient or the person > represented by the recipient, or the existence of such authorization is > known to the recipient of the person represented by the recipient. >[[alternative HTML version deleted]]