Python Trending Weekly
ISSUE 70

Python in Microsoft Excel is Now Officially Available!

2024-09-21 Season 3

TL;DR

Python in Excel is officially here, WindowsDowndate shows how to hijack Windows Update into downgrade attacks, and sherlock hunts social media accounts by username.

Articles 12 Projects 12 Media 2
🦄

Articles & Tutorials

× 12
01 Python in Excel – Available Now techcommunity.microsoft.com

Python in Excel is now officially available! Compatible with Microsoft 365 Business and Enterprise editions, you can write Python directly in Excel with syntax highlighting and code completion, plus access to popular analytics libraries like Pandas, Matplotlib, and NLTK.

Visual analysis with NLTK in Excel
02 UV Roundup: Five good articles and a pre-commit tip micro.webology.dev

uv has evolved beyond just being a faster pip – it's becoming increasingly versatile. The author shares 5 articles about uv, all singing its praises without question. If you haven't heard of it yet, this is a great way to get up to speed. (Bonus: Some comments about uv on Mastodon)

03 Spiderweb: the Tiny Web Framework itsthejoker.github.io

The author built a web framework primarily to understand how web frameworks actually work. The article covers the framework's implementation principles, request handling flow, and the tricks and insights learned along the way.

04 7 Ways To Use Jupyter Notebooks inside PyCharm | The PyCharm Blog blog.jetbrains.com

PyCharm Professional offers robust support for Jupyter Notebooks. This article explores its various capabilities, including connecting to remote Jupyter Notebooks, importing data, viewing DataFrames and interactive charts, AI assistance, statistical classification, and data analysis.

05 Why Learn Python Concurrency? superfastpython.com

Do you understand Python concurrency? Why do all developers need to learn about concurrency? The SuperFastPython site has published tons of articles on concurrency, and this one explains what Python concurrency is and why it matters.

06 Let’s build and optimize a Rust extension for Python pythonspeed.com

How do you write a Rust extension for Python to boost performance? This tutorial shows how to package Rust code as a Python extension, compares performance improvement data, and implements multiple optimizations.

07 Randomness extractors: making fair coins out of biased coins bytepawn.com

The author explores deterministic randomness extraction – creating uniformly random output streams from potentially biased and correlated random input streams. The article uses Python to progressively implement increasingly complex randomness extractors.

08 Things I’ve learned serving on the board of the Python Software Foundation simonwillison.net

The PSF (Python Software Foundation) is a nonprofit organization that promotes Python and its community development. The author explains the organization's various activities and the responsibilities and impact of serving as a board member.

09 Classifying all of the pdfs on the internet snats.xyz

This article analyzes and classifies 8 million PDF files (8TB uncompressed) using LLMs, Embedding Models, XGBoost, and LinearRegressor, creating some beautiful visualizations in the process.

Classifying all of the pdfs on the internet
10 Build simple fuzzer part1 carstein.github.io

Fuzz testing is an automated testing technique that feeds massive amounts of random data to discover security vulnerabilities or bugs. This article series (4 parts) builds simple fuzzers to understand their importance.

11 Sans I/O when rubber meets the road fractalideas.com

Sans I/O is a software design pattern for implementing network protocols that excludes network I/O and async control flow, but can connect to network I/O frameworks through an I/O integration layer. The author of the websockets library uses it as an example to share Sans I/O's advantages in testing, reusability, and scalability, plus the challenges encountered in practice.

12 Why is language documentation still so terrible? walnut356.github.io

The author ruthlessly roasts the official documentation of almost every programming language for quality issues, including poor structure, inadequate search functionality, and insufficient examples. While praising Rust's documentation, they systematically call out problems with Python, C#, Java, C/C++, Go, and JavaScript docs...

🐿️

Projects & Resources

× 12
01 sherlock: Hunt down social media accounts by username across social networks github.com

Hunt down existing accounts by username across 400+ social networks. Supports batch searching. (58.6K stars)

02 WindowsDowndate: A tool that takes over Windows Updates to craft custom downgrades and expose past fixed vulnerabilities github.com

Takes over Windows update functionality to craft custom downgrades of fixed vulnerabilities, including OS components, DLLs, drivers, NT kernel, secure kernel, and more.

03 pyedifice: Declarative GUI framework for Python and Qt github.com

Inspired by modern declarative UI paradigms from web development, built in pure Python with hot reload for rapid iteration.

04 uvtrick: A fun party trick to run Python code from another venv into this one github.com

Uses uv and pickle to enable Python code execution across different virtual environments.

05 smartcut: Cut video files with minimal recoding github.com

A CLI video editing tool that performs retention and cutting operations based on specified timestamps, supporting multiple formats and codecs with near-lossless audio and video quality.

06 pyrtls: rustls-based modern TLS for Python github.com

Provides Python bindings for rustls, aiming to replace the ssl module (though not fully compatible), bringing security and performance to the Python world.

07 pocketpy: Portable Python 3.x Interpreter in Modern C github.com

A lightweight (~15K LOC) Python 3.x interpreter developed in C11, primarily for game scripting and designed to replace Lua. (1.6K stars)

08 wifi-crack-tool: WiFi Password Brute-Forcing Tool github.com

A Python-developed WiFi password cracker with a graphical interface, supporting WPA/WPA2/WPA3, multi-threading, automatic cracking, custom wordlists, and automatic password dictionary generation. (1.4K stars)

09 finic: Create Playwright-based browser agents to scrape websites and automate tasks github.com

A cloud platform that simplifies deployment and management of browser-based automation agents, enabling quick launch of bots, scrapers, RPA integrations, and other web services requiring multi-factor authentication. (2.1K stars)

10 papermill: Parameterize, execute, and analyze notebooks github.com

Parameterizes code in notebooks, allowing the same notebook to be executed multiple times with different parameters. (5.9K stars)

11 Local_Knowledge_Graph: A Local Knowledge Graph Based on Llama github.com

A Flask-based web application that uses local Llama models to process user queries, generate step-by-step reasoning, and visualize the thought process as an interactive knowledge graph.

12 Plain Text Accounting (PTA) plaintextaccounting.org

PTA refers to accounting and bookkeeping methods using plain text files and scriptable, command-line friendly software (like Ledger, hledger, or Beancount). This website curates tons of tools, videos, documentation, and practices.

🐢

Podcasts & Videos

× 2
01 Episode #400 Celebrating episode 400 pythonbytes.fm

Python Bytes podcast hits episode 400! Congrats to this long-running Python podcast!

02 13 Python Quirks That Will Surprise You youtube.com

This video shares 13 quirky Python features and explains in detail why these behaviors occur.

ESC
↑↓ select · ↵ open175 issues