Category: Python
-
Python / PiSpark: Pivot on multiple rows
first… Let’s create some data that needs pivoting. What is special about this data is that it has two columns (Product and Categories) in its granularity and that we want to pivot two values out (Amount and Quantity).
-
Python: Extract UNSPSC from a PDF
Using the UNSPSC (United Nations Standard Products and Services Code) to identify hazardous materials is beneficial because it provides a global classification system that is standardized and consistent. This system facilitates the identification and categorization of products and services, including hazardous materials. Please note that the data source may contain information that is not up-to-date and could also be…
-
Python: Web scraping ISO3166
This Python script is meticulously crafted to extract ISO-3166 country data from the comprehensive list is available at https://www.iban.com/country-code. The script employs advanced web scraping techniques to programmatically navigate the website and retrieve all current country codes, names, and related information. It’s important to note that the ISO-3166 country data obtained from websites https://www.iban.com/country-code may be…