I have been working in the Psychology Department at the University of Kent for nearly a year now and during this time I’ve been asked to write experiment and programs for a wide range of tasks. In addition, I have found myself helping students and staff handling the data generated by both my programs and 3rd party software. One particular operation that I seem to be carrying out on virtually a weekly basis, is to manipulate a table of data. Whilst it only takes a couple of minutes to knock together a piece of code to actually manipulate the data in the way that I need, it is wasted time. So this weekend I put together a little Java program that I carried out three of the common manipulations that I do.
At present there are four manipulations the program allows you to carry out:
- Swap columns and rows over
- Reverse the order of the columns
- Reverse the order of the rows
- Convert the table into a single row of data
In future version I plan to add the ability to specify you own delimiter, in case you are using something really strange, and possibly look at the feasibility of loading other file types i.e. excel, spss, etc.
