How to get values with in a single string in a list without getting separated by commas in csv file using python?

Question

I have kept an input field where i can browse and select the CSV file, and decode the file and passing the values to relevant fields. The problem I am receiving now is the values like

['hello','"hello', 'world"']

The cell values in the CSV file will be like

col1  col2    col3
hello world hello,world

The code I have tried:

import base64
file_value = self.file_import.decode("utf-8")
            filename, FileExtension = os.path.splitext(self.filename)
            input_file = base64.b64decode(file_value)
            lst = []
            for loop in input_file.decode("utf-8").split("\n"):
                l = loop.replace(u'\ufeff', '')
                vals = l.replace('\r', '')
                lst.append([vals])

            #  Deletes the heading of the csv file
            lst.pop(0)

            for res in lst:
                if res[0]:
                    output = res[0].split(',')
                    print(output)

The output is:

['hello','"hello', 'world"']

But I want like:

['hello','"hello,world"']

you should use module csv to write and read CSV file - it should handle it. — furas
– furas, Commented Oct 17, 2019 at 7:42
import csv, reader = csv.reader(open(filename)) and data = list(reader) — furas
– furas, Commented Oct 17, 2019 at 8:37

Hashaam Haider · Accepted Answer · 2019-10-25 18:30:52Z

1

If you are working with the csv's in python then you must use the csv library by importing it like you imported base64.

But if you are restricted to not to use csv, there is an other solution.value = value.replace('"', '') and value = value.replace(''', '')

But this is not a better option. Better option is to use csv module

answered Oct 25, 2019 at 18:30

Hashaam Haider

213 bronze badges

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

Collectives™ on Stack Overflow

How to get values with in a single string in a list without getting separated by commas in csv file using 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