如何从列表列表中编辑 Dataframe 中行名称？

sdnqo3pr 于 2023-04-03 发布在其他

关注(0)|答案(3)|浏览(128)

我是R的新手（我试过搜索;对不起，如果这是重复在其他地方！），我需要一些帮助，请！我试图编辑行名称在一个数据。帧：我从几个vcf文件开始，使用lapply()创建一个列表列表，然后使用unlist()将列表展平，并将提取的指示符组合到一个 Dataframe 中，但最终得到以下结果：

> row.names(mydataframe)
  [1] "1_S1_annotated_filtered.vcf.gz1"   "1_S1_annotated_filtered.vcf.gz2"   "1_S1_annotated_filtered.vcf.gz3"   "1_S1_annotated_filtered.vcf.gz6"  
  [5] "1_S1_annotated_filtered.vcf.gz7"   "1_S1_annotated_filtered.vcf.gz8"   
... 
[457] "6_S6_annotated_filtered.vcf.gz877" "6_S6_annotated_filtered.vcf.gz888" "6_S6_annotated_filtered.vcf.gz907" "7_S7_annotated_filtered.vcf.gz309"
[461] "7_S7_annotated_filtered.vcf.gz354" "7_S7_annotated_filtered.vcf.gz477" "7_S7_annotated_filtered.vcf.gz485" "7_S7_annotated_filtered.vcf.gz537"
[465] "7_S7_annotated_filtered.vcf.gz569" "7_S7_annotated_filtered.vcf.gz575" "7_S7_annotated_filtered.vcf.gz721" "7_S7_annotated_filtered.vcf.gz871"
[469] "7_S7_annotated_filtered.vcf.gz892" "8_S8_annotated_filtered.vcf.gz136" "8_S8_annotated_filtered.vcf.gz191" "8_S8_annotated_filtered.vcf.gz967"

而我需要的是

> row.names(mydataframe)
[1] "S1"   "S1"   "S1"   "S1"  
[5] "S1"   "S1"   "S1"   "S1"
....
[469] "S7" "S8" "S8" "S8"

有什么建议吗？提前感谢！

来源：https://stackoverflow.com/questions/44134165/how-to-edit-row-names-in-dataframe-from-list-of-lists

3条答案

按热度按时间

bpzcxfmw1#

建议是：将信息存储在一个额外变量中。不能在 Dataframe 中存储非唯一的行名称：

df <- data.frame(
  A = 1:3,
  B = 3:1
)
rownames(df) <- c("D","E","D")

给出：

Error in `row.names<-.data.frame`(`*tmp*`, value = value) : 
  duplicate 'row.names' are not allowed
In addition: Warning message:
non-unique value when setting 'row.names': ‘D’

因此，您可以：

mydataframe$origin <- gsub("\\d_(S\\d{1})_.+", "\\1", rownames(mydataframe))

但不能将其设置为行名。

赞(0）回复(0）举报 2023-04-03

aydmsdu92#

我会用途：

library(stringr)
 str_extract(row.names(mydataframe),"S[0-9]")

赞(0）回复(0）举报 2023-04-03

n1bvdmb63#

或者，将gsub与组捕获一起使用：

a <- c("6_S6_annotated_filtered.vcf.gz877", "7_S7_annotated_filtered.vcf.gz569")
gsub('[0-9]+_(S[0-9]+)_annotated_filtered.vcf.*',"\\1",a)
#[1] "S6" "S7"

赞(0）回复(0）举报 2023-04-03

我来回答

如何从列表列表中编辑 Dataframe 中行名称？

3条答案

相关问题

热门标签

最新问答