DataFrame属性 .columns,.shape, .size, .values, .dtypes, .ndim, .T

http://liao.cpython.org/pandas09/

.columns

crm.columns
Out[195]: 
Index(['Team', 'Task(created date)', 'Phone Calls (created date)',
       'Visits  (created date)', 'Leads(created date)',
       'Open, SQL, MQL per OSR (last modified date)',
       'Converted, Closed per OSR (last modified date)',
       'Number Opportunities per OSR(create date)',
       'Number C4C Quotes per OSR (create date)',
       'Number SAP Quotes per OSR (create date)', 'Open Opp qty',
       'Weighted Opp value'],
      dtype='object')

.shape

crm.shape
Out[196]: (36, 12)

.size dataframe的size属性返回的是dataframe的value的个数。

crm.size
Out[197]: 432

.values 返回当前dataframe的数据和index、columns相对应

crm.values
Out[198]: 
array([[1234, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0],
       ['SBF', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0],
       ['JSB', 13, 14, 11, 0, 2, 1, 4, 16, 4, 29, 245750.0],
       ['JSB', 5, 8, 2, 0, 0, 0, 0, 0, 2, 6, 510000.0],
       ......
       ['admin', 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0.0],
       ['na', 0, 0, 0, 0, 5, 1, 0, 0, 0, 0, 0.0]], dtype=object)

.dtypes 描述当前dataframe的里的每列值的数据类型。

crm.dtypes
Out[199]: 
Team                                               object
Task(created date)                                  int64
Phone Calls (created date)                          int64
Visits  (created date)                              int64
Leads(created date)                                 int64
Open, SQL, MQL per OSR (last modified date)         int64
Converted, Closed per OSR (last modified date)      int64
Number Opportunities per OSR(create date)           int64
Number C4C Quotes per OSR (create date)             int64
Number SAP Quotes per OSR (create date)             int64
Open Opp qty                                        int64
Weighted Opp value                                float64
dtype: object

.ndim 数组的ndim属性是说明数组的维度是多少

crm.ndim
Out[200]: 2

T属性：dataframe的T属性，实际是转置的意思