Skip to main content
 首页 » 编程设计

Python Pandas 在循环中创建新列

2024年10月24日13shihaiming

我试图通过划分两列来为每一列创建一个新列。 df 是一个 Pandas 数据框...

columns = list(df.columns.values) 
for column_1 in columns:  
    for column_2 in columns:          
        new_column = '-'.join([column_1,column_2]) 
        df[new_column] = df[column_1] / df[column_2] 

出现错误:NotImplementedError: operator '/' not implemented for bool dtypes

有什么想法会很感激吗?

请您参考如下方法:

就像 Brian 所说的那样,您肯定会尝试划分非数字列。下面是划分两列以创建第三列的工作示例:

name = ['bob','sam','joe'] 
age = [25,32,50] 
wage = [50000, 75000, 32000] 
 
people = {} 
for i in range(0,3): 
    people[i] = {'name':name[i], 'age':age[i],'wage':wage[i]} 
 
# you should now have a data frame where each row is a person 
# you have one string column (name), and two numerics (age and wage)         
df = pd.DataFrame(people).transpose() 
 
df['wage_per_year'] = df['wage']/df['age'] 
 
print df