Pandas: Unique Function

Here we want to pull unique values from the Years column in our table. When we say unique we want to get the individual values of Years in the column. Sometimes you will have data comeback and there are duplicate names, numbers or any type of object. Using the “unique” function in the pandas library…

Pandas: Minimum and Maximum Values

Today we will look at retrieving the minimum and maximum values in a pandas column. Lets say we have various dates in a dates column and we want to see what the earliest date in the set was or what the latest date may have been. This is a very simple and easy to use…

Pandas Library: Importing Excel CSV file

Using Python Pandas Library to Import CSV file Import the Pandas Library into your project – here I rename it to “pd” Use Pandas to Read the CSV file Print the top 10 rows including the column headers. 123>import pandas as pd >variablename_df = pd.read_csv("filename.csv") >print(variablename_df.head(10)) Import Pandas: The code above starts out by importing…

Pip Install Windows 10

Installing pip on Windows 10: * If the regualar pip command is not working: 1. Open your PowerShell or Command Prompt 2. In the command prompt type: py -m pip – This should display a list of pip commands:         When  I tried to use the regular “pip” command I received an…

Installing Python on Windows 10

I found this tutorial to be one of the most complete and easy to follow tutorials when it comes to successfully installing python on your windows 10 pc operating system. He installs both Python 2 and Python 3 so that you can work on any project in both environments. For his IDE he uses atom…

Hello World!

As all good programmers know you must make your first program and blog post with the infamous ‘Hello World” string.