Deleting Rows an Columns

Deleting Rows an Columns - Matrice Handling - Messaggi

#1 Pubblicato: 30/05/2021 22:31:23
overlord

overlord

600 apprezzamenti in 1.381 post.

Gruppo: Moderator

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)

2021-05-31_04-24_1.png
1 utenti hanno apprezzato questo post
sergio 31/05/2021 05:16:00
#2 Pubblicato: 31/05/2021 08:01:39
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

Otherwise useful ... you delete what you don't select.

DelColRow.PNG
1 utenti hanno apprezzato questo post
sergio 31/05/2021 08:16:00
#3 Pubblicato: 01/06/2021 00:23:20
NDTM Amarasekera

NDTM Amarasekera

130 apprezzamenti in 352 post.

Gruppo: User

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).

Del_Col_Row_Ex.png
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
2 utenti hanno apprezzato questo post
overlord 03/06/2021 21:45:00, sergio 01/06/2021 04:28:00
#4 Pubblicato: 01/06/2021 11:30:22
overlord

overlord

600 apprezzamenti in 1.381 post.

Gruppo: Moderator

Wrote

Alternate 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

2021-06-01_17-25.png
1 utenti hanno apprezzato questo post
NDTM Amarasekera 01/06/2021 13:29:00
#5 Pubblicato: 01/06/2021 12:52:21
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

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).
#6 Pubblicato: 01/06/2021 13:28:36
NDTM Amarasekera

NDTM Amarasekera

130 apprezzamenti in 352 post.

Gruppo: User

Wrote

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.



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
#7 Pubblicato: 02/06/2021 15:34:35
NDTM Amarasekera

NDTM Amarasekera

130 apprezzamenti in 352 post.

Gruppo: User

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).

Capture.PNG
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
2 utenti hanno apprezzato questo post
overlord 03/06/2021 21:45:00, Alvaro 02/06/2021 17:53:00
#8 Pubblicato: 02/06/2021 18:12:03
Alvaro

Alvaro

1.139 apprezzamenti in 1.805 post.

Gruppo: User

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).

Clipboard01.jpg

Best regards.
Alvaro.
2 utenti hanno apprezzato questo post
overlord 03/06/2021 21:45:00, NDTM Amarasekera 02/06/2021 23:47:00
#9 Pubblicato: 02/06/2021 18:35:44
Jean Giraud

Jean Giraud

983 apprezzamenti in 6.866 post.

Gruppo: User

1 utenti hanno apprezzato questo post
NDTM Amarasekera 02/06/2021 23:48:00
  • Nuovi post
  • Nessun nuovo post