Retrieving data in a cell using using row and column name in R

Question

I am able to retrieve a cell value when using index of the column and row, but when I use the actual names, its returning NA for some reason. 9520.700195 is the actual value in the cell and its also what I get when I use [2,2].

here's the code.

stock_data = read.table("/Users/elisabethlussier-arpin/Documents/Besancon/R/real estate/Core RE/s&p_tsx_yreturn.csv", sep=",", header=TRUE)


index_begg = stock_data[ "2000-04-01" ,"Open"] #---> gives NA

index_begg = stock_data[ 2 ,2] #---->works

DPH · Accepted Answer · 2025-07-20 00:17:21Z

5

You can select the columns by name just like you did with "OPEN".

But to select rows you need to get the index that corresponds to your condition.

Here is a simple example inspired by what you supplied:

df <- data.frame(date = c("2000-04-01","2000-04-02","2000-04-03"),
                 OPEN = c(TRUE, FALSE, TRUE))

        date  OPEN
1 2000-04-01  TRUE
2 2000-04-02 FALSE
3 2000-04-03  TRUE

# select by generatin the index on your condition of date
df[df$date == "2000-04-01", "OPEN"]

[1] TRUE

Note that I formatted date as text in this example

edited Jul 20 at 0:17

answered Nov 9, 2020 at 17:54

DPH

4,3991 gold badge10 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrieving data in a cell using using row and column name in R

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related