How to choose dataset tools
Choose the group by the job your tabular dataset needs. Analyze Tools checks what is there, Clean Tools handles inconsistent values, Transform Tools changes the table's shape, Merge Tools combines datasets, and Generate Tools creates one.
Dataset tools for inspecting and cleaning tables
Use Analyze Tools when you need to inspect or measure a dataset. The group lists Correlation Matrix Generator, Dataset Profiler, Fuzzy Duplicate Finder, Outlier Detector, and Time-Series Anomaly Detector. Pick the child tool whose name matches the check you need.
Choose Clean Tools when a dataset needs cleanup. The listed tools cover email lists, phone numbers, blank cells, null values, numbers and currencies, duplicate rows, addresses, dates, and clusters of similar values. Data Cleaner is also listed in this group.
Tools to reshape or merge datasets
Transform Tools is the group for changing a table's layout. Its listed tools are Pivot Table Generator, Rename Columns, Transpose Table, and Unpivot Table. Choose the one that names the layout change you need.
Use Merge Tools when datasets need to be combined through a join. This group contains Dataset Merger & Joiner.
Generate a dataset
Generate Tools is for creating a dataset. The group contains Random Data Generator, which is the listed option when you need random data.
Typical dataset jobs
To inspect or measure a dataset, open Analyze Tools. If the task names a correlation matrix, profile, fuzzy duplicate, outlier, or time-series anomaly, use the matching child tool.
To clean a dataset, open Clean Tools. Match the issue to a child tool for email lists, phone numbers, blank cells, null values, numbers and currencies, duplicate rows, addresses, dates, or similar values.
To change the table's layout, open Transform Tools and select Pivot Table Generator, Rename Columns, Transpose Table, or Unpivot Table. To combine datasets through a join, open Merge Tools.
To create random data, open Generate Tools and choose Random Data Generator.
When to use Data Tools instead
Start with Data Tools when you are choosing by data format or need to decide between cleaning, validating, comparing, converting, and merging data. Use Dataset Tools when the input is tabular and the next action is analysis, cleanup, generation, reshaping, or a dataset join.
Frequently asked questions
How do I analyze a dataset before cleaning it?
Start with Analyze Tools to inspect or measure the dataset. Choose Dataset Profiler, Correlation Matrix Generator, Fuzzy Duplicate Finder, Outlier Detector, or Time-Series Anomaly Detector by the check you need.
What dataset tool should I use to clean a table?
Choose Clean Tools when the dataset needs cleanup. Pick a focused tool for an email list, phone number list, blank cells, null values, numbers or currencies, duplicate rows, addresses, dates, or similar values.
Which tool reshapes or merges tabular data?
Use Transform Tools to pivot, rename, transpose, or unpivot a table. Use Merge Tools when datasets need to be combined through a join.
Do dataset tools upload my data?
The listed child tool groups run locally in your browser with no upload. That applies to Analyze Tools, Clean Tools, Generate Tools, Merge Tools, and Transform Tools.