Have a personal or library account? Click to login
CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files Cover

CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files

Open Access
|Dec 2021

Abstract

In experimental psychology and other applications, researchers will often have numerous datafiles (e.g., one for each participant) that need to be joined together into one larger dataset before data analyses. Many experimental software programs, including some increasingly popular ones (e.g., PsychoPy or OpenSesame), do not include data merging functionality. Copy-and-pasting (potentially error prone) or the writing of situation-specific scripts (potentially difficult and time consuming) may be necessary. CSVDataMerge was created as a free Java application that merges CSV (or comma-separated TXT) data with little more than a double-click. The program also appropriately deals with datasets that have different column orders in different datafiles or empty cells. More trivially, it can also concatenate datafiles that do not contain headers and allows the user to specify which columns to keep and in what order.

DOI: https://doi.org/10.5334/jors.368 | Journal eISSN: 2049-9647
Language: English
Submitted on: Feb 5, 2021
|
Accepted on: Nov 29, 2021
|
Published on: Dec 10, 2021
Published by: Ubiquity Press
In partnership with: Paradigm Publishing Services
Publication frequency: 1 issue per year

© 2021 James R. Schmidt, published by Ubiquity Press
This work is licensed under the Creative Commons Attribution 4.0 License.