Many starting in data science and data analytics may get introduced to pandas before being introduced to the structured query language (SQL).SQL has a lot of analogous methods and functions, with some even having the[…]
Read more
Category: Software
Joins with Pandas
For those of you who are familiar with SQL, you will recognize the logic and functionality behind the Pandas merge feature. However, if you are not familiar with SQL, or need a refresher, this post[…]
Read more
Free Data Science Courses
A lot of data science courses claim to be free, but most are not. Many, such as Coursera, let you sign up for free for a trial period of about a week. After that, you[…]
Read more
Pandas in Python for Data Manipulation (an Introduction)
One of Python’s most dynamic and powerful libraries for working with data is Pandas. Pandas lets you read data from txt, csv, and Excel files. A video of this tutorial is available below.You must first[…]
Read moreSQL-Enabled Vrs. NoSQL Databases
SQL stands for structured query language. It is the language for interacting with relational databases which can also be referred to as SQL-enabled databases. Relational databases are made up of tables with rows and columns.[…]
Read more
VBA for Excel, Less Popular than Before
One of the programming languages that often taught for data science is Visual Basic for desktop applications. While useful on a resume, it may be less useful in the future of data science.Microsoft introduced the[…]
Read more
Excel for Data Science
Microsoft Excel is one of the more useful tools for data science. First and foremost, Excel is of the most widely used spreadsheet applications. With add-ins it can do almost any data science process, and[…]
Read more