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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 ...

9 years ago | 0 answers | 0

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 ...

9 years ago | 1 answer | 0

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...

9 years ago | 1 answer | 0

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...

9 years ago | 1 answer | 0

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...

9 years ago | 2 answers | 1

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 ...

9 years ago | 1 answer | 0

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...

9 years ago | 1 answer | 0

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...

9 years ago | 1 answer | 0

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 ...

9 years ago | 1 answer | 0

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 ...

9 years ago | 1 answer | 0

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...

9 years ago | 1 answer | 0

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...

9 years ago | 1 answer | 0

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...

9 years ago | 0 answers | 0