How can I get a specific field of a csv file

Question

I need a way to get a specific item field  of a CSV  Say I have a CSV with 100 rows and 2 columns  comma seperated   First column emails  second column passwords  For example I want to get the password of the email in row 38  So I need only the item from 2nd column row 38     Say I have a csv file   aaaaa aaa com bbbbb ccccc ccc com ddddd   How can I get only  ddddd  for example   I m new to the language and tried some stuff with the csv module  but I don t get it

User · Answer

Finaly I got it    import csv  def select index index       csv file   open  oscar age female csv    r       csv reader   csv DictReader csv file       for line in csv reader          l   line  Index           if l    index              print line    quot Name quot      select index  11        quot Bette Davis quot

User · Answer

import csv inf   csv reader open  yourfile csv   r    for row in inf    print row 1

User · Answer

usr bin env python    Print a field specified by row  column numbers from given csv file   USAGE       prog csv filename row number column number     import csv import sys  filename   sys argv 1  row number  column number    int arg  10 -1 for arg in sys argv 2      with open filename   rb   as f       rows   list csv reader f        print rows row number  column number    Example    python print-csv-field py input csv 2 2 ddddd   Note  list csv reader f   loads the whole file in memory  To avoid that you could use itertools   import itertools       with open filename   rb   as f       row   next itertools islice csv reader f   row number  row number 1        print row column number

User · Answer

import csv mycsv   csv reader open myfilepath   for row in mycsv     text   row 1    Following the comments to the SO question here  a best  more robust code would be   import csv with open myfilepath   rb   as f      mycsv   csv reader f      for row in mycsv          text   row 1                         Update  If what the OP actually wants is the last string in the last row of the csv file  there are several aproaches that not necesarily needs csv  For example   fulltxt   open mifilepath   rb   read   laststring   fulltxt split      -1    This is not good for very big files because you load the complete text in memory but could be ok for small files  Note that laststring could include a newline character so strip it before use   And finally if what the OP wants is the second string in line n  for n 2    Update 2  This is now the same code than the one in the answer from J F Sebastian   The credit is for him    import csv line number   2      with open myfilepath   rb   as f      mycsv   csv reader f      mycsv   list mycsv      text   mycsv line number  1

User · Answer

import csv  def read cell x  y       with open  file csv    r   as f          reader   csv reader f          y count   0         for n in reader              if y count    y                  cell   n x                  return cell             y count    1  print  read cell 4  8      This example prints cell 4  8 in Python 3

User · Answer

There is an interesting point you need to catch about csv reader   object  The csv reader object is not list type  and not subscriptable    This works   for r in csv reader file obj     file not closed     print r   This does not   r   csv reader file obj   print r 0    So  you first have to convert to list type in order to make the above code work   r   list  csv reader file obj    print r 0

[python] How can I get a specific field of a csv file?

Examples related to python

Examples related to csv