public class Program { public static void main(String[] args) { Table A = new Table("tableA.csv"); Table B = new Table("tableB.csv"); Table C = JoinOperator.join(A, B, "email"); // Sanity Check if(C.toString().equals((new Table("expected.csv")).toString())) { System.out.println("Sanity Check Passed"); } else { System.out.println("Sanity Check Failed"); } } } public class JoinOperator { // Complete the join method and pass the sanity check public static Table join(Table A, Table B, String label) { return null; } private static Map joinLabels(Map labelsFromA, Map labelsFromB){ Map map = new HashMap(); int i = 0; for (String key: labelsFromA.keySet()){ if(!map.containsKey(key)){ map.put(key, i++); } } for (String key: labelsFromB.keySet()){ if(!map.containsKey(key)){ map.put(key, i++); } } return map; } private static Map createHashMap(Table A, String label){ HashMap newHashMap = new HashMap<>(); for (int i =0; i labelsForNewTable, Table A, Table B, int rowIndexFromA, int rowIndexFromB) { int size = labelsForNewTable.keySet().size(); String[] data = new String[size]; for (String key: labelsForNewTable.keySet()){ if (A.getCell(rowIndexFromA,key)!= null){ data[labelsForNewTable.get(key)] = A.getCell(rowIndexFromA,key); } if (B.getCell(rowIndexFromB,key)!= null){ data[labelsForNewTable.get(key)] = B.getCell(rowIndexFromB,key); } } return new Row(data); } } public class Row { String[] data; public Row(String[] data) { this.data = data; } public String get(int i) { return data[i]; } public int size() { return data.length; } } public class Table { private Map labels; private List rows; public Table(Map labels, List rows) { this.labels = labels; this.rows = rows; } public Table(String filename) { rows = new ArrayList(); load(filename); } public Map labelMap(){ return labels; } public String getCell(int index, String label) { if(labels.get(label) == null) { return null; } else { return rows.get(index).get(labels.get(label)); } } public int size() { return rows.size(); } private void load(String filename) { try{ String currentDirectory = System.getProperty("user.dir") + "/"; // System.out.println(currentDirectory); BufferedReader bf = new BufferedReader(new FileReader(currentDirectory + filename)); // Parse labels labels = parseLabels(bf.readLine()); // Parse rows String line; while((line = bf.readLine()) != null) { rows.add(parseRow(line)); } bf.close(); } catch(IOException e){ System.out.println("File '" + filename + "' not found."); } } private Map parseLabels(String line) { Map labels = new HashMap(); String[] tokens = line.split(","); for(int i = 0; i < tokens.length; i++) { labels.put(tokens[i], i); } return labels; } private Row parseRow(String line) { return new Row(line.split(",")); } // This is for debugging purposes public String toString() { String[] labelsArray = labels.keySet().toArray(new String[0]); Arrays.sort(labelsArray); String[] rowsArray = new String[this.size()]; for(int i = 0; i < this.size(); i++) { rowsArray[i] = ""; for(int j = 0; j < labelsArray.length; j++) { rowsArray[i] += this.getCell(i, labelsArray[j]) + "|"; } } Arrays.sort(rowsArray); return Arrays.toString(rowsArray); } }

My code 2018/11/29 21:56