Yeah, read my message above where I mention this. We are still missing a step, a way to have a sparse matrix where the 0-value is missing. I know it exists, hopefully someone else can help.
Thanks, it’s great to have a second method to do this though, it’ll probably come in handy at some point.
It’s mostly just an optimization thing that I’d like to sort out early because I’m doing wavelets and will never need those empty cells, basically. So sparse matrices are ideal for what I need.
Maybe it’s this?
See some old discussion here.
Just as an aside, if your data is small enough to open up in excel, you might not need a sparse matrix at all.
Oh, this looks like it might be useful in the end:
Just as an aside, if your data is small enough to open up in excel, you might not need a sparse matrix at all.
You’re right. The way I’m hoping for this to work might only need to output something readable at the very last step, so converting to a dense array at that point probably doesn’t matter one way or another.
The data size is flexible though, eventually I would like to be able to use much larger sets than Excel could handle (wav files, basically)
Still a long way for me to go to get there though, 
, but I have the basic groundwork covered and can use Excel to evaluate outputs as I go in the meantime still to see if everything works as it should.
Wait why is this relevant to your current problem?
You mean array of arrays?
Not for the current problem, no. But I will want to do operations on the arrays that may go a couple of layers deep in the end.
A bit of a variation on this sort of thing: https://file.scirp.org/Html/2-1630011/dff8c838-6c24-4e6a-abda-5459bed729bf.jpg
from here: SWAT and Wavelet Analysis for Understanding the Climate Change Impact on Hydrologic Response
I have the whole operation running on Excel, but as you can imagine it takes days to run things when they get a couple of layers deep. I think understand what I want to do well enough now that its time to port to something a bit more practical. I tried Python before but it didn’t improve speed enough to warrant losing the visual directness while I was playing around with things.
Enter Julia.
1 Like