Find out the head count of employee in each job | Data Engineering Interview | TigerAnalytics

[@tanmaykapil5362]

bro also attach csv file in the description it will be better we can prac. although u r doing great job

[@CognitiveCoders]

Please get the dataset from telegram channel

[@RajendraPrasad-qc3cy]

Hi Pritam, i'm new subscriber to your channel and your videos are greatful for us. A request from my end is, please provide the datasets and datafrme create statement scripts in description

[@CognitiveCoders]

From telegram channel you will get all the data files.

[@vighneshbuddhivant8353]

df=spark.read.csv("/content/jobs.csv",header=True)
df.show()
result=df.groupBy('job').agg(count('name').alias('total_count'))
result.show()
rows=result.rdd.collect()
result_dict = dict((row['job'], row['total_count']) for row in rows)
print(result_dict)