Pandas基础学习

# encoding:utf-8import pandas as pdimport numpy as np# s=pd.Series([1,3,5,np.NaN,6,8])# print sdates = pd.date_range('20130101', periods=6)# print dates# 生成随机数，randn()从正态分布中返回一个或多个样本，rand()，随机样本位于[0，）df = pd.DataFrame(np.random.randn(6, 4), index=dates, columns=['A', 'B', 'CD', 'E'])# print df# C的行数必须和B的行数相同# df2 = pd.DataFrame({#     'A': 1.,#     'B': dates,#     'C': pd.Series(1, index=list(range(6)))# })# print df2# print df.head(1),df.tial(1)# print df.first_valid_index()# print df.columns# 将值放到了一个多维矩阵当中# print df.values# print df.iloc[2].describe()# axis=1，对列进行排序，ascending=False,降序排序df.sort_index(axis=0,ascending=True)list1=[]for value in df.values:    # 将array转成list    value=value.tolist()    print value    list1.append(value)print list1list = [[0 for col in range(4)] for row in range(6)]for row in range(6):    for col in range(4):        list[row][col]=list1[row][col]print list