🗒 Read Specific Columns From CSV File

https://www.pythonforbeginners.com/basics/read-specific-columns-from-csv-file

@pythonl

🔋 Recipes from Python SQLite docs

https://rednafi.github.io/reflections/recipes-from-python-sqlite-docs.html

@pythonl

🔥 10 Unknown Security Pitfalls for Python

https://blog.sonarsource.com/10-unknown-security-pitfalls-for-python/

@pythonl

🗒 Daft

is a fast, ergonomic and scalable open-source dataframe library: built for Python and Complex Data/Machine Learning workloads.

pip install getdaft

⚙️ Github
📎 Docs

@pythonl

🕸 Web scraping open knowledge project

⚙️ Github

@pythonl

The Fuck 🖕

The Fuck is a magnificent app that corrects errors in previous console commands.

Если вы ошиблись в предыдущих командах в консоли вызовите The Fuck, интрумент постарается исправить команды и сделает «всё красиво»

pip install thefuck

⚙️ Github

@pythonl

⌚ Use pandas DateOffsets for easy date manipulation

import pandas as pd
now = pd.Timestamp.now()
print("Add a day:", now + pd.offsets.DateOffset(days=1))
print("Add a week:", now + pd.offsets.DateOffset(weeks=1))
print("Add a month:", now + pd.offsets.DateOffset(months=1))
print("Add an hour:", now + pd.offsets.DateOffset(hours=1))
print("Add a day, replace the hour:", now + pd.offsets.DateOffset(days=1, hour=13))
print("Add a month, normalize:", now + pd.offsets.DateOffset(month=1, normalize=True))
print("Add 2 days across DST change:", pd.Timestamp("2022-11-05 00:00:00", tz="America/Chicago") + pd.offsets.DateOffset(days=2))
print("Add 2 days across DST change (with Timedelta, no adjustment):", pd.Timestamp("2022-11-05 00:00:00", tz="America/Chicago") + pd.Timedelta(days=2))

https://www.wrighters.io/use-pandas-dateoffsets-for-easy-date-manipulation/

@pythonl

👨‍🍳 📙 📊 Python Data Viz Cookbook

https://dataviz.dylancastillo.co/

@pythonl

🚀 Rocketry

modern statement-based scheduling framework for Python. It is simple

pip install rocketry

⚙️ Github
🗒 Docs

@pythonl

↙️ Left Join Dataframes in Python

https://www.pythonforbeginners.com/basics/left-join-dataframes-in-python

@pythonl

🔎 Hunt down social media accounts by username across social networks

# clone the repo
$ git clone https://github.com/sherlock-project/sherlock.git

# change the working directory to sherlock
$ cd sherlock

# install the requirements
$ python3 -m pip install -r requirements.txt

⚙️ Github

@pythonl

🌐 translatepy

An aggregation of multiple translation API

pip install --upgrade translatepy

List of Built-in Services
- Microsoft Bing Translator
- DeepL
- Google Translate
- LibreTranslate
- Microsoft Translator
- MyMemory
- Reverso
- Translate.com
- Yandex Translate

⚙️ Github

@pythonl

✔️ Nebulo

Nebulo is a python library for building GraphQL APIs on top of PostgreSQL.

$ pip install nebulo

⚙️ Github
📃 Docs

@pythonl

🧑‍💻Generate a QR Code with Python

pip install pil
pip install "qrcode[pil]"

⚙️Github
🗒 Article

@pythonl