从CSV文件创建字典
从CSV文件创建字典
提问于 2022-03-23 20:38:30
我需要从csv文件创建一个字典。CSV看起来会是这样的：
hostnames,device_platform,device_role
co-agg-r1,cisco_ios,co-agg-r
co-edg-fw,cisco_asa,co-edg-fw
co-acc-sw,cisco_ios,co-acc-sw
co-acc-rsw,broadcom_icos,co-acc-rsw我需要创建字典，以便主机名是键。就像这样：
devices_dict = {
'co-agg-r1': { 'device_platform': 'cisco_ios', 'device_role': 'co-agg-r'},
'co-edg-fw': { 'device_platform': 'cisco_asa', 'device_role': 'co-edg-fw'},
'co-acc-sw1': { 'device_platform': 'cisco_ios', 'device_role': 'co-acc-sw'},
'co-acc-rsw1': { 'device_platform': 'broadcom_icos', 'device_role': 'co-acc-rsw'}
}做这件事最简单的方法是什么？
回答 2
Stack Overflow用户
回答已采纳
发布于 2022-03-23 21:08:24
没有潘达斯的替代方案(潘达斯没有错)：
import csv
with open("file.csv", "r") as file:
reader = csv.reader(file)
keys = next(reader)[1:]
devices_dict = {key: dict(zip(keys, values)) for key, *values in reader}结果：
{'co-agg-r1': {'device_platform': 'cisco_ios', 'device_role': 'co-agg-r'},
'co-edg-fw': {'device_platform': 'cisco_asa', 'device_role': 'co-edg-fw'},
'co-acc-sw': {'device_platform': 'cisco_ios', 'device_role': 'co-acc-sw'},
'co-acc-rsw': {'device_platform': 'broadcom_icos', 'device_role': 'co-acc-rsw'}}Stack Overflow用户
发布于 2022-03-23 20:48:04
import pandas as pd
df = pd.read_csv("/tmp/data.csv") # data you provided
df.set_index("hostnames").T.to_dict() # or df.set_index("hostnames").to_dict("index")收益率
{'co-agg-r1': {'device_platform': 'cisco_ios', 'device_role': 'co-agg-r'},
'co-edg-fw': {'device_platform': 'cisco_asa', 'device_role': 'co-edg-fw'},
'co-acc-sw': {'device_platform': 'cisco_ios', 'device_role': 'co-acc-sw'},
'co-acc-rsw': {'device_platform': 'broadcom_icos',
'device_role': 'co-acc-rsw'}}页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/71593753
复制相关文章
相似问题
腾讯云开发者
