Convert a table without any col and row name created from a matrix to data frame

Question

I wrote a code for my matrix that I want to create

tstp<-matrix(1:200, ncol = 4, byrow = TRUE)

And then I wrote this code to get my required format

write.table(tstp, row.names = FALSE, col.names = FALSE, quote = FALSE, sep = "\t")

I am here presenting the first four rows. The out is like that

1   2   3   4
5   6   7   8
9   10  11  12
13  14  15  16

It is my required output if its class will be data frame. So I wrote a code to convert it into data frame that is given as

> timestp<-data.frame(tstp)

And the output from the code has created the column names and row number that are not required as shown below.

> timestp
  X1 X2 X3 X4
1  1  2  3  4
2  5  6  7  8
3  9 10 11 12
4 13 14 15 16

its produced the class that I need

> class(timestp)
[1] "data.frame"

But I want output like given below with class of data.frme

1   2   3   4
5   6   7   8
9   10  11  12
13  14  15  16

score 2 · Answer 1 · answered May 28 '17 at 00:35

You can do this:

rownames(timestp) <- NULL
colnames(timestp) <- NULL

or if you only want to exclude row names, then use this:

timestp<-data.frame(tstp, row.names = NULL)

However, when you print it will show the numbers (as indices, not names). Refer to "Removing display of R row names from data frame".

You have successfully removed the rownames. The print.data.frame method just shows the row numbers if no rownames are present.

If you want to exclude the row numbers while printing then this will help you:

print(timestp, row.names = FALSE)

This will be the output:

> print(head(timestp), row.names = FALSE)

 # 1  2  3  4
 # 5  6  7  8
 # 9 10 11 12
 # 13 14 15 16
 # 17 18 19 20
 # 21 22 23 24

my main question was removing the column names. as he produced as X1 X2 X3 X4 when changing it into data frame — Mohsin Waqas, May 28 '17 at 00:50
@MohsinWaqas `colnames(timestp) <- NULL` this does what you want. Take a look at the sample output. Your main question is not reflected through your question. Glad that you have your answer anyways. GL. — M--, May 28 '17 at 01:55

score 2 · Accepted Answer · answered May 28 '17 at 01:11

2

We can use as.data.frame with optional parameter set to TRUE

timestp <- as.data.frame(tstp, optional = TRUE)

colnames(df)
#NULL

answered May 28 '17 at 01:11

Ronak Shah

2 Answers2