A generic tool for handling of observed data within the Open Systems Pharmacology Suite is the formerly known PKExcelImporter. It is used in both applications (PK-Sim® and MoBi®) for importing observed data from e.g. Microsoft Excel® files with following prerequisites:
A file contains one or several sheets with data tables.
Column headers are in the first non-empty row.
Units are given in the second header row or as part of the column header (at the end) enclosed in brackets (For example Time [h] would be interpreted as column name Time [h] and unit h).
LLOQ values (= values below Lower Limit Of Quantification) must be preceded by a "<", e.g. "<0.2", where 0.2 is the LLOQ value. In case of different LLOQ values in one Observed Data vector the largest of those LLOQ values is used as LLOQ value.
The LLOQ value is stored at the data column and is not editable. All LLOQ values are stored as LLOQ/2 (= 0.1 in the example) to display them in the middle of the unknown range 0, LLOQ. In charts for such data a dotted line y=LLOQ is shown.
File Selection Dialog
In the Parameter Identification those LLOQ values can be handled differently (see Handling of LLOQ values).
To import data you should do the following:
Select the input file (see File Selection).
Specify the column mapping (see Column Mapping in Import of Observed Data).
You can continue importing data sheets/data files by adding or changing the column mapping or selecting another input file.
Enter all required meta data and set unit information.
Complete the transfer of the imported data sheets to the calling application by confirming your settings.
Click on the Observed Data button to start the import component and specify the the excel file to be imported.
After selection of the file to be imported, a split window appears (see screenshot below). The left hand side shows a preview of the imported data file using the current mapping, each data table can be found in a separate tab. The right hand side window displays the mapping of imported column identifiers with the predefined data types. This mapping is performed automatically upon import but can be overridden by adjusting the controls. The preview of the imported data displays the first one hundred lines of each imported sheet.
An estimate of the number of data tables upon import using the current mapping is given in brackets in the Import button. This helps the user to judge whether the specified mapping produces the desired number of data tables. The Import All button is used to import multiple sheets at the same time.
Clicking on the Preview Original Data button allows the user to quickly review the original data. This might be useful in case explanatory data that is needed to perform mapping gets trimmed out during the import process. Also, in the preview of the original data, specific subsets of data can be selected for import.
The mapping table on the right in the Import Observed Data window shows the automatically generated mapping of the columns of the source sheet to the targets columns. Automatic mapping of source columns onto the target columns takes the following criteria into account:
Equality of names.
The target column has the same name as the source column.
The target column supports the unit of the source column.
If several target columns match the above criteria, the ones that have not been used in mapping are preferred to avoid multiple mapping.
If no matching target column can be found, proceed as for meta data information on table level.
The mapping of source and target columns can be changed manually by using the buttons on the right hand side of each target column cell.
The predefined data types are time, concentration and error of concentrations and are available from a drop down menu. Similarly, imported data can be classified as meta data. Meta data is additional information on the imported data that applies to one or more data repository. The following meta data categories are available from the dropdown menu: molecule, species, organ, compartment, study ID, gender, dose, route and patient ID. For further information on handling and entering meta data see, “Entering Meta Data”. Units can be specified after clicking on .
The icons to the left of each target entry in the mapping dialog have the following meaning:
The icon indicates that meta data are requested.
The icon indicates that meta data are requested which are not entered right now.
The icon indicates that unit information are requested.
The icon indicates that unit information are requested which are not explicitly entered right now.
The icon indicates that meta data and unit information are requested.
The icon indicates that the data will be split into several tables by distinct values of source column (see Using Group By in the mapping).
It might be more effective to enter meta data information for a column during the mapping process, especially if you are using the multiple mapping feature.
The meta data will then be used for all columns which will be created out of this mapping.
In both, PK-Sim® and MoBi®, observed data can be organized in folders in the Building Block explorer. Observed data can be grouped into subfolders and shifted among folders by drag/drop or by using meta data to automatically group observed data during the import into a specific subfolder.
To import a single data sheet you have to click on the Import button. If you want to import several data sheets in one file, click on the Import All button (see Import All) button. The number of currently imported tables is shown in brackets in the imports tab page caption.
You can go through each source sheet, map the columns and import the sheet as new import table. That way you would collect several import tables which can be transferred to the calling application later on.
Meta data are additional information that the calling application might request of the user. There can be meta data requested for an imported table or for each imported column (see below for an example).
A column unit can be set in the mapping dialog or by selecting Set Unit from the context menu of a column in the imported table tab page (see Imported Table Tab Page Screenshot).
For a column there can be multiple dimensions defined. Each dimension can have multiple units.
A new tab page is created for each imported data file and you can enter meta data for tables or columns, set unit information or just view the imported data (see Imported Table Tab Page Screenshot). Changes to the error type or to units can be made in this view and are directly reflected in the chart.
On the left hand side you can see all meta data of the currently selected table and their columns. You can enter the requested information directly into this area or select Edit Meta Data from the context menu of a column header.
To set a unit for a column of an imported table you can select Set Unit from the context menu of a column header.
To complete the import of data tables to the calling application press the OK button.
Once a repository of observed data is imported, it can be manipulated by adding new data points, numerically changing data points or changing meta data. Changes are reversible through and will be tracked in the project history. Numerically changing a value is reflected in real time in the preview graph below and will result in moving the data point in the data grid to the new settings
The new editing window can be accessed through double clicking the observed data in the building block view or through the context menu.