1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>FreeMat: CSVREAD Read Comma Separated Value (CSV) File</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="dynsections.js"></script>
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
$(document).ready(initResizable);
</script>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="top"><!-- do not remove this div, it is closed by doxygen! -->
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td style="padding-left: 0.5em;">
<div id="projectname">FreeMat
</div>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end header part -->
<!-- Generated by Doxygen 1.8.1.1 -->
<div id="navrow1" class="tabs">
<ul class="tablist">
<li><a href="index.html"><span>Main Page</span></a></li>
<li class="current"><a href="pages.html"><span>Related Pages</span></a></li>
</ul>
</div>
</div><!-- top -->
<div id="side-nav" class="ui-resizable side-nav-resizable">
<div id="nav-tree">
<div id="nav-tree-contents">
</div>
</div>
<div id="splitbar" style="-moz-user-select:none;"
class="ui-resizable-handle">
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){initNavTree('io_csvread.html','');});
</script>
<div id="doc-content">
<div class="header">
<div class="headertitle">
<div class="title">CSVREAD Read Comma Separated Value (CSV) File </div> </div>
</div><!--header-->
<div class="contents">
<div class="textblock"><p>Section: <a class="el" href="sec_io.html">Input/Ouput Functions</a> </p>
<h1><a class="anchor" id="Usage"></a>
Usage</h1>
<p>The <code>csvread</code> function reads a text file containing comma separated values (CSV), and returns the resulting numeric matrix (2D). The function supports multiple syntaxes. The first syntax for <code>csvread</code> is </p>
<pre class="fragment"> x = csvread('filename')
</pre><p> which attempts to read the entire CSV file into array <code>x</code>. The file can contain only numeric values. Each entry in the file should be separated from other entries by a comma. However, FreeMat will attempt to make sense of the entries if the comma is missing (e.g., a space separated file will also parse correctly). For complex values, you must be careful with the spaces). The second form of <code>csvread</code> allows you to specify the first row and column (zero-based index) </p>
<pre class="fragment"> x = csvread('filename',firstrow,firstcol)
</pre><p> The last form allows you to specify the range to read also. This form is </p>
<pre class="fragment"> x = csvread('filename',firstrow,firstcol,readrange)
</pre><p> where <code>readrange</code> is either a 4-vector of the form <code>[R1,C1,R2,C2]</code>, where <code>R1,C1</code> is the first row and column to use, and <code>R2,C2</code> is the last row and column to use. You can also specify the <code>readrange</code> as a spreadsheet range <code>B12..C34</code>, in which case the index for the range is 1-based (as in a typical spreadsheet), so that <code>A1</code> is the first cell in the upper left corner. Note also that <code>csvread</code> is somewhat limited. </p>
<h1><a class="anchor" id="Example"></a>
Example</h1>
<p>Here is an example of a CSV file that we wish to read in</p>
<pre class="fragment"> sample_data.csv
</pre><pre class="fragment">10, 12, 13, 00, 45, 16
09, 11, 52, 93, 05, 06
01, 03, 04, 04, 90, -3
14, 17, 13, 67, 30, 43
21, 33, 14, 44, 01, 00
</pre><p>We start by reading the entire file</p>
<pre class="fragment">--> csvread('sample_data.csv')
ans =
10 12 13 0 45 16
9 11 52 93 5 6
1 3 4 4 90 -3
14 17 13 67 30 43
21 33 14 44 1 0
</pre><p>Next, we read everything starting with the second row, and third column</p>
<pre class="fragment">--> csvread('sample_data.csv',1,2)
ans =
52 93 5 6
4 4 90 -3
13 67 30 43
14 44 1 0
</pre><p>Finally, we specify that we only want the <code>3 x 3</code> submatrix starting with the second row, and third column</p>
<pre class="fragment">--> csvread('sample_data.csv',1,2,[1,2,3,4])
ans =
52 93 5
4 4 90
13 67 30
</pre> </div></div><!-- contents -->
</div><!-- doc-content -->
<!-- start footer part -->
<div id="nav-path" class="navpath"><!-- id is needed for treeview function! -->
<ul>
<li class="navelem"><a class="el" href="index.html">FreeMat Documentation</a></li><li class="navelem"><a class="el" href="sec_io.html">Input/Ouput Functions</a></li>
<li class="footer">Generated on Thu Jul 25 2013 17:17:38 for FreeMat by
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.8.1.1 </li>
</ul>
</div>
</body>
</html>
|
