Here we provide a list of all “How To”-articles on this website.
Data Frames
- Check if Data Frames are Identical
- Change the Case of Column Names
- Convert a Column into Lowercase
- Convert a Column into Uppercase
- Rename Columns
- Remove Columns by Name
- Remove Columns with a Prefix/Suffix
- Remove Duplicated Columns
- Remove Duplicated Column Names
- Remove Empty Columns
- Repeat Columns
- Repeat Rows
- Replace Blanks in Column Names
- Select Last N Columns
Error Measures
- Calculate the Mean Absolute Error (MAE)
- Calculate the Mean Absolute Percentage Error (MAPE)
- Calculate the Normalized Mean Absolute Error (NMAE)
- Calculate the Relative Absolute Error (RAE)
- Calculate the Relative Squared Error (RSE)
- Calculate the Root Relative Squared Error (RRSE)
- Calculate the Weighted Absolute Percentage Error (WAPE)
- Calculate the Weighted Mean Absolute Percentage Error (WMAPE)
Matrices
Missing Values
- Count the number of NA’s per Column
- Count the Number of NA’s per Row
- Deal with NaN’s
- Find Columns with Missing Values
- Remove Rows with Missing Values
- Replace Blanks with NA’s
- Replace Missing Values with the Last, Non-Missing Value (per Group)
- Replace Missing Values with the Next, Non-Missing Value (per Group)
- Replace Missing Values with the Maximum
- Replace Missing Values with the Mean
- Replace Missing Values with the Median (by Group)
- Replace Missing Values with the Minimum (per Group)
- Replace Missing Values with the Mode
- Replace Missing Values with Zeros
Strings
- Check if a String Contains Digits
- Count the Number of Words in a String
- Convert a String to Lowercase
- Convert a String to Uppercase
- Extract Words from a String
- Read the Last N Characters from a String
- Remove the Last N Characters from a String
- Reverse a String