How to specify the column headers while reading in a CSV file using 'readtable'?

51 次查看(过去 30 天)
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
编辑: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 个)

标签

尚未输入任何标签。

产品


版本

尚未输入任何版本。

Community Treasure Hunt

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

Start Hunting!

Translated by