Importing big data from txt/excel file
4 views (last 30 days)
Show older comments
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 Comment
Wei Wang
on 21 Dec 2018
You can use the function: tall to deal with the big data. It is extremely fast.
good luck.
Answers (1)
Robert Alvarez
on 27 Mar 2017
Read your data into excel then export them as comma-separated-values (csv) then read into Matlab with csvread
0 Comments
See Also
Categories
Find more on Standard File Formats 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!