Hello Rui,
Thanks for your kind and unrelenting help. The code works actually. I will
see what to do to sort things out. Please, accept my indebtedness.
*Jibrin Adejoh Alhassan (Ph.D)*
Department of Physics and Astronomy,
University of Nigeria, Nsukka
On Mon, Jun 17, 2024 at 8:53 PM Rui Barradas <ruipbarra...@sapo.pt> wrote:
> À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 <ruipbarra...@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 <ruipbarra...@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.alhas...@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 <ruipbarra...@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 <
> ruipbarra...@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@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
>
[[alternative HTML version deleted]]
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
