Issue with reading csv files python

Question

I'm trying to read a csv file but for some reason when I ask it to print, it prints the memory address instead of the table.

Below is my result :

>>> read_table('books.csv')

['books.csv', 'boxoffice.csv', 'imdb.csv', 'olympics-locations.csv', 'olympics-results.csv', 'oscar-actor.csv', 'oscar-film.csv', 'seinfeld-episodes.csv', 'seinfeld-foods.csv']

<_csv.reader object at 0x03977C30>

This is my code :

import csv

import glob
from database import *

def read_table(name):
    '''
    (str) -> Table
    Given a file name as a string, the function will return the file as a Table
    object.
    '''
    # create a list that stores all comma-separate files(*.csv)
    files_list = glob.glob('*.csv')
    print(files_list)
    # check if the desired file is in the list
    if(name in files_list):
        # if found, open the file for reading
        with open(name) as csvfile:
            readCSV = csv.reader(csvfile, delimiter = ',')
            print(readCSV)

Something is false in my script ?

According to the documentation, csv.reader returns a reader object which will iterate over lines in the given csvfile. So in order to print the file, you should iterate over the object, for each iteration the object will return a new line of data. This line can then be printed if that is desired. — Håkon Hægland
– Håkon Hægland, Commented Nov 24, 2016 at 17:37

Henry Heath · Accepted Answer · 2016-11-24 17:34:19Z

2

Try this:

for line in readCSV:
    print(line)

See docs for a more complete example and explanation. Briefly csvreader returns an iterator object (a list is also an iterator).

edited Nov 24, 2016 at 17:34

answered Nov 24, 2016 at 17:32

Henry Heath

1,08211 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shamanth Chedde Over a year ago

Oh it worked this time. Do you know the reason why this happens?

tdelaney Over a year ago

@ShamanthChedde - you created a reader but didn't read from it. The example and referenced documentation show one way to do it. You could also do table = list(readCSV).

Januka samaranyake · Accepted Answer · 2016-11-25 05:11:36Z

0

import csv
from collections import defaultdict

col_names = defaultdict(list)

with open(filename) as f:
    reader = csv.DictReader(f) 
    for each_row in reader: 
        for (i,j) in each_row.items(): 
            col_names[i].append(j) 


print(col_names[column name])

edited Nov 25, 2016 at 5:11

answered Nov 24, 2016 at 17:39

Januka samaranyake

2,6072 gold badges34 silver badges54 bronze badges

2 Comments

yceruto Over a year ago

Please, could you explain what you try to do with your code.

Januka samaranyake Over a year ago

It will print all the data under your given column name

Collectives™ on Stack Overflow

Issue with reading csv files python

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related