Difference between revisions of "LoadingData"
(Replaced content with "= Theory = Usually you will have data saved in some file, like Excel files, csv (comma seperated values) file or a text file. These are the most common formats in which y...") |
(→Theory) |
||
| Line 1: | Line 1: | ||
| − | = | + | = Data Sources = |
Usually you will have data saved in some file, like Excel files, csv (comma seperated values) file or a text file. These are the most common formats in which you can download data from various databases. | Usually you will have data saved in some file, like Excel files, csv (comma seperated values) file or a text file. These are the most common formats in which you can download data from various databases. | ||
| + | |||
| + | By far the easiest formats to import data into MATLAB are Excel spreadsheets and csv files. | ||
| + | |||
| + | The most common | ||
| + | |||
| + | double click on | ||
| + | |||
| + | if text data then use command line: | ||
| + | [NUM,TXT,RAW]=xlsread(FILE,SHEET) as that will save the textdata in TXT and RAW | ||
| + | |||
| + | |||
| + | == Dealing with date vectors == | ||
| + | |||
| + | When dealing with time series data you will often want to keep date information. MATLAB has excellent date functionality and dealing with data is indeed one of its strengths. There are two principle formats in which MATLAB handles dates. | ||
| + | |||
| + | # The | ||
Revision as of 19:33, 22 September 2012
Data Sources
Usually you will have data saved in some file, like Excel files, csv (comma seperated values) file or a text file. These are the most common formats in which you can download data from various databases.
By far the easiest formats to import data into MATLAB are Excel spreadsheets and csv files.
The most common
double click on
if text data then use command line:
[NUM,TXT,RAW]=xlsread(FILE,SHEET) as that will save the textdata in TXT and RAW
Dealing with date vectors
When dealing with time series data you will often want to keep date information. MATLAB has excellent date functionality and dealing with data is indeed one of its strengths. There are two principle formats in which MATLAB handles dates.
- The
