CSV to SQLite3

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

Scraping a Bookstore – Part 4

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

Scraping a Bookstore – Part 1

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

How to Scrape HTML Tables – Part 1

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

How to Scrape HTML Tables – Part 3

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

How to Scrape HTML Tables – Part 2

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

Part 3: Email a PDF in Python

Story: This series of articles assume you are an employee of the City of Sacramento’s IT Department. At the end of each month, a CSV file is sent to the Chief of Police outlining the crime statistics for the current month. However, the Chief prefers to view the output in a styled PDF format based … Read more

Part 2: CSV to PDF

Story: This series of articles assume you are an employee of the City of Sacramento’s IT Department. At the end of each month, a CSV file is sent to the Chief of Police outlining the crime statistics for the current month. However, the Chief prefers to view the output in a styled PDF format based … Read more

Serialize DataFrame to_gbq() and to_coo()

This article focuses on the serialization and conversion methods of a Python DataFrame: to_gbq(), to_coo(). Let’s get started! Preparation Before any data manipulation can occur, four (4) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices in addition to a collection of mathematical … Read more