%%sql
-- Find the total count of duplicate rows in the CLARITY_DATA table
SELECT SUM(duplicate_count - 1) AS total_duplicates
FROM (
SELECT COUNT(*) AS duplicate_count
FROM CLARITY_DATA
GROUP BY Date, Time, DateTime, Value, Treatment, Source
HAVING COUNT(*) > 1
) as duplicates;Abstract
A comprehensive 4-part series on analyzing continuous glucose monitor (CGM) data using Python, SQLite, and Tableau. Each part focuses on a specific step of the process, from building a clean dataset to creating interactive visualizations. Designed to be accessible for readers of all expertise levels, the series provides practical guidance for managing and interpreting CGM data. The post also links to each detailed article, providing a clear pathway for readers to follow the project step by step.
Key Points
Purpose of the Series: Guide readers through the process of analyzing CGM data, demonstrating practical applications of Python, SQLite, and Tableau.
Read more: Working with CGM Data: Python, SQLite, and Tableau in a 4-Part Series
Abstract
This post explores participation trends from the 2023 and 2024 5K@EASD events, highlighting the role of physical activity in diabetes management. Key insights include geographic distribution, gender-based participation, and race performance trends. Interactive Tableau visualizations offer a detailed, data-driven analysis of how the event's engagement has evolved over two years.
Key Points
Abstract
Explore advanced Python techniques for efficient data retrieval, focusing on handling large datasets, optimizing API calls, and ensuring data integrity. Whether you're working in healthcare analytics, financial modeling, or large-scale data science, these strategies will enhance your workflow and analysis capabilities.
Key Points
Explore the visualization of 5K@ADA race results using Tableau. Learn how to create interactive maps and charts that showcase geographic distribution and performance metrics. Discover how calculated fields and interactivity features in Tableau make the data analysis both engaging and informative.
Key Points
Page 4 of 8
