Choose Specific Columns of a Data Frame in R Programming - select() Function

Read CSV file and select specific rows and columns in R

Last Updated : 20 May, 2021

In this article, we are going to see how to read CSV file and select specific rows and columns in R Programming Language.

CSV file:

To import a CSV file into the R environment we need to use a pre-defined function called read.csv(). Pass filename.csv as a parameter within quotations. First, we need to set the path to where the CSV file is located using setwd( ) otherwise we can pass the full path of the CSV file into read.csv( ) as a parameter.

Example 1: Selecting specific multiple rows

R

df = read.csv('C:/Users/KRISHNA KARTHIKEYA/Documents/item.csv')

a = df[c(2, 7),]
print(a)

Output :

Explanation :

In the first step, we have imported a CSV file into the R environment using read.csv( ) function.
In the next step, we have selected 2,7 rows from CSV file using indexing and storing the result into a variable

Example 2: Selecting specific single rows

R

df = read.csv('C:/Users/KRISHNA KARTHIKEYA/Documents/item.csv')
a = df[ 2, ]
print(a)

Output :

Example 3: Selecting multiple columns

R

df = read.csv('C:/Users/KRISHNA KARTHIKEYA/Documents/item.csv')
a = df[, c(3 , 4)]
print(a)

Output :

Choose Specific Columns of a Data Frame in R Programming - select() Function

krishnakarthikeyakhandrika

Improve

Article Tags :

Similar Reads

How to read Excel file and select specific rows and columns in R?

In this article, we will discuss how to read an Excel file and select specific rows and columns from it using R Programming Language. File Used: To read an Excel file into R we have to pass its path as an argument to read_excel() function readxl library. Syntax: read_excel(path) To select a specific

Choose Specific Columns of a Data Frame in R Programming - select() Function

select() function in R Language is used to choose whether a column of the data frame is selected or not. Syntax: select(x, expr) Parameters: x: Data frame expr: condition for selection Example 1: Python3 1== # R program to select specific columns # Loading library library(dplyr) # Create a data fram

Import Only Selected Columns of Data from CSV in R

In this article, we will be looking at two different approaches to import selected columns of the Data from a CSV file in the R programming language. Method 1: Using read.table() function In this method of only importing the selected columns of the CSV file data, the user needs to call the read.tabl

Read text File with Space as Delimiter in R

In this article, we will discuss how to read a text file with spaces as delimiters in R programming language. Base R allows us to read and access the content within the text files with any number of characters as the delimiter.Â File in use:Â The read.table() method in R can be used to read data fro

Specify Row Names when Reading Excel File in R

In this article, we are going to specify the row names when reading Excel file in the R Programming language. Specifying row names when reading a file using row.names argument of the read.xlsx2() function. This is the easiest approach to specify the row names when reading a file in the R programming

Select Subset of DataTable Columns in R

In this article, we will discuss how to select a subset of data table columns in R programming language. Let's create a data table using a matrix. First, we need to load data.table package in the working space. Installation install.packages("data.table") Â Â Â Â Â Â Â Â Â Â Â Â Â Loading library("dat

Filtering row which contains a certain string using Dplyr in R

In this article, we will learn how to filter rows that contain a certain string using dplyr package in R programming language. Functions Used Two main functions which will be used to carry out this task are: filter(): dplyr package's filter function will be used for filtering rows based on condition

DataFrame Rows & Column Segment in R

The process of extracting the row and column information in a dataset by simply using the index or slice operator is known as Slicing. In R Programming, the rows and columns can be sliced in two ways either by using an index or using the name of the row and column. The slice operator is much more us

Filter or subsetting rows in R using Dplyr

In this article, we are going to filter the rows from dataframe in R programming language using Dplyr package. Dataframe in use: Method 1: Subset or filter a row using filter() To filter or subset row we are going to use the filter() function. Syntax: filter(dataframe,condition) Here, dataframe is t

Convert an Excel column into a list of vectors in R

In this article, we will be discussing the different approaches to convert the Excel columns to vector in the R Programming language. File in use: Method 1: Using $-Operator with the column name In this method, we will be simply using the $-operator with the column name and the name of the data read