Question

Extracting data from excel spreadsheet based on shared dates

I have two spreadsheets. One has the dates for a given plant phenological event. The other has the appropriate weather data for ...

4 months ago | 1 answer | 0

Question

Convert single data to double

I have downloaded an nc weather data file and from this have downloaded the variables I need. The temperature variable has come...

7 months ago | 1 answer | 0

Answered

Recovering editor window scripts

Thanks for the response, but I did manage to find them just by searching for "matlab" in explorer and when I double clicked on t...

Recovering editor window scripts

Thanks for the response, but I did manage to find them just by searching for "matlab" in explorer and when I double clicked on t...

1 year ago | 0

Question

Recovering editor window scripts

I had a problem with my 2017b licence and was told to uninstall and reinstall the latest version. When I reinstalled the 2020a ...

1 year ago | 2 answers | 0

Question

Setting targets for ANN

The machine learning part of Matlab is quite new to me and I have looked at the examples given which seem to make sense. Howe...

2 years ago | 0 answers | 0

Question

Plotting weather graphs so subsequent years are superimposed rather than sequential

I have many years of weather data to plot. At present the data is all in one long column. But I don't want the graph to be one...

2 years ago | 1 answer | 0

Question

Summing parts of a column

I have 18 years of daily weather temperatures. I want to sum the temperatures for a specific part of the each year. How could I...

2 years ago | 1 answer | 0

Question

Averaging and summing parts of a column based on date

Greetings Matlab community I have some very large data sets and I am wanting to sum and average parts of a table column based o...

2 years ago | 2 answers | 0

Question

Change the format of an excel spreadsheet using matlab

I have numerous spreadsheets in the format of tab 2 attached, and I want to convert them to the format of the one in tab 1. Is t...

2 years ago | 2 answers | 0

Question

How to combine table vertically

I have two large tables I want to combine. They both have exactly the same column headings but different row numbers (>300) and...

2 years ago | 2 answers | 1

Question

Predict y values from x values

If x=[0 1 2 3 4 5]; and y=[0 20 60 68 77 110]; To get a linear equation I can use coefficients=polyfit(x,y,1) which gives me ...

3 years ago | 2 answers | 0

Question

Machine learning to predict yield

I am wanting to use a combination of numeric and categorical data to predict numeric data using matlab/machine learning. I'm wo...

3 years ago | 1 answer | 0

Question

Create a subtable from a larger table

Hi Everyone, I'm hoping this specific question might be useful too in other more general situations. I have some sample data...

3 years ago | 2 answers | 0

Question

Segmented regression or broken stick regression

An example of my data is as follows: xdata=[1150 1200 1263.3 1333.3 1429 1497.3 1567.8 1608.3 1643.5 1668.8]; ydata=[6.2 7.2 8...

3 years ago | 1 answer | 0

Question

Fitting data with broekn stick regression

Hi. I have some grape ripening data (sugar versus heat degrees) and want to try and fit a broken stick regression to it, and ...

3 years ago | 3 answers | 0

Question

Help with if statements

If I have a number in one table column, how do I add a new column where the numbers in the second column depend on on the first ...

3 years ago | 1 answer | 0

Question

How to get cumulative sum in yearly buckets

I have several years of data and temperature in one table. I want to calculate a cumulative temperature sum which I've done sim...

3 years ago | 4 answers | 0

Answered

Merging two categorical columns using a rule

Yes that worked with the table I sent you as you describe. I get a 42 x 1 categorical - thank you very much. I'm now just trying...

Merging two categorical columns using a rule

Yes that worked with the table I sent you as you describe. I get a 42 x 1 categorical - thank you very much. I'm now just trying...

3 years ago | 0

Answered

Merging two categorical columns using a rule

Hi, I have attached some sample data. Basically I have columns A and B but want to get column C. I couldn't quite get the me...

Merging two categorical columns using a rule

Hi, I have attached some sample data. Basically I have columns A and B but want to get column C. I couldn't quite get the me...

3 years ago | 0

Question

Merging two categorical columns using a rule

Hi, I am wanting to merge/add 2 categorical columns but need to use a rule. For example a= [Flowering not not not], b=[no...

3 years ago | 4 answers | 0

Question

Matching dates in two different tables and inserting value in separate column in second table when dates match.

I want to match a date from one table column, with a date from a second table, and when the dates match, insert a value in a sep...

3 years ago | 1 answer | 0

Question

Repeating table calculations using pairs of columns

I have a table of data and need to do repeat calculations using two columns at a time. One of the columns is always the same (D...

3 years ago | 1 answer | 0