Issue #456

Automating Excel, Tracing the Python GIL, Python for Non-Developers, and More

Jan. 19, 2021

Automating Excel, Tracing the Python GIL, Python for Non-Developers, and More
#456 – JANUARY 19, 2021 VIEW IN BROWSER
The PyCoder’s Weekly Logo
Automating Excel File Creation and Distribution With Pandas And Outlook
See how a little bit of Python can go a long way to automating manual processes and save businesses valuable time.
CHRIS MOFFITT

Tracing the Python GIL
Learn how to trace and visualize the GIL, how the GIL affects performance, and how you use this information to write higher performance Python code.
MAARTEN BREDDELS

Introducing App Platform, a New PaaS That Gets Your Apps to Market, Faster
Get your apps to market faster with DigitalOcean’s App Platform. Build, deploy, and scale apps quickly using a simple, fully managed solution. We’ll handle the infrastructure, app runtimes and dependencies, so that you can push code to production in just a few clicks. Get started with $100 in free credit →
DIGITAL OCEANsponsor

That XOR Trick
Is the exclusive or (XOR) operator something you have in your programming toolit? Learn how it works and how to use it to solve some common interview questions.
FLORIAN HARTMANN

Introduction to Sorting Algorithms in Python
In this course, you’ll learn all about five different sorting algorithms in Python from both a theoretical and a practical standpoint. You’ll also learn several related and important concepts, including Big O notation and recursion.
REAL PYTHON

Write Bad Code to Win a Prize
Get a chance of winning a prize by writing code with an error that friendly-traceback can’t properly analyze.
AROBERGE.BLOGSPOT.COM

Django 3.2 Alpha 1 Released
DJANGO SOFTWARE FOUNDATION

PyCon 2021 Call for Proposals Open Until February 12
PYCON.ORG


Discussions


Double Precision Is Different in Different Languages
Representing numbers on a computer can be challenging. Understanding how representations get printed is also a challenge!
STACK OVERFLOW

Python Changed the Way I Think
Has learning to code influenced how you think about other things in your life?
REDDIT


Python Jobs


How Strong Is Your Resume?sponsor
Get a free, confidential review from a resume expert →

Entry-Level Engineering Programme
TESSIAN 📍 LONDON, UK

Senior Backend Engineer
TESSIAN 📍 LONDON, UK

Backend Engineer
TESSIAN 📍 LONDON, UK

Backend Engineer
FEATHER 📍 BERLIN, GERMANY

More Python Jobs >>>


Articles & Tutorials


Non-Developers Guide to the Python Programming Language
How would you introduce Python to someone who has never coded before and has little technical background? This beginner’s tutorial is written to be accessible by everyone, not just developers.
FATIH ERIKLI

Stellar Chart, a Type of Chart to Be on Your Radar
Stellar charts are an alternative to radar charts and are useful for showing characteristics of a profile (such as a tennis player’s statistics) in an eye-catching and easy-to-understand way. Learn how to create these charts in Matplotlib so you can add them to your data visualization repertoire.
JOÃO PALMEIRO

Automatically Find and Fix Python Vulnerabilities
Did you know that 96% of Python vulnerabilities have known fixes? Scan your apps for thousands of Python vulnerabilities in seconds. Fix quickly with one-click fix pull requests. Get started with Snyk to ship your Python apps faster, securely. Sign up for free →
SNYK.IOsponsor

Sentiment Analysis: First Steps With Python’s NLTK Library
Learn how to work with Python’s Natural Language Toolkit (NLTK) to process and analyze text. You’ll also learn how to perform sentiment analysis with built-in as well as custom classifiers!
REAL PYTHON

How to Analyze Volume Profiles With Python
Learn how to analyze volume profiles, a tool used in market analysis and algorithmic trading. While the article is focused on trading assets, the statistical analysis is applicable to a wide range of applications.
MINH NGUYEN

Best Practices for Orchestrating Python and R Code in ML Projects [2017]
The future of data science isn’t Python or R. It’s probably Python and R. Learn about some best practices for integrating both languages in thee same data science project.
MARIJA ILIĆ

Spend Less Time Debugging and More Time Building with Scout APM
Scout APM uses tracing logic to tie bottlenecks to source code to help developers identify and resolve performance issues at only $39 a month! Start your free 14-day trial today and we’ll donate $5 to the OSS project of your choice when you deploy!
SCOUT APMsponsor

Adding Social Authentication to Django
Learn how to add social authentication to Django applications using the Django Allauth library.
AMAL SHAJI

Python: Update All Packages With pip-review
Keeping track of Python dependencies and updates can be tricky. The pip-review tool automates a lot of this process in a convenient command-line interface.
STACK ABUSE

Make Your First Python Game: Rock, Paper, Scissors!
Learn to program rock paper scissors in Python from scratch. You’ll learn how to take in user input, make the computer choose a random action, determine a winner, and split your code into functions.
REAL PYTHON


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 →

pip-review: A Tool to Keep Track of Your Python Package Updates
GITHUB.COM/JGONGGRIJP

dbt: Transform Their Data Using the Same Practices That Software Engineers Use to Build Applications
GITHUB.COM/FISHTOWN-ANALYTICS

locust: Scalable User Load Testing Tool
GITHUB.COM/LOCUSTIO

best-of-web-python: Ranked List of Awesome Python Libraries for Web Development
GITHUB.COM/ML-TOOLING

caer: High-Performance Computer Vision Library
GITHUB.COM/JASMCAUS

pyRAPL: Measure the Python Energy Consumption of Python Code
GITHUB.COM/POWERAPI-NG

svm2csr: Fast Rust-Based SVMlight Parser
GITHUB.COM/VLAD17

CleverDict: Pythonic Dictionaries, Evolved
GITHUB.COM/PFYTHON • Shared by Peter Fison

📆🐍 Upcoming Python Events


Real Python Office Hours (Virtual)
January 20, 2020

BelPy
January 30 – 31, 2021

PyCascades 2021 (Virtual)
February 19 – 21, 2021

PyCon 2021 (Virtual)
May 12 – 18, 2021
Happy Pythoning!
Copyright © 2021 PyCoder’s Weekly, All rights reserved.