python笔记：3.2.2.6pandas数据操作

# -*- coding: utf-8 -*- """ Created on Thu May 23 20:41:43 2019 @author: User """ import pandas as pd dfdata1={'Name':{101:'Zhang San',102:'Li Si',103:'Wang Wu',104:'Zhao Liu',105:'Qian Qi',106:'Sun Ba'}, 'Subject':{101:'Literature',102:'History',103:'English',104:'Maths',105:'Physics',106:'Chemics'}, 'Score':{101:98,102:76,103:84,104:70,105:93,106:83} } c1=pd.DataFrame(dfdata1) print('\nc1:') print(c1) c2=pd.DataFrame({'Gender':{101:'Male',102:'Male',103:'Male',104:'Female',105:'Female'}}) print('\nc2:') print(c2) print('\n c=pd.concat([c1,c2],axis=1):') c=pd.concat([c1,c2],axis=1) print(c) print('\n c1.append(c2):') print(c1.append(c2)) c3=pd.DataFrame({ 'Name':{101:'Zhang San',102:'Li Si',103:'Wang Wu',104:'Zhao Liu',105:'Qian Qi',106:'Sun Ba'}, 'Gender':{101:'Male',102:'Male',103:'Male',104:'Female',105:'Female'} }) print('\nc3:') print(c3) print("\n pd.merge(c1,c3,on='Name'):") print(pd.merge(c1,c3,on='Name'))

运行：

c1:           Name     Subject  Score 101  Zhang San  Literature     98 102      Li Si     History     76 103    Wang Wu     English     84 104   Zhao Liu       Maths     70 105    Qian Qi     Physics     93 106     Sun Ba     Chemics     83

c2:      Gender 101    Male 102    Male 103    Male 104  Female 105  Female

 c=pd.concat([c1,c2],axis=1):           Name     Subject  Score  Gender 101  Zhang San  Literature     98    Male 102      Li Si     History     76    Male 103    Wang Wu     English     84    Male 104   Zhao Liu       Maths     70  Female 105    Qian Qi     Physics     93  Female 106     Sun Ba     Chemics     83     NaN

 c1.append(c2):      Gender       Name  Score     Subject 101     NaN  Zhang San   98.0  Literature 102     NaN      Li Si   76.0     History 103     NaN    Wang Wu   84.0     English 104     NaN   Zhao Liu   70.0       Maths 105     NaN    Qian Qi   93.0     Physics 106     NaN     Sun Ba   83.0     Chemics 101    Male        NaN    NaN         NaN 102    Male        NaN    NaN         NaN 103    Male        NaN    NaN         NaN 104  Female        NaN    NaN         NaN 105  Female        NaN    NaN         NaN

c3:           Name  Gender 101  Zhang San    Male 102      Li Si    Male 103    Wang Wu    Male 104   Zhao Liu  Female 105    Qian Qi  Female 106     Sun Ba     NaN

 pd.merge(c1,c3,on='Name'):         Name     Subject  Score  Gender 0  Zhang San  Literature     98    Male 1      Li Si     History     76    Male 2    Wang Wu     English     84    Male 3   Zhao Liu       Maths     70  Female 4    Qian Qi     Physics     93  Female 5     Sun Ba     Chemics     83     NaN