Extract Single Column as DataFrame in R

In this article, we will see how a single column can be extracted as Dataframe using R programming language.

Database in use:

Data Frame GFG

Method 1: Extract Data from Data Frame using column name

In this method, a specific column can be extracted from the dataframe using its name using $.

Syntax:

dataframe$column_name

The column returned will be in a form of a vector, but it can be converted to a dataframe explicitly using data.frame() function of R language.

Example:

Output 

Here, we can see that two columns are extracted Name & Salary

Method 2: Extract Data from Data Frame using square bracket

The column can also be extracted as a dataframe using square brackets with an index of the column in the dataframe given to it as input.

Example:

Output

Display the 1st and 2nd column

Method 3: Extract Single Column as DataFrame 

 We extract columns as a vector from an R data frame, but sometimes we might need a column as a data frame. Thus, we can use as.data.frame to extract columns that we want to extract as a data frame with single square brackets. The purpose behind this could be merging the column with another data frame.

Example:

Output

Extracting 2nd column as a separate data frame

Extracting 3rd column as a separate data frame

Method 4: Extract Single Variable as Data Frame Using drop Argument

If the drop argument is provided with the value FALSE the columns are not converted to vector objects.

Example:

Output 

Displaying the 1st and 2nd column

yashisrivastav

Follow

Improve

Article Tags :

• R Language
• R Programs
• R DataFrame-Programs
• R-DataFrame