photo

CMatlabWold


Last seen: meer dan een jaar ago |  Active since 2020

Followers: 0   Following: 0

Statistics

  • Thankful Level 3

View badges

Feeds

View by

Question


Extract each column in excel spreadsheet and create new workbook with header as spreadsheet name
Hello. I have a spreadsheet, "CatchCount1.xlsx", and in the spreadsheet, the first column header is "date", and the following co...

meer dan een jaar ago | 1 answer | 0

1

answer

Question


Loop Code Through Each Row of Excel Spreadsheet and Save Result Matrix
I haven't been on MATLAB for a while. I suppose I am very rusty. But I have a spreadsheet, and there are two columns of interest...

meer dan een jaar ago | 2 answers | 0

2

answers

Question


Keeping spreadsheet name as column header when looping through multiple excel files
Hi. I have a code where I am extracting the second column of all spreadsheets in my folder and putting them into one new spreads...

meer dan 2 jaar ago | 1 answer | 0

1

answer

Question


Calculate the Median of the results from 100 Simulations
Hi. I have a code where I am running a Random Forest regression. I am running it 100 times. However, I am having difficulty calc...

ongeveer 3 jaar ago | 1 answer | 0

1

answer

Answered
Keep Headers in Loop and Skip Errors
I figured out the first two. For the last, I believe I will use an excel merge type of function I added Mdl.PredictorNames. And...

ongeveer 3 jaar ago | 0

| accepted

Question


Keep Headers in Loop and Skip Errors
Hi. I have two issues with my loop, and I'd appreciate any help. First I am creating excel files for impOOB results. However,...

ongeveer 3 jaar ago | 1 answer | 0

1

answer

Question


Need Predictor Importance in Random Forest Expressed as a Percentage
Hi. I'm running a code to see the importance of demographics (Predictors) on my response (Complaints). I need to express the imp...

meer dan 3 jaar ago | 1 answer | 0

1

answer

Question


How to Prevent Lowess 3D Curve From Dipping into Negative Values
Hi, I have a code. The Z value represents total complaints. When I run the code to get a 3D scatterplot with Lowess curve, the ...

ongeveer 4 jaar ago | 1 answer | 0

1

answer

Question


Keeping Headers When Import Excel Then Running Code and Exporting
I have a code which will scale the data I have from each excel files in a folder director. Then, after the data is scaled, the c...

ongeveer 4 jaar ago | 1 answer | 0

1

answer

Question


Export Command Window to Excel
Hi, I am pasting part of my code: X = [PRCP Catch Back Manhole Break]; y = Street; b4_default = stepwisefit...

meer dan 4 jaar ago | 1 answer | 0

1

answer

Question


Running the Same code for Multiple Files in a Folder
Hi, tt10001 = readtable('10001.xlsx'); dsa = tt10001; modelspec = 'Street ~ Catch*BackUp*PRCP - Catch:BackUp:Break:Manhol...

meer dan 4 jaar ago | 1 answer | 0

1

answer

Question


Combining Spreadsheets to Create a Table in Matlab
Hello, I have 4 spreadsheets, which have different data for zip codes. I want to create one spreadsheet for each zip code, wh...

meer dan 4 jaar ago | 2 answers | 0

2

answers

Question


Putting Timetables Together to Create One Large Table
Hi, I have a code. And I want to put the columns of timetables sequentially. For instance, in my code produces these timetab...

meer dan 4 jaar ago | 0 answers | 0

0

answers

Question


Heat (or color coded Map) in Matlab
Hello, I am creating a heatmap in Matlab. For each Sewershed, there is a median income. It is in the shapefile. When I produce ...

meer dan 4 jaar ago | 2 answers | 0

2

answers

Question


Semilog x axis for Scatter Plot
Hi, I am trying to plot points, with the x-axis in log scale. This is my code ss0 = readtable('MedianBeta.xlsx') x = ss0{:,2}...

meer dan 4 jaar ago | 1 answer | 0

1

answer

Question


Creating a Loop to Incorporate all Tables into One Code
Hi, I am trying to create loops. I have a code, where I am summing weekly complaints: %2010 tt0 = readtable('BackUpbySS1.xls...

meer dan 4 jaar ago | 0 answers | 0

0

answers

Question


Calculate if statement based on date
Hello, I have a spreadsheet. In column A, are the dates. In column E, I have the precipitation values. I need to sum cert...

meer dan 4 jaar ago | 1 answer | 0

1

answer

Question


Label Polygons in Mapshow
Hi I have a shapefile of zip codes of NYC. When I use the code, I get this pic and a structure is created, where zip codes are ...

meer dan 4 jaar ago | 1 answer | 0

1

answer

Question


Scatter Plot only Non-Zero Set of Points
Hi, I suppose... Let's say, once you make two tables of values and you decide create a scatter plot, where the row values of o...

meer dan 4 jaar ago | 1 answer | 0

1

answer

Question


Removing a Date (Leap Year) from being Averaged
Hi,. I have a code. The data takes place over 10 years. And I need the average for each day of the year: 1-365. I think everyt...

meer dan 4 jaar ago | 1 answer | 0

1

answer

Question


Once Shapefile is uploaded, How to use longitude and latitude data
I created a shapefie from a portal item in Arc GIS. So, on Matlab, I have this map: The shapefile I have is called "Sewersh...

meer dan 4 jaar ago | 0 answers | 1

0

answers

Question


Count Occurrences of a Variable from Excel per Chronological Date
I have a spreadsheet with complaints made from one of three locations on a variety of dates from 1/1/2010 to 12/31/2018. I need ...

bijna 5 jaar ago | 1 answer | 0

1

answer