python AttributeError: 'NoneType' object has no attribute 'replace' in list

Question

#@ Row 1, Column 4: Invalid character value for cast specification @#

BCC,01,12697,2013-12- 12,1.0,2014004,CR,ACCOUN TS PAYABLE,-86.23000,,2200-000-000,, ,,,,True,,0,False,,,False,,,,,,0.00000,0.00000

I am trying to remove the tab in the date value and elsewhere in each row of data.

columndata = [str(items.replace('\t', '')) for items in list(row)]

However, this command returns the following error:

  File "apdetfac.py", line 60, in <listcomp>
  columndata = [str(items.replace('\t', '')) for items in list(row)]
  AttributeError: 'NoneType' object has no attribute 'replace'

I tried converting items to str as follows str(items) in list(row) but that generated another error. What to do?

there might be missing values in your date column. Try [str(items.replace('\t', '')) if items else items for items in list(row)] Also, what is the row object? Is it 1 row of data? In that case you are not looping properly — Vivek Kalyanarangan
– Vivek Kalyanarangan, Commented Feb 6, 2018 at 12:09
It is data from Progress extracted using pyodbc. Im looping on for row in data: — user1082748
– user1082748, Commented Feb 6, 2018 at 12:13
This is what I get now: AttributeError: 'bool' object has no attribute 'replace' — user1082748
– user1082748, Commented Feb 6, 2018 at 12:15

quamrana · Accepted Answer · 2018-02-06 12:34:57Z

1

Its difficult to tell what data you have, but this gives the right sort of answer:

row_str = 'BCC,01,12697,2013-12-\t12,1.0,2014004,CR,ACCOUN\tTS PAYABLE,-86.23000,,2200-000-000,, ,,,,True,,0,False,,,False,,,,,,0.00000,0.00000'
# note the '\t' in date and ACCOUNTS

row = row_str.split(',')

columndata = [str(items.replace('\t', '')) for items in row]

print(columndata)

Output:

['BCC', '01', '12697', '2013-12-12', '1.0', '2014004', 'CR', 'ACCOUNTS PAYABLE', '-86.23000', '', '2200-000-000', '', ' ', '', '', '', 'True', '', '0', 'False', '', '', 'False', '', '', '', '', '', '0.00000', '0.00000']

Of course this list can be joined back into a string:

new_row = ','.join(columndata)
print(new_row)

Output:

BCC,01,12697,2013-12-12,1.0,2014004,CR,ACCOUNTS PAYABLE,-86.23000,,2200-000-000,, ,,,,True,,0,False,,,False,,,,,,0.00000,0.00000

edited Feb 6, 2018 at 12:34

answered Feb 6, 2018 at 12:18

quamrana

39.6k13 gold badges57 silver badges77 bronze badges

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

3 Comments

user1082748 Over a year ago

rowStr = row.split(',') AttributeError: 'pyodbc.Row' object has no attribute 'split'

user1082748 Over a year ago

I converted row.split to str(row).split and rest of remains the same and it appears to be working.

user1082748 Over a year ago

Will you all know in a few once the million plus rows are processed. thanks for your help.

Veera Balla Deva · Accepted Answer · 2018-02-06 12:25:00Z

0

data = "'BCC,01,12697,2013-12-\t12,1.0,2014004,CR,ACCOUN\tTS PAYABLE,-86.23000,,2200-000-000,, ,,,,True,,0,False,,,False,,,,,,0.00000,0.00000'"

print(','.join(map(lambda x: x.replace('\t',''), data.split(','))))
>>>'BCC,01,12697,2013-12-12,1.0,2014004,CR,ACCOUNTS PAYABLE,-86.23000,,2200-000-000,, ,,,,True,,0,False,,,False,,,,,,0.00000,0.00000'

answered Feb 6, 2018 at 12:25

Veera Balla Deva

7886 silver badges19 bronze badges

Collectives™ on Stack Overflow

python AttributeError: 'NoneType' object has no attribute 'replace' in list

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related