Community Profile

photo

alpedhuez


145 total contributions since 2017

null

alpedhuez's Badges

  • Thankful Level 4

View details...

Contributions in
View by

Question


a script that joints multiple sheets in an Excel workbook
I have an Excel workbook with, let us say, 40 worksheets. Every worksheet has a format of Date Sheet1Data 5/1/2...

4 months ago | 1 answer | 0

1

answer

Question


How fast is Matlab on AWS or Cloud?
I have seen that one can Matlab on Clound and AWS. https://www.mathworks.com/cloud.html#PublicClouds I would like to get an i...

4 months ago | 0 answers | 0

0

answers

Question


Merge data from multiple XML files
I would like to merge multiple xml files into one excel spreadsheet. There is a software for this https://www.novixys.com/Exult/...

5 months ago | 0 answers | 0

0

answers

Question


writing loops to download files using Matlab websave
I want to download files of the form https://www.somecompany.com/xml/A_*.xml I can download one file using >> url = 'http...

5 months ago | 1 answer | 0

1

answer

Question


remove rows with duplicates
Consider a following spreadsheet Column 1 2 3 10 10 10 11 10 9 11 10 10 In this setting I want to delete Row 2 and Row ...

5 months ago | 1 answer | 0

1

answer

Question


download all files in a directory with some conditions
Suppose a website http://www.abc.com/xml has files of the form a01.xml, a02.xml,....,b01.xml, b02.xml,.... c01.xml, c02.xml,.......

5 months ago | 0 answers | 0

0

answers

Question


how to write a script that outerjoins multiple data files
I have files "File1.csv", "File2.csv",.... and "File33.csv". Each of 33 files has a key variable 'date'. I would need to outerjo...

5 months ago | 1 answer | 0

1

answer

Question


list of natively parallel functions in Matlab
>Yes, they will inherently use multiple cpu cores. And are able to utalize the cpu much better (some can utalize avx, some are o...

6 months ago | 0 answers | 0

0

answers

Question


How important is it to have ECC memory?
I think of getting a workstation. How important is it to have ECC memory for accuracy of computations?

9 months ago | 1 answer | 0

1

answer

Question


Live Script versus Jupyter Notebook
I would like to know further detailed comparison between Matlab Live Script and Jupyter Notebook.

1 year ago | 0 answers | 0

0

answers

Question


Saving codes in Live editor to script
I have written matlab code on Live Editor. I would like to extract these codes into a standard script. Please advise the steps. ...

1 year ago | 1 answer | 0

1

answer

Question


Livescript: putting codes and plots side-by-side
In live script I would like to force a plot always next to code (not below the code) like the attached screenshot. What will be ...

1 year ago | 0 answers | 0

0

answers

Question


Using Price2Ret to calculate Return
Suppose I have a data with the first column is Date and the second column is Price. I would like to calculate Returns using pric...

1 year ago | 1 answer | 0

1

answer

Question


Printing live script without code part
Is it possible to print a live script file without code so that readers can get output and graphics (but not code)?

1 year ago | 2 answers | 0

2

answers

Question


Expanding quarterly data to monthly data
To expand between months where data exist, one can use a variant of TT = retime(outdoors,'hourly','spline'); but suppose ...

1 year ago | 0 answers | 0

0

answers

Question


Specify a format character vector in readtable
I ran "readtable" and got a following warning. Please advise how to specify a format character vector in readtable. It was not c...

1 year ago | 2 answers | 0

2

answers

Question


Create table from excel spreadsheet with multiple sheets
Suppose I have xlsx file with multiple sheets. I want to create table A from the first sheet and create table B from the second ...

1 year ago | 2 answers | 0

2

answers

Question


Transform into a Matlab datetime format, Part 2 (Sample File Attached)
I have a column of MM_DD_YY and another column with hours (1 to 24). What is the best way to concatenate two entries to apply da...

1 year ago | 1 answer | 0

1

answer

Question


Take a difference between the value and the lagged value dealing with NaN
Suppose I have a table T such as Running Dist Swimming Dist --------------------------------------------- ...

1 year ago | 1 answer | 0

1

answer

Question


Transform into a Matlab datetime format
I have an entry "2017-10-26 06-PM" How can I transform this entry into a datetime format that Matlab can understand?

1 year ago | 1 answer | 0

1

answer

Question


Append the tabelename to a variable name in a table
I have a table T. There are variables a,b,... in T. I would like to rename variables so that their names will be T_a,T_b,...etc....

1 year ago | 1 answer | 0

1

answer

Question


"Close" all loops in a script m file
I have multiple for loop for a=1 test end for b=1 test end In an editor I can "close" the loops with ...

1 year ago | 1 answer | 0

1

answer

Question


What is the best file format to import data into Matlab?
What will be the most robust file format when one tries to import data into Matlab?

1 year ago | 2 answers | 0

2

answers

Question


Extract a table with some range of dates, Part 2
I have an attached table and then applied A=B(Periods,:); but the result is 0*2 timetable. Please advise.

1 year ago | 0 answers | 0

0

answers

Question


Remove rows with NaN from a table
I have a table T. T has some rows with NaN. I would like to remove any rows with NaN in any entry. Please advise.

1 year ago | 2 answers | 0

2

answers

Question


table2timetable: date lost in a generated timetable
I have a table that has NaN and then applied table2timetable. There were no error messages. But the resulting timetable does not...

1 year ago | 1 answer | 0

1

answer

Question


skipping code sections when running the code
Suppose I have 30 code sections and test the 23rd one. It would be cumbersome that I need to run 22 sections each time. Suppose ...

1 year ago | 2 answers | 0

2

answers

Question


Plot only for positive y
I have plot(x,y) hold on plot(x,z) hold on plot(x,w) I need to have a plot for only...

1 year ago | 1 answer | 0

1

answer

Question


Function 'subsindex' is not defined for values of class 'datetime'.
I have a simplest possible csv file but still cannot plot(test.X,test.Y) with the above message. Please advise.

1 year ago | 2 answers | 0

2

answers

Question


Removing hours and minutes from date
I have an entry 04/20/2016 00:00 I want to set it just to 04/20/2016 Please advise the steps.

1 year ago | 0 answers | 0

0

answers

Load more