首页 > 解决方案 > 如何获取每个打开窗口的名称列表并将其放入数据框中?

问题描述

所以我试图同时使用 win32gui 和 Pandas 来获取打开的窗口的数据框(df)。下面是我写的。我最终得到一个错误。我怎样才能返回一个数据框?

# info http://timgolden.me.uk/pywin32-docs/win32gui__EnumWindows_meth.html

import win32gui
import pandas as pd

def winEnumHandler( hwnd, dfx ):
    if win32gui.IsWindowVisible( hwnd ) and len(win32gui.GetWindowText( hwnd ))>0 :
    idv = hex(hwnd)
    winv = win32gui.GetWindowText(hwnd)
    df = pd.DataFrame({'ID' : idv , 'Window': winv}, index = ['0'])

    frames  = [dfx, df]
    dfx = pd.concat(frames)
    # print(dfx) 
    return dfx # Comment out this and it runs but not the result I want.

dfx= pd.DataFrame() # empty dataframe
win32gui.EnumWindows( winEnumHandler, dfx )
print(dfx)

追溯

Traceback (most recent call last):
  File "c:\Users\s...\Python\List of windows.py", line 19, in <module>
    win32gui.EnumWindows( winEnumHandler, dfx )
TypeError: an integer is required (got type DataFrame)

标签: pythonpandaswin32gui

解决方案


因此,将数据框从函数中取出的关键是使用全局变量。这个变量在函数内部必须是全局的,这样就不会混淆,python 也不认为它是局部变量。这是代码。

import win32gui
import pandas as pd

dfx = pd.DataFrame() 
i = 0

def winEnumHandler( hwnd, x ):
    global dfx, i

    if win32gui.IsWindowVisible( hwnd ) and len(win32gui.GetWindowText( hwnd ))>0 :
        idv = hex(hwnd)
        winv = win32gui.GetWindowText(hwnd)
        df = pd.DataFrame({'ID' : idv , 'Window': winv}, index = [i])
        frames  = [dfx, df]
        dfx = pd.concat(frames)
        i += 1

win32gui.EnumWindows( winEnumHandler, i )
print(dfx)

推荐阅读