gvisTable: Google Table Chart with R

Description

The gvisTable function reads a data.frame and creates text output referring to the Google Visualisation API, which can be included into a web page, or as a stand-alone page. The actual chart is rendered by the web browser. A table that can be sorted and paged. Table cells can be formatted using format strings, or by directly inserting HTML as cell values. Numeric values are right-aligned; boolean values are displayed as check marks. Users can select single rows either with the keyboard or the mouse. Users can sort rows by clicking on column headers. The header row remains fixed as the user scrolls. The table fires a number of events corresponding to user interaction.

Usage

gvisTable(data, options = list(), chartid, formats = NULL)

Arguments

data

a data.frame to be displayed as a table

options

list of configuration options for Google Table. [object Object] Further possible components are, taken from https://google-developers.appspot.com/chart/interactive/docs/gallery/table.html#Configuration_Options: [object O

chartid

character. If missing (default) a random chart id will be generated based on chart type and tempfile

formats

named list. If NULL (default) no specific format will be used. The named list needs to contain the column names of the data and the specified format. The format string is a subset of the ICU pattern set. For instance, {pattern:'#,###%'} will

Value

gvisTable returns list of class "gvis" and "list". An object of class "gvis" is a list containing at least the following components:
typeGoogle visualisation type, here 'Table'
chartidcharacter id of the chart object. Unique chart ids are required to place several charts on the same page.
htmla list with the building blocks for a page [object Object],[object Object],[object Object],[object Object]

References

Google Table API: https://google-developers.appspot.com/chart/interactive/docs/gallery/table.html Follow the link for Google's data policy.

Examples

Run this code

## Please note that by default the googleVis plot command
## will open a browser window and requires Flash and Internet
## connection to display the visualisation.

## Table with links to wikipedia (flags) 
tbl1 <- gvisTable(Population)
plot(tbl1)

## Table with enabled paging
tbl2 <- gvisTable(Population, options=list(page='enable', height=300))

plot(tbl2)

## Table with formating options
tbl3 <- gvisTable(Population, formats=list(Population="#,###"))

Population[['% of World Population']] <- Population[['% of World Population']]/100 
tbl4 <- gvisTable(Population, formats=list(Population="#,###", 
                                           '% of World Population'='#.#\%'))
plot(tbl4)                                           
plot(tbl3)