Pandas基础操作

#创建series对象及打印，连接，删除
import pandas as pd
s1 = pd.Series([1,2,3,4,5,6],dtype = "int32")
#用字典创建series
s2 = pd.Series({'longitude':39,'latitude':116,'temperature':26})
#打印
print(s1)
print("\n")
print(s2)
print("\n")
#连接
s3 = s1.append(s2)
print(s3)
print("\n")
#删除
s4 = s2.drop("temperature")
print(s4)

0 1
1 2
2 3
3 4
4 5
5 6
dtype: int32

longitude 39
latitude 116
temperature 26
dtype: int64

0 1
1 2
2 3
3 4
4 5
5 6
longitude 39
latitude 116
temperature 26
dtype: int64

longitude 39
latitude 116
dtype: int64

#DataFrame的创建与行列访问(表格型的数据结构)
import pandas as pd
df = pd.DataFrame({'col1':[1,2,5,7],'col2':['a','b','c','d']})
df

	col1	col2
0	1	a
1	2	b
2	5	c
3	7	d

#由列表组成的字典创建DataFrame
import pandas as pd
lista = [1,2,5,7]
listb = ['a','b','c','d']
df = pd.DataFrame({'col1':lista,'col2':listb})
df

	col1	col2
0	1	a
1	2	b
2	5	c
3	7	d

#修改DataFrame数据
import numpy as np
import pandas as pd
data=pd.DataFrame(np.arange(16).reshape(4,4),index=['BJ','SH','GZ','SZ'],columns=['q','r','s','t'])
data['q']['BJ']=8
data['t']=8
data['s']['SZ']=8
data

	q	r	s	t
BJ	8	1	2	8
SH	4	5	6	8
GZ	8	9	10	8
SZ	12	13	8	8

#DataFrame对象的行列删除操作示例
dt1=data.drop('SZ',axis=0)      #删除行
dt2=data.drop(['r','s'],axis=1) #删除列
data.drop('SZ',inplace=True)    #删除行
dt1

	q	r	s	t
BJ	8	1	2	8
SH	4	5	6	8
GZ	8	9	10	8

dt2

	q	t
BJ	8	8
SH	4	8
GZ	8	8
SZ	12	8

data

	q	r	s	t
BJ	8	1	2	8
SH	4	5	6	8
GZ	8	9	10	8

#使用Pandas模块求方差
import numpy as np
import pandas as pd
a = np.arange(0,60,5)
a = a.reshape(3,4)
df = pd.DataFrame(a)
print(df)
print('-------------')
print(df.std())

0 1 2 3
0 0 5 10 15
1 20 25 30 35
2 40 45 50 55
-------------
0 20.0
1 20.0
2 20.0
3 20.0
dtype: float64