python parsing string to csv format

Question

I have a file containing a line with the following format

aaa=A;bbb=B;ccc=C

I want to convert it to a csv format so the literals on the equation sides will be columns and the semicolon as a row separator. I tried doing something like this

 f = open("aaa.txt", "r")
    with open("ccc.csv", 'w') as csvFile:
        writer = csv.writer(csvFile)
        rows = []
        if f.mode == 'r':
            single = f.readline()
            lns = single.split(";")
            for item in lns:
                rows.append(item.replace("=", ","))
            writer.writerows(rows)
            f.close()
            csvFile.close()

but I am getting each letter as a column so the result looks like :

a,a,a,",",A
b,b,b,",",B
c,c,c,",",C,"

The expected result should look like

aaa,A
bbb,B
ccc,C

mutux · Accepted Answer · 2019-04-26 15:33:58Z

2

Just write the strings into the target file line by line:

import os
f = open("aaa.txt", "r")
with open("ccc.csv", 'w') as csvFile:
    single = f.readline()
    lns = single.split(";")
    for item in lns:
        csvFile.write(item.replace("=", ",") + os.linesep)
f.close()

The output would be:

aaa,A
bbb,B
ccc,C

edited Apr 26, 2019 at 15:33

answered Apr 26, 2019 at 15:28

mutux

3623 silver badges12 bronze badges

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

Comments

Aditya Patel · Accepted Answer · 2019-04-26 15:39:39Z

1

The following 1 line change worked for me:

rows.append(item.split('='))

instead of the existing code

rows.append(item.replace("=", ",")).

That way, I was able to create a list of lists which can easily be read by the writer so that the row list looks like [['aaa', 'A'], ['bbb', 'B'], ['ccc', 'C']]instead of ['aaa,A', 'bbb,B', 'ccc,C']

answered Apr 26, 2019 at 15:39

Aditya Patel

1681 gold badge1 silver badge11 bronze badges

Comments

Serge Ballesta · Accepted Answer · 2019-04-26 15:29:55Z

It helps to interactively execute the commands and print the values, or add debug print in the code (that will be removed or commented when everything works). Here you could have seen that rows is ['aaa,A', 'bbb,B', 'ccc,C'] that is 3 strings when it should be three sequences.

As a string is a (read only) sequence of chars writerows uses each char as a field.

So you do not want to replace the = with a comma (,), but want to split on the equal sign:

        ...
        for item in lns:
            rows.append(item.split("=", 1))
        ...

But the csv module requires for proper operation the output file to be opened with newline=''.

So you should have:

with open("ccc.csv", 'w', newline='') as csvFile:
    ...

Eugene Yarmash · Accepted Answer · 2019-04-27 09:32:29Z

0

The parameter to writer.writerows() must be an iterable of rows, which must in turn be iterables of strings or numbers. Since you pass it a list of strings, characters in the strings are treated as separate fields. You can obtain the proper list of rows by splitting the line first on ';', then on '=':

import csv

with open('in.txt') as in_file, open('out.csv', 'w') as out_file:
    writer = csv.writer(out_file)
    line = next(in_file).rstrip('\n')
    rows = [item.split('=') for item in line.split(';')]
    writer.writerows(rows)

edited Apr 27, 2019 at 9:32

answered Apr 26, 2019 at 15:26

Eugene Yarmash

152k44 gold badges346 silver badges391 bronze badges

Collectives™ on Stack Overflow

python parsing string to csv format

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related