How to delete the very first column-first row in R as per this shows in attached pic

Question

I have uploaded the excel file into the R environment when I view(data) then this shows like

this red circle has "...1" which is not actually in the excel sheet, so how to delete it in the R?

how did you load that file in Rstudio ? What is its extension ? — Benjamin Dupuis, Apr 26 '20 at 13:18

Michael Beck · Answer 1 · 2020-04-26T13:33:03.543

2

If you just want to rename the first column:

colnames(data)[1] <- ""

Otherwise you can either sett it to Null

data[1] <- NULL

... or subset the dataframe ...

data <- data[,-1]

... but there are lots of ways to do this.

edited Apr 26 '20 at 13:33

answered Apr 26 '20 at 13:21

Michael Beck

this is deleting the entire column, I want to delete only the first corner cell (inside the red circle); Moreover when I run the "heatmap" then "Error in sample.int(m, k) : vector size cannot be NA/NaN" showing – Suraj Kumar Bhagat Apr 26 '20 at 13:28
1

Rename the first col: `colnames(data)[1] – Michael Beck Apr 26 '20 at 13:31

score 2 · Answer 2 · answered Apr 26 '20 at 19:52

2

With tidyverse, we could use column_to_rownames from tibble

library(dplyr)
library(tibble)
df <- df %>%
        column_to_rownames(var = "...1")

answered Apr 26 '20 at 19:52

akrun

score 1 · Answer 3 · answered Apr 26 '20 at 13:38

1

You can add the first column as rowname and then delete the first column.

rownames(df) <- df[[1]]
df[, 1] <- NULL

answered Apr 26 '20 at 13:38

Ronak Shah

3 Answers3