[Data manipulation ]A best set of functions to solve this issue.

Hello everyone,

I am trying to draw a plot with a curve that has two components: (1) mean (thicker colored-lines) (2) standard deviation (shades), as seen below

For that, multiple y-axis data points are required for each certain x-value (here, Extension). It would be very straightforward if the n-th row has the "nearly" same x-value on each run. The excel lmage below is the collection of x-axis values for each run, and apparently in the same row the value does not match. Then it is challenging to obtain corresponding "averaged" y-axis value.

I am wondering if you have good solutions to the issue.

Thank you.

[Cheeesepondue]

I tried Get or findobj functions. but these functions just retrieve data from fig. file only extracts the "same" number of input data for drawing the figure.

[Rik]

What is your actual question? Do you have the source data and want to make the plot, or do you have the plot and want to extract the source data?

[Cheeesepondue]

@Rik Wisselink Sorry for the confusion. Eventually, I need to draw a plot like that. For that, I need to obtain processed data - averaged y-values at each x-value - from raw data.

The problem with the source data (or raw data) is that even though each test ran for 12 (sec), the length of data (the number of rows per each column; each column represents a different specimen) is different. So what I want is that somehow reprocess all the raw data to have the same length (e.g., Make all the data end at 230th-row of each column with the end value ~12). I tried to retrieve data from fig. files drawn with the raw data using get or findobj functions, but the problem is that I get back the same Xdata/Ydata. I need to truncate or micro-adjust the difference between each value to have the same number of rows for all specimens.

Thank you.

[Rik]

Why not directly calculate the mean and standard deviation from the actual data-points? That way you don't need to throw out or invent data.

[Cheeesepondue]

@Rik Wisselink I don't think I can. n-th mean/STDEV values will be calculated from n-th row data from each column. The problem is that x-values (in the excel image) are not (approximately) equal in the n-th row of column. (e.g.,210-th row, the x-value ranges from 8.99 to 11.938)

Updates: Interpolation did the job!