一项新的研究表明,发表的基因组研究错误很大程度是因为微软Excel的一个问题。在澳大利亚的一个三人组对过去10年的时间里,扫描了18种期刊中的3600篇论文的7500份基因列表文件,发现有五分之一的文件存在基因书写错误。
A new paper has revealed the vast extent of errors in published genomics research, which is down to an unfortunate quirk of Microsoft Excel. A trio of scientists in Australia scanned 7,500 Excel files with gene lists accompanying 3,600 papers in 18 journals over a 10-year period. One-fifth of the files had easily identified errors, which is “quite striking and a little bit embarrassing,” says Mark Ziemann of the Baker IDI medical research institute in Melbourne, one of the paper’s co-authors.
比如基因“Membrane-Associated Ring Finger (C3HC4) 1, E3 Ubiquitin Protein Ligase,” 缩写为“MARCH1”,Excel表就会转换为日期“03/01/2016”。而基因如“2310009E13”则会转换为对数(2.31E+19)。
Years of genomics research is riddled with errors thanks to a bunch of botched Excel spreadsheets
基因组学研究者注意了!用Excel对基因列表可能产生错误 |
|