1 pagine (9 elementi)
Deleting Rows an Columns - Matrice Handling - Messaggi
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,39 KiB) scaricato 1446 volta(e). (old method)
delete_rowcol.sm (15,58 KiB) scaricato 1436 volta(e). (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,39 KiB) scaricato 1446 volta(e). (old method)
delete_rowcol.sm (15,58 KiB) scaricato 1436 volta(e). (new and faster method)

1 utenti hanno apprezzato questo post
sergio 31/05/2021 05:16:00
Alternate program. Very fast on large matrix.
Jean's program very helpful. Thank you Jean
New_Matrix_Delete [col_row].sm (24,06 KiB) scaricato 1314 volta(e).

Jean's program very helpful. Thank you Jean
New_Matrix_Delete [col_row].sm (24,06 KiB) scaricato 1314 volta(e).

Look within!... The secret is inside you.
Best Regards
Eng. NDTM Amarasekera - Sri Lanka
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 utenti hanno apprezzato questo post
NDTM Amarasekera 01/06/2021 13:29:00
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,58 KiB) scaricato 1334 volta(e).
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,58 KiB) scaricato 1334 volta(e).
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 utenti hanno apprezzato questo post
overlord 03/06/2021 21:45:00
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,9 KiB) scaricato 1288 volta(e).

Faster on large matrix than my last example in post #3.
New_Matrix_Delete [col_row]_R2.sm (41,9 KiB) scaricato 1288 volta(e).
Look within!... The secret is inside you.
Best Regards
Eng. NDTM Amarasekera - Sri Lanka
Hi Amarasekera. Please try this other version, which works for single column values or column ranges.
New_Matrix_Delete [col_row]_R2.sm (38,79 KiB) scaricato 1276 volta(e).

Best regards.
Alvaro.
New_Matrix_Delete [col_row]_R2.sm (38,79 KiB) scaricato 1276 volta(e).

Best regards.
Alvaro.
2 utenti hanno apprezzato questo post
1 pagine (9 elementi)
- Nuovi post
- Nessun nuovo post