Pandas Basics

Pandasintro.py

# -*- coding: utf-8 -*-
"""
Created on Thu Dec 28 19:46:45 2017

@author: garym
"""
#import pandas 
import pandas as pd 

## create dataframe from csv 
dataframe = pd.read_csv(r'C:\Users\garym\Documents\PyWinAutoBlog\File\testing.csv')
## can also use from sql, html, txt, excel etc. 

## print top 5 row 
print(dataframe.head(5))

#Rename columns
dataframe.columns = ['Start', 'Bob', 'Colx', 'Something','Woo', 'testing']
print(dataframe.head(5))

#Drop Columns
dataframe.drop(['Start', 'Bob'], axis = 1 , inplace = True)
print(dataframe.head(5))

#Get Unique values 
dfUnique =  dataframe.Colx.unique()
print(dfUnique)