My post was apparently unclear, so I'm trying to fix it, don't hesitate to tell me if I'm still unclear!
I got a dataframe of physical variables, with a data every minute. I'd like to convert the 4 first columns into a single one: "%d/%m/%Y %H:%M" (GMT) in R.
Year    Julian_day  Hour    Minute  Air_temp    Water_temp  Rel_hum   Wind_int  Wind_dir
2012    1   0   0   11.82   4.73    87.2    5.1 310
2012    1   0   1   11.92   4.743   87.2    5   310
2012    1   0   2   11.86   4.748   86.9    4.7 310
# This imports your data into a variable named "weather"
weather <- read.table(text = "Year    Julian_day  Hour    Minute  Air_temp    Water_temp  Rel_hum   Wind_int  Wind_dir
2012    1   0   0   11.82   4.73    87.2    5.1 310
2012    1   0   1   11.92   4.743   87.2    5   310
2012    1   0   2   11.86   4.748   86.9    4.7 310", header = TRUE)
# Combine the first four columns into a character vector
date_info <- with(weather, paste(Year, Julian_day, Hour, Minute))
# Parse that character vector
strptime(date_info, "%Y %j %H %M")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With