pyspark.sql.functions.concat_ws#
- pyspark.sql.functions.concat_ws(sep, *cols)[source]#
Concatenates multiple input string columns together into a single string column, using the given separator.
New in version 1.5.0.
Changed in version 3.4.0: Supports Spark Connect.
- Parameters
- sepliteral string
words separator.
- cols
Column
or column name list of columns to work on.
- Returns
Column
string of concatenated words.
See also
Examples
>>> from pyspark.sql import functions as sf >>> df = spark.createDataFrame([("abcd", "123")], ["s", "d"]) >>> df.select("*", sf.concat_ws("-", df.s, "d", sf.lit("xyz"))).show() +----+---+-----------------------+ | s| d|concat_ws(-, s, d, xyz)| +----+---+-----------------------+ |abcd|123| abcd-123-xyz| +----+---+-----------------------+