从 Pandas 中的数据帧中仅获取大写单词
要仅获取大写单词,我们使用正则表达式。这里是 re 模块的使用,并进行导入。让我们导入所有库 −
import re import pandas as pd
创建一个数据帧 −
data = [['computer', 'mobile phone', 'ELECTRONICS', 'electronics'],['KEYBOARD', 'charger', 'SMARTTV', 'camera']] dataFrame = pd.DataFrame(data)
现在,提取大写单词 −
for i in range(dataFrame.shape[1]):
for ele in dataFrame[i]:
if bool(re.match(r'\w*[A-Z]\w*', str(ele))):
print(ele)示例
代码如下 −
import re
import pandas as pd
# create a dataframe
data = [['computer', 'mobile phone', 'ELECTRONICS', 'electronics'],['KEYBOARD', 'charger', 'SMARTTV', 'camera']]
dataFrame = pd.DataFrame(data)
# dataframe
print"Dataframe...\n",dataFrame
print"\nDisplaying only capital words...\n"
# extracting capital words
for i in range(dataFrame.shape[1]):
for ele in dataFrame[i]:
if bool(re.match(r'\w*[A-Z]\w*', str(ele))):
print(ele)输出
这将产生以下输出 −
Dataframe... 0 1 2 3 0 computer mobile phone ELECTRONICS electronics 1 KEYBOARD charger SMARTTV camera Displaying only capital words... KEYBOARD ELECTRONICS SMARTTV
广告
数据结构
网络
RDBMS
操作系统
Java
iOS
HTML
CSS
Android
Python
C 编程
C++
C#
MongoDB
MySQL
Javascript
PHP