[Python] How to add a constant to all elements of a Pandas DataFrame?

Question

Which function should I use to add a number to all elements of a Pandas DataFrame?

Answer 1

You can use the add() function of Pandas DataFrame to add any value to all elements of a DataFrame.

Here is an example:

>>> import pandas as pd
>>> df = pd.DataFrame({'a':[10,20,30], 'b':[11,22,33], 'c':[12,24,36]})
>>> df
    a   b   c
0  10  11  12
1  20  22  24
2  30  33  36

>>> df.add(5)
    a   b   c
0  15  16  17
1  25  27  29
2  35  38  41
>>> 

You can also add the number directly to the DataFrame.

Example:

>>> df+5
    a   b   c
0  15  16  17
1  25  27  29
2  35  38  41