Skip to main content
Ctrl+K
Logo image

Site Navigation

  • Home
  • Getting Started
  • CLI Reference
  • API Reference
  • Release notes

Site Navigation

  • Home
  • Getting Started
  • CLI Reference
  • API Reference
  • Release notes

Section Navigation

  • Dataset
    • macpie.Dataset
    • macpie.Dataset.create_id_col
    • macpie.Dataset.rename_col
    • macpie.Dataset.prepend_level
    • macpie.Dataset.drop_sys_cols
    • macpie.Dataset.keep_cols
    • macpie.Dataset.keep_fields
    • macpie.date_proximity
    • macpie.group_by_keep_one
    • macpie.Dataset.sort_by_id2
    • macpie.Dataset.cross_section
    • macpie.Dataset.display_name_generator
    • macpie.Dataset.to_excel_dict
    • macpie.Dataset.from_excel_dict
    • macpie.DatasetFields
    • macpie.LavaDataset
  • Dataset Collections
    • macpie.BasicList
    • macpie.AnchoredList
    • macpie.MergeableAnchoredList
    • macpie.BaseCollection
  • Input/output
    • macpie.read_excel
    • macpie.Dataset.to_excel
    • macpie.Dataset.from_file
    • macpie.MACPieExcelFile.parse
    • macpie.MACPieExcelWriter
  • Pandas
    • macpie.pandas.read_csv
    • macpie.pandas.read_excel
    • macpie.pandas.read_file
    • macpie.pandas.filter_by_id
    • macpie.pandas.filter_labels
    • macpie.pandas.filter_labels_pair
    • macpie.pandas.get_col_name
    • macpie.pandas.get_col_names
    • macpie.pandas.get_cols_by_prefixes
    • macpie.pandas.remove_trailers
    • macpie.pandas.rtrim
    • macpie.pandas.rtrim_longest
    • macpie.pandas.subset
    • macpie.pandas.subset_pair
    • macpie.pandas.drop_suffix
    • macpie.pandas.flatten_multiindex
    • macpie.pandas.insert
    • macpie.pandas.prepend_multi_index_level
    • macpie.pandas.replace_suffix
    • macpie.pandas.add_diff_days
    • macpie.pandas.any_duplicates
    • macpie.pandas.count_trailers
    • macpie.pandas.is_date_col
    • macpie.pandas.mark_duplicates_by_cols
    • macpie.pandas.date_proximity
    • macpie.pandas.merge
    • macpie.pandas.compare
    • macpie.pandas.diff_cols
    • macpie.pandas.diff_rows
    • macpie.pandas.equals
    • macpie.pandas.conform
    • macpie.pandas.mimic_dtypes
    • macpie.pandas.mimic_index_order
    • macpie.pandas.to_datetime
    • macpie.pandas.group_by_keep_one
    • macpie.pandas.sort_values_pair
    • macpie.MacDataFrameAccessor
    • macpie.MacSeriesAccessor
  • Tools
    • macpie.datetimetools.current_datetime_str
    • macpie.datetimetools.datetime_ms
    • macpie.datetimetools.reformat_datetime_str
    • macpie.itertools.duplicate_indices
    • macpie.itertools.filter_get_index
    • macpie.itertools.filter_get_message
    • macpie.itertools.first_true
    • macpie.itertools.overlay
    • macpie.lltools.chunks
    • macpie.lltools.common_members
    • macpie.lltools.difference
    • macpie.lltools.filter_seq
    • macpie.lltools.filter_seq_pair
    • macpie.lltools.is_disjoint
    • macpie.lltools.is_list_like
    • macpie.lltools.list_like_str_equal
    • macpie.lltools.make_list_if_list_like
    • macpie.lltools.make_same_length
    • macpie.lltools.make_tuple_if_list_like
    • macpie.lltools.maybe_make_list
    • macpie.lltools.maybe_make_tuple
    • macpie.lltools.move_item_to
    • macpie.lltools.remove_duplicates
    • macpie.lltools.rtrim
    • macpie.lltools.rtrim_longest
    • macpie.openpyxltools.autofit_column_width
    • macpie.openpyxltools.file_to_dataframe
    • macpie.openpyxltools.get_column_index
    • macpie.openpyxltools.get_sheet_names
    • macpie.openpyxltools.highlight_row
    • macpie.openpyxltools.is_row_empty
    • macpie.openpyxltools.iter_rows_with_column_value
    • macpie.openpyxltools.to_tablib_dataset
    • macpie.openpyxltools.worksheet_to_dataframe
    • macpie.pathtools.create_dir_with_datetime
    • macpie.pathtools.create_subdir
    • macpie.pathtools.get_files_from_dir
    • macpie.pathtools.has_csv_extension
    • macpie.pathtools.has_excel_extension
    • macpie.pathtools.validate_paths
    • macpie.shelltools.copy_file_same_dir
    • macpie.strtools.add_suffix
    • macpie.strtools.add_suffixes
    • macpie.strtools.add_suffixes_with_base
    • macpie.strtools.make_unique
    • macpie.strtools.seq_contains
    • macpie.strtools.str_equals
    • macpie.strtools.str_startswith
    • macpie.strtools.strip_suffix
    • macpie.tablibtools.MacpieTablibDataset
    • macpie.tablibtools.DictLikeTablibDataset
    • macpie.tablibtools.read_excel
    • macpie.validatortools.validate_bool_kwarg
    • macpie.xlsxwritertools.tlset_sheet
    • macpie.xlsxwritertools.XlsxWriterAutofitColumnsWorksheet
  • Utilities
    • macpie.util.DataTable
    • macpie.util.MethodHistory
    • macpie.util.MethodTimer
    • macpie.util.Masker
    • macpie.util.MaskMap
  • Options
    • macpie.reset_option
    • macpie.get_option
    • macpie.set_option
  • Testing
    • macpie.testing.assert_excels_equal
    • macpie.testing.assert_excel_worksheet_equal
  • API Reference
  • Testing

Testing#

assert_excels_equal(filepath_1, filepath_2)

For testing equality of openpyxl.workbook.workbook.Workbook objects

assert_excel_worksheet_equal(left_ws, right_ws)

For testing equality of openpyxl.worksheet.worksheet.Worksheet objects

© Copyright 2022, Regents of the University of California.

Created using Sphinx 7.0.1.

Built with the PyData Sphinx Theme 0.13.3.