Read CSV file and select specific rows and columns in R

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 :