There are other databases out there aside from SQL. Believe it or not, some of these are called NoSQL databases. It is important to understand how we can work with them because it will widen our tool belts as Data Scientists. MongoDB is a popular NoSQL. The structure of these…

In Data Science, we are expected to work with extremely large quantities of data, so much so that a typical run of the mill computer will not have the proper power to handle all the data. …

As a Data Scientist, know that there are alternatives to finding a pre-compiled dataset on websites like Kaggle or the UCI Machine Learning Repository. Both of these sites are fabulous, but if we cannot find the information we are looking for, we can compile our own datasets through the utilization…

For my very first post on Medium, I wrote a blog called Collections of Knowledge. It was on the module Collections. This module gives us access to different special kinds of datatypes. It is interesting that when I wrote it, I did not cover a default dictionary. …

Pivot tables are useful tools in both Pandas and Excel. For todays blog, I am going to be talking about them with Pandas in mind. When working with a DataFrame (or Sheet if you are in Excel), at times it can be difficult to see the information based on how…

Want to write a function, but have no idea how many parameters you’ll need? That is not a problem in Python thanks to the use of *args and **kwargs. When I first heard these terms thrown around, I honestly thought they were talking about tweedle-dee and tweedle-dum. It just sounded…

In beginner SQL, the majority of queries are centered around returning a single piece of information, or a single piece of information per group. As we get more and more advanced, it becomes clear that by doing this, some of the information can get lost and that there is much…

SQL to a relational database is like a translator for a person speaking another language. This ‘other language’ is data of course. It is crucial that data scientists to learn a good amount of SQL so that we can do our job of making the data talk. Much like a…

Big O Notation is an important concept for Data Scientists to consider. Our job deals with large amounts of data on a daily basis. The larger the data, presumably the longer time it will take for our codes and programs to run. …