I have this tsv file and i want to remove the ; from the list but it keeps giving me an error message 'AttributeError: 'list' object has no attribute 'split''
import csv
h = []
with open('paths_finished.tsv', 'rb') as csvfile:
ar = csv.reader(csvfile, dialect='excel-tab')
for row in ar:
h.append(row[3:4].split(';'))
print h
output:
['14th_century;15th_century;16th_century]
How do i split the ';' in this output?
row is a list, so the slice row[3:4] is also a list.
You should just use row[3] to get the (string) item from the list
for row in ar:
h.append(row[3].split(';'))
You may also use a list comprehension
import csv
with open('paths_finished.tsv', 'rb') as csvfile:
ar = csv.reader(csvfile, dialect='excel-tab')
h = [row[3].split(';') for row in ar if len(row) > 3]
print h
if len(row) > 3 to prevent thatYou can do:
>>> my_output = ['14th_century;15th_century;16th_century'] #this is your current output
>>> print my_output[0].split(';')
['14th_century', '15th_century', '16th_century']
This takes the first element of your output above and then prints the list based on the string split on ';'
try this ,
>>> ''.join(a)
'14th_century;15th_century;16th_century'
>>> a=''.join(a)
>>> a
'14th_century;15th_century;16th_century'
>>> a.split(';')
['14th_century', '15th_century', '16th_century']
