node_reference.md

Node Reference

Aggregation

Node	Description
Pandas Group By	Computes aggregate values for groups in a DataFrame.

Arithmetic method

Node	Description
Pandas Add	Adds two pandas DataFrames.
Pandas Add Scalar Float	Adds a floating-point number to a Pandas DataFrame.
Pandas Add Scalar Int	Adds an integer to a Pandas DataFrame.
Pandas Add Series	Adds a Pandas Series to a pandas DataFrames.
Pandas Div	Divides a Pandas DataFrame by another DataFrame.
Pandas Div Scalar Float	Divides a Pandas DataFrame by a floating-point number.
Pandas Div Scalar Int	Divides a Pandas DataFrame by an integer.
Pandas Div Series	Divides a Pandas DataFrame by a Pandas Series.
Pandas Mul	Multiplies two pandas DataFrames.
Pandas Mul Scalar Float	Multiplies a Pandas DataFrame by a floating-point number.
Pandas Mul Scalar Int	Multiplies a Pandas DataFrame by a floating-point number.
Pandas Mul Series	Multiplies a Pandas DataFrame by a Pandas Series.
Pandas Pow	Exponentiates two pandas DataFrames.
Pandas Pow Scalar Float	Raises a Pandas DataFrame to the power of a floating-point number.
Pandas Pow Scalar Int	Raises a Pandas DataFrame to the power of an integer.
Pandas Pow Series	Raises a Pandas DataFrame to the power of a Pandas Series.
Pandas Sub	Subtracts a Pandas DataFrame from another DataFrame.
Pandas Sub Scalar Float	Subtracts a floating-point number from a Pandas DataFrame.
Pandas Sub Scalar Int	Subtracts an integer from a Pandas DataFrame.
Pandas Sub Series	Subtracts a Pandas Series from a Pandas DataFrame.

Categorical summary

Node	Description
Pandas Crosstab	Creates a contingency table (crosstab, or cross-tabulation) from two or more columns in a DataFrame.
Pandas Value Counts	Creates a frequency table from one or more columns in a DataFrame.

Cumulative calculations

Node	Description
Pandas Cummax	Computes the cummax (cumulative max) of the DataFrame.
Pandas Cummin	Computes the cummin (cumulative minimum) of the DataFrame.
Pandas Cumprod	Computes the cumprod (cumulative product) of the DataFrame.
Pandas Cumsum	Computes the cumsum (cumulative sum) of the DataFrame.

Data cleansing

Node	Description
Pandas Drop Duplicates	Drops duplicate rows from a Pandas DataFrame.
Pandas Drop NA	Drops missing values from a pandas DataFrame.
Pandas Fill NA Scalar Float	Replaces missing values in a Pandas DataFrame with a floating-point number.
Pandas Fill NA Scalar Int	Replaces missing values in a Pandas DataFrame with an integer.
Pandas Is NA	Checks a pandas DataFrame for missing values.
Pandas Replace	Replaces part or all of a string in each DataFrame cell with a specified string using a wildcard for matching. If you want to remove some characters, then leave the replace_string field blank.
Pandas Replace Advanced	Replaces strings in a DataFrame cell using a mapping specified in a dictionary.

Data subset selection

Node	Description
Pandas At Datetime	Selects a cell from a pandas DataFrame and output as a Python datetime.datetime data.
Pandas At Float	Selects a cell from a pandas DataFrame and output as a Python float.
Pandas At Int	Selects a cell from a pandas DataFrame and output as a Python int.
Pandas At String	Selects a cell from a pandas DataFrame and output as a string.
Pandas Boolean Index	Selects rows from a pandas DataFrame based on the boolean index in the Series.
Pandas Head	Retrieves the first few rows of a pandas DataFrame.
Pandas Iat Datetime	Selects a cell from a pandas DataFrame and output as a Python datetime.datetime data.
Pandas Iat Float	Selects a cell from a pandas DataFrame and output as a Python float.
Pandas Iat Int	Selects a cell from a pandas DataFrame and output as a Python int.
Pandas Iat String	Selects a cell from a pandas DataFrame and output as a string.
Pandas Iloc Row Series	Selects a row from a pandas DataFrame and returning it as a Series.
Pandas Iloc Rows Data Frame	Selects rows from a pandas DataFrame and returning it as a DataFrame.
Pandas Iloc Rows Slice Data Frame	Selects rows from a pandas DataFrame using a slice defined by a start and end integer position. The start position is inclusive, while the end position is exclusive. Returns the selected rows as a DataFrame.
Pandas Loc Cell String	Selects a cell from a pandas DataFrame and output as a string.
Pandas Loc Row MultiIndex DataFrame	Selects a row or rows from a pandas DataFrame with MultiIndex and output as a DataFrame.
Pandas Loc Row Series	Selects a row from a pandas DataFrame and output as a Series.
Pandas Select Column As Series	Selects specific column as Series from a pandas DataFrame.
Pandas Select Columns	Selects specific columns from a pandas DataFrame.
Pandas Select Rows	Selects specific rows from a pandas DataFrame based on a condition. This node internally calls DataFrame.query().
Pandas Xs	Selects a subset of a Pandas DataFrame using specified index labels or positions.

Data type conversion

Node	Description
Pandas As Float	Converts all cells in a pandas DataFrame to float type.
Pandas As Int	Converts all cells in a pandas DataFrame to integer type.
Pandas As String	Converts all cells in a pandas DataFrame to string type.
Pandas To Numpy	Converts a pandas DataFrame to Numpy ndarray.

DataFrame information

Node	Description
Pandas Columns	Retrieves the column labels of a pandas DataFrame.
Pandas Index	Retrieves the row labels (index) of a pandas DataFrame.

Date and time processing

Node	Description
Pandas Strftime	Converts one or more datetime columns in a DataFrame to string columns.
Pandas To Datetime	Converts one or more string columns in a DataFrame to datetime columns.

Display data

Node	Description
CDA Show Float	Displays a floating-point number as text.
CDA Show Int	Displays a Pandas Int as text.
Pandas Index To String	Converts a pandas Index to a string representation.
Pandas Series To String	Converts a pandas Series to a string representation.
Pandas Show Data Frame	Displays a Pandas DataFrame as text.
Pandas Show Index	Displays a Pandas Index as text.
Pandas Show Series	Displays a Pandas Series as text.
Pandas Show Text	Displays a string.
Pandas To String	Converts a pandas DataFrame to a string representation.

IO

Node	Description
CDA Float Create	Creates a Python float using a value entered in the text field.
CDA Int Create	Creates a Python int using a value entered in the text field.
CDA JSON Create	Creates a serialized JSON object using values entered in the text field.
CDA String Create	Creates a Python String using a value entered in a single-line text field.
CDA Text Create	Creates a Python String using a value entered in a multi-line text field.
Pandas Create	Creates a pandas DataFrame using values entered in the text field.
Pandas Create From Dict	Creates a pandas DataFrame from a Python dictionary.
Pandas Create From Dict Index List	Creates a pandas DataFrame from a Python dictionary and a list for index.
Pandas Create From Multiple Dict	Creates a pandas DataFrame from multiple Python dictionaries.
Pandas Create From Numpy	Creates a pandas DataFrame from a NumPy ndarray.
Pandas Create From Tensor	Creates a pandas DataFrame from a PyTorch tensor.
Pandas Create Series From Dict	Creates a Pandas Series from a Python dictionary.
Pandas Create Series From List	Creates a Pandas Series from a Python list.
Pandas Create Series From List Index List	Creates a Pandas Series from a Python list of cell values and a list for index.
Pandas Create With Index	Creates a pandas DataFrame using values entered in the text field. Input data is assumed to have an index.
Pandas Excel File Sheet Names	Returns the string list of sheet names contained in the Excel file.
Pandas Load CSV	Loads CSV files into a pandas DataFrame.
Pandas Load CSV With Encoding	Loads CSV files into a pandas DataFrame.
Pandas Load CSV With Index	Loads CSV files into a pandas DataFrame.
Pandas Load Excel	Loads Excel files into a pandas DataFrame.
Pandas Load HTML	Scans an HTML file or webpage for tables and returns the number of DataFrames
Pandas Load JSON	Loads JSON files into a pandas DataFrame.
Pandas Save CSV	Saves a PandasDataFrame to a CSV file.
Pandas Save JSON	Saves a PandasDataFrame to a JSON file.

Logical operations

Node	Description
Pandas Eq	Determines whether each element in the first pandas DataFrame is equal to the corresponding element in the second DataFrame.
Pandas Eq Scalar Float	Determines whether each element in the pandas DataFrame is equal to the float.
Pandas Eq Scalar Int	Determines whether each element in the pandas DataFrame is equal to the int.
Pandas Ge	Determines whether each element in the first pandas DataFrame is greater than or equal to the corresponding element in the second DataFrame.
Pandas Ge Scalar Float	Determines whether each element in the pandas DataFrame is greater than or equal to the float.
Pandas Ge Scalar Int	Determines whether each element in the pandas DataFrame is greater than or equal to the int.
Pandas Gt	Determines whether each element in the first pandas DataFrame is greater than the corresponding element in the second DataFrame.
Pandas Gt Scalar Float	Determines whether each element in the pandas DataFrame is greater than the float.
Pandas Gt Scalar Int	Determines whether each element in the pandas DataFrame is greater than the int.
Pandas Le	Determines whether each element in the first pandas DataFrame is less than or equal to the corresponding element in the second DataFrame.
Pandas Le Scalar Float	Determines whether each element in the pandas DataFrame is less than or equal to the float.
Pandas Le Scalar Int	Determines whether each element in the pandas DataFrame is less than or equal to the int.
Pandas Lt	Determines whether each element in the first pandas DataFrame is less than the corresponding element in the second DataFrame.
Pandas Lt Scalar Float	Determines whether each element in the pandas DataFrame is less than the float.
Pandas Lt Scalar Int	Determines whether each element in the pandas DataFrame is less than the int.
Pandas Ne	Determines whether each element in the first pandas DataFrame is not equal to the corresponding element in the second DataFrame.
Pandas Ne Scalar Float	Determines whether each element in the pandas DataFrame is not equal to the float.
Pandas Ne Scalar Int	Determines whether each element in the pandas DataFrame is not equal to the int.

Math

Node	Description
Pandas Cos	Apply the cosine function to a pandas DataFrame and converting non-numeric values to NaN.
Pandas Exp	Apply the exponential function to a pandas DataFrame and converting non-numeric values to NaN.
Pandas Log	Applying the natural logarithm function to a pandas DataFrame and converting non-numeric values to NaN.
Pandas Sin	Applies the sine function to a pandas DataFrame and converting non-numeric values to NaN.
Pandas Tan	Applies the tangent function to a pandas DataFrame and converting non-numeric values to NaN.

Numpy

Node	Description
Numpy Float Create	Creates a NumPy ndarray with 32-bit floating point precision
Numpy Int Create	Creates a NumPy ndarray with 32-bit integer
Numpy Show	Displays a Numpy ndarray as text.
Numpy Squeeze	Removes a dimension at the specified position in the input array if it is of size 1.

Plot

Node	Description
MPL Bar Chart	Generates a bar chart from a Pandas DataFrame.
MPL Line Plot	Generates a line plot from a pandas DataFrame.
MPL Pie Chart	Generates a pie chart from a pandas DataFrame.
MPL Scatter Plot	Generates a scatter plot from a pandas DataFrame.
SNS Bar Chart	Generates a bar chart from a Pandas DataFrame using Seaborn.
SNS Bar Chart Pt	Generates a bar chart from a PyTorch tensor using Seaborn.
SNS Boxplot	Generates a boxplot from a Pandas DataFrame using Seaborn.
SNS Heatmap	Generates a heatmap from a Pandas DataFrame using Seaborn.
SNS Histogram	Generates a histogram from a Pandas DataFrame using Seaborn.
SNS Histogram Pt	Generates a histogram from a PyTorch tensor using Seaborn.
SNS Line Plot	Generates a line plot from a pandas DataFrame using Seaborn.
SNS Line Plot Pt	Generates a line plot from a PyTorch tensor using Seaborn.
SNS Pairplot	Generates a pairplot from a Pandas DataFrame using Seaborn.
SNS Scatter Plot	Generates a scatter plot from a pandas DataFrame using Seaborn.
SNS Scatter Plot Pt	Generates a scatter plot from a PyTorch tensor using Seaborn.

Python wrapper

Node	Description
Py Datetime To String	Converts a Python datetime.datetime value to a Python string
Py Float To String	Converts a Python float value to a Python string
Py Int To String	Converts a Python int value to a Python string
Py Kv Float Create	Creates a Python dictionary with a string key and a float value.
Py Kv Int Create	Creates a Python dictionary with an string key and an integer value.
Py Kv String Create	Creates a Python dictionary with a string key and a string value.
Py List To String	Converts a Python list value to a Python string
Py String To Datetime	Converts a Python string to a Python datetime.datetime.
Py String To Dict	Creates a Python dictionary using the string values entered in the text field.
Py String To Float	Converts a Python string to a float.
Py String To Int	Converts a Python string to an int.
Py String To List	Creates a Python list using the string values entered in the text field.

Summary statistics

Node	Description
Pandas Corr	Computes the correlation of the DataFrame. You can select from the Pearson, Kendall or Spearman methods.
Pandas Count	Computes the count of a pandas DataFrame.
Pandas Cov	Computes the covariance of the DataFrame.
Pandas Kurtosis	Computes the unbiased kurtosis of the DataFrame.
Pandas Max	Computes the max of a pandas DataFrame.
Pandas Mean	Computes the mean of a pandas DataFrame.
Pandas Median	Computes the median of a pandas DataFrame.
Pandas Min	Computes the min of a pandas DataFrame.
Pandas Mode	Computes the mode of a pandas DataFrame.
Pandas Skew	Computes the unbiased skewness of the DataFrame.
Pandas Std	Computes the standard deviation of a pandas DataFrame.
Pandas Sum	Computes the sum of a pandas DataFrame.
Pandas Summary	Analyzes and summarizes a pandas DataFrame.
Pandas Var	Computes the variance of a pandas DataFrame.

Transformation

Node	Description
Pandas At Set Datetime	Sets a Python datetime.datetime data in a cell in a pandas DataFrame.
Pandas At Set Float	Sets a Python float data in a cell in a pandas DataFrame.
Pandas At Set Int	Sets a Python int data in a cell in a pandas DataFrame.
Pandas At Set String	Sets a Python string data in a cell in a pandas DataFrame.
Pandas Feature Split To Numpy	Splits a Pandas DataFrame into feature Numpy ndarray and label Numpy ndarray.
Pandas Feature Split To Pt	Splits a Pandas DataFrame into feature PyTorch tensor and label PyTorch tensor.
Pandas Horizontal Concat	Horizontally concatenates two pandas DataFrames.
Pandas Horizontal Split	Horizontally splits a Pandas DataFrame into two pandas DataFrames.
Pandas Iat Set Datetime	Sets a Python datetime.datetime data in a cell in a pandas DataFrame.
Pandas Iat Set Float	Sets a Python float data in a cell from a pandas DataFrame.
Pandas Iat Set Int	Sets a Python int data in a cell from a pandas DataFrame.
Pandas Iat Set String	Sets a Python string in a cell in a pandas DataFrame.
Pandas Join	Merges two pandas DataFrames based on a common column.
Pandas Melt	Performs an unpivot operation (melt) on a pandas DataFrame.
Pandas Pivot	Computes a pivot table from a pandas DataFrame.
Pandas Rename	Renames an index (row label) or a column label.
Pandas Rename Advanced	Renames one or more indices (row labels) or column labels to new labels.
Pandas Series To Data Frame	Converts a Pandas Series to a DataFrame.
Pandas Set Index	Create index (row label) from existing column or columns.
Pandas Sort	Sorts a pandas DataFrame by a specified column.
Pandas Transpose	Transposes a DataFrame.
Pandas Vertical Concat	Vertically concatenates two pandas DataFrames.
Pandas Vertical Split	Vertically splits a Pandas DataFrame into two pandas DataFrames.