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

Data Science Interview Questions › Category: Data Science › What is the difference between "long" ("tall") and "wide" format data?
0 Vote Up Vote Down
MockInterview Staff asked 6 years ago

Source

1 Answers
0 Vote Up Vote Down
MockInterview Staff answered 6 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

5 + 9 =