CODEWITHSUNDEEP
rintervals
RFA_
RFA_

Reputation: 37

How to make a new variable that assigns a numeric variable to intervals of 1000 units. R

In a dataframe I have the variable position that ranges from 0 to 2.7M.

I want to create a new variable bin that takes the value of position and it assigns it to intervals of 1000:

position bin
128 1000
333 1000
2900 3000
4444 5000

I have looked at previous questions and couldn't find a solution.

Thanks in advance.

Upvotes: 2

Views: 150

Answers (3)

AndrewGB
AndrewGB

Reputation: 16836

You could use cut:

library(dplyr)

bin_size <- 1000
bin_seq <- seq(0, ceiling(max(df$position)/bin_size)*bin_size, bin_size)

df %>%
  mutate(bin = cut(
    position,
    bin_seq,
    include.lowest = TRUE,
    labels = bin_seq[-1]
  ))

Output

  position  bin
1      128 1000
2      333 1000
3     2900 3000
4     4444 5000

Data

df <-structure(list(position = c(128L, 333L, 2900L, 4444L)), class = "data.frame", row.names = c(NA, 
-4L))

Upvotes: 2

Allan Cameron
Allan Cameron

Reputation: 173793

You can do

bin <- 1000 * ceiling(position / 1000)

Upvotes: 1

Martin Gal
Martin Gal

Reputation: 16978

You could use

df$bin_2 <- (df$position %/% 1000 + 1) * 1000

Upvotes: 1

Related Questions