MATLAB: How to plot a 3D graph which has data in the form of a 2D array with missing values

3d plotscell arrayscurve fittinginterpolation

My Data is the image attached but I am unsure how to interpolate it and then plot the graph, the curve fitting tool I think doesn't have the option to fit from an array.

Best Answer

The first row appears to be column headers, values at which the rows were created. The first column appears to be row headers, values at which the rows were created.

If the data is currently in the form of a cell array, with empty cells where the values are showing as blank, then grab https://www.mathworks.com/matlabcentral/fileexchange/4551-inpaint-nans and

mask = cellfun( @isempty, YourCell );
tempcell = YourCell;
tempcell(mask) = {NaN};
as_array = cell2mat(tempcell);
col_headers = as_array(1,2:end);
row_headers = as_array(2:end,1);
interpolated_data = inpaint_nans(as_array(2:end,2:end));

After that you can, for example,

surf(col_headers, row_headers, interpolated_data, 'edgecolor', 'none');  %notice row vs col order

Related Solutions

MATLAB: How to remove NaN in rows and columns of excel data set in matlab

You can use isnan() to identify nan locations and then build a cell array with nulls there. If m is your matrix (untested code):

[rows, columns] = size(m);
nanLocations = isnan(m);
ca = cell(rows, columns); % Initialize cell array.
for row = 1 : rows
    for col = 1 : columns
        if ~nanLocations(row, col)
            ca{row, col} = m(row, col); % Only fill cell if it's not nan.
        end
    end
end
xlswrite(filename, ca);

MATLAB: How to use XLSWRITE to add row and column labels to the MATLAB matrix when I write it to Excel in MATLAB 7.3 (R2006b)

The following examples illustrate how to use XLSWRITE to add column and row labels to a MATLAB matrix that is written to an Excel file. This can be done either by writing to several sections of the worksheet (Case 1), or by joining the data and labels before writing to the XLS-file (Case 2).

Case 1. Using several XLSWRITE commands:

data=ones(10,4);      %Sample 2-dimensional data

col_header={'Temperature','Pressure','X','Y'};     %Row cell array (for column labels)

row_header(1:10,1)={'Time'};     %Column cell array (for row labels)

xlswrite('My_file.xls',data,'Sheet1','B2');     %Write data
xlswrite('My_file.xls',col_header,'Sheet1','B1');     %Write column header
xlswrite('My_file.xls',row_header,'Sheet1','A2');      %Write row header

Case 2. Using one XLSWRITE command:

data=ones(10,4);     %Sample 2-dimensional data
data_cells=num2cell(data);     %Convert data to cell array
col_header={'Temperature','Pressure','X','Y'};     %Row cell array (for column labels)
row_header(1:10,1)={'Time'};     %Column cell array (for row labels)
output_matrix=[{' '} col_header; row_header data_cells];     %Join cell arrays
xlswrite('My_file.xls',output_matrix);     %Write data and both headers

Best Answer

Related Solutions

MATLAB: How to remove NaN in rows and columns of excel data set in matlab

MATLAB: How to use XLSWRITE to add row and column labels to the MATLAB matrix when I write it to Excel in MATLAB 7.3 (R2006b)

Related Question