R building a subset based on value in previous row -

-

i have problem figuering out: suppose how data looks like:

num condition     y 1     1 2     2 3     3 4   b   4 5   b   5 6   b   6 7   c   7 8   c   8 9   c   9 10  b   10 11  b   11 12  b   12

i want make calculation (e.g., mean) on b, depending on whether value in row before b, in example or c? help!!! angelika

is want?

# in order separate between different runs of condition 'b', # length , value of runs of equal values of 'condition' rl <- rle(x = df$condition) df$run <- rep(x = seq_len(length(rl$lengths)), times = rl$lengths)  # calculate sum of y, on data grouped condition , run, , condition 'b' aggregate(y ~ condition + run, data = df, subset = condition == "b", sum)

Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more