@MatthewDavidH @ENirenberg Really?! 2 decades since first publication & probably years before that: BR Zeeberg, et al., "Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics", BMC Bioinformatics 5
RT @takatoh_life: 【参考文献(1/2)】 2004年 Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformati…
RT @takatoh_life: 【参考文献(1/2)】 2004年 Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformati…
【参考文献(1/2)】 2004年 Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics https://t.co/U8lXlYyT7D 2016年 Gene name errors are widespread in the scientific literature https://t.co/JYwqEfUiFi
@grams_it @kclemson some 20 years late comes closer: https://t.co/dXAahOZIPh
RT @mdziemann: Learn more about the history of this topic with these articles: ➡️Zeeberg et al 2004, https://t.co/CqhLFwpoRh ➡️Ziemann et a…
내가 공저자로 참여한 생애 첫 peer-review 논문도 이 문제가 있다. 이게 어마어마하게 중대한 문제라고 생각하지는 않지만 많이 부끄럽다. 망할 놈의SEPT 유전자…
Learn more about the history of this topic with these articles: ➡️Zeeberg et al 2004, https://t.co/CqhLFwpoRh ➡️Ziemann et al 2016, https://t.co/srK41QiL0j ➡️Abeysooriya et al 2021, https://t.co/3cn7B0mHBb
RT @mdziemann: @marceljuengling There are workarounds described here https://t.co/QTf4CymqiX
@marceljuengling There are workarounds described here https://t.co/QTf4CymqiX
Some references regarding the issue: https://t.co/Z0kJY3EnNS https://t.co/eOvQYB3KbF
RT @jks: @emollick The problem was known already in 2004 https://t.co/WxsFruG0lu and some genes eventually got renamed https://t.co/nqtWejc…
RT @jks: @emollick The problem was known already in 2004 https://t.co/WxsFruG0lu and some genes eventually got renamed https://t.co/nqtWejc…
RT @jks: @emollick The problem was known already in 2004 https://t.co/WxsFruG0lu and some genes eventually got renamed https://t.co/nqtWejc…
RT @jks: @emollick The problem was known already in 2004 https://t.co/WxsFruG0lu and some genes eventually got renamed https://t.co/nqtWejc…
RT @jks: @emollick The problem was known already in 2004 https://t.co/WxsFruG0lu and some genes eventually got renamed https://t.co/nqtWejc…
@emollick My PhD student Barry Zeeberg pointed this out in a *2004* paper. And it's still not fixed. Think uSoft cares? https://t.co/IEKpPIbtWz
@Noahpinion 2016?? My PhD student Barry Zeeberg pointed this out in a *2004* paper. https://t.co/4P896nYTKf F'ing excel, the bane of our existence.
@emollick The problem was known already in 2004 https://t.co/WxsFruG0lu and some genes eventually got renamed https://t.co/nqtWejcEsG because that's easier than fixing Excel
@ComradeEevee I have so many nightmares bout excel. First paper I found published the same year I started doing bioinformatics: https://t.co/9zvvhe7FXd
RT @NicGambardella: Excel date conversion mangles gene names http://t.co/kGXyMhZTdW Same with libreoffice
هناك جينات أسماؤها تشبه التواريخ، مثل MARCH1، SEPT1، SEPT2 وغيرهم كثير. وهكذا فإكسيل مباشرة يحول أسماء هذه الجينات إلى تواريخ أو عدد. كما يوضح بحث منشور : https://t.co/tYNAASuVap https://t.co/pRur4mEuEO
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
Excelで遺伝子名が自動変換される問題なんて存在するの知らなかった… "For example, SEPT4 (septin 4) and MARCH1 (membrane associated ring-CH-type finger 1) will be automatically changed to 4-Sep and 1-Mar."
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
RT @yuifu: 「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6H…
「Excelで遺伝子名が変換される問題」の最新状況 https://t.co/t9v0GNOxap 最初の報告は2004年 https://t.co/F2XLV9HlgF HGNCは影響を受けやすい遺伝子名を変更 https://t.co/0BzF6Ho3OV 最新の報告ではPMCでサプリテーブルを取得し大規模調査。30.9%の論文で発覚 https://t.co/Me35PrLxdo
It has been nearly 20 years since Zeeberg's paper on the issue https://t.co/QTf4CyDtkX
@strnr It’s been a known issue since 2004 yet it persists. Not sure why they hypothesised their 2016 paper would make any more difference than the one raising the same issue years before. https://t.co/xbYbYMqD7W
Friendly reminder; do not use Excel as part of your dataprocessing pipeline. https://t.co/MSEXU9eFIm
@KiwiPeterKelly @andrewtychen It was easier to change the gene names than wait another 16 years for people to stop using Excel. https://t.co/xbYbYMqD7W
@mndoci @_joemag_ @neilfws there’s even peer reviewed papers about this https://t.co/ka7Dt2UPjy
It's 2020. We've known about the problems using Excel for working with research data for almost two decades. https://t.co/RjXlZC8dWa
@SvobodaLab seems to be a long-standing issue (https://t.co/tDLsJOhUR5) with some recent "solution" (https://t.co/ZHVxgCItg3)
スラドチラ見して過去記事リンクから出てきた https://t.co/LX18QJ9GQ3 2004か…
@Olu_GH Data manipulation via Excel is inevitable. Besides, it's not like people haven't known about this for ages and come up with fixes... Like in 2004... https://t.co/zMgc8jEJTz - bonus points for getting "transmogrified" into a paper!
@masanork @h_okumura それは2004年には論文になっている問題かも知れません https://t.co/1V85qxbfnh
RT @zakkohane: That Excel feature defeated quite a few bioinformatics papers as per this classic of 2004 https://t.co/gR9XsziBmt and this o…
RT @zakkohane: That Excel feature defeated quite a few bioinformatics papers as per this classic of 2004 https://t.co/gR9XsziBmt and this o…
RT @zakkohane: That Excel feature defeated quite a few bioinformatics papers as per this classic of 2004 https://t.co/gR9XsziBmt and this o…
RT @zakkohane: That Excel feature defeated quite a few bioinformatics papers as per this classic of 2004 https://t.co/gR9XsziBmt and this o…
RT @zakkohane: That Excel feature defeated quite a few bioinformatics papers as per this classic of 2004 https://t.co/gR9XsziBmt and this o…
That Excel feature defeated quite a few bioinformatics papers as per this classic of 2004 https://t.co/gR9XsziBmt and this one from 2016 https://t.co/cfqI5dYjXY I wonder if anyone approached @MSFTResearch : Could heuristic AI veto name mangling if there w
@BioMickWatson I believe this the first paper on the subject... note the date 2004 and it was a well known problem in the microarray world. I remember at the time, it was such a commonly known problem even then, I wondered how they got the paper published.
@occsci It only took 16 years. Yes researchers have not stopped making this mistake in that time either! https://t.co/xbYbYMqD7W
RT @neilfws: June 23 2004. 16 years of attempts to educate and this is the solution 🙄 https://t.co/e4Es5mtYpo
RT @neilfws: June 23 2004. 16 years of attempts to educate and this is the solution 🙄 https://t.co/e4Es5mtYpo
June 23 2004. 16 years of attempts to educate and this is the solution 🙄 https://t.co/e4Es5mtYpo
@YFeyman @hyperplanes It’s not just formatting. With Y2K Excel crossed the Rubicon and began altering data without telling the users. Excel munging gene names into dates is a well known problem in bioinformatics https://t.co/VXUFzpp747 and https://t.co/YV3
RT @JennyBryan: This paper details how Excel mangles gene names. Yet the mangling goes on, 10 yrs later. http://t.co/IfLGHLlA9G http://t.co…
@AmandaLynGunn Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics https://t.co/mJcPsUN3Uw
We knew about a similar problem for gene names since at least 2004: https://t.co/cVv9DTJqMG. In 2016 it was reported that one in five genetics papers had gene name issues with MS Excel to blame: https://t.co/vlQvyxhONW It is 2020. We are still loosing da
@1Mothtoaflame @FatEmperor Without access to source code, nor to another subprogram known to be reliable, how else might you decide which program(s) to scrutinize first? -- W Kahan, UCBerkeley https://t.co/rTwukFGDBI
@thecity2 @bbstats I'm not sure. The papers are quite old in many cases. And this would be a strange paper to publish if it's just about how the genes are displayed? This paper cites another paper documenting this issue going back to 2004: https://t.co/21K
@krizdabz Tie paši gēnu pētnieki par tieši šo problēmu tika brīdināti pirms 15 gadiem. Šajā periodā varēja jau nu iemācīties strādāt ar Excel. https://t.co/GilAz454wD
I'm guessing you also know about the scientific consequences of spreadsheet errors? Lots of poorly managed scientific data held in spreadsheets. https://t.co/xxQrMOV5br https://t.co/UBXCuhBpHQ
RT @davepdotorg: Me: *having worked in software development for 30 years, moving to new problem domain* Bioinformatics world: "Welcome, yo…
@softbear_ I mean we’ve known about this for 15 years but I guess there’s nothing more dark matter than drawing things out a bit. https://t.co/3TUUYqxVMQ
RT @dk_barupal: @Eric_Fauman @pjobphd @ksuhre Reminded me of these two papers - 1) Mistaken Identifiers: Gene name errors can be introduced…
@Eric_Fauman @pjobphd @ksuhre Reminded me of these two papers - 1) Mistaken Identifiers: Gene name errors can be introduced inadvertently when using Excel in bioinformatics https://t.co/M8s1Kxz2mz 2) Gene name errors are widespread in the scientific liter
@Samantha_Toet The horror, the horror... https://t.co/mFZFfIl7CJ
The Infinium MethylationEPIC v1.0 B4 Array Manifest File Release Notes: Manifest v1.0 B4 Reformatted the manifest files to address the issue with incorrect gene annotation formatting when viewed in Excel (gene names were incorrectly displayed as dates).
@Jared_Mamrot @msexcel @kamal_hothi Yep. @msexcel is literally breaking parts of science: https://t.co/acK3qLpn4J Plus do a search for "gene names excel" for screeds of problems.
@punkrockscience @JovMaksimovic There is more than one. My colleagues and I wrote this back in 2004: https://t.co/7EnHyFB3yd
@aylwyn_scally @dgmacarthur @BioMickWatson Or gene names. :D https://t.co/phhPZiHpEA
@josephtravers @evergreendata @dgoosens @maartenzam "Despite the work-arounds, even the most vigilant investigator can inadvertently introduce conversion errors" https://t.co/idBu201eaG
Thanks Excel! (Curious if the same happens in R...)
@statesdj @mbeisen And this classic https://t.co/3pBHb9AtxW
@EdwardTufte @BioMickWatson Plus ça change... https://t.co/RILKVEgkYZ
RT @catmacOA: One aim of @stencila is to get researchers to move away from using error prone excel e.g. for gene names https://t.co/076K8eX…
RT @catmacOA: One aim of @stencila is to get researchers to move away from using error prone excel e.g. for gene names https://t.co/076K8eX…
One aim of @stencila is to get researchers to move away from using error prone excel e.g. for gene names https://t.co/076K8eXVuw - #osbazaar
RT @JennyBryan: This paper details how Excel mangles gene names. Yet the mangling goes on, 10 yrs later. http://t.co/IfLGHLlA9G http://t.co…
This plagues GEO. Plagues it. https://t.co/vXuAiiIz1O
RT @nlavielle: Never. Use. Excel. NEVER! https://t.co/UQr4095I57
RT @nlavielle: Never. Use. Excel. NEVER! https://t.co/UQr4095I57
Excel is evil... https://t.co/qoC5HrPEdw #bmcbioinformatics
RT @nlavielle: Never. Use. Excel. NEVER! https://t.co/UQr4095I57
Never. Use. Excel. NEVER! https://t.co/UQr4095I57
Quand Microsoft Excel change les noms de vos gènes dans vos publications... https://t.co/Pu13ntA6vS @BioinfoFr
@EarlyPermian @SJW_Science Awareness is a generous way of putting it. Concern. Over a decade of concern. https://t.co/xbYbYMqD7W
2004 год: парни, эксель портит названия генов, осторожно! 2017 год: *получаю список с геном Sep-09* https://t.co/PmZEMLap0W
Note to self: Excel sees 'March' as a month not an E3 Ubiquitin-Protein Ligase with an unfortunate acronym. https://t.co/3EmIyOjofY