CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files
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., Psycho...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Ubiquity Press
2021-12-01
|
| Series: | Journal of Open Research Software |
| Subjects: | |
| Online Access: | https://openresearchsoftware.metajnl.com/articles/368 |
| _version_ | 1798022360128815104 |
|---|---|
| author | James R. Schmidt |
| author_facet | James R. Schmidt |
| author_sort | James R. Schmidt |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-04-11T17:28:39Z |
| format | Article |
| id | doaj.art-2a0315bc74d34bd28024734a5291dd3e |
| institution | Directory Open Access Journal |
| issn | 2049-9647 |
| language | English |
| last_indexed | 2024-04-11T17:28:39Z |
| publishDate | 2021-12-01 |
| publisher | Ubiquity Press |
| record_format | Article |
| series | Journal of Open Research Software |
| spelling | doaj.art-2a0315bc74d34bd28024734a5291dd3e2022-12-22T04:12:13ZengUbiquity PressJournal of Open Research Software2049-96472021-12-019110.5334/jors.368264CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data FilesJames R. Schmidt0Associate Professor, LEAD-CNRS UMR 5022, Université Bourgogne Franche-Comté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.https://openresearchsoftware.metajnl.com/articles/368data mergingexperimental psychologycsv filesjavasortingempty cells |
| spellingShingle | James R. Schmidt CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files Journal of Open Research Software data merging experimental psychology csv files java sorting empty cells |
| title | CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files |
| title_full | CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files |
| title_fullStr | CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files |
| title_full_unstemmed | CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files |
| title_short | CSVDataMerge: A Simple and Free Program for Concatenating Experimental Data Files |
| title_sort | csvdatamerge a simple and free program for concatenating experimental data files |
| topic | data merging experimental psychology csv files java sorting empty cells |
| url | https://openresearchsoftware.metajnl.com/articles/368 |
| work_keys_str_mv | AT jamesrschmidt csvdatamergeasimpleandfreeprogramforconcatenatingexperimentaldatafiles |