1 Pages (9 items)
Deleting Rows an Columns - Matrice Handling - Messages
#1 Posted: 5/30/2021 10:31:23 PM
Some functions for row and column deletion.
For row and column functions accepts horizontal and vertical vectors, range(2) and range(3), numbers.
No need to convert anything during input, and exceeding and subceeding values not be removed.
Regards
delete_rowcol.sm (21 KiB) downloaded 62 time(s). (old method)
delete_rowcol.sm (15 KiB) downloaded 67 time(s). (new and faster method)

For row and column functions accepts horizontal and vertical vectors, range(2) and range(3), numbers.
No need to convert anything during input, and exceeding and subceeding values not be removed.
Regards
delete_rowcol.sm (21 KiB) downloaded 62 time(s). (old method)
delete_rowcol.sm (15 KiB) downloaded 67 time(s). (new and faster method)
1 users liked this post
sergio 5/31/2021 5:16:00 AM
#3 Posted: 6/1/2021 12:23:20 AM
Alternate program. Very fast on large matrix.
Jean's program very helpful. Thank you Jean
New_Matrix_Delete [col_row].sm (24 KiB) downloaded 67 time(s).

Jean's program very helpful. Thank you Jean
New_Matrix_Delete [col_row].sm (24 KiB) downloaded 67 time(s).
Look within!... The secret is inside you.
Best Regards
Eng. NDTM Amarasekera - Sri Lanka
#4 Posted: 6/1/2021 11:30:22 AM
WroteAlternate program. Very fast on large matrix.
Jean's program very helpful. Thank you Jean
I tried your solution and found out it is faster with single row or single column removal. Good job.
And also found out transpose method is way much slower if I use ranges or matrices for input.
That method is not fast enough and not a good method when you use vectors of columns or rows for removal.
So I have combined your solution with mine, a fast and feature-full method is born.
New file is added in first post.
Regards
1 users liked this post
NDTM Amarasekera 6/1/2021 1:29:00 PM
#5 Posted: 6/1/2021 12:52:21 PM
From square/rectangular matrix algo style do all at will.
1. delete cols & rows in any shuffled ways.
2. conserve selected rows deleted of 'j'.
3. conserve selected cols deleted of 'j'.
Hopefully, no red in your SS version !
Thanks, be good ... Jean.
Utilities Matrix Minor [col_row] ADVANCED OTHERWISE Copy.sm (21 KiB) downloaded 59 time(s).
1. delete cols & rows in any shuffled ways.
2. conserve selected rows deleted of 'j'.
3. conserve selected cols deleted of 'j'.
Hopefully, no red in your SS version !
Thanks, be good ... Jean.
Utilities Matrix Minor [col_row] ADVANCED OTHERWISE Copy.sm (21 KiB) downloaded 59 time(s).
#6 Posted: 6/1/2021 1:28:36 PM
WroteI tried your solution and found out it is faster with single row or single column removal. Good job.
And also found out transpose method is way much slower if I use ranges or matrices for input.
That method is not fast enough and not a good method when you use vectors of columns or rows for removal.
So I have combined your solution with mine, a fast and feature-full method is born.
New file is added in first post.
Yes it works fast. It is a smart code with added features.
Thank you.
Look within!... The secret is inside you.
Best Regards
Eng. NDTM Amarasekera - Sri Lanka
1 users liked this post
overlord 6/3/2021 9:45:00 PM
#7 Posted: 6/2/2021 3:34:35 PM
A revised version, to delete multiple non-adjacent columns.
Faster on large matrix than my last example in post #3.
New_Matrix_Delete [col_row]_R2.sm (41 KiB) downloaded 63 time(s).

Faster on large matrix than my last example in post #3.
New_Matrix_Delete [col_row]_R2.sm (41 KiB) downloaded 63 time(s).
Look within!... The secret is inside you.
Best Regards
Eng. NDTM Amarasekera - Sri Lanka
2 users liked this post
#8 Posted: 6/2/2021 6:12:03 PM
Hi Amarasekera. Please try this other version, which works for single column values or column ranges.
New_Matrix_Delete [col_row]_R2.sm (38 KiB) downloaded 64 time(s).

Best regards.
Alvaro.
New_Matrix_Delete [col_row]_R2.sm (38 KiB) downloaded 64 time(s).
Best regards.
Alvaro.
2 users liked this post
1 Pages (9 items)
-
New Posts
-
No New Posts