• Using Python to Work with the Keepa API to Automate MySQL Database Ingestion for Power BI

    Python is a versatile language that can be used for all sorts of things, from data analysis to web development. In this blog post, we'll show you how to use Python to work with the Keepa API to automate MySQL database ingestion. Keepa is a site that tracks Amazon prices and allows users to create price alerts. We'll walk you through the steps of setting up a Python environment and using the Keepa API to import data into your MySQL database. Let's get started!
  • Get All Possible Combinations from a List using Python

    See this script in which we are taking a list from an array, getting all the possible combinations using itertools, writing that output to a data frame using pandas, and then printing that data frame to an excel file using pyexcel.
  • Convert XLS Files to XLSX Files using Python

    In order to automate converting excel file types, we can use scripting languages such as Python or PowerShell.

    The script in this article converts all of the XLS files in an existing folder to XLSX files, also making sure to delete any previously existing XLSX files that were in the folder previously.