How do I print a particular field from a CSV file in python?

Question

import csv
with open('doc.csv','r') as f:
                file=csv.reader(f)
                for row in file:
                      if row==['NAME']:
                               print(row)

I wanted to print all the names from a csv file in python. I tried this using this method but I got a blank output. Can anyone help me out ?

Does this answer your question? [Reading .csv through DictReader](https://stackoverflow.com/questions/32572541/reading-csv-through-dictreader) — sushanth, Aug 09 '20 at 05:49
Should I download a seperate module for that or is it inbuilt ? — vaman madhavan, Aug 09 '20 at 06:32

Juan Pablo Pisano · Accepted Answer · 2020-08-09T05:31:27.430

1

row is just a list, if you want first column from row, try:

print(row[0])

if you want all row, just

print(row[:])

if you want cells number 2 and 4:

print(row[1],row[3])

if you really want to have a better control of csv try with read_csv() pandas method:

import pandas as pd

df = pd.read_csv('AAPL.csv')
print(df['your_field_name_here'])

edited Aug 09 '20 at 05:31

answered Aug 09 '20 at 05:25

Juan Pablo Pisano

127
1
3

How do I print a particular field from a CSV file in python?

1 Answers1