data.table equivalent in matlab

Hi everybody,
I am coming from R and used the data.table package a lot to filter, group, and aggregate large datasets. Is there an equivalent in Matlab?
Best,

2 个评论

"large datasets" how large are these datasets compared to the physical memory of the computer?
The datasets usually are between 12-14 gb, so they usually fit in the memory.

请先登录,再进行评论。

 采纳的回答

Luna
Luna 2019-3-15

0 个投票

Hello,
Have you ever checked table and datastore? You can look at below links and their relevant properties and methods in documentation:

4 个评论

Hi Luna,
Thank you for your answer. I know table (and functions like varfun) but I found them to be much slower than data.table from R. The data.table package in R works a bit like SQL, by using primary keys to quickly access large dataframes/tables. It also allows things like rolling joins etc. Is there an equivalent in matlab?
Luna
Luna 2019-3-18
编辑:Luna 2019-3-18
You should check datastore and databasedatastore I can recommend you. (if you are working with large tables)
I am sure you can find what functions you need with a little bit research on that. Also you can overview tall arrays, too.
note: Primary keys are also exist in tables in Matlab, too.
Join Tables (check innerjoin and outerjoin functions, too)
Please don't forget to look at See Also section on the bottom of the pages. There are useful functions and topics in there.
note2: if you want to access a specific data in your table, use logical indexing instead of cellfun arrayfun or varfun. It will be way much faster. You should read Loren's article in here:
Thank you very much! Your answer helps me a lot!
I will do research on the links you send me.
Your welcome :)

请先登录,再进行评论。

更多回答(0 个)

类别

帮助中心File Exchange 中查找有关 Tables 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by