I am working on to create a python automation program for Excel.
I wanted to divide the longitude based on the median number.
What I want to get data is :
1. get the median number of longitude from excel file, 2. separate longitude based on median number ex) if median number > 91: allocate above 91 longitude to 'A' else: allocate below 91 longitude to 'B'
Below is my code:
for i in range(2, maxRow+1): country = sheet.cell(i,7).value longitude = sheet.cell(i,6).value median = np.median(longitude) if country=="United States": print("Unnited States" + str(longitude))
Below is the output from this code. output
above the output is show all longitude in United States. However, I want to filter only 1. filter median from all the longitude, 2. if median > longitude: allocate longitudes to ‘A’ else: allocate longitudes to ‘B’
Could anyone help me with this issue ?
Advertisement
Answer
for i in range(2, maxRow+1): country = sheet.cell(i,7).value longitude = sheet.cell(i,6).value median = np.median(longitude) if country=="United States" and int(longitude)>-91: print("Unnited States" + str(longitude))