Python Weekly (Issue 491 March 18 2021)

Python Weekly - Issue 491

March 18, 2021

Python Weekly

Welcome to issue 491 of Python Weekly. Let's get straight to the links this week.

From Our Sponsor 

A weekly newsletter featuring the best hand curated news, articles, tutorials, talks, tools and libraries etc for programmers.

Articles, Tutorials and Talks

In this tutorial, we’ll explore working with Excel spreadsheets in Python, using the openpyxl library and other tools. In particular, we’ll learn how to: Process Excel files as input, with various methods to access the data in them, Evaluate formulas and Write Excel files as output.

A lunchtime story to demonstrate threading, asyncio, multiprocessing & cloud functions.

VizTracer traces concurrent Python programs to help with logging, debugging, and profiling.

We will briefly discuss various options of streaming video over the internet and see a simple streaming video example using FastAPI that will show the video in the browser using the HTML5 video tag.

This article gives you a high level, example driven, overview of writing data processing programs using the Python programming language bindings for Spark which is commonly known as PySpark. It specifically covers the Spark SQL DataFrame API which is the most useful way to write data analytics code with PySpark. 

Comparing zope.interface and typing.Protocol.

Optimizing pandas memory usage by the effective use of datatypes.

This post highlights a new project: Python-on-whales. The goal of this project is to have a 1-to-1 mapping between the Docker CLI and the Python library.

Interesting Projects, Tools and Libraries

A unified approach to federated learning. Federate any workload, any ML framework, and any programming language.

Baserow is an open source online database tool and Airtable alternative. Create your own database without technical experience. Our user friendly no-code tool gives you the powers of a developer without leaving your browser.

An itty-bitty PaaS that uses git push to deploy micro-services and websites on your own servers.

Track live sentiment for stocks from Reddit and Twitter and identify growing stocks.

Mac-style shortcut keys for Linux & Windows. 

Auto-Editor is a command line application for automatically editing video and audio by analyzing where sections are silent and cutting them up.

Python library to make development of portfolio analysis faster and easier.

Machine learning metrics for distributed, scalable PyTorch applications.

Find regular expressions which are vulnerable to ReDoS (Regular Expression Denial of Service)

Django app for building dashboards using raw SQL queries.

A PyTorch-based Speech Toolkit.

A deep learning-based translation library built on Huggingface transformers.

A convention over configuration workflow orchestrator. Develop locally (Jupyter or your favorite editor), deploy to Airflow or Kubernetes.

An asynchronous ODM for MongoDB, based on Motor and Pydantic.

New Releases

This release largely focused on bug fixes and stabilization work in our Python, Pylance and Jupyter extensions, and includes a preview of improved Jedi language server support for our Python Insiders.  

This is the most extensive release for SQLAlchemy in at least ten years, featuring a major rethink of the most prominent APIs in Core and ORM, vastly revised internals, and a wide range of significant new features and capabilities.

Upcoming Events and Webinars

An introduction to PyTest with lots of simple, hackable examples. We'll start from nothing, add assertions, write some fixtures, do some parametrization, and mark tests. You'll see simple examples of the power that pytest can bring to your testing.

There will be following talks

  • From RGB-D images to complete point clouds

  • Where are the Earth's streams flowing right now? - Dynamic hydrology maps from satellite-LiDAR fusion

There will be following talks

  • DevOps for developers (or maybe against them?

  • Streamlit: Fast building and sharing Data apps

  • Using Python as a procedural language in PostgreSQL

  • World's Smallest Political Quiz v2.0 - Graphic Watermarks or Overlays

There will be following talks

  • Batteries Included: Things you can do with standard libraries

  • Corona Virus Computations and Plots using Python Notebooks in Google Colab 

There will be following talks

  • Introduction to the World of Neural Networks

  • Machine Learning approaches in personalized medicine and Biomarker discovery

There will be a talk, Building 1D Convolutional Neural Network Model in Keras for Sentimental Analysis.

Our Other Newsletters

 - A free weekly newsletter for programmers.

- A free weekly newsletter for entrepreneurs featuring best curated content, must read articles, how to guides, tips and tricks, resources, events and more.