Write the following contents into a file named employee.json, Create a dataframe for the file,And complete the following operations. [4 marks]{ "id":1 , "name":" Ella" , "age":36 }{ "id":2,...

Write the following contents into a file named employee.json, Create a dataframe for the file,

And complete the following operations. [4 marks]

{ "id":1 , "name":" Ella" , "age":36 }

{ "id":2, "name":"Bob","age":29 }

{ "id":3 , "name":"Jack","age":29 }

{ "id":4 , "name":"Jim","age":28 }

{ "id":4 , "name":"Jim","age":28 }

{ "id":5 , "name":"Damon" }

{ "id":5,"name":"Damon"}

1. Filter the record where age>30 [1 mark]


2. Group the data by age [1 mark]


3. Query the average of all the age [1 mark]


4. Query the minimum age [1 mark]