library(dplyr)
## 
## Attaching package: 'dplyr'
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library("readxl")

# Imputed data
df <- read_excel("D:/Research/REFERENCES/Statistic/Network analysis/PROJECT/Data/Amelia imputed data.xlsx",sheet = "BS")
## New names:
## * `` -> ...1
## * `PANSS-P-TO...5` -> `PANSS-P-TO`
## * `PANSS-N-TO...6` -> `PANSS-N-TO`
## * `PANSS-G-TO...7` -> `PANSS-G-TO`
## * `BCSS-NS...9` -> `BCSS-NS`
## * ... and 6 more problems
df1 <- read_excel("D:/Research/REFERENCES/Statistic/Network analysis/PROJECT/Data/Amelia imputed data.xlsx",sheet = "TM")
## New names:
## * `` -> ...1
## * `PANSS-P-TO...16` -> `PANSS-P-TO`
## * `PANSS-N-TO...17` -> `PANSS-N-TO`
## * `PANSS-G-TO...18` -> `PANSS-G-TO`
## * `BCSS-NS...20` -> `BCSS-NS`
## * ... and 6 more problems
BS = df%>%select(c(2:12))
TM = df1%>%select(c(2:12))

BLR= df%>%select(c(2:12),RS)%>%filter(.$RS=="Low")%>%.[,-12]
BHR= df%>%select(c(2:12),RS)%>%filter(.$RS=="High")%>%.[,-12]
THR= df1%>%select(c(2:12),RS2)%>%filter(.$RS2=="High")%>%.[,-12]
TLR= df1%>%select(c(2:12),RS2)%>%filter(.$RS2=="Low")%>%.[,-12]

R Markdown

This is an R Markdown document. Markdown is a simple formatting syntax for authoring HTML, PDF, and MS Word documents. For more details on using R Markdown see http://rmarkdown.rstudio.com.

When you click the Knit button a document will be generated that includes both content as well as the output of any embedded R code chunks within the document. You can embed an R code chunk like this:

summary(cars)
##      speed           dist       
##  Min.   : 4.0   Min.   :  2.00  
##  1st Qu.:12.0   1st Qu.: 26.00  
##  Median :15.0   Median : 36.00  
##  Mean   :15.4   Mean   : 42.98  
##  3rd Qu.:19.0   3rd Qu.: 56.00  
##  Max.   :25.0   Max.   :120.00

Including Plots

You can also embed plots, for example:

Note that the echo = FALSE parameter was added to the code chunk to prevent printing of the R code that generated the plot.