Series与DataFrame之间算术运算和数据对齐

最新推荐文章于 2023-08-21 09:39:36 发布

Mikowoo007

最新推荐文章于 2023-08-21 09:39:36 发布

阅读量1.1k

点赞数 1

分类专栏： Python3.5

本文链接：https://blog.csdn.net/Mikowoo007/article/details/96452811

版权

20 篇文章 1 订阅

订阅专栏

算术运算和数据对齐(NaN)

from pandas import Series,DataFrame
import numpy as np
import pandas as pd

s1 = Series([-7.3,-2.5,3.4,1.5],index=['a','c','d','e'])
s1

a   -7.3
c   -2.5
d    3.4
e    1.5
dtype: float64

s2 = Series([-2.1,3.6,-1.5,4,3.1], index=['a','c','e','f','g'])
s2

a   -2.1
c    3.6
e   -1.5
f    4.0
g    3.1
dtype: float64

s1 + s2

a   -9.4
c    1.1
d    NaN
e    0.0
f    NaN
g    NaN
dtype: float64

print(list('bde'))

['b', 'd', 'e']

df1 = DataFrame(np.arange(9).reshape((3,3)),
               columns=list('bcd'),index=['Ohio','Texas','Colorado'])
df1

df2 = DataFrame(np.arange(12).reshape((4,3)),
               columns=list('bde'),index=['Utah','Ohio','Texas','Oregon'])
df2

df1 + df2

df1 = DataFrame(np.arange(12).reshape((3,4)),columns=list('abcd'))
df1

df2 = DataFrame(np.arange(20).reshape((4,5)),columns=list('abcde'))
df2

df1.add(df2,fill_value=0)

计算一个二维数组与其某行之间的差 (广播)

arr = np.arange(12).reshape((3,4))
arr

array([[ 0,  1,  2,  3],
       [ 4,  5,  6,  7],
       [ 8,  9, 10, 11]])

arr[0]

array([0, 1, 2, 3])

arr - arr[0]

array([[0, 0, 0, 0],
       [4, 4, 4, 4],
       [8, 8, 8, 8]])

frame = DataFrame(np.arange(12).reshape((4,3)),
                 columns=list('bde'),index=['Utah','Ohio','Texas','Oregon'])
frame

series = frame.ix[0]  #行
series

b    0
d    1
e    2
Name: Utah, dtype: int64

frame - series

series2 = Series(range(3),index=['b','e','f'])
series2

b    0
e    1
f    2
dtype: int64

frame + series2

frame

frame['d']

Utah       1
Ohio       4
Texas      7
Oregon    10
Name: d, dtype: int64

series3 = frame['d']
series3

Utah       1
Ohio       4
Texas      7
Oregon    10
Name: d, dtype: int64

frame.sub(series3,axis=0)

关注

专栏目录