Python CSV Module

Question

I'm using the following code to learn how to read, write and analyze with a CSV file from this website http://www.whit.com.au/blog/2011/11/reading-and-writing-csv-files/. However, I get these errors,

Traceback (most recent call last): Files "csv_example.py", 
line 1, in <module? import csv
File "C:\python27\csv.py", line 11, in <module>
mywriter = csv.writer(csv_out)
AttributeError: 'module' object has no attribute 'writer'

Do you have any idea why I am getting the errors above? I'm using Notepad++ and PowerShell. I actually looked around and tried to find a CSV module for python to download but I didn't find any. I'm at a bit of a lost.

import csv

bus_numbers = ['101', '102', '36', '40']
bus_names = ['NUC_A', 'NUC_B', 'CATDOG', 'HYDRO_A']
voltage = [.99, 1.02, 1.01, 1.00]

# open a file for writing.
csv_out = open('mycsv.csv', 'wb')

# create the csv writer object.
mywriter = csv.writer(csv_out)

# all rows at once.
rows = zip(bus_numbers, bus_names, voltage)
mywriter.writerows(rows)

# always make sure that you close the file.
# otherwise you might find that it is empty.
csv_out.close()

On a sidenote, I am interesting in good tutorials on how to read, write and use CSV files in python.

The official Python documentation has a well elaborated section on csv module — Tharindu Rusira
– Tharindu Rusira, Commented Oct 15, 2013 at 2:20

Lie Ryan · Accepted Answer · 2013-10-15 01:57:55Z

11

This is a common error. Rename your script from csv.py to something else; it will try to import itself when you do import csv.

answered Oct 15, 2013 at 1:57

Lie Ryan

65.3k14 gold badges103 silver badges151 bronze badges

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

Collectives™ on Stack Overflow

Python CSV Module

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related