Remove ")" from cells in list if ")" exists

Question

Could you please tell me how can I remove ")" from strings in a list without converting the list to a string? Example:

Input:

list =[
 'ABDDDDC 1,000 IWJBCKNBCDVV',
 'BDISJBJ 2,000 DBFIAJDBDIAJ',
 'JDBISJB 5,000 AHSBIEFEWEFJ)', # there is a parenthesis at the end
 'CONDDDD 7,000 4DJVBDISJEVV)'] # there is a parenthesis at the end

Expected output:

list =[
 'ABDDDDC 1,000 IWJBCKNBCDVV',
 'BDISJBJ 2,000 DBFIAJDBDIAJ',
 'JDBISJB 5,000 AHSBIEFEWEFJ', # parenthesis is removed
 'CONDDDD 7,000 4DJVBDISJEVV'] # parenthesis is removed

I know how to do it by converting list to str like following:

a = str(list)
a = a.replace(")","")
print(a)

However, since I need convert it to a dataframe later... I want to keep it as list. Please let me know if you need any clarificaiton for my question. This is my first time to post a question.

Does this answer your question? Replace function in list of strings — gre_gor
– gre_gor, Commented Nov 25, 2022 at 3:45
OP upı should accept one of the answers. You asked for help. They helped... — niaei
– niaei, Commented Nov 25, 2022 at 10:10
[item.rstrip(")") for item in list] if you only want to eliminate the ")" at the end. And don't use list as variable name, you're overriding a builtin function. — Timus
– Timus, Commented Nov 25, 2022 at 15:45

Tim Biegeleisen · Accepted Answer · 2022-11-25 03:39:51Z

1

You may use a list comprehension here:

inp = ['ABDDDDC 1,000 IWJBCKNBCDVV', 'BDISJBJ 2,000 DBFIAJDBDIAJ', 'JDBISJB 5,000 AHSBIEFEWEFJ)', 'CONDDDD 7,000 4DJVBDISJEVV)']
output = [re.sub(r'\)$', '', x) for x in inp]
print(output)

This prints:

['ABDDDDC 1,000 IWJBCKNBCDVV',
 'BDISJBJ 2,000 DBFIAJDBDIAJ',
 'JDBISJB 5,000 AHSBIEFEWEFJ',
 'CONDDDD 7,000 4DJVBDISJEVV']

answered Nov 25, 2022 at 3:39

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

5 Comments

Blckknght Over a year ago

str.replace is just as good as regex for a substitution this simple.

Tim Biegeleisen Over a year ago

Yes, that might be fine, but perhaps the OP really only wants to target ) at the very end of each string.

John Gordon Over a year ago

That's not clear. The comment "# there is a parenthesis at the end" sort of implies it, but we don't know for sure.

Jiaman Lee Over a year ago

Thanks for your response, I tried your solution but ")" is still there... maybe it's because I used re.findall() to get the value of the list from a HTML file....

Tim Biegeleisen Over a year ago

Well my answer doesn't use re.findall and you are not using my answer.

Jethy11 · Accepted Answer · 2022-11-25 10:03:49Z

1

This is the solution for that.

list =[
 'ABDDDDC 1,000 IWJBCKNBCDVV',
 'BDISJBJ 2,000 DBFIAJDBDIAJ',
 'JDBISJB 5,000 AHSBIEFEWEFJ)',
 'CONDDDD 7,000 4DJVBDISJEVV)']

list = [i.replace(')','') if ')' in i else i for i in list]
[print(x) for x in list]

answered Nov 25, 2022 at 10:03

Jethy11

135 bronze badges

1 Comment

Timus Over a year ago

You don't need the if-else.

Collectives™ on Stack Overflow

Remove ")" from cells in list if ")" exists

2 Answers 2

5 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related