Data Table

Table (information)

From Wikipedia, the free encyclopedia
Jump to: navigation, search
For sortable tables in Wikipedia, see Help:Sorting
This article may require cleanup to meet Wikipedia's quality standards. Please improve this article if you can. (October 2009)
An example table rendered in a web browser using HTML.

A table is both a mode of visual communication and also a means of arranging data. The table is not the only means of arranging data. The use of tables is pervasive throughout all communication, research and data analysis. Tables appear in print media, handwritten notes, computer software, architectural ornamentation, traffic signs and many other places. The precise conventions and terminology for describing tables varies depending on the context. Moreover, tables differ significantly in variety, structure, flexibility, notation, representation and use.[1][2][3][4][5] In books and technical articles, tables are typically presented apart from the main text in numbered and captioned floating blocks.

* 1 Basic description
o 1.1 Simple table
o 1.2 Multi-dimensional table
o 1.3 Wide and Narrow Tables
* 2 Generic representation
* 3 Specific uses
o 3.1 Publishing
o 3.2 Mathematics
o 3.3 Natural sciences
o 3.4 Information technology
+ 3.4.1 Computer programming
+ 3.4.2 Software applications
* 4 Historical relationship to furniture
* 5 Notes and references
* 6 See also

[edit] Basic description

A table consists of an ordered arrangement of rows and columns. This is a simplified description of the most basic kind of table. Certain considerations follow from this simplified description:

* the term row has several common synonyms (e.g., record, k-tuple, n-tuple, vector);
* the term column has several common synonyms (e.g., field, parameter, property, attribute);
* a column is usually identified by a name;
* a column name can consist of a word, phrase or a numerical index;
* the intersection of a row and a column is a cell.

The elements of a table may be grouped, segmented, or arranged in many different ways, and even nested recursively. Additionally, a table may include metadata, annotations, header,[6] footer or other ancillary features. [5]
[edit] Simple table

The following illustrates a simple table with three columns and six rows. The first row is not counted, because it is only used to display the column names. This is traditionally called a "header row".
Age table First name Last name Age
Laurisse Sapungan 33
Jella Buquiran 43
Jan Estuesta 23
Joseph Yuhico 37
Mike Guadalupe 31
Josh Lunzaga 11

[edit] Multi-dimensional table
An example of a table containing rows with summary information. The summary information consists of subtotals that are combined from previous rows within the same column.

The concept of dimension is also a part of basic terminology.[7] Any "simple" table can be represented as a "multi-dimensional" table by normalizing the data values into ordered hierarchies. A common example of such a table is a multiplication table.
Multiplication table × 1 2 3
1 1 2 3
2 2 4 6
3 3 6 9

NOTE: Multidimensional tables, 2-dimensional as in the example, are created under the condition the coordinates or combination of the basic headers (margins) give a unique value attached. This is a injective relation: each combination of the values of the headers row (row 0, for lack of a better term) and the headers column (column O for lack of a better term) is related to a unique value represented on the table:

* column 1 and row 1 will only correspond to the value 1 (and no other)
* column 1 and row 2 will only correspond to the value 2 (and no other), etc

If the said condition is not present, it is required to insert extra columns or rows which increases the size of table with plenty of empty cells.

To illustrate how a simple table can be transformed into a multi-dimensional table, consider the following transformation of the Age table.
Modified Age Table (names only) + 1 2 3
Nancy Nancy Davolio Nancy Klondike Nancy Obesanjo
Justin Justin Saunders Justin Timberland Justin Daviolio

This is structurally identical to the multiplication table, except it uses concatenation instead of multiplication as the operator; and first name and last name instead of integers as the operands.
[edit] Wide and Narrow Tables

Tables can be described as wide or narrow in format. Wide format has a separate column for each data variable, a Narrow format will have one column for all the variable values and another column for the context of that value. See Wide and Narrow Data.
[edit] Generic representation

As a communication tool, a table allows a form of generalization of information from an unlimited number of different social or scientific contexts. It provides a familiar way to convey information that might otherwise not be obvious or readily understood.

For example, in the following diagram, two alternate representations of the same information are presented side by side. On the left is the NFPA 704 standard "fire diamond" with example values indicated and on the right is a simple table displaying the same values, along with additional information. Both representations convey essentially the same information, but the tabular representation is arguably more comprehensible to someone who is not familiar with the NFPA 704 standard. The tabular representation may not, however, be ideal for every circumstance (for example because of space limitations, or safety reasons).
Fire diamond Standard Representation Tabular Representation
NFPA 704.svg

Risk levels of hazardous materials in this facility Health Risk Flammability Reactivity Special
Level 3 Level 2 Level 1
[edit] Specific uses

There are several specific situations in which tables are routinely used as a matter of custom or formal convention.
[edit] Publishing

* Cross-reference (Table of contents)

[edit] Mathematics

* Arithmetic Multiplication table
* Logic Truth table

[edit] Natural sciences

* Chemistry (Periodic table)
* Oceanography (tide table)

[edit] Information technology
[edit] Computer programming

Data tables are used extensively in computers in many diverse forms, each form representing a distinct data structure or format. Tables are used to control software and minimize load on hardware, by memoizing[8] results that would otherwise require direct computation.

Examples include:

* n-dimensional array;
* control table;
* symbol table;
* inode table;
* hash table;
* file formats such as Comma-separated values

[edit] Software applications

Modern software applications give users the ability to generate, format, and edit tables and tabular data for a wide variety of uses.

Such applications include:

* word processing applications;
* spreadsheet applications;
* presentation software;
* tables specified in HTML or another markup language

[edit] Historical relationship to furniture

In medieval counting houses, the tables were covered with a piece of chequered cloth, to count money. Exchequer is an archaic term for the English institution which accounted for money owed to the monarch. Thus the checkerboard tables of stacks of coins are a concrete realization of this information.
[edit] Notes and references

1. ^ Fink, Arlene (2005). How to Conduct Surveys. Thousand Oaks: Sage Publications. ISBN 141291423X.
2. ^ Mcnabb, David (2002). Research Methods in Public Administration and Nonprofit Management. Armonk: M.E. Sharpe. ISBN 0765609576.
3. ^ Morgan, George (2004). Spss for Introductory Statistics. Hillsdale: Lawrence Erlbaum. ISBN 0805847898.
4. ^ Robey, David (2000). Sound and Structure in the Divine Comedy. Oxford Oxfordshire: Oxford University Press. ISBN 0198184980.
5. ^ a b Zielinski, Krzysztof (2006). Software Engineering: Evolution and Emerging Technologies. Amsterdam: IOS Press. ISBN 1586035592.
6. ^ see e.g., Page header or Header (information technology)
7. ^ The concept of "dimension" is often applied to tables in different contexts and with different meanings. For example, what is described as a "Simple Table" in this article is alternatively described as a "two dimensional array". This is distinct from "multi-dimensional table" as presented in this article.
8. ^ see also, cache

[edit] See also
Search Wiktionary Look up table in Wiktionary, the free dictionary.

* Abstract data type
* Column (database)
* Information graphics
* Periodic table
* Row (database)
* Table (database)
* Table (HTML)
* Tensor
* Timetable
* Dependent variable
* Independent variable

v • d • e
Visualization of technical information
Biological data visualization · Chemical imaging · Crime mapping · Data visualization · Educational visualization · Flow visualization · Geovisualization · Information visualization · Mathematical visualization · Medical imaging · Molecular graphics · Product visualization · Scientific visualization · Software visualization · Technical drawing · Volume visualization
Image types
Chart · Computer graphics · Diagram · Graph of a function · Engineering drawing · Ideogram · Information graphics · Map · Photograph · Pictogram · Plot · Statistical graphics · Table · Technical drawings · Technical illustration
Jacques Bertin · Stuart Card · Thomas A. DeFanti · Michael Friendly · Nigel Holmes · Alan MacEachren · Jock D. Mackinlay · Michael Maltz · Bruce H. McCormick · Charles Joseph Minard · Otto Neurath · William Playfair · Clifford A. Pickover · Arthur H. Robinson · Lawrence J. Rosenblum · Adolphe Quetelet · George G. Robertson · Ben Shneiderman · Edward Tufte
Related topics
Cartography · Computer graphics · Graph drawing · Graphic design · Imaging science · Information science · Mental visualisation · Neuroimaging · Scientific modelling · Spatial analysis · Visual analytics · Visual perception
Retrieved from ""
Categories: Infographics | Data modeling

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License