Bottom Page

Thread Rating:
  • 2 Vote(s) - 4.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Get the info from 2 different rows in the same column using a one key
#1
Hi all,
Again I need your support!
I have the following excel file info:

Using the key “Site ID” I want to find the VLAN XXX about the key1 but if you observe the excel I have 2 rows for the same key1, I have the identification for the first row as “key1” and for the second row it’s blank but nevertheless that row also contains info about “key1”.

İmage


this is the coding:
 excel_file = u'*Personal SUR GUL EPT 20190103*'
 controller_file = u'*IPs Controladoras*'
 ip_plan_file = u'*IP PLAN South_2*'
 controller_Dict = LOAD_EXCEL_FILE(controller_file, "Sheet1", 1, "key2")
 ip_plan_Dict = LOAD_EXCEL_FILE(ip_plan_file, "Sheet2", 1, "Site ID")
 Site_2G_Dict = LOAD_EXCEL_FILE(excel_file,"Sheet3", 1, "Site Name")
 
 Base_Station_row_list = []
 Site_list = READ_TXT_FILE("site_list")
 for sites in Site_list:
     if sites not in Site_2G_Dict.keys(): # Check if SiteID exist in excel file
         print sites, "Not present in Personal excel file"
         continue
 		
 Site_2G_Info = Site_2G_Dict[sites]
 h = Site_2G_Info[0].attr("Site ID")
 
 # Device IP Address info
     for device_ip in ip_plan_Dict:
         if device_ip != h: continue
         device_ipplan_info = ip_plan_Dict[device_ip]
         i = device_ipplan_info[0].attr("IP Address")
with this coding, I can get the IP Address info “i = 10.1.2.1/30” but I don’t want the IP I want the VLAN XXX info “i = VLAN 1000”
Thanks in advance
Gribouillis wrote Jan-10-2019, 09:52 PM:
Fixed python tag, see BBCode help.
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  How to group by name and column in box plot SriRajesh 0 36 Mar-19-2019, 02:33 PM
Last Post: SriRajesh
  shifting specific column to before/after specific column in dataframe theinzawoo 4 83 Mar-19-2019, 10:55 AM
Last Post: scidam
  Split Column Text by Number of Characters cgoldstein 3 107 Mar-11-2019, 01:45 PM
Last Post: perfringo
  How to ger matching rows data based on index columns SriRajesh 1 71 Mar-08-2019, 11:05 AM
Last Post: scidam
  Comparing the count of rows from the tables that are present in two different databas krt5 6 146 Feb-15-2019, 03:20 PM
Last Post: krt5
  column order changes when copying rows in datafram swapnaharish 1 93 Feb-07-2019, 11:52 AM
Last Post: scidam
  Merge rows of 2 arrays vipinv23 2 156 Jan-27-2019, 05:45 PM
Last Post: aakashjha001
  Remove Rows based on condition abc123 1 159 Jan-12-2019, 10:45 PM
Last Post: Larz60+
  column math Devilish 1 176 Jan-06-2019, 01:38 AM
Last Post: scidam
  How to calculate variance(standard deviation) by column SriRajesh 2 228 Dec-27-2018, 12:35 PM
Last Post: SriRajesh

Forum Jump:


Users browsing this thread: 1 Guest(s)