没有合适的资源?快使用搜索试试~ 我知道了~
Pandas版本1
资源详情
资源评论
资源推荐
120Pandas
“Python”
Python
120Pandas
Pandas120
120pandas
DataFrame
DataFrame
⭐
data = {"grammer":["Python","C","Java","GO",np.nan,"SQL","PHP","Python"],
"score":[1,2,np.nan,4,5,6,7,10]}
1
Python
公众号:早起Python
Python
import numpy as np
import pandas as pd
df = pd.DataFrame(data)
#
df = pd.DataFrame({
"grammer": ["Python","C","Java","GO",np.nan,"SQL","PHP","Python"],
"score": [1,2,np.nan,4,5,6,7,10]})
1-20
"Python"
⭐⭐
grammer score
0 Python 1.0
7 Python 10.0
Python
#> 1
df[df['grammer'] == 'Python']
#> 2
results = df['grammer'].str.contains("Python")
results.fillna(value=False,inplace = True)
df[results]
df
⭐
Index(['grammer', 'score'], dtype='object')
Python
2
3
公众号:早起Python
df.columns
'popularity'
⭐⭐
Python
df.rename(columns={'score':'popularity'}, inplace = True)
grammer
⭐⭐
Python
df['grammer'].value_counts()
⭐⭐⭐
Python
popularity3
⭐⭐
Python
# pandas
df['popularity'] = df['popularity'].fillna(df['popularity'].interpolate())
4
5
6
7
公众号:早起Python
df[df['popularity'] > 3]
grammer
⭐⭐
Python
df.drop_duplicates(['grammer'])
popularity
⭐⭐
Python
df['popularity'].mean()
# 4.75
grammerlist
⭐⭐
Python
df['grammer'].to_list()
# ['Python', 'C', 'Java', 'GO', nan, 'SQL', 'PHP', 'Python']
DataFrameEXCEL
⭐⭐
Python
8
9
10
11
公众号:早起Python
df.to_excel('filename.xlsx')
⭐
Python
df.shape
# (8, 2)
popularity37
⭐⭐
Python
df[(df['popularity'] > 3) & (df['popularity'] < 7)]
⭐⭐⭐
Python
temp = df['popularity']
df.drop(labels=['popularity'], axis=1,inplace = True)
df.insert(0, 'popularity', temp)
popularity
12
13
14
15
公众号:早起Python
剩余44页未读,继续阅读
方2郭
- 粉丝: 23
- 资源: 324
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0