PythonHub
2.43K subscribers
2.35K photos
49.1K links
News & links about Python programming.
https://pythonhub.dev/
Download Telegram
SQL Databases with Pandas and Python - A Complete Guide

In this Python tuturial we talk all about connecting to SQL Databases with Python and Pandas. Python is the swiss army knife of data anaylsis, and relational databases are the most common way data is stored at small and large companies. Learning how to best connect the two is an essential skill for any data professional.

https://www.youtube.com/watch?v=DiQ5Hni6oRI
Understanding GPT tokenizers

Large language models such as GPT-3/4, LLaMA and PaLM work in terms of tokens. They take text, convert it into tokens (integers), then predict which tokens should come next. Playing around with these tokens is an interesting way to get a better idea for how this stuff actually works under the hood.

https://simonwillison.net/2023/Jun/8/gpt-tokenizers/
AsyncIO

The author argues that asyncio is too complex, difficult to use, and that its performance benefits are not worth the added complexity for most applications. The author recommends using gevent, another Python library that allows asynchronous programming, as an alternative to asyncio.

https://charlesleifer.com/blog/asyncio/
Understanding CPUs can help speed up Numba and NumPy code

With a little understanding of how CPUs and compilers work, you can speed up NumPy with faster Numba code.

https://pythonspeed.com/articles/speeding-up-numba/