首先引入相关的包
import numpy as np
import pandas as pd
from pandas import Series,DataFrame
Serious的运算
创建两个Series:s1,s2,并且打印结果
s1 = Series([1,2,3],index = ['A','B','C'])
s2 = Series([4,5,6,7],index=['B','C','D','E'])
print(s1)
print(s2)
我们对s1和s2做运算,只有B,C两项索引相加了。(只有索引相同才能相加)
print(s1 + s2)
显示结果
DataFrame的运算
创建df1和df2
df1 = DataFrame(np.arange(4).reshape(2,2),
index=['A','B'],columns=['BJ','SH'])
df2 = DataFrame(np.arange(9).reshape(3,3),
index=['A','B','C'],columns=['BJ','SH','GZ'])
打印
print(df1)
print(df2)
对df1和df2做运算
print(df1+df2)
创建df3,df3中含有nan
df3 = DataFrame([[1,2,3],[4,5,np.nan],[7,8,9]],index=['A','B','C'],columns=['c1','c2','c3'])
print(df3)
print(type(df3))
首先列相加
print(df3.sum())#列相加
然后行相加
print(df3.sum(axis=1))
列的最小值
print(df3.min())
行的最大值
df3.max(axis= 1)
查看下df3的情况
print(df3.describe())