Python - Remove elements from a list

Question

I have a list in Python and I want to replace certain elements in it, already try to use the replace mode I found in the documentation, but I did not succeed because it cannot be used in lists.

I have a list as follows.

Mylist = ['Ford"~"Fiat"~"Ka"~"Palio']

This list is composed of a single element, using the function Len(line) it returns me the value 1.

I need to treat this line to get out the following way.

NewList= ['Ford','Fiat','Ka','Palio']

I’m trying in many ways and I’m not getting the expected result.

My code:

encoding='utf-8'

import csv

NewMatriz = []


ficheiro = open('C:\\Users\\asus\\Documents\\models.csv', 'r', newline='', encoding="utf8")
reader = csv.reader(ficheiro)


for item in reader:
    NewMatriz.append(item.replace('"','').split('~'))

Answer 1

One way to do this is to remove double quotes with the function replace and turn the string into an array with the function split on the basis of (~):

#Lista simples
Mylist = ['Ford"~"Fiat"~"Ka"~"Palio']

NewList = Mylist[0].replace('"','').split('~')

print(NewList)

#Lista matriz

#Com loop
NewMatriz = []

for item in Mylist:
  NewMatriz.append(item.replace('"','').split('~'))

print(NewMatriz)

#Com map/lambda
NewMapList = []

NewMapList = map(lambda x: x.replace('"','').split('~'), Mylist)
print(list(NewMapList))

In the other examples, I created one within another, just to illustrate that there may be other forms, but with slightly different results, but it can be useful in its resolution.

---

Working with the CSV:

encoding='utf-8'

import csv

NewMatriz = []

ficheiro = open('C:\\Users\\asus\\Documents\\models.csv', 'r', newline='\n', encoding="utf8")
reader = csv.reader(ficheiro)

for line in reader:
  for item in line:
    NewMatriz.append(item.replace('"','').split('~'))

print(NewMatriz)

Answer 2

Searches the csv.Reader documentation for any arguments you can use to reset the field separator. I use the pandas library and the read_csv function, which I find much more friendly. In it, you can define the argument "Sep" that identifies in the reading of the file which character is being used to separate the fields. In your example, to be the "~". Another possibility is that the encoding is not right. Maybe it is reading "~" when it is actually a ";". Try encoding "latin" or "latin1" and see if the output is different.