# CMatlabWold

Followers: 0 Following: 0

**Statistics**

RANK**31,183**

of 289,723

REPUTATION**1**

CONTRIBUTIONS

**21** Questions

**1** Answer

ANSWER ACCEPTANCE **
76.19%
**

VOTES RECEIVED**1**

RANK

of 19,581

REPUTATION**N/A**

AVERAGE RATING**0.00**

CONTRIBUTIONS**0** Files

DOWNLOADS **0**

ALL TIME DOWNLOADS**0**

RANK

of 144,097

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

**Feeds**

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

1 year ago | 1 answer | 0

### 1

answerQuestion

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

1 year ago | 2 answers | 0

### 2

answersQuestion

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

2 years ago | 1 answer | 0

### 1

answerQuestion

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

2 years ago | 1 answer | 0

### 1

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

2 years 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,...

2 years ago | 1 answer | 0

### 1

answerQuestion

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

3 years ago | 1 answer | 0

### 1

answerQuestion

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

3 years ago | 1 answer | 0

### 1

answerQuestion

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

3 years ago | 1 answer | 0

### 1

answerQuestion

Export Command Window to Excel

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

3 years ago | 1 answer | 0

### 1

answerQuestion

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

4 years ago | 1 answer | 0

### 1

answerQuestion

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

4 years ago | 2 answers | 0

### 2

answersQuestion

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

4 years ago | 0 answers | 0

### 0

answersQuestion

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

4 years ago | 2 answers | 0

### 2

answersQuestion

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

4 years ago | 1 answer | 0

### 1

answerQuestion

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

4 years ago | 0 answers | 0

### 0

answersQuestion

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

4 years ago | 1 answer | 0

### 1

answerQuestion

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

4 years ago | 1 answer | 0

### 1

answerQuestion

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

4 years ago | 1 answer | 0

### 1

answerQuestion

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

4 years ago | 1 answer | 0

### 1

answerQuestion

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

4 years ago | 0 answers | 1

### 0

answersQuestion

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

4 years ago | 1 answer | 0