| T O P I C R E V I E W |
| metroid02 |
Posted - 08/09/2017 : 04:11:48 AM
Origin Version: OriginPro 2017
OS: Windows 10
Hey everyone I have a problem that I am not quite sure how to solve:
I have two data sets that range from the years 2015-2017. Both sets of Data roughly come in the following format:
1/1/2015 00:00
1/1/2015 00:05
etc
My problem is that one of these data sets is not entirely complete (column B) where I am missing days worth of data. This means that when I align the values they do not match up at all which makes any further analysis pointless.
Now my question is, is there a way to sort these values in such a way that if a value from column A does not match column B it looks for teh corresponding value in B, and if it does not exist in B then it just returns an empty string? |
| 3 L A T E S T R E P L I E S (Newest First) |
| metroid02 |
Posted - 08/14/2017 : 08:22:32 AM
First of all, thanks for replying.
That looks like it could work wonderfully, though I have run into another problem that for some arbitrary reason Origin decides that when I convert the data I have into Dates (format 14/7/2017 HH:mm) it cannot comprehend some of the dates despite them having that exact format.... so while Id like to check this method I first need to solve this little conundrum. |
| snowli |
Posted - 08/10/2017 : 2:30:18 PM
Could you check if this helps.
1. Put Dataset 1's X and Y into column A and B.
2. Put the X(Time) of dataset 2 (incomplete) in column C.
3. Add new column D. And enter table(A, B, C) in column D's F(x) cell.
It will search times in column C and find the matching rows and put corresponding row's B values into D.
Thanks, Snow |
| metroid02 |
Posted - 08/09/2017 : 04:44:39 AM
Alternatively, would it be possible that I just put my two data sets in two different books and create a third book that "combines" the Y values of these two sets for equal X values?
Here is how the data looks:
Data Set 1:
X: Time (as shown above)
Y: Global irradiation values
Data Set 2
x: Time (same as in Data Set 1 just incomplete)
Y: corresponding measured power and voltage values. |
