Look Ma, Update DB to HTML5 Using C++ - No Hands
Explore seamless data transport from SQL databases to HTML5 interfaces using WebSocket and POCO framework, enhancing performance and enabling real-time updates without polling.
Polyglot Data with Python - Introducing Pandas and Apache Arrow
Explore polyglot data handling with Python using Pandas and Apache Arrow for efficient data exchange between ecosystems, improving performance and reducing file sizes.
From Spreadsheets to DataFrames
Learn to transition from spreadsheets to Python DataFrames, exploring web scraping, data processing, analysis, and visualization using popular libraries like Pandas and Matplotlib. Gain skills for efficient data management and problem-solving.
Getting Started with Polars
Explore Polars, a fast data manipulation library, through hands-on exercises with real-world datasets. Learn key operations, compare with Pandas, and optimize data pipelines.
Making Use of OpenStreetMap Data with Python
Explore OpenStreetMap data manipulation using Python, learning techniques to extract, analyze, and visualize geographic information for various applications.
Data Plumbing with Python
Explore efficient data manipulation techniques using Python for seamless integration, transformation, and analysis of diverse datasets.
Web API Mashups in a Python Application
Explore techniques for integrating multiple web APIs into Python applications, enhancing functionality and data richness through API mashups.
Python Without Filesystem
Explore Python's capabilities beyond traditional filesystem operations, focusing on alternative data storage and retrieval methods for enhanced performance and flexibility.
Python for Finance Part 1
Learn to leverage Python for financial analysis, modeling, and algorithmic trading. Explore practical applications in quantitative finance and risk management.
Data Analysis and Map-Reduce with MongoDB and PyMongo
Explore data analysis techniques using MongoDB's aggregation framework and pymongo. Learn to perform complex operations like grouping, reshaping, and map-reduce with practical examples and best practices.
How to Use Pandas the Wrong Way
Explore common pitfalls in pandas usage, focusing on performance and robustness. Learn efficient indexing, data type handling, and optimized group operations for better data manipulation.
Data Is Not Flat
Explore feature engineering techniques for low-dimensional data to enhance model performance, with a focus on neural network classification and practical examples.
Developing in a Black Hole - Vim, Tmux, Httpie and Jq
Explore vim, tmux, httpie, and jq for a streamlined, keyboard-centric development environment. Boost productivity with powerful terminal-based tools and techniques.
Practical Optimisations for Pandas
Discover techniques for optimizing Pandas code, including bottleneck identification, computational efficiency, and memory management for improved performance in data processing tasks.
Traveling Through a Secure API in Python
Learn to build a secure "Where Have I Been" map application using Python and Auth0, covering API endpoint creation, data protection, manipulation, and deployment.
I Have to Confess, I Still Love Pandas
Discover the power of Pandas for data science workflows. Learn advantages, efficient usage techniques, and fundamental concepts to enhance your data manipulation skills.
Zero-Copy Zen - Boost Performance with Memory View
Explore zero-copy techniques in Python using memory view objects to optimize data transfer, minimize memory usage, and boost performance when working with large datasets, sockets, and memory profiling.
Scipp - Multi-Dimensional Arrays with Labeled Dimensions and Physical Units
Explore Scipp's powerful features for handling multi-dimensional data arrays with named dimensions, physical units, and non-destructive binning. Learn about its intuitive visualization tools for Jupyter notebooks.
Polars vs Pandas - What's the Difference?
Explore the differences, pros, and cons of Polars and Pandas data manipulation libraries. Gain insights into their unique features and understand when to use each for optimal data analysis.
Building Your T-SQL Tool Kit - Window Function Fundamentals
Explore T-SQL window functions to enhance data analysis skills, improve query performance, and solve complex business problems efficiently.
Common Table Expressions - Advanced
Explore advanced Common Table Expressions: recursive queries, hierarchical data, data manipulation, common use cases, performance considerations, and classic recursive algorithms in SQL Server.