从 pandas 数据框中减去两列并将结果存储在第三列中 [英] subtracting two columns from pandas dataframe and store the result in third column

问题描述

我有一个 DataFrame，df，有 3 列，我想按如下方式执行减法:

I have a DataFrame, df, with 3 columns and I want to perform subtraction as follows:

df['available'] = df['recommended'] - df['manual input']

但我收到一条错误消息:

But I am getting an error stating:

不支持的操作数类型 -: 'int' 和 'str'

unsupported operand type(s) for -: 'int' and 'str'

我也尝试过

df['available'] = df['recommended'].sub(df['manual input'])

但它显示相同的错误.

我还想知道，如果我们尝试从数据框中获取特定列，它会返回 Series 吗??

Also I would like to know that does it returns Series if we try to get particular column from dataframe??

推荐答案

您必须将值转换为数字 - 例如到 integers:

You have to convert values to numeric - e.g. to integers:

df['available'] = df['recommended'] - df['manual input'].astype(int)

或者到floats:

df['available'] = df['recommended'] - df['manual input'].astype(float)

这篇关于从 pandas 数据框中减去两列并将结果存储在第三列中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！