How to extract a column / row attribute from a table in R?

Question

Suppose that I have any generic table such as the following:

| Column 1 | Column 2 | Column 3 |
|----------|----------|----------|
| Row 1    |          |          |
| Row 2    |          |          |
| Row 3    |          |          |

How can I pull the row and columns into a vector in R without manually imputing them?

I tried c(table), where tableis the table name, but that didn´t give me the output I expected. I´m looking for the output of a vector containing, c(Row 1, Row 2, Row 3,...), in addition a vector containing c(Column 1, Column 2, Column 3,...).

I saw Converting a dataframe to a vector (by rows), but it creates a vector such as Column 1, Row 1, Column 2, Row 2 or vice versa, while I am looking for two seperate vectors.

Possible duplicate of Converting a dataframe to a vector (by rows) — nghauran
– nghauran, Commented Jun 18, 2018 at 7:23
@ang I saw that, but I am looking for two separate vectors, one for the column and one for the row. That creates the vector for the column AND the row. — MichaelLink
– MichaelLink, Commented Jun 18, 2018 at 7:24
Please provide a real R object and exactly what the output would look like in R. What you're describing could perhaps be done using indexing ($, [) with a combination of rownames or colnames. — Roman Luštrik
– Roman Luštrik, Commented Jun 18, 2018 at 7:27
Do you mean a couple of vector with column names and row names? Maybe it is going to fit colnames(data) and rownames(data). — s__
– s__, Commented Jun 18, 2018 at 7:29

nghauran · Accepted Answer · 2018-06-18 07:35:37Z

1

Try this

data(iris)
df <- iris[, 1:4]
head(df) # have a look at df

rows.vec <- as.vector(t(df)) # first vector for rows
cols.vec <- as.vector(unlist(df)) # second vector for columns

answered Jun 18, 2018 at 7:35

nghauran

6,7982 gold badges23 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

How to extract a column / row attribute from a table in R?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related