Restaurant Menu (Data Cleaning)

Restaurant Menu Dataset

With approximately 45,000 menus dating from the 1840s to the present, The New York Public Library’s restaurant menu collection is one of the largest in the world. The menu data has been transcribed, dish by dish, into this dataset. For more information, please see http://menus.nypl.org/about.

This dataset is not clean and contains many missing values, making it perfect to practice data cleaning tools and techniques.

Dataset Variables:

• id: identifier for menu
• name:
• sponsor: who sponsored the meal (organizations, people, name of restaurant)
• event: category
• venue: type of place (commercial, social, professional)
• place: where the meal took place (often a geographic location)
• physical_description: dimension and material description of the menu
• occasion: occasion of the meal (holidays, anniversaries, daily)
• notes: notes by librarians about the original material
• call_number: call number of the menu
• keywords:
• language:
• date: date of the menu
• location: organization or business who produced the menu
• location_type
• currency: system of money the menu uses (dollars, etc)
• currency_symbol: symbol for the currency ($, etc)
• status: completeness of the menu transcription (transcribed, under review, etc)
• page_count: how many pages the menu has
• dish_count: how many dishes the menu has