The latest articles on DEV Community by Jarod Chen (@jarodchen). https://dev.to/jarodchen https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F417513%2F6b0a3155-1347-4e86-b4d9-f42e3ecc1b27.jpeg https://dev.to/jarodchen en Jarod Chen Sun, 28 Jun 2020 08:47:13 +0000 https://dev.to/jarodchen/how-to-read-csv-file-in-python-4lja https://dev.to/jarodchen/how-to-read-csv-file-in-python-4lja <h1> It's a simple way to read CSV file in Python. </h1> <h2> 1. Read csv </h2> <p>filename: example.csv<br> </p> <div class="highlight"><pre class="highlight python"><code><span class="kn">import</span> <span class="nn">csv</span> <span class="k">with</span> <span class="nb">open</span><span class="p">(</span><span class="s">'example.csv'</span><span class="p">,</span> <span class="n">newline</span><span class="o">=</span><span class="s">''</span><span class="p">)</span> <span class="k">as</span> <span class="n">csvfile</span><span class="p">:</span> <span class="n">rows</span> <span class="o">=</span> <span class="n">csv</span><span class="p">.</span><span class="n">reader</span><span class="p">(</span><span class="n">csvfile</span><span class="p">)</span> <span class="k">for</span> <span class="n">row</span> <span class="ow">in</span> <span class="n">rows</span><span class="p">:</span> <span class="k">print</span><span class="p">(</span><span class="n">row</span><span class="p">)</span> </code></pre></div> <h2> 2. Read csv in Dictionary </h2> <p>If there are data of following format:<br> Date ,Open, Close<br> 2020/01/01, 100, 200<br> 2020/01/02, 120, 200<br> You can fetch specific column by csv.DictReader.<br> </p> <div class="highlight"><pre class="highlight python"><code><span class="kn">import</span> <span class="nn">csv</span> <span class="k">with</span> <span class="nb">open</span><span class="p">(</span><span class="s">'example.csv'</span><span class="p">,</span> <span class="n">newline</span><span class="o">=</span><span class="s">''</span><span class="p">)</span> <span class="k">as</span> <span class="n">csvfile</span><span class="p">:</span> <span class="n">rows</span> <span class="o">=</span> <span class="n">csv</span><span class="p">.</span><span class="n">DictReader</span><span class="p">(</span><span class="n">csvfile</span><span class="p">)</span> <span class="k">for</span> <span class="n">row</span> <span class="ow">in</span> <span class="n">rows</span><span class="p">:</span> <span class="k">print</span><span class="p">(</span><span class="n">row</span><span class="p">[</span><span class="s">'Date'</span><span class="p">],</span> <span class="n">row</span><span class="p">[</span><span class="s">'Close'</span><span class="p">])</span> </code></pre></div> python