How to read and work with a large Excel file in MATLAB?
1 次查看(过去 30 天)
显示 更早的评论
MathWorks Support Team
2018-7-24
回答: MathWorks Support Team
2018-8-16
I have huge data saved on a single Excel csv file (approximatly 90 GB). I would like to know how can I read the data from this file. And, what is the maximum file size (csv file) that I can work with?
采纳的回答
MathWorks Support Team
2018-7-24
In general, the amount of data that can be loaded into memory depends on your machine's RAM.
To workaround the memory limitation, MATLAB has a feature called 'datastore'. This feature allows you to read and process your data without loading everything into memory at once.
You can refer to the "tabularTextDatastore" to learn more about 'datastore' for CSV file:
You can also refer to the following documentation for a more general overview about our 'datastore' feature:
Additionally, if your workflow also demands manipulating the data as array after you import them as 'datastore', you can leverage another feature called Tall array:
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!