def test_index_sheet2(self): s = pe.ColumnSeriesReader(self.testfile, series=0) actual = pe.to_records(s) result = [ {'1.0': 4.0, 'X': 'Y', '3.0': 6.0, '2.0': 5.0}, {'1.0': 7.0, 'X': 'Z', '3.0': 9.0, '2.0': 8.0} ] assert actual == result
def test_index_sheet2(self): s = pe.ColumnSeriesReader(self.testfile, series=0) actual = pe.to_records(s) result = [ {'1': 4, 'X': 'Y', '3': 6, '2': 5}, {'1': 7, 'X': 'Z', '3': 9, '2': 8} ] self.assertEqual(result, actual)
def test_book_reader_to_records(self): r = pe.SeriesReader(self.testfile) result = [ {u'Y': 4.0, u'X': 1.0, u'Z': 7.0}, {u'Y': 5.0, u'X': 2.0, u'Z': 8.0}, {u'Y': 6.0, u'X': 3.0, u'Z': 9.0}] actual = pe.to_records(r) self.assertEqual(result, actual)
def test_index_sheet2(self): s = pe.ColumnSeriesReader(self.testfile, 0) actual = pe.to_records(s) result = [ {1.0: 4.0, 'X': 'Y', 3.0: 6.0, 2.0: 5.0}, {1.0: 7.0, 'X': 'Z', 3.0: 9.0, 2.0: 8.0} ] assert actual == result
def test_index_sheet3(self): s = pe.ColumnSeriesReader(self.testfile, series=0) headers = ["Row 1", "Row 2", "Row 3", "Row 4"] actual = pe.to_records(s, headers) print(actual) result = [ {'Row 4': 6.0, 'Row 2': 4.0, 'Row 1': 'Y', 'Row 3': 5.0}, {'Row 4': 9.0, 'Row 2': 7.0, 'Row 1': 'Z', 'Row 3': 8.0} ] self.assertEqual(result, actual)
def test_book_reader_to_records_custom(self): """use custom header """ r = pe.SeriesReader(self.testfile) custom_headers = ["O", "P", "Q"] result = [ {u'P': 4.0, u'O': 1.0, u'Q': 7.0}, {u'P': 5.0, u'O': 2.0, u'Q': 8.0}, {u'P': 6.0, u'O': 3.0, u'Q': 9.0}] actual = pe.to_records(r, custom_headers) self.assertEqual(result, actual)
def test_index_sheet2(self): s = pe.ColumnSeriesReader(self.testfile, series=0) actual = pe.to_records(s) result = [{ '1.0': 4.0, 'X': 'Y', '3.0': 6.0, '2.0': 5.0 }, { '1.0': 7.0, 'X': 'Z', '3.0': 9.0, '2.0': 8.0 }] assert actual == result
def test_index_sheet2(self): s = pe.ColumnSeriesReader(self.testfile, series=0) actual = pe.to_records(s) result = [{ '1': 4, 'X': 'Y', '3': 6, '2': 5 }, { '1': 7, 'X': 'Z', '3': 9, '2': 8 }] self.assertEqual(result, actual)
def test_index_sheet3(self): s = pe.ColumnSeriesReader(self.testfile, series=0) headers = ["Row 1", "Row 2", "Row 3", "Row 4"] actual = pe.to_records(s, headers) print(actual) result = [{ 'Row 4': 6.0, 'Row 2': 4.0, 'Row 1': 'Y', 'Row 3': 5.0 }, { 'Row 4': 9.0, 'Row 2': 7.0, 'Row 1': 'Z', 'Row 3': 8.0 }] assert actual == result
def test_book_reader_to_records(self): r = pe.SeriesReader(self.testfile) result = [{ u'Y': 4.0, u'X': 1.0, u'Z': 7.0 }, { u'Y': 5.0, u'X': 2.0, u'Z': 8.0 }, { u'Y': 6.0, u'X': 3.0, u'Z': 9.0 }] actual = pe.to_records(r) assert actual == result
def test_book_reader_to_records_custom(self): """use custom header """ r = pe.SeriesReader(self.testfile) custom_headers = ["O", "P", "Q"] result = [{ u'P': 4.0, u'O': 1.0, u'Q': 7.0 }, { u'P': 5.0, u'O': 2.0, u'Q': 8.0 }, { u'P': 6.0, u'O': 3.0, u'Q': 9.0 }] actual = pe.to_records(r, custom_headers) assert actual == result
def test_book_reader_to_records_with_wrong_args(self): r = pe.BookReader(self.testfile) pe.to_records(r)
def test_index_sheet1(self): """Invalid input""" s = pe.sheets.NominableSheet([[1,2,3]], "test") pe.to_records(s)
def test_index_sheet1(self): """Invalid input""" s = pe.sheets.NominableSheet([[1, 2, 3]], "test") pe.to_records(s)
def test_index_sheet1(self): """Invalid input""" s = pe.sheets.IndexSheet([[1,2,3]], "test") actual = pe.to_records(s)