✨Data Intelligence Lab@HKU✨

Extract readable text from PDFs when ordinary file readers return garbled or binary content. The skill guides agents through detecting failed reads and using pdftotext, a command-line PDF text extractor, with layout-preserving options.

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

• Reading PDFs that return garbled text
• Extracting text while preserving page layout
• Working around Python dependency issues in sandboxes

Inspect PowerPoint files when standard readers fail by using python-pptx through the shell. Produce structured results showing slide counts, titles, and shape counts to check presentation structure before delivery.

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

• Inspecting PowerPoint files that standard readers cannot open
• Checking slide counts against requirements
• Finding slides without titles

Diagnose Python script failures by showing error output and exit codes alongside the working directory and file listing. Use these clues to investigate missing files, missing modules, permission errors, or scripts that produce no output.

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

• Investigating Python failures during automated execution
• Checking file paths after a FileNotFoundError
• Diagnosing Python failures in CI/CD pipelines

Run Python through run_shell when execute_code_sandbox fails unexpectedly. The skill explains how to pass multiline code using a heredoc, a shell syntax for inline text, then check standard output and error messages.

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

• Continue Python work after an unknown sandbox error
• Pass multiline Python code to run_shell
• Check Python availability with a simple print statement

Troubleshoot CSV and XLSX processing when execute_code_sandbox fails. The workflow locates input files, saves processing code as a Python script, captures execution errors, checks dependencies and file access, and confirms output exists before reading it.

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

• Recovering spreadsheet processing after sandbox errors
• Locating CSV and XLSX input files
• Diagnosing dependency, path, and encoding errors

Recover from file creation failures in automated tools by creating directories with shell commands and writing files individually. This workflow separates each step so project structures can be created and checked more easily.

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

• Recovering from unknown file creation errors
• Creating nested project directories
• Writing multiple files individually

Extract PDF text when the usual file reader returns errors or unusable output. Choose command-line tools or Python libraries for plain text, metadata, tables, and complex layouts, with checks for scanned or copy-protected documents.

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

• Recovering text when PDF reading fails
• Extracting tables and structured data from PDFs
• Inspecting PDF metadata

Create and edit Excel workbooks by running a complete Python script through the shell. Covers multiple sheets, data entry, formatting, formulas, and saving files when other file-reading or code-execution tools fail.

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

• Create an Excel report with multiple sheets
• Apply data and formatting in one script
• Update cells in an existing XLSX file

Continue regulatory research when official sources cannot be accessed. The skill uses alternative sources or established regulatory knowledge to draft summaries and checklists, while documenting limitations and identifying the need for verification against current official requirements.

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

• Continuing regulatory research after source access failures
• Drafting pharmacy and healthcare compliance checklists
• Documenting unavailable sources and alternative evidence

Recover readable text from PDFs when read_file or Python extraction fails. Use pdftotext, a command-line text extractor, with options to preserve layout, specify character encoding, or save extracted content to a file.

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

• Recovering text after PDF reading fails
• Extracting text while preserving page layout
• Saving text from large PDFs to a file

Check generated PDFs with PyPDF2 before reporting completion. A Python script verifies that each file can be opened and has the expected page count, helping identify outputs that need regeneration.

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

• Checking a generated one-page summary
• Verifying page counts across multiple PDFs
• Checking PDFs before reporting completion

Run Python through the shell when a code sandbox fails to start or connect. Uses a heredoc, a way to pass multiline code, with examples for generating charts, Word documents, and processed JSON files.

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

• Continue Python work when the code sandbox is unavailable
• Create a graph image from Excel data
• Generate a Word document with headings and a table

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

Inspect website responses with curl, using browser-like request headers and checking file size, content, and format. Identify placeholder pages and choose a browser-based or direct API approach when the expected content is missing.

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

• Investigating downloads that contain no page content
• Checking whether a response is HTML, JSON, or PDF
• Fetching pages that vary by browser identification

Organizes creation of a spreadsheet, a diagram, and a summary PDF as a related report package. Allocates attempts across components, checks generated files, and provides fallback methods when a tool or output fails.

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

• Preparing a spreadsheet, diagram, and PDF report together
• Documenting equipment choices, layouts, and costs
• Dividing generation attempts across multiple deliverables

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

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

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

Download PDFs or process local files, extract their text, and turn processed data into structured PDF reports with ReportLab. Includes alternative extraction methods and text output when PDF generation fails.

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

• Extracting text from technical manuals
• Processing PDFs downloaded from websites
• Creating PDF reports with sections and tables

Investigate unclear errors in Python PDF generation by displaying output immediately and inspecting error details. Use the resulting traceback, a record of where execution failed, to identify missing dependencies, font problems, or invalid file paths.

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

• Investigating unknown errors when saving PDFs
• Checking missing fonts and dependencies
• Diagnosing incomplete PDFs or silent crashes

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

Recover PDF or DOCX generation when execute_code_sandbox fails with unclear errors. Use run_shell to execute Python directly, check required libraries, report specific failures, and verify that the output file was created.

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

• Retry PDF generation after an unclear sandbox error
• Generate DOCX files by running Python through the shell
• Check and install missing document libraries

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

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