#KPMG Data engineer interview experience.

#KPMG interview questions of data engineers for 2years experienced candidates #python/SQL/Pyspark dataframe transformations.

[beingnagur]

df = df.withcolumn("b", when(df.a == 1, sum(df.b))) i think this method also will work... Correct me if i am wrong

[souradeep.official]

data=[(1, 5),
(1, 5),
(1, 5),
(1, 5),
(2, 3)]
df=spark.createDataFrame(data, "a int, b int")


df1.show()

[sivaani]

Could you post the other solutions as well