Can / how to use the function readtable to load mixed data from a .csv file, but only pull certain rows?
1 view (last 30 days)
Show older comments
Here is the code that I have that works, but its a bit clunky in that there are 68 columns of data and 8760 rows. It would be nice to only load the columns needed directly without having to convert the .csv files to .xls as my installation says it doesn't support .csv as a compatible excel file type. (probably because I'm using a mac with excel for mac 2008 on it.) The end goal is to not waste memory and loading time as this will be done with a list of 1020 files in the stations cell array. A secondary goal is to write code that is easily portable across all platforms not just windows.
T=readtable(stations{1},'HeaderLines',1);
T=T(:,[1 2 5 8 11 32 41 62]);
0 Comments
Answers (0)
See Also
Categories
Find more on Spreadsheets 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!