Issue #553

Python + Power BI, Parallel Loops, Fast Testing, and More

Nov. 29, 2022

Python + Power BI, Parallel Loops, Fast Testing, and More
#553 – NOVEMBER 29, 2022 VIEW IN BROWSER
The PyCoder’s Weekly Logo
Microsoft Power BI and Python: Two Superpowers Combined
In this tutorial, you’ll learn how to install and configure Microsoft Power BI to work with Python. Using Python, you’ll import data from a SQLite database, transform and augment your dataset with pandas, and visualize it with Matplotlib.
REAL PYTHON

Parallel Nested for-Loops in Python
Nested for-loops often are an opportunity for parallel code. This article covers when it is a good idea to split them up and the variety of different parallel coding approaches you can use.
JASON BROWNLEE

Painless and Worry Free Postgres
Find out why vanilla Postgres is a more cost effective and simple way to manage your database than shiny Postgres “compatible” databases. Performance tuned, no-forks, quality Postgres with expert support. Built for developer experience. Get started today →
CRUNCHY DATAsponsor

How We Run Tests in Hundreds of Environments Really Fast
Anton describes the test setup at Sentry and how they use both tox in parallel as well as GitHub actions to run a large test suite quickly.
ANTON PIRKER


Discussions


The Origins of Python
This discussion is around the excellent article by Lambert Meertens called The Origins of Python that delves into Python’s history.
HACKER NEWS


Python Jobs


Software Engineer - Weissman Lab
WHITEHEAD INSTITUTE FOR BIOMEDICAL RESEARCH 📍 CAMBRIDGE, MA, USA

Senior Software Engineer (Python, Qt, Linux)
VIOLET 📍 ANYWHERE

More Python Jobs >>>


Articles & Tutorials


Everyday Project Packaging With pyproject.toml
In this Code Conversation video course, you’ll learn how to package your everyday projects with pyproject.toml. Playing on the same team as the import system means you can call your project from anywhere, ensure consistent imports, and have one file that’ll work for many build systems.
REAL PYTHON course

Always Use [closed, open) Intervals
“Intervals or ranges pop-up everywhere in the programming world. The classic example is picking a start and end date, like you would when booking an AirBnB or a flight. Have you ever wondered why they are always implemented as [closed, open) as opposed to [closed, closed]?”
FERNANDO HURTADO CARDENAS

Top 10 Vulns Impacting Open Source in 2022
You might know all about the incredibly useful and insightful OWASP Top 10 list from 2021, but what about the exact CVEs that could be lurking in your applications? Check out Snyk Top 10 Open Source Vulnerability report to get up to date on 2022’s most common vulnerabilities →
SNYK.IOsponsor

16 Reasons to Use VS Code for Developing Jupyter Notebooks
“Visual Studio Code is one of the most popular text editors with a track record of continual improvements. One area where VS Code has been recently innovating is its Jupyter Notebook support.” Read on to see how this might help you.
CHRIS MOFFITT

Python Bytecode Explained
When a Python program is run, the interpreter first parses your code and checks for syntax errors, then it translates it into bytecode instructions. This article explains some of the features of Python bytecode.
MOSER MICHAEL

plydata: Piping for Pandas
The plydata Python package enables you to use the pipe operator, ">>", to chain operations on a pandas dataframe. Read on to learn how to use it and how it compares to the equivalent operation in R.
MARCIN KOZAK • Shared by Marcin

REPL Driven Development
REPL Driven Development is about fast feedback loops during development. It is not about typing code into a terminal window. David talks about this coding workflow and how it is similar to TDD.
DAVID VUJIC • Shared by David Vujic

Python JSONPath With Example
JSONPath is an expression language that is used to parse the JSON data in Python, similar to XPath in XML. This article covers the basics of finding paths in JSON using the library.
SRINIVAS RAMAKRISHNA

Deploy Django, Celery, Redis & Postgres With Docker-Compose
Deployments can be painful. This article describes one approach to deploying Django, Celery, Redis, and Postgres with docker-compose so you can reuse it in your app!
PIOTR PŁOŃSKI • Shared by Piotr Płoński

Deepnote Is a Modern Notebook Where Data Teams Go to Explore, Collaborate, and Solve Hard Problems
Explore data with Python & SQL from your browser. Add context with data visualizations and rich text editing. Share analysis with stakeholders by simply sending a link. Plans start at $0 (free).
DEEPNOTEsponsor

Private, “Protected” Attributes in Python Demystified
A guide to private and protected attributes in Python, learn all about when to use and when not to use leading underscores and double underscores (dunder).
AMIR AFIANIAN • Shared by Amir Afianian

Investigating a Backdoored PyPI Package Targeting FastAPI
Using an open source security scanner, the authors found a backdoored package on PyPI. Read on for details about how they found it and what it contained.
TURCKHEIM & TAFANI-DEREEPER


Projects & Code


Brought to you by Real Python for Teamssponsor
Online Python training created by a community of experts. Give your team the real-world Python skills they need to succeed →

quickadd: Parse Natural Language Time and Date Expressions
GITHUB.COM/ACREOM

Python Tools for the Polylith Architecture
GITHUB.COM/DAVIDVUJIC • Shared by David Vujic

django-virtual-models: Django ORM Prefetching Layer
GITHUB.COM/VINTASOFTWARE

Colossal-AI: Unified Deep Learning System for Big Model Era
GITHUB.COM/HPCAITECH

pytorch-image-models: Models, Scripts, Pre-Trained Weights
GITHUB.COM/RWIGHTMAN

📆🐍 Upcoming Python Events


NZPUG-Auckland Coding Challenge “Office Hours”
November 30, 2022

Deep Learning With PyTorch
November 30, 2022

Weekly Real Python Office Hours Q&A (Virtual)
November 30, 2022

PyDelhi User Group Meetup
December 3, 2022

Sydney Python User Group (SyPy)
December 1, 2022
Happy Pythoning!
Copyright © 2022 PyCoder’s Weekly, All rights reserved.