Thursday 26 November 2015

graphics - Software for extracting data from a graph without having to click on every single point?


There are many times when I am faced with the task of extracting data from a published graph (usually a bitmap image in an paper). For example, a scatter plot from which I would like to get a list of individual (x, y) coordinates for the points.


One option is to ask the contact author for raw data. Most will do it, sometimes in nice ASCII format, sometimes in Excel files, sometimes in formats that I cannot open (chemists are fond of software like Origin or Igor Pro). Some authors never reply, or ask questions like “what do you want to do with it?”. In all cases, it takes time. Sometime, it's not even possible (I can hardly email the author of a 1936 paper!).


The other option is to extract the data. I currently use g3data to do that, but for large scatter plots having to click on every single point is tedious. Thus, I am looking for a data extraction software that could recognize individual points automagically, and possibly filter them by point color or symbol used. Is that even something that exists? What other tools can you recommend to work around this issue?


I don't think it'd be appropriate to have extra requirements on the software, so I'm happy with free or commercial solutions, running on any OS. Of course, if given the choice, I'd prefer open source software running on Linux and Mac OS.



Answer




A colleague suggested I use GraphClick, a Mac OS software that includes (according to its website):




  • Automatic detection of curves (solid, dotted or dashed), symbols, bar charts, or perimeters of areas

  • Frame-by-frame digitization of QuickTime movies



The later is something I had not thought about, but might actually be useful for some teaching needs (analysis of motion from a video). My first experiences are good: the software is easy to use, includes a nice magnification UI, and automatic curve detection works fine if the graph is “clean”.




And here's a list of other possible software from this answer on Cross Validated (link thanks to @AndyW and @Paresh):




  • Engauge Digitizer (free software, GPL license) auto point / line recognition. Available in Ubuntu repository (engauge-digitizer)

  • Get Data (shareware, free trial version, $30 for personal license) has zoom window, auto point / line recognition

  • DigitizeIt (shareware, free trial version, $49 for personal license) auto point / line recognition


No comments:

Post a Comment

evolution - Are there any multicellular forms of life which exist without consuming other forms of life in some manner?

The title is the question. If additional specificity is needed I will add clarification here. Are there any multicellular forms of life whic...