title: How to concatenate a string to a column in Spark?
body: <p>I have the following data and would like to get the result with a text prefix:</p>
  
  <p>Input dataframe:</p>
  
  <pre><code>sk            id       
  2306220722    117738
  </code></pre>
  
  <p>Current code:</p>
  
  <pre><code>df.withColumn("Remarks", concat_ws("MCA", col("ID")))
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>sk           id      Remarks  
  2306220722   117738  MCA 117738
  </code></pre>
  
  <p>I would like to prefix the <code>id</code> column with "MCA" and add the resulting string to the <code>Remarks</code> column.</p>