Category: data-analytics
-
Why You Should Stop Writing Loops in Pandas
Why You Should Stop Writing Loops in Pandas How to think in columns, write faster code, and finally use Pandas like a professional The post Why You Should Stop Writing Loops in Pandas appeared first on Towards Data Science. Ibrahim Salami Go to original source
-
The Rule Everyone Misses: How to Stop Confusing loc and iloc in Pandas
The Rule Everyone Misses: How to Stop Confusing loc and iloc in Pandas A simple mental model to remember when each one works (with examples that finally click). The post The Rule Everyone Misses: How to Stop Confusing loc and iloc in Pandas appeared first on Towards Data Science. Ibrahim Salami Go to original source
-
Stop Writing Messy Boolean Masks: 10 Elegant Ways to Filter Pandas DataFrames
Stop Writing Messy Boolean Masks: 10 Elegant Ways to Filter Pandas DataFrames Master the art of readable, high-performance data selection using .query(), .isin(), and advanced vectorized logic. The post Stop Writing Messy Boolean Masks: 10 Elegant Ways to Filter Pandas DataFrames appeared first on Towards Data Science. Ibrahim Salami Go to original source
-
Why Human-Centered Data Analytics Matters More Than Ever
Why Human-Centered Data Analytics Matters More Than Ever From optimizing metrics to designing meaning: putting people back into data-driven decisions The post Why Human-Centered Data Analytics Matters More Than Ever appeared first on Towards Data Science. Rashi Desai Go to original source
-
Beyond the Flat Table: Building an Enterprise-Grade Financial Model in Power BI
Beyond the Flat Table: Building an Enterprise-Grade Financial Model in Power BI A step-by-step journey through data transformation, star schema modeling, and DAX variance analysis with lessons learned along the way. The post Beyond the Flat Table: Building an Enterprise-Grade Financial Model in Power BI appeared first on Towards Data Science. Ibrahim Salami Go to original source
-
EDA in Public (Part 1): Cleaning and Exploring Sales Data with Pandas
EDA in Public (Part 1): Cleaning and Exploring Sales Data with Pandas Hey everyone! Welcome to the start of a major data journey that I’m calling “EDA in Public.” For those who know me, I believe the best way to learn anything is to tackle a real-world problem and share the entire messy process — including mistakes, victories,…
-
NumPy for Absolute Beginners: A Project-Based Approach to Data Analysis
NumPy for Absolute Beginners: A Project-Based Approach to Data Analysis Build a high-performance sensor data pipeline from scratch and unlock the true speed of Python’s scientific computing core The post NumPy for Absolute Beginners: A Project-Based Approach to Data Analysis appeared first on Towards Data Science. Ibrahim Salami Go to original source
-
What Building My First Dashboard Taught Me About Data Storytelling
What Building My First Dashboard Taught Me About Data Storytelling Why clarity beats complexity when turning data into stories people actually understand The post What Building My First Dashboard Taught Me About Data Storytelling appeared first on Towards Data Science. Benjamin Nweke Go to original source
-
Using NumPy to Analyze My Daily Habits (Sleep, Screen Time & Mood)
Using NumPy to Analyze My Daily Habits (Sleep, Screen Time & Mood) Can I use NumPy to figure out how my habits affect my mood and productivity? The post Using NumPy to Analyze My Daily Habits (Sleep, Screen Time & Mood) appeared first on Towards Data Science. Ibrahim Salami Go to original source
-
Hidden Gems in NumPy: 7 Functions Every Data Scientist Should Know
Hidden Gems in NumPy: 7 Functions Every Data Scientist Should Know I’ve been learning data analytics for a year now. So far, I can consider myself confident in SQL and Power BI. The transition to Python has been quite exciting. I’ve been exposed to some neat and smarter approaches to data analysis. After brushing up…
-
Optimize the dbt Doc Function with a CI
Optimize the dbt Doc Function with a CI How to set an automated check to improve your dbt documentation Image by the author (generated with chatgpt) In large dbt projects, maintaining consistent and up-to-date documentation can be a challenge. Although dbt’s {{ doc() }} function allows you to store and reuse descriptions for the columns of…
-
How to Pick Between Data Science, Data Analytics, Data Engineering, ML Engineering, and SW…
How to Pick Between Data Science, Data Analytics, Data Engineering, ML Engineering, and SW… Make the right choice for YOU Continue reading on Towards Data Science » Marina Wyss – Gratitude Driven Go to original source
-
Data behind the Luck, Ambition, and a Billion-Dollar Dream: Lottery
Data behind the Luck, Ambition, and a Billion-Dollar Dream: Lottery Using Seattle’s local retail store data for consumer patterns of the lottery (SQL, Python) Continue reading on Towards Data Science » Sunghyun Ahn Go to original source
-
The Lead, Shadow, and Sparring Roles in New Data Settings
The Lead, Shadow, and Sparring Roles in New Data Settings From data engineer to domain expert—what it takes to build a new data platform Continue reading on Towards Data Science » Marina Tosic Go to original source
-
Think you Know Excel? Take Your Analytics Skills to the Next Level with Power Query!
Think you Know Excel? Take Your Analytics Skills to the Next Level with Power Query! 5 practical use cases that prove Power Query is worth exploring. I have a confession to make: I’ve been living under a rock 🪨. Not literally, but how else can I explain not discovering Power Query in Excel until now? Imagine…