Get data out of figure file to combine with other dataset

Hi

I am new to Matlab

I want to get data out of .Fig file and then combine the data from .Fig file with data from spreadsheet to make a combined plot

I have large scale data 3600000 linies, but to make it simple. I have attachted a small .Fig file and a small spreadsheet.

Please help me to understand the steps I have to follow to combine the data.

[Walter Roberson]

It is possible to extract the line objects from the figure, and it is possible to examine their DisplayName property and match the names against the variables in the table.

However it is not clear what it means to you to "combine" the data. The data in your line objects appears to be identical to the data in your xlsx file.

Do you want to construct x y rows from the existing data and from the time and corresponding xlsx column, and union() by rows, and then draw the resulting lines? Do you want to draw the xlsx data on the end of the existing line? Something else?

[Steen]

My bad. The data are the same. I have attached new files. I have also added a visual process of the data treatment.

The reason way. I have two different input data, are because I have two different meassurement equipment attached the meassure my system ( one meassurement cant meassure all data)

[Walter Roberson]

It isn't clear why you are not just doing

figfile = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/1156208/Fig%20import%20test%20rev1.fig';
datafile = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/1156213/Values%20to%20combine%20with%20Fig.xlsx';
tempfile = tempname() + ".fig";

fig = openfig(websave(tempfile, figfile));
T = readtable(datafile);
hold on
t = T.time;
P = T.Properties.VariableNames(2:end);
for K = 1 : length(P)
    fn = P{K};
    plot(t, T.(fn), 'DisplayName', fn);
end
hold off

set(gcf, 'visible', 'on')
legend show

Answer 1

[Walter Roberson]

The websave layer is there in order to permit me to reference the .fig file you attached. For local use,

figfile = 'Fig import test rev1.fig';
datafile = 'Values to combine Fig.xlsx';
fig = openfig(figfile);
T = readtable(datafile);
hold on
t = T.time;
P = T.Properties.VariableNames(2:end);
for K = 1 : length(P)
    fn = P{K};
    plot(t, T.(fn), 'DisplayName', fn);
end
hold off
set(gcf, 'visible', 'on')
legend show

[Steen]

WOW. Thats great.

I tried to use my local files, But gets a error on the Websave. See below

figfile = 'Fig import test rev1.fig';
datafile = 'Values to combine Fig.xlsx';
tempfile = tempname() + ".fig";
fig = openfig(websave(tempfile, figfile));

Error using websave
The '' protocol specified in URL, 'Fig%20import%20test%20rev1.fig', is not supported. Specify the URL with the protocol 'http://' or 'https://'.

T = readtable(datafile);
hold on
t = T.time;
P = T.Properties.VariableNames(2:end);
for K = 1 : length(P)
    fn = P{K};
    plot(t, T.(fn), 'DisplayName', fn);
end
hold off
set(gcf, 'visible', 'on')
legend show

[Steen]

Great thanks

Can I also import data from .TXT file. ( se structure below). ?

Is it possible to make a offset on the values that I import from xlsx/txt. I have a offset on 5,5 sec between the .fig and the .txt file?

"COMMENT","8861-50 REAL DATA"

"DATE","10-24-2022"

"TIME","09:44:09.370"

"NUM_SIGS",3

"INTERVAL",2.00000E-003

"HORZ_UNITS","s"

"VERT_UNITS","s","V","V"

"SIGNAL","TIME","VFD DC IN V","VFD AC OUT V"

"DATA"

+0.000000000E+000,+5.36000E+002,+5.65000E+002

+2.000000000E-003,+5.35000E+002,+5.54000E+002

+4.000000000E-003,+5.35000E+002,+5.28000E+002

+6.000000000E-003,+5.33000E+002,+4.99000E+002

+8.000000000E-003,+5.45000E+002,-3.30000E+001

+1.000000000E-002,+5.41000E+002,-3.50000E+001

+1.200000000E-002,+5.41000E+002,-1.80000E+001

+1.400000000E-002,+5.42000E+002,-5.13000E+002

+1.600000000E-002,+5.38000E+002,+2.80000E+001

+1.800000000E-002,+5.32000E+002,-4.83000E+002

+2.000000000E-002,+5.39000E+002,+4.20000E+001

+2.200000000E-002,+5.33000E+002,+5.28000E+002

+2.400000000E-002,+5.37000E+002,+5.22000E+002

+2.600000000E-002,+5.40000E+002,-1.80000E+001

+2.800000000E-002,+5.32000E+002,-2.90000E+001

+3.000000000E-002,+5.33000E+002,-3.40000E+001

+3.200000000E-002,+5.41000E+002,-2.00000E+001

+3.400000000E-002,+5.35000E+002,+0.00000E+000

+3.600000000E-002,+5.31000E+002,+2.50000E+001

+3.800000000E-002,+5.40000E+002,+4.20000E+001

+4.000000000E-002,+5.29000E+002,+3.70000E+001

+4.200000000E-002,+5.37000E+002,+3.00000E+001

[Walter Roberson]

For that file, change

T = readtable(datafile);

to

T = readtable(datafile, 'VariableNames', ["time","VFD DC IN V","VFD AC OUT V"]);

after having changed datafile to refer to the text file.

[Steen]

Hi Walter

I had succes today. But I had to modify you code. And also remove .txt filer header

Remove header

Original header

If I used your code

figfile = 'IBox 100-100 - Copy.fig';
datafile = 'Copy_of_V164_Backup_KK_Con_Test1_Step1_100_100_Rev1_short version_rev5.txt';
fig = openfig(figfile);
T = readtable(datafile, 'VariableNames', ["TIME","VFD DC IN V","VFD AC OUT V"]);
hold on
t = T.time;
P = T.Properties.VariableNames(2:end);
for K = 1 : length(P)
    fn = P{K};
    plot(t, T.(fn), 'DisplayName', fn);
end
hold off
set(gcf, 'visible', 'on')
legend show

I get this error

>> clear
>> extract_data_from_figures_13
Error using readtable
Ambiguous parameter name: VariableNames.

Error in extract_data_from_figures_13 (line 4)
T = readtable(datafile, 'VariableNames', ["TIME","VFD DC IN V","VFD AC OUT V"]);

But if I change

T = readtable(datafile, 'VariableNames', ["TIME","VFD DC IN V","VFD AC OUT V"]);

to

T = readtable(datafile,'Format','auto');

it works fine

Can you advice me if the code change are ok and how to get the code to ignore the heater

[Walter Roberson]

T = readtable(datafile);
T.Properties.VariableNames = ["TIME","VFD DC IN V","VFD AC OUT V"];

and you will need to change

t = T.time;

to

t = T.TIME;