PsychoTableTool

What is it?

PsychoTableTool is a program to convert tables that was generated during some experiments.

Is it free to use?

PsychoTableTool was build 2024 by Kristian Schultz k.schultz@mail.de. It is free to use. See LICENSE for details.

Examples

Start screen.

Here you have the option to select a "patient <-> script mapping" or to calculate the mean in a table.

You may click on the buttons or drag a file from your file-explorer to the according button.

Patient <-> script mapping

Here you can select a patient. The according scripts will be set for the table conversion. You will be lead to the file selection page.

Select files

Here you select the tables to convert and the destination folder. You may click on "Datei Auswählen" and then select the file using the "Open file dialog" or drag a file from your file-explorer to the according button.

When you have selected all files and the destination folder click on "start".

In the destination folder will be created this files:

• PBD_EDA_FINAL.csv
• PBD_NonEDA_FINAL.csv

Calculate mean

After clicking the button Mittelwerte Berechnen you may select a ".xls" file or a ".csv" file. The CSV file need to have a semicolon ";" as field separator.

The program calculates the mean and saves the result as: file-name_Mittelwerte.csv

The input file needs this columns to be present:

• Startle: Non empty list of integers
• Phase: Non empty list of integers
• Block: Non empty list of integers
• Skripttyp: List of anything

When present this columns will be used to create this values:

• StaPeakbc: mean of StaPeakbc
• StaPeakbc1: mean of StaPeakbc1
• StaPeakbc2: mean of StaPeakbc2
• StaBase: mean of StaBase
• StaMax: mean of StaMax
• StaArea: mean of StaArea
• StaMax T: mean of StaMax T
• ZygAmplitude: mean of (ZygMax - ZygBase)
• EkgMean: mean of EKGMean
• EkgAkzeleration: mean of (EKGMax - EKGMean)
• EkgDezeleration: mean of (EKGMean - EKGMin)
• SCL: mean of SCL
• SCR Amplitude: mean of SCR Amplitude
• SCR Rise Time: mean of SCR Rise Time
• SCR Size: mean of SCR Size

Empty cells will be ignored and don't count in to the mean. When two columns are needed in the input both values have to be present for this row to count for the mean.

For each calculated mean there will be two rows present:

• Mit Null: Ja This is the mean over all given numbers for this column.
• Mit Null: Nein This is the mean over all non zero numbers for this column.

Downloads

Windows-Executable

• V0.1.0.3
• V0.1.0.1

Change log

Version 0.1.0.3

• Added drag and drop for files
• Changed the output for mean calculation