Announcing the official paper and electronic version of the 'Practical MongoDB Aggregations' book, published by Packt with new content.
A tutorial on using pipes and the .[] filter in jq, a command-line JSON processor, for data iteration and transformation.
A cleaned-up, de-interleaved transcript of text message exhibits from the Twitter v. Elon Musk lawsuit, presented for clarity.
Explains how to integrate Dask with Kubeflow to accelerate data preparation and ETL tasks in machine learning pipelines using distributed computing.
A guide to quickly install ClickHouse on macOS using a one-line shell command and demonstrates its use for converting CSV data to Parquet.
A guide to creating and using PostgreSQL triggers for automating data processing tasks, covering types, functions, and examples.
Practical strategies for staying current in the fast-moving field of machine learning, including project experimentation and community engagement.
A developer compares performance of a Rust-based TLD extraction script rewritten in Go, analyzing processing times on a large reverse DNS dataset.
A technical guide on using ksqlDB to process and transform complex JSON data from ActiveMQ via Kafka Connect, including array splitting.
A case study on automating Excel file creation and email distribution using Python's Pandas and Outlook integration.
A case study on using Python to automate the collection, cleaning, and processing of gigabytes of historical weather data for analysis.
An analysis of the CSV data format, covering its advantages, drawbacks, and common parsing pitfalls in data processing.
Explains the PHP array_chunk function, demonstrating how to split arrays into segments and use it for statistical calculations like weekly averages.
A talk on using Python to efficiently process and analyze large datasets from mass spectrometry, presented at a Python Frederick event.
A tutorial on using Python's itertools.groupby function to group and sort data, demonstrated with an employee list example.
A technical guide on fixing timestamp corruption in CSV data using pandas and uploading the corrected data to OmniSci using pymapd.
Explains the APPROX_COUNT_DISTINCT function for faster, memory-efficient distinct counts in SQL, comparing it to exact COUNT(DISTINCT).
A technical guide on extending the googleway package's google_distance() function in R to handle multiple inputs, cache API calls, and manage errors efficiently.
Final post in the GeoPAT 2 series, exploring advanced pattern-based spatial analysis methods and integration into custom workflows.
A guide to converting many .zip files to .gz format in parallel using a command-line one-liner for efficient disk usage.
