Difference between revisions of "Category talk:Tabular data/doc"
blackwiki>Mxn |
blackwiki>Mxn m |
||
| Line 7: | Line 7: | ||
Returns the value of the cell at the given row index and column name. | Returns the value of the cell at the given row index and column name. | ||
| − | Usage: {{mlx|{{ | + | Usage: {{mlx|{{BASEPAGENAME}}|''cell''|''Page name.tab''|output_row{{=}}''Index of row to output''|output_column{{=}}''Name of column to output''}} |
A row index of <code>1</code> refers to the first row in the table. A row index of <code>-1</code> refers to the last row in the table. It is an error to specify a row index of <code>0</code>. | A row index of <code>1</code> refers to the first row in the table. A row index of <code>-1</code> refers to the last row in the table. It is an error to specify a row index of <code>0</code>. | ||
| Line 13: | Line 13: | ||
Example getting the latest death toll in [[c:COVID-19 Cases in Santa Clara County, California.tab]] (regardless of when the table was last updated): | Example getting the latest death toll in [[c:COVID-19 Cases in Santa Clara County, California.tab]] (regardless of when the table was last updated): | ||
| − | {{#invoke:Demo|module|demo_module={{ | + | {{#invoke:Demo|module|demo_module={{BASEPAGENAME}}|demo_module_func=cell|COVID-19 Cases in Santa Clara County, California.tab|output_row=-1|output_column=deaths}} |
== <code>lookup</code> == | == <code>lookup</code> == | ||
| Line 20: | Line 20: | ||
This function is reminiscent of <code>LOOKUP()</code> macros in popular spreadsheet applications, except that the search key must match exactly. (On the other hand, this means the table does not need to be sorted.) | This function is reminiscent of <code>LOOKUP()</code> macros in popular spreadsheet applications, except that the search key must match exactly. (On the other hand, this means the table does not need to be sorted.) | ||
| − | Usage: {{mlx|{{ | + | Usage: {{mlx|{{BASEPAGENAME}}|''lookup''|''Page name.tab''|search_value{{=}}''Value to find in column''|search_column{{=}}''Name of column to search in''|output_column{{=}}''Name of column to output''}} |
Example getting the total confirmed case count in [[c:COVID-19 Cases in Santa Clara County, California.tab]] on the day that the county issued a [[stay-at-home order]]: | Example getting the total confirmed case count in [[c:COVID-19 Cases in Santa Clara County, California.tab]] on the day that the county issued a [[stay-at-home order]]: | ||
| − | {{#invoke:Demo|module|demo_module={{ | + | {{#invoke:Demo|module|demo_module={{BASEPAGENAME}}|demo_module_func=lookup|COVID-19 Cases in Santa Clara County, California.tab|search_value=2020-03-16|search_column=date|output_column=totalConfirmedCases}} |
== <code>wikitable</code> == | == <code>wikitable</code> == | ||
| Line 31: | Line 31: | ||
Returns the entire data table as a (rather plain) table. | Returns the entire data table as a (rather plain) table. | ||
| − | Usage: {{mlx|{{ | + | Usage: {{mlx|{{BASEPAGENAME}}|''wikitable''|''Page name.tab''}} |
{{Collapse top|Example}} | {{Collapse top|Example}} | ||
| − | {{#invoke:Demo|module|demo_module={{ | + | {{#invoke:Demo|module|demo_module={{BASEPAGENAME}}|demo_module_func=wikitable|COVID-19 Cases in Santa Clara County, California.tab}} |
{{Collapse bottom}} | {{Collapse bottom}} | ||
Revision as of 00:52, 10 May 2020
Error: {{Module rating}} must be placed in the Module namespace.
This module provides basic functions for interacting with tabular data on Wikimedia Commons.
cell
Returns the value of the cell at the given row index and column name.
Usage: {{#invoke:Tabular data|cell|Page name.tab|output_row=Index of row to output|output_column=Name of column to output}}
A row index of 1 refers to the first row in the table. A row index of -1 refers to the last row in the table. It is an error to specify a row index of 0.
Example getting the latest death toll in c:COVID-19 Cases in Santa Clara County, California.tab (regardless of when the table was last updated):
Lua error in Module:Tabular_data at line 35: attempt to index local 'data' (a boolean value).
lookup
Returns the value of the cell in the given output column of the row matching the search key and column.
This function is reminiscent of LOOKUP() macros in popular spreadsheet applications, except that the search key must match exactly. (On the other hand, this means the table does not need to be sorted.)
Usage: {{#invoke:Tabular data|lookup|Page name.tab|search_value=Value to find in column|search_column=Name of column to search in|output_column=Name of column to output}}
Example getting the total confirmed case count in c:COVID-19 Cases in Santa Clara County, California.tab on the day that the county issued a stay-at-home order:
Lua error in Module:Tabular_data at line 97: attempt to index local 'data' (a boolean value).
wikitable
Returns the entire data table as a (rather plain) table.
Usage: {{#invoke:Tabular data|wikitable|Page name.tab}}
Example
|
|---|
|
Lua error in Module:Tabular_data at line 153: attempt to index local 'data' (a boolean value). |