readtable() custom variable names (2024)

Certain variable names can cause a nuissance warning that clutters the command window. To avoid this, readtable can be called with "VariableNamingRule","preserve" as detailed in the documentation. But can the variable names in the source data be ignored entirely so that this does not have to be done? Perhaps by calling with ReadVariableNames set to false and DataRange set to 2?

In my case readtable automatically generate column header as "VAR". If I do not want to generate that "VAR" what should I do?

"If I do not want to generate that "VAR" what should I do?"

Table columns/variables must have headers. If the header is not imported from a file, the default VAR* is used.

You can specify the header names when importing the file data, or replace them afterwards (see the above answer). What do you expect to see as the header names in your table?

Actually I'm converting.xls file to .CSV by using the command 'readtable'. Now in my actual dataset there was no header. But after converting using 'readtable' a default header is coming which is 'Var'. Now I don't want this to come. What should I do?

table() objects must have unique names for each variable. It is not possible to create a table() object which does not have variable names.

You can readtable() and pass VariableNames at the time of reading, thereby giving some name of your choice.

You can skip a header by using HeaderLines, 1 and ReadVariableNames, false