[R] code for year month day hr format

Rui Barradas ru|pb@rr@d@@ @end|ng |rom @@po@pt
Mon Jun 17 21:53:29 CEST 2024


Às 09:44 de 17/06/2024, Jibrin Alhassan escreveu:
> Hello Rui,
> The df1 output printed from June instead of January .Here is part of it.
> 4288  2012-06-27 15  6.2  420  70   -7 109.9
> 4289  2012-06-27 16  6.5  442  70   -9 109.9
> 4290  2012-06-27 17  6.3  450  70   -6 109.9
> 4291  2012-06-27 18  6.0  453  70    0 109.9
> 4292  2012-06-27 19  6.7  473  70    2 109.9
> 4293  2012-06-27 20  5.7  460  70    2 109.9
> 4294  2012-06-27 21  5.4  469  70    0 109.9
> 4295  2012-06-27 22  4.5  485  70   -2 109.9
> 4296  2012-06-27 23  4.9  497  70    1 109.9
> 4297  2012-06-28  0  4.6  500  87    3 123.7
> 4298  2012-06-28  1  4.7  503  87    2 123.7
> 4299  2012-06-28  2  4.3  488  87    1 123.7
> 4300  2012-06-28  3  4.9  479  87    0 123.7
> 4301  2012-06-28  4  5.1  459  87    0 123.7
> 4302  2012-06-28  5  4.9  458  87    0 123.7
> 4303  2012-06-28  6  5.1  460  87    0 123.7
> 4304  2012-06-28  7  5.0  451  87   -3 123.7
> 4305  2012-06-28  8  5.2  452  87   -5 123.7
> 4306  2012-06-28  9  5.2  445  87   -6 123.7
> 4307  2012-06-28 10  5.0  430  87   -7 123.7
> 4308  2012-06-28 11  4.6  434  87   -8 123.7
> 4309  2012-06-28 12  4.1  442  87   -7 123.7
> 4310  2012-06-28 13  3.9  433  87   -7 123.7
> 4311  2012-06-28 14  3.5  421  87   -9 123.7
> 4312  2012-06-28 15  4.4  420  87   -8 123.7
> 4313  2012-06-28 16  4.6  421  87   -9 123.7
> 4314  2012-06-28 17  3.2  417  87   -7 123.7
> 4315  2012-06-28 18  3.5  415  87   -3 123.7
> 4316  2012-06-28 19  3.9  394  87   -2 123.7
> 4317  2012-06-28 20  4.2  407  87    0 123.7
> 4318  2012-06-28 21  3.9  411  87   -3 123.7
> 4319  2012-06-28 22  3.6  420  87   -5 123.7
> 4320  2012-06-28 23  4.0  423  87    0 123.7
> 4321  2012-06-29  0  3.2  418 103    5 121.3
> 4322  2012-06-29  1  3.3  421 103    7 121.3
> 4323  2012-06-29  2  3.7  411 103    9 121.3
> 4324  2012-06-29  3  3.8  413 103    9 121.3
> 4325  2012-06-29  4  3.3  413 103    6 121.3
> 4326  2012-06-29  5  3.2  417 103    2 121.3
> 4327  2012-06-29  6  3.4  414 103    2 121.3
> 4328  2012-06-29  7  3.7  405 103    1 121.3
> 4329  2012-06-29  8  3.9  393 103    1 121.3
> 4330  2012-06-29  9  4.2  385 103    2 121.3
> 4331  2012-06-29 10  4.4  381 103    2 121.3
> 4332  2012-06-29 11  4.0  386 103    3 121.3
> 4333  2012-06-29 12  4.7  386 103    5 121.3
> 4334  2012-06-29 13  5.2  378 103    7 121.3
> 4335  2012-06-29 14  5.1  376 103    5 121.3
> 4336  2012-06-29 15  4.7  366 103    2 121.3
> 4337  2012-06-29 16  4.5  378 103    0 121.3
> 4338  2012-06-29 17  4.8  369 103    0 121.3
> 4339  2012-06-29 18  5.4  365 103    0 121.3
> 4340  2012-06-29 19  5.7  369 103    1 121.3
> 4341  2012-06-29 20  5.8  373 103    3 121.3
> 4342  2012-06-29 21  4.9  392 103   10 121.3
> 4343  2012-06-29 22  4.0  406 103   19 121.3
> 4344  2012-06-29 23  7.1  402 103   19 121.3
> 4345  2012-06-30  0  6.5  398 104   18 128.2
> 4346  2012-06-30  1  7.6  397 104   12 128.2
> 4347  2012-06-30  2  8.8  407 104   10 128.2
> 4348  2012-06-30  3 11.2  404 104   -1 128.2
> 4349  2012-06-30  4 11.2  410 104    1 128.2
> 4350  2012-06-30  5  8.8  410 104    1 128.2
> 4351  2012-06-30  6  9.7  417 104   -6 128.2
> 4352  2012-06-30  7 12.3  446 104  -14 128.2
> 4353  2012-06-30  8  9.5  476 104  -10 128.2
> 4354  2012-06-30  9  8.7  496 104  -13 128.2
> 4355  2012-06-30 10 12.6  560 104  -17 128.2
> 4356  2012-06-30 11 11.4  600 104  -13 128.2
> 4357  2012-06-30 12 11.4  607 104  -12 128.2
> 4358  2012-06-30 13 11.1  603 104   -8 128.2
> 4359  2012-06-30 14 11.1  616 104  -14 128.2
> 4360  2012-06-30 15  9.7  616 104  -13 128.2
> 4361  2012-06-30 16  9.7  629 104  -15 128.2
> 4362  2012-06-30 17  6.6  654 104  -24 128.2
> 4363  2012-06-30 18  6.5  660 104  -24 128.2
> 4364  2012-06-30 19  6.8  676 104  -31 128.2
> 4365  2012-06-30 20  7.2  675 104  -37 128.2
> 4366  2012-06-30 21  7.0  657 104  -32 128.2
> 4367  2012-06-30 22  6.4  634 104  -31 128.2
> 4368  2012-06-30 23  7.6  640 104  -29 128.2
> 4369  2012-07-01  0  6.9  650 126  -23 137.9
> 4370  2012-07-01  1  7.0  635 126  -18 137.9
> 4371  2012-07-01  2  6.9  651 126  -17 137.9
> 4372  2012-07-01  3  6.3  661 126  -25 137.9
> 4373  2012-07-01  4  5.6  663 126  -26 137.9
> 4374  2012-07-01  5  5.4  655 126  -26 137.9
> 4375  2012-07-01  6  5.1  656 126  -33 137.9
> 4376  2012-07-01  7  4.9  658 126  -30 137.9
> 4377  2012-07-01  8  5.1  648 126  -24 137.9
> 4378  2012-07-01  9  5.0  643 126  -24 137.9
> 4379  2012-07-01 10  5.0  633 126  -20 137.9
> 4380  2012-07-01 11  5.1  650 126  -17 137.9
> 4381  2012-07-01 12  5.2  687 126  -13 137.9
> 4382  2012-07-01 13  5.0  653 126   -8 137.9
> 4383  2012-07-01 14  4.9  648 126  -12 137.9
> 4384  2012-07-01 15  5.7  661 126  -11 137.9
> 4385  2012-07-01 16  5.7  665 126  -10 137.9
> 4386  2012-07-01 17  5.9  655 126  -12 137.9
> 4387  2012-07-01 18  5.1  647 126  -10 137.9
> 4388  2012-07-01 19  4.9  638 126  -16 137.9
> 4389  2012-07-01 20  5.1  633 126  -17 137.9
> 4390  2012-07-01 21  5.8  642 126  -16 137.9
> 4391  2012-07-01 22  5.8  635 126  -18 137.9
> 4392  2012-07-01 23  5.6  639 126  -16 137.9
> 4393  2012-07-02  0  5.2  653 128  -15 171.4
> 4394  2012-07-02  1  6.0  642 128  -12 171.4
> 4395  2012-07-02  2  5.3  664 128  -16 171.4
> 4396  2012-07-02  3  5.2  676 128  -13 171.4
> 4397  2012-07-02  4  5.0  662 128  -22 171.4
> 4398  2012-07-02  5  5.2  650 128  -28 171.4
> 4399  2012-07-02  6  5.0  650 128  -35 171.4
> 4400  2012-07-02  7  5.1  644 128  -32 171.4
> 4401  2012-07-02  8  4.9  653 128  -31 171.4
> 4402  2012-07-02  9  4.5  649 128  -26 171.4
> 4403  2012-07-02 10  4.3  640 128  -25 171.4
> 4404  2012-07-02 11  4.2  635 128  -20 171.4
> 4405  2012-07-02 12  4.8  636 128  -17 171.4
> 4406  2012-07-02 13  5.2  619 128  -16 171.4
> 4407  2012-07-02 14  4.9  649 128  -25 171.4
> 4408  2012-07-02 15  4.9  652 128  -31 171.4
> 4409  2012-07-02 16  5.1  649 128  -36 171.4
> 4410  2012-07-02 17  4.6  628 128  -37 171.4
> 4411  2012-07-02 18  4.2  633 128  -31 171.4
> 4412  2012-07-02 19  4.0  642 128  -29 171.4
> 4413  2012-07-02 20  3.8  643 128  -30 171.4
> 4414  2012-07-02 21  3.7  631 128  -32 171.4
> 4415  2012-07-02 22  3.7  626 128  -32 171.4
> 4416  2012-07-02 23  3.1  642 128  -31 171.4
> 4417  2012-07-03  0  3.3  634 125  -25 150.7
> 4418  2012-07-03  1  3.7  618 125  -19 150.7
> 4419  2012-07-03  2  3.9  593 125  -17 150.7
> 4420  2012-07-03  3  3.8  589 125  -16 150.7
> 4421  2012-07-03  4  3.8  576 125  -16 150.7
> 4422  2012-07-03  5  4.1  580 125  -20 150.7
> 4423  2012-07-03  6  3.9  580 125  -18 150.7
> 4424  2012-07-03  7  3.8  572 125  -19 150.7
> 4425  2012-07-03  8  4.1  562 125  -18 150.7
> 4426  2012-07-03  9  4.0  561 125  -15 150.7
> 4427  2012-07-03 10  4.1  558 125  -18 150.7
> 4428  2012-07-03 11  4.0  550 125  -20 150.7
> 4429  2012-07-03 12  4.1  548 125  -22 150.7
> 4430  2012-07-03 13  3.9  549 125  -21 150.7
> 4431  2012-07-03 14  4.1  532 125  -19 150.7
> 4432  2012-07-03 15  4.2  546 125  -19 150.7
> 4433  2012-07-03 16  4.1  547 125  -19 150.7
> 4434  2012-07-03 17  4.1  525 125  -23 150.7
> 4435  2012-07-03 18  4.0  514 125  -25 150.7
> 4436  2012-07-03 19  3.7  534 125  -22 150.7
> 4437  2012-07-03 20  3.7  541 125  -18 150.7
> 4438  2012-07-03 21  3.6  533 125  -19 150.7
> 4439  2012-07-03 22  4.3  548 125  -16 150.7
> 4440  2012-07-03 23  4.9  534 125  -12 150.7
> 4441  2012-07-04  0  4.6  538 131  -11 168.6
> 4442  2012-07-04  1  4.6  558 131  -10 168.6
> 4443  2012-07-04  2  4.1  568 131   -8 168.6
> 4444  2012-07-04  3  4.8  578 131   -5 168.6
> 4445  2012-07-04  4  5.1  580 131  -10 168.6
> 4446  2012-07-04  5  5.2  573 131  -17 168.6
> 4447  2012-07-04  6  5.1  565 131  -19 168.6
> 4448  2012-07-04  7  4.5  560 131  -18 168.6
> 4449  2012-07-04  8  4.7  555 131  -18 168.6
> 4450  2012-07-04  9  4.2  531 131  -19 168.6
> 4451  2012-07-04 10  4.1  521 131  -17 168.6
> 4452  2012-07-04 11  4.2  525 131  -18 168.6
> 4453  2012-07-04 12  3.9  526 131  -15 168.6
> 4454  2012-07-04 13  4.1  518 131  -10 168.6
> 4455  2012-07-04 14  4.5  506 131   -7 168.6
> 4456  2012-07-04 15  4.9  497 131   -6 168.6
> 4457  2012-07-04 16  4.9  498 131   -5 168.6
> 4458  2012-07-04 17  4.8  489 131   -5 168.6
> 4459  2012-07-04 18  4.5  518 131   -6 168.6
> 4460  2012-07-04 19  5.2  521 131   -6 168.6
> 4461  2012-07-04 20  6.1  535 131   -8 168.6
> 4462  2012-07-04 21  6.3  537 131  -14 168.6
> 4463  2012-07-04 22  6.4  519 131  -18 168.6
> 4464  2012-07-04 23  6.1  512 131  -19 168.6
> 4465  2012-07-05  0  5.9  500 129  -12 170.1
> 4466  2012-07-05  1  5.7  493 129   -1 170.1
> 4467  2012-07-05  2  5.8  486 129    4 170.1
> 4468  2012-07-05  3  5.8  487 129    4 170.1
> 4469  2012-07-05  4  5.4  478 129    5 170.1
> 4470  2012-07-05  5  5.4  478 129    2 170.1
> 4471  2012-07-05  6  5.9  483 129   -3 170.1
> 4472  2012-07-05  7  6.3  495 129   -7 170.1
> 4473  2012-07-05  8  6.1  503 129   -7 170.1
> 4474  2012-07-05  9  6.2  499 129   -2 170.1
> 4475  2012-07-05 10  5.9  495 129    3 170.1
> 4476  2012-07-05 11  4.1  499 129   21 170.1
> 4477  2012-07-05 12  6.8  491 129   16 170.1
> 4478  2012-07-05 13  6.9  489 129   11 170.1
> 4479  2012-07-05 14  6.5  486 129   31 170.1
> 4480  2012-07-05 15  8.2  478 129   11 170.1
> 4481  2012-07-05 16  8.1  472 129   11 170.1
> 4482  2012-07-05 17  9.8  486 129   11 170.1
> 4483  2012-07-05 18 10.0  489 129    9 170.1
> 4484  2012-07-05 19 10.0  489 129    8 170.1
> 4485  2012-07-05 20  9.8  488 129   12 170.1
> 4486  2012-07-05 21  9.8  485 129   13 170.1
> 4487  2012-07-05 22 10.3  473 129    6 170.1
> 4488  2012-07-05 23  9.4  460 129    7 170.1
> 4489  2012-07-06  0  9.4  457 132    4 163.0
> 4490  2012-07-06  1  9.3  448 132    6 163.0
> 4491  2012-07-06  2  8.8  437 132    7 163.0
> 4492  2012-07-06  3  7.4  435 132   -1 163.0
> 4493  2012-07-06  4  8.2  431 132   -3 163.0
> 4494  2012-07-06  5  8.2  424 132    1 163.0
> 4495  2012-07-06  6  7.8  429 132   -2 163.0
> 4496  2012-07-06  7  7.8  429 132  -10 163.0
> 4497  2012-07-06  8  7.6  436 132  -13 163.0
> 4498  2012-07-06  9  6.9  442 132   -9 163.0
> 4499  2012-07-06 10  5.7  458 132   -2 163.0
> 4500  2012-07-06 11  6.3  453 132   -3 163.0
> 4501  2012-07-06 12  5.0  447 132   -4 163.0
> 4502  2012-07-06 13  5.2  430 132   -4 163.0
> 4503  2012-07-06 14  5.9  417 132   -5 163.0
> 4504  2012-07-06 15  6.3  421 132   -7 163.0
> 4505  2012-07-06 16  8.7  447 132    2 163.0
> 4506  2012-07-06 17  9.8  453 132    4 163.0
> 4507  2012-07-06 18 10.1  484 132   -4 163.0
> 4508  2012-07-06 19  9.9  484 132  -17 163.0
> 4509  2012-07-06 20 10.0  485 132  -27 163.0
> 4510  2012-07-06 21 10.5  457 132  -36 163.0
> 4511  2012-07-06 22  9.9  459 132  -25 163.0
> 4512  2012-07-06 23  8.3  483 132   -9 163.0
> 4513  2012-07-07  0  8.1  486 146  -12 163.7
> 4514  2012-07-07  1  6.9  485 146   -6 163.7
> 4515  2012-07-07  2  7.1  484 146    0 163.7
> 4516  2012-07-07  3  5.6  480 146    4 163.7
> 4517  2012-07-07  4  5.2  480 146    3 163.7
> 4518  2012-07-07  5  5.3  493 146    1 163.7
> 4519  2012-07-07  6  5.1  494 146    1 163.7
> 4520  2012-07-07  7  4.7  469 146   -3 163.7
> 4521  2012-07-07  8  4.9  484 146   -7 163.7
> 4522  2012-07-07  9  4.3  482 146  -10 163.7
> 4523  2012-07-07 10  4.3  477 146   -7 163.7
> 4524  2012-07-07 11  4.1  467 146   -6 163.7
> 4525  2012-07-07 12  4.1  462 146  -10 163.7
> 4526  2012-07-07 13  3.8  448 146  -13 163.7
> 4527  2012-07-07 14  3.9  442 146  -14 163.7
> 4528  2012-07-07 15  3.8  443 146  -14 163.7
> 4529  2012-07-07 16  3.8  439 146  -12 163.7
> 4530  2012-07-07 17  3.4  435 146   -7 163.7
> 4531  2012-07-07 18  3.7  434 146   -9 163.7
> 4532  2012-07-07 19  3.5  428 146   -6 163.7
> 4533  2012-07-07 20  3.1  427 146   -3 163.7
> 4534  2012-07-07 21  3.2  429 146   -2 163.7
> 4535  2012-07-07 22  3.3  427 146   -6 163.7
> 4536  2012-07-07 23  3.5  434 146  -12 163.7
> 4537  2012-07-08  0  3.1  441 117   -9 183.7
> 4538  2012-07-08  1  3.1  436 117   -7 183.7
> 4539  2012-07-08  2  3.8  427 117   -4 183.7
> 4540  2012-07-08  3  3.4  418 117    3 183.7
> 4541  2012-07-08  4  3.6  417 117   13 183.7
> 4542  2012-07-08  5  4.6  413 117   15 183.7
> 4543  2012-07-08  6  4.3  404 117   15 183.7
> 4544  2012-07-08  7  4.0  394 117   11 183.7
> 4545  2012-07-08  8  5.5  405 117   12 183.7
> 4546  2012-07-08  9  9.2  423 117   14 183.7
> 4547  2012-07-08 10  8.8  418 117   18 183.7
> 4548  2012-07-08 11  9.2  407 117   11 183.7
> 4549  2012-07-08 12  9.2  401 117   10 183.7
> 4550  2012-07-08 13 10.6  412 117   18 183.7
> 4551  2012-07-08 14 11.1  414 117   17 183.7
> 4552  2012-07-08 15 11.1  458 117   13 183.7
> 4553  2012-07-08 16 11.3  441 117   14 183.7
> 4554  2012-07-08 17 11.0  439 117   15 183.7
> 4555  2012-07-08 18  9.8  443 117   13 183.7
> 4556  2012-07-08 19  8.1  439 117   10 183.7
> 4557  2012-07-08 20  5.1  453 117   12 183.7
> 4558  2012-07-08 21  8.4  462 117   16 183.7
> 4559  2012-07-08 22  9.0  447 117    6 183.7
> 4560  2012-07-08 23  9.8  436 117  -10 183.7
> 4561  2012-07-09  0 10.1  438 122  -27 179.6
> 4562  2012-07-09  1 11.6  441 122  -37 179.6
> 4563  2012-07-09  2 11.6  434 122  -30 179.6
> 4564  2012-07-09  3 11.8  421 122  -29 179.6
> 4565  2012-07-09  4 11.8  419 122  -33 179.6
> 4566  2012-07-09  5 11.6  419 122  -36 179.6
> 4567  2012-07-09  6 11.7  420 122  -34 179.6
> 4568  2012-07-09  7 12.2  415 122  -43 179.6
> 4569  2012-07-09  8 12.2  412 122  -49 179.6
> 4570  2012-07-09  9 12.3  405 122  -58 179.6
> 4571  2012-07-09 10 12.3  398 122  -61 179.6
> 4572  2012-07-09 11 12.0  392 122  -62 179.6
> 4573  2012-07-09 12 12.0  392 122  -78 179.6
> 4574  2012-07-09 13 11.9  390 122  -73 179.6
> 4575  2012-07-09 14 11.4  394 122  -64 179.6
> 4576  2012-07-09 15 10.6  400 122  -61 179.6
> 4577  2012-07-09 16 10.9  400 122  -71 179.6
> 4578  2012-07-09 17 10.7  396 122  -69 179.6
> 4579  2012-07-09 18 10.7  394 122  -67 179.6
> 4580  2012-07-09 19 10.3  395 122  -64 179.6
> 4581  2012-07-09 20 11.0  395 122  -64 179.6
> 4582  2012-07-09 21 10.8  397 122  -70 179.6
> 4583  2012-07-09 22 11.5  401 122  -78 179.6
> 4584  2012-07-09 23 11.1  401 122  -70 179.6
> 4585  2012-07-10  0 11.1  389 107  -65 179.2
> 4586  2012-07-10  1 11.8  403 107  -55 179.2
> 4587  2012-07-10  2 10.1  416 107  -45 179.2
> 4588  2012-07-10  3 11.0  406 107  -42 179.2
> 4589  2012-07-10  4 10.8  419 107  -42 179.2
> 4590  2012-07-10  5 10.6  410 107  -39 179.2
> 4591  2012-07-10  6 10.3  408 107  -36 179.2
> 4592  2012-07-10  7  9.4  417 107  -35 179.2
> 4593  2012-07-10  8  8.2  405 107  -38 179.2
> 4594  2012-07-10  9  8.3  404 107  -38 179.2
> 4595  2012-07-10 10  8.0  424 107  -34 179.2
> 4596  2012-07-10 11  7.3  433 107  -31 179.2
> 4597  2012-07-10 12  7.5  465 107  -28 179.2
> 4598  2012-07-10 13  7.3  450 107  -25 179.2
> 4599  2012-07-10 14  6.5  454 107  -25 179.2
> 4600  2012-07-10 15  6.6  472 107  -27 179.2
> 4601  2012-07-10 16  6.7  461 107  -28 179.2
> 4602  2012-07-10 17  6.5  462 107  -29 179.2
> 4603  2012-07-10 18  6.5  461 107  -28 179.2
> 4604  2012-07-10 19  5.4  483 107  -27 179.2
> 4605  2012-07-10 20  4.9  490 107  -24 179.2
> 4606  2012-07-10 21  5.6  482 107  -23 179.2
> 4607  2012-07-10 22  5.7  484 107  -25 179.2
> 4608  2012-07-10 23  5.8  484 107  -26 179.2
> 4609  2012-07-11  0  6.6  489 110  -27 167.1
> 4610  2012-07-11  1  6.7  489 110  -25 167.1
> 4611  2012-07-11  2  7.1  503 110  -24 167.1
> 4612  2012-07-11  3  5.7  494 110  -29 167.1
> 4613  2012-07-11  4  5.5  509 110  -30 167.1
> 4614  2012-07-11  5  5.3  522 110  -24 167.1
> 4615  2012-07-11  6  5.2  518 110  -23 167.1
> 4616  2012-07-11  7  6.5  516 110  -30 167.1
> 4617  2012-07-11  8  6.3  526 110  -36 167.1
> 4618  2012-07-11  9  6.2  523 110  -34 167.1
> 4619  2012-07-11 10  5.5  527 110  -25 167.1
> 4620  2012-07-11 11  6.0  527 110  -22 167.1
> 4621  2012-07-11 12  5.8  518 110  -22 167.1
> 4622  2012-07-11 13  5.4  515 110  -19 167.1
> 4623  2012-07-11 14  5.3  513 110  -21 167.1
> 4624  2012-07-11 15  5.5  512 110  -21 167.1
> 4625  2012-07-11 16  5.2  505 110  -21 167.1
> 4626  2012-07-11 17  4.9  512 110  -18 167.1
> 4627  2012-07-11 18  5.1  514 110  -17 167.1
> 4628  2012-07-11 19  6.2  520 110  -13 167.1
> 4629  2012-07-11 20  6.6  510 110  -17 167.1
> 4630  2012-07-11 21  6.2  516 110  -18 167.1
> 4631  2012-07-11 22  5.8  512 110  -24 167.1
> 4632  2012-07-11 23  5.9  509 110  -31 167.1
> 4633  2012-07-12  0  6.1  502 125  -34 170.9
> 4634  2012-07-12  1  6.6  506 125  -34 170.9
> 4635  2012-07-12  2  6.1  502 125  -22 170.9
> 4636  2012-07-12  3  5.8  480 125  -18 170.9
> 4637  2012-07-12  4  5.7  474 125  -15 170.9
> 4638  2012-07-12  5  5.4  474 125  -23 170.9
> 4639  2012-07-12  6  6.1  466 125  -28 170.9
> 4640  2012-07-12  7  5.4  460 125  -32 170.9
> 4641  2012-07-12  8  4.8  453 125  -32 170.9
> 4642  2012-07-12  9  4.7  445 125  -28 170.9
> 4643  2012-07-12 10  4.9  436 125  -29 170.9
> 4644  2012-07-12 11  4.9  441 125  -23 170.9
> 4645  2012-07-12 12  4.9  440 125  -18 170.9
> 4646  2012-07-12 13  4.2  417 125  -15 170.9
> 4647  2012-07-12 14  3.5  414 125  -16 170.9
> 4648  2012-07-12 15  3.9  418 125  -14 170.9
> 4649  2012-07-12 16  4.2  419 125  -11 170.9
> 4650  2012-07-12 17  3.9  416 125  -11 170.9
> 4651  2012-07-12 18  4.0  416 125  -12 170.9
> 4652  2012-07-12 19  3.8  415 125  -13 170.9
> 4653  2012-07-12 20  3.9  410 125  -16 170.9
> 4654  2012-07-12 21  3.8  402 125  -20 170.9
> 4655  2012-07-12 22  3.8  395 125  -19 170.9
> 4656  2012-07-12 23  3.9  394 125  -19 170.9
> 4657  2012-07-13  0  3.9  395 129  -20 152.1
> 4658  2012-07-13  1  3.8  395 129  -19 152.1
> 4659  2012-07-13  2  3.8  391 129  -17 152.1
> 4660  2012-07-13  3  3.8  385 129  -16 152.1
> 4661  2012-07-13  4  3.7  376 129  -15 152.1
> 4662  2012-07-13  5  3.8  371 129  -15 152.1
> 4663  2012-07-13  6  3.8  365 129  -14 152.1
> 4664  2012-07-13  7  3.9  357 129  -15 152.1
> 4665  2012-07-13  8  4.0  354 129  -18 152.1
> 4666  2012-07-13  9  3.9  355 129  -20 152.1
> 4667  2012-07-13 10  3.9  353 129  -19 152.1
> 4668  2012-07-13 11  3.7  357 129  -18 152.1
> 4669  2012-07-13 12  3.8  357 129  -18 152.1
> 4670  2012-07-13 13  3.8  355 129  -18 152.1
> 4671  2012-07-13 14  3.7  347 129  -17 152.1
> 4672  2012-07-13 15  3.7  350 129  -15 152.1
> 4673  2012-07-13 16  3.7  346 129  -13 152.1
> 4674  2012-07-13 17  3.7  341 129  -10 152.1
> 4675  2012-07-13 18  3.3  340 129   -8 152.1
> 4676  2012-07-13 19  3.2  338 129   -9 152.1
> 4677  2012-07-13 20  3.3  333 129  -10 152.1
> 4678  2012-07-13 21  3.4  329 129   -9 152.1
> 4679  2012-07-13 22  3.9  326 129   -7 152.1
> 4680  2012-07-13 23  4.0  324 129   -8 152.1
> 4681  2012-07-14  0  4.0  324 125   -9 152.8
> 4682  2012-07-14  1  4.0  325 125   -9 152.8
> 4683  2012-07-14  2  3.9  329 125   -7 152.8
> 4684  2012-07-14  3  4.1  326 125   -5 152.8
> 4685  2012-07-14  4  4.4  325 125   -6 152.8
> 4686  2012-07-14  5  4.5  323 125   -5 152.8
> 4687  2012-07-14  6  5.0  319 125   -5 152.8
> 4688  2012-07-14  7  5.2  317 125   -8 152.8
> 4689  2012-07-14  8  5.4  323 125   -7 152.8
> 4690  2012-07-14  9  5.4  318 125   -6 152.8
> 4691  2012-07-14 10  5.2  316 125   -8 152.8
> 4692  2012-07-14 11  5.2  326 125   -5 152.8
> 4693  2012-07-14 12  4.6  335 125   -5 152.8
> 4694  2012-07-14 13  4.2  340 125   -5 152.8
> 4695  2012-07-14 14  5.0  350 125   -5 152.8
> 4696  2012-07-14 15  4.9  366 125   -1 152.8
> 4697  2012-07-14 16  3.9  355 125   -5 152.8
> 4698  2012-07-14 17  5.1  369 125   -5 152.8
> 4699  2012-07-14 18 11.0  419 125   15 152.8
> 4700  2012-07-14 19 14.6  574 125    4 152.8
> 4701  2012-07-14 20 11.2  569 125   -7 152.8
> 4702  2012-07-14 21 13.9  568 125   -5 152.8
> 4703  2012-07-14 22 15.3  574 125    1 152.8
> 4704  2012-07-14 23 19.2  644 125   -2 152.8
> 4705  2012-07-15  0 11.4  665 117    9 145.1
> 4706  2012-07-15  1  9.7  657 117    0 145.1
> *Jibrin Adejoh Alhassan (Ph.D)*
> Department of Physics and Astronomy,
> University of Nigeria, Nsukka
> 
> 
> On Mon, Jun 17, 2024 at 9:23 AM Rui Barradas <ruipbarradas using sapo.pt> wrote:
> 
>> Às 09:12 de 17/06/2024, Jibrin Alhassan escreveu:
>>> Hello Rui,
>>> Here is the head(df1) output
>>> Date HR IMF SWS SSN Dst f10.7
>>> 1 2012-01-01  0 4.0 379  71  -8 999.9
>>> 2 2012-01-01  1 4.4 386  71  -3 999.9
>>> 3 2012-01-01  2 4.8 380  71  -4 999.9
>>> 4 2012-01-01  3 5.4 374  71  -5 999.9
>>> 5 2012-01-01  4 4.5 369  71  -9 999.9
>>> 6 2012-01-01  5 4.2 368  71  -7 999.9
>>> Many thanks.
>>> *Jibrin Adejoh Alhassan (Ph.D)*
>>> Department of Physics and Astronomy,
>>> University of Nigeria, Nsukka
>>>
>>>
>>> On Mon, Jun 17, 2024 at 8:14 AM Rui Barradas <ruipbarradas using sapo.pt>
>> wrote:
>>>
>>>> Às 07:53 de 17/06/2024, Jibrin Alhassan escreveu:
>>>>> Part of it is pasted below
>>>>> YEAR DOY HR    IMF SWS   SSN   Dst f10.7
>>>>> 2012   1  0   4.0  379.  71    -8 999.9
>>>>> 2012   1  1   4.4  386.  71    -3 999.9
>>>>> 2012   1  2   4.8  380.  71    -4 999.9
>>>>> 2012   1  3   5.4  374.  71    -5 999.9
>>>>> 2012   1  4   4.5  369.  71    -9 999.9
>>>>> 2012   1  5   4.2  368.  71    -7 999.9
>>>>> 2012   1  6   4.7  367.  71    -6 999.9
>>>>> 2012   1  7   4.1  361.  71   -10 999.9
>>>>> 2012   1  8   3.2  362.  71    -7 999.9
>>>>> 2012   1  9   4.3  367.  71    -3 999.9
>>>>> 2012   1 10   4.5  365.  71    -6 999.9
>>>>> 2012   1 11   5.6  369.  71    -8 999.9
>>>>> 2012   1 12   5.2  366.  71    -8 999.9
>>>>> 2012   1 13   4.4  370.  71    -7 999.9
>>>>> 2012   1 14   4.8  357.  71    -5 999.9
>>>>> 2012   1 15   4.6  354.  71    -8 999.9
>>>>> 2012   1 16   3.7  382.  71    -7 999.9
>>>>> 2012   1 17   3.2  376.  71    -2 999.9
>>>>> 2012   1 18   2.8  368.  71     2 999.9
>>>>> 2012   1 19   3.2  361.  71     2 999.9
>>>>> 2012   1 20   3.2  361.  71    -3 999.9
>>>>> 2012   1 21   3.5  365.  71    -5 999.9
>>>>> 2012   1 22   3.6  364.  71    -3 999.9
>>>>> 2012   1 23   3.0  362.  71    -3 999.9
>>>>> 2012   2  0   3.2  359.  92    -5 130.3
>>>>> 2012   2  1   3.0  361.  92    -4 130.3
>>>>> 2012   2  2   4.5  374.  92     3 130.3
>>>>> 2012   2  3   4.5  364.  92     5 130.3
>>>>> 2012   2  4   5.1  352.  92     3 130.3
>>>>> 2012   2  5   4.9  358.  92     3 130.3
>>>>> 2012   2  6   4.4  346.  92     4 130.3
>>>>> 2012   2  7   4.2  349.  92     7 130.3
>>>>> 2012   2  8   4.5  346.  92     8 130.3
>>>>> 2012   2  9   5.2  345.  92     7 130.3
>>>>> 2012   2 10   5.0  349.  92     5 130.3
>>>>> 2012   2 11   4.8  345.  92     0 130.3
>>>>> 2012   2 12   5.3  347.  92     0 130.3
>>>>> 2012   2 13   5.5  342.  92     0 130.3
>>>>> 2012   2 14   6.1  359.  92     1 130.3
>>>>> 2012   2 15   6.2  393.  92     8 130.3
>>>>> 2012   2 16   6.7  390.  92    10 130.3
>>>>> 2012   2 17   7.7  369.  92    10 130.3
>>>>> 2012   2 18   9.4  380.  92    14 130.3
>>>>> 2012   2 19  10.6  386.  92    12 130.3
>>>>> 2012   2 20  10.2  378.  92    11 130.3
>>>>> 2012   2 21  11.6  369.  92     7 130.3
>>>>> 2012   2 22  12.0  369.  92     8 130.3
>>>>> 2012   2 23  10.5  361.  92     1 130.3
>>>>> 2012   3  0  11.3  403. 120    -7 130.2
>>>>> 2012   3  1  10.3  412. 120   -14 130.2
>>>>> 2012   3  2   8.8  419. 120   -18 130.2
>>>>> 2012   3  3   8.3  412. 120   -23 130.2
>>>>> 2012   3  4   8.0  408. 120   -25 130.2
>>>>> 2012   3  5   7.0  380. 120   -28 130.2
>>>>> 2012   3  6   6.9  374. 120   -29 130.2
>>>>> 2012   3  7   6.9  372. 120   -30 130.2
>>>>> 2012   3  8   7.1  365. 120   -32 130.2
>>>>> 2012   3  9   6.8  376. 120   -35 130.2
>>>>> 2012   3 10   6.7  380. 120   -35 130.2
>>>>> 2012   3 11   6.4  381. 120   -30 130.2
>>>>> 2012   3 12   5.9  401. 120   -26 130.2
>>>>> 2012   3 13   5.9  405. 120   -23 130.2
>>>>> 2012   3 14   5.9  413. 120   -20 130.2
>>>>> 2012   3 15   5.9  406. 120   -20 130.2
>>>>> 2012   3 16   6.3  427. 120   -20 130.2
>>>>> 2012   3 17   5.9  424. 120   -19 130.2
>>>>> 2012   3 18   4.8  390. 120   -16 130.2
>>>>> 2012   3 19   4.8  374. 120   -15 130.2
>>>>> 2012   3 20   4.8  374. 120   -15 130.2
>>>>> 2012   3 21   5.1  378. 120   -18 130.2
>>>>> 2012   3 22   4.9  375. 120   -19 130.2
>>>>> 2012   3 23   4.7  364. 120   -17 130.2
>>>>> 2012   4  0   4.3  359. 126   -17 131.6
>>>>> 2012   4  1   4.3  359. 126   -15 131.6
>>>>> 2012   4  2   4.2  358. 126   -13 131.6
>>>>> 2012   4  3   3.8  359. 126   -13 131.6
>>>>> 2012   4  4   3.8  358. 126   -13 131.6
>>>>> 2012   4  5   3.7  359. 126   -14 131.6
>>>>> 2012   4  6   3.9  361. 126   -13 131.6
>>>>> 2012   4  7   3.7  364. 126   -13 131.6
>>>>> 2012   4  8   3.7  366. 126   -12 131.6
>>>>> 2012   4  9   3.8  363. 126   -10 131.6
>>>>> 2012   4 10   3.5  363. 126    -8 131.6
>>>>> 2012   4 11   3.0  352. 126   -10 131.6
>>>>> 2012   4 12   3.1  348. 126   -12 131.6
>>>>> 2012   4 13   3.3  340. 126    -9 131.6
>>>>> 2012   4 14   4.0  343. 126    -8 131.6
>>>>> 2012   4 15   4.2  343. 126    -7 131.6
>>>>> 2012   4 16   3.8  336. 126    -5 131.6
>>>>> 2012   4 17   3.9  334. 126    -6 131.6
>>>>> 2012   4 18   3.8  329. 126    -5 131.6
>>>>> 2012   4 19   3.8  326. 126    -4 131.6
>>>>> 2012   4 20   4.3  337. 126    -3 131.6
>>>>> 2012   4 21   3.9  331. 126     0 131.6
>>>>> 2012   4 22   3.8  322. 126    -1 131.6
>>>>> 2012   4 23   3.5  331. 126    -1 131.6
>>>>> 2012   5  0   3.9  312. 109    -3 136.6
>>>>> 2012   5  1   3.6  311. 109    -1 136.6
>>>>> 2012   5  2   3.7  312. 109     0 136.6
>>>>> 2012   5  3   3.8  308. 109     0 136.6
>>>>> 2012   5  4   4.0  305. 109     2 136.6
>>>>> 2012   5  5   4.5  309. 109     2 136.6
>>>>> 2012   5  6   3.5  314. 109     3 136.6
>>>>> 2012   5  7   3.6  305. 109     2 136.6
>>>>> 2012   5  8   4.3  307. 109     2 136.6
>>>>> 2012   5  9   4.6  316. 109     1 136.6
>>>>> 2012   5 10   5.0  321. 109    -4 136.6
>>>>> 2012   5 11   5.1  321. 109    -6 136.6
>>>>> 2012   5 12   4.6  326. 109    -4 136.6
>>>>> 2012   5 13   5.7  321. 109    -2 136.6
>>>>> 2012   5 14   5.0  316. 109     1 136.6
>>>>> 2012   5 15   4.6  315. 109     2 136.6
>>>>> 2012   5 16   5.5  321. 109     7 136.6
>>>>> 2012   5 17   7.2  327. 109     7 136.6
>>>>> 2012   5 18   9.2  329. 109     3 136.6
>>>>> 2012   5 19   9.4  341. 109     3 136.6
>>>>> 2012   5 20   9.2  345. 109     8 136.6
>>>>> 2012   5 21   9.8  344. 109     9 136.6
>>>>> 2012   5 22   9.8  341. 109    10 136.6
>>>>> 2012   5 23  10.0  351. 109    15 136.6
>>>>> 2012   6  0  10.4  356. 113    12 131.0
>>>>> 2012   6  1   9.1  360. 113    10 131.0
>>>>> 2012   6  2   6.6  392. 113    10 131.0
>>>>> 2012   6  3   6.9  418. 113     7 131.0
>>>>> 2012   6  4   6.5  408. 113     4 131.0
>>>>> 2012   6  5   6.6  413. 113     7 131.0
>>>>> 2012   6  6   7.3  428. 113     6 131.0
>>>>> 2012   6  7   7.3  416. 113     4 131.0
>>>>> 2012   6  8   7.0  411. 113     1 131.0
>>>>> 2012   6  9   7.2  415. 113     1 131.0
>>>>> 2012   6 10   7.2  426. 113     0 131.0
>>>>> 2012   6 11   6.5  431. 113    -2 131.0
>>>>> 2012   6 12   6.4  431. 113    -2 131.0
>>>>> 2012   6 13   6.6  435. 113     0 131.0
>>>>> 2012   6 14   6.2  425. 113     2 131.0
>>>>> 2012   6 15   5.7  431. 113     4 131.0
>>>>> 2012   6 16   6.1  431. 113     1 131.0
>>>>> 2012   6 17   5.7  425. 113    -3 131.0
>>>>> 2012   6 18   5.8  431. 113    -1 131.0
>>>>> 2012   6 19   6.4  425. 113     2 131.0
>>>>> 2012   6 20   6.0  434. 113     1 131.0
>>>>> 2012   6 21   6.3  420. 113     0 131.0
>>>>> 2012   6 22   6.3  440. 113    -3 131.0
>>>>> 2012   6 23   6.5  456. 113    -3 131.0
>>>>> 2012   7  0   6.3  435. 113    -5 135.9
>>>>> 2012   7  1   5.9  428. 113    -1 135.9
>>>>> 2012   7  2   5.7  434. 113     1 135.9
>>>>> 2012   7  3   5.3  423. 113     0 135.9
>>>>> 2012   7  4   4.3  417. 113     1 135.9
>>>>> 2012   7  5   5.4  420. 113     0 135.9
>>>>> 2012   7  6   5.7  434. 113     1 135.9
>>>>> 2012   7  7   5.5  423. 113     1 135.9
>>>>> 2012   7  8   4.8  419. 113    -2 135.9
>>>>> 2012   7  9   5.8  421. 113    -6 135.9
>>>>> 2012   7 10   5.3  412. 113    -9 135.9
>>>>> 2012   7 11   4.6  424. 113    -7 135.9
>>>>> 2012   7 12   4.0  439. 113    -3 135.9
>>>>> 2012   7 13   4.8  431. 113    -1 135.9
>>>>> 2012   7 14   5.1  431. 113    -1 135.9
>>>>> 2012   7 15   4.8  427. 113    -1 135.9
>>>>> 2012   7 16   4.7  429. 113    -5 135.9
>>>>> 2012   7 17   5.3  436. 113    -6 135.9
>>>>> 2012   7 18   5.1  426. 113    -5 135.9
>>>>> 2012   7 19   5.2  427. 113    -4 135.9
>>>>> 2012   7 20   4.5  416. 113    -5 135.9
>>>>> 2012   7 21   4.9  409. 113    -4 135.9
>>>>> 2012   7 22   5.0  417. 113    -4 135.9
>>>>> 2012   7 23   5.0  426. 113    -4 135.9
>>>>> 2012   8  0   5.0  433. 104    -2 131.4
>>>>> 2012   8  1   4.9  426. 104    -2 131.4
>>>>> 2012   8  2   4.7  421. 104    -4 131.4
>>>>> 2012   8  3   4.4  417. 104    -5 131.4
>>>>> 2012   8  4   4.3  416. 104    -8 131.4
>>>>> 2012   8  5   4.5  416. 104    -8 131.4
>>>>> 2012   8  6   5.0  419. 104    -6 131.4
>>>>> 2012   8  7   5.4  446. 104    -1 131.4
>>>>> 2012   8  8   5.3  439. 104    -2 131.4
>>>>> 2012   8  9   5.3  432. 104    -4 131.4
>>>>> 2012   8 10   5.4  434. 104    -4 131.4
>>>>> 2012   8 11   5.4  435. 104    -3 131.4
>>>>> 2012   8 12   4.5  421. 104    -4 131.4
>>>>> 2012   8 13   4.5  422. 104    -4 131.4
>>>>> 2012   8 14   5.1  425. 104    -2 131.4
>>>>> 2012   8 15   5.3  429. 104     1 131.4
>>>>> 2012   8 16   5.5  433. 104    -2 131.4
>>>>> 2012   8 17   5.9  440. 104    -2 131.4
>>>>> 2012   8 18   6.6  445. 104    -1 131.4
>>>>> 2012   8 19   6.4  442. 104    -4 131.4
>>>>> 2012   8 20   5.9  434. 104    -6 131.4
>>>>> 2012   8 21   5.3  429. 104    -7 131.4
>>>>> 2012   8 22   4.8  438. 104    -2 131.4
>>>>> 2012   8 23   5.3  427. 104     4 131.4
>>>>> 2012   9  0   5.5  433.  79     8 137.6
>>>>> 2012   9  1   5.2  445.  79     9 137.6
>>>>> 2012   9  2   5.4  439.  79    10 137.6
>>>>> 2012   9  3   5.3  430.  79     7 137.6
>>>>> 2012   9  4   5.1  426.  79    -3 137.6
>>>>> 2012   9  5   4.7  415.  79    -6 137.6
>>>>> 2012   9  6   5.0  412.  79    -4 137.6
>>>>> 2012   9  7   5.2  418.  79    -2 137.6
>>>>> 2012   9  8   5.5  441.  79     2 137.6
>>>>> 2012   9  9   5.1  441.  79     2 137.6
>>>>> 2012   9 10   5.4  430.  79    -2 137.6
>>>>> 2012   9 11   5.3  433.  79    -1 137.6
>>>>> 2012   9 12   5.5  438.  79     5 137.6
>>>>> 2012   9 13   5.4  436.  79     6 137.6
>>>>> 2012   9 14   5.7  440.  79     9 137.6
>>>>> 2012   9 15   5.9  430.  79     9 137.6
>>>>> 2012   9 16   5.8  437.  79     4 137.6
>>>>> 2012   9 17   4.9  431.  79    -3 137.6
>>>>> 2012   9 18   5.3  424.  79    -3 137.6
>>>>> 2012   9 19   5.7  437.  79    -2 137.6
>>>>> 2012   9 20   6.1  427.  79    -4 137.6
>>>>> 2012   9 21   6.0  409.  79    -7 137.6
>>>>> 2012   9 22   6.6  410.  79    -4 137.6
>>>>> 2012   9 23   6.4  432.  79    -1 137.6
>>>>> 2012  10  0   5.9  434.  70     2 124.6
>>>>> 2012  10  1   5.6  424.  70     4 124.6
>>>>> 2012  10  2   4.8  435.  70     7 124.6
>>>>> 2012  10  3   4.6  425.  70     4 124.6
>>>>> 2012  10  4   4.3  424.  70     3 124.6
>>>>> 2012  10  5   5.4  426.  70     2 124.6
>>>>> 2012  10  6   5.5  434.  70     2 124.6
>>>>> 2012  10  7   6.4  435.  70     4 124.6
>>>>> 2012  10  8   6.3  436.  70     1 124.6
>>>>> 2012  10  9   5.2  431.  70    -6 124.6
>>>>> 2012  10 10   4.5  426.  70   -10 124.6
>>>>> 2012  10 11   4.6  435.  70    -9 124.6
>>>>> 2012  10 12   3.4  425.  70    -5 124.6
>>>>> 2012  10 13   4.2  427.  70    -4 124.6
>>>>> 2012  10 14   4.0  432.  70     2 124.6
>>>>> 2012  10 15   5.5  450.  70     7 124.6
>>>>> 2012  10 16   5.9  451.  70     2 124.6
>>>>> 2012  10 17   5.5  445.  70    -3 124.6
>>>>> 2012  10 18   5.8  442.  70    -2 124.6
>>>>> 2012  10 19   5.4  430.  70    -1 124.6
>>>>> 2012  10 20   4.9  427.  70    -1 124.6
>>>>> 2012  10 21   4.0  436.  70     0 124.6
>>>>> 2012  10 22   3.4  445.  70    -1 124.6
>>>>> 2012  10 23   4.5  453.  70     0 124.6
>>>>> 2012  11  0   5.3  438.  63     1 116.1
>>>>> 2012  11  1   5.0  438.  63     3 116.1
>>>>> 2012  11  2   5.3  445.  63     3 116.1
>>>>> 2012  11  3   4.5  451.  63     2 116.1
>>>>> 2012  11  4   5.0  456.  63    -1 116.1
>>>>> 2012  11  5   4.6  459.  63     0 116.1
>>>>> 2012  11  6   5.1  459.  63     1 116.1
>>>>> 2012  11  7   4.0  466.  63     3 116.1
>>>>> 2012  11  8   5.0  478.  63    -1 116.1
>>>>> 2012  11  9   4.6  489.  63    -2 116.1
>>>>> 2012  11 10   4.5  493.  63    -4 116.1
>>>>> 2012  11 11   4.5  494.  63    -1 116.1
>>>>> 2012  11 12   3.6  504.  63     3 116.1
>>>>> 2012  11 13   3.5  496.  63     5 116.1
>>>>> 2012  11 14   3.3  497.  63     7 116.1
>>>>> 2012  11 15   3.0  498.  63     7 116.1
>>>>> 2012  11 16   2.1  503.  63     3 116.1
>>>>> 2012  11 17   2.0  495.  63     0 116.1
>>>>> 2012  11 18   2.5  492.  63    -2 116.1
>>>>> 2012  11 19   2.2  496.  63    -1 116.1
>>>>> 2012  11 20   2.4  489.  63     1 116.1
>>>>> 2012  11 21   2.6  489.  63     3 116.1
>>>>> 2012  11 22   2.6  483.  63     2 116.1
>>>>> 2012  11 23   2.6  478.  63     2 116.1
>>>>> 2012  12  0   2.9  453.  52     3 113.0
>>>>> 2012  12  1   2.2  446.  52     4 113.0
>>>>> 2012  12  2   2.4  442.  52     8 113.0
>>>>> 2012  12  3   2.6  440.  52    10 113.0
>>>>> 2012  12  4   2.2  438.  52    11 113.0
>>>>> 2012  12  5   2.8  438.  52     9 113.0
>>>>> 2012  12  6   2.0  437.  52     8 113.0
>>>>> 2012  12  7   2.4  426.  52     7 113.0
>>>>> 2012  12  8   3.0  423.  52     5 113.0
>>>>> 2012  12  9   3.3  420.  52     4 113.0
>>>>> 2012  12 10   4.0  419.  52     2 113.0
>>>>> 2012  12 11   3.8  412.  52     5 113.0
>>>>> 2012  12 12   4.2  409.  52     4 113.0
>>>>> 2012  12 13   3.5  408.  52     2 113.0
>>>>> 2012  12 14   3.7  404.  52     9 113.0
>>>>> 2012  12 15   4.5  402.  52    15 113.0
>>>>> 2012  12 16   3.6  395.  52    14 113.0
>>>>> 2012  12 17   2.4  392.  52    16 113.0
>>>>> 2012  12 18   5.8  403.  52    27 113.0
>>>>> 2012  12 19   7.6  400.  52    27 113.0
>>>>> 2012  12 20   6.9  418.  52    17 113.0
>>>>> 2012  12 21   6.9  463.  52    10 113.0
>>>>> 2012  12 22   7.3  469.  52     9 113.0
>>>>> 2012  12 23   5.5  482.  52    12 113.0
>>>>> 2012  13  0   7.7  500.  71    10 120.0
>>>>> 2012  13  1   8.7  492.  71    14 120.0
>>>>> 2012  13  2   7.8  513.  71    16 120.0
>>>>> 2012  13  3   7.5  530.  71    11 120.0
>>>>> 2012  13  4   7.1  518.  71     8 120.0
>>>>> 2012  13  5   7.0  524.  71     6 120.0
>>>>> 2012  13  6   5.9  536.  71     8 120.0
>>>>> 2012  13  7   3.6  529.  71     5 120.0
>>>>> 2012  13  8   4.1  510.  71     4 120.0
>>>>> 2012  13  9   3.9  497.  71     3 120.0
>>>>> 2012  13 10   2.4  492.  71     3 120.0
>>>>> 2012  13 11   2.6  485.  71     5 120.0
>>>>> 2012  13 12   2.9  492.  71     5 120.0
>>>>> 2012  13 13   2.6  487.  71     3 120.0
>>>>> 2012  13 14   2.3  478.  71     6 120.0
>>>>> 2012  13 15   3.2  467.  71    11 120.0
>>>>> 2012  13 16   3.4  453.  71    10 120.0
>>>>> 2012  13 17   3.2  452.  71     6 120.0
>>>>> 2012  13 18   3.0  452.  71     2 120.0
>>>>> 2012  13 19   2.8  447.  71     1 120.0
>>>>> 2012  13 20   2.5  439.  71     0 120.0
>>>>> 2012  13 21   2.5  443.  71    -2 120.0
>>>>> 2012  13 22   2.7  442.  71    -3 120.0
>>>>> 2012  13 23   3.0  447.  71    -4 120.0
>>>>> 2012  14  0   3.5  445. 118    -3 128.0
>>>>> 2012  14  1   3.3  440. 118    -1 128.0
>>>>> 2012  14  2   3.1  440. 118     1 128.0
>>>>> 2012  14  3   2.7  446. 118     0 128.0
>>>>> 2012  14  4   2.9  442. 118    -1 128.0
>>>>> 2012  14  5   2.9  437. 118    -2 128.0
>>>>> 2012  14  6   3.3  431. 118    -3 128.0
>>>>> 2012  14  7   2.8  420. 118    -2 128.0
>>>>> 2012  14  8   2.3  409. 118    -2 128.0
>>>>> 2012  14  9   2.2  407. 118     1 128.0
>>>>> 2012  14 10   2.6  405. 118     3 128.0
>>>>> 2012  14 11   2.8  401. 118     4 128.0
>>>>> 2012  14 12   3.2  398. 118     4 128.0
>>>>> 2012  14 13   2.7  400. 118     4 128.0
>>>>> 2012  14 14   1.9  399. 118     5 128.0
>>>>> 2012  14 15   2.4  395. 118     3 128.0
>>>>> 2012  14 16   2.7  389. 118     2 128.0
>>>>> 2012  14 17   2.9  385. 118     0 128.0
>>>>> 2012  14 18   3.2  384. 118     1 128.0
>>>>> 2012  14 19   2.6  380. 118     2 128.0
>>>>> 2012  14 20   2.3  378. 118     1 128.0
>>>>> 2012  14 21   2.1  374. 118     0 128.0
>>>>> 2012  14 22   3.1  367. 118     0 128.0
>>>>> 2012  14 23   4.0  366. 118    -1 128.0
>>>>> 2012  15  0   4.8  363. 149     0 129.2
>>>>> 2012  15  1   4.0  359. 149     2 129.2
>>>>> 2012  15  2   3.4  354. 149     2 129.2
>>>>> 2012  15  3   3.0  349. 149     5 129.2
>>>>> 2012  15  4   2.7  344. 149     7 129.2
>>>>> 2012  15  5   2.4  349. 149    11 129.2
>>>>> 2012  15  6   2.9  343. 149    12 129.2
>>>>> 2012  15  7   3.5  333. 149     7 129.2
>>>>> 2012  15  8   3.6  341. 149     4 129.2
>>>>> 2012  15  9   3.7  345. 149     1 129.2
>>>>> 2012  15 10   3.6  343. 149     2 129.2
>>>>> 2012  15 11   3.6  342. 149     3 129.2
>>>>> 2012  15 12   3.7  340. 149     7 129.2
>>>>> 2012  15 13   3.7  342. 149     8 129.2
>>>>> 2012  15 14   4.1  344. 149     9 129.2
>>>>> 2012  15 15   3.9  345. 149     4 129.2
>>>>> 2012  15 16   4.4  355. 149     8 129.2
>>>>> 2012  15 17   4.7  360. 149    11 129.2
>>>>> 2012  15 18   5.4  359. 149    12 129.2
>>>>> 2012  15 19   6.8  353. 149     8 129.2
>>>>> 2012  15 20   6.6  349. 149     6 129.2
>>>>> 2012  15 21   5.9  364. 149     2 129.2
>>>>> 2012  15 22   5.2  394. 149     1 129.2
>>>>> 2012  15 23   6.3  395. 149     5 129.2
>>>>> 2012  16  0   6.3  385. 154     6 135.1
>>>>> 2012  16  1   6.6  397. 154     2 135.1
>>>>> 2012  16  2   6.7  400. 154     4 135.1
>>>>> 2012  16  3   6.9  396. 154     5 135.1
>>>>> 2012  16  4   7.9  392. 154     5 135.1
>>>>> 2012  16  5   4.6  379. 154    10 135.1
>>>>> 2012  16  6   8.0  365. 154    13 135.1
>>>>> 2012  16  7   6.3  358. 154    16 135.1
>>>>> 2012  16  8   7.9  380. 154    12 135.1
>>>>> 2012  16  9  10.2  391. 154    10 135.1
>>>>> 2012  16 10   8.1  394. 154     8 135.1
>>>>> 2012  16 11  12.1  412. 154    -8 135.1
>>>>> 2012  16 12  13.2  424. 154   -10 135.1
>>>>> 2012  16 13  12.9  433. 154    -8 135.1
>>>>> 2012  16 14   9.3  461. 154    -7 135.1
>>>>> 2012  16 15   6.6  466. 154   -14 135.1
>>>>> 2012  16 16   6.6  493. 154   -11 135.1
>>>>> 2012  16 17   7.4  496. 154    -7 135.1
>>>>> 2012  16 18   6.2  493. 154    -7 135.1
>>>>> 2012  16 19   6.9  492. 154   -13 135.1
>>>>> 2012  16 20   6.8  486. 154   -19 135.1
>>>>> 2012  16 21   5.6  488. 154   -14 135.1
>>>>> 2012  16 22   6.4  464. 154   -11 135.1
>>>>> 2012  16 23   6.0  459. 154   -10 135.1
>>>>> 2012  17  0   4.9  476. 141   -14 134.5
>>>>> 2012  17  1   4.6  460. 141   -20 134.5
>>>>> 2012  17  2   4.1  467. 141   -17 134.5
>>>>> 2012  17  3   3.7  469. 141   -13 134.5
>>>>> 2012  17  4   3.3  472. 141   -12 134.5
>>>>> 2012  17  5   2.7  472. 141    -8 134.5
>>>>> 2012  17  6   3.5  459. 141    -6 134.5
>>>>> 2012  17  7   3.9  459. 141    -6 134.5
>>>>> 2012  17  8   4.1  463. 141    -7 134.5
>>>>> 2012  17  9   4.1  443. 141   -10 134.5
>>>>> 2012  17 10   4.1  446. 141   -14 134.5
>>>>> 2012  17 11   4.1  442. 141   -13 134.5
>>>>> 2012  17 12   3.6  436. 141   -10 134.5
>>>>> 2012  17 13   3.6  433. 141    -6 134.5
>>>>> 2012  17 14   4.2  421. 141    -1 134.5
>>>>> 2012  17 15   3.7  416. 141    -2 134.5
>>>>> 2012  17 16   4.2  410. 141    -1 134.5
>>>>> 2012  17 17   4.6  396. 141    -1 134.5
>>>>> 2012  17 18   4.5  398. 141    -2 134.5
>>>>> 2012  17 19   4.4  397. 141    -6 134.5
>>>>> 2012  17 20   4.5  396. 141    -8 134.5
>>>>> 2012  17 21   3.5  411. 141    -5 134.5
>>>>> 2012  17 22   3.9  425. 141    -5 134.5
>>>>> 2012  17 23   4.7  418. 141    -6 134.5
>>>>> 2012  18  0   4.6  400. 126    -7 143.4
>>>>> 2012  18  1   4.5  413. 126    -3 143.4
>>>>> 2012  18  2   4.4  418. 126     2 143.4
>>>>> 2012  18  3   4.2  420. 126     2 143.4
>>>>> 2012  18  4   4.0  401. 126    -2 143.4
>>>>> 2012  18  5   3.8  399. 126    -1 143.4
>>>>> 2012  18  6   3.5  388. 126    -1 143.4
>>>>> 2012  18  7   4.4  393. 126    -2 143.4
>>>>> 2012  18  8   4.7  405. 126    -3 143.4
>>>>> 2012  18  9   4.8  409. 126    -4 143.4
>>>>> 2012  18 10   4.9  409. 126    -3 143.4
>>>>> 2012  18 11   5.0  411. 126    -5 143.4
>>>>> 2012  18 12   5.1  405. 126    -5 143.4
>>>>> 2012  18 13   5.2  403. 126    -6 143.4
>>>>> 2012  18 14   5.1  394. 126    -4 143.4
>>>>> 2012  18 15   5.0  391. 126    -5 143.4
>>>>> 2012  18 16   4.6  387. 126    -4 143.4
>>>>> 2012  18 17   4.7  376. 126    -2 143.4
>>>>> 2012  18 18   4.7  381. 126    -1 143.4
>>>>> 2012  18 19   4.5  382. 126    -2 143.4
>>>>> 2012  18 20   4.9  386. 126    -5 143.4
>>>>> 2012  18 21   4.8  375. 126    -5 143.4
>>>>> 2012  18 22   4.7  385. 126    -6 143.4
>>>>> 2012  18 23   4.7  381. 126    -5 143.4
>>>>> 2012  19  0   4.3  372. 105    -3 152.0
>>>>> 2012  19  1   4.2  361. 105    -4 152.0
>>>>> 2012  19  2   4.0  360. 105    -5 152.0
>>>>> 2012  19  3   3.9  362. 105    -4 152.0
>>>>> *Jibrin Adejoh Alhassan (Ph.D)*
>>>>> Department of Physics and Astronomy,
>>>>> University of Nigeria, Nsukka
>>>>>
>>>>>
>>>>> On Mon, Jun 17, 2024 at 7:50 AM Jibrin Alhassan <
>>>> jibrin.alhassan using unn.edu.ng>
>>>>> wrote:
>>>>>
>>>>>> Hello Rui,
>>>>>> Your patience is indeed amazing. Your script tested as shown below
>>>> worked
>>>>>> perfectly well.
>>>>>> df1 <- read.table(text = "YEAR DOY HR   IMF  SW   SSN    Dst f10.7
>>>>>> 2012 215  4   5.1  371. 143    -4 138.6 ", header = TRUE)
>>>>>> with(df1, paste(YEAR, DOY)) |> as.Date(format = "%Y %j")
>>>>>> df1$Date <- with(df1, paste(YEAR, DOY)) |> as.Date(format = "%Y %j")
>>>>>> df1 <- df1[-(1:2)]
>>>>>> df1 <- df1[c(ncol(df1), 1:(ncol(df1) - 1L))]
>>>>>> head(df1).
>>>>>> But  I have 43,849 data points. Your script only generated one. Help
>> me
>>>>>> with a script that can handle the whole data points. I have tried
>>>> following
>>>>>> your tested solution but was unsuccessful. My regards.
>>>>>> *Jibrin Adejoh Alhassan (Ph.D)*
>>>>>> Department of Physics and Astronomy,
>>>>>> University of Nigeria, Nsukka
>>>>>>
>>>>>>
>>>>>> On Sun, Jun 16, 2024 at 8:33 AM Rui Barradas <ruipbarradas using sapo.pt>
>>>> wrote:
>>>>>>
>>>>>>> Às 21:42 de 15/06/2024, Jibrin Alhassan escreveu:
>>>>>>>> Thank you Rui. I ran the following script
>>>>>>>> df1 <- read.table("solar_hour", header = TRUE)
>>>>>>>> df1$date <- as.Date(paste(df1$year, df1$hour),
>>>>>>>>      format = "%Y %j",
>>>>>>>> origin = "2012-08-01-0")
>>>>>>>> df2 <- df1[c("date", "IMF", "SWS", "SSN", "Dst", "f10")]
>>>>>>>> head(df1)
>>>>>>>> #To display all the rows
>>>>>>>>      print(df2).
>>>>>>>> It gave me this error message
>>>>>>>>> source ("script.R")
>>>>>>>> Error in `$<-.data.frame`(`*tmp*`, date, value = numeric(0)) :
>>>>>>>>       replacement has 0 rows, data has 38735
>>>>>>>>> print(df2)
>>>>>>>> Error: object 'df2' not found
>>>>>>>>> My data is an hourly data but desire to have the date as
>>>>>>>> year    month    day   hour
>>>>>>>> 2012   08         01     01
>>>>>>>> 2012   08         01     02
>>>>>>>> 2012   08        01      03 etc
>>>>>>>> Thanks.
>>>>>>>>
>>>>>>>> *Jibrin Adejoh Alhassan (Ph.D)*
>>>>>>>> Department of Physics and Astronomy,
>>>>>>>> University of Nigeria, Nsukka
>>>>>>>>
>>>>>>>>
>>>>>>>> On Sat, Jun 15, 2024 at 8:34 PM Rui Barradas <ruipbarradas using sapo.pt>
>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Às 20:00 de 15/06/2024, Jibrin Alhassan escreveu:
>>>>>>>>>> I have solar-geophysical data e.g as blow:
>>>>>>>>>> YEAR DOY HR   IMF  SW   SSN    Dst f10.7
>>>>>>>>>> 2012 214  0   3.4  403. 132    -9 154.6
>>>>>>>>>> 2012 214  1   3.7  388. 132   -10 154.6
>>>>>>>>>> 2012 214  2   3.7  383. 132   -10 154.6
>>>>>>>>>> 2012 214  3   3.7  391. 132    -9 154.6
>>>>>>>>>> 2012 214  4   4.2  399. 132    -7 154.6
>>>>>>>>>> 2012 214  5   4.1  411. 132    -6 154.6
>>>>>>>>>> 2012 214  6   4.0  407. 132    -6 154.6
>>>>>>>>>> 2012 214  7   4.2  404. 132    -4 154.6
>>>>>>>>>> 2012 214  8   4.3  405. 132    -6 154.6
>>>>>>>>>> 2012 214  9   4.4  409. 132    -6 154.6
>>>>>>>>>> 2012 214 10   4.4  401. 132    -6 154.6
>>>>>>>>>> 2012 214 11   4.5  385. 132    -7 154.6
>>>>>>>>>> 2012 214 12   4.7  377. 132    -8 154.6
>>>>>>>>>> 2012 214 13   4.7  382. 132    -6 154.6
>>>>>>>>>> 2012 214 14   4.3  396. 132    -4 154.6
>>>>>>>>>> 2012 214 15   4.1  384. 132    -2 154.6
>>>>>>>>>> 2012 214 16   4.0  382. 132    -1 154.6
>>>>>>>>>> 2012 214 17   3.9  397. 132     0 154.6
>>>>>>>>>> 2012 214 18   3.8  390. 132     1 154.6
>>>>>>>>>> 2012 214 19   4.2  400. 132     2 154.6
>>>>>>>>>> 2012 214 20   4.6  408. 132     1 154.6
>>>>>>>>>> 2012 214 21   4.8  401. 132    -3 154.6
>>>>>>>>>> 2012 214 22   4.9  395. 132    -5 154.6
>>>>>>>>>> 2012 214 23   5.0  386. 132    -1 154.6
>>>>>>>>>> 2012 215  0   5.0  377. 143    -1 138.6
>>>>>>>>>> 2012 215  1   4.9  384. 143    -2 138.6
>>>>>>>>>> 2012 215  2   4.9  390. 143    -4 138.6
>>>>>>>>>> 2012 215  3   4.9  372. 143    -6 138.6
>>>>>>>>>> 2012 215  4   5.1  371. 143    -4 138.6
>>>>>>>>>> I want to process it to be of the format as shown below
>>>>>>>>>>       y   m  d  hr imf  sws  ssn    Dst f10.7
>>>>>>>>>> 2012-08-01 10 3.4  403. 132    -9 154.6
>>>>>>>>>> 2012-08-01 12 3.7  388. 132   -10 154.6
>>>>>>>>>> 2012-08-01 15 3.7  383. 132   -10 154.6
>>>>>>>>>> 2012-08-01 17 3.7  391. 132    -9 154.6
>>>>>>>>>> I want to request an R code to accomplish this task. Thanks for
>> your
>>>>>>>>> time.
>>>>>>>>>> *Jibrin Adejoh Alhassan (Ph.D)*
>>>>>>>>>> Department of Physics and Astronomy,
>>>>>>>>>> University of Nigeria, Nsukka
>>>>>>>>>>
>>>>>>>>>>           [[alternative HTML version deleted]]
>>>>>>>>>>
>>>>>>>>>> ______________________________________________
>>>>>>>>>> R-help using 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.
>>>>>>>>> Hello,
>>>>>>>>>
>>>>>>>>> To create a date column, paste the first two columns and coerce to
>>>>>>> class
>>>>>>>>> "Date" with conversion specifications %Y for the 4 digit year and
>> %j
>>>>>>> for
>>>>>>>>> the day of year. See
>>>>>>>>>
>>>>>>>>> help("strptime")
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> df1 <- read.table(text = "YEAR DOY HR   IMF  SW   SSN    Dst f10.7
>>>>>>>>> 2012 214  0   3.4  403. 132    -9 154.6
>>>>>>>>> 2012 214  1   3.7  388. 132   -10 154.6
>>>>>>>>> 2012 214  2   3.7  383. 132   -10 154.6
>>>>>>>>> 2012 214  3   3.7  391. 132    -9 154.6
>>>>>>>>> 2012 214  4   4.2  399. 132    -7 154.6
>>>>>>>>> 2012 214  5   4.1  411. 132    -6 154.6
>>>>>>>>> 2012 214  6   4.0  407. 132    -6 154.6
>>>>>>>>> 2012 214  7   4.2  404. 132    -4 154.6
>>>>>>>>> 2012 214  8   4.3  405. 132    -6 154.6
>>>>>>>>> 2012 214  9   4.4  409. 132    -6 154.6
>>>>>>>>> 2012 214 10   4.4  401. 132    -6 154.6
>>>>>>>>> 2012 214 11   4.5  385. 132    -7 154.6
>>>>>>>>> 2012 214 12   4.7  377. 132    -8 154.6
>>>>>>>>> 2012 214 13   4.7  382. 132    -6 154.6
>>>>>>>>> 2012 214 14   4.3  396. 132    -4 154.6
>>>>>>>>> 2012 214 15   4.1  384. 132    -2 154.6
>>>>>>>>> 2012 214 16   4.0  382. 132    -1 154.6
>>>>>>>>> 2012 214 17   3.9  397. 132     0 154.6
>>>>>>>>> 2012 214 18   3.8  390. 132     1 154.6
>>>>>>>>> 2012 214 19   4.2  400. 132     2 154.6
>>>>>>>>> 2012 214 20   4.6  408. 132     1 154.6
>>>>>>>>> 2012 214 21   4.8  401. 132    -3 154.6
>>>>>>>>> 2012 214 22   4.9  395. 132    -5 154.6
>>>>>>>>> 2012 214 23   5.0  386. 132    -1 154.6
>>>>>>>>> 2012 215  0   5.0  377. 143    -1 138.6
>>>>>>>>> 2012 215  1   4.9  384. 143    -2 138.6
>>>>>>>>> 2012 215  2   4.9  390. 143    -4 138.6
>>>>>>>>> 2012 215  3   4.9  372. 143    -6 138.6
>>>>>>>>> 2012 215  4   5.1  371. 143    -4 138.6", header = TRUE)
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> with(df1, paste(YEAR, DOY)) |> as.Date(format = "%Y %j")
>>>>>>>>> #>  [1] "2012-08-01" "2012-08-01" "2012-08-01" "2012-08-01"
>>>>>>> "2012-08-01"
>>>>>>>>> #>  [6] "2012-08-01" "2012-08-01" "2012-08-01" "2012-08-01"
>>>>>>> "2012-08-01"
>>>>>>>>> #> [11] "2012-08-01" "2012-08-01" "2012-08-01" "2012-08-01"
>>>>>>> "2012-08-01"
>>>>>>>>> #> [16] "2012-08-01" "2012-08-01" "2012-08-01" "2012-08-01"
>>>>>>> "2012-08-01"
>>>>>>>>> #> [21] "2012-08-01" "2012-08-01" "2012-08-01" "2012-08-01"
>>>>>>> "2012-08-02"
>>>>>>>>> #> [26] "2012-08-02" "2012-08-02" "2012-08-02" "2012-08-02"
>>>>>>>>>
>>>>>>>>> # now create the column
>>>>>>>>> df1$Date <- with(df1, paste(YEAR, DOY)) |> as.Date(format = "%Y
>> %j")
>>>>>>>>> # remove the columns no longer needed
>>>>>>>>> df1 <- df1[-(1:2)]
>>>>>>>>> # relocate the new date column
>>>>>>>>> df1 <- df1[c(ncol(df1), 1:(ncol(df1) - 1L))]
>>>>>>>>> head(df1)
>>>>>>>>> #>         Date HR IMF  SW SSN Dst f10.7
>>>>>>>>> #> 1 2012-08-01  0 3.4 403 132  -9 154.6
>>>>>>>>> #> 2 2012-08-01  1 3.7 388 132 -10 154.6
>>>>>>>>> #> 3 2012-08-01  2 3.7 383 132 -10 154.6
>>>>>>>>> #> 4 2012-08-01  3 3.7 391 132  -9 154.6
>>>>>>>>> #> 5 2012-08-01  4 4.2 399 132  -7 154.6
>>>>>>>>> #> 6 2012-08-01  5 4.1 411 132  -6 154.6
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Hope this helps,
>>>>>>>>>
>>>>>>>>> Rui Barradas
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Este e-mail foi analisado pelo software antivírus AVG para
>> verificar
>>>> a
>>>>>>>>> presença de vírus.
>>>>>>>>> www.avg.com
>>>>>>>>>
>>>>>>>>
>>>>>>> Hello,
>>>>>>>
>>>>>>> There is an error in your new code:
>>>>>>>
>>>>>>>
>>>>>>> paste YEAR with DOY, not with HR.
>>>>>>>
>>>>>>>
>>>>>>> As for the rest, is your real data like the one you posted before?
>>>>>>> If it is then I don't see anything wrong with my (tested) solution.
>>>>>>>
>>>>>>>
>>>>>>> Hope this helps,
>>>>>>>
>>>>>>> Rui Barradas
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Este e-mail foi analisado pelo software antivírus AVG para verificar
>> a
>>>>>>> presença de vírus.
>>>>>>> www.avg.com
>>>>>>>
>>>>>>
>>>>>
>>>> Hello,
>>>>
>>>> I cannot reproduce any error. T is vectorized so I am not understanding
>>>> what you mean by the script only generated one data point.
>>>> Here is the same code ran on your new data set, the result is as
>> expected.
>>>> Note the output of str(). It days that the 1st column is of class "Date"
>>>> so it was created from YEAR and DOY and relocated to the 1st position.
>>>>
>>>> Can you post the output of your final df1? Please post
>>>>
>>>> head(df1)
>>>>
>>>>
>>>>
>>>> # new data
>>>> df1 <- read.table("~/rhelp.txt", header = TRUE)
>>>>
>>>> df1$Date <- with(df1, paste(YEAR, DOY)) |> as.Date(format = "%Y %j")
>>>> df1 <- df1[-(1:2)]
>>>> df1 <- df1[c(ncol(df1), 1:(ncol(df1) - 1L))]
>>>> str(df1)
>>>> #> 'data.frame':    436 obs. of  7 variables:
>>>> #>  $ Date : Date, format: "2012-01-01" "2012-01-01" ...
>>>> #>  $ HR   : int  0 1 2 3 4 5 6 7 8 9 ...
>>>> #>  $ IMF  : num  4 4.4 4.8 5.4 4.5 4.2 4.7 4.1 3.2 4.3 ...
>>>> #>  $ SWS  : num  379 386 380 374 369 368 367 361 362 367 ...
>>>> #>  $ SSN  : int  71 71 71 71 71 71 71 71 71 71 ...
>>>> #>  $ Dst  : int  -8 -3 -4 -5 -9 -7 -6 -10 -7 -3 ...
>>>> #>  $ f10.7: num  1000 1000 1000 1000 1000 ...
>>>> head(df1)
>>>> #>         Date HR IMF SWS SSN Dst f10.7
>>>> #> 1 2012-01-01  0 4.0 379  71  -8 999.9
>>>> #> 2 2012-01-01  1 4.4 386  71  -3 999.9
>>>> #> 3 2012-01-01  2 4.8 380  71  -4 999.9
>>>> #> 4 2012-01-01  3 5.4 374  71  -5 999.9
>>>> #> 5 2012-01-01  4 4.5 369  71  -9 999.9
>>>> #> 6 2012-01-01  5 4.2 368  71  -7 999.9
>>>>
>>>>
>>>> Hope this helps,
>>>>
>>>> Rui Barradas
>>>>
>>>>
>>>> --
>>>> Este e-mail foi analisado pelo software antivírus AVG para verificar a
>>>> presença de vírus.
>>>> www.avg.com
>>>>
>>>
>> Hello,
>>
>> So what's the error? Your output is identical to mine. If the output of
>> str(df1) is also identical to what I have posted, then everything works
>> as expected.
>>
>> Hope this helps,
>>
>> Rui Barradas
>>
>>
>> --
>> Este e-mail foi analisado pelo software antivírus AVG para verificar a
>> presença de vírus.
>> www.avg.com
>>
> 
Hello,

"2012-06-27" is YEAR == 2012 and DOY == 179.
If that's what you have in the file then there's nothing wrong with that 
output.

And in your last post the df starts in row 4288, is this the problem? 
The code works, so there must be something with the data.

Hope this helps,

Rui Barradas


-- 
Este e-mail foi analisado pelo software antivírus AVG para verificar a presença de vírus.
www.avg.com



More information about the R-help mailing list