python vectorizing

Job ID: 34009858

Budget: $10 – $30 USD

I want to extract if data exists within a polygon. Unfortunately, I have big data; the speed is too slow. So I uploaded the big data to sharing drive.
Please check the ppt file to understand better.

I made a code. But, the code takes around 35 minutes, a very long time.

So I made a function with vectorization to improve speed. I attached the code with the vectorization function. (project.ipynb)

By the way, I noticed that the value in the last row is replaced with the total value.It seems to be an index problem, but I don't know how to solve it.