The following examples are one of many data query options via RStudio:<\/p>\n
First, you will want to download the dplyr\u00a0<\/strong>package.\u00a0<\/span><\/span><\/p>\n Then type:\u00a0<\/span> Then give your object a name, in this case “applejack”:\u00a0<\/span><\/p>\n >applejack\u00a0\u00a0<-<\/strong> Actual name of your data table.<\/p>\n If you want to see all the names of the variables\/column headings, you have the option to type the following:\u00a0<\/span><\/p>\n >names<\/strong> (applejack)<\/p>\n Now give your object another name to query the column heading\/variables you want to select:<\/span><\/p>\n applejack1<\/strong><\/span><-select<\/strong>(applejack, variable1, variable2, variable3, variabl4, variable 5…….)<\/p>\n or<\/p>\n applejack1<\/strong><\/span><-select<\/strong>(applejack, variable1:variable19)<\/p>\n<\/blockquote>\n >applejack2<\/span><\/strong> <- filter<\/strong> (applejack1<\/strong><\/span>, Variable2==’Y’,variable5\u00a0 > 3.5 )<\/p>\n >applejack2<\/span><\/strong><\/p>\n Now you will see your queried data in upper right hand corner of your RStudio.\u00a0<\/span><\/p>\n _____________________________________________________________________________________<\/p>\n Another option is to utilize the\u00a0\u00a0dplyr\u00a0<\/strong> pipe function:\u00a0<\/span><\/span><\/span><\/p>\n >applejack %>% select<\/strong>(variable1, variable2, variable3, variabl4, variable5…….) %>% filter <\/strong>(Variable2==’Y’,variable5\u00a0 > 3.5)<\/p>\n applejack<\/p>\n or<\/p>\n >applejack %>% select<\/strong>(variable1:variable5…….) %>% filter <\/strong>(Variable2==’Y’,variable5\u00a0 > 3.5)<\/p>\n applejack<\/p>\n<\/blockquote>\n<\/blockquote>\n <\/p>\n If you want to arrange your selected\/generated data frame in certain order and want to see up to 20 rows information you are about to generate, you can use the following command:\u00a0<\/span><\/p>\n \u00a0<\/span>> applejack %>% arrange<\/strong>(variable1)%>%print<\/strong>(n=20)<\/p>\n ____________________________________________________________________________________<\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" The following examples are one of many data query options via RStudio: First, you will want to download the dplyr\u00a0package.\u00a0 Then type:\u00a0 >library(dplyr) Then give your object a name, in this case “applejack”:\u00a0 >applejack\u00a0\u00a0<- Actual name of your data table. If you want to see all the names of the variables\/column headings, you have the…<\/p>\n
\n>library(dplyr<\/strong>)<\/span><\/span><\/p>\n\n
\n
\n