Question: Write a program using the attached datasets above by doing the following: 1 . Review the meal _ info.csv and test.csv datasets and identify a

Write a program using the attached datasets above by doing the following:
1. Review the meal_info.csv and test.csv datasets and identify a common dataframe value (column name).
2. Merge the meal_info.csv and test.csv datasets using the common value. It will be the same for both datasets (right and left).
3. Review the fulfilment_center_info.csv and test.csv datasets and identify a common dataframe value (column name).
4. Merge the fulfilment_center_info.csv and test.csv datasets using the common value. It will be the same for both datasets (right and left).
5. Create a many-to-many merge by passing the multiple columns from the 2 merges above (#2 and #4). Use the 2 common values from the above merges to match to 2 columns for both right and left. Print only the 4th record of this merge. (Similar to pg.106)
The 4th record of the many-to-many merge will look like the following:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!