英文:
Python pandas, bad output while filtering
问题
你好，以下是您要求的代码部分的翻译：
from netmiko import ConnectHandlerfrom re import searchimport pandas as pdfrom io import StringIOimport reswitch = []NetworkDevice = {"host": "A.B.C.D","username": "blabla","password": "secureblabla","device_type": "cisco_ios", }Connect = ConnectHandler(**NetworkDevice)Connect.enablecommand = "sh int status"result = Connect.send_command(command).strip()print(result)switch.append(result)with open(r".\nst.csv", "w") as filout:for i in switch:filout.write(','.join(switch))header = re.split('\s+', result.split('\n', 1)[0])df = pd.read_csv(StringIO((result)), engine="python", skiprows=2, names=header)print(df[['Port']])
请注意，以上内容是您提供的代码的翻译，不包括问题的回答或其他内容。
英文:
Hello everyone I've a little issue that i'd like to be solve (like every issues no?)
First, i've made this code :
from netmiko import ConnectHandlerfrom re import searchimport pandas as pdfrom io import StringIOimport reswitch = []NetworkDevice= {"host" : "A.B.C.D","username" : "blabla","password" : "secureblabla","device_type" : "cisco_ios",}Connect = ConnectHandler(**NetworkDevice)Connect.enablecommand = "sh int status"result = Connect.send_command(command).strip()print(result)switch.append(result)with open (r".\nst.csv","w") as filout:for i in switch:filout.write(','.join(switch))header = re.split('\s+', result.split('\n', 1)[0])df = pd.read_csv(StringIO((result)), engine="python", skiprows=2, names=header)print(df[['Port']])
The output of this is :
Port Name Status Vlan Duplex Speed TypeGi0/1 connected 8 a-full a-1000 10/100/1000BaseTXGi0/2 notconnect 29 auto auto 10/100/1000BaseTXGi0/3 notconnect 20 auto auto 10/100/1000BaseTXGi0/4 notconnect 81 auto auto 10/100/1000BaseTXGi0/5 notconnect 8 auto auto 10/100/1000BaseTXGi0/6 notconnect 8 auto auto 10/100/1000BaseTXGi0/7 Borne DECT notconnect 1 auto auto 10/100/1000BaseTXGi0/8 notconnect 1 auto auto 10/100/1000BaseTXGi0/9 notconnect 1 auto auto Not PresentGi0/10 connected trunk a-full a-1000 10/100/1000BaseTXPort0 Gi0/2 notconnect 29 ...1 Gi0/3 notconnect 20 ...2 Gi0/4 notconnect 81 ...3 Gi0/5 notconnect 8 ...4 Gi0/6 notconnect 8 ...5 Gi0/7 Borne DECT notconnect 1 ...6 Gi0/8 notconnect 1 ...7 Gi0/9 notconnect 1 ...8 Gi0/10 connected trun...
The output is close to the result I want but i can't find the solution
I'd like to have just this output (for df ofc, not result) :
Gi0/1Gi0/2Gi0/3Gi0/4Gi0/5Gi0/6Gi0/7Gi0/8Gi0/9Gi0/10
Is there a way to do that ?
I searched for many hours with tricks like df.iloc or df[:,0] but nothing is working.
If someone has a way or an idea to help
Thanks in advance !
Lucas
答案1
得分: 0
提取DataFrame df 中的Series "Port"，只需使用df.Port。要去掉列名，只返回值，将其转换为列表。
thing_you_want = list(df.Port)
英文:
Sure, just extract the Series "Port" from df by merely doing df.Port. To get rid of the column name and just give back the values, cast to list.
thing_you_want = list(df.Port)
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论