Data Wrangling
Most of the Data Science working hours are spent on Data Wrangling. But, there is no UI tool that is designed for those who analyze data.
Exploratory’s ‘Step’ based UI experience makes it easy to clean up and transform data in an iterative and a fully reproducible way so that you can spend more time on discovering new insights.
Exploratory’s ‘Step’ based UI experience makes it easy to clean up and transform data in an iterative and a fully reproducible way so that you can spend more time on discovering new insights.
Reproducible Data Wrangling Steps
All the data wrangling operations are recorded in the Step pane (right-hand side) so that you can quickly move to any step to see how the data changes. You can automatically reproduce all the steps at any time so no more of the repetitive data wrangling woks!
Branch
You can create multiple data frames from the same data to experiment with various scenarios.
Independently Managed Step
All the steps are managed together in a reproducible way. But they can function independently. This means that you can create charts to different steps, cache or disable some of the steps, move the steps around. Just works as you would expect!
Create Calculation
You can create custom calculations by accessing hundreds of R functions natively integrated.
Summarize
You can summarize (aggregate) your data quickly with a simple UI.
Summarize - Custom Calculation
By using the custom function support, you can add various calculations in a very flexible way.
Pivot
You can transform your data into a Pivot format so that you can apply other calculations or apply analytics algorithms on top of the Pivot data.
Recode
You can assign new values for existing data. You can also group multiple values into a single value.
Text Data Wrangling
Cleaning up text data is cumbersome and can be scary with all the regular expressions. With Exploratory’s Text Data Wrangling UI makes it more intuitive and fun to work with text data with various useful methods.
Text Data Wrangling - Convert
You can convert between uppercase and lowercase, country name and IP address, state name and code, or anonymize your data with Text Convert UI.
Join Data
Join with another data frame to bring additional columns or filter the data based on the data from another data frame.
Merge Data
Merge multiple data frames to add extra rows such as various months, locations, products, etc.
Tokenize Text
You can tokenize text sentences so that you can visualize which words are more frequently used or analyze the similarities of words, for example.
Wide to Long
Transform data from the wide format to the long format.
Long to Wide
Transform data from the long format to the wide format.
