sda.analysis.loaders#

Supplementary file loaders shared across SDA analysis scripts.

Provides load_supplementary_xlsx(), a robust loader for non-standard .xlsx files that live inside a test folder but are not registered as SDA tables (e.g. T346_analyse_EP.xlsx).

The loader handles Windows file-lock issues by copying to a temp location before opening with openpyxl.

Functions#

load_supplementary_xlsx(test_name[, filename, ...])

Load a supplementary .xlsx from the folder of an SDA test.

Module Contents#

sda.analysis.loaders.load_supplementary_xlsx(test_name, filename=None, glob_patterns=None, sheet=0, label=None)#

Load a supplementary .xlsx from the folder of an SDA test.

Copies the file to a temporary location first so that Windows file locks (e.g. the file is open in Excel) do not prevent reading.

Parameters:

  • test_name (SDA test identifier (e.g. ````”T346”:py:class:`). Used` to resolve) – the folder via sda.api.file_discovery.resolve_local_test_path().

  • filename (Exact filename to load (e.g. ````”T346_analyse_EP.xlsx”:py:class:`).`) – When None, the first file matching glob_patterns is used.

  • glob_patterns (Glob patterns relative to the test folder to search when) – filename is not given. Defaults to ["*analyse*.xlsx", "*EP*.xlsx", "*ep*.xlsx"].

  • sheet (Sheet index or name to parse.  Defaults to 0 (first sheet).)

  • label (Short label for log messages (defaults to) – "<test_name>-sup").

Return type:

pandas.DataFrame — empty on any failure.