pandas基础属性方法随机整理（一）--- index&column 重命名rename / Series--DataFrame

1). Series –> DataFrame: Series.to_frame()

bigcolumn = pd.concat([series1, series2, series3], axis=0) 
# it is still a Series, so we need to transform it to a DataFrame
type(bigcolumn)
Out[66]: pandas.core.series.Series

方法：Series.to_frame():

bigcolumn = bigcolumn.to_frame()
type(bigcolumn)
Out[69]: pandas.core.frame.DataFrame
type(bigcolumn[0])
Out[72]: pandas.core.series.Series

2). DataFrame的column重命名： data.rename(columns = dict, .., inplace = True)*
说明： rename方法作用： 复制DataFrame并对其索引index和列标签columns进行赋值。如果希望就地修改某个数据集，传入inplace=True即可。

a) 对列标签columns赋值：
data.rename(columns = {**0:’bedrs’, ‘1’: ‘bathrs’, ‘2’: ‘price_sqr_meter’}, inplace = True)
b) 对索引index赋值：
data.rename(index= {‘achd’: ‘ACHD’, ‘ds’: ‘DS’}, inplace = True) (dict也可用function替代)

data = pd.concat([s1,s2,s3],axis=1)
data.head()
Out[54]: 
   0  1      2
0  2  3  12093
1  1  2  20383
2  4  1  26351
3  2  2  27145
4  4  1  21293

data.rename(columns = {0: 'bedrs', 1: 'bathrs', 2: 'price_sqr_meter'}, inplace=True)
data.head()
Out[77]: 
   bedrs  bathrs  price_sqr_meter
0      2       3            12093
1      1       2            20383
2      4       1            26351
3      2       2            27145
4      4       1            21293

help()代码信息：

rename(self, mapper=None, index=None, columns=None, axis=None, copy=True, inplace=False, level=None)
    Alter axes labels.

    Function / dict values must be unique (1-to-1). Labels not contained in
    a dict / Series will be left as-is. Extra labels listed don't throw an error.
    Parameters
    ----------
    mapper, index, columns : dict-like or function, optional
        dict-like or functions transformations to apply to
        that axis' values. Use either ``mapper`` and ``axis`` to
        specify the axis to target with ``mapper``, or ``index`` and
        ``columns``.
    axis : int or str, optional
        Axis to target with ``mapper``. Can be either the axis name
        ('index', 'columns') or number (0, 1). The default is 'index'.
    copy : boolean, default True
        Also copy underlying data
    inplace : boolean, default False
        Whether to return a new %(klass)s. If True then value of copy is
        ignored.
    level : int or level name, default None
        In case of a MultiIndex, only rename labels in the specified
        level.

    Returns
    -------
    renamed : DataFrame