Convert tabular data between formats, without losing or reshuffling rows.

Use this whenever a table needs to change shape: CSV to Markdown, Markdown to JSON, HTML table to CSV, and so on. Rows are never silently dropped, and ragged rows are padded rather than truncated. Markdown output is column-aligned with East-Asian wide characters counted as two cells, so Chinese tables line up correctly.

Args: text: The whole table as text. from_format: Source format. markdown, csv, tsv, json or html (aliases: md, htm). to_format: Target format. markdown, csv, tsv, json or html (aliases: md, htm). aligns: Markdown output only. Per-column alignment as a comma-separated list, e.g. "left,right,center", or one value applied to every column, e.g. "center". Empty means leave the default alignment. indent: JSON output indentation width. Default 2.

Re-align a messy Markdown table so every column lines up.

Use this when a Markdown table is ragged, when pipes are not aligned in the source, when a row has the wrong number of cells, or when Chinese characters make the columns drift. This is a focused shortcut for table_convert(..., to_format="markdown"); it always outputs Markdown.

Args: text: The table as text. Defaults to reading it as Markdown. from_format: How to read the input. markdown, csv, tsv, json or html. aligns: Per-column alignment, e.g. "left,right", or a single value. Empty means no explicit alignment markers.

Reshape a table: transpose, pick or rename columns, sort, dedupe, filter.

Prefer this over editing rows by hand when the change is mechanical, because the whole table is processed at once and row order is preserved.

Args: text: The whole table as text. operation: What to do. transpose | select_columns | rename_columns | sort | dedupe | drop_empty_rows | filter. from_format: How to read the input. markdown, csv, tsv, json or html. to_format: How to write the result. markdown, csv, tsv, json or html. columns: For select_columns: the column names to keep, in output order. A 1-based column number is also accepted, e.g. "2". renames: For rename_columns: a mapping of old name to new name. sort_by: For sort: the column to sort on. descending: For sort: set true for descending order. numeric: For sort: set true to sort numerically instead of as text. column: For filter: the column to test. operator: For filter: == | != | > | >= | < | <= | contains | startswith | endswith | empty | not_empty. value: For filter: the value to compare against. aligns: Markdown output only. Per-column alignment or a single value.

Report the structure and data quality of a table before working on it.

Returns row and column counts, a per-column summary (inferred type, empty count, distinct values, most frequent values) and a list of problems such as duplicate headers, ragged rows, fully duplicated rows and empty rows. Call this first when a table looks suspicious, then fix it with table_transform.

Args: text: The whole table as text. from_format: How to read the input. markdown, csv, tsv, json or html.