Clear Filters
Clear Filters

Why are the matrix numbers changing while converting table to matrix?

7 views (last 30 days)
I have a table named "tres_big" of size (324 x 65). It's a time series dataset. I wanted it to convert to a matrix without the "Date" column so I removed that first. But when I applied the "table2array" function, the elements of the several columns changed to 0.
% removes the "Date" column from "tres_big"
tresc_big= removevars(tres_big,{'Date'});
% convert into matrix
data_big = table2array(tresc_big);
This is the original table:
This is what happens after I convert into matrix
What can I do to fix the problem? I would like to have the original numbers as in the table. I would appreciate any help.

Accepted Answer

Cris LaPierre
Cris LaPierre on 20 Dec 2020
They are not changing, but you must have some large numbers in your data. When you convert the table to a matrix, it expresses all the numbers using the same format. Note the multiplier under data_big ( x). This means everything is you matrix is times 100,000. This causes your smaller values to not have anything but zeros appear in the display, though the values are still there.
You can modify the command window output display with the format function. See the format options here.

More Answers (0)

Categories

Find more on Tables 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!