| Author |
 Topic  |
|
|
dominik.mierzwa
Poland
118 Posts |
 Posted - 02/06/2021 : 1:41:07 PM
|
Origin Ver. and Service Release (Select Help-->About Origin): 2021
Operating System: W10 pro
Hi,
I would like to ask how to create a bar chart from the data of ANOVA. I would like to create a column/bar chart with Factor as X, Mean as Y, SD or SE as an error, and mean comparison letter as a label.
I know that I can aggregate these data in one sheet (linked with ANOVA report) and create a chart, but maybe there is a more convenient method that can be applied for any new ANVOA analysis?
Kind regards,
Dominik |
|
|
easwar
USA
1964 Posts |
Posted - 02/06/2021 : 2:13:36 PM
|
Hi Dominik,
Please try this free App:
https://www.originlab.com/fileExchange/details.aspx?fid=390
You can also install from within Origin by pressing F10 to open the App Center, then click the Search tab on the left, then search for:
Paired Comparison
and download the App.
Easwar
OriginLab
|
 |
|
|
dominik.mierzwa
Poland
118 Posts |
Posted - 02/06/2021 : 4:41:16 PM
|
quote:
Originally posted by easwar
Hi Dominik,
Please try this free App:
Dear Easwar,
Thank you. I will try this app. Can I Ask you one more questions, is it possibile to work with text formulas like im Excel eg. =A-left(A,6)$
Col A contains string.
Kind regards,
Dominik |
|
|
|
cpyang
USA
1406 Posts |
Posted - 02/07/2021 : 10:20:22 PM
|
Maybe you can show an image of what col(A) string looks like so we can suggest a formula?
CP
|
|
|
|
dominik.mierzwa
Poland
118 Posts |
Posted - 02/09/2021 : 01:31:07 AM
|
quote:
Originally posted by cpyang
Maybe you can show an image of what col(A) string looks like so we can suggest a formula?
CP
Sure, Col(D) is a source, and Col(E) is an extracted text.
Kind regards,
Dominik |
|
|
|
cpyang
USA
1406 Posts |
Posted - 02/09/2021 : 02:51:50 AM
|
Since the string is a fixed format, then it can just be
Mid(D,8,5)
Like
The $ at the end for string function can be omitted for column formula, while needed if using in LabTalk scripts.
CP
|
|
|
|
dominik.mierzwa
Poland
118 Posts |
Posted - 02/09/2021 : 03:19:16 AM
|
quote:
Originally posted by cpyang
Since the string is a fixed format, then it can just be be
Mid(D,8,5)
CP
Unfortunately, there are unique stringi such as 210208-VI_300. Thus I considered text functions duch as left and right.
Kind regards,
Dominik |
|
|
|
Castiel
343 Posts |
Posted - 02/09/2021 : 05:32:13 AM
|
quote:
Originally posted by dominik.mierzwa
quote:
Originally posted by cpyang
Since the string is a fixed format, then it can just be be
Mid(D,8,5)
CP
Unfortunately, there are unique stringi such as 210208-VI_300. Thus I considered text functions duch as left and right.
Kind regards,
Dominik
Regex is perfect for such tasks. In Set Values dialog
import re
def extract(texts):
prog = re.compile(r'\d+-(?P<model>([^_]+))')
results = [prog.match(text) for text in texts]
return [result['model'] if result else '' for result in results]
------------------------------------------
Be The Change
You Want To See
In The World
------------------------------------------
|
|
|
|
dominik.mierzwa
Poland
118 Posts |
Posted - 02/10/2021 : 12:54:57 PM
|
quote:
Originally posted by Castiel
Regex is perfect for such tasks. In Set Values dialog
Hi Castiel!
Great! You really encouraged me to get familiar with python. Could you explain to me how the code works? Or please give me some references.
Kind regards,
Dominik |
|
|
|
Castiel
343 Posts |
Posted - 02/10/2021 : 5:40:19 PM
|
quote:
Originally posted by dominik.mierzwa
quote:
Originally posted by Castiel
Regex is perfect for such tasks. In Set Values dialog
Hi Castiel!
Great! You really encouraged me to get familiar with python. Could you explain to me how the code works? Or please give me some references.
Kind regards,
Dominik
https://docs.python.org/3/howto/regex.html
------------------------------------------
Be The Change
You Want To See
In The World
------------------------------------------
|
|
|
|
dominik.mierzwa
Poland
118 Posts |
|
| |
Topic |
|
Charting of ANOVA results