Question 13: KPMG Interview Questions part 2| data engineers | groupBy #pyspark #KPMG #big4

In this video I have discussed on Interview question asked in KPMG interview for data engineers.

Write a pyspark query to find avg salary of each dept also rename the column.

# Sample data
data = [("John", "IT", 5000),
("Alice", "HR", 6000),
("Bob", "IT", 5500),
("Eve", "Finance", 7000),
("Charlie", "HR", 6500),
("David", "Finance", 7500)]

columns = ["Name", "Department", "Salary"]

# Create a DataFrame

Solution is in PySpark

Check out this video and do let me know your doubts we can connect on

Do subscribe @pysparkpulse for more such Questions.

#pyspark #spark #bigdata #bigdataengineer #dataengineering #dataengineer #deloitte #pwc #mnc #kpmg #interviewquestions

[rawat]

Thank you Sir, keep doing the great work