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.

This tool parses API Gateway access logs from various providers (AWS, Kong, Nginx). It performs statistical analysis using pandas to detect critical security threats such as Broken Object Level Authorization (BOLA/IDOR), credential stuffing, rate limit bypass attempts, and injection vulnerabilities. Ideal for SOC analysts or security engineers investigating API abuse and building advanced threat detection rules.

This script performs statistical analysis on Zeek connection logs (conn.log) to detect Command and Control (C2) beaconing patterns. It leverages the ZAT library to load data into Pandas DataFrames, calculates inter-arrival time statistics, and flags connections with low standard deviation relative to the mean. This technique is crucial for network threat hunting and security incident investigation when identifying malicious, periodic callbacks.

Dask is a powerful Python library designed for parallel and distributed computing. It allows users to scale existing pandas and NumPy workflows beyond the limits of available RAM, processing massive datasets up to the terabyte scale. It provides specialized APIs (DataFrames, Arrays, Bags) for handling structured, scientific, and unstructured data efficiently across single machines or multi-node clusters.

A powerful Python library that extends pandas to enable complex spatial operations on vector geometric data. It supports reading and writing diverse formats, including Shapefile, GeoJSON, and GeoPackage. Users can perform advanced GIS tasks such as spatial joins, buffering, overlay analysis, calculating areas, managing Coordinate Reference Systems (CRS), and generating interactive choropleth maps, making it essential for geographic data science projects.

Polars is a lightning-fast DataFrame library built on Apache Arrow for Python. It provides an expression-based API, lazy query optimization, and parallel computation capabilities for efficient data manipulation, analytics, and ETL pipelines. It is designed to handle large, memory-intensive datasets, making it an ideal alternative for migrating from pandas or optimizing complex data workflows.

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.