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
  • 0
    点赞
  • 9
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值