# How to Combine Two Text Columns in a DataFrame?

We sometimes need to create columns by combining two or more columns together. In this how-to article, we will learn how to combine two text columns in Pandas and PySpark DataFrames.

## Pandas

We can combine text columns with the “+” operator.

				
df["full_name"] = df["first_name"] + " " + df["last_name"]



The expression in between is used for adding a space between the first and last names. Another way of combining text columns is aggregating columns by joining.

				
df["full_name"] = df[["first_name","last_name"]].agg(" ".join, axis=1)



We can use both these methods to combine as many columns as needed. The only requirement is that the columns must be of object or string data type.

## PySpark

We can use the concat function for this task.

				
df = df.withColumn(
"full_name",
F.concat("first_name", F.lit(" "), "last_name")
)



The lit function is used for adding the space between the first and last names.

### This question is also being asked as:

• Python combining two columns.

How-Tos

### How to Convert a Dictionary to a DataFrame?

Dictionary is a built-in data structure of Python, which consists of key-value pairs. In this short …
Data Science

### How to Delete Rows Based on Column Values in a DataFrame?

A row in a DataFrame can be considered as an observation with several features that are represented …
Data Science

### How to Convert the Index of a DataFrame to a Column?

DataFrame is a two-dimensional data structure with labeled rows and columns. Row labels are also kno …
Start Monitoring Your Models in Minutes