public static void main(String[] args) {
Table nationalityLIS =
Utils.readTable(
"/home/plibin0/myWorkspace/regadb-io-db/src/net/sf/regadb/io/db/ghb/mapping/LIS-nationality.csv");
Table nationalityDefault =
Utils.readTable(
"/home/plibin0/myWorkspace/regadb-analyses/io-assist-files/countrylist.csv");
int CLISCode = Utils.findColumn(nationalityLIS, "codePost");
int CLISName = Utils.findColumn(nationalityLIS, "internationaleOmschrijving");
int CDefaultCode = Utils.findColumn(nationalityDefault, "ISO 3166-1 2 Letter Code");
int CDefaultName = Utils.findColumn(nationalityDefault, "Common Name");
List<Attribute> regadbAttributesList = Utils.prepareRegaDBAttributes();
Attribute countryOfOrigin = Utils.selectAttribute("Country of origin", regadbAttributesList);
for (int i = 1; i < nationalityLIS.numRows(); i++) {
String LISCode = nationalityLIS.valueAt(CLISCode, i);
String LISName = nationalityLIS.valueAt(CLISName, i);
String match = "";
for (int j = 1; j < nationalityDefault.numRows(); j++) {
String defaultCode = nationalityDefault.valueAt(CDefaultCode, j);
String defaultName = nationalityDefault.valueAt(CDefaultName, j);
if (LISCode.trim().toLowerCase().equals(defaultCode.trim().toLowerCase())) {
match = defaultName;
break;
}
}
System.err.println("\"" + LISCode + "\"" + "," + "\"" + match + "\"");
}
}
public WAbstractItemModel readFromCsv(Table csv) {
WAbstractItemModel model = new WStandardItemModel();
for (int r = 0; r < csv.numRows(); r++) {
if (r != 0) model.insertRow(r - 1);
for (int c = 0; c < csv.numColumns(); c++) {
String value = csv.valueAt(c, r);
if (r == 0) {
model.insertColumn(c);
model.setHeaderData(c, Orientation.Horizontal, value);
} else {
try {
Double d = Double.valueOf(value);
model.setData(r - 1, c, d);
} catch (NumberFormatException e) {
model.setData(r - 1, c, value);
}
}
}
}
return model;
}