Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Exporting to Excel
#1
i am trying to Export the data to excel

list = [{'ip': u'9.11.180.3','endpoint': u'rd2ff5-az2-1519-1520_eth1-18_vpc', 'hostname': u'RD2APIC1', 'encap': u'vlan-42', 'epg': u'19_14_140_172', 'extpaths': u'topology/pod-2/protpaths-1519-1520/pathep-[rd2ff5-az2-1519-1520_eth1-18_vpc]'},{'ip': u'14.10.5.5','endpoint': u'eth1/2','hostname': u'RD2APIC1', 'encap': u'vlan-18', 'epg': u'14_70_7_0', 'extpaths': u'topology/pod-2/paths-1511/extpaths-102/pathep-[eth1/2]'}]
My Code :

filename = self.controller + ".xls"
        excel_file = xlwt.Workbook()
        sheet = excel_file.add_sheet('HOSTLIST')
        sheet.write(0, 0, "APIC")            
        sheet.write(0, 1, "VLAN")
        sheet.write(0, 2, "EPG")
        sheet.write(0, 3, "EndPoint")
        sheet.write(0, 4, "Extpath")
        for count in xrange(1, len(list) + 1):
            if list[count - 1]["epg"]:
                epg = list[count - 1]["epg"]
            else:
                epg = "UNKNOWN"

            sheet.write(count, 0, list[count - 1].get("hostname","UNKNOWN"))
            sheet.write(count, 1, list[count - 1].get("encap","UNKNOWN"))
            sheet.write(count, 2, epg)
            sheet.write(count, 3, list[count - 1].get("endpoint","UNKNOWN"))
            sheet.write(count, 4, list[count - 1].get("extpaths","UNKNOWN"))
        excel_file.save(filename)
[/python]

Link Below : Current and Expected Output :

[Image: iLsQkJc.png]

I have uploaded the image , its about current and expected output . Basically i need to split the "endpoint" if it starts with "rd" while exporting it to excel.

in this case "endpoint - rd2ff5-az2-1519-1520_eth1-18_vpc" needs to be splited as rd2ff5-az2-1519 and rd2ff5-az2-1520 in two rows inserted instead of one in the excel sheet.

Any suggestion/idea ?
Reply
#2
This is a shot from the hip but mabye something in this direction?

Before you react to my shitty coding, this code would most likely work if inserted "as is", im tired af atm (friday). This is more of a suggestion of how one could go about it.
And this might also be pure nonsense.... super tired :P

if "rd" in list[1][:2]: 
# list[1] is ment to be the part with endpoint. in my head it makes sense at this moment, when im not as tired, its likely that im way off
	endpoint = list[1].split('-')
	endpoint_1 = str(endpoint[0]) + str(endpoint[1]) + str(endpoint[2]) + str(endpoint[4])
	endpoint_2 = str(endpoint[0]) + str(endpoint[1]) + str(endpoint[3]) + str(endpoint[4])
	
	list_1 = list
	list_2 = list
	
	list_1[1] = endpoint_1
	list_2[1] = endpoint_2
Again, if its rubbish or simply stupid, please disregard this reply :).

Have a nice weekend!
Reply
#3
@Nuzvee : this says :

----> 2 endpoint = list[1].split('-')
      3 print endpoint

AttributeError: 'dict' object has no attribute 'split'
it says this too :

TypeError: unhashable type
Reply
#4
Aha, missed that it was a dict :) As i mentioned, i was tired xD.

May i though ask why u put it as a dict?
I am fairly new to programming overall so my basic knowledge is less than ideal, but wouldnt it be easier to set it as a list and exclude the column name from the dict and make it a list, and then define the columns with arrays for the list instead?
Reply
#5
well its like value against each item ... so its in dictionary..
Reply
#6
can we remove the section after "_ " in "endpoint"and export that to excel ? for e:g rd2ff5-az2-1519-1520_eth1-18_vpc needs to be "rd2ff5-az2-1519-1520" ?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Exporting Stock Fundamental Data to a CSV file with yahoo_fin DustinKlent 2 4,637 Aug-01-2022, 06:08 PM
Last Post: paulyan
  Exporting dataframes to excel without loosing datetime format Rafa 0 1,212 Oct-27-2021, 10:42 AM
Last Post: Rafa
  Exporting a huge dataFrame stylingpat 5 15,265 Mar-23-2021, 12:13 AM
Last Post: stylingpat
  exporting all lines YazeedbnMohmmed 2 2,075 Feb-24-2021, 03:29 AM
Last Post: YazeedbnMohmmed
  Python code for exporting table using Selenium gj31980 4 2,932 Aug-04-2020, 01:29 AM
Last Post: gj31980
  Exporting data from python into excel Zankawah 5 3,307 Jun-02-2020, 03:17 AM
Last Post: buran
  Exporting list with dictionary to Excel veromi22 0 3,011 Oct-15-2019, 12:54 AM
Last Post: veromi22
  Exporting Python Output to Notepad Nirmal 4 3,518 Sep-02-2018, 02:36 PM
Last Post: Nirmal
  Exporting Json events to a text file uklipse 3 2,618 Aug-21-2018, 02:12 PM
Last Post: buran

Forum Jump:

User Panel Messages

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