Text Files (e.g. csv)

CSV View Module

The CSV View module was designed to offer a tool for quick inspection of text files, commonly named CSV, but applicable to various file extensions. AMIGOpy can export different types of information into CSV files, and we frequently use CSV files from diverse sources, such as patient breathing curves, dose measurements, and CT calibration data.

This module enables users to:

Inspect CSV files with ease.
Plot the data for visual analysis.
Perform basic operations like swapping columns, and executing arithmetic operations such as addition, subtraction, multiplication, and division.

Click "Load File" to open the file selection dialogue. If the file you want to open is not visible, select "All Files" in the dialogue box. Once you open the file, the first 100 lines will be displayed in the software. You can then inspect the file to determine how many lines should be skipped (header) and the separator type (e.g., comma ",") used in the file.

Adjust the number of header lines to skip and the separator type, then load the file again. The columns will now be displayed in a table that includes the entire file.

Plot

Select the columns to be displayed in the graph using the dropdown menus labelled "X-Axis" and "Y-Axis," then click "Plot." In the example below, the breathing curve is plotted with the timestamp in column "C3" and the amplitude in column "C1."

Note:

To keep the current plot when adding additional data, select the checkbox next to the "Plot" button. If the checkbox is not selected, the new plot will replace the existing one.
Additional icons at the top-left of the plot allow for further customization.

Operations

At the bottom left of the table, there is a dropdown menu with some basic operations. Select the desired operation, enter a number in the space below (for arithmetic operations), and then press "Apply."

Examples:

Swap: Swaps the values between the columns indicated in the X-Axis and Y-Axis menus.
Copy: Copies the values from the column indicated in X-Axis to the column indicated in Y-Axis.
Multiplication/Division/etc.: Multiplies, divides, etc., the values of the column in X-Axis by the value provided by the user. For example, in the scenario above, the amplitude should be multiplied by a scale factor of 10.

Note: The graph needs to be updated manually by selecting the columns and pressing the plot.

Page updated

Google Sites

Report abuse