Convert scientific notation in table

Question

Konvictus177 2022-1-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1636090-convert-scientific-notation-in-table

回答： Rahul 2024-10-11

Hi,

I create a table that looks like this:

How can I get rid of the scientifc notation in the last two columns? I want to create uitable using the struct or trable above.

Thanks.

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Benjamin Thompson 2022-1-25

Is this a table in Excel? If you import a text file into MATLAB, formatting does not matter because you can choose the display format later on. Can you post code or sample data?

See the article on uitable in the MATLAB documentation or "Table Properties" for how to use the uitable ColumnFormat property to control the display.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Rahul 2024-10-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1636090-convert-scientific-notation-in-table#answer_1530725

在 MATLAB Online 中打开

Hi @Konvictus177,

I understand that you wish to adjust the notation of the data in your table. Considering you have obtained the table in your MATLAB workspace using the 'readtable' function. You can use the 'convertvars' function to adjust the data type of the desired columns according to your specifications.

Here is an example:

T1 = readtable('yourTableName.csv');
T2 = convertvars(T1,{'columnNameToChange'},'single');
% Here I have used random file and column names, you can adjust that accordingly.
% I have converted the data type of the column to 'single', however
% conversion to 'double', 'int8', 'int16', 'int32'	and many more are possible