Message-ID: <fc104a3c-6d2f-062a-d79e-42ec7c7811b3@sapo.pt>
Date: 2021-01-16T07:01:16Z
From: Rui Barradas
Subject: Converting "day of year" to "year", "month" and "day"
In-Reply-To: <CAEGeL+EFE5pfU_133h_j7d74maMaBDJEHoxe9QdiGxyBt5kgmA@mail.gmail.com>
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 <ruipbarradas at sapo.pt
> <mailto:ruipbarradas at 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 at r-project.org <mailto:R-help at r-project.org> mailing list
> -- To UNSUBSCRIBE and more, see
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> > and provide commented, minimal, self-contained, reproducible code.
> >
>