Skill UI

This guide provides a comprehensive workflow for searching and retrieving biomedical literature from PubMed and NCBI. It covers advanced query construction using MeSH terms and specific field tags, advanced filtering (date, publication type), and a repeatable programmatic workflow using NCBI E-utilities (esearch, efetch). Essential for researchers conducting systematic reviews and literature monitoring.

This comprehensive guide covers essential operations for handling PDF documents, including text, table, and metadata extraction using libraries like pdfplumber. It details document creation with reportlab, merging/splitting with pypdf/qpdf, and advanced OCR for scanned PDFs. Ideal for automating complex document workflows and structured data ingestion.

This powerful tool compares identical tables across two SQL Server instances (e.g., Production vs. Staging). It efficiently detects missing rows, extra columns, schema drifts, and data mismatches. Leveraging Python and Apache Arrow for fast columnar data transfer, it provides a comprehensive reconciliation report, making it essential for data migration validation and ETL verification.

This guide details the process of creating advanced, static visualizations in Power BI using Python libraries like matplotlib and seaborn. It covers the full workflow, from script writing and data injection to best practices and limitations, enabling users to render complex, custom charts not supported by native Power BI visuals.

Execute arbitrary PySpark or pure Python code directly on Fabric Spark compute using the Livy API. This method creates ephemeral sessions without generating persistent notebook artifacts. It provides full read/write access to lakehouse Delta tables, making it ideal for agent-driven ETL pipelines, quick data transformations, or analyses where session cleanup is critical. Users must manage the session lifecycle (create, run, and delete).

This guide details how to deploy OpenCTI, a powerful, open-source threat intelligence platform, and utilize the pycti Python client. It teaches analysts how to model complex cyber threat intelligence, including threat actors, campaigns, and indicators, into a structured STIX 2.1 knowledge graph. Use this for centralized threat-intel correlation, building adversary graphs, and generating STIX bundles for detection engineering.

This guide provides a comprehensive workflow for searching and retrieving biomedical literature from PubMed and NCBI. It covers advanced query construction using MeSH terms and specific field tags, advanced filtering (date, publication type), and a repeatable programmatic workflow using NCBI E-utilities (esearch, efetch). Essential for researchers conducting systematic reviews and literature monitoring.

This package ensures full reproducibility for international macroeconomics research. It is designed for projects utilizing complex, multi-source, and often restricted data (such as IMF or central bank files). It mandates capturing the entire data lineage, pinning the execution environment (R, Python, Stata), and documenting access instructions, allowing any authorized replicator to rebuild the analysis from scratch.

Provides comprehensive guidelines for authors submitting to the Journal of Econometrics (JoE). It details the required best practices for data citation (using the Elsevier `[dataset]` format), ensuring methodological reproducibility (e.g., Monte Carlo simulations), and preparing estimators as runnable code packages (R, Python, etc.). This guide is essential for meeting rigorous academic publication standards and passing peer review.

This guide outlines comprehensive best practices for ensuring the reproducibility of Machine Learning and Pattern Recognition research. It covers fixing random seeds, locking hardware/software dependencies (Python, CUDA, etc.), managing data splits, tracking pre-trained model versions, and structuring the required artifact package for external review. It is essential for building trust in published scientific results.

Track physical units and propagate measurement uncertainty in scientific Python calculations using pint and uncertainties, from unit conversion and GUM budgets to Monte Carlo and dimensional sanity checks.

Astropy is the essential Python package for astronomical research and data analysis. It provides a comprehensive suite of tools for handling celestial coordinate transformations (e.g., ICRS, Galactic), managing physical units and quantities, processing FITS files, performing complex cosmological calculations, and ensuring precise time handling. It is indispensable for any project involving scientific data in the field of astronomy and astrophysics.