String partitioning a column of a pandas dataframe
Using pandas str.partition to extract part of a URL
I have a dataframe of URLs to datasets available from the PxStat database of the Central Statistics Office (CSO). The URLs follow the same format. The dataset code can be extracted using string partitioning.