/** * Returns an entry from a given column name as a Double (possibly null). Throws an IllegalArgumentException if the name is not defined in * the header definition. Throws a NumberFormatException if the underlying data cannot be parsed as a double precision floating point * number. * * @param column the column name of the entry, not null * @return the entry, can be null if the value is null or empty */ public Double getDouble(final String column) { int index = _headerDefinition.columnIndex(column); return getDouble(index); }
@Test public void runAccessorTests() { HeaderDefinition headerDefinition1 = HeaderDefinition.of("A", "B", "C", "D"); HeaderDefinition headerDefinition2 = HeaderDefinition.of("A", "B", "C", "D"); Row row1 = Row.of(headerDefinition1, new String[] {"Jim", "Miranda", "1.2", "2009-09-13" }); Row row3 = Row.of(headerDefinition2, new String[] {"Jim", "Miranda", "Elaine", "Kostas" }); TabularResult tr1 = TabularResult.of(headerDefinition1, Arrays.asList(row1, row3)); Assert.assertEquals(tr1.get(0).getString(0), "Jim"); Assert.assertEquals(tr1.get(0).getString(1), "Miranda"); Assert.assertEquals(tr1.get(0).getString(2), "1.2"); Assert.assertEquals(tr1.get(0).getDouble(2), 1.2d, 1e-14); Assert.assertEquals(tr1.get(0).getString(3), "2009-09-13"); Assert.assertEquals(tr1.get(0).getLocalDate(3), LocalDate.of(2009, 9, 13)); Assert.assertEquals(tr1.get(0).getString("A"), "Jim"); Assert.assertEquals(tr1.get(0).getString("B"), "Miranda"); Assert.assertEquals(tr1.get(0).getString("C"), "1.2"); Assert.assertEquals(tr1.get(0).getDouble("C"), 1.2d, 1e-14); Assert.assertEquals(tr1.get(0).getString("D"), "2009-09-13"); Assert.assertEquals(tr1.get(0).getLocalDate("D"), LocalDate.of(2009, 9, 13)); }
@Test public void runAccessorTests() { HeaderDefinition headerDefinition1 = HeaderDefinition.of("A", "B", "C", "D"); HeaderDefinition headerDefinition2 = HeaderDefinition.of("A", "B", "C", "D"); Row row1 = Row.of(headerDefinition1, new String[] {"Jim", "Miranda", "1.2", "2009-09-13" }); Row row3 = Row.of(headerDefinition2, new String[] {"Jim", "Miranda", "Elaine", "Kostas" }); TabularResult tr1 = TabularResult.of(headerDefinition1, Arrays.asList(row1, row3)); Assert.assertEquals(tr1.get(0).getString(0), "Jim"); Assert.assertEquals(tr1.get(0).getString(1), "Miranda"); Assert.assertEquals(tr1.get(0).getString(2), "1.2"); Assert.assertEquals(tr1.get(0).getDouble(2), 1.2d, 1e-14); Assert.assertEquals(tr1.get(0).getString(3), "2009-09-13"); Assert.assertEquals(tr1.get(0).getLocalDate(3), LocalDate.of(2009, 9, 13)); Assert.assertEquals(tr1.get(0).getString("A"), "Jim"); Assert.assertEquals(tr1.get(0).getString("B"), "Miranda"); Assert.assertEquals(tr1.get(0).getString("C"), "1.2"); Assert.assertEquals(tr1.get(0).getDouble("C"), 1.2d, 1e-14); Assert.assertEquals(tr1.get(0).getString("D"), "2009-09-13"); Assert.assertEquals(tr1.get(0).getLocalDate("D"), LocalDate.of(2009, 9, 13)); }
/** * The main body of the code. */ private void run() { QuandlSession session = QuandlSession.create(); TabularResult tabularResultMulti = session.getDataSets( MultiDataSetRequest.Builder .of( QuandlCodeRequest.singleColumn("WIKI/AAPL", CLOSE_COLUMN), QuandlCodeRequest.allColumns("DOE/RWTC") ) .withStartDate(RECENTISH_DATE) .withFrequency(Frequency.MONTHLY) .build()); System.out.println("Header definition: " + tabularResultMulti.getHeaderDefinition()); Iterator<Row> iter = tabularResultMulti.iterator(); while (iter.hasNext()) { Row row = iter.next(); LocalDate date = row.getLocalDate("Date"); Double value = row.getDouble("DOE/RWTC - Value"); System.out.println("Value on date " + date + " was " + value); } }
/** * The main body of the code. */ private void run() { ClassicQuandlSession session = ClassicQuandlSession.create(); TabularResult tabularResult = session.getDataSet( DataSetRequest.Builder .of("SSE/VROS") // VERIANOS REAL ESTATE AG on Boerse Stuttgart .withColumn(3) // Last (looked up previously) .withStartDate(RECENTISH_DATE) .withFrequency(Frequency.MONTHLY) .build()); System.out.println("Header definition: " + tabularResult.getHeaderDefinition()); for (final Row row : tabularResult) { LocalDate date = row.getLocalDate("Date"); Double value = row.getDouble("Last"); System.out.println("Value on date " + date + " was " + value); } }