从索引中逐个打印多个输出

2024-04-19 13:50:42 发布

您现在位置:Python中文网/ 问答频道 /正文

import re
import pandas as pd
import sqlite3
connection = sqlite3.connect('C:\Users\wh112\Desktop\BRAIN.sqlite')
df1 = pd.read_sql('select * from PRONOUN',connection)
df2 = pd.read_sql('select * from VERB',connection)
df3 = pd.read_sql('select * from QUESTIONS',connection)

df = pd.concat([df1,df2,df3])

def word_list(text):
return list(filter(None, re.split('\W+', text)))


session = raw_input("Test on me!")
feedback = session
print(word_list(feedback))

dff = pd.DataFrame({'Sentence':[feedback]})
dff['1'] = dff['Sentence'].astype(str).str.split().str[0]
dff['2'] = dff['Sentence'].astype(str).str.split().str[1]
dff['3'] = dff['Sentence'].astype(str).str.split().str[2]

for pts1 in dff['1']:
  pts1 = df.columns[df.isin([pts1]).any()]
for pts2 in dff['2']:
 pts2 = df.columns[df.isin([pts2]).any()]
for pts3 in dff['3']:
 pts3 = df.columns[df.isin([pts3]).any()]

现在的主题是:

 pts1 = df.columns[df.isin([pts1]).any()]

当我用这个从数据库字符串中查找任何匹配项时;输出时同时显示多个匹配项。像这样:

Index([u'auxiliary_verbfirst_person_singular_pronounnon_wh_type'])

但我希望他们一个接一个的像:

Index([u'auxiliary_verb, first_person_singular_pronoun,non_wh_type'])

有什么办法可以帮我吗


Tags: columnsimportdfreadsqlanyconnectionselect