readtable() custom variable names

131 次查看（过去 30 天）
Muhammed Yusuf Aksel
评论： Stephen23 2022-5-18
I am using the below command to read a csv file into a table called T.
T = readtable("library.csv")
Now, the first row of the csv inludes the column headers, or variable names you can say. However, I want to change those variable names as I want. I have inspected readtable() documentation, but could not find the solution.
How can I do this?
Thanks.

请先登录，再回答此问题。

采纳的回答

Ameer Hamza
Ameer Hamza 2020-4-4
编辑：Ameer Hamza 2020-4-4
One way is to change the variable names after reading the file like this.
t = readtable("library.csv");
t.Properties.VariableNames = {'name1', 'name2'}; % names of columns
  6 个评论
显示 4更早的评论
Walter Roberson
Walter Roberson 2022-5-18
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
Stephen23
Stephen23 2022-5-18
@Supriya Gain: use READCELL and WRITECELL instead.

请先登录，再进行评论。

更多回答（1 个）

Steven Lord
Steven Lord 2022-5-18
If you're using release R2020a or later I would use the renamevars function.

类别

在 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!

Translated by