CODEWITHSUNDEEP
pythonpandasdataframe
Salih
Salih

Reputation: 719

Python Counting Same Values For Specific Columns

If i have a dataframe;

      A       B       C      D
1     1       2       2      1
2     1       1       2      1
3     3       1       0      1
4     2       4       4      4

I want to make addition B and C columns and counting whether or not the same values with D columns. Desired output is;

          A       B       C     B+C      D
    1     1       2       2      4       1
    2     1       1       2      3       1
    3     3       1       0      1       1
    4     2       4       4      8       4 

There are 3 different values compare the "B+C" and "D".

Could you please help me about this?

Upvotes: 2

Views: 80

Answers (2)

sre
sre

Reputation: 279

df.insert(3,'B+C', df['B']+df['C'])
3 is the index
df.head()

    A   B   C   B+C D
0   1   2   2   4   1
1   1   1   2   3   1
2   3   1   0   1   1
3   2   4   4   8   4

After that you can follow the steps of @yatu

df['B+C'].ne(df['D'])
0     True
1     True
2    False
3     True dtype: bool

df['B+C'].ne(df['D']).sum()
 3

Upvotes: 1

yatu
yatu

Reputation: 88236

You could do something like:

df.B.add(df.C).ne(df.D).sum()
# 3

If you need to add the column:

df['B+C'] = df.B.add(df.C)
diff = df['B+C'].ne(df.D).sum()
print(f'There are {diff} different values compare the "B+C" and "D"')
#There are 3 different values compare the "B+C" and "D"

Upvotes: 2

Related Questions