How do i resize a large dataset

I am trying to copy and paste a dataset from the internet and resize it into a matrix (300x14) however when copying the dataset it appears in the form below
1 2 3 4 5 6 6 7 8 8 8 9
2 2
3 2 3 4 5 6 7 7 8 6 4 3
1 3 ...
how do i resize this without applying semicolons on every other row?
Thanks

回答(2 个)

You could paste it into a txt file then create the matrix with this code:
fid = fopen('text.txt'); % Open the text file.
numbers = textscan(fid, '%d');
numbers = reshape(numbers{1}, 14, [])'
fclose(fid);

4 个评论

By the way, 300 x 14 is hardly "large" - it's microscopic.
now all my numbers are rounded to integer values when the original data was all to 3 d.p . is there any way to get rid of this.
thanks
textscan with '%f' instead of '%d'
Walter's right. And this highlights the importance of attaching your data. The data you posted was integers so I used %d. If you had attached your text file we would have known you had floating point numbers and we would have gotten you the correct answer immediately.

请先登录,再进行评论。

类别

帮助中心File Exchange 中查找有关 Large Files and Big Data 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by