Question

subtracting matrices in a special way
a = randi(50,600,9); mx = randi(50,60,1); q = bsxfun(@minus,reshape(a(:,7),10,[]),mx); q = reshape(q,[],1); After reshap...

11 years ago | 2 answers | 0

2

answers

Question

problems with speed need advice on hardware
Hi, i have an i7 and 8gigs ram. All calculations are CPU based. I carry out calculations with huge cell arrays(100x60) that hav...

11 years ago | 2 answers | 0

2

answers

Question

converting only certain cells to a matrix
consider the following example a = { rand(1877958,7); rand(1251972,7); rand(4564357,7) }; i want only the first two ce...

11 years ago | 1 answer | 0

1

answer

Question

converting a minute chart
Hi guys, i have a table with 6 columns and 4 million rows. Column1 shows the date and column 2 the time. Column 3 the opening pr...

11 years ago | 1 answer | 0

1

answer

Question

calculation within a matrix
Consider a matrix with 1877958 rows and 7 columns. How can I subtract the first row, second row, third row... in column 1 from...

11 years ago | 1 answer | 0

1

answer

Question

converting a cell array to a matrix
consider the following example a={rand(1877958,7); rand(1251972,7)}; i want this to be converted to a matrix. i know t...

11 years ago | 1 answer | 0

1

answer

Question

short cut to subtract cells without replicating numbers
Hi guys, assume the following: Cell array mx (100x61), Cell array mn (100x61), Cell array a (100x61). These cell arrays consi...

11 years ago | 1 answer | 0

1

answer

Question

automatic import into matlab after time period
I have .csv file on my desktop which get replaced every 49 minutes. Can i put a command in matlab which imports this file every ...

11 years ago | 1 answer | 0

1

answer

Question

calculation with different cell arrays
Hi guys, assume the following: Cell array mx (100x61), Cell array mn (100x61), Cell array a (100x61). These cell arrays ...

11 years ago | 1 answer | 0

1

answer

Question

error with number replication in a cell array
Hi guys, mx is a 100x61 cell array. I want to replicate the numbers of all cells in the cell array with the following formula b...

11 years ago | 1 answer | 0

1

answer

Question

multiply numbers in a table
Assume the following numbers in a table 1 2 3 4 How can I multiply them in the following manner: 1 1 ...

11 years ago | 4 answers | 0

4

answers

Answered
applying formula across various matrices
any advice?

11 years ago | 0

Answered
applying formula across various matrices
ok let me give you a better example to clarify what I want to do: Assume the following array a={rand(3755940,7); rand(18779...

11 years ago | 0

Answered
applying formula across various matrices
ok let me give you a better example to clarify what I want to do: Assume the following array a={rand(3755940,7); rand(18779...

11 years ago | 0

Question

applying formula across various matrices
Hi guys, I have a complex problem. I have a cell array b (1x100 cell). The cells contain matrices with various row numbers b...

11 years ago | 4 answers | 0

4

answers

Question

Scanning an entire table in blocks of 60s for max and min values
a={rand(1877958,7); rand(1251972,7)}; b=cellfun(@(x) [x; repmat(x(end,:),-mod(size(x,1),-60),1)],a,'un',0) for i=1:lengt...

11 years ago | 1 answer | 0

1

answer

Question

reshaping to display the same result of a function
I want the following function to be reshaped in a different manner: for i=1:length(b) mn(i)={min(reshape(b{i}(:,5),60,...

11 years ago | 1 answer | 0

1

answer

Question

finding the maximum and minimum value of specific rows in a cell array
I have a cell array (1x99) which consists of the following matrices: 1877958x8 double 1251972x8 double 938979x8 double 7...

11 years ago | 2 answers | 0

2

answers

Question

removing symbol and numbers from a table
I have a column with a million rows in cell array format. The time is given as '2:02' and some rows contain '02:02:00'. How can ...

11 years ago | 1 answer | 0

1

answer

Question

date and time serial conversion
I have a table with one million rows and 5 columns. The first column has the dates and the second column the time. I want toconv...

11 years ago | 2 answers | 0

2

answers

Question

putting columns together as a table
Hi guys, I have got several variables: a, b, c, d, e. They are all cell arrays and consist of one column and several million ro...

11 years ago | 2 answers | 0

2

answers

Question

converting a minute chart
Hi guys, i have a table with 6 columns and 4 million rows. Column1 shows the date and column 2 the time. Column 3 the opening pr...

11 years ago | 0 answers | 0

0

answers

Question

removing saturday and sunday and the corresponding values from a table.
hi guys, I have a table which is in table format in matlab. the table has 5 million rows and 6 columns. here is a sample of the...

11 years ago | 1 answer | 0

1

answer

Question

merging two tables gives me an error
Hi, I am trying to merge two tables but i get the following error. why is that? the first table consists of 6 columns and 10000...

11 years ago | 1 answer | 0

1

answer

Question

how to add columns with a certain formula
Hi guys, I have a cell array with 90 cells. Each cell consits of a table or matrix with 6 columns and one million rows. Colu...

11 years ago | 1 answer | 0

1

answer

Question

calculating average from 2 rows
Hi guys, I have a cell array with 90 cells. Each cell consists of 6 columns and approximately one million rows. Column 1 shows d...

11 years ago | 1 answer | 0

1

answer

Question

converting a minute chart
Hi guys, i have a table with 6 columns and 4 million rows. Column1 shows the date and column 2 the time. Column 3 the opening pr...

11 years ago | 2 answers | 0

2

answers

Question

removing weekends from table
Hi guys, i have a table with 6 columns and 4 million rows. Column1 shows the date and column 2 the time. Column 3,4,5,6 display ...

11 years ago | 1 answer | 0

1

answer

Question

sorting cell array ascending order and changing the values within the cell to positive
I have got the following cell array. I want to put the cell array in ascending order in such a way that the [smallest numberx24 ...

11 years ago | 1 answer | 0

1

answer

Question

complex subtraction of cell array from matrix
Hi, I have two variables called 'out' and 'in'. The out variable is a cell array which is displayed as out = [ 52416x...

11 years ago | 1 answer | 0

1

answer