/pylookup

PyLookup is a fuzzy-matching, auto-table-updating library and command-line tool inspired by the "VLOOKUP" function in Excel.

Primary LanguagePythonMIT LicenseMIT

PyLookup

PyLookup is a fuzzy-matching, auto-table-updating library and command-line tool inspired by the "VLOOKUP" function in Excel.

Installation

pip install pylookup

Command Line Interface Usage

  • To add and populate the "COLUMN" column in "excel_to_populate" from the data in "excel_with_column", simply run the following command. This currently works for .xlsx (Excel) files and .csv files.
pylookup COLUMN excel_with_column.xlsx excel_to_populate.xlsx

License

MIT