~pycoders | Issue #612 (Jan. 16, 2024) (23)

Exploring Python in Excel Are you interested in using your Python skills within Excel? Would you like to share a data science project or visualization as a single Office file? This week on the show, we speak with Principal Architect John Lam and Sr. Cloud Developer Advocate Sarah Kaiser from Microsoft about Python in Excel. REAL PYTHON podcast

Python 3.13 Gets a JIT This article does a deeper dive into the JIT recently added to the CPython 3.13 pre-release. This JIT is a bit different, it is called a copy-and-patch JIT, and the post explains what that means. ANTHONY SHAW

NumPy 2 Is Coming: Preventing Breakage, Updating Your Code NumPy 2 is coming, and it’s backwards incompatible. Learn how to keep your code from breaking, and how to upgrade. ITAMAR TURNER-TRAURING

Build Invincible Apps With Temporal’s Python SDK Get an introduction to Temporal’s Python SDK by walking through our easy, free tutorials. Learn how to build Temporal applications using Python, including building a data pipeline Workflow and a subscription Workflow. Get started here → TEMPORAL sponsor

Learn From 2023’s Most Popular Python Tutorials and Courses Revisit your favorite Real Python tutorials and video courses from 2023. Explore various topics, from Python basics to web development, machine learning, and effective coding environments. It’s been a busy year of learning, and there’s something for everyone to discover and build upon in 2024. REAL PYTHON

Python’s Array: Working With Numeric Data Efficiently In this tutorial, you’ll dive deep into working with numeric arrays in Python, an efficient tool for handling binary data. Along the way, you’ll explore low-level data types exposed by the array module, emulate custom types, and even pass a Python array to C for high-performance processing. REAL PYTHON

Data Deduplication in Python with RecordLinkage Duplicate detection is a critical process in data preprocessing, especially when dealing with large datasets. In this tutorial, you will explore data deduplication using Python’s RecordLinkage package, paired with Pandas for data manipulation. PATRYK SZLAGOWSKI • Shared by Izabela Pawlik

The Curious Case of Pydantic and the 1970s Timestamps When parsing Unix timestamps, Pydantic guesses whether to interpret them in seconds or milliseconds. While this is certainly convenient and works most of the time, it can drastically (and silently) distort timestamps from a few decades ago. ARIE BOVENBERG • Shared by Arie Bovenberg

A Critical Supply Chain Attack on PyTorch This post describes how coders found an exploit in the PyTorch supply chain, leaving the repo and its maintainers up for attack. Full details on what the vulnerability was and how to avoid the problem in your own repos is covered. JOHN STAWINSKI

Comparing Coroutines, by Example, in Kotlin and Python This series of 3 articles compares Python and Kotlin, with a focus on coroutines and generators. It compares, through examples, how coroutines are used in both languages, to read files and perform network requests. MEDIUM.COM • Shared by Carmen Alvarez

Enhance Your Flask Web Project With a Database Adding a database to your Flask project elevates your web app to the next level. In this tutorial, you’ll learn how to connect your Flask app to a database and how to receive and store posts from users. REAL PYTHON

SQLALchemy vs Django ORM If you are working with Django ORM most of the time and then switching to SQLAlchemy, you may face some unexpected behavior. This post describes the most important differences between them. ALEXEY EVSEEV

Annotating *args and **kwargs in Python “Typing *args and **kwargs has always been a pain since you couldn’t annotate them precisely before.” This article shows you what your options are when typing function signatures. REDOWAN DELOWAR

Python Gotcha: Modifying a List While Iterating Python makes it easy to modify a list while you are iterating through it’s elements. This will bite you. Read on to find out how and what can be done about it. ANDREW WEGNER

A Deep Dive Into Python’s functools.wraps Decorator Take a deep dive into Python’s functools.wraps decorator to learn how it maintains metadata in your code. A concise guide to effective decorator use. JACOB PADILLA

max() is broken The built-in function max in Python is broken and this article explains why, drawing parallels with other programming and mathematics concepts. MATHSPP.COM • Shared by Rodrigo Girão Serrão

All PyCon 2023 (US and AU) Talks Sorted by the View Count A full list of PyCon talks given in the US and Australia which are available on YouTube, and sorted by popularity. SUBSTACK.COM