Read string and numeric array in CSV file
1 次查看(过去 30 天)
显示 更早的评论
Hello,
I am trying to automatize the post-processing of csv files such as the one enclosed here.
I want to extract :
- the value of Hresolution
- the four columns of data
I have tried to use readtable but I can not figure out which options to select.
Thanks for your help
0 个评论
回答(1 个)
Cris LaPierre
2022-7-25
If you save your file as a 'xlsx' file, you could take advantage of the 'Range' option in readtable.
Without it, you may have to be a little more creative. The approach I took was to disable a lot of the autodetection readtable uses. This approach means your files must all have the same format. Some of the 'header' values look incorrect because this approach treats them all as numeric values. Those that aren't get read in as NaN.
file = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/1076420/LDB100B.CSV';
data = readtable(file,'ReadRowNames',true,'ExpectedNumVariables',5,'PartialFieldRule','fill','numheaderlines',0)
hRes = data{'HResolution',1}
vals = data{(data{'Header Size',1}+1):end,:}
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!