real struggle trying to parse a table

Question

I am trying to parse a table (of prices) from a web and it is turning out a real struggle

here is the web

url='http://www.zonebourse.com/AEX-7959/composition/'

with bs4:

r = requests.get(url)
data = r.text
soup = BeautifulSoup(data,"html5lib")
tables =soup.find('table',id='ALNI4')

print tables

with html5lib:

df=pd.read_html(url)
print df

In both cases no tables found, could anyone help me parse the table or at least understand what is the problem?

ValueError: No tables found

I would like to discard the option of xml if possible, having problems to install so dont use at all.

Thank you in advance

Well, when I try visiting the url you posted, I don't get anything back. I did `res= requests.get("http://www.zonebourse.com/AEX-7959/composition/")` and `res.text` returns `''`. Is that the right URL? — cosinepenguin, Jul 13 '17 at 19:02
You are right , days ago that link took you to the composition section as you can appreciate under the web header , is there ANYWAY i can get the table over there ? — JamesHudson81, Jul 13 '17 at 19:08

score 1 · Accepted Answer · edited Jul 13 '17 at 19:18

1

Seems you are looking for

url='http://www.zonebourse.com/AEX-7959/composition%E2%80%8C%E2%80%8B/'

edited Jul 13 '17 at 19:18

cs95

379,657
97
704
746

answered Jul 13 '17 at 19:11

Prem

11,775
1
19
33

Ah shoot! You beat me to it! Well played ;) – cosinepenguin Jul 13 '17 at 19:11

score 1 · Answer 2 · answered Jul 13 '17 at 19:11

For some reason, the URL you are pointing to is wrong. I searched for what the URL actually is, and it is actually http://www.zonebourse.com/AEX-7959/composition%E2%80%8C%E2%80%8B/.

I do not know why the URL is this weird.

If you make that edit, (url='http://www.zonebourse.com/AEX-7959/composition%E2%80%8C%E2%80%8B/') your code should work correctly (though I did not test it myself!)

Hope it helps! Bonne chance!

real struggle trying to parse a table

2 Answers2