Description
Complete this assignment using MongoDB.
- Create a database called “sample”.
- Create a collection called “test_data” and load the following data into the collection.
| class | age | menopause | deg_malig | breast | breast_quad | irradiat |
| NO | 35 | premeno | 3 | left | left_low | no |
| NO | 42 | premeno | 2 | right | right_up | no |
| NO | 30 | premeno | 2 | left | left_low | no |
| NO | 61 | ge40 | 2 | right | left_up | no |
| NO | 45 | premeno | 2 | right | right_low | no |
| NO | 64 | ge40 | 2 | left | left_low | no |
| NO | 52 | premeno | 2 | left | left_low | no |
| NO | 67 | ge40 | 1 | left | left_low | no |
| YES | 41 | premeno | 2 | left | left_low | no |
| YES | 43 | premeno | 2 | right | left_up | no |
| YES | 41 | premeno | 3 | left | central | no |
| YES | 44 | ge40 | 2 | left | left_low | no |
1 of 2
| YES | 61 | lt40 | 1 | left | right_up | no |
| YES | 55 | ge40 | 3 | left | right_up | no |
| YES | 44 | premeno | 3 | left | left_up | no |
- Write MongoDB queries to select/compute data from the “test_data” collection.
- Select all rows where the menopause column has the value “ge40”.
- Select all rows where age is less than 41.
- Select all rows where age is less than 41 or the menopause column has the value “ge40”.
- Compute the average age across all rows.
