Chapter 2: Intermediate

This chapter covers the intermediate level functionality of working with tidychef.

By the end of this chapter you should:

• know how to iterate through and combine data extracted from multiple tables

• know how to drop duplicates

• know how to use horizontal conditions

• know how to move data markings or other notations to their own separate column

• know how to use a within lookup

• know how to use and create more complex methods of validation

• know how to pass data from tidychef to pandas

• understand best practices when working wth tidychef

Contents

• Apply
• TidyData: Concatenation
• Iterating Tables/Sheets
• TidyData: Duplicate Rows
• TidyData: Horizontal Conditions
• TidyData: Data Markers & Dropping Columns
• Pandas
• TidyData: Column: validate=
• TidyData: Within
• Against (Creating New Validators)
• Best Practice
• Time