I keep getting the error message ValueError: Wrong number of items passed 2, placement implies 1

Asked Apr 04 '22 at 22:30

Active Apr 04 '22 at 22:31

Viewed 40 times

I'm using python to extract dollar amounts from six to seven figures with dollars and comma separated. My regex tool capture both amounts but python throws a value error. Not sure what is causing this. It works if I remove the Boolean but I have to create separate columns.

df3['Price'] = df3['Listings'].str.extract('(\$?\d{3}\,\d{3})|(\$?\d{1}\,\d{3}\,\d{3})',expand = True)

ValueError: Wrong number of items passed 2, placement implies 1

edited Apr 04 '22 at 22:31

Barmar

741,623
53
500
612

asked Apr 04 '22 at 22:30

Jon Burks Jr

You're assigning to one column, but you have two capture groups in the regexp. – Barmar Apr 04 '22 at 22:32
1

Just put one capture group around the entire regexp, not separate groups in each alternative. – Barmar Apr 04 '22 at 22:34
Ah that what it is. I put it in a capture group and it worked. Thanks – Jon Burks Jr Apr 05 '22 at 22:05

I keep getting the error message ValueError: Wrong number of items passed 2, placement implies 1

0 Answers0