How to specify the column headers while reading in a CSV file using 'readtable'?
51 次查看(过去 30 天)
显示 更早的评论
MathWorks Support Team
2019-7-25
编辑: MathWorks Support Team
2024-8-29
I am reading in a CSV file using 'readtable', but I have my column headers in row 4 of the CSV file. How do I specify the column headers?
采纳的回答
MathWorks Support Team
2024-7-29
编辑:MathWorks Support Team
2024-8-29
The 'VariableNamesLine' property can be used to specify this. Please refer to the example snippet below.
%Import the options of the csv file
opts=detectImportOptions('sample.csv');
%Defines the row location of channel variable name
opts.VariableNamesLine = 4;
%Specifies that the data is comma seperated
opts.Delimiter =','; %Specifies that the data is comma seperated
%Read the table
t = readtable('sample.csv',opts, 'ReadVariableNames', true);
The properties 'VariableNamesRange' and 'VariableNamesLine' can be specified only if the 'ReadVariableNames' argument is set to 'true'.
Refer to the second subsection of 'Name-Value Pair Arguments' to learn more. To access release specific documentation in MATLAB R2019a, please run the following command in the MATLAB command window:
>> web(fullfile(docroot, 'matlab/ref/readtable.html'))
Please follow the below link to search for the required information regarding the current release:
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!