Python - cmd 명령어 결과 DataFrame 변환
import os
import pandas as pd
def get_dataframe_text(f) :
header = None
# df_task_info = pd.DataFrame(columns = ['processid', 'parentprocessid', 'commandline'])
flag = True
while True :
#1. text 데이터 확인
line = f.readline()
if not line : break
#2. text -> list 변환하여 길이 확인
line = line.split()
line_list = list(line)
if len(line_list) == 0 : continue
if flag == True :
flag = False
header = pd.Series(line_list)
df_task_info = pd.DataFrame(columns =header)
else :
df_task_info = df_task_info.append(pd.DataFrame([line_list], columns=header), ignore_index=True)
return df_task_info
f = os.popen("wmic process where \"name like 'NV%'\" get processid, parentprocessid")
df_task_info = get_dataframe_text(f)
f.close()
print("wmic commad result -> DataFram", df_task_info)