Html and sql with python

Question

import urllib2

url = "http://www.bdfutbol.com/es/t/t2012-13.html"

request = urllib2.Request(url)
handle  = urllib2.urlopen(request)

content = handle.read()

splitted_page = content.split('<div class="divclassificacio">', 1);
splitted_page = splitted_page[1].split("</div>", 1);

print "Downloads: " + splitted_page[0]

So I just wrote this code to retrieve data, in html, from a soccer website using python. I am having issues writing the result into a file, and also displaying the table in python, which is what the code's for.

Also, I was wondering if anybody knew how can I transfer the table or the data into a MySql table?

What you're doing here is more widely known by the term "scraping". Just thought you might find it useful when googling for examples and such. — Morgan Wilde
– Morgan Wilde, Commented Jul 25, 2013 at 16:49

leonsas · Accepted Answer · 2013-07-25 14:47:45Z

1

To write to a file you can use:

with open('downloads.txt', 'w') as output_file:
     output_file.write(splitted_page[0])

In order to transfer into MySQL (or any other database) you'll have to first model your data in a schema, and then interact with it via the python interface. This set of articles provide great help on how to interact with databases from python.

edited Jul 25, 2013 at 14:47

answered Jul 25, 2013 at 5:26

leonsas

4,9487 gold badges47 silver badges71 bronze badges

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

2 Comments

Javier Galindo Over a year ago

Any suggestions on how to parse a table from a website using python, and also storing it into a csv file?

leonsas Over a year ago

Check out the following question. It will help you. stackoverflow.com/questions/15250455/…

Collectives™ on Stack Overflow

Html and sql with python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related