How to count the total number of rows in specific range

[mhab]

Hi All,

I need some help here. I would like to count the number of value of specific range from my data set. For example like I would like to know how many rows in my dataset have the value of <10, >10, >20 etc.
Thank you for help
Here some dataset

Time	Value
0900	10
0901	-1
0902	50
0903	34
0904	33
0905	2
0906	67
0907	90

[FJCC]

The simplest solution for one value would be like the following. Will that work for you?

DF <- read.csv("~/R/Play/Dummy.csv", sep=" ")
DF
  Time Value
1  900    10
2  901    -1
3  902    50
4  903    34
5  904    33
6  905     2
7  906    67
8  907    90
sum(DF$Value > 10) 
[1] 5

[mhab]

Thank you for the code.
I have tried using the same code.
And its appear as 'NA'

How to resolve it please

[arthur.t]

Try this

library(tidyverse)
iris %>% 
  expand_grid(tibble(Min = seq(5, 7, .1), Max = Min + 0.1)) %>% 
  group_by(Min, Max) %>% 
  summarize(Sepal.Length.Count = sum((Sepal.Length > Min) & (Sepal.Length <= Max)), 
           .groups = "drop")

[arthur.t]

If there are missing values you want to ignore you need the na.rm = TRUE

library(tidyverse)
iris %>% 
  expand_grid(tibble(Min = seq(5, 7, .1), Max = Min + 0.1)) %>% 
  group_by(Min, Max) %>% 
  summarize(Sepal.Length.Count = sum((Sepal.Length > Min) & (Sepal.Length <= Max), na.rm = TRUE), 
           .groups = "drop")

[mhab]

@arthur.t

na.rm = TRUE

Alright, thanks..i solved it..I just need to add the 'na.rm=TRUE' to ignore the missing values.

Thank you very much