https://www.youtube.com/handle на ютьюбе можно выбрать псевдоним
go go go)

Подборка статей про оптимизацию Pandas

Статьи:
🔹 Memory Optimisation – Python DataFrames vs Lists and Dictionaries (JSON-like)
🔹 Advanced Pandas: Optimize speed and memory
🔹 Five Killer Optimization Techniques Every Pandas User Should Know
🔹 Pandas Optimization for Largest Datasets
🔹 How to handle large datasets in Python with Pandas and Dask
🔹 Scaling to large datasets
🔹 Comprehensive Guide To Optimize Your Pandas Code
🔹 Seven Killer Memory Optimization Techniques Every Pandas User Should Know
🔹 Optimizing Pandas
🔹 How to Find Pandas DataFrame Size, Shape, and Dimensions Properties

Видео:
🎦 Speed up slow pandas python code by 2500x
🎦 Efficient Pandas Dataframes in Python - Make your code run fast with these tricks!
🎦 Loop / Iterate over pandas DataFrame (2020)
🎦 How to Optimize and Speed Up Pandas

👉 @python_powerbi

Злободневное

Mining the Social Web, 3rd Edition (Jupyter Examples)

The official code repository for Mining the Social Web, 3rd Edition. The book is available from Amazon and Safari Books Online.

The notebooks folder of this repository contains the latest bug-fixed sample code used in the book chapters.

▫️ Chapter 0 - Preface.ipynb
▫️ Chapter 1 - Mining Twitter.ipynb
▫️ Chapter 2 - Mining Facebook.ipynb
▫️ Chapter 3 - Mining Instagram.ipynb
▫️ Chapter 4 - Mining LinkedIn.ipynb
▫️ Chapter 5 - Mining Text Files.ipynb
▫️ Chapter 6 - Mining Web Pages.ipynb
▫️ Chapter 7 - Mining Mailboxes.ipynb
▫️ Chapter 8 - Mining GitHub.ipynb
▫️ Chapter 9 - Twitter Cookbook.ipynb
▫️ _Appendix A - Virtual Machine Experience.ipynb
▫️ _Appendix B - OAuth Primer.ipynb
▫️ _Appendix C - Python & Jupyter Notebook Tips.ipynb

👉 @python_powerbi

https://github.com/mikhailklassen/Mining-the-Social-Web-3rd-Edition

BARC DATA CULTURE SURVEY 23

How to liberalize data access to empower data users

Обзор форматов данных и способы оптимизации при работе с Pandas

Подборка из трех статей:
🔸 The Best Format to Save Pandas Data
🔸 Optimize Storing in Pandas: 98% Faster Disk Reads and 72% Less Space
🔸 Stop persisting pandas data frames in CSVs

〰️〰️〰️
👉 @python_powerbi

Пишу диаграммы последовательностей текстом (кодом). Вы тоже можете

🖇️ https://habr.com/ru/company/rostelecom/blog/701970/

Waterfall vs. Agile

В свежем новостном выпуске Data Coffee:
— Что происходит в Яндексе
— Судьба арбузов и почерневших ягод
— Diagram as a Code и свежие интерфейсы для доступа к данным
— Ну и, конечно, Doom и VR!

#datacoffee #podcast #data

Где слушать🎧:
— Anchor.FM
— YouTube
— Бот (последний эпизод)
— Остальные площадки

Guide to Python comprehensions | Marcin Kozak | Towards Data Science
https://towardsdatascience.com/a-guide-to-python-comprehensions-4d16af68c97e

Google introduces new machine learning addon for Google Sheets - SiliconANGLE
https://siliconangle.com/2022/12/07/google-introduces-new-machine-learning-addon-google-sheets/

ClickHouse Academy https://clickhouse.com/learn/
Become a ClickHouse expert with our free official ClickHouse training

Например, блок ClickHouse Developer Courses содержит следующие курсы:
▫️ 101 - Getting Started (duration: 25 minutes)
▫️ 102 - Creating Databases and Tables (duration: 25 minutes)
▫️ 103 - ClickHouse Architecture (duration: 25 minutes)
▫️ 104 - Data Ingestion (duration: 20 minutes)
▫️ Deduplication (duration: 25 minutes)
▫️ Materialized Views (duration: 25 minutes)
▫️ Projections (duration: 15 minutes)

👉 @python_powerbi

JupyterLab for Data Science and Knowledge Graphs

JupyterLab image with VisualStudio Code server integrated, based on the jupyter/docker-stacks scipy image, with additional packages and kernels installed for data science and knowledge graphs.

With a docker-compose.yml file

Jupyter with Docker Compose

A docker-compose file for launching Jupyter Notebooks in a container.

https://github.com/stefanproell/jupyter-notebook-docker-compose

Artificial Intelligence with Power BI – SQLServerCentral
https://www.sqlservercentral.com/articles/artificial-intelligence-with-power-bi

Generation of diagrams like flowcharts or sequence diagrams from text in a similar manner as markdown

MIT License

Mermaid is a JavaScript-based diagramming and charting tool that uses Markdown-inspired text definitions and a renderer to create and modify complex diagrams. The main purpose of Mermaid is to help documentation catch up with development.

https://github.com/mermaid-js/mermaid

Juypter Notebooks for ClickHouse

This directory contains sample notebooks showing how to connect Python to ClickHouse.

Notebook code has been tested on Ubuntu using Anaconda and Python 3.7. They should work from Python 3.5 onwards.

▫️ EX-1.0-Getting-to-Know-the-Clickhouse-driver-Client.ipynb
▫️ EX-1.1-Something-You-Should-Not-Do.ipynb
▫️ EX-2-ClickHouse-SQL-Alchemy.ipynb
▫️ EX-3-Sql-Magic-Functions.ipynb
▫️ EX-4-Pivot-Using-SQL-And-Pandas.ipynb
▫️ EX-5-Airline-OnTime-Data.ipynb

-------------------------------------
👉 @python_powerbi