pandas筛选数据

最新推荐文章于 2023-01-10 17:42:33 发布

生如夏花~之绚烂

最新推荐文章于 2023-01-10 17:42:33 发布

阅读量111

点赞数

分类专栏： python

本文链接：https://blog.csdn.net/qq_41663800/article/details/101015614

版权

python 专栏收录该内容

120 篇文章 1 订阅

订阅专栏

代码

import pandas as pd


data = {
	'sno':['14770110', '14770111', '14770112', '14770113', '14730114'],
	'sname':['李白', '赵云', '干将', '鲁班', '花木兰'],
	'sex':['man', 'woman', 'man', 'woman', 'man'],
}

df = pd.DataFrame(data)


print(df)
print('='*30)
print(df.sex == 'woman')
print('='*30)
print(type(df.sex == 'woman'))
print('='*30)
print(df[df.sex == 'woman'])
print('='*30)

print(df['sex'].value_counts())#得到每个属性的个数
print('='*30)
print(type(df['sex'].value_counts()))
print('='*30)

print(df.groupby(by = ['sex']))
print('='*30)
print(df.groupby(by = ['sex']).count())
print('='*30)
print(df.groupby(by = ['sex']).count().reset_index())#参数inpalce = Ture

运行结果

        sno sname    sex
0  14770110    李白    man
1  14770111    赵云  woman
2  14770112    干将    man
3  14770113    鲁班  woman
4  14730114   花木兰    man
==============================
0    False
1     True
2    False
3     True
4    False
Name: sex, dtype: bool
==============================
<class 'pandas.core.series.Series'>
==============================
        sno sname    sex
1  14770111    赵云  woman
3  14770113    鲁班  woman
==============================
man      3
woman    2
Name: sex, dtype: int64
==============================
<class 'pandas.core.series.Series'>
==============================
<pandas.core.groupby.generic.DataFrameGroupBy object at 0x000001E1117EA710>
==============================
       sno  sname
sex              
man      3      3
woman    2      2
==============================
     sex  sno  sname
0    man    3      3
1  woman    2      2
[Finished in 0.8s]