Index Symbols | _ | A | B | C | D | E | F | G | H | I | K | L | M | O | P | R | S | T | V | W | X Symbols --date-col macpie command line option --engines compare command line option mppair-compare command line option --help macpie-keepone command line option macpie-link command line option --host mpsql command line option --id-col macpie command line option --id2-col macpie command line option --keep macpie command line option macpie-keepone command line option --keep-original macpie-link command line option macpie-merge command line option --merge-results macpie-link command line option --merge-results/--no-merge-results macpie-keepone command line option --no-keep-original macpie-link command line option macpie-merge command line option --no-merge-results macpie-link command line option --password mpsql command line option --port mpsql command line option --primary-keep macpie-keepone command line option macpie-link command line option --secondary-date-col macpie-keepone command line option macpie-link command line option --secondary-days macpie-keepone command line option macpie-link command line option --secondary-get macpie-keepone command line option macpie-link command line option --secondary-id-col macpie-keepone command line option macpie-link command line option --secondary-id2-col macpie-keepone command line option macpie-link command line option --secondary-when macpie-keepone command line option macpie-link command line option --sheet compare command line option --sheet-pair compare command line option --sort-col compare command line option --user mpsql command line option --verbose macpie command line option -c compare command line option -d macpie command line option macpie-keepone command line option macpie-link command line option -e compare command line option mppair-compare command line option -g macpie-keepone command line option macpie-link command line option -h mpsql command line option -i macpie command line option macpie-keepone command line option macpie-link command line option -j macpie command line option macpie-keepone command line option macpie-link command line option -k macpie command line option macpie-keepone command line option, [1] macpie-link command line option -P mpsql command line option -p compare command line option mpsql command line option -s compare command line option -t macpie-keepone command line option macpie-link command line option -u mpsql command line option -v macpie command line option -w macpie-keepone command line option macpie-link command line option _ __init__() (macpie.AnchoredList method) (macpie.BaseCollection method) (macpie.BasicList method) (macpie.Dataset method) (macpie.DatasetFields method) (macpie.LavaDataset method) (macpie.MacDataFrameAccessor method) (macpie.MACPieExcelWriter method) (macpie.MacSeriesAccessor method) (macpie.MergeableAnchoredList method) (macpie.tablibtools.DictLikeTablibDataset method) (macpie.tablibtools.MacpieTablibDataset method) (macpie.util.DataTable method) (macpie.util.Masker method) (macpie.util.MaskMap method) (macpie.util.MethodHistory method) (macpie.util.MethodTimer method) (macpie.xlsxwritertools.XlsxWriterAutofitColumnsWorksheet method) A add_diff_days() (in module macpie.pandas) add_suffix() (in module macpie.strtools) add_suffixes() (in module macpie.strtools) add_suffixes_with_base() (in module macpie.strtools) AnchoredList (class in macpie) any_duplicates() (in module macpie.pandas) assert_excel_worksheet_equal() (in module macpie.testing) assert_excels_equal() (in module macpie.testing) autofit_column_width() (in module macpie.openpyxltools) B BaseCollection (class in macpie) BasicList (class in macpie) C chunks() (in module macpie.lltools) common_members() (in module macpie.lltools) compare command line option --engines --sheet --sheet-pair --sort-col -c -e -p -s LEFT_FILE RIGHT_FILE compare() (in module macpie.pandas) conform() (in module macpie.pandas) copy_file_same_dir() (in module macpie.shelltools) count_trailers() (in module macpie.pandas) create_dir_with_datetime() (in module macpie.pathtools) create_id_col() (macpie.Dataset method) create_subdir() (in module macpie.pathtools) cross_section() (macpie.Dataset method) current_datetime_str() (in module macpie.datetimetools) D DATABASE mpsql command line option Dataset (class in macpie) DatasetFields (class in macpie) DataTable (class in macpie.util) date_proximity() (in module macpie) (in module macpie.pandas) datetime_ms() (in module macpie.datetimetools) DictLikeTablibDataset (class in macpie.tablibtools) diff_cols() (in module macpie.pandas) diff_rows() (in module macpie.pandas) difference() (in module macpie.lltools) display_name_generator (macpie.Dataset property) drop_suffix() (in module macpie.pandas) drop_sys_cols() (macpie.Dataset method) duplicate_indices() (in module macpie.itertools) E equals() (in module macpie.pandas) F file_to_dataframe() (in module macpie.openpyxltools) filter_by_id() (in module macpie.pandas) filter_get_index() (in module macpie.itertools) filter_get_message() (in module macpie.itertools) filter_labels() (in module macpie.pandas) filter_labels_pair() (in module macpie.pandas) filter_seq() (in module macpie.lltools) filter_seq_pair() (in module macpie.lltools) first_true() (in module macpie.itertools) flatten_multiindex() (in module macpie.pandas) from_excel_dict() (macpie.Dataset class method) from_file() (macpie.Dataset class method) G get_col_name() (in module macpie.pandas) get_col_names() (in module macpie.pandas) get_cols_by_prefixes() (in module macpie.pandas) get_column_index() (in module macpie.openpyxltools) get_files_from_dir() (in module macpie.pathtools) get_option() (in module macpie) get_sheet_names() (in module macpie.openpyxltools) group_by_keep_one() (in module macpie) (in module macpie.pandas) H has_csv_extension() (in module macpie.pathtools) has_excel_extension() (in module macpie.pathtools) highlight_row() (in module macpie.openpyxltools) I insert() (in module macpie.pandas) is_date_col() (in module macpie.pandas) is_disjoint() (in module macpie.lltools) is_list_like() (in module macpie.lltools) is_row_empty() (in module macpie.openpyxltools) iter_rows_with_column_value() (in module macpie.openpyxltools) K keep_cols() (macpie.Dataset method) keep_fields() (macpie.Dataset method) L LavaDataset (class in macpie) LEFT_FILE compare command line option list_like_str_equal() (in module macpie.lltools) M MacDataFrameAccessor (class in macpie) macpie command line option --date-col --id-col --id2-col --keep --verbose -d -i -j -k -v PRIMARY macpie-keepone command line option --help --keep --merge-results/--no-merge-results --primary-keep --secondary-date-col --secondary-days --secondary-get --secondary-id-col --secondary-id2-col --secondary-when -d -g -i -j -k, [1] -t -w PRIMARY, [1] SECONDARY macpie-link command line option --help --keep-original --merge-results --no-keep-original --no-merge-results --primary-keep --secondary-date-col --secondary-days --secondary-get --secondary-id-col --secondary-id2-col --secondary-when -d -g -i -j -k -t -w PRIMARY, [1] SECONDARY macpie-merge command line option --keep-original --no-keep-original PRIMARY MACPieExcelWriter (class in macpie) MacpieTablibDataset (class in macpie.tablibtools) MacSeriesAccessor (class in macpie) make_list_if_list_like() (in module macpie.lltools) make_same_length() (in module macpie.lltools) make_tuple_if_list_like() (in module macpie.lltools) make_unique() (in module macpie.strtools) mark_duplicates_by_cols() (in module macpie.pandas) Masker (class in macpie.util) MaskMap (class in macpie.util) maybe_make_list() (in module macpie.lltools) maybe_make_tuple() (in module macpie.lltools) merge() (in module macpie.pandas) MergeableAnchoredList (class in macpie) MethodHistory (class in macpie.util) MethodTimer (class in macpie.util) mimic_dtypes() (in module macpie.pandas) mimic_index_order() (in module macpie.pandas) move_item_to() (in module macpie.lltools) mppair-compare command line option --engines -e mpsql command line option --host --password --port --user -h -p -P -u DATABASE TABLENAME mpsql-createproc command line option PROCNAME mpsql-createtable command line option PROCNAME TABLENAME O overlay() (in module macpie.itertools) P parse() (macpie.MACPieExcelFile method) prepend_level() (macpie.Dataset method) prepend_multi_index_level() (in module macpie.pandas) PRIMARY macpie command line option macpie-keepone command line option, [1] macpie-link command line option, [1] macpie-merge command line option PROCNAME mpsql-createproc command line option mpsql-createtable command line option R read_csv() (in module macpie.pandas) read_excel() (in module macpie) (in module macpie.pandas) (in module macpie.tablibtools) read_file() (in module macpie.pandas) reformat_datetime_str() (in module macpie.datetimetools) remove_duplicates() (in module macpie.lltools) remove_trailers() (in module macpie.pandas) rename_col() (macpie.Dataset method) replace_suffix() (in module macpie.pandas) reset_option() (in module macpie) RIGHT_FILE compare command line option rtrim() (in module macpie.lltools) (in module macpie.pandas) rtrim_longest() (in module macpie.lltools) (in module macpie.pandas) S SECONDARY macpie-keepone command line option macpie-link command line option seq_contains() (in module macpie.strtools) set_option() (in module macpie) sort_by_id2() (macpie.Dataset method) sort_values_pair() (in module macpie.pandas) str_equals() (in module macpie.strtools) str_startswith() (in module macpie.strtools) strip_suffix() (in module macpie.strtools) subset() (in module macpie.pandas) subset_pair() (in module macpie.pandas) T TABLENAME mpsql command line option mpsql-createtable command line option tlset_sheet() (in module macpie.xlsxwritertools) to_datetime() (in module macpie.pandas) to_excel() (macpie.Dataset method) to_excel_dict() (macpie.Dataset method) to_tablib_dataset() (in module macpie.openpyxltools) V validate_bool_kwarg() (in module macpie.validatortools) validate_paths() (in module macpie.pathtools) W worksheet_to_dataframe() (in module macpie.openpyxltools) X XlsxWriterAutofitColumnsWorksheet (class in macpie.xlsxwritertools)