11. Write spark code to find the employee count under each manager | Pyspark | SQL Solution

If you like this video please do like,share and subscribe my channel.

data = [(4529,'Nancy','Young','4125'),(4238,'John','Simon','4329'),(4329,'Martina','Candreva','4125'),(4009,'Klaus','Koch','4329'),(4125,'Mafalda','Ranieri','Null'),(4500,'Jakub','Hrabal','4529'),(4118,'Moira','Areas','4952'),(4012,'Jon','Nilssen','4952'),(4952,'Sandra','Rajkovic','4529'),(4444,'Seamus','Quinn','4329')]

schema = ['emp_id','first_name','last_name','manager_id']

PySpark playlist :    • PySpark and Databricks  

Azure Datafactory playlist :    • Azure Data Factory Tutorial  

PySpark RealTime Scenarios playlist :    • PySpark Real Time Scenarios  

PySpark Interview Question :    • PySpark Interview Series  

Scenario Based Interview Question :    • Scenario Based Interview Question  

Unit Testing in PySpark :    • UnitTesting PySpark  

Linkedin :   / pritam-saha-060516139  

GitHub : https://github.com/Pritamsaha627/Pyspark

Contact Mail Id : [email protected]

Telegram channel : https://t.me/CognitiveCoders

Topmate : https://topmate.io/pritamsaha627

WhatsApp channel : https://whatsapp.com/channel/0029Va4x...

Instagram :   / pritamsaha627  

Travel & Food Vlogs :    / @pritamsaha627  

1 Subscriber, 1👍🏻, 1Comment = 100 Motivation 🙏🏼
🙏🏻Please Subscribe 🙏🏼

#pyspark #databricks #tutorial #beginners #dataengineeringessentials #dataengineers #python #job #interview #questions #data #machinelearning #dataenginners #datascience #sql #easy #learning #subscribe #realtimescenarios #cognitivecoders