Data Cleaning Actor

Pricing

$15.00 / 1,000 results

Data Cleaning Actor

This actor automatically cleans, analyzes, and summarizes spreadsheet data. It handles different file types (CSV, XLSX), fixes missing values, detects outliers, generates charts, computes correlations, and returns a cleaned dataset along with downloadable files and visual insights.

Pricing

$15.00 / 1,000 results

Rating

0.0

(0)

Developer

Mitchell Wanjiru

Maintained by Community

Actor stats

Bookmarked

Total users

Monthly active users

8 days ago

Last modified

data_cleaning_actor

A Python-based Apify Actor for automatic data cleaning, summarization, and visualization of CSV or Excel files.

Features

Upload CSV or Excel files
Clean data (remove missing, standardize types)
Compute summary statistics (mean, median, missing values)
Generate correlation matrix and plots (histogram, heatmap)
Outputs cleaned CSV, JSON summary, and optional plot image

Usage

Inputs

dataFile: Path to CSV or Excel file to process
columnsToAnalyze: (optional) List of columns to include in analysis
summaryType: "stats", "correlations", or "charts"

Example key_value_stores/default/INPUT.json:

{
  "dataFile": "sample.csv",
  "columnsToAnalyze": [],
  "summaryType": "stats"
}

Outputs

key_value_stores/default/cleaned.csv: Cleaned data file
key_value_stores/default/summary.json: JSON summary (mean, median, missing values, correlations)
key_value_stores/default/plot.png: Plot image (if requested)

Running Locally

Install Python dependencies:

pip install -r requirements.txt

Prepare your input file and INPUT.json as above.
Run the Actor:
```
python src/main.py
```
Check outputs in key_value_stores/default/

Publishing to Apify

Ensure all required files are present:
- .actor/actor.json, input_schema.json, output_schema.json, dataset_schema.json
- src/main.py, requirements.txt, Dockerfile, AGENTS.md, README.md
Test with real data and input options.

apify login
apify push

Notes

Only numeric columns are used for correlations and plots.
All NaN values in JSON output are converted to null for compatibility.
For questions or issues, see AGENTS.md for Apify Actor guidance.

CSV File to Dataset

lukaskrivka/csv-file-to-dataset

Upload a local or remote CSV/text file and convert it to Apify Dataset for further use.

Lukáš Křivka

153

Dataset Download

idiatech/apify-Dataset-Download

Download any dataset from the Apify platform automatically and in any format you want. Use this actor along with a Dataset toolbox automation tool.

idIA Tech

universal-data-cleaner

motivational_nickel/universal-data-cleaner

“Cleans CSV/Excel files and datasets by removing duplicates, trimming whitespace, fixing casing, and normalizing emails, phone numbers, URLs, and text fields. Outputs clean CSV, XLSX, JSON, or dataset. Ideal for CRM imports, lead lists, and analytics workflows.”

Leoncio Jr Coronado

Actor 2 Dataset Cleaner and Formatter

motivational_nickel/dataset-cleaner-and-formatter

Automatically cleans and formats datasets by trimming whitespace, fixing capitalization, and removing duplicates. Supports both Apify datasets and uploaded JSON/CSV files.

Leoncio Jr Coronado

Markdown Table Generator

visita/markdown-table-generator

This Actor converts data from multiple sources into a clean, presentation-ready table. You can provide raw text, a direct URL to a file (like `.xlsx` or `.csv`), or Run ID of another Apify Actor, and this tool will automatically format it into Markdown, HTML, or Confluence Wiki markup.

Visita AI & Automation

Barcode Generator

zsoftware/barcode-generator

Generate high-quality barcode images for a list of values in popular formats like Code 128, EAN-13, UPC, and more. This actor takes an array of input values and a selected barcode type, then outputs a downloadable ZIP file containing PNG images of the generated barcodes.

Karim

SEO Image Audit Tool - Analyze & Optimize Website Images

smart-digital/seo-image-audit-tool

Analyzes website images for SEO: detects missing alt attributes, heavy images (>200KB), non-optimized formats (JPEG/PNG), and dimension issues. Generates detailed reports per page and site summary.

My Smart Digital

5.0

Video to Text Transcription

aizen0/video-to-text-transcription

Convert video speech to text in bulk. Supports Only Twitter/Instagram, auto-detects languages, handles large files automatically. Uses OpenAI Whisper for high accuracy.

Pratham Yadav

Apk Scraper

thenetaji/apk-downloader

📱 Find and extract direct download links for APK files from websites. Also discovers other downloadable content like videos, images, and audio files. Perfect for gathering Android apps and media files from various sources.