Excel is my database, Python is my brain.
Turn Excel into a lightweight data-science tool for cleaning datasets, standardizing dates, visualizing clusters, and analyzing keywords.
Loads registered drug products from SFDA Excel mapping file into local database. Maps brand names (trade names) to scientific names for medication validation. Input ...
-i, --input : Path to the input configuration file. Can be either a YAML (.yaml/.yml) or Excel (.xlsx) file. Default is 'prepare_framework_v2_config.xlsx'. -o, --output : Optional output Excel file ...