Hello,
Thanks for the data, it makes things easier.
df1 <- read.table("Jibrin_data.txt", header = TRUE)
#'data.frame': 168 obs. of 4 variables:
# $ year: int 1998 1998 1998 1998 1998 1998 1998 1998 1998 1998 ...
# $ day : int 1 2 3 4 5 6 7 8 9 10 ...
# $ Hr : int 0 0 0 0 0 0 0 0 0 0 ...
# $ SWS : num 344 346 356 332 302 329 395 359 471 392 ...
Here is a simple way of converting the year and day of year columns to a
column of class "Date".
Like others have said, there are also CRAN packages to handle date/time
data, my favorite being package lubridate, but base R can do it.
df1$date <- as.Date(paste(df1$year, df1$day),
format = "%Y %j",
origin = "1998-01-01")
head(df1)
# year day Hr SWS date
#1 1998 1 0 344 1998-01-01
#2 1998 2 0 346 1998-01-02
#3 1998 3 0 356 1998-01-03
#4 1998 4 0 332 1998-01-04
#5 1998 5 0 302 1998-01-05
#6 1998 6 0 329 1998-01-06
Hope this helps,
Rui Barradas
Às 06:48 de 16/01/21, Jibrin Alhassan escreveu:
Hi Barradas
Sorry for the delay. Below is a section of my data. I have up to 1826
covering 1998 to 2002
year day Hr SWS
1998 1 0 344.
1998 2 0 346.
1998 3 0 356.
1998 4 0 332.
1998 5 0 302.
1998 6 0 329.
1998 7 0 395.
1998 8 0 359.
1998 9 0 471.
1998 10 0 392.
1998 11 0 346.
1998 12 0 387.
1998 13 0 393.
1998 14 0 367.
1998 15 0 320.
1998 16 0 309.
1998 17 0 341.
1998 18 0 329.
1998 19 0 322.
1998 20 0 429.
1998 21 0 433.
1998 22 0 398.
1998 23 0 393.
1998 24 0 393.
1998 25 0 423.
1998 26 0 426.
1998 27 0 429.
1998 28 0 386.
1998 29 0 381.
1998 30 0 375.
1998 31 0 365.
1998 32 0 450.
1998 33 0 381.
1998 34 0 316.
1998 35 0 351.
1998 36 0 306.
1998 37 0 312.
1998 38 0 320.
1998 39 0 339.
1998 40 0 395.
1998 41 0 429.
1998 42 0 479.
1998 43 0 495.
1998 44 0 407.
1998 45 0 358.
1998 46 0 360.
1998 47 0 382.
1998 48 0 394.
1998 49 0 393.
1998 50 0 435.
1998 51 0 408.
1998 52 0 360.
1998 53 0 372.
1998 54 0 376.
1998 55 0 379.
1998 56 0 361.
1998 57 0 333.
1998 58 0 321.
1998 59 0 344.
1998 60 0 412.
1998 61 0 428.
1998 62 0 401.
1998 63 0 369.
1998 64 0 343.
1998 65 0 330.
1998 66 0 317.
1998 67 0 296.
1998 68 0 282.
1998 69 0 404.
1998 70 0 530.
1998 71 0 525.
1998 72 0 484.
1998 73 0 430.
1998 74 0 388.
1998 75 0 347.
1998 76 0 337.
1998 77 0 342.
1998 78 0 305.
1998 79 0 329.
1998 80 0 420.
1998 81 0 564.
1998 82 0 483.
1998 83 0 385.
1998 84 0 393.
1998 85 0 437.
1998 86 0 441.
1998 87 0 434.
1998 88 0 471.
1998 89 0 429.
1998 90 0 412.
1998 91 0 370.
1998 92 0 326.
1998 93 0 357.
1998 94 0 338.
1998 95 0 380.
1998 96 0 339.
1998 97 0 312.
1998 98 0 313.
1998 99 0 327.
1998 100 0 362.
1998 101 0 358.
1998 102 0 387.
1998 103 0 397.
1998 104 0 375.
1998 105 0 350.
1998 106 0 357.
1998 107 0 472.
1998 108 0 526.
1998 109 0 396.
1998 110 0 374.
1998 111 0 376.
1998 112 0 355.
1998 113 0 343.
1998 114 0 425.
1998 115 0 426.
1998 116 0 479.
1998 117 0 469.
1998 118 0 425.
1998 119 0 344.
1998 120 0 341.
1998 121 0 426.
1998 122 0 601.
1998 123 0 476.
1998 124 0 670.
1998 125 0 585.
1998 126 0 496.
1998 127 0 479.
1998 128 0 569.
1998 129 0 531.
1998 130 0 489.
1998 131 0 484.
1998 132 0 480.
1998 133 0 393.
1998 134 0 332.
1998 135 0 327.
1998 136 0 493.
1998 137 0 493.
1998 138 0 430.
1998 139 0 396.
1998 140 0 408.
1998 141 0 416.
1998 142 0 376.
1998 143 0 375.
1998 144 0 415.
1998 145 0 407.
1998 146 0 398.
1998 147 0 352.
1998 148 0 349.
1998 149 0 517.
1998 150 0 597.
1998 151 0 480.
1998 152 0 435.
1998 153 0 408.
1998 154 0 441.
1998 155 0 397.
1998 156 0 374.
1998 157 0 413.
1998 158 0 582.
1998 159 0 513.
1998 160 0 459.
1998 161 0 466.
1998 162 0 414.
1998 163 0 354.
1998 164 0 341.
1998 165 0 343.
1998 166 0 369.
1998 167 0 411.
1998 168 0 355.
Thanks
Jibrin
On Fri, Jan 15, 2021 at 7:15 PM Rui Barradas <ruipbarra...@sapo.pt
<mailto:ruipbarra...@sapo.pt>> wrote:
Hello,
No dataset was attached. Like the posting guide says,
No binary attachments except for PS, PDF, and some image and archive
formats (others are automatically stripped off because they can contain
malicious software). Files in other formats and larger ones should
rather be put on the web and have only their URLs posted. This way a
reader has the option to download them or not.
Can you post sample data? Please post the output of `dput(df)`. Or, if
it is too big the output of `dput(head(df, 20))`. (`df` is the name of
your dataset.)
Hope this helps,
Rui Barradas
Às 11:30 de 15/01/21, Jibrin Alhassan escreveu:
> Dear R users,
> I am very new to R software. I have solar wind speed data needed
for my
> work. How do I convert day in the year to year, month, and day with R
> software? I have used this code
> as.Date(0, origin = "1998-01-01")
> but it can only convert one day of the year at a time. Meanwhile,
I have up
> to the 1998-2002 data set. Attached is my data.
> Kindly help, please.
> Jibrin Alhassan
> ______________________________________________
> R-help@r-project.org <mailto: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.
>
______________________________________________
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.
