Managing data with a complex structure

Managing data with a complex structure#

Learning Objectives#

After working through this topic, you should be able to:

  • Explain the three rules for storing tabular data in a collection of tables:

    1. Values have no internal structure

    2. Tables do not contain redundant information

    3. Variable names have no structure

  • Apply the rules to data management tasks by:

    1. Doing all data management in a collection of tables satisfying these rules

    2. Storing each of these tables in a separate file

    3. Merging / reshaping the tables as needed for analysis

Materials#

Video:

Download the slides.

Quiz#