Reading rows from a CSV file in Python

by

Use the csv module:

import csv

with open("test.csv", "r") as f:
    reader = csv.reader(f, delimiter="\t")
    for i, line in enumerate(reader):
        print 'line[{}] = {}'.format(i, line)

Output:

line[0] = ['Year:', 'Dec:', 'Jan:']
line[1] = ['1', '50', '60']
line[2] = ['2', '25', '50']
line[3] = ['3', '30', '30']
line[4] = ['4', '40', '20']
line[5] = ['5', '10', '10']

More Related Contents:

  1. Update a CSV file?
  2. Writing a Python list of lists to a csv file
  3. How do I read and write CSV files with Python?
  4. How to write to an Excel spreadsheet using Python?
  5. How to get rid of “Unnamed: 0” column in a pandas DataFrame read in from CSV file?
  6. Python convert csv to xlsx
  7. CSVWriter not saving data to file the moment I write it
  8. Python CSV to SQLite
  9. Save Dataframe to csv directly to s3 Python
  10. How to obtain the total numbers of rows from a CSV file in Python?
  11. Writing to CSV with Python adds blank lines [duplicate]
  12. pandas DataFrame output end of csv
  13. Panda’s Write CSV – Append vs. Write
  14. Loading multiple csv files of a folder into one dataframe
  15. pyqt – populating QTableWidget with csv data
  16. Row count in a csv file
  17. Why can’t I repeat the ‘for’ loop for csv.Reader?
  18. Use python requests to download CSV
  19. IndexError: too many indices for array
  20. Proper way to reset csv.reader for multiple iterations?
  21. CSV reader behavior with None and empty string
  22. AttributeError: ‘module’ object has no attribute ‘reader’ [duplicate]
  23. Strip white spaces from CSV file
  24. Pandas to_csv call is prepending a comma
  25. Get data from Twitter using Tweepy and store in csv file
  26. Opening csv file in Python using Flask
  27. How to add a new column to the beginning of the rows of a CSV file?
  28. Python Parse CSV Correctly
  29. start index at 1 for Pandas DataFrame
  30. Bin values based on ranges with pandas [duplicate]

Leave a Comment