1.DataFrame基本操作
1.将下面的字典创建为DataFrame
| grammer | score | |
|---|---|---|
| 0 | Python | 1.0 |
| 1 | C | 2.0 |
| 2 | Java | NaN |
| 3 | GO | 4.0 |
| 4 | NaN | 5.0 |
| 5 | SQL | 6.0 |
| 6 | PHP | 7.0 |
| 7 | Python | 10.0 |
2.提取数据–提取含有字符串“Python”的行
| grammer | score | |
|---|---|---|
| 0 | Python | 1.0 |
| 7 | Python | 10.0 |
| grammer | score | |
|---|---|---|
| 0 | Python | 1.0 |
| 7 | Python | 10.0 |
3. 提取列名
4.修改第二列列名为‘popularity’
| grammer | popularity | |
|---|---|---|
| 0 | Python | 1.0 |
| 1 | C | 2.0 |
| 2 | Java | NaN |
| 3 | GO | 4.0 |
| 4 | NaN | 5.0 |
| 5 | SQL | 6.0 |
| 6 | PHP | 7.0 |
| 7 | Python | 10.0 |
5.统计grammer列中每种编程语言出现的次数
6.缺失值用上下值均值填充
| grammer | popularity | |
|---|---|---|
| 0 | Python | 1.0 |
| 1 | C | 2.0 |
| 2 | Java | 3.0 |
| 3 | GO | 4.0 |
| 4 | NaN | 5.0 |
| 5 | SQL | 6.0 |
| 6 | PHP | 7.0 |
| 7 | Python | 10.0 |
7.提取popularity列中值大于3的行
| grammer | popularity | |
|---|---|---|
| 3 | GO | 4.0 |
| 4 | NaN | 5.0 |
| 5 | SQL | 6.0 |
| 6 | PHP | 7.0 |
| 7 | Python | 10.0 |
8.按照grammer列进行去重
| grammer | popularity | |
|---|---|---|
| 0 | Python | 1.0 |
| 1 | C | 2.0 |
| 2 | Java | 3.0 |
| 3 | GO | 4.0 |
| 4 | NaN | 5.0 |
| 5 | SQL | 6.0 |
| 6 | PHP | 7.0 |
9.计算popularity列平均值
10.将grammer列转换为list
11.将dataframe保存为excel
12.查看数据行列数 形状
13.提取popularity列值大于3小于7的行
| grammer | popularity | |
|---|---|---|
| 3 | GO | 4.0 |
| 4 | NaN | 5.0 |
| 5 | SQL | 6.0 |
14.交换两列的位置
| popularity | grammer | |
|---|---|---|
| 0 | 1.0 | Python |
| 1 | 2.0 | C |
| 2 | 3.0 | Java |
| 3 | 4.0 | GO |
| 4 | 5.0 | NaN |
| 5 | 6.0 | SQL |
| 6 | 7.0 | PHP |
| 7 | 10.0 | Python |
15.提取popularity列最大值所在的行
| popularity | grammer | |
|---|---|---|
| 7 | 10.0 | Python |
16.查看数据最后5行
| popularity | grammer | |
|---|---|---|
| 3 | 4.0 | GO |
| 4 | 5.0 | NaN |
| 5 | 6.0 | SQL |
| 6 | 7.0 | PHP |
| 7 | 10.0 | Python |
17. 删除最后一行数据
18. 添加一行数据[‘Perl’,6.6]
19.对数据按照”popularity”列值的大小进行排序
| popularity | grammer | |
|---|---|---|
| 0 | 1.0 | Python |
| 1 | 2.0 | C |
| 2 | 3.0 | Java |
| 3 | 4.0 | GO |
| 4 | 5.0 | NaN |
| 5 | 6.0 | SQL |
| 7 | 6.6 | Perl |
| 6 | 7.0 | PHP |
20.统计grammer列每个字符串的长度
声明：本站部分文章及图片源自用户投稿，如本站任何资料有侵权请您尽早请联系jinwei@zod.com.cn进行处理,非常感谢！