Data Transformation

Transform your data using PXL expressions directly in the spreadsheet. Create new columns, clean data, and perform advanced calculations with ease.

The powerful expression bar lets you transform data using PXL:

Basic Transformations

word_count(description)
extract("sentiment" from reviews)
classify(feedback into ("positive", "negative", "neutral"))

Chained Operations

extract("issue_type" from support_tickets) ->
filter(issue_type = "billing") ->
score(urgency from "low" to "high")

• Real-time validation: See errors as you type
• Auto-completion: Smart suggestions for functions and columns
• Result preview: See transformation results before applying
• Undo/Redo: Full change history for safety

• Clean and standardize text data
• Extract information from unstructured content
• Sentiment analysis on text columns
• Category classification based on content

• Mathematical operations between columns
• Statistical functions like averages and percentiles
• Date arithmetic for time-based calculations
• Custom scoring and ranking systems

• Remove duplicates based on key columns
• Standardize formats across data types
• Fill missing values with calculated defaults
• Validate and correct data inconsistencies