Multiplying elements from various tables to create a third table

Question

0 个投票

Hi there,

I'm a beginner to Matlab, and I have a very shaky foundation. However, I need the help of Matlab to do some analysis. I would highly appreciate your help!

I have two types of data sets I'm drawing from

(for n =1:82 tables) Table A_n(70080 x 4)

Table B(82 x 1)

Basically, I need to individually multiple the 'nth' element in Table B by the second column of Table A_n.

This should result in Table C (70080 x 82).

I know I can produce the variables for each column vector of Table C by inputting this:

Col_1 = A_1(:,2)*B(1,1);

Col_2 = A_2(:,2)*B(2,1);

...

Col_n = A_n(:,2)*B(n,1);

but it is manually taxing. Furthermore, I have no idea how to input these into an actual table. This would require some sort of concantenation?

Initially I wanted to dynamically create these variables but I have read elsewhere that doing so is actually quite troublesome.

Is there any way for me to input these variables directly into a table?

And to do this all through a for loop...

Thanks!

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Christina Hong 2020-7-28

In the follow script, im getting close to my desired result

HOWEVER in the bold/italic/underlined section im trying to obtain the column vector of one table and the element of the other, but instead what I get returned is a string. How will I be able to obtain actual values?!

>> myFilenames = cell(8,1);

for i = 1:8

str = strcat('1000YearReturn_300deg_Story',' ', num2str(i),'.txt');

myFilenames{i} = str;

load(myFilenames{i});

end

>> myFilenames = cell(8,1);

momentY = cell(70080,1);

for i = 1:8

str = strcat('1000YearReturn_300deg_Story',' ', num2str(i),'.txt');

myFilenames{i} = str;

load(myFilenames{i});

story_i = strcat('X1000YearReturn_300deg_Story', ' ', num2str(i), '(:,2)');

refHeight = strcat('Referenceheights(', ' ', num2str(i), ',1)');

momentY{i} = story_i*refHeight;

mY = momentY{i};

T = [T mY];

end

请先登录，再进行评论。

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

Follow Question

Answer 1

Christina Hong 2020-7-30

0 个投票

I was able to find the answer to my problem, successfully creating 3 70080x82 tables and using a loop to load in all 82 files

>> load Referenceheights.txt

myFilenames = cell(82,1);

My = [];

Mx = [];

Mz = [];

for i = 1:82

str = strcat('1000YearReturn_300deg_Story',' ', num2str(i),'.txt');

myFilenames{i} = str;

load(myFilenames{i});

S = load(myFilenames{i});

My(:,i) = S(:,2)*Referenceheights(i,1);

Mx(:,i) = S(:,3)*-Referenceheights(i,1);

Mz(:,i) = S(:,4);

end

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

请先登录，再进行评论。

Answer 2

Mario Malic 2020-7-28

在 MATLAB Online 中打开

0 个投票

Check if it gives correct output.

C = (A(:,2)'.*B)';

4 个评论
显示 2更早的评论隐藏 2更早的评论

Christina Hong 2020-7-29

Hi Mario,

I will compile all 82 resultant column vectors from Table A(:,2) x Table B(n,1) to form ONE table C with 82 columns.

Mario Malic 2020-7-29

编辑：Mario Malic 2020-7-29

The line that I wrote gives you the Variable C with (70080 x 82).

请先登录，再进行评论。

Multiplying elements from various tables to create a third table

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

采纳的回答

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

更多回答（1 个）

4 个评论
显示 2更早的评论隐藏 2更早的评论

类别

标签

Community Treasure Hunt

Multiplying elements from various tables to create a third table

1 个评论 显示 -1更早的评论 隐藏 -1更早的评论

采纳的回答

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

更多回答（1 个）

4 个评论 显示 2更早的评论 隐藏 2更早的评论

类别

标签

另请参阅

Community Treasure Hunt

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

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

4 个评论
显示 2更早的评论隐藏 2更早的评论