I need to create a list from a general Excel database that requires only data from "ALL STUDENTS" rows on columns 2 and 7.
The List most be of the form {DISTRICT, MATH} where the MATH score is only from the ALL STUDENTS group.
I'm not really sure how to go about doing this, whether i can just import specific stuff only from the file, or if I can just compose a list with specific entries. My mathematica skills are very limited and I don't find the mathematica more info option very helpful.
Any help is much appreciated
Edit:
Import["SAT_District_Data_class_2011.csv", {"Sheets", 1,
All, {2, 7}}][[2 ;; ;; 12]]
returns the errors:
import::noelem: The Import element "Sheets " is not present when importing as CSV
Part::take: "Cannot take positions 2 through -1 in $Failed. "
Import["yourexcelfile.xlsx", {"Sheets", 1, All, {2, 7}}][[2;;;;12]]
? $\endgroup$ – kglr Apr 30 '15 at 21:36Import["SAT_District_Data_class_2011.csv"][[ 2 ;; ;; 12, {2,7}]]
$\endgroup$ – kglr Apr 30 '15 at 23:00