| Author |
 Topic  |
|
|
cheynitz
Germany
31 Posts |
 Posted - 02/16/2023 : 03:28:51 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): Pro 2021b
Operating System: Win10
Hi everyone,
i am struggling with structuring and labeling my data to folders, books, sheets and columns in a way that is easy accessible for plotting & fitting.
1.) I have about 60 time series of temperatures designated to process times T(t) each consisting of 6 individual time stamps
2.) These measurements were taken by varying two parameters, pressure p (5x) and pH (10x) values
3.) Some experiments have been repeated two or three times
4.) The time stamps are written down manually, the corresponding temperature data can be copied and pasted from an excel table
5.) All single experiments are labeld with an individual running parameter V1-V60
What would you suggest as the most elegant & clear way to structure the data and name books, sheets, columns to account for repeated experiments and especially plotting the time series, comparing same pressure levels p or pH Levels. Sequential fitting of the time series should also be good accessible.
Thank you very much
PS: One might think, that such a question should be answered by the classical tutorial videos etc but unfortunatelly they all rely on very lean and minimal data examples to make a certain point |
|
|
AmandaLu
439 Posts |
Posted - 02/16/2023 : 05:21:18 AM
|
Hi,
How to arrange the data must be determined by yourself. Maybe you can try something like following:
Then you can use Worksheet: Split Worksheet to split this source datasets to several sheets by different P or pH levels for the follow-up analysis or plotting purpose.
https://www.originlab.com/doc/Origin-Help/split-wks-into-sheets?f=dl
Thanks,
Amanda
OriginLab Technical Service
|
 |
|
|
cheynitz
Germany
31 Posts |
Posted - 02/16/2023 : 05:47:54 AM
|
Hi Amanda,
thank you very much for you great and quick advice!
The only challenge left is to keep the connection between time (x) and temperature (y) during the splitting process. I could fill the time columns with the same P and pH values upfront, so that they are carried along. Or is there a more elegant way? The splitting dialog has no feature for this pair-conservation.
Kind regards |
|
|
|
AmandaLu
439 Posts |
Posted - 02/22/2023 : 9:24:56 PM
|
Hi,
What do you mean by “keep the connection between time (x) and temperature (y) during the splitting process”? Can you give me an example?
Thanks,
Amanda
OriginLab Technical Service
|
|
|
|
cheynitz
Germany
31 Posts |
Posted - 02/23/2023 : 10:27:14 AM
|
Hi Amanda,
i meant that when using the splitting option, based on a sheet similar to your example the time and their corresponding temperature columns will be separated, since the tim columns do not have the "P" and "pH" values in their respectives rows.
Unfortunatell i dind´t find a splitting option to keep x(time) and y(temperature) as neighboured columsn during splitting operation.
Kind regards
Christian |
|
|
|
snowli
USA
1417 Posts |
Posted - 02/24/2023 : 11:30:33 AM
|
Hi Christian,
You don't have to split worksheet to do further analysis and graphing.
e.g.
1. U can use Edit: Edit to easily select columns with same p Value or pH value, etc. and plot do analysis. Corresponding X will be used automatically.
2. U can use Plot: Browse: Color line or Back Lines, etc. to plot them and on the left panel, show p Value, ph value columns and sort by them and choose which columns to show to compare them.
3. With nothing selected in worksheet, u can also choose regular plot type, e.g. line, scatter, etc.. Plot Setup dialog will open which supports sorting in middle panel to pick related columns.
4. We also have Plot: Multi-panel/Axis: Multiple Panels by ... where u can specify label row to use as group information to plot multi-panel graphs so plots with same group info. will be plotted in same panel.
etc.
Thanks, Snow |
|
|
|
aplotnikov
Germany
169 Posts |
Posted - 02/24/2023 : 6:36:52 PM
|
Hi cheynitz,
seems - taking into account a small number of points in each experiment - you can use an alternative table structure as well. You can organize your data in two tables: one contains ALL time series with the corresponding expereiment-IDs/repetition number values, the other contains the information on experiments (id, label, parameters, number of repetitions). You can use column filtering to select the data to process. Filtering is fast and can be easily implemented programmatically.
I cannot estimate which approach is more efficient in your particular case.
Regards,
Alexei |
Edited by - aplotnikov on 02/24/2023 6:38:27 PM |
|
|
|
cheynitz
Germany
31 Posts |
Posted - 03/02/2023 : 05:25:02 AM
|
Dear Snow and Alexei,
thank you very much for your helpful approaches!
Greetings
Christian |
|
|
| |
Topic |
|
Organizing Data & varying Parameters