# data manipulation

1. ### Measuring change over time- How to make measures from two datasets comparable?

Greetings!!! I'm interested in learning how students' academic skills change overtime, to what extent, and how college contributes to this. Academic skills include reading skills, quantitative reasoning, and English as a second language (ESL). Data on these variables are collected both...
2. ### Adjust values based on control

I have taken 20 photographs. Each photograph contained a museum specimen of a bird and a colour chart. In each photograph, I measured the brightness of a specific part of the bird's plumage and the brightness of a specific part of the colour chart. In each photograph, the value of the colour...
3. ### Rearranging a dataset in R

Hello, So I currently have a dataset that is like this: structure(list(FID = structure(1:10, .Label = c("A", "B", "C", "D", "E", "F", "G", "H", "I", "J"), class = "factor"), Treatment = c(1L, 2L, 3L, 4L, 5L, 1L, 2L, 3L, 4L, 5L), Territorial = structure(c(2L, 1L, 2L, 1L, 2L, 2L, 1L...
4. ### Stata - Merging 2 datasets

Hi all, How can I merge Dataset1 and Dataset2 to create Dataset3? Merge m:m Group doesn't provide the result expected... Thanks for your help. StdDev. Dataset1 Group Elt A 01 A 02 A 03 B 04 B 05 C 06 C 07 Dataset2 Group Type A CP A CM B CB B TD C CA...
5. ### using weightedMedian() in aggregate()?

Hello, I have a data set that looks like this: SubjectID QuestionNumber Answers Confidence 1 386 1 6.000e+00 1 2 741 1 2.000e+02 1 3 23276 1 2.000e+02 2 4 25539 1 7.000e+01...
6. ### Data manipulation - conditional loop

Hi all, I am new in Stata and couldn't find help about this transformation in the archives. Please help. I use Stata 12. Thanks, StdDev * Original data ID Len A1 3 C3 4 B1 2 * Transformed data ID Len Rank A1 3 1 A1 3 2 A1 3 3 C3 4 1 C3 4 2 C3 4 3 C3 4 4 B1 2 1 B1...