CMatlabWold
Followers: 0 Following: 0
Feeds
提问
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 前 | 1 个回答 | 0
1
个回答提问
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 前 | 2 个回答 | 0
2
个回答提问
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 前 | 1 个回答 | 0
1
个回答提问
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...
3 years 前 | 1 个回答 | 0
1
个回答已回答
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...
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...
3 years 前 | 0
| 已接受
提问
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,...
3 years 前 | 1 个回答 | 0
1
个回答提问
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 前 | 1 个回答 | 0
1
个回答提问
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 ...
4 years 前 | 1 个回答 | 0
1
个回答提问
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...
4 years 前 | 1 个回答 | 0
1
个回答提问
Export Command Window to Excel
Hi, I am pasting part of my code: X = [PRCP Catch Back Manhole Break]; y = Street; b4_default = stepwisefit...
4 years 前 | 1 个回答 | 0
1
个回答提问
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 前 | 1 个回答 | 0
1
个回答提问
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 前 | 2 个回答 | 0
2
个回答提问
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 前 | 0 个回答 | 0
0
个回答提问
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 前 | 2 个回答 | 0
2
个回答提问
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 前 | 1 个回答 | 0
1
个回答提问
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 前 | 0 个回答 | 0
0
个回答提问
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 前 | 1 个回答 | 0
1
个回答提问
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 前 | 1 个回答 | 0
1
个回答提问
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 前 | 1 个回答 | 0
1
个回答提问
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 前 | 1 个回答 | 0
1
个回答提问
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 前 | 0 个回答 | 1
0
个回答提问
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 ...
5 years 前 | 1 个回答 | 0