代码之家 › 专栏 › 技术社区 › Josh

行尾的多余逗号导致read.csv和read.table出错

read.csv read.table r

2

Josh · 技术社区 · 8 年前

.csv file this post 我认为这个问题与每行末尾多加一个逗号有关。在对前一个问题的回答中,我找不到的是如何去掉行尾逗号。

pmr <-read.csv("pubmed_result.csv", header = T, row.names = NULL)
colnames(pmr) <- c(colnames(pmr)[2:ncol(pmr)], "blank")
pmr <- pmr[1:ncol(pmr)-1]

这提供了期望的结果,但似乎有点不雅。是否有方法获取read.csv或read.table以忽略最后一个逗号?或者有没有办法使用gsub来修复csv?

1 回复 | 直到 8 年前

1

3

Maurits Evers 8 年前

你的评估是正确的 ","

如果您不想像在上面的代码中那样手动修复该问题,可以使用 readr::read_csv

library(tidyverse);
df <- read_csv("pubmed_result.csv");
df;
    ## A tibble: 375 x 11
#   Title   URL    Description  Details  ShortDetails Resource Type  Identifiers
#   <chr>   <chr>  <chr>        <chr>    <chr>        <chr>    <chr> <chr>
# 1 Myoediâ¦ /pubmâ¦ Zhang Y, Loâ¦ Physiolâ¦ Physiol Revâ¦ PubMed   citaâ¦ PMID:29717â¦
# 2 Cullinâ¦ /pubmâ¦ Papizan JB,â¦ J Biol â¦ J Biol Chemâ¦ PubMed   citaâ¦ PMID:29653â¦
# 3 Fusogeâ¦ /pubmâ¦ Bi P, McAnaâ¦ Proc Naâ¦ Proc Natl Aâ¦ PubMed   citaâ¦ PMID:29581â¦
# 4 Correcâ¦ /pubmâ¦ Long C, Li â¦ Sci Advâ¦ Sci Adv.  2â¦ PubMed   citaâ¦ PMID:29404â¦
# 5 Singleâ¦ /pubmâ¦ Amoasii L, â¦ Sci Traâ¦ Sci Transl â¦ PubMed   citaâ¦ PMID:29187â¦
# 6 Requirâ¦ /pubmâ¦ Shi J, Bi Pâ¦ Proc Naâ¦ Proc Natl Aâ¦ PubMed   citaâ¦ PMID:29078â¦
# 7 Considâ¦ /pubmâ¦ Carroll KJ,â¦ Circ Reâ¦ Circ Res.  â¦ PubMed   citaâ¦ PMID:29074â¦
# 8 ZNF281â¦ /pubmâ¦ Zhou H, Morâ¦ Genes Dâ¦ Genes Dev. â¦ PubMed   citaâ¦ PMID:28982â¦
# 9 Functiâ¦ /pubmâ¦ Kyrychenko â¦ JCI Insâ¦ JCI Insightâ¦ PubMed   citaâ¦ PMID:28931â¦
#10 Deficiâ¦ /pubmâ¦ Papizan JB,â¦ J Clin â¦ J Clin Inveâ¦ PubMed   citaâ¦ PMID:28872â¦
## ... with 365 more rows, and 3 more variables: Db <chr>, EntrezUID <int>,
##   Properties <chr>