What is the difference between "long" ("tall") and "wide" format data?

Data Science Interview QuestionsCategory: Data ScienceWhat is the difference between "long" ("tall") and "wide" format data?
1 Answers
MockInterview Staff answered 5 years ago

Explain the difference between “long” and “wide” format data. Why would you use one or the other?

  • Long: one column containing the values and another column listing the context of the value Fam_id year fam_inc
  • Wide: each different variable in a separate column
    Fam_id fam_inc96 fam_inc97 fam_inc98

Long Vs Wide:
– Data manipulations are much easier when data is in the wide format: summarize, filter
– Program requirements
Source

Your Answer

8 + 7 =