Beautifulsoup Python Web Scraping

APIs are not always available. Sometimes you have to scrape data from a webpage yourself. Luckily the modules Pandas and Beautifulsoup can help!

Web Scraping is a useful technique to convert unstructured data on the web to structured data BeautifulSoup is an efficient library available in Python to perform web scraping other than urllib A basic knowledge of HTML and HTML tags is necessary to do web scraping in Python. Python offers an automated way, through various modules, to fetch the HTML content from the web (URL/URI) and extract data. This guide will elaborate on the process of web scraping using the beautifulsoup module.

Related Course:Complete Python Programming Course & Exercises

Web scraping

Pandas has a neat concept known as a DataFrame. A DataFrame can hold data and be easily manipulated. We can combine Pandas with Beautifulsoup to quickly get data from a webpage.

If you find a table on the web like this:

We can convert it to JSON with:

And in a browser get the beautiful json output:

Converting to lists

Rows can be converted to Python lists.
We can convert it to a dataframe using just a few lines:

Pretty print pandas dataframe

You can convert it to an ascii table with the module tabulate.
This code will instantly convert the table on the web to an ascii table:
This will show in the terminal as:

Today we will learn how to scrap a music web store using a Python library called Beautiful Soup. With simple, easy to read code, we are going to extract the data of all albums from our favourite music bands and store it into a .csv file.

It is simple, it is easy and even better, is efficient. And it is a lot of fun!

Introduction

If you know what Python, Beautiful Soup and web scraping is, skip to the next lesson: How to get the next page with Beautiful Soup

If you don’t, let me give a brief jump-start to you with a short, easy explanation:

• Python: An easy to learn programming language. It is one of the most used programming languages due to its easiness to learn, as it can be read like the English language.
• Beautiful Soup: Beautiful Soup is a library (a set of pre-writen code) that give us methods to extract data from websites via web scraping
• Web Scraping: A technique to extract data from websites.

With that in mind, we are going to install Beautiful Soup to scrap a website, Best CD Price to fetch the data and store it into a .csv file. Let’s go!

Getting ready

If you have used Python before, open your favourite IDE and create a new environment in the project’s folder.

If you never used Python before and what I said sounds strange, don’t panic. You don’t need to install anything if you don’t want to. Just open repl.it, click ‘+ next repl’, select Python as the project’s language and you are ready to go:

In this image, you have a white column in the middle where you’ll write the code, at your right, a black terminal where the output will be displayed and to your left, a column listing all the Python files. This script has only one file.

Importing libraries

If we had to code everything with just Python, it would take us days instead of less than 30 minutes. We need to import some libraries to help us. Write the following code to import them:

We are importing:

• Requests to fetch the HTML files
• BeautifulSoup to pull the data from HTML files
• lxml to parse (or translate) the HTML to Python
• Pandas to manipulate our data, printing it and saving it into a file

If we click “Run” it will download and install all the libraries. Don’t worry, it only installs them the first time.

Fetching the URL

The first step to scrape data from an URL? Fetching that URL.

Let’s make it simple: Go to Best CD Price and search for one band, then copy the resulting URL. This is mine: http://www.best-cd-price.co.uk/search-Keywords/1-/229816/sex+pistols.html

After the importing code, type this:

Run the code and you’ll see the “Everything is cool!” message.

We have stored our URL in ‘search_url’. Using requests we used the ‘get’ method to fetch the URL and if everything is working properly, our URL is successfully fetched with a 200 status code (Success) and we print ‘Everything is cool!’ in our terminal.

Python needs to understand the code. To do so, we have to translate it, or parsing it. Replace the last print with the following code:

We parse the page’s text, with the ‘lxml’ parser, and print the result.

Sounds familiar?

We have the whole URL stored in the ‘bs’ variable. Now, let’s take the parts we need.

Selecting elements from the URL

Now the fun part begins!

For me, web scraping is fun especially because this part of the process. We are like a detective in a crime scene, looking for hints we can follow up.

Copy the search URL and paste it into a browser. While Chrome is recommended, it is not mandatory. Right–click the website at any place and select “Inspect”. A side drawer will open. Make sure to click the ‘Elements’ tab.

You are looking at the skeleton of the website: The HTML code.

You can move your cursor to an HTML tag and that part of the website will be selected.

This is the equivalent of a detective magnifying glass. By hovering over HTML tags we can tell what part we need to select.

And I found our first clue. Every CD is wrapped inside a li tag (List Item) inside a ul tag (Unordered List). Let’s grab all of them then!

We have our website stored in the ‘bs’ variable. We use the ‘findAll’ method to find every ‘li’ tag. But as there are 192 li elements we need to reduce our scope.

We are going to fetch every li tag that also has a class ‘ResultItem’ and then, print all of them and the length of the list.

We get the whole list and ’10’, as there are 10 items in our page. It is looking good!

Getting our first album

We have a list of 10 (or less, depending of the band) albums. Let’s get one and see how we can extract the desired data. Then, following the same process, we will get the rest of them.

Remove the previous prints and type this:

After selecting all CDs, we store the first one into ‘cd’ and we print it:

You can view the same structure on the website too:

Let’s grab the information of this CD!

Following the same technique as before, we search for an ‘img‘ tag with the class ‘ProductImage’. Now the method is ‘find’ as we want only the first instance, not every

Hm, we have the element, indeed. But we only need that image’s URL, that it is stored in the ‘src’ property. As a Python element, we can extract it as a normal property, using [‘src’]

Nice, we extracted the image. Let’s keep going:

Cool! With a few lines we have everything!

Web Scraping Python Bs4

We keep extracting the values we need. If the element is a property of the tag as the ‘src’ or ‘href’, we use [‘href’] to extract it. If it is the text between the starting and ending tag, we use ‘.text’.

As not every album has the same properties, we try to fetch the value first and then, if it exists, we try to find the value. If not, we just return an empty string:

Some values have extra text we don’t need, as format_album or release_date. We remove that extra text with the ‘replace’ function, replacing that text with an empty string.

This was the most complicated thing of the code, but I’m sure you crushed it.

Getting all the albums

We have everything to fetch the information from one CD, now let’s do the same with every CD and store it into an object.

Replace what it is inside the ‘if page.status_code…’ statement with this

‘data’ is our object structure. We are going to add each value in each key. The name of the album, to data[‘Name’], its cover to data[‘Image’], etc. Now we just need to loop over each item and store the fetched value into the data object.

For each element in our list_all_cds, we are going to assign it the name ‘cd’ and run the code inside the for loop.

After getting each value, we append (or ‘add it’) to the data value:

And now, the print. The information is there, nice!

But it is ugly and hard to read…

Remember we installed the ‘panda’ library? That will help us to display the data and something else.

Storing the albums in a file

Let’s use that panda library! Copy this at the end of the file, out of the for loop:

Pandas (or pd) give us a ‘DataFrame’ function where we pass the data and the columns list. That’s it. That’s enough to create a beautiful table.

‘table.index = table.index +1’ sets the first index to ‘1’ instead of ‘0’.

The next line creates a .csv file, with a comma as separator and sets the encoding to ‘UTF-8’. We don’t want to store the index so we set it to false.

It looks better!

But now check your left column. You have a ‘my_albums.csv’ file. Everything is stored there!

Congratulations, you have written your first scraping script in Python

Extra points!

You succeeded in creating your own first scraping bot. You can scrape any band by switching the URL…

But we can do better, right?

Why not asking the user the name of a band and search it. It can be done?

Of course.

Web Scraping Beautiful Soup Python

Replace the old code with the new one:

Here we ask the user to enter a band, we format the name by replacing empty spaces with ‘+’ signs. This website does it when searching, so we have to do it too. Example: http://www.best-cd-price.co.uk/search-Keywords/1-/229816/sex+pistols.html

Now, our search URL uses the formatted band name

Not mandatory, but is a better practice to have the urls at the start of the code to easily replace it.

Now the file has the name of each band, so we can create any number of files we want without rewriting it! Let’s run the code.

Conclusion

In just few minutes we have learn how to:

• Fetch a website
• Localize the element(s) we want to scrap
• Analyze what HTML tags and class we need to hit to retrieve the values
• How to store the values retrieved into an object
• How to create a file with that object
• We improved the code making it dynamically by letting our users type the name of the band and storing that into a file with the band’s name as file name.

I’m really proud of you by reaching to the end of this tutorial.

Right now we are scraping just one page. Wouldn’t be great to learn how to scrape all the pages?

Now you can! How to get to the next page on Beautiful Soup

Contact me: DavidMM1707@gmail.com

Keep reading more tutorials