Python Forum
Need to create a dictionary from a *.csv
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need to create a dictionary from a *.csv
#3
(Dec-17-2019, 04:09 PM)ichabod801 Wrote: The csv module has a DictReader class that converts the data into a dictionary. If that is not giving you the dictionary you want, perhaps you could show us a few rows of the data you have, and how you would want those rows to look when converted to a dictionary.

Thank you for the reply.

Here is an example of the output of the *.csv I am looking at.

IP_Address,NodeName,DeviceRole,sha1(DeviceRole)
xxx.xxx.xxx.xxx,sxxxr1,Branch Router,181B2DF9E3B6FF829F94FFD142ED9F965684F40B
xxx.xxx.xxx.xxx,sxxxsw1,Layer 3 Remote Switch,AD8CDCABA055C5FA52B4C2F39CD32E927B20B185
xxx.xxx.xxx.xxx,sxxxsw2,Layer 2 Remote Switch,4FA0DF65ACAB35ADCF923AF1E0164D12149A63DC

So I want to have a dictionary with key values for IP Address and Node Name. Those values are in row 1 of the *.csv file. I want every value under those put in a dictionary so that I can iterate through the dictionary and connect to the devices IP address/hostname.

I hope that makes sense.
Reply


Messages In This Thread
RE: Need to create a dictionary from a *.csv - by 74razor - Dec-17-2019, 04:50 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Create new dictionary angus1964 6 2,320 May-08-2022, 12:43 PM
Last Post: snippsat
  Create new dictionary angus1964 2 1,402 May-06-2022, 02:14 PM
Last Post: deanhystad
  Create a dynamic Menu from a editable Dictionary. KiNeMs 1 2,401 Jan-28-2020, 04:27 AM
Last Post: Larz60+
  Create a dictionary from a list klllmmm 3 3,101 Oct-06-2019, 05:50 PM
Last Post: Gribouillis
  Create XML from dictionary pygrrrl 7 141,578 Jul-29-2019, 08:33 PM
Last Post: pygrrrl
  Better way to create nested dictionary with defaultdict() x2mlh 8 22,112 Nov-30-2017, 08:10 PM
Last Post: buran
  create dictionary from **kwargs that include tuple bluefrog 2 5,074 Oct-26-2016, 10:24 PM
Last Post: Larz60+

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020