Help with a code to get float data

[dunhill]

I want to modify some data obtained by a plugin that they made for me and I don't want to be too upset with the programmer who has so kindly done it.
The original code includes the price in text format. With this parameter(pricespan.text)
I am looking to get the data in decimal format ( float ) as seen in the code replacement but I don't get the result. If someone can give me a hand.
Don't laugh at me if I replaced the wrong code

This is the original code:

def scrape (isbn):
from bs4 import BeautifulSoup as bs
import requests
url = "https://www.tematika.com/catalogsearch/result/?q=" + isbn
r = requests.get(url)
soup = bs(r.text, 'html.parser')
div = soup.find(id='jm-current-content')
try:
pricebox = div.find_all(class_="price-box")
if len(price box) == 1:
for p in pricebox:
price range = p.find(class_="price")
return pricespan.text
the rest:
return none
except:
return none

And I have changed it to this:

def scrape (isbn):
from bs4 import BeautifulSoup as bs
import requests
url = "https://www.tematika.com/catalogsearch/result/?q=" + isbn
r = requests.get(url)
soup = bs(r.text, 'html.parser')
div = soup.find(id='jm-current-content')
try:
pricebox = div.find_all(class_="price-box")
if len(price box) == 1:
for p in pricebox:
price range = p.find(class_="price")
return float((pricespan.text).replace('.','').replace(',' , '.'))
the rest:
return none
except:
return none

[thiago.eec]

Hi, @dunhill

Maybe I'm wrong, but I think you may have translated your original code to Spanish and then back to English. This caused some problem with python syntax getting changed, like 'try' to 'attempt'.

Here is a working code, returning a 'float':

def scrape (isbn):
    from bs4 import BeautifulSoup as bs
    import requests
    url = "https://www.tematika.com/catalogsearch/result/?q=" + isbn
    r = requests.get(url)
    soup = bs(r.text, 'html.parser')
    div = soup.find(id='jm-current-content')
    try:
        pricebox = div.find_all(class_="price-box")
        if len(pricebox) == 1:
            for p in pricebox:
                pricerange = p.find(class_="price")
                return float(pricerange.text.replace('$', '').replace('.','').replace(',' , '.'))
        else:
            return none
    except:
        return none

P.S.: ISBN here is assumed to be a string, so I didn't change this.

[dunhill]

Originally Posted by thiago.eec

Hi, @dunhill

Maybe I'm wrong, but I think you may have translated your original code to Spanish and then back to English. This caused some problem with python syntax getting changed, like 'try' to 'attempt'.

Here is a working code, returning a 'float':

def scrape (isbn):
    from bs4 import BeautifulSoup as bs
    import requests
    url = "https://www.tematika.com/catalogsearch/result/?q=" + isbn
    r = requests.get(url)
    soup = bs(r.text, 'html.parser')
    div = soup.find(id='jm-current-content')
    try:
        pricebox = div.find_all(class_="price-box")
        if len(pricebox) == 1:
            for p in pricebox:
                pricerange = p.find(class_="price")
                return float(pricerange.text.replace('$', '').replace('.','').replace(',' , '.'))
        else:
            return none
    except:
        return none

P.S.: ISBN here is assumed to be a string, so I didn't change this.

thiago.eec
Thanks for the code.
Works !!

[thiago.eec]

Originally Posted by dunhill

thiago.eec
Thanks for the code.
Works !!

I could not answer at the time, but I saw your question before you deleted it.
In case you still want to know how to keep the '$' symbol and the '.' as a thousand separator, do this:

1) Preferences > Add your own column
2) Go to the desired column and double-click it
3) In 'Format for numbers', use this: "${:.10n}"

[dunhill]

Originally Posted by thiago.eec

I could not answer at the time, but I saw your question before you deleted it.
In case you still want to know how to keep the '$' symbol and the '.' as a thousand separator, do this:

1) Preferences > Add your own column
2) Go to the desired column and double-click it
3) In 'Format for numbers', use this: "${:.10n}"

Thank you the way you comment on this message is better.
I was using format for number this ${:,.0f}