The R Journal: article published in 2014, volume 6:2

Automatic Conversion of Tables to LongForm Dataframes PDF download
Jimmy Oh , The R Journal (2014) 6:2, pages 16-26.

Abstract TableToLongForm automatically converts hierarchical Tables intended for a human reader into a simple LongForm dataframe that is machine readable, making it easier to access and use the data for analysis. It does this by recognising positional cues present in the hierarchical Table (which would normally be interpreted visually by the human brain) to decompose, then reconstruct the data into a LongForm dataframe. The article motivates the benefit of such a conversion with an example Table, followed by a short user manual, which includes a comparison between the simple one argument call to TableToLongForm, with code for an equivalent manual conversion. The article then explores the types of Tables the package can convert by providing a gallery of all recognised patterns. It finishes with a discussion of available diagnostic methods and future work.

Received: 2013-11-04; online 2014-09-26
CRAN packages: TableToLongForm, reshape2, plyr


CC BY 4.0
This article is licensed under a Creative Commons Attribution 3.0 Unported license .

@article{RJ-2014-021,
  author = {Jimmy Oh},
  title = {{Automatic Conversion of Tables to LongForm Dataframes}},
  year = {2014},
  journal = {{The R Journal}},
  doi = {10.32614/RJ-2014-021},
  url = {https://doi.org/10.32614/RJ-2014-021},
  pages = {16--26},
  volume = {6},
  number = {2}
}