Open In App

Read CSV file and select specific rows and columns in R

Improve
Improve
Like Article
Like
Save
Share
Report

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 : 



Last Updated : 20 May, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads