In [ ]:

    

# ===============================================PCS Data
df_pcs_left, df_pcs_right = read_excel_split(
    excel_dir=excel_dir, sheet_name='sum_pcs', left_parse_col=pcs_left_parse_cols, 
    right_parse_col=pcs_right_parse_cols, skip_footer=57, fill_nan=None)
# ================================================= Cross Dock Parcel Data ==========================
df_cross_left, df_cross_right = read_excel_split(
    excel_dir=excel_dir, sheet_name='crossdock by pcs', left_parse_col=cross_d_left_parse_cols, 
    right_parse_col=cross_d_right_parse_cols, skip_footer=57, fill_nan=0)


    

In [ ]:

    

# ====================================get left table =======================================
a_df_cross_left = a_pcs.get_left_table(df=df_cross_left, 
                                       select_list=cross_parcel_sum_selctc_left, 
                                       left_round_list=sort_parcel_sum_left_round_list)
log(f'Cross Dock Parcel Left Size: {a_df_cross_left.index.size}')
# a_df_cross_left.tail(7)
# ====================================get right table ======================================
a_df_cross_right = a_pcs.get_right_table(
    df=df_cross_right, 
    drop_col='model', 
    round_list=right_round_list, index_slip_name=index_slip_name, column_index_data_name='cross_sum')

log(f'Cross Dock Parcel Right Size: {a_df_cross_right.index.size}')
a_df_cross_right.tail(2)
# ====================================merge data ===========================================
a_df_cross_data = a_pcs.get_merge_table(
    df_left=a_df_cross_left, 
    df_right=a_df_cross_right, merge_on=in_tabel_merge_on , drop_cloum=in_tabel_merge_on)
log(f'Cross Dock Parcel Data Size: {a_df_cross_data.index.size}')
a_df_cross_data = a_df_cross_data.rename_axis({"by_pcs_of_ULD": "cross_by_pcs_of_ULD"}, axis="columns")
a_df_cross_data.head(2)