如何在pandas中添加两列

import pandas as pd

# 读取数据集
df = pd.read_csv('data.csv')

df['new_column1'] = 0  # 添加名为'new_column1'的列，并将所有值设置为0
df['new_column2'] = 'text'  # 添加名为'new_column2'的列，并将所有值设置为'text'

df['new_column3'] = df['column1'] + df['column2']  # 添加名为'new_column3'的列，其值为'column1'和'column2'列对应位置的和
df['new_column4'] = df['column3'] * 2  # 添加名为'new_column4'的列，其值为'column3'列的值乘以2

df['new_column5'] = df['column4'].apply(lambda x: 'Yes' if x > 0 else 'No')  # 添加名为'new_column5'的列，根据'column4'列的值是否大于0，设置为'Yes'或'No'

print(df)