How to Add a New Column with a Constant Value to a DataFrame?

pandas and pyspark dataframe new column with constant value

DataFrame is a two-dimensional data structure with labeled rows and columns. We can always add new columns or rows to a DataFrame.

In this short how-to article, we will learn how to add a new column of a constant value to Pandas and PySpark DataFrames.



It is a quite simple operation in Pandas.

					df["Bonus"] = 100


We can perform this task using the withColumn and lit functions as below:

					from pyspark.sql import functions as F

df = df.withColumn("Bonus", F.lit(100))

This question is also being asked as:

  • How to add a new column with string constant?

People have also asked for:

You may also like

Start Monitoring Your Models in Minutes