Post Format

Title is Heading 4

For paragraphs use Paragraph.

For code, use the Code Insert option in the text format tool bar.

# This would be a code insert

def add_task_type_and_priority(df: pd.DataFrame):
    print('Add task type and priority')
    file = open('bow-task-type-and-priority.txt')
    sql = file.read()

    tp = pd.read_sql(sql, ods_connection)
    filter_cols = ['SCHEDULED_DATE', 'STATION', 'AIRCRAFT','WC_NUMBER','JOB_ID']
    tp.drop_duplicates(subset=filter_cols, keep='last', inplace=True)

    result = pd.merge(df, tp, how="left", on=['SCHEDULED_DATE', 'STATION', 'AIRCRAFT','WC_NUMBER','JOB_ID'])
    return result