Python parse_excel Examples

Example #1

File: test.py Project: JolleJolles/movekit

    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)

Example #2

File: test.py Project: JolleJolles/movekit

 def test_read_excel_file_missing_col(self):
     path = 'missing-col.xlsx'
     self.assertRaises(EmptyDataError, parse_excel(datafile(path)))

Example #3

File: test.py Project: JolleJolles/movekit

 def test_read_excel_file_without_suffix(self):
     path = 'fish-5'
     df = parse_excel(datafile(path))
     self.assertEqual(len(df.index), 50)

Example #4

File: test.py Project: JolleJolles/movekit

 def test_read_excel_file_empty(self):
     path = 'empty.xlsx'
     self.assertRaises(EmptyDataError, parse_excel(datafile(path)))

Example #5

File: test.py Project: JolleJolles/movekit

 def test_read_excel_file(self):
     path = 'fish-5.xlsx'
     df = parse_excel(datafile(path))
     self.assertEqual(len(df.index), 50)