✨Data Intelligence Lab@HKU✨

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

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

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

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

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

Diagnose PDF conversion failures in pandoc by checking installed conversion engines, capturing full error logs, and investigating missing fonts or packages. Follow a structured sequence of retries and fallback methods to find a working conversion route.

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

• Investigate an unknown error during PDF conversion
• Check which PDF engines are installed
• Find missing fonts or LaTeX packages

Download PDFs, check that the files contain valid content, and try several text extraction tools in sequence. The workflow helps detect downloaded error pages, insufficient text, and extraction failures while recording diagnostic details.

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

• Extract text from official PDF handbooks
• Check whether a downloaded PDF is actually an error page
• Try another extractor when PDF text extraction fails

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

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

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

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

Extract readable PDF text when read_file returns binary or image data. Check the filetype parameter, run pdftotext, a command-line text extractor, and inspect output and errors, with temporary file output as an alternative.

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

• Extracting PDF text after binary data is returned
• Checking read_file parameter names during troubleshooting
• Saving extracted text when direct output has issues

Extract readable text from PDFs when normal file reading returns garbled or unusable content. The workflow switches between extraction tools, checks the results, and includes optical character recognition for scanned pages when needed.

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

• Recovering readable text from garbled PDF output
• Preparing PDF text for data processing
• Extracting text from scanned PDFs

Generate PDF documents when sandbox execution fails with unclear errors. Check available Python libraries, switch to direct shell execution, and verify the resulting file while collecting error details to help diagnose problems.

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

• Generating a PDF after sandbox execution fails
• Checking PDF libraries and choosing an alternative
• Verifying generated PDFs and investigating errors

Recover document and PDF generation tasks when sandbox errors provide little detail. Checks Python libraries, runs generation through the shell, captures errors, and verifies output files, with alternative PDF tools and text output as fallback options.

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

• Recovering PDF generation after unclear sandbox errors
• Checking required PDF libraries before generation
• Capturing detailed document generation errors

Extract PDF text using a sequence of tools when one method fails. Validate downloaded files, check whether the extracted text is substantial, record the successful method, and investigate alternative sources if extraction remains unsuccessful.

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

• Extracting text from regulatory documents and handbooks
• Checking whether a PDF download returned an error page
• Trying another tool after empty or garbled text extraction

Recover from Pandoc PDF generation failures by checking installed PDF engines and retrying alternatives. The guide matches engines to Unicode text, simple Latin documents, or HTML-based layouts, and includes an automated fallback script.

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

• Retrying failed Pandoc PDF conversions
• Choosing an engine for Japanese or other Unicode text
• Automating PDF engine fallback in document pipelines

Retrieve PDFs from web sources and extract their text through an ordered sequence: direct reading, pdftotext, then PyMuPDF. Includes file validation, extraction checks, and guidance for documenting inaccessible sources and distinguishing supplementary content.

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

• Retrieving and reading PDFs from government websites
• Extracting text from technical manuals
• Handling PDF extraction failures in automated workflows

Extract text from PDFs by checking each tool’s output and switching methods when needed. Guides agents from file reading to pdftotext and PyMuPDF, then checks readability, missing sections, and records extraction failures.

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

• Extract text from local or downloaded PDFs
• Switch tools when file reading returns binary data
• Check extracted text for readability and missing sections

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

Create spreadsheets, diagrams, and PDF reports in a staged workflow. Allocate execution attempts across deliverables, check generated files, and use simpler methods or alternative formats when tool errors or limited remaining attempts interrupt progress.

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

• Preparing a comparison spreadsheet, diagram, and report
• Allocating execution attempts across several deliverables
• Recovering from file generation errors with fallback methods

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

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