Importing big data from txt/excel file

2 次查看（过去 30 天）
Burak Dermenci
Burak Dermenci 2017-3-27
评论： Wei Wang 2018-12-21
Hi all,
I have quite large number of battery test data which contain hundreds of thousands data from each 13 columns (totally million of them). I generally convert them into txt and/or excel. However, when importing the file by using xlsread or import; it takes a few hours.
I'm looking for a more easy way to import txt or excel file in a shorter time. My purpose is to draw a 2D plot choosing any 2 columns of them.
  1 个评论
Wei Wang
Wei Wang 2018-12-21
You can use the function: tall to deal with the big data. It is extremely fast.
good luck.

请先登录，再进行评论。

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

回答（1 个）

Robert Alvarez
Robert Alvarez 2017-3-27
Read your data into excel then export them as comma-separated-values (csv) then read into Matlab with csvread

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by