import pandas as pd

		Slide 4 

df = pd.read_csv("/home/user/Desktop/test.csv")


import MySQLdb

conn = MySQLdb.Connect(host='192.168.0.132',user='root',passwd='root123', db='dc-scrapers')

df = pd.read_sql('select * from countries', conn)





d = {'A': [50, 45, 0, 0],
     'B': [53, 48, 0, 0],
     'C': [56, 53, 0, 0],
     'D': [54, 49, 0, 0],
     'E': [53, 48, 0, 0],
     'F': [50, 45, 0, 0]}

pd.DataFrame(d)


		Slide 5

df.head(5)

df.shape

df.tail(5)

df.info()

df.describe()

df.columns

		Slide 6

df[['Name','Code']]

df.iloc[0,:]

df.ix[5]

df.iloc[3,3]

		Slide7

df.columns
df.columns = ['Id','code','name','phonecode']  ##renaming

df = pd.read_csv("/home/user/Desktop/test.csv")

df.isnull()

df.fillna('x')

df = pd.read_csv("/home/user/Desktop/test2222.csv")

df.drop_duplicates()

import numpy as np

df.dropna()

df.to_csv("/home/user/Desktop/t2.csv")