In [1]:
import pandas as pd
In [2]:
data = [10,11,12]
index = ['a','b','c']
s = pd.Series(data=data,index=index)
s
Out[2]:
In [3]:
mask = [True,False,True]
s[mask]
Out[3]:
In [4]:
s['b']
Out[4]:
In [5]:
s.loc['b']
Out[5]:
In [6]:
s.iloc[1]
Out[6]:
In [7]:
s1 = s.copy()
s1['a']=101
s1
Out[7]:
In [12]:
s1.replace(to_replace=101,value=102,inplace=False)
Out[12]:
In [15]:
s1.index
Out[15]:
In [18]:
s1.index=['c','b','a']
s1
Out[18]:
In [24]:
s1.rename(index={'a':'A'},inplace=True)
s1
Out[24]:
In [27]:
s2 = pd.Series([100,500],index=['f','g'])
s2
Out[27]:
In [28]:
s1.append(s2)
Out[28]:
In [31]:
s3 = s1.append(s2)
s3['v']=50
s3
Out[31]:
In [32]:
s1.append(s2,ignore_index=True)
Out[32]:
In [36]:
s1
Out[36]:
In [38]:
del s1['v']
s1
Out[38]:
In [40]:
s1.drop(['c','b'],inplace=True)
s1
Out[40]:
In [42]:
data = [[1,2,3],[4,5,6]]
index=['a','b']
columns=['A','B','C']
df = pd.DataFrame(data=data,index=index,columns=columns)
df
Out[42]:
In [43]:
df['A']
Out[43]:
In [44]:
df.iloc[0]
Out[44]:
In [45]:
df.loc['a']
Out[45]:
In [46]:
df.loc['a']['A']=150
df
Out[46]:
In [47]:
df.index=['f','g']
df
Out[47]:
In [48]:
df.loc['c']=[1,2,3]
df
Out[48]:
In [49]:
data = [[1,2,3],[4,5,6]]
index=['p','l']
columns=['A','B','C']
df2 = pd.DataFrame(data=data,index=index,columns=columns)
df2
Out[49]:
In [50]:
### concat() 将两个DataFrame数据连接为一个新的数据
In [52]:
df3 = pd.concat([df,df2])
df3
Out[52]:
In [53]:
df2['Tage']=[10,11]
df2
Out[53]:
In [58]:
df4 = pd.DataFrame([[10,11],[12,13]],index=['p','l'],columns=['D','E'])
df4
Out[58]:
In [59]:
df5 = pd.concat([df2,df4],axis=1)
df5
Out[59]:
In [61]:
df5.drop(['p'],axis=0,inplace=True)
df5
Out[61]:
- 按列删除
In [63]:
del df5['Tage']
df5
Out[63]:
In [65]:
df5.drop(['A','B','C'],axis=1,inplace=True)
df5
Out[65]: