# Order the products by the difference in suggested retail price and average selling price. from nested import product_db from pythonql.helpers import print_table res = [ select (make,model,diff) for p in product_db let model = p['model'], # Again, we use the try-except construct to drill # into the objects make = try p['manufacturer']['company'] except p['manufacturer'], price = p['price'], diff = try (price['suggested_retail_price'] - price['average_price']) except 0 order by diff desc ] print_table(res)
Welcome to the PythonQL Web Demo
The Demo is organized into a number of scenarios that demonstrate the power and usability of PythonQL.
Each scenario illustrates a specific use case in data science that is addressed by PythonQL.