Concatenate two columns of a csv file using horzcat with same variable name

Question

Hitesh Bugata 2020-6-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/548427-concatenate-two-columns-of-a-csv-file-using-horzcat-with-same-variable-name

评论： Ameer Hamza 2020-6-15

I have few csv files, each has 3 columns with first two columns same in all. I want to merge all of them into a single csv file with first two common columns and continued with 3rd column of each individual files. Error associated is the same variable name for the 3rd column in all csv files. I'm attaching my code. Thanks in advance!

clc
clear all
close all
files = dir('*.csv');
A = readtable(files(1).name);
numfiles = length(files);
for k=2:numfiles
filename = files(k).name;
T = readtable(filename,"ReadVariableNames",true,"PreserveVariableNames",true); 
A = horzcat(A, T(:,3));
end
writetable(A,'mergedCols.csv');

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Ameer Hamza 2020-6-15

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/548427-concatenate-two-columns-of-a-csv-file-using-horzcat-with-same-variable-name#answer_451368

编辑：Ameer Hamza 2020-6-15

在 MATLAB Online 中打开

In MATLAB, two columns of a table cannot have the same variable name. Also, it might not make sense to have identical column names in a CSV file. However, you can do this using cell arrays instead of tables. Something like this

files = dir('*.csv');
A = readtable(files(1).name);
A = [A.Properties.VariableNames; table2cell(A)];
numfiles = length(files);
for k=2:numfiles
filename = files(k).name;
T = readtable(filename,"ReadVariableNames",true,"PreserveVariableNames",true); 
A = horzcat(A, [T.Properties.VariableNames(3); num2cell(T{:,3})]);
end
writecell(A, 'mergedCols.csv');