OptionalallKeep the rows of both frames that have no match. Default false.
OptionalallKeep the rows of x that have no match in y (y's columns missing). Default all.
OptionalallKeep the rows of y that have no match in x (x's columns missing). Default all.
OptionalbyThe key columns, in both frames. Default: the column names common to both, in x's order.
OptionalbyThe key columns of x. Default by.
OptionalbyThe key columns of y (as many as byX, matched in order). Default by.
OptionalsortOrder the rows by the key. Default true.
OptionalsuffixesAppended to the names of the non-key columns that occur in both frames. Default [".x", ".y"].
Options for merge.