How to join datasets?

8 views (last 30 days)
Xinyuan Wei
Xinyuan Wei on 18 Jun 2016
I need to join some columns in the dataset attached below. When I joined the columns int_rate and id with the following code, it works.
TrainInputs = [TrainDataset.int_rate,TrainDataset.id]
But when I was trying to join the columns int_rate and sub_grade, it failed.
TrainInputs = [TrainDataset.int_rate,TrainDataset.sub_grade]
Error using horzcat
Dimensions of matrices being concatenated are not consistent.
Could you help me find out why and how should I do this? Thank you for your time.

Answers (1)

Muhammad Usman Saleem
Muhammad Usman Saleem on 18 Jun 2016
check this in both columns vectors, these are not of same length.
TrainDataset.int_rate and TrainDataset.id are not of same length to concatenated. Always concatenate vector of same lengths
  2 Comments
Xinyuan Wei
Xinyuan Wei on 19 Jun 2016
Thank you for your reply. But I still cannot understand.These three columns should all have 50 rows.
>> size(TrainDataset.id)
ans =
50 1
>> size(TrainDataset.int_rate)
ans =
50 1
>> size(TrainDataset.sub_grade)
ans =
50 1
Why matlab says they are not of the same length?
Muhammad Usman Saleem
Muhammad Usman Saleem on 19 Jun 2016
You can't horizontally concatenate scalars with matrices or column vector, hence the error.
Find out which variable is the culprit on why it's not scalar (or why you're using a non-scalar variable in your expression.
As i do not know how you three column vectors looks, The attached .m file also not opening. Please upload here its content

Sign in to comment.

Categories

Find more on Creating and Concatenating Matrices in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!