Home Paxata Fundamentals

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

Visit the official Paxata Documentation portal for all of your doc needs.

Paxata Fundamentals

All the fundamental things you need to know about using Paxata once you know the basics. Brand new to Paxata? Check out the "Getting Started" section first.
 

Discussion List

  • Joining two datasets using multiple join conditions
    Joining two datasets on multiple conditions in Paxata – [email protected] 1.  Create the project a…
    157 views 0 comments Started by Akshay
  • Change into Column Operations
    The Change into Operations 1)    Change into Capital Case: Changes the words in the column to …
    60 views 0 comments Started by Akshay
  • Selecting Multiple Columns in a Multi-Column Operation
    Selecting Columns in a Multi-Column Operation In order to perform the column operations on mult…
    11 views 0 comments Started by Akshay
  • Complex, Compound Filters
    I need to filter my dataset to rows that have compound filter requirements. For example, I want to…
    12 views 0 comments Started by Akshay
  • Adding Leading Zeros to your data
    To add leading zeros, follow this tip. Assume you have a column which contains numbers.  These num…
    92 views 0 comments Started by Akshay
  • Different Color indicators on Paxata
    When making selections in the Paxata application, such as when you are selecting columns for a join…
    16 views 0 comments Started by Akshay
  • Trimming leading and trailing whitespace
    (Image) This operation, when applied to a column, examines all rows for spaces at both the beginn…
    45 views 0 comments Started by Akshay
  • Find + Replace
    (Image) The Find + Replace function allows you to find specific values in a column and replace t…
    106 views 0 comments Started by Akshay
  • Collapse Consecutive Whitespace
    This operation examines all text strings in a column for all instances of two or more spaces in suc…
    5 views 0 comments Started by Akshay
  • The Lookup function
    The LOOKUP function allows the user to combine a selected dataset as a lookup table to the previous…
    223 views 0 comments Started by Akshay
  • Columns
    Paxata allows the user to specify which columns within a dataset are visible at specific points in …
    86 views 0 comments Started by Akshay
  • Publish
    The Publish function allows the you to publish your updated dataset into the Data Library for use i…
    6 views 0 comments Started by Akshay
  • Tags
     (Image) The top portion of the Data Library contains a number of filters, which can be used to v…
    23 views 0 comments Started by Akshay
  • Steps Editor
    The Steps Editor allows you to view, edit, add, rearrange, and delete steps within a project. The S…
    37 views 0 comments Started by Akshay
  • Remove function
    The REMOVE function allows you to remove rows from your data. In order to use the REMOVE function, …
    45 views 0 comments Started by Akshay
  • Aggregate: Variance (Var)
    Estimates the how much dispersion exists (how much the values are spread out) within a sample set o…
    24 views 0 comments Started by Akshay
  • Aggregate: Sum
    This aggregate function executes an addition operation on the numbers in the reference column (the …
    35 views 0 comments Started by Akshay
  • Aggregate: Standard Deviation (stdev)
    Estimates the standard deviation (how much variation from the average) exists within a sample set o…
    39 views 0 comments Started by Akshay
  • Importing a fixed-width file
    When you import a fixed-width file, click the dropdown box next to the file name on the right hand …
    6 views 0 comments Started by Akshay
  • Aggregate: Max
    This aggregate function returns the largest of the numbers in the reference column (the column to w…
    22 views 0 comments Started by Akshay
  • Aggregate: First
    The First function searches the data for duplicate rows (based on the columns chosen by the user) a…
    1 view 0 comments Started by Akshay
  • Aggregate: Count
    This aggregate function returns the number of duplicate rows in a dataset. Excluding the column to …
    66 views 0 comments Started by Akshay
  • Aggregate: Average
    This aggregate function finds an average of the numbers in the reference column (the column to whic…
    6 views 0 comments Started by Akshay
  • Aggregate: Array
    Of the available aggregate functions available, array is unique in that it operates on both text an…
    33 views 0 comments Started by Akshay
  • Aggregate Functions
    The following is a list of the Aggregate Functions available to the user during Group By and Pivot …
    67 views 0 comments Started by Akshay
  • Shape (Group By)
    This function allows for the user to utilize a number of different aggregate functions (listed belo…
    134 views 0 comments Started by Akshay
  • Shape (Transpose)
    Transpose is the simplest of the Shape functions, essentially allowing you to switch your rows and …
    112 views 0 comments Started by Akshay
  • Shape (Pivot)
    Pivot is similar to transpose in that it allows you to rearrange your column headers into row heade…
    209 views 0 comments Started by Akshay
  • Shape (Depivot)
    The Depivot function is a very powerful function that allows you to take your data and stack column…
    100 views 0 comments Started by Akshay
  • Import Options: Microsoft Excel
    Any of the most common Excel® file types can be uploaded in their native formats directly into the …
    152 views 0 comments Started by Akshay