Importing data from a large CSV file based on a particular criteria
3 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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
2 Commenti
Konrad
il 12 Gen 2022
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.
Risposte (0)
Vedere anche
Categorie
Scopri di più su Standard File Formats in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!