<pandas.core.groupby.groupby.DataFrameGroupBy object at 0x0000000007B3BCF8>
Signature: df.groupby(by=None, axis=0, level=None, as_index=True, sort=True, group_keys=True, squeeze=False, observed=False,**kwargs)
Docstring:Group series using mapper (dictor key function,apply given function
E:\Anaconda3\lib\site-packages\ipykernel_launcher.py:1: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version
of pandas will change to not sort by default.
To accept the future behavior, pass 'sort=False'.
To retain the current behavior and silence the warning, pass 'sort=True'.
"""Entry point for launching an IPython kernel.
A
B
C
D
0
a
e
NaN
NaN
1
b
f
NaN
NaN
2
c
g
NaN
NaN
3
d
h
NaN
NaN
0
NaN
NaN
a
e
1
NaN
NaN
b
f
2
NaN
NaN
c
g
3
NaN
NaN
d
h
pd.concat([df1,df2],axis=1)#左右堆叠
A
B
C
D
0
a
e
a
e
1
b
f
b
f
2
c
g
c
g
3
d
h
d
h
(2) join
company.join(data)
Signature: company.join(other, on=None, how='left', lsuffix='', rsuffix='', sort=False)
Docstring: Join columns with other DataFrame either on index or on a key column.
Efficiently Join multiple DataFrame objects by index at once by
(3) merge #键值
data.merge(right=company,how='inner', on='companyId')#right表示与哪张表关联,左关联右,返回在左边 on通过哪几个键值(列)进行关联### data 的在左边,company在右边