This question already has an answer here:
Is there an equivalent to Hadley Wickham's Tidy Data concept for GIS tables? For instance, a table in this format:
grade male female 1 A 1 5 2 B 5 0 3 C 5 2 4 D 5 5 5 E 7 4 would not be considered tidy data because the header contains values (male, female). Instead, the table is melted into the form:
grade sex count 1 A male 1 2 B male 5 3 C male 5 4 D male 5 5 E male 7 6 A female 5 7 B female 0 8 C female 2 9 D female 5 10 E female 4 where the variables "grade", "sex" and "count" are used to capture exactly one unique observation along each row.
If I were to apply this methodology to a table of polygons I would be duplicating my polygons in order to keep each row unique. Is that considered good form in GISs?
Apologies if this is the wrong place to post this potentially "soft" question.
أكثر...
Is there an equivalent to Hadley Wickham's Tidy Data concept for GIS tables? For instance, a table in this format:
grade male female 1 A 1 5 2 B 5 0 3 C 5 2 4 D 5 5 5 E 7 4 would not be considered tidy data because the header contains values (male, female). Instead, the table is melted into the form:
grade sex count 1 A male 1 2 B male 5 3 C male 5 4 D male 5 5 E male 7 6 A female 5 7 B female 0 8 C female 2 9 D female 5 10 E female 4 where the variables "grade", "sex" and "count" are used to capture exactly one unique observation along each row.
If I were to apply this methodology to a table of polygons I would be duplicating my polygons in order to keep each row unique. Is that considered good form in GISs?
Apologies if this is the wrong place to post this potentially "soft" question.
أكثر...