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

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?

Answer 1

[MathWorks Support Team]

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:

https://www.mathworks.com/help/