Writing CSVs With Python's "csv" Module

Hello,

What is the IDE or editor that you are using?

Robert

Hi Robert! I’m using Atom and platformio-ide-terminal for the integrated terminal at the bottom in these videos.

Thank you, I’ll check those out

Such a great tutorial, Joe - as always!

I’m not sure why, but my csv’s printed rows on every other line. I was able to fix it by adding a lineterminator to the employee_writer definition: employee_writer = csv.DictWriter(employee_file, fieldnames=fieldnames, lineterminator = '\n')

In python3 in order to work without double space you shall add:

with open('employee_file.csv', mode='w', newline='') as employee_file:

Source: Stackoverflow

Hi, I got a reply to a prior question regarding why I am getting a syntax error when I put in pip install pandas. The RP Team member, Bartosz, answered telling me what a csv file was and that any text editor can open them. Problem is that I know exactly what a CSV file is, I am using PYcharm and Thorny and on both applications, when I enter the script in this lesson, I get a syntax error. I have installed Anaconda and when I put in the entire script I get attribution error. When I debug, it says I should try calling something other than pandas. So, please explain to me what I am doing wrong since all I am doing is following the lesson plan.

Hi @sweir12525. It might be useful in this case if you copy the bottom part of the Traceback error. Just above where it says Syntax error, it’ll show you which line of code is causing the problem. It would be helpful if we could see that so we can help you further.

Thanks, Ricky. I did manage to finally figure this out after a ton of reading in Anaconda.

Added newline variable to open function to not print on every other line as other mentioned.

with open('employee_file.csv', mode='w', newline='') as employee_file:

Hi.

I received an error when trying to write a csv file with dictionary. Here is my code

with open("C:/Users/xxxx/Desktop/dictionary_file.txt",'w')as employee_file:
    fieldnames=['name','dept','birth_month']
    employee_writer=csv.DictWriter(employee_file, fieldnames=fieldnames)

    employee_writer.writeheader()
    employee_writer.writerow([{'name':'John Smith','dept':'Accounting','birth_month': 'November'}])
    employee_writer.writerow([{'name':'Erica Meyers','dept': 'IT','birth_month': 'March'}])

Here is the error I received:

---------------------------------------------------------------------------
AttributeError                            Traceback (most recent call last)
<ipython-input-26-bb18ce957124> in <module>
      4 
      5     employee_writer.writeheader()
----> 6     employee_writer.writerow([{'name':'John Smith','dept':'Accounting','birth_month': 'November'}])
      7     employee_writer.writerow([{'name':'Erica Meyers','dept': 'IT','birth_month': 'March'}])

~\anaconda3\envs\R-base\lib\csv.py in writerow(self, rowdict)
    152 
    153     def writerow(self, rowdict):
--> 154         return self.writer.writerow(self._dict_to_list(rowdict))
    155 
    156     def writerows(self, rowdicts):

~\anaconda3\envs\R-base\lib\csv.py in _dict_to_list(self, rowdict)
    145     def _dict_to_list(self, rowdict):
    146         if self.extrasaction == "raise":
--> 147             wrong_fields = rowdict.keys() - self.fieldnames
    148             if wrong_fields:
    149                 raise ValueError("dict contains fields not in fieldnames: "

AttributeError: 'list' object has no attribute 'keys'.

What do I need to do to fix? Thanks!

@Kim Unlike the regular CSV writer, the dict writer’s .writerow() method expects a dictionary and not a list:

import csv

with open("employees.csv", "w") as file:
    writer = csv.DictWriter(file, fieldnames=["name", "dept", "birth_month"])
    writer.writeheader()
    writer.writerow(
        {
            "name": "John Smith",
            "dept": "Accounting",
            "birth_month": "November",
        }
    )
    writer.writerow(
        {
            "name": "Erica Meyers",
            "dept": "IT",
            "birth_month": "March"
        }
    )

OK. Thank you! I’ll use what you have above.

Hello, I receive error : AttributeError: ‘module’ object has no attribute ‘writer’

Any suggestions.

Thanks,

When i try to repeat the example where i write a csv file with the quoting parameter set to QUOTE_ALL i have this situation

employee_writer.writerow([‘John Smith’,’Accounting’,’November’]) employee_writer.writerow([‘Erica Meyers’,’IT’,’March’])

In my new file created by the program i have these row

John Smith,”Accounting”,”November” Erica Meyers,”IT”,”March”

Why the first element is written without the ” ” ????? thanks in advance to all