2、pandas数据创建

实例：一维数组Series

import pandas as pd
#默认索引
data = pd.Series([1,2,3])
print('data:')
print(data.index)
print(data.values)
print(data)
print(data[2])
print(data*2)
print(4 in data)
print(2 in data)
print('\n')
#自制索引
data1 = pd.Series(['a','b','c'],index=['x','y','z'])
print('data1:')
print(data1)
print(data1['y'])
print('\n')
#修改索引
data1.index=['m','n','l']
print(data1)
print(data1*2)
print(data1[data1 > 'a'])
print(data1 > 'a')

runfile('C:/Users/xyy/.spyder-py3/temp.py', wdir='C:/Users/xyy/.spyder-py3')
data:
RangeIndex(start=0, stop=3, step=1)
[1 2 3]
0    1
1    2
2    3
dtype: int64
3
0    2
1    4
2    6
dtype: int64
False
True


data1:
x    a
y    b
z    c
dtype: object
b


m    a
n    b
l    c
dtype: object
m    aa
n    bb
l    cc
dtype: object
n    b
l    c
dtype: object
m    False
n     True
l     True
dtype: bool

实例：多维数组DataFrame

import pandas as pd
st=pd.DataFrame({'id':[0,1,3,2],'name':['alice','cindy','bob','bruce']},index=[0,1,2,3])
#切片查看
print('id列，前三行：\n',pd.DataFrame(st['id'].loc[:2]))
#新增字段
st['name_1']=st['name']
print('新增列name_1：\n',st)
#删除原表字段
del st['name_1']
print('删除列name_1：\n',st)
#删除字段产生新对象
st1=st.drop(['name'],axis=1) #删除列
print('删除列name：\n',st1)
st1=st1.drop(3) #删除行
print('删除索引为3的行：\n',st1)

runfile('C:/Users/xyy/.spyder-py3/temp.py', wdir='C:/Users/xyy/.spyder-py3')
id列，前三行：
    id
0   0
1   1
2   3
新增列name_1：
    id   name name_1
0   0  alice  alice
1   1  cindy  cindy
2   3    bob    bob
3   2  bruce  bruce
删除列name_1：
    id   name
0   0  alice
1   1  cindy
2   3    bob
3   2  bruce
删除列name：
    id
0   0
1   1
2   3
3   2
删除索引为3的行：
    id
0   0
1   1
2   3