[]

Analysis

The best skills for data-related work, like analysis, visualization, SQL, pipelines and machine learning.

  • categorical-comparison-analysis

    Compare two categorical datasets by counts, ratios and differences with charts

    ★5.9K
  • category-filtering-and-difficulty-analysis

    Score text difficulty and quality by category using length, term density and regex metrics

    ★5.9K
  • dynamic-large-file-parquet-analysis

    Convert large Excel files to Parquet for fast filtering, aggregation and export

    ★5.9K
  • dynamic-percentage-and-large-file-analysis

    Calculate percentages and means from large Excel files into a report with charts

    ★5.9K
  • excel-basic-statistics-and-routing

    Compute conditional means and deduplicated sums across Excel sheets and row ranges

    ★5.9K
  • excel-conditional-comparison-and-large-file-processing

    Compare coefficients across Excel sheets and color-flag outliers in large files

    ★5.9K
  • excel-conditional-filtering-optimization

    Filter Excel rows by multi-column numeric conditions and export results at scale

    ★5.9K
  • excel-data-analysis-and-report-generation

    Turn Excel data into a analysis report with charts and a download link

    ★5.9K
  • excel-large-file-processing-and-cleaning

    Extract target columns and Chinese text from multi-sheet Excel into a standard workbook

    ★5.9K
  • excel-multi-sheet-dynamic-analysis

    Run cross-sheet statistics and summary reports on Excel files with volume-based processing

    ★5.9K
  • excel-multi-sheet-threshold-analysis

    Count rows across Excel sheets, dedupe a dimension and build summary and detail reports

    ★5.9K
  • excel-outlier-detection-and-highlighting

    Find out-of-range values and error cells in Excel and highlight them

    ★5.9K
  • excel-sheet-filter-export

    Filter multi-sheet Excel data by condition, rename fields and export a new workbook

    ★5.9K
  • excel-smart-analysis-and-cleaning

    Clean multi-sheet Excel files, cross-check sheets and build visual analysis

    ★5.9K
  • excel-statistical-viz-large-file

    Run multi-dimensional statistics and charts on large Excel datasets

    ★5.9K
  • excel-threshold-analysis-and-styling

    Filter Excel numeric columns by threshold and style matching cells with openpyxl

    ★5.9K
  • formatted-export-with-parquet

    Filter multi-sheet Excel records by condition and export matching rows highlighted red

    ★5.9K
  • group-by-analysis

    Group and aggregate multi-sheet Excel data into styled summary tables and charts

    ★5.9K
  • grouped-statistics

    Merge multi-sheet Excel data, forward fill gaps and count rows per group

    ★5.9K
  • invalid-data-cleaning

    Clean large Excel text columns with regex rules, such as keeping only Chinese characters

    ★5.9K
  • large-excel-analysis-and-formatting

    Format large multi-sheet Excel analyses with conditional highlights and openpyxl styling

    ★5.9K
  • large-file-conditional-formatting

    Build Excel reports with time-series averages and conditional formatting for large files

    ★5.9K
  • large-file-kpi-analysis

    Extract KPIs from large spreadsheets, validate units and rank results in a table

    ★5.9K
  • large-file-parquet-analysis-and-highlight

    Analyze Excel files over 10k rows via Parquet and highlight key rows in the output

    ★5.9K
  • multi-file-excel-parquet-analysis

    Analyze multi-sheet Excel files with Parquet conversion, category stats and charts

    ★5.9K
  • multi-sheet-reading-and-analysis

    Read multi-sheet Excel, clean with regex, fit trends and export formatted charts

    ★5.9K
  • numeric-extraction-and-distribution-analysis

    Extract numbers from unit-labeled text and chart distributions with histograms and CDFs

    ★5.9K
  • numeric-format-normalization

    Normalize numeric formats in Excel data and check totals before exporting results

    ★5.9K
  • outlier-detection-and-quality-assessment

    Detect outliers with the IQR method and assess data quality with skewness and kurtosis

    ★5.9K
  • range-reading-and-large-file-analysis

    Extract cell ranges from multi-sheet Excel files and analyze large workbooks with charts

    ★5.9K
  • single-sheet-reading-and-analysis

    Read a single Excel sheet with merged cells, clean it and chart key metrics and trends

    ★5.9K
  • sn-da-excel-workflow

    Orchestrate Excel data analysis from loading and cleaning to aggregation and export

    ★5.9K
  • sn-da-large-file-analysis

    Analyze Excel datasets over 10k rows with streaming reads, Parquet and chunked processing

    ★5.9K
  • statistical-distribution-and-outlier-analysis

    Analyze numeric distributions and outliers with boxplots and histograms

    ★5.9K
  • text-normalization-and-large-file-processing

    Normalize text columns in large Excel files and export a cleaned workbook

    ★5.9K
  • time-series-and-categorical-analysis

    Analyze time series and categories for trends, grades and forecasts with visual reports

    ★5.9K
  • top-value-coloring

    Merge multi-table Excel data and highlight key metrics with openpyxl styling

    ★5.9K
  • trend-analysis

    Forecast graded performance trends with set growth rates and comparison charts

    ★5.9K
  • results-analysis

    Analyze experiment results with significance tests, ablations and scientific figures

    ★5.9K
  • exploratory-data-analysis

    Profile scientific data files across 200 formats and write structured EDA reports

    ★5.2K
  • networkx

    Analyze and visualize networks with centrality, communities and shortest paths

    ★5.2K
  • statistical-analysis

    Choose statistical tests, check assumptions and write APA-style results

    ★5.2K
  • statsmodels

    Fit OLS, GLM and time series models with detailed diagnostics in statsmodels

    ★5.2K
  • csv

    View, filter, convert and merge CSV tables from the command line

    ★4.7K
  • tsv

    View, filter and convert tab-separated files from the command line

    ★4.7K
  • dataset-quality-audit

    Score a CSV or Excel dataset for missing values, duplicates and outliers

    ★4.7K
  • log-error-digest

    Cluster log errors by pattern and find the peak periods behind them

    ★4.7K
  • regression-modeler

    Fit OLS or logistic regression on CSV data with p-values and multicollinearity checks

    ★4.7K
  • metric-design

    Design and calibrate a low-variance metric with noise bands before optimizing anything

    ★4.6K
  • bayesian-inference

    Estimate parameter posteriors with emcee and PyMC, including convergence checks

    ★4.3K