✨Data Intelligence Lab@HKU✨

Troubleshoot access to government and institutional websites by checking connectivity, SSL certificates, and proxy settings. Follow a structured process to test request options, configure retries, and identify alternative data sources when access fails.

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

• Investigating SSL certificate errors
• Comparing browser and script connectivity
• Checking proxy authentication failures

Check deliverables before marking a task complete. Review the requested file format, confirm every reference file was used, and compare the result with the original request to catch omissions and work that misses the goal.

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

• Checking deliverables before submission
• Reviewing coverage of multiple reference files
• Verifying requested output formats

Create internal and external documents from one reference source. Extract deadlines, responsibilities, procedures, and policies, tailor content for each audience, and check that terminology, formatting, versions, and references stay consistent while internal information remains appropriately restricted.

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

• Creating internal procedures and customer guidelines from one source
• Organizing deadlines, responsibilities, and process steps
• Separating internal information from external documents

Run multi-line Python scripts through run_shell when execute_code_sandbox repeatedly fails. The guide explains heredocs, a way to pass blocks of text to a command, with examples for PDF creation, data processing, and inspecting errors.

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

• Running Python after repeated sandbox errors
• Creating a PDF with ReportLab
• Summarizing CSV data with pandas

Diagnose connection problems with government websites by checking SSL certificates, which verify website identity, and proxy settings. Follow structured troubleshooting steps, record failed attempts, and explore alternative APIs or data sources when access remains blocked.

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

• Diagnosing certificate errors on government websites
• Checking whether proxy settings block data access
• Finding alternative sources for inaccessible public data

Create a structured Markdown report when multiple retrieval tools fail. Using available domain knowledge, the workflow separates verified facts from general guidance, marks missing data, and saves a document with limitations and practical next steps.

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

• Drafting a report when search and file reading fail
• Organizing general guidance into a structured document
• Marking missing data for later completion

Check whether a file creation or transformation task actually succeeded after an unclear execution error. Inspect output files and their contents to distinguish success, partial completion, and failure before deciding whether to retry.

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

• Checking output files after an unknown error
• Validating spreadsheet or JSON contents
• Deciding whether to retry or fix incomplete output

Describe the files you want created, updated, or organized, and let shell_agent choose how to perform the work. It selects tools such as Python or Bash, executes the operation, and handles errors with retries.

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

• Creating a document with specified content and format
• Updating multiple configuration files
• Creating a Python project structure

Diagnose failed connections to government websites and corporate portals by checking network access, SSL certificates, and proxy settings. If access remains unavailable, the workflow helps identify alternative data sources and document attempts and next steps.

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

• Investigating SSL certificate errors
• Checking connections through a corporate proxy
• Finding alternative sources for inaccessible data

Build Web3 applications, combining blockchain contracts with a user interface, in a defined sequence. Organize directories, define interfaces, implement and test contracts, configure wallet connections, build components, and prepare deployment scripts.

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

• Planning a Web3 project's directory structure
• Defining interfaces for external protocol integrations
• Building wallet-connected contract interaction screens

Recover from failed inline Python execution by saving the code as a script, running it through the shell, and checking the output. The four-step workflow helps diagnose errors in multiline code and spreadsheet generation tasks.

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

• Recovering from failed inline Python execution
• Diagnosing heredoc parsing errors
• Debugging complex multiline scripts

Check generated PDFs with PyPDF2, a Python library for reading PDF files. Verify that files exist, contain data, open successfully, and match expected page counts, then use failures to guide regeneration and another verification pass.

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

• Checking PDFs after generation
• Verifying exact page count requirements
• Validating multiple related PDF outputs

Create PDF reports from existing PDFs using command-line tools. The workflow checks source files, extracts text, organizes report sections, and generates or merges PDFs, with alternative output methods depending on the tools available.

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

• Building a report from several source PDFs
• Checking PDF page counts and required terms
• Extracting text from selected PDF pages

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

Create PowerPoint presentations with specified slide content and structure, switching from shell_agent to python-pptx if generation fails. The workflow also locates misplaced files, checks their size and type, and records errors to help diagnose problems.

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

• Create slides with specified titles and bullet points
• Retry presentation creation after shell_agent failures
• Locate PowerPoint files saved in unexpected folders

Create PowerPoint presentations with shell_agent, then switch to Python and python-pptx if generation fails. The workflow captures error details, locates output files, and checks that the presentation opens and contains the expected slides.

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

• Creating slides from a specified outline
• Recovering from presentation generation errors
• Locating PowerPoint files saved in unexpected folders

Create PowerPoint presentations through shell_agent with specified slide counts and content, then locate the resulting files in nested workspace folders. Copy the presentation to the working directory and check that it exists and is not empty.

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

• Creating slides with specified content and structure
• Generating presentations when document tools fail
• Locating presentations in nested folders

Diagnose Python script failures by capturing full error traces, which show where execution failed, alongside exit codes and working directory details. The skill also covers file existence checks and clearer paths for troubleshooting.

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

• Investigate Python failures with unclear error messages
• Find why a script cannot locate its input file
• Add diagnostic output to file processing scripts

Run Python through shell commands when sandbox execution fails because required packages are unavailable. The skill explains short commands, multiline scripts, package checks, and output verification, with examples for creating Excel and Word files.

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

• Continuing Python work after sandbox import failures
• Creating Excel or Word files through shell commands
• Running multiline Python scripts with a heredoc

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

Continue regulatory research when government pages or PDFs cannot be retrieved. Use alternative sources to draft compliance checklists, clearly distinguish the basis of each finding, and identify requirements that need confirmation from the relevant authority.

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

• Continue research when government PDFs cannot be retrieved
• Draft compliance checklists from secondary sources
• Organize preliminary notes on pharmacy compliance

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

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

Apply ReportLab’s built-in paragraph styles to PDF titles, headings, and body text. Learn how to reuse existing styles and create named variations without duplicate style names that can cause KeyError exceptions.

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

• Applying consistent styles to PDF titles and body text
• Checking available built-in paragraph styles
• Creating a custom style based on an existing one