How to properly import a dataset including characters and numbers?

Question

Samuel 2017-1-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322773-how-to-properly-import-a-dataset-including-characters-and-numbers

编辑： Samuel 2017-2-2

Hello all, I am in the process of importing an xls based data input file. The data has several columns- some of them include an exponential digit, expressed with an "e". A sample of the dataset is shown below:

.49 .159 5.16e-04 7.42e+02 .155

.. etc

I tend to use the "import data" function, and automatically had it generate a script. However, upon seeing the e and + characters, matlab imports that column to be a cell via the cellvectors() command.

As a result I have a combination of data() files and cellvectors() files- with these data types, I unfortunately cannot plot all of the data output together.

Can anybody help me in a way to enable the data importing so it can properly handle exponential files? (Or if there is no other way, is there a way to "convert" the cell file with the characters as a float number that can be plotted with the other number values?)

Thanks in advance for the help.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Samuel 2017-2-2

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/322773-how-to-properly-import-a-dataset-including-characters-and-numbers#answer_253075

编辑：Samuel 2017-2-2

I was able to find the solution- in the import data option, I can click on the column selection and click on the data type it needs to be imported to- for the ones that says "cell", I can make it be a number, and clicking on "apply to selection" applies to every part that needs to be changed.

I am not sure if I am allowed to "accept" my own answer, but Just an fyi to the future people that might be interested. feel free to leave a comment if anybody needs more help.