ZH

欢迎阅读《pythonista周刊》第491期。Let us start 原文: https://mailchi.mp/pythonweekly/python-weekly-issue-491 翻译：Dustyposa 来自赞助商（PS：原文的赞助商）: Get Your Weekly Dose of Programming A weekly newsletter featuring the best hand curated news, articles, tutorials, talks, tools and libraries etc for programmers. Join For Free 文章、教程与话题 Working With Excel in Python 在本教程中，我们将探索如何在 Python 中使用 openpyxl 库和其他工具来处理 Excel 电子表格。特别是，我们将学习如何。处理作为输入的 Excel 文件，使用各种方法访问其中的数据，评估公式和将 Excel 文件作为输出写入。 Making lunch faster with Python concurrency A lunchtime story to demonstrate threading, asyncio, multiprocessing & cloud functions. Visualize multi-threaded Python programs with an open source tool VizTracer 追踪并发的 Python 程序，以帮助记录、调试和剖析。 Streaming video with FastAPI 我们将简要讨论互联网上流媒体视频的各种选项，并看到一个使用 FastAPI 的简单流媒体视频示例，它将使用 HTML5 视频标签在浏览器中显示视频。 实例驱动的Spark与Python的高级概述 这篇文章为你提供了一个高层次的、实例驱动的、使用 Python 编程语言绑定 Spark （俗称 PySpark）编写数据处理程序的概述。它特别介绍了 Spark SQL DataFrame API，这是使用 PySpark 编写数据分析代码最有用的方法。 Interfaces and Protocols Comparing zope.interface and typing.Protocol. 用较小的数据类型减少pandas的内存使用量 通过有效的使用数据类型来优化 pandas 的内存使用。 用Pyth-on-whales从Python调用Docker CLI 这篇文章重点介绍了一个新项目。Python-whales。这个项目的目标是在 Docker CLI 和 Python 库之间建立一个1对1的映射。 Github Actions CI/CD - 所有你需要的基础知识 Profiling Python code with py-spy ...

模式匹配在 Pythonic 原文: PyCoder’s Weekly - Issue #464 210317 Zoom.Quiet(大妈) 用时 42 分钟 完成快译 210317 Zoom.Quiet(大妈) 用时 37 分钟 完成格式转抄. Pythonic 的模式匹配教程 RODRIGO GIRÃO SERRÃO • Shared by Rodrigo Girão Serrão Structural pattern matching is coming in Python 3.10. This article explores how to use it to write Pythonic code by searching for some of the best use cases for the match statement. Keep in mind that match is still in alpha, so, while unlikely, some things may still change before the final version of 3.10 is released. (是也乎: 在 Erlang 用老的形式, 终于进入 Python, 不过, 也只是刚刚开始, 远没浸入内核, 只能当成语法糖先. ) PyQt6 vs PySide6: 两种 Python Qt 库间有什么区别? MARTIN FITZPATRICK There is a new version of Qt (version 6) and with it new versions of PyQt and PySide — now named PyQt6 & PySide6 respectively. Take a look at the latest versions of the libraries to identify the differences between them and find solutions for writing portable code. (是也乎: 表兄弟有什么不同? ) 用 Python/PyQt 和 SQLite 建立通讯录 REAL PYTHON In this step-by-step project, you’ll build a minimal contact book application using Python, with PyQt to build the application’s GUI and SQLite to handle the database. (是也乎: 真正上手项目, 可以立即让你反感 GUI 编程… ) 用 Flask/htmx 和 Tailwind CSS 进行快速原型制作 AMAL SHAJI • Shared by Amal Shaji Learn how to usee htmx and Tailwind CSS with Flask to quickly build interactive front-ends. Mu 版本 1.1.0-Beta.2 已发布 MADEWITH.MU (是也乎: 最萌 IDE 发布新版了 ) 探讨/吐糟 Discussions ...

欢迎阅读《pythonista周刊》第490期。Let us start 原文: https://mailchi.mp/pythonweekly/python-weekly-issue-490 翻译：Dustyposa 来自赞助商（PS：原文的赞助商）: RSVP for the 3rd Annual Python Web Conference (Virtual) | March 22-26, 2021 Experts discuss hard Python problems. 50+ talks on Machine Learning, AI, Big Data, Django, Plone, Serverless, CI/CD, Containers, etc. Join JetBrains and Six Feet Up to discuss what the future holds. ...

4000 个徦模块在 PyPI 原文: PyCoder’s Weekly - Issue #463 210310 Zoom.Quiet(大妈) 用时 42 分钟 完成快译 210310 Zoom.Quiet(大妈) 用时 37 分钟 完成格式转抄. Poison Packages: 用户在用 4000 个徦模块访问 Python 社区 PAUL DUCKLIN Recently, a PyPI user going by the name “Remind Supply Chain Risks” uploaded nearly 4000 fake modules to the index, many of which were named as common misspellings of popular packages. Learn about the incident in this article, and read all the way to the end for four tips every Python developer should follow. (是也乎: Fake News Fake Modules Fake People Fake … ) Atlas: 从 Python 巨石到托管平台的旅程 NAPHAT SANGUANSIN AND UTSAV SHAH See how dropbox migrated their internal systems from a monolith architecture to something more service-oriented without disrupting their users while also minimizing the operation cost that typically comes with owning a service. (是也乎: Dropbox 的奇幻想之旅 ) 更快地检测/诊断和解决代码级问题, 从而优化 Python 应用性能 DATADOG sponsor Datadog’s Continuous Profiler allows you to find the most resource-consuming parts in your production code all the time, at any scale, with minimal overhead. Improve MTTR, enhance user experience and reduce cloud provider costs with Datadog APM. Start troubleshooting your Python apps today → (是也乎: 良心赞助商. ) Django View 授权: 限制访问 REAL PYTHON course Learn how to restrict your web pages to users with different roles through Django view authorization. You’ll learn about HttpRequest.user objects, view decorators that authenticate, and how to notify your users with the Django messages framework. (是也乎: ) Django 3.2 令人兴奋的新功能 HAKI BENITA Django 3.2 is just around the corner and it’s packed with new features. Django versions are usually not that exciting — and that’s a good thing — but this time many features were added to the ORM. (是也乎: 是的, 没什么特性比增强 ORM 要来的兴奋/实用 ) PEP 621 最终 PYTHON.ORG In the near future, you’ll be able to store project metadata in pyproject.toml. (是也乎: 从 yaml 开始, 现在 toml 也转正了, 世界终究回到了 ML 的手中… ) Python 3.10.0a6 可用于测试 PYTHON.ORG Test it out today and take structural pattern matching for a spin! 探讨/吐糟 Discussions ...