Lightweight Data Preparation

User problem

Users currently lack the ability to perform basic data preparation tasks directly within Plotly Studio, leading to the need for external tools to clean, filter, group, and combine datasets before they can be used to generate applications. This creates an inefficient workflow and a barrier to quickly leveraging Plotly Studio for data visualization and app creation.

What is it?

This feature introduces a suite of lightweight data preparation tools directly integrated into Plotly Studio. It will provide users with an intuitive interface to inspect and refine their datasets before they are used for application generation.

What does it allow users to do?

This feature will allow users to:

• Handle null or missing values: Users can easily identify and address missing data points through various methods, such as removing rows with nulls, filling nulls with a specific value (e.g., mean, median, mode, or a constant), or interpolating missing values.

• Pre-filter their data: Users can apply filters to their datasets based on specific criteria, allowing them to focus on relevant subsets of their data for analysis and visualization.

• Group their data: Users can group data by one or more columns, enabling aggregation and summarization of information for more insightful analysis.

• Join multiple tables together: Users can combine data from different tables based on common keys, facilitating the creation of comprehensive datasets for their applications.