pandas_增删改查

查

dic1={
   "name":["amy","bob","james","zs","james","ls"],"age":[18,18,None,None,None,None],"tel":[10086,None,10086,10086,10086,10086]}
import pandas as pd
import numpy as np
df1=pd.DataFrame(dic1,index=list("abcdef"))
#
name	age	tel
a	amy	18.0	10086.0
b	bob	18.0	NaN
c	james	NaN	10086.0
d	zs	NaN	10086.0
e	james	NaN	10086.0
f	ls	NaN	10086.0

仅行索引

• 位置索引

df1[:2]
#
	name	age	tel
a	amy	18.0	10086.0
b	bob	18.0	NaN

• 标签索引（双闭合区间）

df1["a":"b"]
#
	name	age	tel
a	amy	18.0	10086.0
b	bob	18.0	NaN

注意：df1["a","b"]是不可以的（这种写法默认为列索引）。

仅列索引

• 标签索引

df1['name']、df1[['name',