DZone
Big Data Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Big Data Zone > Learn R: How to Extract Rows and Columns From Data Frame

Learn R: How to Extract Rows and Columns From Data Frame

This article represents command set in R programming language, which could be used to extract rows and columns from a given data frame.

Ajitesh Kumar user avatar by
Ajitesh Kumar
CORE ·
Dec. 08, 14 · Big Data Zone · Tutorial
Like (5)
Save
Tweet
1.06M Views

Join the DZone community and get the full member experience.

Join For Free

This article represents a command set in the R programming language, which can be used to extract rows and columns from a given data frame. When working on data analytics or data science projects, these commands come in handy in data cleaning activities. This article is meant for beginners/rookies getting started with R who want examples of extracting information from a data frame. Please feel free to comment/suggest if I missed mentioning one or more important points.

The following are the key points described later in this article:

  • Commands to extract rows and columns.
  • Command to extract a column as a data frame.
  • Command to extract an element.

Suppose you have a data frame, df, which is represented as follows. Below we've created a data frame consisting of three vectors that include information such as height, weight, and age.

df <- data.frame( c( 183, 85, 40), c( 175, 76, 35), c( 178, 79, 38 ))
names(df) <- c("Height", "Weight", "Age")

Commands to Extract Rows and Columns

The following represents different commands which could be used to extract one or more rows with one or more columns. Note that the output is extracted as a data frame. This could be checked using the class command.

# All Rows and All Columns
df[,]

# First row and all columns
df[1,]

# First two rows and all columns
df[1:2,]

# First and third row and all columns
df[ c(1,3), ]

# First Row and 2nd and third column
df[1, 2:3]

# First, Second Row and Second and Third COlumn
df[1:2, 2:3]

# Just First Column with All rows
df[, 1]

# First and Third Column with All rows
df[,c(1,3)]

Command to Extract a Column as a Data Frame

The following represents a command which can be used to extract a column as a data frame. If you use a command such as df[,1], the output will be a numeric vector (in this case). To get the output as a data frame, you would need to use something like below.

# First Column as data frame
as.data.frame( df[,1], drop=false)

Command to Extract an Element

The following represents a command which could be used to extract an element in a particular row and column. It is as simple as writing a row and a column number, such as the following:

# Element at 2nd row, third column
df[2,3]
Data science R (programming language) Extract Column (database) Frame (networking) Row (database) Command (computing)

Published at DZone with permission of Ajitesh Kumar, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Top 20 Git Commands With Examples
  • Implementing HIPAA Technical Safeguards in Your API Platform
  • How BDD Works Well With EDA
  • Legacy Modernization and Hybrid Cloud with Kafka in Healthcare

Comments

Big Data Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo