Importing data from a large CSV file based on a particular criteria

3 次查看（过去 30 天）

Ashish Kulkarni 2022-1-12

评论： Konrad 2022-1-12

Hi Everyone!

Can u tell how to import data from an excel sheet based on conditions while using importdata.

My problem is the file size is too big for import. If I use entire selection, my laptop runs out of memory.

Or whenI load the data using import function, how do I filter it based on a condition and then import it as a table or matrix?

The structure of my file is as follows, I want rows related to a particular date only to be imported.

ID_frame TimeStamp MAC ID RSSI Vendor cod sync DeviceID

1 23-05-2019 12:34 e6aa4f2224ee98e98 -78 Unknown SmartPhone 0 1.91E+13

2 23-05-2019 12:34 f7af897c07bf765a9 -90 Unknown SmartPhone 0 1.91E+13

3 23-05-2019 12:35 e6aa4f2224ee98e98 -69 Unknown SmartPhone 0 1.91E+13

4 23-05-2019 12:35 f7af897c07bf765a9 -88 Unknown SmartPhone 0 1.91E+13

5 23-05-2019 12:36 24cb3474f61a53bac -89 Bluegiga Technologies OY Uncategorized 0 1.91E+13

6 23-05-2019 12:36 e6aa4f2224ee98e98 -85 Unknown SmartPhone 0 1.91E+13

Ankit 2022-1-12

Konrad 2022-1-12

Hi,

would saving the excel sheet as a csv file be an option? Then you could open the file with fopen(), read line by line and keep only matching lines.

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

R2015a

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

Translated by