pandas库平均值
时间: 2023-11-23 10:58:24 浏览: 31
以下是使用pandas库计算平均值的例子:
1.计算DataFrame中某一列的平均值
```python
import pandas as pd
# 创建DataFrame
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
# 计算列A的平均值
mean_A = df['A'].mean()
print(mean_A) # 输出:2.0
```
2.计算DataFrame中多列的平均值
```python
import pandas as pd
# 创建DataFrame
df = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6], 'C': [7, 8, 9]})
# 计算列A、B、C的平均值
mean_ABC = df[['A', 'B', 'C']].mean()
print(mean_ABC) # 输出:A 2.0 B 5.0 C 8.0 dtype: float64
```
3.计算DataFrame中某一列的滚动平均值
```python
import numpy as np
import pandas as pd
# 创建DataFrame
df = pd.DataFrame()
df["data"] = np.random.rand(30)
# 计算data列的滚动平均值
simp_moving_avg = df["data"].rolling(window=3, center=True, min_periods=1).mean()
print(simp_moving_avg) # 输出:每个位置的滚动平均值
```