MATLAB Answers

Eliminating duplicate columns in a table when appending

215 ビュー (過去 30 日間)
Danielle Leblance
Danielle Leblance 2017 年 2 月 5 日
コメント済み: nikhilthoppil 2020 年 4 月 10 日
Hi,
I am importing data using readtable function. but when i append data using:
mytable=[mytable mytable2];
I receive an error: Duplicate variable name: 'ID' because every file contains the ID of the firm. I need the column ID only once. so how can i skip the ID column in mytable2 when i want to append?

採用された回答

the cyclist
the cyclist 2017 年 2 月 5 日
編集済み: the cyclist 2017 年 2 月 5 日
Use the join command. Here's a simple example.
% Set up some sample data
id = [1 2 3]';
firstName = {'Walter','Image','Star'}';
lastName = {'Roberson','Analyst','Strider'}';
tableFirst = table(id,firstName);
tableLast = table(id,lastName);
% Join the tables
tableFirstAndLast = join(tableFirst,tableLast)
FYI, there are many input options that govern how the variables in the two tables are retained when there are duplicates, so I suggest carefully reading the documentation (linked above) if this example doesn't do exactly what you want in your case.
You might also need a different function from that family, e.g. innerjoin.
  6 件のコメント
nikhilthoppil
nikhilthoppil 2020 年 4 月 10 日
Can I use this function if I need to erge two tables having more that one columns in common?

サインインしてコメントする。

その他の回答 (0 件)

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by