Skill UI

An expert guide for performing complex data analysis, cleaning, and transformation using pandas DataFrames. This skill covers advanced techniques such as vectorized operations, efficient merging, time series resampling, group-by aggregations, and memory optimization, ensuring production-grade code and robust data validation.

Guidance for creating, editing, and analyzing .xlsx workbooks while preserving formulas, formatting, and assumptions, leveraging pandas/openpyxl for data work and LibreOffice recalc to ensure error-free financial models.

Provides a Python client for querying the Data Commons knowledge graph so teams can resolve entities, fetch statistical observations, and explore public demographic, economic, and health datasets with optional Pandas support.

GeoPandas extends pandas for geospatial vector data, enabling reading/writing shapefiles, GeoJSON, GeoPackage and PostGIS, performing CRS management, spatial joins, overlays, buffering, area/distance calculations, and producing static or interactive choropleth maps.

PyDESeq2 brings the DESeq2 differential expression workflow to Python, letting users load bulk RNA-seq counts, specify design formulas, fit DESeq2 models, run Wald tests with FDR correction, optionally apply apeGLM shrinkage, and export gene-level statistics within pandas/AnnData pipelines.

Pandas is a Python data analysis library that simplifies loading, cleaning, transforming, and analyzing structured datasets, making it ideal for data wrangling in analytics or engineering workflows.

Analyzes endpoint and cloud logs with pandas baselines and DLP policy violation context to expose insider exfiltration signs such as anomalous uploads, off-hours access, and device spikes during threat investigations.

GeoPandas extends pandas for geospatial vector data, enabling reading/writing shapefiles, GeoJSON, GeoPackage and PostGIS, performing CRS management, spatial joins, overlays, buffering, area/distance calculations, and producing static or interactive choropleth maps.

PyDESeq2 brings the DESeq2 differential expression workflow to Python, letting users load bulk RNA-seq counts, specify design formulas, fit DESeq2 models, run Wald tests with FDR correction, optionally apply apeGLM shrinkage, and export gene-level statistics within pandas/AnnData pipelines.

This skill guides users on automating fundraising workflow analysis using local data methods. Since Finta lacks a public API, it teaches how to export pipeline data (CSV) and use Python (Pandas) scripts to calculate key funnel metrics, conversion rates, and generate detailed weekly reports for investor tracking and reporting.

A comprehensive guide detailing the process of migrating data warehouses to Snowflake from major sources like Amazon Redshift, Google BigQuery, or on-premise databases. This resource covers critical steps including schema conversion (handling dialect differences like STRUCT/ARRAY to VARIANT), robust data transfer methods (S3/Cloud Storage, Python/Pandas), data validation techniques (checksums, row counts), and essential SQL syntax translation patterns.

A comprehensive skill for creating, editing, and analyzing complex spreadsheets (.xlsx, .csv, etc.). This skill excels in financial modeling, ensuring all calculations are managed via dynamic Excel formulas rather than hardcoded values. It supports data analysis using pandas, rigorous formatting standards, and complex formula integrity checks, making it ideal for financial reporting and data visualization.