Hi Folks:
I appreciate for your help to guide me to
solve this problem.
I have a huge data set, in which i have school
districts listed, and within each school district are diffierent number of
schools listed, and there are 2 numerical variables by school ,
but i want the sum of each variable for by school district. Since it is
a very large data set with thousands of school districts, it is
tedious to do the work by spreadsheet. Can someone help me to show how
to output the sum for each school district.
Here is the small sample data :
code
schldistric
school lunch student
1600001
a ab 2
4
1600001 a cd 3 7
1600001
a
er 5
12
1600060
c cd
3
21
1600060 c
w
2
3
1400003
e gh
3
230
3000023
v kl
2
3
3000023
v gr
3
2
3000023
v
rt
4
12
what i want is the
output as follow
code
schldistric lunch_sum
student_sum
1600001
a 10
23
1600060
c
5
24
1400003
e
3
230
3000023
v 9
17