Question

reshaping a vector of dates (2)

Dear all, I have a cell column vector that contains the following elements AAA={'AUGUST-SEPTEMBER 1999' ... 'OC...

oltre 9 anni ago | 2 answers | 0

Question

deleting all the empty rows

Dear all, I have [N,T,R]]=xlsread(name); I want to erase all the empty rows in T. I suggest T( all(cellfun(@isemp...

oltre 9 anni ago | 1 answer | 0

Question

creating a string variable to be used in xlswrite

Dear all, I have [N,T,R]=xlsread(Name); where Name={'Input_DE_carrots.xlsx'} The DE which represents the countr...

oltre 9 anni ago | 3 answers | 0

Question

Selecting a particular part of a string variable

Dear all, I have A={'BARI 500 esd' ... 'DUR NOR 18 df ' } I want to choose the part of the string that is up t...

oltre 9 anni ago | 3 answers | 0

Question

selecting only the numbers from a string variable

Dear all, I have A={'BARI 500G' ... 'DUR NOR 18CONmS' ... 'SENSO NORM ST-TUB 75ML '... 'MARL 100S 20CIG'......

oltre 9 anni ago | 3 answers | 3

Question

reshaping 2 vectors of dates

Hi everyone I have the following cell vector of dates D={'September-October 2000' ... 'November-December 2000' ... ...

oltre 9 anni ago | 1 answer | 0

Question

a problem with "for loop" that contains "if staetement"

Dear all, I have the following code list= {'jj.xlsx' ... 'rt.xlsx' ... 'gt.xlsx' } ...

oltre 9 anni ago | 0 answers | 0

Question

verification of the intepretation of a simple code that contains "isequalwithequalnans"

Could you please verify the interpretation of the code if ~(isequalwithequalnans(a, b) ==1 | isequalwithequalnans(a, c) ...

oltre 9 anni ago | 2 answers | 0

Question

save variables of different dimension in the same excel file

Hi, I want to save in the same excel file variables of different dimension that I create. Foe example say that a variab...

oltre 9 anni ago | 1 answer | 0

Question

more efficient way of coding a series of string variables which contain a fix subset of strings

Dear all, I have the following list l1= 'di _Aust.xlsx' ; l2='di _Bel.xlsx' ; l3='di_Est.xlsx'; l4 = 'di...

oltre 9 anni ago | 2 answers | 0

Question

Display warning only if the "if "statement is not satisfied

Hi, I want to create an if statement that will warn me ONLY if the “if “ is NOT satisfied I tried initially, if qs...

oltre 9 anni ago | 1 answer | 0

Question

comparing matices that contain numbers and NaNs

I have 2 cell matrices R and W and I want to check if they contain the same elements. Specifically, I want to compare R which ...

oltre 9 anni ago | 3 answers | 0

Question

treating NaN as a unique value (instead of as a distinct)

In http://www.mathworks.de/help/techdoc/ref/unique.html there is the following example: Unique Values in Array Cont...

oltre 9 anni ago | 4 answers | 1

Question

Calculating combinations of dates with empty cells

Dear all, I have the following cell vector of dates jji= ' ' '28/12/08' '25/01/09' that corresponds...

oltre 9 anni ago | 0 answers | 0

Question

finding the exact location of empty cells

Dear all, I have the following cell matrix clear all clc k = cell(2,6)' k{1} = '7'; k{12} = 3; To find em...

oltre 9 anni ago | 1 answer | 0

Question

replacing specific elements in a matrix

Dear all, I have a matrix A of dimension 9126 by 2 and I want to replace the elements (39,2) (39*2,2) , (39*3,2), (39*4,2) a...

oltre 9 anni ago | 1 answer | 0

Question

Calculating combinations of dates

Dear all, I have the following cell vector of dates jji= '23/11/08' '28/12/08' '25/01/09' ...

oltre 9 anni ago | 1 answer | 0

Question

replacing "zero dates " so as to be empty

Dear all I have the following cell vector '00/00/00' '00/00/00' '00/00/00' '00/00/00' '00/0...

oltre 9 anni ago | 2 answers | 0

Question

projecting values to future dates

Dear all, I have the following sequence of dates Dates=['02/11/08' '30/11/08' '28/12/08' '25/01/09...

oltre 9 anni ago | 0 answers | 0

Question

Finding the end date of each month/year

Dear all, I have the following sequence of dates dates =[ '23/11/08' '28/12/08' '25/01/09' '22/0...

oltre 9 anni ago | 2 answers | 0

Question

replicating a cell vector of dates

Dear all, I have the cell vector jji= 'JAN 2009' 'FEB 2009' 'MAR 2009' 'APR 2009' 'MAY 2009' ...

oltre 9 anni ago | 1 answer | 0

Question

Separating a column in two others when there are empty cells

Guys, I have the following cell Column ' ' '4W231108' '4W211208' '4W180109' '4W15020...

oltre 9 anni ago | 1 answer | 0

Question

breaking a column of strings in two different columns

Dear all, Inside the workspace I have the following column in cell format Column 1 ‘AR021108' 'AW301108' ...

oltre 9 anni ago | 2 answers | 0

Question

temporal disaggregation

Dear all I have the following data set dates price 23/11/08 2 28/12/0...

oltre 9 anni ago | 1 answer | 0

Question

interpolation to specific sequence of dates

Dear all, I have a panel data set of prices of goods that vary across time and countries. The data are in an excel file ...

oltre 9 anni ago | 2 answers | 0

Question

calculating the difference (in days) between successive dates

Dear all, I have the following sequence of dates dd={'2-11-2008' '30-11-2008' '28-12-2008' '25-01-2009' '22-...

oltre 9 anni ago | 1 answer | 0

Question

analyzing assymetric data sets

Dear all, I have some data on prices for a specific good across time and across countries. The first problem is that the sta...

oltre 9 anni ago | 0 answers | 0

Question

finding all the other elements of a cell vector apart from zeros and empties

Dear all, I want to find all the elements of a cell vector apart from zeros and empties Using the command ismember(mm,...

oltre 9 anni ago | 1 answer | 0

Question

finding unique string variables from a column vector

Dear all, I insert an excel file into matlab as follows clear clear all [data,text,all] = xlsread(A.xlsx'); ...

oltre 9 anni ago | 1 answer | 0

Question

plots of dates

Dear all, I have a panel data across countries and individuals. For each country I have a sequence of dates For France for ex...

oltre 9 anni ago | 1 answer | 0