Topic Archive

Data

  • From SQL to SQLModel: A Cleaner Way to Work with Databases in Python

    Ahmed Lemine

    ·

    ·

    17 min read

    SQLModel is a library that lets you interact with databases through Python code with Python objects and type annotations instead of writing direct SQL queries. Created by the same author of the extremely popular framework FastAPI, it aims to make interacting with SQL DBs in Python easier and elegant, with data validation and IDE support, […]

  • NLP Made Easy: How We Prioritize Exercise Improvements with a Few Lines of Code

    Bob Belderbos

    ·

    ·

    5 min read

    We highly appreciate user feedback for continuous improvement. With hundreds of Bite exercises and thousands of reviews, it’s easy to get overwhelmed by the data. 😱 How do you uncover insights from this sea of feedback? Use code! 😎 Enter TextBlob, a Python library that abstracts away the complexities of Natural Language Processing (NLP). This […]

  • A Practical Example of the Pipeline Pattern in Python

    Juan José Expósito González

    ·

    ·

    5 min read

    What is this pattern about? The Pipeline design pattern (also known as Chain of Command pattern) is a flexible way to handle a sequence of actions, where each handler in the chain processes the input data and passes it to the next handler. This pattern is commonly used in scenarios involving data processing, web scraping, […]

  • OpenStreetMap, Overpass API and Python

    Judith Vockenroth

    ·

    ·

    7 min read

    OpenStreetMap (OSM) is known for being an open source project that allows people to browse the world map and to plan routes. However it is more than that. Among others it provides a read-only API that allows users to query for very diverse map data: Overpass API Data structure of OSM To understand the structure […]

  • Using Python in Excel with PyXLL

    PyBites Team

    ·

    ·

    1 min read

    In this podcast episode we talk with Tony Roberts, creator of PyXLL (pronounced “pixel”).  Listen here: Also released on our YouTube channel: We dive into the backstory of this Python Excel Add-in, why he built it, features, success stories, the business side of things, and also how it compares to Microsoft’s recently announced Python in […]

  • Making plots in your terminal with plotext

    Bob Belderbos

    ·

    ·

    2 min read

    In this blog post a quick script to plot the frequency of our blog articles in the terminal. It’s good to see that we’re getting back on track 🙂 The code gist is here. First we import the libraries we are going to use. As always we separate Standard Library modules from 3rd party ones […]

  • Data engineering involves more Python than you might think!

    PyBites Team

    ·

    ·

    1 min read

    Listen here: This week we have Christo back on the show to talk about his experience in the data engineering field. He shares some valuable tips how to become a more effective data engineer which, surprisingly or not, increasingly requires a well-rounded Python developer skill set. Enjoy and feel free to reach out to Christo below … Christo’s website: https://www.christoolivier.com […]

  • Case study: How to parse nested JSON

    Michael Aydinbas

    ·

    ·

    10 min read

    I was asked to help parse a JSON file that is delivered by the iTunes Store Customer Reviews API JSON endpoint. It is not so important how this API works or if there are better APIs for this. Instead, let’s assume that we found our favorite API to work with and that our request makes […]