Skip to content

Data Science Examples

Your source for everything data science.

  • About
  • Contact
  • Resume
  • Scott McMahan
Data Science Examples

Category: Software

SQL vs Pandas

Comparing SQL and Pandas with MySQL and MySQL Workbench Tutorial

January 29, 2020 Scott McMahan Databases, Python

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
Joins with Pandas and SQL

Joins with Pandas

December 6, 2019 Scott McMahan Databases, Python, Relational Databases/SQL-Enabled

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 Online

Free Data Science Courses

October 20, 2019 Scott McMahan Data Analysis, Databases, Deep Learning, Excel, Python, R

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 - a Python library

Pandas in Python for Data Manipulation (an Introduction)

October 6, 2019 Scott McMahan Data Analysis, Excel, Python

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 more

SQL-Enabled Vrs. NoSQL Databases

September 24, 2019 Scott McMahan Databases, NoSQL, Relational Databases/SQL-Enabled

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

VBA for Excel, Less Popular than Before

September 17, 2019 Scott McMahan Excel, Visual Basic for Applications (VBA)

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 -- box and spreadsheet-- image by Christian Dorn from Pixabay

Excel for Data Science

September 13, 2019 Scott McMahan Artificial Neural Networks, Data Analysis, Excel, Python, Software

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

Recent Posts

  • Using .env File for Passwords and Keys
  • Artificial Neural Network Disadvantages
  • Underspecification in AI
  • Getting Data Outside D3 or Plotly CSV Functions
  • CSVs to Single JSON

Archives

  • February 2021
  • December 2020
  • November 2020
  • October 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019

Categories

  • AI–Artificial Intelligence
  • Algorithms
  • Artificial Neural Networks
  • Big Data
  • Data Analysis
  • Data Analysis Techniques
  • Data Mining
  • Data visualization
  • Databases
  • Deep Learning
  • Excel
  • Javascript
  • Machine Learning
  • NoSQL
  • Programming Languages
  • Python
  • R
  • Relational Databases/SQL-Enabled
  • Software
  • Uncategorized
  • Visual Basic for Applications (VBA)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
WordPress Theme: Poseidon by ThemeZee.