TFLsTool

This is a toolkit related to TFL (Tables, Figures, and Listings) generation in the field of clinical biostatistics for pharmaceuticals

Main Features

• extract_shell_to_tracker() extracting table types, table numbers, titles, and footnotes from DOCX format mock shells into a tracker, enabling statistical programmers to efficiently generate TFLs.
• completeness_report() extract the completion status of the Production side and QC side from the tracker.xlsx, and then create graphs report based on the status and send emails.

Installation

pip install TFLsTool

Example

Enter the TFL path, extraction requirements, delimiter, document language, and output path, then run the program.

extract_shell_to_tracker()

Use in python

from TFLsTool import extract_shell_to_tracker

extract_shell_to_tracker(

    table_path='./project-table.docx',
    table_conditions_list=[["Table", re.compile(r'\d'), '.']],
    
    listing_path='./project-listings.docx',
    listing_conditions_list=[["Listing", re.compile(r'\d'), '.']],
    
    figure_path='./project-figures.docx',
    figure_conditions_list=[["Figures", re.compile(r'\d'), '.']],

    title_split='\n',
    language='EN',
    output_path='./tracker_results.xlsx'
)

Use in SAS Viya

proc python;
submit;

from TFLsTool import extract_shell_to_tracker
extract_shell_to_tracker(
    table_path='./project-table.docx',
    table_conditions_list=[["Table", re.compile(r'\d'), '.']],
    
    listing_path='./project-listings.docx',
    listing_conditions_list=[["Listing", re.compile(r'\d'), '.']],
    
    figure_path='./project-figures.docx',
    figure_conditions_list=[["Figures", re.compile(r'\d'), '.']],

    title_split='\n',
    language='EN',
    output_path='./tracker_results.xlsx'
)

endsubmit;
run;

completeness_report()

Use in python

from TFLsTool import completeness_report

completeness_report(
    file_path='./tracker.xlsx',
    sheet_name='sheet',
    ds_select_list=['Type', 'SP', 'Pstatus', 'QC', 'Qstatus'],
    ds_status_list=['Ready', 'Complete'],
    project='Name of the project',
    side='all',

    email_sender = [
        '[email protected]',
        'thisispassword'
        ],
    email_recipient = ['[email protected]', '[email protected]'],
    email_cc = ['[email protected]', '[email protected]'], 
    outpath='./output'
)

Use in SAS Viya

proc python;
submit;

from TFLsTool import completeness_report
completeness_report(
    file_path='./tracker.xlsx',
    sheet_name='sheet',
    ds_select_list=['Type', 'SP', 'Pstatus', 'QC', 'Qstatus'],
    ds_status_list=['Ready', 'Complete'],
    project='Name of the project',
    side='all',

    email_sender = [
        '[email protected]',
        'thisispassword'
        ],
    email_recipient = ['[email protected]', '[email protected]'],
    email_cc = ['[email protected]', '[email protected]'], 
    outpath='./output'
)

endsubmit;
run;

More information: https://tflstool.readthedocs.io/zh-cn/latest/

Read this in other languages: English, 中文.