Tabulating the data obtained for my Matlab code
1 view (last 30 days)
Show older comments
With the code I stated below, I obtain 2 column graphic data as x and y. The data I obtained appear separately on the right. One writes as a column, the other as a row. I would like help in updating my code to create a txt or Excel file with these two data as columns from top to bottom.
The data I obtained look like this, separately, one as a column and the other as a graph. I want it to give me this data as columns in txt or excel.
I upload the data I use for the code to work as a txt file.
data = readmatrix('Naca LD0006 6R.txt');
f = fit(data(:,1), data(:,2),'smoothingspline','SmoothingParam',0.3);
xi = -15:1:18; % or -15:0.5:18 or whatever
yi = f(xi);
figure
plot(f,data(:,1),data(:,2))
hold on
plot(xi,yi,'o','MarkerFaceColor','g','DisplayName','1° intervals')
set(get(gca(),'Legend'),'Location','best');
0 Comments
Answers (1)
Star Strider
on 20 May 2024
Edited: Star Strider
on 20 May 2024
Create a table array with your variables (that I assume are ‘xi’ and ‘yi’ here) and then use writetable to save them as an Excel file. Use the colon, : operator to force both of them to be column vectors.
Try this —
data = readmatrix('Naca LD0006 6R.txt');
f = fit(data(:,1), data(:,2),'smoothingspline','SmoothingParam',0.3);
xi = -15:1:18; % or -15:0.5:18 or whatever
yi = f(xi);
figure
plot(f,data(:,1),data(:,2))
hold on
plot(xi,yi,'o','MarkerFaceColor','g','DisplayName','1° intervals')
set(get(gca(),'Legend'),'Location','best');
Result = table(xi(:), yi(:), 'VariableNames',{'xi','yi'})
writetable(Result,'xi_yi.xlsx')
Read_xi_yi = readtable('xi_yi.xlsx')
EDIT — Corrected typographical error.
EDIT — (20 May 2024 at 20:40)
Added colon operator citation and link.
.
2 Comments
Star Strider
on 21 May 2024
My pleasure!
The writetable call creates an Excel file (that I call ‘xi_yi.xlsx’, you can call it whatever you want) that you should be able to open in Excel or any application that uses Excel and allows those files.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!