MATLAB: How to specify the column headers while reading in a CSV file using ‘readtable’

MATLAB

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?

Best Answer

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);
As mentioned in the link below, 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.
https://www.mathworks.com/help/releases/R2019a/matlab/ref/readtable.html
Related Question