Deleting Rows an Columns

Deleting Rows an Columns - Matrice Handling - 消息

#1 已发布: 2021/5/30 22:31:23
overlord

overlord

600个赞,共1,381个帖子。

组: 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)已下载 1458 次。 (old method)

delete_rowcol.sm (15.58 KiB)已下载 1446 次。 (new and faster method)

2021-05-31_04-24_1.png
1位用户喜欢此帖子
sergio 2021/5/31 05:16:00
#2 已发布: 2021/5/31 08:01:39
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

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

DelColRow.PNG
1位用户喜欢此帖子
sergio 2021/5/31 08:16:00
#3 已发布: 2021/6/1 00:23:20
NDTM Amarasekera

NDTM Amarasekera

130个赞,共352个帖子。

组: 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)已下载 1327 次。

Del_Col_Row_Ex.png
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
2位用户喜欢此帖子
overlord 2021/6/3 21:45:00, sergio 2021/6/1 04:28:00
#4 已发布: 2021/6/1 11:30:22
overlord

overlord

600个赞,共1,381个帖子。

组: 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位用户喜欢此帖子
NDTM Amarasekera 2021/6/1 13:29:00
#5 已发布: 2021/6/1 12:52:21
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: 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)已下载 1346 次。
#6 已发布: 2021/6/1 13:28:36
NDTM Amarasekera

NDTM Amarasekera

130个赞,共352个帖子。

组: 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位用户喜欢此帖子
overlord 2021/6/3 21:45:00
#7 已发布: 2021/6/2 15:34:35
NDTM Amarasekera

NDTM Amarasekera

130个赞,共352个帖子。

组: 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)已下载 1313 次。

Capture.PNG
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
2位用户喜欢此帖子
overlord 2021/6/3 21:45:00, Alvaro 2021/6/2 17:53:00
#8 已发布: 2021/6/2 18:12:03
Alvaro

Alvaro

1,139个赞,共1,805个帖子。

组: 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)已下载 1286 次。

Clipboard01.jpg

Best regards.
Alvaro.
2位用户喜欢此帖子
overlord 2021/6/3 21:45:00, NDTM Amarasekera 2021/6/2 23:47:00
#9 已发布: 2021/6/2 18:35:44
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

1位用户喜欢此帖子
NDTM Amarasekera 2021/6/2 23:48:00
  • 有新帖
  • 无新帖