def test_csv_excel_equal(self):
csv_path = 'fish-5.csv'
df1 = parse_csv(datafile(csv_path))
excel_path = 'fish-5.xlsx'
df2 = parse_excel(datafile(excel_path))
pd.testing.assert_frame_equal(df1, df2)
def test_read_excel_file_missing_col(self):
path = 'missing-col.xlsx'
self.assertRaises(EmptyDataError, parse_excel(datafile(path)))
def test_read_excel_file_without_suffix(self):
path = 'fish-5'
df = parse_excel(datafile(path))
self.assertEqual(len(df.index), 50)
def test_read_excel_file_empty(self):
path = 'empty.xlsx'
self.assertRaises(EmptyDataError, parse_excel(datafile(path)))
def test_read_excel_file(self):
path = 'fish-5.xlsx'
df = parse_excel(datafile(path))
self.assertEqual(len(df.index), 50)