Question

How to add column to pandas DataFrame with a default value in Python

Answer 1

import pandas as pd
  
df = pd.DataFrame(
    [['Tom', 91, 80, 94],
     ['Emmy', 98, 95, 96],
     ['Rubeus', 87, 81, 87],
     ['Dumbledore', 99, 100, 98],
     ['Axel', 75, 85, 90]],
    columns=['name', 'algebra', 'python', 'java'])
  
df['c++'] = 70

print(df)

   
   
   
'''
run:
   
          name  algebra  python  java  c++
0         Tom       91      80    94   70
1        Emmy       98      95    96   70
2      Rubeus       87      81    87   70
3  Dumbledore       99     100    98   70
4        Axel       75      85    90   70
 
'''

 

70+ SQL courses for beginners and professionals