PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Friday, October 7, 2022

[FIXED] How to find the values and the corresponding column of those values in a matrix in R

 October 07, 2022     combinations, matrix, r, statistics, vector     No comments   

Issue

So on a small scale, let's say I have 5 patients which are the rows of a matrix. In the columns, I have some information like age, sex etc. But the question is on some medications. so let's say I have 4 categorical medications. 1 means the patients received them and 0 otherwise. now for some patients I have this vector (1,1,?,?) meaning that the first two values SHOULD be 1 and I know them, but I don't know what are the "?" for each patient.

I assume it should be a matrix of 5 rows and at least 4 columns. now, how can I find the values of "?" for each row? Also, it is SO important to know that this value belongs to which treatment. (I'm not sure if this part of the question makes sense but I also want to know whether for example (1,1,0,1) was the most repeated combination or (1,1,0,0) was or ( 1,1,1,0) or...

I have almost zero knowledge on stat or math but here is the situation and I would appreciate if someone can explain how I can do it in R.


Solution

How about something like this, where n is the number of observations that have each pattern:

library(dplyr)
dat <- data.frame(patient = LETTERS[1:20], 
                d1 = 1, 
                d2 = 1, 
                d3 = sample(c(0,1), 20, replace=TRUE), 
                d4 = sample(c(0,1), 20, replace=TRUE))

dat %>% 
  group_by(d1, d2, d3, d4) %>% 
  tally()
#> # A tibble: 4 × 5
#> # Groups:   d1, d2, d3 [2]
#>      d1    d2    d3    d4     n
#>   <dbl> <dbl> <dbl> <dbl> <int>
#> 1     1     1     0     0     1
#> 2     1     1     0     1     6
#> 3     1     1     1     0     9
#> 4     1     1     1     1     4

Created on 2022-02-15 by the reprex package (v2.0.1)



Answered By - DaveArmstrong
Answer Checked By - Dawn Plyler (PHPFixing Volunteer)
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing