Question

Fill the column with pre-defined time intervals
Hi, I need to fill the column A below with pre-defined time intervals for each day. For example, Jan 1 1998 1/1/1998 0:...

9 years ago | 1 answer | 0

1

answer

Question

Linear Inperpolation for missing values
Hi, I need to find the missing values for Lat, Long in column 5 and 6 using linear interpolation. Can anybody suggest me a me...

9 years ago | 1 answer | 0

1

answer

Question

Write a cell array to a .csv file
Hi, I have a cell array "newdata" as shown below. '01/01/2001' 0 '02/01/2001' 0 '03/01/2001' 0 '04/01/2001' 0 ...

9 years ago | 3 answers | 0

3

answers

Question

Arrange data in cell array for complete data years
I wanted to modify the code below to show the mm/dd/yyyy in first column if col 6 of each cell has complete data set (i.e. if nu...

9 years ago | 1 answer | 0

1

answer

Question

Convert MATLAB code compatible with version 2011
Hi, Can somebody help me to convert the piece of code below compatible with MATLAB 2011 version? tr = readtable('100303...

9 years ago | 1 answer | 0

1

answer

Question

Read non-negative cells from a cell array
Hi, I have following code to read two csv files. I need to read the non-negative cell values from col 6 of Dt cell array and ...

9 years ago | 1 answer | 0

1

answer

Question

Pass one value at a time from a matrix to a for loop
Hi, I need to pass one value at a time from matrix to iprev inside the for loop. For example, first value of iprev is 11 then...

9 years ago | 1 answer | 0

1

answer

Question

Read all the columns in a .csv file
Hi, I have a .csv file with the following columns, I need to read all the columns. What function I need to use. I tried csvre...

9 years ago | 2 answers | 0

2

answers

Question

Get the avarage for coresponding cell contents from a cell array
Hi, I have two cell arrays. # data = 1x175 cell (rows double array is not consistent for each cell. There are some cells w...

9 years ago | 2 answers | 0

2

answers

Question

Reading .dbf files in a for loop by dynamically changing file names
Hi All, I need to read multiple (175) .dbf files in a for loop. But file name to be read needs to be dynamically changed. F...

9 years ago | 1 answer | 0

1

answer

Question

convert data celll array to double array and write to .xls or .csv
Hi, I have a data cell array "Data" which has 10 cells but each cell have different number of rows (see the image below). Can...

9 years ago | 2 answers | 0

2

answers

Question

Dynamically change column in excel worksheet inside a for loop
Hi, Can somebody help me how I can modify/include the follwing code to dynamically write output to Excel file inside a for lo...

9 years ago | 1 answer | 0

1

answer

Question

Generating days based on leap years
Hi, I wanted to generate a matrix like below. Basically, years in the first column, start days, end days for the year by cond...

9 years ago | 1 answer | 0

1

answer

Question

acessing cell arrays with different number of rows
Hi, I have cell array "out" <1x123> cells. Within each cell of out{1,1}, <1x3 cells. How can I access 2 and 3 columns of each...

9 years ago | 1 answer | 0

1

answer

Question

Reading a all the rows in a CSV file
Hi, I have written the following code to read the csv file. But How can I modify to read all the rows in both columns. At the...

9 years ago | 2 answers | 0

2

answers

Question

Read 2 and 6 columns of multiple .csv files with different file names
Hi, I have tried the following code to read 2 and 6 columns of multiple .csv files (368) with different file names. Then i n...

9 years ago | 1 answer | 0

1

answer

Question

convert matrix and horizontally catenate
Hi, I need to convert this matrix A to A=[1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 ...

9 years ago | 1 answer | 0

1

answer

Question

Show the numbers in one color in scatterplot
Hi, Please look at the following code. I need to show the points (as numbers) in black color. But it is showing in different ...

10 years ago | 0 answers | 0

0

answers

Question

Remove NaN and create one column
Hi, I have a matrix A (31 x 12) which has NaN values and need to remove all NaN values and make it a one column (:). How can ...

10 years ago | 1 answer | 0

1

answer

Question

Remove NaN and create one column
3680 2420 1400 907 932 2200 4460 7110 10200 10800 7270 4890 3620 2330 1470 1050 1110 2400 4480 7250 10100 10700 7150 47...

10 years ago | 1 answer | 0

1

answer

Question

Fix the limits of Yaxis secondary axis
Hi, I have the following code which I am duplicating for 6 different data sets. I want to limit the Y secondary axis from -25...

10 years ago | 1 answer | 0

1

answer

Question

Store columns in a matrix in different variables
Hi, I have a matrix A (5479 x 378). I need to store every column of the matrix A in separate arrays St1, St2, St3....St378. S...

10 years ago | 2 answers | 1

2

answers

Question

Obatin the sum from reading columns from 2 matrices
Hi, I have matrix A=(5479 x 378) and RowID matrix (15 x 2). I need to get the sum for each column of A for RowIDs 1:15 ...

10 years ago | 1 answer | 0

1

answer

Question

read from multiple text file and store in a 3D array
Hi, I have 378 text files (0001.txt, 0002.txt, ....0378.txt). I can read each text file using the following code by chaning t...

10 years ago | 1 answer | 0

1

answer

Question

merge multiple netCDF files into one netCDF file and read for lat, lon
Hi, I have multiple folders from 1998 to 2012 in each folder there are 365 .nc files. File names in each folder appear like t...

10 years ago | 1 answer | 0

1

answer

Question

Show row and column number by the side of each point in scatterplot
Hi, I have an array X of values has 741 (rows) and 1 (col). Y is also the same. I want to plot a scatterplot(X,Y) but I need ...

10 years ago | 1 answer | 0

1

answer

Question

Plot scatterplot showing row and column numbers
Hi, A=[1.0 0.7 0.6 0.5 0.8 1.0 0.5 0.1 0.2 0.3 1.0 0.2 0.1 0.8 0.6 1.0]; I need to plot a scatter ...

10 years ago | 1 answer | 0

1

answer

Question

Read through header number and add correponding columns from different arrays
Hi, I have following arrays. H=[438 440 441 449 455 457 459 460 462 467 468 469 473 476 478 479 481 483 485 486 487]; A...

10 years ago | 1 answer | 0

1

answer

Question

Find elements greater than a value corresponding to the second array
Hi, I have matrix A which has zeros and precipitation values and B which has zeros and probability values. The probability va...

10 years ago | 1 answer | 0

1

answer

Question

Change values of an array to make uncorrelated
Hi, I have two arrays B and C. Each (3652500 x 1) which has zero and nonzero values. But B and C are correlated. How can I ch...

10 years ago | 0 answers | 0

0

answers