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