{"id":31226,"name":"Data Preprocessor","link":"/plugin/31226-data-preprocessor","approve":false,"xmlId":"com.datapreprocessor.plugin","description":"<p>Stop writing repetitive pandas preprocessing scripts.</p>\n\n        <p><b>Data Preprocessor</b> is an in-IDE toolkit for cleaning, transforming, and preparing datasets\n        directly inside your JetBrains IDE.</p>\n\n        <p>Load a <b>CSV, Excel (.xlsx), or JSON</b> file, profile your data instantly, handle missing values,\n        remove duplicates and outliers, normalize columns, and generate ready-to-run <b>Python (pandas)</b>\n        code from your workflow. Pro unlocks <b>R</b> and <b>SQL</b> generation, reusable pipelines,\n        column visualisations, custom regex rules, and batch processing — all without leaving the IDE.</p>\n\n        <b>Key features:</b>\n        <ul>\n          <li><b>Column Profiling &amp; Statistics</b> — type, null count, unique count, mean, median, std dev, min, max, mode</li>\n          <li><b>Missing Value Handling</b> — drop rows or fill with mean, median, mode, or a custom value</li>\n          <li><b>Duplicate Removal</b> — detect and remove duplicate rows in one click</li>\n          <li><b>Outlier Detection (IQR)</b> — identify and remove outliers using the IQR fence method</li>\n          <li><b>Data Normalization</b> — Min-Max scaling [0, 1], Z-Score standardisation (mean=0, std=1), or Robust Scaler (median/IQR)</li>\n          <li><b>Column Type Casting</b> — cast any column to int, float, boolean, or string</li>\n          <li><b>Label Encoding</b> — encode categorical columns to integer indices</li>\n          <li><b>One-Hot Encoding</b> — expand categorical columns into binary dummy columns</li>\n          <li><b>Train / Test Split</b> — split the dataset with a configurable ratio; reflected in generated Python and Pro R code</li>\n          <li><b>Sort Column</b> — sort the dataset ascending or descending by any column (numeric or text)</li>\n          <li><b>Filter Rows</b> — keep only rows matching a condition (==, !=, &gt;, &lt;, &gt;=, &lt;=, contains)</li>\n          <li><b>Regex Replace [Pro]</b> — clean text columns with custom regex find/replace rules, including capture-group replacements</li>\n          <li><b>Reusable Pipelines [Pro]</b> — import/export cleaning pipelines as `.dpp` JSON files</li>\n          <li><b>Multi-File Batch Mode [Pro]</b> — apply the current pipeline to many CSV, Excel, or JSON files and export cleaned CSV copies</li>\n          <li><b>Python Code Generation</b> — one click produces a complete, ready-to-run pandas script</li>\n          <li><b>R Code Generation [Pro]</b> — one click produces an equivalent base-R script; readxl / jsonlite / fastDummies imported only when needed</li>\n          <li><b>SQL Code Generation [Pro]</b> — one click produces a PostgreSQL-style CTE template for database-side preprocessing</li>\n          <li><b>Undo / Redo</b> — step back and forward through pipeline edits without losing work</li>\n          <li><b>Export cleaned CSV</b> — choose where to save the transformed dataset via a file dialog</li>\n          <li><b>Copy cleaned data as TSV</b> — paste applied results directly into Excel or Google Sheets</li>\n          <li><b>Column Visualisations [Pro]</b> — histogram and box plot per numeric column rendered inside the tool window; charts update automatically after Apply</li>\n          <li><b>Settings</b> — configure preview row limit, default normalization method, and default train/test ratio</li>\n        </ul>\n\n        <p>Built for <b>data scientists, analysts, and developers</b> who want faster preprocessing\n        without leaving their IDE.</p>\n\n        <p>Compatible with <b>IntelliJ IDEA</b>, <b>PyCharm</b>, <b>DataGrip</b>, and other JetBrains IDEs.</p>\n\n        <br>\n        <b>Privacy:</b> This plugin does not collect, store, or transmit any user data.\n        All processing is performed locally within the IDE.","customIdeList":false,"preview":"Stop writing repetitive pandas preprocessing scripts. Data Preprocessor is an in-IDE toolkit for cleaning, transforming, and preparing datasets directly inside your...","docText":"1. Install the plugin from JetBrains Marketplace\n\n2. Open your project in IntelliJ IDEA, PyCharm, or any JetBrains IDE\n\n3. Load a CSV file:\n   - Right-click the file → \"Open in Data Preprocessor\"\n   OR\n   - Go to Tools → Open Data Preprocessor\n\n4. Explore your dataset:\n   - View column statistics and data types\n   - Identify missing values and outliers\n\n5. Apply transformations:\n   - Clean missing values\n   - Remove duplicates\n   - Normalize data\n   - Cast column types\n\n6. Generate pandas code:\n   - Click \"Generate Preprocessing Code\"\n   - Insert it directly into your editor\n\nYou're now ready to integrate the generated code into your data pipeline or notebook.","email":"admin@keencodelabs.com","cdate":1781275847000,"family":"intellij","downloads":543,"purchaseInfo":{"productCode":"PDATAPREPROCESS","buyUrl":null,"purchaseTerms":null,"optional":true,"trialPeriod":30},"vendor":{"type":"organization","id":18396,"name":"keencodelabs","url":"https://keencodelabs.com/","link":"/vendor/keencodelabs","publicName":"Keencodelabs","email":"admin@keencodelabs.com","showEmail":true,"countryCode":"NG","country":"Nigeria","isVerified":true,"isTrader":true,"details":{"city":"Lagos","address":"23 Victor Iyoha street","state":null,"zip":"105101","phone":"09063234358"},"marketplaceVendorId":18396},"urls":{"url":"","forumUrl":"https://github.com/CodaBlurd/data-preprocessor-plugin/discussions","licenseUrl":"https://opensource.org/licenses/MIT","privacyPolicyUrl":"","bugtrackerUrl":"https://github.com/CodaBlurd/data-preprocessor-plugin/issues","docUrl":"https://github.com/CodaBlurd/data-preprocessor-plugin","sourceCodeUrl":"https://github.com/CodaBlurd/data-preprocessor-plugin.git","customContacts":[{"title":"Linkedin","link":"https://www.linkedin.com/feed/"}]},"tags":[{"id":241,"name":"Data Science","privileged":false,"searchable":true,"link":"/tag/241-data-science"}],"hasUnapprovedUpdate":false,"pricingModel":"FREEMIUM","screens":[{"url":"/files/31226/screenshot_d461f38c-476d-4e94-98f8-ec2ddac0172b"},{"url":"/files/31226/screenshot_90db077c-f1d8-4623-a806-1d4e7b3c8be4"},{"url":"/files/31226/screenshot_f817351f-a9bd-4a52-ad83-e2675caa2c31"},{"url":"/files/31226/screenshot_35dd5bd9-1963-4713-88ca-006c11fedca5"},{"url":"/files/31226/screenshot_517c56b5-0add-4b4d-b7df-5d607a7fa584"}],"icon":"/files/31226/1076563/icon/default.svg","semverOnly":true,"containsAds":false,"isHidden":false,"isMonetizationAvailable":false,"isBlocked":false,"isModificationAllowed":false,"preserveUIEdits":false}