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_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.IndexSheet([[1,2,3]], "test")
actual = pe.to_records(s)
