How to write a python function for csv writer

Question

I have the following code that works fine:

with open('userWithAgentProp.csv','w+') as f:
        w = csv.DictWriter(f,user_keys)
        w.writeheader()
        for user in userAgentProp_list:
            w.writerow(user)

I used this code to write a function:

def createCSVOutput(fileName, keys, listOfLists):
    with open(fileName, 'w+') as f:
        w= csv.dictWriter(f, keys)
        w.writeheader()
        for row in listOfLists:
            w.writerow(row)

When I call the function:

createCSVOutput('new_test_csv.csv', user_keys, userAgentProp_list)

I get the following error:

File "mongodb_script_2.py", line 101, in <module>
  createCSVOutput('new_test_csv.csv', user_keys, userAgentProp_list)
File "mongodb_script_2.py", line 54, in createCSVOutput
  w= csv.dictWriter(f, keys)
AttributeError: 'module' object has no attribute 'dictWriter'

Why does it work for user_keys variable in the script, but not in the function?

You probably have something shadowing the csv name. Consider posting more code (or just look for what could be causing it). — Thomas Orozco
– Thomas Orozco, Commented Apr 29, 2015 at 21:42

Celeo · Accepted Answer · 2015-04-29 21:44:56Z

2

You have a typo:

csv.dictWriter is wrong. It should be csv.DictWriter.

edited Apr 29, 2015 at 21:44

Celeo

5,7138 gold badges41 silver badges44 bronze badges

answered Apr 29, 2015 at 21:43

tanaydin

5,32632 silver badges50 bronze badges

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

1 Comment

tanaydin Over a year ago

everybody can do such as mistake.

Collectives™ on Stack Overflow

How to write a python function for csv writer

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related