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 Jon
21 months ago by
Jon • 160
United States
Jon • 160 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 • 3.4k views
ADD COMMENT • link •
modified 21 months ago by andrew.j.skelton73 ♦ 5.9k • written 21 months ago by Jon • 160
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 21 months ago by michael.ante • 3.5k

This helped, Thank you so much

ADD REPLY • link written 21 months ago by Jon • 160
1
gravatar for andrew.j.skelton73
21 months ago by
andrew.j.skelton73 ♦ 5.9k
London
andrew.j.skelton73 ♦ 5.9k 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 21 months ago • written 21 months ago by andrew.j.skelton73 ♦ 5.9k

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 21 months ago by Jon • 160
1

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

ADD REPLY • link written 21 months ago by andrew.j.skelton73 ♦ 5.9k

tidyverse way is to use readxl. See here

ADD REPLY • link written 21 months ago by russhh • 4.9k
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: 879 users visited in the last hour