Skip to content
Advertisement

Python filter from Excel

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 :

JavaScript

Below is my code:

JavaScript

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

JavaScript
User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement