data cleansing

import numpy as n[]

import pandas as pd

conn=

sql1=select * from table

data=pd.read_sql(sql1,conn)

print(data.describe())

#cleaning missing numbers

data["price"][(data["price"]==0)]=none

for i in data.columns: 

  for j in range(len(data)):

    if (data[i].isnull())[j]:

        data[i][j]="36"

         x+=1

print(x)

data cleansing

原文：http://www.cnblogs.com/rabbittail/p/7859309.html