Roman Babeykin
Roman Babeykin

Reputation: 53

Calculationg median of observations in particular set of columns in R

I have an sf object containing the following columns of data:

HR60        HR70        HR80        HR90        HC60        HC70        HC80        HC90
0.000000    0.000000    8.855827    0.000000    0.0000000   0.0000000   0.3333333   0.0000000   
0.000000    0.000000    17.208742   15.885624   0.0000000   0.0000000   1.0000000   1.0000000   
1.863863    1.915158    3.450775    6.462453    0.3333333   0.3333333   1.0000000   2.0000000   
...

How can I calculate the median of HR60 to HR90 columns for all observations and place it in a different column, let's say HR-median? I tried to use apply(), but this kind of works for the whole dataset only and I need only these 4 columns to be considered.

Upvotes: 1

Views: 59

Answers (1)

akrun
akrun

Reputation: 887851

We can select those columns

df1$HR_median <- apply(subset(df1, select = HR60:HR90), 1, median)

Upvotes: 2

Related Questions