Latest
Open
RNA-Seq
ChIP-Seq
SNP
Assembly
Tutorials
Tools
Jobs
Forum
Planet
All »
Home
Log In
Question: How to overcome "duplicate row.names" error while importing tpm/count/fpkm matrix/table in R ?
0
gravatar for sciencer
6 months ago by
sciencer • 60
sciencer • 60 wrote:

HI,

I used RSEM to produce TPM matrix for 100 RNA seq reads (row names= gene, columns are cell number) I get the following error, can anyone help me please!

> all <-read.table(file="tpm_matrix.xls",header=T)
Error in read.table(file = "tpm_matrix.xls", header = T) : 
  duplicate 'row.names' are not allowed

I changed the format of row names from "gene10000_Ermap" to "Ermap".
rna-seq R software error • 1.0k views
ADD COMMENT • link •
modified 6 months ago by andrew.j.skelton73 ♦ 5.3k • written 6 months ago by sciencer • 60
1

If your file is rather a text file but no MS xls, you can use cut -f 1 tpm_matrix.xls | sort | uniq -c | sort -k1,1nr to find the duplicated row names. If there are only a few, you'll curate that manually; if you have a lot, you can use e.g. awk to add a consecutive number to the name.

ADD REPLY • link written 6 months ago by michael.ante • 2.6k

This helped, Thank you so much

ADD REPLY • link written 6 months ago by sciencer • 60
1
gravatar for andrew.j.skelton73
6 months ago by
andrew.j.skelton73 ♦ 5.3k
London
andrew.j.skelton73 ♦ 5.3k wrote:
library(gdata)
data.in <- read.xls("tpm_matrix.xls")

read.table is trying to create a matrix, and as you've observed duplicate row names aren't allowed. You can get around this by importing it as a data frame.

Disclaimer: Untested, and probably a Tidyverse way to do it now instead of openxlsx...

ADD COMMENT • link modified 6 months ago • written 6 months ago by andrew.j.skelton73 ♦ 5.3k

Hi, Thanks but I get the following error!

data.in <- read.xlsx("tpm_matrix.xlsx")
Error in file(con, "r") : invalid 'description' argument
In addition: Warning message:
In unzip(xlsxFile, exdir = xmlDir) : error 1 in extracting from zip file
ADD REPLY • link written 6 months ago by sciencer • 60
1

I've edited my OP - assumed it was an xlsx file, not xls... my bad.

ADD REPLY • link written 6 months ago by andrew.j.skelton73 ♦ 5.3k

tidyverse way is to use readxl. See here

ADD REPLY • link written 6 months ago by russhh • 3.8k
Please log in to add an answer.

Similar posts • Search »

Content
Help
Access
Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1814 users visited in the last hour