wesso Dadoyan

2015년부터 활동

Followers: 0 Following: 0

통계학

Feeds

답변 있음
Importing to matlab a set of data with the same structure across multiple sheets
sorry the file wasn't attached in the previous post

거의 7년 전 | 0

질문

Importing to matlab a set of data with the same structure across multiple sheets
Normally, I don't post such questions since I clean the data in excel first before importing to matlab. However, I have many fil...

거의 7년 전 | 답변 수: 1 | 0

1

답변

질문

Comparing first n digits
Hi , I have two columns of numbers A and B. A is 9 digits and B is 8 digits. How can I find the row in B that matches A(i) in...

대략 7년 전 | 답변 수: 1 | 0

1

답변

질문

Concatenating horizontally two cell arrays
Hi, A{1,1}=00016510; B{1,1}=0; C=horzcat(A{1,1},B{1,1});% is giving C=00016510 (1x9 char although 8 digits appear) ...

대략 7년 전 | 답변 수: 1 | 0

1

답변

질문

Left 6 digits of a 9 digit number that could be incomple
I have a column of 9 digit numbers that I want to trim to the left 6 digits.For example,931146104 should be 931146. Sometimes fo...

대략 7년 전 | 답변 수: 2 | 0

2

답변

질문

inner join with a conditional statement
Hi, I have an id that could pertain to two different companies depending on the date of the observation. For example id=1 cou...

대략 7년 전 | 답변 수: 0 | 0

0

답변

질문

How to make matlab start by opening a folder than doesn't have a matlab folder as a root
Hi, I want matlab to open a folder C:\Users\w\Documents\paper1 automatically when I start it instead of manually searching th...

대략 7년 전 | 답변 수: 1 | 0

1

답변

질문

innerjoin error and potential matching questions
Hi, 1. I am matching two tables based on ticker but i receive the following error Error using tabular/innerjoin (line 10...

대략 7년 전 | 답변 수: 1 | 0

1

답변

질문

find observations with nonconsecutive numbers
A=[55; 56; 57; 58; 26; 27; 28] I want to find the observations in A where the two consecutive observations are not equa...

7년 초과 전 | 답변 수: 2 | 0

2

답변

질문

Faster codes in a loop
Hi, I have a sequence of dates and firms. For each firm I want to compute the median return on equity for the peers that are ...

7년 초과 전 | 답변 수: 1 | 0

1

답변

질문

Finding the relationship between three columns
I have a data set (attached in zip) downloaded from a database. the first column(date)is the dates column, the second is the id ...

7년 초과 전 | 답변 수: 1 | 0

1

답변

질문

writetable function doesn't produce any output
The code: writetable(t3,'C:\Users\w) is not producing any output. Any reason for that? (I am attaching the file that con...

7년 초과 전 | 답변 수: 1 | 0

1

답변

질문

Leaping loop with constant rows for each identity
I have a vector where the first 80 rows belong to a company, the 2nd 80 to another company ... last 80 rows belong to company N ...

대략 8년 전 | 답변 수: 1 | 0

1

답변

질문

using find(ismember) instead of a loop?
I have matrix B which is has around 1 million rows and Matrix A which has 800,000 rows. I want to match the observations of A a...

대략 8년 전 | 답변 수: 1 | 0

1

답변

질문

converting number to date number
I have a column of dates that are number (double format) such as 19940127 how can i convert it to matlab numeric date that corr...

대략 8년 전 | 답변 수: 2 | 0

2

답변

질문

Find index of cells containing a string
Hi , Attached the "text" cell array. I tried to find the index of cells that match the string 'CERT'. I tried many approaches...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

How to download the mat files of examples provided by Matlab
Hi, I was looking at the MACD function in matlab . In the example they report the following: This example shows how to compu...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

textscan formatting to import a large text file
fid = fopen(FileToLoad,'rt'); data = textscan(fid, colFormats,'HeaderLines',1,'Delimiter','\t'); fclose(fid) I have a...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

importing selected columns of text files with headers where the missing value is a dot
I have many files that are large where the first row is a header row. The files are tab delimited and I want to import only sele...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

Aggregating selected variables from multiple mat files
I have 276 mat files (each corresponds to a month for a specific year starting 1993 till 2015). In these files I have numeric ve...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

getting excel variable in a loop
Folder=pwd; d = dir('bhcf*.xlsx'); N_File=numel(d); e = actxserver ('Excel.Application'); h=waitbar(0,'Progress......

8년 초과 전 | 답변 수: 0 | 0

0

답변

질문

Forcing fsolve to be positive
ire = fsolve(@(re) Pgls(P,BV0,FROE,B,re),re0); is their a way to force fsolve to return a positive ire?

8년 초과 전 | 답변 수: 2 | 0

2

답변

질문

finding a string with parentheses using regexp
A={'5123(P)';'5123 ESP'} how can i search A to find the cell that has the '(P)' string? find(~cellfun(@isempty,regexp(A,'(...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

finding a string in a cell array
ids1='519448(EPS1MN)' '519448(EPS2MN)' '519448(EPS3MN)' '519448(EPS4MN)' '519448(EPS5MN)' '519448(LTMD)' '519448(P)' '519...

8년 초과 전 | 답변 수: 2 | 0

2

답변

질문

Removing duplicate observations in a Matrix where the rows are not completely identical
Hi, I have Matrix A, where many rows are like in the attached image. column 1 is the id of the company and column 2 is the d...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

Input A of class cell and input B of class double must be cell arrays of strings, unless one is a string
A= 89830410 50590220 '33762X10' '02837P30' 57832110 '25037Y10' 13063010 '09972F10' ...

8년 초과 전 | 답변 수: 2 | 0

2

답변

질문

joint find statement using ismember & ~ismember
Hi, I wrote the following code: xe=find(ismember(ID,IDA) & ~ismember(DateID,DateIDA)); but it is failing to capture what I ...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

replace any nan value in the table by zero
I have a 34420x229 table I want to replace any nan value in the table by zero. how can I do so ?

8년 초과 전 | 답변 수: 2 | 0

2

답변

질문

Appending variables from different mat files
Hi, I have many mat files that contain the same variables. Is there any function that would help me to append these variables...

8년 초과 전 | 답변 수: 1 | 0

1

답변

질문

strange output when using writetable function
t=table(x,y,ID) %x,y are vectors, ID is cell array writetable(t,'Data.xlsx'); I am getting for ID an output which ID_...

거의 9년 전 | 답변 수: 0 | 0

0

답변

wesso Dadoyan

통계학

Thankful Level 4

MATLAB Answers

Feeds

1

1

1

2

0

1

1

2

1

1

1

1

1

2

1

1

1

1

1

0

2

1

2

1

2

1

2

1

0