Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Write list of list to CSV?
#11
the only problem I see is that dlist is already list of lists. But this will not prevent writing to file (although it may be not what you want:
Output:
device1,HundredGigE0/2/0/0,"['ALPHANUMERICWITHCHARAC;;;', 'ALPHANUMERICWITHCHARAC;;;', 'ALPHANUMERICWITHCHARAC;;;']" ,HundredGigE0/2/0/0.242, ,HundredGigE0/2/0/0.244 l2transport, ,HundredGigE0/2/0/1, ,HundredGigE0/2/0/0.244, device1,TenGigabitEthernet1/1/0.138,['ALPHANUMERICWITHCHARAC;;;'] device1,TenGigE0/1/0/15,['ALPHANUMERICWITHCHARAC;;;']
note that lst column is str repr of a list.
If you make it like this

import itertools
import csv
opo = ['device1', 'device1', 'device1']
intfname = [['HundredGigE0/2/0/0', 'HundredGigE0/2/0/0.242', 'HundredGigE0/2/0/0.244 l2transport', 'HundredGigE0/2/0/1', 'HundredGigE0/2/0/0.244'], ['TenGigabitEthernet1/1/0.138'], ['TenGigE0/1/0/15']]
descname = [['ALPHANUMERICWITHCHARAC;;;', 'ALPHANUMERICWITHCHARAC;;;', 'ALPHANUMERICWITHCHARAC;;;'], ['ALPHANUMERICWITHCHARAC;;;'], ['ALPHANUMERICWITHCHARAC;;;']]# ['0/2/0/0info1', '0/2/0/0.242info2', '0/2/0/0.244info3']

opo = [[ele] for ele in opo]
 
## EXPORT AS CSV
with open('intlist.csv', 'w', newline='') as updatecsv:
    write = csv.writer(updatecsv, delimiter=',',lineterminator='\n')
    for cols in zip(opo,intfname,descname):
        rows = itertools.zip_longest(*cols, fillvalue='')
        write.writerows(rows)
updatecsv.close()
print ("Done...")
the output will be
Output:
device1,HundredGigE0/2/0/0,ALPHANUMERICWITHCHARAC;;; ,HundredGigE0/2/0/0.242,ALPHANUMERICWITHCHARAC;;; ,HundredGigE0/2/0/0.244 l2transport,ALPHANUMERICWITHCHARAC;;; ,HundredGigE0/2/0/1, ,HundredGigE0/2/0/0.244, device1,TenGigabitEthernet1/1/0.138,ALPHANUMERICWITHCHARAC;;; device1,TenGigE0/1/0/15,ALPHANUMERICWITHCHARAC;;;
Note that desc values go to first three lines, I don't know if this is correct

What I try to say is if the print output is OK, then second part should work too (i.e. the lists are populated with values, not empty)

you can make opo list of lists by design, when you create it in the first place.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply


Messages In This Thread
Write list of list to CSV? - by searching1 - Feb-24-2019, 01:13 AM
RE: Write list of list to CSV? - by Larz60+ - Feb-24-2019, 01:28 AM
RE: Write list of list to CSV? - by Larz60+ - Feb-24-2019, 01:49 AM
RE: Write list of list to CSV? - by searching1 - Feb-24-2019, 01:50 AM
RE: Write list of list to CSV? - by buran - Feb-24-2019, 06:42 AM
RE: Write list of list to CSV? - by searching1 - Feb-24-2019, 07:58 AM
RE: Write list of list to CSV? - by buran - Feb-24-2019, 08:17 AM
RE: Write list of list to CSV? - by searching1 - Feb-24-2019, 08:28 AM
RE: Write list of list to CSV? - by buran - Feb-24-2019, 08:43 AM
RE: Write list of list to CSV? - by searching1 - Feb-24-2019, 09:03 AM
RE: Write list of list to CSV? - by buran - Feb-24-2019, 09:10 AM
RE: Write list of list to CSV? - by searching1 - Feb-24-2019, 09:33 AM
RE: Write list of list to CSV? - by buran - Feb-24-2019, 09:37 AM
RE: Write list of list to CSV? - by searching1 - Feb-24-2019, 06:41 PM
RE: Write list of list to CSV? - by buran - Feb-24-2019, 06:43 PM
RE: Write list of list to CSV? - by SmartGrid - Feb-24-2019, 07:57 PM
RE: Write list of list to CSV? - by searching1 - Feb-25-2019, 03:26 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Strange behavior list of list mmhmjanssen 3 441 May-09-2024, 11:32 AM
Last Post: mmhmjanssen
  No matter what I do I get back "List indices must be integers or slices, not list" Radical 4 1,365 Sep-24-2023, 05:03 AM
Last Post: deanhystad
  Delete strings from a list to create a new only number list Dvdscot 8 1,721 May-01-2023, 09:06 PM
Last Post: deanhystad
  List all possibilities of a nested-list by flattened lists sparkt 1 996 Feb-23-2023, 02:21 PM
Last Post: sparkt
  Сheck if an element from a list is in another list that contains a namedtuple elnk 8 1,999 Oct-26-2022, 04:03 PM
Last Post: deanhystad
Question Keyword to build list from list of objects? pfdjhfuys 3 1,690 Aug-06-2022, 11:39 PM
Last Post: Pedroski55
  Split a number to list and list sum must be number sunny9495 5 2,444 Apr-28-2022, 09:32 AM
Last Post: Dexty
  How to check if a list is in another list finndude 4 1,949 Jan-17-2022, 05:04 PM
Last Post: bowlofred
  Different out when using conda list and pip list Led_Zeppelin 1 4,191 Jan-14-2022, 09:30 PM
Last Post: snippsat
  Use one list as search key for another list with sublist of list jc4d 4 2,284 Jan-11-2022, 12:10 PM
Last Post: jc4d

Forum Jump:

User Panel Messages

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