guessTable: Guess table formats
In cstubben/pmcXML: Tools to parse full text XML documents from PMC Open Access

Description Usage Arguments Details Value Author(s) See Also Examples

Guess format of data.frames by identifying captions and footnotes

1	guessTable(x, header = 1, ...)

`x`	a data.frame, often loaded by `read.xls`
`header`	header row(s), after removing caption
`...`	other options passed to `fixTypes`

Counts the number of non-empty cells in a data.frame and finds consecutive runs of 1 at the start and end, which are assigned to caption and footnote attributes. The remaining rows are reformated into a new data.frame

a data.frame

Chris Stubben

read.xls2

x <- data.frame( rbind( c("Table 1. Loaded using read.xls", NA, NA, NA), letters[1:4], diag(4), c("* And some footnotes", NA, NA, NA )), stringsAsFactors=FALSE)
x
y <- guessTable(x)
y
str(y)