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"}
- Filter the record where age>30 [1 mark]
- Group the data by age [1 mark]
- Query the average of all the age [1 mark]
- Query the minimum age [1 mark]