Story: Assume you work for the Finxter Academy. Your boss asks you to import an existing CSV file containing fictitious users to SQLite3. What is SQLite3, you ask! SQLite3 is an ANSI-C source-code file that offers a light-weight database with the following qualities: Easy to compile and incorporate into projects. No external dependencies. Supports cross-platforms. … Read more
Story: This series of articles assume you work in the IT Department of Mason Books. The Owner asks you to scrape the website of a competitor. He would like this information to gain insight into his pricing structure. 💡 Note: Before continuing, we recommend you possess, at minimum, a basic knowledge of HTML and CSS and … Read more
Introduction Something usual in data science is to work with data stored in a pandas dataframe. Often there is a need to extract specific parts of the dataframe, like columns, rows, or both. The reasons for this could be many, the dataframe is large, and only certain parts are of interest. This post will present … Read more
Story: This series of articles assume you work in the IT Department of Mason Books. The Owner asks you to scrape the website of a competitor. He would like this information to gain insight into his pricing structure. 💡 Note: Before continuing, we recommend you possess, at minimum, a basic knowledge of HTML and CSS and … Read more
What are Arrays? A Python array is a data structure like a list. They contain a number of objects that can be of different data types. They provide fast ways and versatile ways to normalize data. What are Dataframes? Dataframes are an ordered sequence of Series, sharing the same index with labeled columns used to … Read more
Summary: The type() function and the __class__ property enables us to determine the type of a Python variable. Problem Statement: Determining the type of a variable in Python. Determining the data type of a variable plays a vital role in programming. Every variable is capable of storing different types of data, and each type has … Read more
Story: This series of articles assume you work in the IT Department of Mason Books. The Owner asks you to scrape the website of a competitor. He would like this information to gain insight into his pricing structure. 💡 Note: Before continuing, we recommend you possess, at minimum, a basic knowledge of HTML and CSS and … Read more
Story: This series of articles assume you work in the IT Department of Mason Books. The Owner asks you to scrape the website of a competitor. He would like this information to gain insight into his pricing structure. 💡 Note: Before continuing, we recommend you possess, at minimum, a basic knowledge of HTML and CSS and … Read more
BeautifulSoup is a library used for parsing web pages. As the library is simple to access and use, it is extensively used by the developers for Web Scraping activities. If the webpage is in the HTML format, we can parse the webpage using an HTML parser. After parsing the document, we can filter only the … Read more
Problem Statement: Selecting rows from a Dataframe based on the column values. Introduction DataFrame (A Quick Recap) A DataFrame is a 2-dimensional data structure that is generally immutable and heterogeneous. It has labelled axes – rows and columns. A Pandas Dataframe comprises three parts: data, rows, and columns. Now let’s create a Dataframe. We are … Read more
Story: This series of articles assumes you are a contractor hired by the NHL (National Hockey League) to produce a CSV file based on Team Stats from 1990-2011. The data for this series is located on a live website in HTML table format. 💡 Note: Before continuing, we recommend you possess, at minimum, a basic knowledge … Read more
Story: This series of articles assumes you are a contractor hired by the NHL (National Hockey League) to produce a CSV file based on Team Stats from 1990-2011. The data for this series is located on a live website in HTML table format. 💡 Note: Before continuing, we recommend you possess, at best, a minimum basic … Read more