Silly Spark SQL query

[Aakash Basu]

Hi,

How to do this when the column (malignant and prediction) names are stored
in two respective variables?


tp = test_transformed[(test_transformed.malignant == 1) &
(test_transformed.prediction == 1)].count()



Thanks,
Aakash.