Answered
Exporting and save Data from Matlab to Excel
Hey, if you want to save Nameofyourdata to the directory E:\mydirectoryname. You can use fullfile dir = 'E:\mydirectoryname'; ...

mer än 4 år ago | 0

Question

How to find the nearest point for 71 points?
Hey all, I have coordinates.mat which includes the name of 71 climate stations and corresponding latitude and longitude. I want...

mer än 4 år ago | 0 answers | 0

0

answers

Question

Counting all NaN and Sequence NaN in tables
Hey all, I have x.mat which includes 71 tables. for all tables, I want to count the number of NaN cells in 9, 10, 11, and 12 c...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Brace indexing is not supported for variables of this type
Hey all, When I try to use this code: output = cell(size(new_precipitation)); for i = 1:length(new_precipitation) mn2t_ma...

mer än 4 år ago | 1 answer | 0

1

answer

Answered
transmit a Excel file in a vector or matrix
I think you want to import an excel file into Matlab. You can use xlsread if your excel format is .xls myfile = xlsread('fil...

mer än 4 år ago | 0

Answered
Choosing the number of hidden layers in a multi layer neural network.
Dear Deepti, There is no rule to decide the number of hidden layers. It can be estimated through trial and error (experiment). ...

mer än 4 år ago | 0

| accepted

Answered
Change value for another value
Hi, If I understood you well, you need this? If Array is your Array, then: index=find(Array==99999); % find all 99999 values....

mer än 4 år ago | 0

Question

Eliminate tables with more than 15% NaN data
Hey all, I have C.mat which has 125 tables. I want to remove tables if any of tmax_m or tmin_m or rrr24 or tmin_m columns have ...

mer än 4 år ago | 2 answers | 0

2

answers

Question

Selecting tables among 540 tables, based on a start and end date
Hello all, I have an x.mat cell which includes over 540 tables for 540 climate stations. In every 540 tables, there is a column...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Add coordinate points (latitude and longitude) on a figure
Hi, I have the coordinates of some climate stations over a country in the coordinates.mat. The 3rd and 4th column of coordinates...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Selecting a portion of the tables
I have C.mat which includes 125 tables. I need to list only the first row of each 125 tables and put them under each other. I w...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Add 0.5 *0.5 degree grid on figure (country)
Hey all, I was even read grid function documentation here: https://www.mathworks.com/help/matlab/ref/grid.html But I don't know...

mer än 4 år ago | 2 answers | 0

2

answers

Question

Count smaller than 15 cells in the table coulumns
I have a 125*5 table, I want to know how many cells are smaller than 15 in each column of tmax_m, tmin_m, rrr24, tm_m separately...

mer än 4 år ago | 2 answers | 0

2

answers

Question

Finding the percentage of NaN cells in columns
I have an excel file. I want to know how much (%) of my data are NaN. I want to found that for columns 9 to 12 separately, and ...

mer än 4 år ago | 3 answers | 0

3

answers

Question

How to export Excel files to the specific folder?
I have the below code: for p = 1:numel(C) filename = C{p}{1,2}; if ~isempty(filename{:}) sprintf('%s.xlsx',f...

mer än 4 år ago | 2 answers | 0

2

answers

Question

How to select the part of the tables in a cell?
I have a 1*125 cell named "C". inside C I have 125 tables (456*12 tables). I want only part of these tables from row number 98 t...

mer än 4 år ago | 1 answer | 0

1

answer

Question

How to fill blank cells in the table using filled cells in the same column?
I have a 1*125 cell named "C". inside C I have 125 tables (456*12 tables). I want to fill every blank cell in 1 to 4 columns of ...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Need help for export table to excel
Hello everyone, I have a 1*125 cell named "C" which has 125 tables. I want to export all these 125 tables to separated xlsx fil...

mer än 4 år ago | 1 answer | 0

1

answer

Answered
how to create a matrix (3*3) from 1 to 9 by using for loop
I think you don't need any for loop to achieve this goal. try this code below: reshape( 1:9, 3, 3) .'

mer än 4 år ago | 0

| accepted

Answered
Merging Arrays in Ascending Order
Hello my friend, I'm new too. I guess you can use: d = [a b c] then sort: d_sort = sort (d)

mer än 4 år ago | 0

| accepted

Question

How to write a Loop to run a specific code to every table in a cell
I have many excel files (540 files) which I used this code to import them to Matlab: D = 'C:\Users\Behzad\Desktop\New folder (2...

mer än 4 år ago | 3 answers | 1

3

answers

Question

How to fill NaN's by averaging previous rows?
I have a table named T2.mat. This table has 12 columns. The last column sometimes has NaN values. I want to fill NaN in this col...

mer än 4 år ago | 2 answers | 0

2

answers

Answered
Replace NaN's in a table - I need some help
Dear all, thanks for all your help. my problem was fixed here: https://www.mathworks.com/matlabcentral/answers/497543-replace-n...

mer än 4 år ago | 0

Question

Replace NaN with next good value in a certain column of a table
I have T2.mat which is a table with 12 columns. I want to replace NaN in columns 5:7 (5 to 7) by exactly the next good value in ...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Replace NaN's in a table - I need some help
Hello all, I have a table namely T2, it has 12 columns. in all of these columns I have some NaN values. I would like to replace...

mer än 4 år ago | 2 answers | 0

2

answers

Question

How to generalize this code?
Hello everyone, Thanks to Adam Danz I have this code below in order to create a NaN cell, where data are missing and generate ...

mer än 4 år ago | 1 answer | 0

1

answer

Question

how to have datetime for specific range?
Hi, I want to have a datetime, monthly from 1982 to 2015, like this: 1/1/1982 2/1/1982 3/1/1982 ... 12/31/2015 how to h...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Error using table (line 328) The VariableNames property must contain one name for each variable in the table.
Hey all, I have Abalai.xlsx file, This table sometimes contains missing data. Where there is a missing number, there is no date...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Compare Two Data Sets: How to Compare Only the non-NaN rows Together?
Hello all, I have a general question. if I have 2 data sets of real data and predicted data, which in those column A is date a...

mer än 4 år ago | 1 answer | 0

1

answer

Question

Creat blank cell, where data are missing and generate related date
Hi I have a table where the first column of the date and the second column are the values corresponding to that date. This tab...

mer än 4 år ago | 1 answer | 0

1

answer