[数据分析]Pandas自测20题
Crossin的编程教室
共 2005字,需浏览 5分钟
·
2020-09-20 03:46
Pandas 是用 Python 进行数据分析时最常用也是最强大的工具库。今天我们通过习题的形式整理了 pandas 中一些比较基础的常用操作。如果你是位 Pandas 新手,不妨通过此练习检验一下自己对基础的掌握情况;如果你是高手,欢迎留言给出与答案的不同解法。Here we go!
data = {"grammer":["Python","C","Java","GO",np.nan,"SQL","PHP","Python"],
"score":[1,2,np.nan,4,5,6,7,10]}
df = pd.DataFrame(data)
grammer score
0 Python 1.0
7 Python 10.0
result=df[df['grammer'].str.contains("Python")]
Index(['grammer', 'score'], dtype='object')
df.columns
df.rename(columns={'score':'popularity'}, inplace = True)
df['grammer'].value_counts()
df['popularity'] = df['popularity'].fillna(df['popularity'].interpolate())
df[df['popularity'] > 3]
df.drop_duplicates(['grammer'])
df['popularity'].mean()
df['grammer'].to_list()
df.to_excel('filename.xlsx')
df.shape
df[(df['popularity'] > 3) & (df['popularity'] < 7)]
temp = df['popularity']
df.drop(labels=['popularity'], axis=1,inplace = True)
df.insert(0, 'popularity', temp)
df[df['popularity'] == df['popularity'].max()]
df.tail()
df = df.drop(labels=0)
row={'grammer':'Perl','popularity':6.6}
df = df.append(row,ignore_index=True)
df.sort_values("popularity",inplace=True)
df['grammer'].map(lambda x: len(x))
作者:刘早起早起
来源:早起Python
_往期文章推荐_
评论