Timeline for GatherBy based on condition imposed on index variable
Current License: CC BY-SA 3.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 11, 2014 at 16:01 | comment | added | ramesh | @ Fred, thank you fro your suggestion. I will work on your function and suggestion. Thanks again. | |
| Dec 11, 2014 at 15:59 | comment | added | Fred Simons | @rka I have no experience at all with large data sets. But I understood that the function Lookup with Associations is very fast, and independent where you want to look in your data (beginning or end). I also understood that Associations are "memory hungry". My feeling is that if your data set fits in the memory of Mathematica as an Association, you will be better of with Lookup, of course depending of what you want to do. So I edited my answer showing how you could transform your testdat to an Association and how you could use LookUp. You might also look at the function GroupBy. | |
| Dec 11, 2014 at 15:47 | history | edited | Fred Simons | CC BY-SA 3.0 |
added 394 characters in body
|
| Dec 11, 2014 at 15:22 | comment | added | ramesh | @ Fred, thank you for your answer. What if I have a large data and index is too big to navigate. In fact, I have over 2m rows. | |
| Dec 11, 2014 at 15:19 | history | answered | Fred Simons | CC BY-SA 3.0 |