3.3 pandas数据运算
3.3.1 算术运算
pandas
的数据对象在进行算数运算时:
- 如果有相同索引对则进行算术运算
- 如果没有则会引入缺失值,这就是
数据对齐
。
对于DataFrame
数据而言,对齐操作会同时发生在行和列上。
from pandas import Series,DataFrame
import pandas as pd
import numpy as np
obj1 = Series([3.2,5.3,-4.4,-3.7],index=['a','c','g','f'])
obj1
a 3.2
c 5.3
g -4.4
f -3.7
dtype: float64
obj2 = Series([5.0,-2,4.4,3.4],index=['a','b','c','d'])
obj2
a 5.0
b -2.0
c 4.4
d 3.4
dtype: float64
obj1+obj2
a 8.2
b NaN
c 9.7
d NaN
f NaN
g NaN
dtype: float64
df1 = DataFrame(np.arange(9).reshape(3,3),columns=['a','b','c'],index=['apple','tea','banana'])
df1
df2 = DataFrame(np.arange(9).reshape(3,3),columns=['a','b','d'],index=['apple','tea','coco'])
df2
df1+df2
s = df1.ix[