Matlab-Excel shape PROBLEM

2023 10 30
1 个回答
更新时间：2023 10 31
7 次查看（30 天）

0 个投票

Buongiorno, ho un file di testo che mi riporta una serie di dati in matrice e lo devo convertire in excel.
Il problema però non è questo, perchè lo so fare, ma il fatto è che devo mettere la matrice disposta in un determinato modo.
Ad esempio le primo 19 colonne le devo mettere tutte sulla stessa riga, e così dalla 20 alla 29 colonna ecc..
La mia matrice ha più di 1000 colonne!
Come posso fare?
Goodmorning I have a text file that gives me a serie of datas in matrix and I have to convert it in excel.
But that's not the problem, I can do that easily!
THe problem is that I have to shape the matrix in a different way, infact I have to take the first 19 columns and put them on the same row. And I have to do that with the columns from 20 to 29.
I have more than 1000 columns, how can I do that? Please!!

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Walter Roberson
Walter Roberson 2023-10-30
So the first row should have 19 columns and the second row should have 10 columns? How many columns should the other rows have?
MATLAB arrays cannot have a different number of columns but if you put NaN in a location it show up empty in excel
Dyuman Joshi
Dyuman Joshi 2023-10-30
Could be a typo, which is what I assumed (I know I should not have).
Nonetheless, OP has not replied yet given the "urgency" of their question.
Roberta Di Napoli
Roberta Di Napoli 2023-10-30
Ok no I haven't been clear and it's really difficult to explain. Basically I have some datas in a certain number of columns and of rows and I have to took them in Excel. The problem is that I have to reshape the datas in order to have for example the numbers from the 1st to the 20th position in the first column and move them in the first row. Then I have to do the same thing with the numbers from the 21th to the 30th with the second row and so on. I don't know if it's clear. I know that you cannot change the shape of the matrix that's why I have problems.
Roberta Di Napoli
Roberta Di Napoli 2023-10-30
I am taking the datas from a .txt Also I was thinking of using a for function. I don't know. I'm welcome to any advise. Thank you for the help!
Walter Roberson
Walter Roberson 2023-10-31
What is the format of the txt file?

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson
Walter Roberson 2023-10-30

0 个投票

Create a vector containing the number of consecutive elements needed to move into each row. Not the indices, the count. So for example counts = [19 10 ... whatever] then
largest_split = max(counts);
total_wanted = sum(counts);
Column_to_Extract = 1;
splits = mat2cell(YourData(1:totalwanted,Column_to_Extract), counts, 1);
Block = cell2mat(cellfun(@(V) [reshape(V, 1, []), nan(1, largest_split-numel(V))], splits(:), 'uniform', 0));
Now if I did everything properly, Block should end up as a numeric array in which groups of consecutive rows in YourData have been converted into one row per group, and each row will be padded out with NaN to the length of the longest row.
If you now write that data out to an excel file, such as with writematrix() then the NaN will be converted to empty cells.

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

产品

版本

R2023a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by