Coordinates - Area blocks lookup

By Timothy Treagus, Yazi

⁠
`www.askyazi.com`⁠

Example of areas from coordinates

⁠

1_100.csv

18.8 kB

⁠

Area → Block map

⁠

Load Shedding Area Mapping (ALL) - ALL AREAS.csv

5.5 MB

⁠

Google Sheet Link⁠

⁠

Code Method:

Step 1:

From Example areas from coordinates CSV (’1_100.csv’) Split text into columns from the right (not left) and move the columns over to the left if no value for postcode in area string

Output 'cleaned_data.csv'

Step 2:

Lookup Province in 'Load Shedding Area Mapping (ALL) - ALL AREAS.csv' from 'cleaned_data.csv'

If province condition met, lookup ‘Suburb’ from ‘AREA’ in the Area→block CSV

Add new column to 'cleaned_data.csv' called ‘BLOCK’ with the load shedding block looked up

Splitting area into columns from right : Code

⁠

Splitting area into columns from right .py

1.2 kB

⁠

Looking up area to get Block

⁠

main (2).py

2 kB

⁠

Loading…⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.