Import SQLite to Python
There are at least two ways to do this. You can use pandas or a cursor. pandas DataFrame […]
query
SQL Introduction
SQL stands for Structured Query Language. SQL is a standard language for storing, manipulating, and retrieving data in […]
BigQuery Introduction
BigQuery is a fully managed enterprise data warehouse that helps you manage and analyze your data with built-in […]
Number Transformations
Number transformations in Power Query are simple to do, but there is something you need to watch out […]
Remove Duplicates
In Power Query it is easy to remove duplicates. There is however something to be aware of. Power […]
Fill and Replace Values
There are times when you need to clean your dataset. Suppose you had a simple table of employees […]
Power Query Transformations
Power Query is part of Microsoft Excel. It’s a powerful tool that can help you with repetitive tasks. […]
Excel Pivot and Unpivot
Many of the transformations in Power Query are fairly easy to grasp but other ones, such as Pivotting […]
IMDB Title Basics
The titlebasics file is a good file to start with after you have downloaded it. I re-named the […]
IMDB Repeating Genre Values
In working with the IMDB database tables, you find that each moving picture can have one or more […]
Unpivot in Power Query
What is unpivot and when would you use it? The unpivot operation converts columns to rows. It creates […]
Excel Power Pivot Introduction
What is Power Pivot? It is an add-in, and according to Microsoft: “Power Pivot is a data modeling […]