MATLAB: How to sort big data into text file by writing

sorttext filewritetable

I have big data. Table of text file is 3,496,000 rows x 6 columns.

ionex = sortrows(ionex, {'Year','DoY','Hour','Lat','Long','TEC'},'ascend');

I didn't write data to text file. I got error as follows:

"Error using writetable
"Too many output arguments.

Best Answer

Do not try to assign the result of writetable() to anything. writetable() does not have any output parameters.

Related Solutions

MATLAB: How to extract and then write data in certain order from other excel files to excel file

[~, sheets] = xlsfinfo('Data.xlsx');  %get list of sheets
lattables = cell(size(sheets));      %preallocate cell array of table
for sh = 1:numel(sheets)
    latitude = sscanf(strrep(sheets{sh}, '_', '.'), 'Lat%f');  %extract latitude from sheet name (replace _ by . so that Lat is followed by an actual number
    lattables{sh} = readtable('Data.xlsx', 'Sheet', sheets{sh});   %read sheet
    lattables{sh}.Latitude = repmat(latitude, height(lattables{sh}), 1); %append latitude column (all identical for the current table)    
end
fulltable = vertcat(lattables{:});  %once all are loaded, concatenate into a single table
fulltable = stack(fulltable, 4:8, 'ConstantVariables', [1:3, 9], 'NewDataVariableName', 'TEC', 'IndexVariableName', 'Longitude');
fulltable.Longitude = sscanf(strrep(strjoin(cellstr(fulltable.Longitude)), '_', '.'), 'Long%f ')

MATLAB: Sorting

Use the sortrows() function instead.

Best Answer

Related Solutions

MATLAB: How to extract and then write data in certain order from other excel files to excel file

MATLAB: Sorting

Related Question