Use Power Query's M language to quickly fix names, remove hidden characters, extract numbers, and merge columns.
if dbutils.widgets.get("test_library_ref") != "": %pip install '{dbutils.widgets.get("test_library_ref")}' # MAGIC Data profiling is typically performed as a one-time ...