R Program to extract 3rd and 5th rows with 1st and 3rd columns from a given data frame


May 6, 2022, Learn eTutorial
1308

How to extract specified rows with specified columns from a given data frame

Here we are explaining how to write an R program to extract 3rd and 5th rows with 1st and 3rd columns from a given data frame. Here we are using a built-in function data.frame() for this. A data frame is used for storing data tables which has a list of vectors with equal length. The data frames are created by function data.frame(), which has tightly coupled collections of variables. The syntax of this function is, 



data.frame(…, row.names = NULL, check.rows = FALSE,check.names = TRUE, fix.empty.names = TRUE,stringsAsFactors = default.stringsAsFactors()) 

Where dots(...) indicates the arguments are of either the form value or tag = value and row. name is a NULL or a single integer or character string.

How to extract 3rd and 5th rows with 1st and 3rd columns from a given data frame in the R program

Below are the steps used in the R program to extract 3rd and 5th rows with 1st and 3rd columns from a given data frame. In this R program, we directly give the data frame to a built-in function. Here we are using variables E, N, S, A, Q for holding different types of vectors. Call the function data.frame() for creating dataframe. Finally, extract the specified rows with specified columns from a given data frame by calling like E[c(3,5),c(1,3)]

ALGORITHM

STEP 1: Assign variables E,N,S,A,Q with vector values 

STEP 2: First print original vector values

STEP 3: Extract the 3rd and 5th rows with 1st and 3rd columns from a given data frame as E[c(3,5),c(1,3)]

STEP 4: Assign variable result with the result 

STEP 5: print the variable result which holding the result 

R Source Code

                                          E = data.frame(
N = c('Jhon', 'Hialy', 'Albert', 'James', 'Delma'),
S = c(10, 9.5, 12.2, 11, 8),
A = c(2, 1, 2, 4, 1),
Q = c('yes', 'no', 'yes', 'no', 'no')
)
print("Original dataframe:")
print(E)
print("Extract 3rd and 5th rows with 1st and 3rd columns :")
result =  E[c(3,5),c(1,3)]
print(result)
                                      

OUTPUT

[1] "Original dataframe:"
     name    score attempts qualify
1  Jhon       10        2     yes
2  Hialy      9.5       1     no
3  Albert     12.2      2     yes
4  James      11        4     no
5  Delma      8         1     no

[1] "Extract 3rd and 5th rows with 1st and 3rd columns:"
       name          attempts     
3      Albert            2           
5      Delma             1