7819 A demographic dataset is stored on HDFS where each record is of the following format:...

Transcribed Image Text:

7819 A demographic dataset is stored on HDFS where each record is of the following format: <state>, <district> <citizenid> <gender> <age> <yearly income> write the outline of a Spark program to load the file and answer the following 2 queries [Marks: 6] 1. What is the average "yearly income of the female population in the age group "22-40" by state? 2. Which state has the maximum senior citizens (age > 60) with yearly income < 1 lac? 7819 A demographic dataset is stored on HDFS where each record is of the following format: <state>, <district> <citizenid> <gender> <age> <yearly income> write the outline of a Spark program to load the file and answer the following 2 queries [Marks: 6] 1. What is the average "yearly income of the female population in the age group "22-40" by state? 2. Which state has the maximum senior citizens (age > 60) with yearly income < 1 lac?