analysis专栏 03.数据处理分析模块 05.Pandas常用方法

# 05.Pandas常用方法

[toc]{type: "ol", level: [3,4,5]}

### 创建数据
```python
import pandas as pd
data = pd.DataFrame(
    {
        'Name': ['lili', 'bing', 'rose'],
        'Num': ['1001', '1002', '1003'],
        'Sex': ['man', 'woman', 'man'],
        'Age': [18, 20, 19],
        'Score': [80, 95, 48],
    }, 
    columns = ['Num', 'Sex', 'Age', 'Score'],
    index = ['lili', 'bing', 'rose']
)
data
```
![常用方法](imgs/25.png)


### 算数运算
```python
ages = data['Age']
ages
```
![常用方法](imgs/26.png)

#### 求平均值
```python
ages.mean()
```
::: details result
19.0
:::

#### 获取最大值
```python
ages.max()
```
::: details result
20
:::

#### 获取最小值
```python
ages.min()
```
::: details result
18
:::

#### 获取标准差
```python
ages.std()
```
::: details result
1.0
:::


### 排序
#### 升序
```python
ages.sort_values()
```
![常用方法](imgs/27.png)

#### 倒序
```python
ages.sort_values(ascending=False)
```
![常用方法](imgs/28.png)


### 条件过滤
#### Series筛选
```python
scores = data['Score']
scores[scores > scores.mean()]
```
![常用方法](imgs/29.png)

#### DataFrame筛选
```python
# 显示符合条件的行
data[scores > scores.mean()]
```
![常用方法](imgs/30.png)

#### 多个条件筛选
```python
# 注意将条件添加小括号
# ‘或使用：‘ | 
data[(scores > scores.mean()) & (ages < 19)]
```
![常用方法](imgs/31.png)