DataFrame的计算
import numpy as np
import pandas as pd
1. DataFrame数值计算
DataFrame.add(other, axis='columns', level=None, fill_value=None)
: +DataFrame.sub(other, axis='columns', level=None, fill_value=None)
: -DataFrame.mul(other, axis='columns', level=None, fill_value=None)
: *DataFrame.div(other, axis='columns', level=None, fill_value=None)
: /DataFrame.floordiv(other, axis='columns', level=None, fill_value=None)
: //DataFrame.mod(other, axis='columns', level=None, fill_value=None)
: %DataFrame.pow(other, axis='columns', level=None, fill_value=None)
: **
参数:
other: scalar, sequence, Series, or DataFrame
axis : {0 or 'index', 1 or 'columns'}
level : int or label
fill_value : float or None, default None
# 定义对象
>>> df = pd.DataFrame(data=np.array([(x, x+1, x+2, x+3, x+4) for x in range(0,25,5)],
dtype=[('col1', 'i4'), ('col2', 'i8'), ('col3', 'i4'), ('col4','f8'), ('col5', 'b')]))
>>> df
col1 col2 col3 col4 col5
0 0 1 2 3.0 4
1 5 6 7 8.0 9
2 10 11 12 13.0 14
3 15 16 17 18.0 19
4 20 21 22 23.0 24
>>&g