Re-implement data import using a CSV parser library

[Anastasia Baryshnikova]

USE CASE: WHAT DO YOU WANT TO DO?

Load data in matrix and list formats in a robust and consistent manner.

STEPS TO REPRODUCE AN ISSUE (OR TRIGGER A NEW FEATURE)

File > Open

CURRENT BEHAVIOR

The matrix import function inherited the original Treeview 2 code and does not make it easy to add new functions (new delimiters, new formats etc.).

EXPECTED BEHAVIOR

1. The new import function must use an existing reliable parser for CSV files.
2. The user must specify the file format (matrix or list).
3. The user must specify the delimiter (tab, comma, custom).
4. For matrices, Treeview can guess the row and column headers, and the user can adjust (as implemented now).
5. For lists, by default, column1 is row headers, column2 is column headers, 1st numeric column is data. The user can adjust.
6. Missing data are set to NaN (not zero).
7. The user must have an option to make the matrix symmetric (for both list and matrix inputs).
8. In lists, replicate values (A-B and A-B) are averaged.
9. In both lists and matrices, when "make symmetric" is checked, reciprocal values (A-B and B-A) are averaged. Replicate and reciprocal values are averaged together, not sequentially.

DEVELOPERS ONLY SECTION

SUGGESTED CHANGE (Pseudocode optional)

e.g. Add a color selection class

FILES AFFECTED (where the changes will be implemented) - developers only

e.g. selectColor.java & settingsPanel.java

LEVEL OF EFFORT - developers only

trivial/minor/medium/major/overhaul (choose one)

COMMENTS