py_cmdtabs

Set of tools to facilitate parsing of tabulated files

py_cmdtabs includes tools that make it easier for its user to manipulate tabulated files. It is designed to carry out the following functionalities:

• Add columns: the aggregate_columns.py script allows you to change the format of the information saved in the same file, combining its columns into a single one as specified in the script.

• Disaggregate columns: the desaggregate_columns.py script allows you to change the format of the information saved in the same file, disaggregating its columns into several using a specific pattern.

• Join tables: the merge_tabular.py script allows two or more tabular tables to be joined by a common join pattern between both.

• Tag tables: the tag_table.py script is used to include a series of specific tags to elements of a table.

• Intersect columns: the intersect_columns.py script compares the elements of two columns belonging to two different tables.

• Obtain common information: the table_linker.py script allows you to save in the same output file the information extracted from a tabulated file, based on the identifiers of a second file.

• Replace information: The standard_name_replacer.py script replaces values in a table based on a contributed value code.

• Filter columns: The column_filter.py script filters columns from a tabulated file whose elements match a specified pattern.

• Transform Excel format into tabular: the excel_to_tabular.py script transforms files with an .xlsx extension into tabular files and makes their handling easier.

See https://github.com/seoanezonjic/py_cmdtabs