我试图通过划分两列来为每一列创建一个新列。 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
