[Tutor] New Item

[LARRYSTALEY07 at comcast.net]

I am very new to Python and appreciate the input as I was able to fully install Python with all needed libraries (i.e., numpy, pandas, etc.). However, I now have an application question in needed to construct a 2D Histogram. 

Basically, I have an Excel file that includes three columns: 
Column 1 - Gender (Male or Female) 
Column 2 - Height (in inches) 
Column 3 - Hand Span (in inches) 

There are 168 entries in the Excel file. 

I need to construct two separate 2D histograms for the two classes, one for the height and the other for the hand span. These formulas would appear as: 

r = ROUND ( (B-1) ((h(i) - h(min) / (h(max) - h(min)) ***this is for the height and requires each the min and max height from the 168 entries. B is for number of bins. I will use 7. i is for each height entry, from 1 through 168. 
c = ROUND ( (B-1) ((s(i) - s(min) / (s(max) - s(min)) ***this is for the hand span and requires each the min and max hand span from the 168 entries. B is for number of bins. Again, I am using 7. i is for each hand span entry, from 1 through 168. 

Finally, if gender = Female, I update H(f) as H(f)[r,c] + 1. Else is Male or update H(m) as H(m)[r,c] + H(m)[r,c] + 1. 

As it appears I need arrays first totalled by gender, height and hand span, appears that would look like the following: 



data=readExcel(excelfile) 
X=np.array(data[:,1],dtype=float); 
S=np.array(data[:,2],dtype=float); 
T=np.array(data[:,0],dtype=str); 




Finally, is my intended coding for the actual 2D histogram. I will get min and max from the height and hand span arrays. Note I am still learning Python and looping is new to me: 




# Define histogram classifier to build histogram using two variables 
def Build1DHistogramClassifier(X, S, smin, smax,T,B,xmin,xmax): 
HF=np.zeros(B).astype('int32'); 
HM=np.zeros(B).astype('int32'); 
binindices1=(np.round(((B-1)*(X-xmin)/(xmax-xmin)))).astype('int32'); 
binindices2=(np.round(((B-1)*(S-smin)/(smax-smin)))).astype('int32'); 
for i,b in enumerate(binindices1): 
for i,c in enumerate(bindindices2): 
if T[i]=='Female': 
HF[b,c]+=1; 
else: 
HM[b,c]+=1; 
return [HF, HM] 




I would appreciate any input on this approach and at least if I am going in the right direction. 

Thanks again. 




Larry Staley 

larrystaley07 at comcast.net 

650.274.6794