JetBrains Data Wrangler: No-code tool for data cleaning and data preparation
To boost efficiency and enhance productivity, automating these stages is crucial and should consist of two steps: optimizing the API and UI for data manipulation and implementing a guided process using LLM agents.
JetBrains are starting with table data and will expand the tool to support more data formats. JetBrains Data Wrangler helps prepare your data for further processing using a set of user-friendly actions:
Filter.
Clean and remove.
Find and replace.
Additionally, JetBrains Data Wrangler allows you to solve statistical issues using effective functions straight out of the box:
Min-max scaling.
Z-score normalization.
Outlier detection with IQR (interquartile range).
Skewness reduction.
Outlier detection with MAD (median absolute deviation).
Outlier detection with Euclidean distance.
Data manipulation is accompanied by code generation, which adds to the basic data export and provides the ability to use the result of the transformation as a new cell.
Support for R 4.4
JetBrains have introduced support for R version 4.4. You can now start taking advantage of the language’s latest features in your projects in DataSpell.