Convert a certain Munro table into more digestible

munro.py

import pandas as pd

munros = pd.read_csv("../physt/example/munrotab_v6.csv", encoding="latin-1")
munros = munros[munros["Post 1997"] == "MUN"]
munros["name"] = munros["Name"]
munros["height"] = munros["Height (m)"]

from bng_to_latlon import OSGB36toWGS84
munros["lat"], munros["long"] = tuple(zip(*[OSGB36toWGS84(*pair) for pair in (zip(munros.xcoord, munros.ycoord))]))
munros = munros[["name", "height", "long", "lat"]].reset_index(drop=True)
munros.to_csv("../physt/example/munros.csv")