Optima.io
Reference beta
Data Manipulation
Python
R
SQL
Inspecting
Structure
Data Frame Summary
Dimensions
Column Names
Column Data Types
Memory Use
Segments
Head or Tail
Random
Range
Specific Rows
Filter
Extremes
Univariate Summary
Data Frame Summary
Numeric Columns
Non Numeric Columns
Multivariate Summary
Data Frame Summary
Numeric by Factor
Factor by Factor
Numeric by 2 Factors
Multiple Facets
Quality
Missing Values
Duplicates
Selecting
Basic Selection
By Name
By Position
Implicit Selection
By Name Pattern
By Data Type
By Data Criteria
By Multiple Conditions
Dynamic Selection
Column Specification
Function Specification
Exclude Columns
Filtering
Basic Filtering
Common Scenarios
Multiple Filters
Custom Filtering
Grouped Filtering
By Value
By Position
By Rank
By Group
Implicit Filtering
Column Selection
Function Specification
Relationship Specification
Dynamic Filtering
Column Specification
Function Specification
Condition Specification
Filtering Joins
Sorting
Basic Sorting
Single Column
Multiple Columns
Custom Sorting
Grouped Sorting
Implicit Sorting
Dynamic Sorting
Transforming
Basic Transformation
Common Scenarios
Multiple Transformations
Conditional Transformation
Grouped Transformation
Non-Vectorized Transformation
Implicit Transformation
Column Selection
Function Specification
Output Naming
Grouped Transformation
Dynamic Transformation
Aggregating
Basic Aggregation
Individual Aggregation
Summary Table
Common Operations
Conditional Aggregation
Sequential Aggregation
Implicit Aggregation
Column Selection
Function Specification
Output Naming
Multi-Value Aggregation
Pivot Aggregation
Dynamic Aggregation
Grouping
Reshaping
Joining
Join Types
Join Columns
Join Special Cases
Appending
Pivoting
Transposing
Nesting
Renaming
Map Names
Set Names
Add Suffix or Prefix
Standardize Names
Implicit Renaming
Function Specification
Column Selection
Dynamic Renaming
Relocating
Basic Relocating
Relative Relocating
Implicit Relocating
General
Type Casting
Missing Values
Encode Missing
Identify Missing
Drop Missing
Fill Missing
Uniqueness
Unique Values
Duplicates
Conditionals
Length
Range
Ranking
Shifting
Sampling
Numeric
String
Properties
Formatting
Case
Wrapping
Alignment
Number
Combining
Matching
Detecting
Locating
Counting
Filtering
Extracting
By Regular Expression
By Location
Modifying
Replacing
Substituting
Removing
Trimming
Splitting
Split
Select
Process
Sorting
Logical
Categorical
Sorting
Date Time
Lists
Content not ready yet. We are on it!