wesso Dadoyan
Followers: 0 Following: 0
Statistics
RANK
14,412
of 295,467
REPUTATION
3
CONTRIBUTIONS
40 Questions
1 Answer
ANSWER ACCEPTANCE
60.0%
VOTES RECEIVED
3
RANK
of 20,234
REPUTATION
N/A
AVERAGE RATING
0.00
CONTRIBUTIONS
0 Files
DOWNLOADS
0
ALL TIME DOWNLOADS
0
RANK
of 153,912
CONTRIBUTIONS
0 Problems
0 Solutions
SCORE
0
NUMBER OF BADGES
0
CONTRIBUTIONS
0 Posts
CONTRIBUTIONS
0 Public Channels
AVERAGE RATING
CONTRIBUTIONS
0 Highlights
AVERAGE NO. OF LIKES
Accept 20 answers given by other contributors
Awarded to wesso Dadoyan on 20 Jul 2017
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
6 years ago | 0
Question
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...
6 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 2 answers | 0
2
answersQuestion
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 years ago | 0 answers | 0
0
answersQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 2 answers | 0
2
answersQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 2 answers | 0
2
answersQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 0 answers | 0
0
answersQuestion
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 years ago | 2 answers | 0
2
answersQuestion
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 years ago | 1 answer | 0
1
answerQuestion
finding a string in a cell array
ids1='519448(EPS1MN)' '519448(EPS2MN)' '519448(EPS3MN)' '519448(EPS4MN)' '519448(EPS5MN)' '519448(LTMD)' '519448(P)' '519...
8 years ago | 2 answers | 0
2
answersQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 2 answers | 0
2
answersQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 2 answers | 0
2
answersQuestion
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 years ago | 1 answer | 0
1
answerQuestion
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 years ago | 0 answers | 0
0
answers
You can also select a web site from the following list
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom(English)
Asia Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)