9,085 reputation
1628
bio website
location
age
visits member for 2 years, 5 months
seen 24 mins ago

Jan
14
comment How to make X and Y = Z?
This question appears to be off-topic because it does not appear to concern the software Mathematica
Jan
14
revised Importing numbers from Excel
deleted 1 character in body
Jan
14
comment Breaking a While loop
another valid approach. don't know why the downvote..
Jan
13
comment How to automatically make the maximum of each row in a table(grid) bold?
i knew there was a cleaner way to do that..
Jan
13
comment The longest run of at most k different elements in a list
oh I should read from the top.. g2 is much faster but not as fast as my While loop. ( and that is with g2 given the known length of the sublist )
Jan
13
answered How to automatically make the maximum of each row in a table(grid) bold?
Jan
13
comment The longest run of at most k different elements in a list
this really bogs down on lists of the size in the question (half million elements). ListCorrelate effectively creates all the partitions and you run into memory limitations.
Jan
13
comment Breaking a While loop
While[ (m=m+1)<=50 , p=m]. No way Fortran auto exits a loop as you claim, by the way. ( I doubt VB does either.. )
Jan
13
comment Append new data to excel?
yes you can append to CSV using low level write operations. Do a search I think that's been discussed on this site.
Jan
13
revised Importing numbers from Excel
added 16 characters in body
Jan
13
comment Import a given column from an excel file?
IIRC its actually faster to import the whole thing and extract what you need that is instead of putting the range inside import just do : Import["file.xls"][[1,;;,1]].
Jan
13
comment Append new data to excel?
If you work with some format where it makes sense to append data to the end of the file then you can use OpenAppend and low level Write operations. Also, I would not use a undocumented/proprietary format such as "xls" for anything unless obviously you need to share data with excel.
Jan
13
comment Append new data to excel?
Export always writes an entire file. There is no mechanism of adding/appending/inserting/modifying an existing file (regardeless of format).
Jan
13
answered Importing numbers from Excel
Jan
13
comment Calculate this integral returns undefined
the first conditional fails for all real x (e^3x<=0).. makes me wonder why @algohli's answer works...
Jan
13
comment How to speed up my code with constructing matrices
sorry its "only" 8Gb with machine precision. still really not practical regardless of how you construct the array
Jan
12
revised The longest run of at most k different elements in a list
added 993 characters in body
Jan
12
revised The longest run of at most k different elements in a list
added 143 characters in body
Jan
12
revised The longest run of at most k different elements in a list
added 282 characters in body
Jan
12
answered The longest run of at most k different elements in a list