python中pandas的用法,python中使用pandas的频率表

如果需要临时显示数据，请使用display.max_rows尝试^{}：#temporary print 999 rows

with pd.option_context('display.max_rows', 999):

print freq

更多信息请参见docs。在

我尝试通过使用函数^{}和^{}修改解决方案，使用函数^{}处理字符串数据，^{}将输出写入file：

^{pr2}$

#get data which starts with 'com'

print s.str.startswith('com')

0 False

1 False

2 False

3 False

4 False

5 True

6 True

7 True

8 False

9 False

10 False

Name: Madding., dtype: bool

#filter rows, which not starts width 'com'

s = s[~s.str.startswith('com')]

print s

0 Madding.

1 Madding.

2 Madding.

3 Crowning.

4 Crowning.

8 Thy.

9 Thou.

10 The.

Name: Madding., dtype: object

#count freq

freq = s.value_counts()#temporary print 999 rows

with pd.option_context('display.max_rows', 999):

print freq

Madding. 3

Crowning. 2

Thou. 1

Thy. 1

The. 1

Name: Madding., dtype: int64

#write series to file by to_csv

freq.to_csv('dataOut.txt', sep=';')