I need to delete spaces within CSV rows, then add commas to specified character locations

Question

import csv
import sys

f = open(sys.argv[1], 'rb') 

reader = csv.reader(f)

k = []

for i in reader:
    j = i.replace(' ','')
    k.append(j)

print k

the raw CSV is this

['1 323 104 564 382']
['2 322 889 564 483']
['3 322 888 564 479']
['4 322 920 564 425']
['5 322 942 564 349']
['6 322 983 564 253']
['7 322 954 564 154']
['8 322 978 564 121']

I want to make it look like this:

['1323104564382']
['2322889564483']
['3322888564479']
['4322920564425']
['5322942564349']
['6322983564253']
['7322954564154']
['8322978564121']

i get the following error:

Traceback (most recent call last): File "list_replace.py", line 12, in j = i.replace(' ','') AttributeError: 'list' object has no attribute 'replace'

Im super new at this so im probably screwing multiple things up,just need some guidance.

I eventually want the csv to look like the below text, but im taking it one step at a time

['1,323104,564382']
['2,322889,564483']
['3,322888,564479']
['4,322920,564425']
['5,322942,564349']
['6,322983,564253']
['7,322954,564154']
['8,322978,564121']

And don't forget to close your file, or use the `with` statement (https://docs.python.org/3/reference/compound_stmts.html#the-with-statement) — handle, Aug 02 '16 at 14:26

score 0 · Answer 1 · edited May 23 '17 at 12:19

0

Try this. I might be off with the slicing:

parts= i[0].split()
one=parts[0]
two=parts[1:2+1]
three=parts[3:4+1]
j= ",".join( [one,two,three] )

edited May 23 '17 at 12:19

Community

1
1

answered Aug 02 '16 at 14:19

handle

5,859
3
54
82

Binyamin Even · Accepted Answer · 2016-08-02T14:47:47.777

0

[[i[0].replace(' ','')] for i in reader]

and to get to your final goal:

reader=[[i[0].replace(' ',',',1)] for i in reader]
reader=[[i[0].replace(' ','',1)] for i in reader]
reader=[[i[0].replace(' ',',',1)] for i in reader]
reader=[[i[0].replace(' ','',1)] for i in reader]

to get:

[['1,323104,564382'],
 ['2,322889,564483'],
 ['3,322888,564479'],
 ['4,322920,564425'], 
 ['5,322942,564349'],
 ['6,322983,564253'],
 ['7,322954,564154'],
 ['8,322978,564121']]

edited Aug 02 '16 at 14:47

answered Aug 02 '16 at 14:34

Binyamin Even

3,318
1
18
45

Yes this is exactly what i needed. Now to just write the new reader to a new csv. – dergatroid Aug 02 '16 at 16:54
If this is what you needed you can accept the answer... (press on the V sign) – Binyamin Even Aug 03 '16 at 06:16

I need to delete spaces within CSV rows, then add commas to specified character locations

2 Answers2