Newlines in CSV data - Python

Question

The following block of code is my attempt at making a CSV filled with data about employees but I've noticed that newlines characters at the end of the last header and its respective data are messing with my searches in the data.

I've tried to use 'ab' instead of 'a' but I get a Type error asking for a bytes-type object and not a str type.

def write_csv(emp_json, licenseName):
    filePath='C:\Scripts\Python\data.csv'
    data = open(filePath, 'a') 
    csvwriter = csv.writer(data)
    count = 0
    for emp in emp_json:
        emp.update({'licenseName':licenseName})
        if count == 0:
            header = emp.keys()
            csvwriter.writerow(header)
            count += 1
        csvwriter.writerow(emp.values())
    data.close()

Any info on how to remove all newline characters from the headers and the data? Or how to create the data without newlines in the first place? Please comment if you need more information and context.

Thanks

You want to remove the newlines from the CSV file you're writing? — user2988908
– user2988908, Commented Aug 21, 2017 at 20:53
Are the newline characters in the emp_json dict you are writing to the CSV file? e.g. emp['licenseName'] = 'someLicense\n' — Tom Sitter
– Tom Sitter, Commented Aug 21, 2017 at 20:54

Mohamed Ali JAMAOUI · Accepted Answer · 2017-08-21 20:57:05Z

1

If want no newlines, add newline="" as parameter to open(...):

def write_csv(emp_json, licenseName):
    filePath='C:\Scripts\Python\data.csv'
    with open(filePath, 'a', newline="") as data: 
       csvwriter = csv.writer(data)
       count = 0
       for emp in emp_json:
           emp.update({'licenseName':licenseName})
           if count == 0:
               header = emp.keys()
               csvwriter.writerow(header)
               count += 1
           csvwriter.writerow(emp.values())

PS: use with open(..) for writing to csv it takes care of opening and closing the file for you.

answered Aug 21, 2017 at 20:57

Mohamed Ali JAMAOUI

14.8k14 gold badges79 silver badges124 bronze badges

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

Collectives™ on Stack Overflow

Newlines in CSV data - Python

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