117 reputation
7
bio website
location
age
visits member for 1 year, 11 months
seen Sep 13 at 16:20

Jan
17
accepted Optimising 2D binning code
Jan
17
comment Optimising 2D binning code
@OleksandrR. Sorry I don't quite understand your comment. Gwyddion gave a set of 100x100 z values (all real values) while the code above returned lots of zeros. Is it to do with my bin intervals? I did (max - min)/100 to calculate the interval
Jan
17
awarded  Supporter
Jan
16
comment Optimising 2D binning code
@Mr.Wizard, i tried your codes and ran it with my data. I tried with 10,000 data and 100x100 bins. The final array of z values has a lot of zeros (implying empty bins). I ran the same data using the software Gwyddion which binned the data and returned 100x100 z values without a single zero in the array. Is there anything wrong with the code above? Thank you
Jan
15
comment Optimising 2D binning code
@kguler thank you
Jan
15
comment Optimising 2D binning code
Does it set the SparseArray function back to normal?
Jan
15
comment Optimising 2D binning code
@kguler, I understand that you overloaded the SparseArray function to calculate mean of the repeated entries in the bin.. But what does the last command do ? System`SetSystemOptions["SparseArrayOptions" -> {"TreatRepeatedEntries" -> First}];
Jan
15
comment Optimising 2D binning code
@kguler Can you please tell me how the indexes are calculated? i mean how is it similar to binLists?
Jan
15
comment Optimising 2D binning code
Or where should I use BinLists in this code?
Jan
15
comment Optimising 2D binning code
And is the final result average of binned z values?
Jan
14
awarded  Nice Question
Jan
14
comment Optimising 2D binning code
@kguler and @ Mr.Wizard, thanks for the quick responses. It looks good but one the possible problem with this rescaling method is that it can round 2 different values to 1 value.And this will introduce error in my final result. My original data are decimal real values and accuracy is important. Is there any other way of doing it by not using Rescale ? Thank you
Jan
14
awarded  Student
Jan
14
awarded  Editor
Jan
14
revised Optimising 2D binning code
added 201 characters in body
Jan
14
asked Optimising 2D binning code