How can I to categorize a timestamp column in an interval of 2 hours in R?
Eric Gomes
I need to categorize a column where the date is a DateTime field (timestamp) like the image below:
To do this, I need to create a new column in my DataFrame to receive the new data, where the result is a column categorized with interval 2 hours like the image above.
Result:
How can I do this?
Ronak Shah
You can use floor_date/ceiling_date from lubridate
library(dplyr)
library(lubridate)
df <- data.frame(time = Sys.time() + sample(100000, 10))
df %>%
mutate(interval = hour(floor_date(time, '2 hours')),
interval1 = paste(interval, interval + 2, sep = '-'),
interval2 = sprintf('[%d, %d)', interval, interval + 2, sep = '-'))
# time interval interval1 interval2
#1 2021-06-07 13:14:15 12 12-14 [12, 14)
#2 2021-06-07 14:57:42 14 14-16 [14, 16)
#3 2021-06-06 23:42:58 22 22-24 [22, 24)
#4 2021-06-07 07:11:57 6 6-8 [6, 8)
#5 2021-06-08 01:20:38 0 0-2 [0, 2)
#6 2021-06-07 17:51:25 16 16-18 [16, 18)
#7 2021-06-07 16:15:47 16 16-18 [16, 18)
#8 2021-06-07 11:29:56 10 10-12 [10, 12)
#9 2021-06-07 16:59:13 16 16-18 [16, 18)
#10 2021-06-07 11:47:07 10 10-12 [10, 12)
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
Related
TOP Ranking
- 1
pump.io port in URL
- 2
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 3
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 4
Double spacing in rmarkdown pdf
- 5
SQL Server : need add a dot before two last character
- 6
Ambiguous use of 'init' with CFStringTransform and Swift 3
- 7
Resetting Value of <input type="time"> in Firefox
- 8
Retrieve Element Tag Value XML Using Bash
- 9
How to pass data to the ng2-bs3-modal?
- 10
JWT gives JsonWebTokenError "invalid token"
- 11
How to update azerothcore-wotlk docker container
- 12
C++ 16 bit grayscale gradient image from 2D array
- 13
redirect your computer port to url
- 14
Capybara Selenium Chrome opens About Google Chrome
- 15
mysql.connector.errors.InterfaceError: 2003: Can't connect to MySQL server on '127.0.0.1:3306' (111 Connection refused)
- 16
How to make thrown errors visible outside of a Promise?
- 17
JMeter: Why get error when try to save test plan
- 18
Should you provide dependent libraries in client jar?
- 19
Issue making model pop up onPress of flatlist
- 20
Message: element not interactable on accessing a tag python
- 21
Calling Doctrine clear() with an argument is deprecated
Comments