✨Data Intelligence Lab@HKU✨

Create a related Excel workbook, PNG diagram, and PDF report in one workflow. It allocates execution attempts across stages, checks output files, and provides retries or simpler versions when generation encounters errors.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Preparing a comparison table, diagram, and report together
• Creating a PDF that references spreadsheet findings and diagrams
• Allocating execution attempts across several output formats

Diagnose failed pandoc PDF conversions by checking installed tools, capturing error logs, and trying alternative PDF engines. The workflow helps identify missing fonts or packages and suggests ways to simplify documents when conversion still fails.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating unknown errors during PDF conversion
• Finding missing fonts or LaTeX packages
• Choosing a PDF engine for a document

Prepare Markdown for pandoc PDF conversion by replacing problematic Unicode symbols with ASCII alternatives. The skill covers reusable substitution scripts, broader character conversion, and alternative PDF engines for documents that need to retain Unicode.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Fixing Unicode errors during Markdown-to-PDF conversion
• Standardizing replacements for currency symbols and arrows
• Choosing a PDF engine that preserves Unicode characters

Create PDF checklists, reports, and scorecards with Python in a sandbox, an isolated code execution environment. The workflow covers choosing a library, arranging headings and tables, generating the document, and checking that the output file exists.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Creating a PDF checklist for distribution
• Organizing assessment results into a scorecard
• Producing reports with headings and tables

Turn unstructured clinical encounter summaries into SOAP notes, a four-part format for medical records. Organize symptoms and findings, include diagnoses with ICD-10 classification codes, and document treatment steps, follow-up timing, and reasons to return for care.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Converting unstructured clinical summaries into SOAP notes
• Documenting diagnoses with ICD-10 codes and supporting reasoning
• Organizing treatment details, dosages, and timelines

Extract text from local PDF files with pdftotext or PyMuPDF, a Python library for reading PDFs. Convert individual files or batches into text files that an agent can read for summarization, analysis, or further data extraction.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Converting local PDFs to text for summarization
• Extracting text from multiple PDFs in one batch
• Reading PDFs that appear as binary data in read_file

Handle repeated tool failures by documenting what went wrong and which deliverables remain blocked. Produce useful partial work with clear limits, distinguish unverified content from completed work, and provide concrete steps for recovery or handoff.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Reporting repeated PDF extraction failures
• Providing partial research with clear reliability limits
• Handing off blocked tasks with errors and next steps

Track every required output in tasks involving multiple files, reports, or recipients. Build a checklist, update each item with completion evidence, and review the original requirements before declaring the task finished.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Track a report and presentation requested together
• Check that documents for every department are complete
• Verify all named files exist before finishing

Check which H.264 encoders, the components that compress video, are available in FFmpeg before building a conversion script. Choose an encoding approach and test a small sample before processing long videos or batches.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Check available H.264 encoders
• Investigate libopenh264 compatibility issues
• Choose stream copy when re-encoding is unnecessary

Package project files into a ZIP archive and verify that the deliverable exists and is not empty before completing a task. It also defines a fallback for archiving available files when the agent approaches its iteration limit.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Delivering a code project as a single ZIP file
• Checking that a delivery archive exists and is not empty
• Reviewing files before packaging a project

Handle failed video encoding by checking available encoders, testing a short clip, and trying alternatives. The workflow covers copying without re-encoding, switching codecs, which define video compression, and using MoviePy as another processing option.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Processing uploaded videos with unknown codecs
• Handling video conversion in containers with limited encoder support
• Testing encoding before a large batch

Build Excel spreadsheets with merged titles and headers using openpyxl, a Python library for spreadsheet files. Follow a sequence for entering values, merging cells, and applying formatting, with guidance for updating existing merged ranges and checking saved results.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Creating report titles that span multiple columns
• Formatting section headers and grouped labels
• Updating values in existing merged ranges

Track tasks that require several outputs by listing every deliverable, updating a visible checklist, and verifying that each result exists. Helps prevent work from ending while requested files, reports, or other outputs remain unfinished.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Tracking several files requested in one task
• Managing progress across multiple reports
• Checking all outputs before closing a task

Track every required output in a visible checklist, update progress as each is completed, and review the original requirements before finishing. When one output is blocked, try alternatives and continue work on the remaining deliverables.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Tracking completion of several requested files
• Preparing separate email drafts for multiple recipients
• Checking that every required output is finished

Find generated files that are missing from their expected locations in isolated or temporary execution environments. Search confirmed directories, identify the right file, copy it to the intended destination, and verify that it is readable and nonempty.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Find files after a tool reports successful generation
• Recover deliverables saved in temporary directories
• Correct files saved in unexpected nested folders

Extract data from Excel sheets with misplaced headers, merged header cells, or introductory rows. Uses text patterns to locate headers, clean column names, and remove empty rows so the data can be processed with pandas.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Extracting tables beneath title and metadata rows
• Reading sheets with inconsistent header positions
• Cleaning blank or duplicate column names

Build complex Excel files in four stages: extraction, preparation, calculation, and formatted output. Intermediate CSV files let agents and reviewers inspect data, validate forecasts, locate errors, and rerun individual stages without repeating the entire workflow.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Combining multiple data sources into an Excel file
• Checking intermediate values in sales forecasts
• Locating errors in data preparation or calculations

Use shell heredocs, which pass multiline text directly to a command, when write_file fails on complex code. Save TypeScript, JSX, JSON, or shell scripts with literal quotes and formatting, then verify the file and its contents.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Saving TypeScript or JSX files after repeated write_file failures
• Writing JSON files containing quotes and special characters
• Preserving variables and line breaks in shell scripts

Check which H.264 video encoders are available before writing FFmpeg scripts. Choose an available encoder or copy an existing video stream when appropriate, then test a short clip to catch compatibility problems before processing the full file.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Checking encoders before writing a video conversion script
• Testing a short clip before processing a full video
• Changing containers without re-encoding video

Generate PDF checklists, reports, and scorecards with Python. Organizes content into sections and tables, supports scoring criteria and status colors, and includes steps to locate and verify the generated files.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Creating PDF checklists with status and notes columns
• Preparing scorecards with weights and scores
• Turning findings into a report with multiple sections

Resolve Unicode character errors when converting Markdown to PDF with pandoc. Follow a workflow to replace troublesome symbols with ASCII equivalents, regenerate and check the PDF, or consider another PDF engine when preserving characters matters.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Resolve Unicode errors during Markdown-to-PDF conversion
• Replace troublesome symbols in a document
• Consider PDF engines that preserve Unicode characters

Continue Excel file creation and editing when execute_code_sandbox repeatedly fails with openpyxl errors. Use run_shell to run Python directly, then check that the workbook was saved with the expected sheets and content.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Continuing Excel creation after sandbox errors
• Editing existing workbooks and adjusting column widths
• Checking saved workbook sheets and content

Locate missing files and verify their full paths before processing them. This workflow checks directory contents, searches by filename, and inspects permissions, size, and modification time to help resolve FileNotFoundError, an error indicating a file could not be found.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Investigating FileNotFoundError
• Finding files with unknown locations
• Checking file existence and permissions before processing

Generate PDF checklists, reports, and assessments with sections, tables, and scoring criteria using Python. Choose a suitable library, save the document for download, and check the output, with shell execution as an alternative when the sandbox fails.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

• Turn a checklist into a PDF with sections and tables
• Create an assessment report with criteria and scores
• Produce PDF reports containing charts