Community Profile

photo

wesso Dadoyan


Attivo dal 2015

Followers: 0   Following: 0

Statistiche

  • Thankful Level 4

Visualizza badge

Feeds

Visto da

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

circa 6 anni fa | 0

Domanda


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

circa 6 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 6 anni fa | 2 risposte | 0

2

risposte

Domanda


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

oltre 6 anni fa | 0 risposte | 0

0

risposte

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 7 anni fa | 2 risposte | 0

2

risposte

Domanda


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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

circa 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 7 anni fa | 2 risposte | 0

2

risposte

Domanda


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

oltre 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 8 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 8 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 8 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 8 anni fa | 0 risposte | 0

0

risposte

Domanda


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?

quasi 8 anni fa | 2 risposte | 0

2

risposte

Domanda


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,'(...

quasi 8 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 8 anni fa | 2 risposte | 0

2

risposte

Domanda


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

quasi 8 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 8 anni fa | 2 risposte | 0

2

risposte

Domanda


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

quasi 8 anni fa | 1 risposta | 0

1

risposta

Domanda


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 ?

quasi 8 anni fa | 2 risposte | 0

2

risposte

Domanda


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

circa 8 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 8 anni fa | 0 risposte | 0

0

risposte

Carica altro