Advantage of vectorize function

Advantage of vectorize function - Data Analysis Using Truth Tables - Сообщения

#1 Опубликовано: 06.07.2019 02:51:39
NDTM Amarasekera

NDTM Amarasekera

130 сообщений из 352 понравились пользователям.

Группа: User

On the request of a fellow Engineer, the attached SM program was developed
to find the Standardized Precipitation Index (SPI).
58 years of daily precipitation data was available.

The SPI is widely used to analyze meteorological drought on a range of
time scales. There are proprietary software packages for this purpose.

The “vectorize” function was pretty handy and fast in analyzing various conditions.

Vectorize function.png

SPI_cal-Rev & Improved-Final.sm (1 МиБ) скачан 161 раз(а).
Rainfal_Data.xlsx (486 КиБ) скачан 116 раз(а).
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
3 пользователям понравился этот пост
Radovan Omorjan 06.07.2019 04:23:00, frapuano 06.07.2019 05:13:00, Davide Carpi 06.07.2019 11:20:00
#2 Опубликовано: 19.09.2019 12:23:07
NDTM Amarasekera

NDTM Amarasekera

130 сообщений из 352 понравились пользователям.

Группа: User

Attached file may be useful in handling data, where it may be
necessary to extract numerical values removing any strings, or
negative values, zeros etc.

Data Analysis Using Truth Table.sm (78 КиБ) скачан 89 раз(а).

DataAnalysis_Results.png

DataAnalysis_Cond.png
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
#3 Опубликовано: 19.09.2019 12:44:46
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

Wrote

Attached file may be useful in handling data, where it may be
necessary to extract numerical values removing any strings, or
negative values, zeros etc.


Maybe more or otherwise in there.

Utilities Matrix Truth Table.sm (59 КиБ) скачан 98 раз(а).
Utilities Matrix Truth Table [UNSORTED alyles].sm (15 КиБ) скачан 89 раз(а).
Utilities Matrix Truth Table [Locate row_col].sm (43 КиБ) скачан 94 раз(а).
#4 Опубликовано: 13.04.2020 13:20:47
NDTM Amarasekera

NDTM Amarasekera

130 сообщений из 352 понравились пользователям.

Группа: User

Advantage of vectorize function revisited.
Another practical example attached, with extensive use of the vectorize function. No loops used.
Comments by Martin, Jean, Razonar and others on this subject much appreciated.
Hope this may be useful for beginners.
Cheers

Vect_Augment.PNG
SPI_cal-Millawana_Multiple_R5.sm (178 КиБ) скачан 89 раз(а).
rainfall_KalaOyaBAsin.xlsx (585 КиБ) скачан 63 раз(а).
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
#5 Опубликовано: 13.04.2020 13:47:05
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

Wrote

Comments by Martin, Jean, Razonar and others on this subject much appreciated.


Sorry mon Ami ... SS 6179 does not open ... Jean
#6 Опубликовано: 13.04.2020 14:04:20
NDTM Amarasekera

NDTM Amarasekera

130 сообщений из 352 понравились пользователям.

Группа: User

Sorry. PDF attached.

SPI_cal-Millawana_Multiple_R5.pdf (1 МиБ) скачан 108 раз(а).
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
2 пользователям понравился этот пост
Davide Carpi 14.04.2020 09:24:00, frapuano 14.04.2020 11:57:00
#7 Опубликовано: 14.04.2020 09:04:19
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

Thanks for the *.PDF ... superb quality !
#8 Опубликовано: 12.11.2020 03:56:59
NDTM Amarasekera

NDTM Amarasekera

130 сообщений из 352 понравились пользователям.

Группа: User

I have found this useful in day to day work.
Data imported from MS Excel sheet, and using "findrows" function to sum daily data to monthly totals.

Vect_Grouping.png
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
1 пользователям понравился этот пост
sergio 12.11.2020 05:23:00
#9 Опубликовано: 16.11.2020 14:13:48
NDTM Amarasekera

NDTM Amarasekera

130 сообщений из 352 понравились пользователям.

Группа: User

Attached is a simplified version of a project work for demonstration only.
The data file consists of date strings, and hence, had to be transformed into numeric.
Hope this may be useful for beginners. Vectorize function very useful in this exercise.

Handling DATE STRINGS.sm (16 КиБ) скачан 72 раз(а).

DATE_Strings.png
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
1 пользователям понравился этот пост
sergio 17.11.2020 14:39:00
#10 Опубликовано: 16.11.2020 20:48:19
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

The secret is inside your nice piece of work ... superb, thanks.
Take care my Friend ... Jean
#11 Опубликовано: 16.11.2020 23:58:06
Alvaro Diaz Falconi

Alvaro Diaz Falconi

992 сообщений из 1675 понравились пользователям.

Группа: User

Wrote

Attached is a simplified version of a project work for demonstration only.
The data file consists of date strings, and hence, had to be transformed into numeric.
Hope this may be useful for beginners. Vectorize function very useful in this exercise.



Hi. Handling data strings you have also this cheat for convert dates to numeric matrices.

Handling DATE STRINGS.sm (20 КиБ) скачан 70 раз(а).

Clipboard01.jpg

Best regards.
Alvaro.
2 пользователям понравился этот пост
sergio 17.11.2020 14:39:00, NDTM Amarasekera 17.11.2020 22:29:00
#12 Опубликовано: 17.11.2020 01:41:25
NDTM Amarasekera

NDTM Amarasekera

130 сообщений из 352 понравились пользователям.

Группа: User

Thank you Jean for your kind words and encouragements. Take care.

Thank you Razonar for the superb alternative. Take care.
Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
#13 Опубликовано: 17.11.2020 09:44:04
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

You too Alvaro: take care, thanks ... Jean
#14 Опубликовано: 02.02.2021 04:35:43
NDTM Amarasekera

NDTM Amarasekera

130 сообщений из 352 понравились пользователям.

Группа: User

Wrote

Attached is a simplified version of a project work for demonstration only.
The data file consists of date strings, and hence, had to be transformed into numeric.
Hope this may be useful for beginners. Vectorize function very useful in this exercise.

Revised program to handle date strings.

Handling DATE STRINGS+Alvaro.sm (43 КиБ) скачан 59 раз(а).
String2Num.png

Look within!... The secret is inside you. Best Regards Eng. NDTM Amarasekera - Sri Lanka
1 пользователям понравился этот пост
Alvaro Diaz Falconi 02.02.2021 15:35:00
#15 Опубликовано: 02.02.2021 11:27:50
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

Wrote

Revised program to handle date strings.


Thanks Collab for that most useful work.
Saved ... for future use.
Cheers ... Jean

#16 Опубликовано: 02.02.2021 15:44:06
Alvaro Diaz Falconi

Alvaro Diaz Falconi

992 сообщений из 1675 понравились пользователям.

Группа: User

Wrote

Attached is a simplified version of a project work for demonstration only.



Hi Amarasekera. Yes, that one, thanks. The fact you're showing despite to me about the speed in procedures with arrays. In the attached some comments about the need to redefining M:=M where M is a matrix argument in a procedure.

Clipboard01.jpg

EvalTest.sm (17 КиБ) скачан 65 раз(а).

EvalTest.pdf (73 КиБ) скачан 52 раз(а).

Best regards.
Alvaro.

1 пользователям понравился этот пост
sergio 03.02.2021 06:33:00
#17 Опубликовано: 02.02.2021 18:53:27
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

Your last Speedy Gonzalez is the Smath Numerical Fairy.
As it looks, pure numerical code coincidence as a fact.
Slightly adapted for convenience SS 6179
Thanks, cheers ... Jean

Maths eval(,) TEST.sm (16 КиБ) скачан 64 раз(а).
#18 Опубликовано: 02.02.2021 19:26:52
Ruben Sidranski

Ruben Sidranski

17 сообщений из 463 понравились пользователям.

Группа: User

Wrote

Hi Amarasekera. Yes, that one, thanks. The fact you're showing despite to me about the speed in procedures with arrays. In the attached some comments about the need to redefining M:=M where M is a matrix argument in a procedure.
Best regards.
Alvaro.


Alvaro,
Are you showing that by redefining Mo variable, within the program, it speeds it up 30 fold? That makes no sense
The only thing that remotely comes to mind is that M, being defined within the program structure as M:=Mo, is not having to read for the variable from the outside.
Have you, or anyone else, tried this on other programs?
#19 Опубликовано: 02.02.2021 19:54:30
Alvaro Diaz Falconi

Alvaro Diaz Falconi

992 сообщений из 1675 понравились пользователям.

Группа: User

Wrote


Alvaro,
Are you showing that by redefining Mo variable, within the program, it speeds it up 30 fold? That makes no sense



Yes. Please, try to check in your environment if this is true also. (Notice that my laptop is very slow, because always is running something else or overloaded by some other procedures)

Wrote


Have you, or anyone else, tried this on other programs?



Yes. For this was the issue in the original Amarasekera work, and why I say that he was the first showing this behavior. But I have other codes where using M:=M speed up slow procedures. Actually anything with a loop over a matrix.

Here intermediate timing result, which I can't explain

Clipboard01.jpg

Best regards.
#20 Опубликовано: 02.02.2021 22:13:47
Jean Giraud

Jean Giraud

983 сообщений из 6866 понравились пользователям.

Группа: User

Wrote

The only thing that remotely comes to mind is that M, being defined within the program structure as M:=Mo, is not having to read for the variable from the outside.
Have you, or anyone else, tried this on other programs?


What's wrong or incorrect in there is length it shouldn't exist in Smath

EvenFaster.PNG
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений