Skip to content
Prev 392508 / 398502 Next

Getting minimum value of a column according a factor column of a dataframe

Hi Javad,
In that case, just modify the function to extract the rows with both
the minimum and maximum Q from each station

df1<-read.table(text="Code Y  M  D  Q  N  O
 41003 81 1 19 0.16 7.17 2.5
 41003 77 9 22 0.197 6.8 2.2
 41003 79 7 28 0.21 4.7 6.2
 41005 79 8 17 0.21 5.5 7.2
 41005 80 10 30 0.21 6.84 2.6
 41005 80 12 20 0.21 6.84 2.4
 41005 79 6 14 0.217 5.61 3.55
 41009 79 2 21 0.218 5.56 4.04
 41009 79 5 27 0.218 6.4 3.12
 41009 80 11 29 0.22 6.84 2.8
 41009 78 5 28 0.232 6 3.2
 41009 81 8 20 0.233 6.39 1.6
 41009 79 9 30 0.24 5.6 7.5
 41017 79 10 20 0.24 5.3 7.1
 41017 80 7 30 0.24 6.73 2.6",
 stringsAsFactors=FALSE,header=TRUE)

# define a function that returns the desired rows
minmaxQrow<-function(x) return(x[c(which.min(x$Q),which.max(x$Q)),])
# apply the function to the data frame
df1a<-by(df1,df1$Code,minmaxQrow)
# set the result to the first element of the list
df1b<-df1a[[1]]
# rbind the remaining rows
for(i in 2:length(df1a)) df1b<-rbind(df1b,df1a[[i]])
# display the result
df1b

Jim
On Fri, Aug 26, 2022 at 5:25 AM javad bayat <j.bayat194 at gmail.com> wrote:

Thread (25 messages)

javad bayat Getting minimum value of a column according a factor column of a dataframe Aug 24 Ebert,Timothy Aaron Getting minimum value of a column according a factor column of a dataframe Aug 24 @vi@e@gross m@iii@g oii gm@ii@com Getting minimum value of a column according a factor column of a dataframe Aug 24 Rui Barradas Getting minimum value of a column according a factor column of a dataframe Aug 24 javad bayat Getting minimum value of a column according a factor column of a dataframe Aug 24 Rui Barradas Getting minimum value of a column according a factor column of a dataframe Aug 25 javad bayat Getting minimum value of a column according a factor column of a dataframe Aug 25 Ebert,Timothy Aaron Getting minimum value of a column according a factor column of a dataframe Aug 25 Rui Barradas Getting minimum value of a column according a factor column of a dataframe Aug 25 Ebert,Timothy Aaron Getting minimum value of a column according a factor column of a dataframe Aug 25 Ebert,Timothy Aaron Getting minimum value of a column according a factor column of a dataframe Aug 25 @vi@e@gross m@iii@g oii gm@ii@com Getting minimum value of a column according a factor column of a dataframe Aug 25 Rui Barradas Getting minimum value of a column according a factor column of a dataframe Aug 25 Ebert,Timothy Aaron Getting minimum value of a column according a factor column of a dataframe Aug 25 Bill Dunlap Getting minimum value of a column according a factor column of a dataframe Aug 25 @vi@e@gross m@iii@g oii gm@ii@com Getting minimum value of a column according a factor column of a dataframe Aug 25 @vi@e@gross m@iii@g oii gm@ii@com Getting minimum value of a column according a factor column of a dataframe Aug 25 Bert Gunter Getting minimum value of a column according a factor column of a dataframe Aug 25 javad bayat Getting minimum value of a column according a factor column of a dataframe Aug 25 Jim Lemon Getting minimum value of a column according a factor column of a dataframe Aug 25 @vi@e@gross m@iii@g oii gm@ii@com Getting minimum value of a column according a factor column of a dataframe Aug 25 Rui Barradas Getting minimum value of a column according a factor column of a dataframe Aug 25 javad bayat Getting minimum value of a column according a factor column of a dataframe Aug 25 @vi@e@gross m@iii@g oii gm@ii@com Getting minimum value of a column according a factor column of a dataframe Aug 25 Ebert,Timothy Aaron Getting minimum value of a column according a factor column of a dataframe Aug 26