# 这段代码用于并排显示多个Series对象

from itertools import izip_longest 

def C(*args, **kw): 

    gap = kw.pop("gap", 5) 

    results = [] 

    for item in args: 

        if isinstance(item, tuple): 

            results.append("\n".join(unicode(row) for row in item).split("\n")) 

    for i, item in enumerate(results): 

        width = max(len(row.encode("gb2312")) for row in item) 

        results[i].insert(1, "-"*width)        

        results[i] = [row.encode("gb2312").ljust(width+gap).decode("gb2312") for row in item] 

    for row in izip_longest(*results, fillvalue=""): 

        print "".join(row) 

import pandas as pd 

s = pd.Series([1,2,3,4,5], index=["a","b","c","d","e"]) 

print s.index 

print s.values 

print s[2], s["d"] 

C((u"s[1:3]", s[1:3]), (u"s['b':'d']", s['b':'d'])) 

C((u"s[[1,3,2]]", s[[1,3,2]]), (u"s[['b','d','c']]", s[['b','d','c']])) 

print list(s.iteritems()) 

index = s.index 

print index.__class__.mro() 

index.values 

print index[[1, 3]] 

print index[index > 'c'] 

print index[1::2] 

print index.get_loc('c') 

index.get_indexer(['a', 'c', 'z']) 

e = s.index._engine 

print e 

e.get_loc('b') 

e.get_indexer(np.array(['a', 'd', 'e', 'z'], 'O')) 

ht = e.mapping 

print ht 

ht.get_item('d') 

ht.lookup(np.array(['a', 'd', 'e', 'z'], 'O')) 

N = 10000 

unique_keys = np.array(list(set(pd.core.common.rands(5) for i in xrange(N))), 'O') 

duplicate_keys = unique_keys.copy() 

duplicate_keys[-1] = duplicate_keys[0] 

sorted_keys = np.sort(duplicate_keys) 

unique_index = pd.Index(unique_keys) 

sorted_index = pd.Index(sorted_keys) 

duplicate_index = pd.Index(duplicate_keys) 

to_search = unique_keys[N-2] 

from itertools import product 

def dataframe_fromfunc(func, index, columns): 

    return pd.DataFrame([[func(idx, col) for col in columns] for idx in index], 

            index = index, columns = columns) 

predicates = ["is_unique", "is_monotonic"] 

index = ["unique_index", "sorted_index", "duplicate_index"] 

dataframe_fromfunc(lambda idx, pred:getattr(globals()[idx], pred), index, predicates) 

print unique_index.get_loc(unique_keys[0]) 

print sorted_index.get_loc(unique_keys[0]) 

print duplicate_index.get_loc(unique_keys[0]) 

%timeit unique_index.get_loc(to_search) 

%timeit sorted_index.get_loc(to_search) 

%timeit duplicate_index.get_loc(to_search)