Stannley Mugabe’s Post

Most people use Pandas for EDA. 𝗩𝗲𝗿𝘆 𝗳𝗲𝘄 𝘂𝘀𝗲 𝗶𝘁 𝗲𝗳𝗳𝗶𝗰𝗶𝗲𝗻𝘁𝗹𝘆. That’s the difference between spending hours exploring data and getting insights in minutes. Over time, one thing has stood out to me: It’s not just about the insights - it’s about how efficiently you get there. I’ve put together a quick reference: 📊 10 Pandas EDA Tricks that help: • Write cleaner, more readable code • Speed up analysis • Build more reliable workflows 📌 Attached is a cheat sheet for easy reference. 𝗙𝗼𝗿 𝗮 𝗱𝗲𝘁𝗮𝗶𝗹𝗲𝗱 𝗯𝗿𝗲𝗮𝗸𝗱𝗼𝘄𝗻: 🔗 https://lnkd.in/gv6_TmUD What’s one Pandas tricks you use that saves you the most time? #DataAnalytics #DataScience #Python #Pandas #EDA

🚀 Day 12/30 of My LeetCode Journey (Python + SQL) Consistency continues… and the concepts are getting sharper! 💻🔥 🔹 **SQL Problem of the Day** 👉 *Invalid Tweets* Given a `Tweets` table, write a query to find tweet IDs where the content length is strictly greater than 15 characters. 💡 *Key Concept:* String functions like `LENGTH()` for validation. 🔹 **Python Problem of the Day** 👉 *Single Number* Given an array where every element appears twice except one, find that single element. 💡 *Key Concept:* Bit manipulation using XOR for optimal O(n) time and O(1) space. Loving how problem-solving is becoming more intuitive day by day ⚡ Day 12 done ✅ #LeetCode #30DaysChallenge #Python #SQL #CodingJourney #Consistency #ProblemSolving #Learning #BitManipulation

🚀 Day 6/30 of My LeetCode Journey (Python + SQL) Consistency is slowly turning into confidence 💪📈 🔹 **Python Problem of the Day** 👉 *Plus One* Given an integer represented as an array of digits, increment the number by one and return the resulting array. 💡 *Key Concept:* Handling carry from the last digit (especially edge cases like 9 → 10). 🔹 **SQL Problem of the Day** 👉 *Game Play Analysis I* Given a table of player activity, write a query to find the first login date for each player. 💡 *Key Concept:* GROUP BY with MIN() to extract earliest dates. Every day learning something new, refining logic, and improving speed ⚡ Day 6 done ✅ #LeetCode #30DaysChallenge #Python #SQL #CodingJourney #Consistency #ProblemSolving #Learning

Day 18 revision done. Operators. If/Else. Match statements. While loops. For loops. Not just reading through notes this time actually writing the code out, making mistakes, fixing them and doing it again until it felt natural. And honestly? It's working. The things that confused me the first time around are starting to make sense now. I finally get why // and % are different. I understand why indentation is not optional in Python. I know when to use a while loop vs a for loop. Revision isn't glamorous. There's no big aha moment. It's just you sitting down, doing the work and trusting that repetition builds confidence. And slowly it is making sense It is finally sticking and guess what I'm happy. Because Python is one of the most amazing tools used in the data space and I'm out here learning it on my own. Day 19 is next. Let's keep going. #Python #100DaysOfCode #SelfTaught #GrowthMindset #DataAnalysis #W3schools

Ever tried to sort a list and ended up with None? The logic looks correct: nums = [3, 1, 2] sorted_nums = nums.sort() print(sorted_nums) 👉 Output: None Why did it fail? In Python, there is a big difference between a Method that modifies an object and a Function that returns a new one. 1️⃣ .sort() is a Method: It modifies the original list "in-place." It doesn't need to return anything because the work is done directly on the original variable. 2️⃣ sorted() is a Function: It creates a brand-new list and leaves the original one exactly as it was. Use .sort() when you want to save memory and don't need the original order anymore. Use sorted() when you need to keep your original data safe and want a new sorted version. #Python #30DaysOfCode #BCA #LearningInPublic #Day22 #JECRC

Most beginners treat int64 and Int64 as the same. They’re not. 🔍 Quick insight: • int64 → NumPy type ❌ Does NOT support missing values • Int64 → Pandas nullable type ✅ Handles NaN in real-world datasets 💡 Why this matters: Real data is messy. Choosing the wrong data type can break your entire pipeline. Small detail. Big impact. #DataAnalytics #Python #Pandas #DataCleaning #LearningInPublic

Focus on the Process, Not the Project The dashboard gets finished. The model gets deployed. The output gets delivered. And then it's Next project. ✅ But how you explored the data — that stays. ✅ How you validated your results — that stays. ✅ How you questioned what didn't make sense — that stays. The project is temporary. The process is what compounds. Most people chase finished work as proof of progress. But finishing faster doesn't mean thinking better. 👉 Projects end. Your process stays. #DataAnalytics #Python #AnalyticsThinking #LearningInPublic

I understood NumPy better when I applied it to real data 👇 Learning concepts is one thing… But using them on actual data is different. So I tried a simple example: 👉 Dataset: list of student marks Task: Add 5 bonus marks to every student Using Python list: - needed a loop - more lines of code Using NumPy: - converted list → array - added 5 in a single step That’s it. What I realized: NumPy is not just about syntax. It’s about handling data efficiently at scale. Even a small example made it clear: - less code - faster execution - cleaner logic Now I’m focusing more on applying concepts, not just learning them. If you're learning NumPy, try this: 👉 Take any small dataset and apply operations on it That’s where real understanding begins. What’s one concept you learned but haven’t applied yet? #NumPy #Python #DataScience #DataEngineering #MachineLearning #CodingJourney #TechLearning

Day 5 of #30DaysOfPython ✅ Today I met two of Python's most powerful data structures. One of them already feels like home. The other? Slightly chaotic. Lists and dictionaries. Day 5. Lists made sense quickly — they're just ordered collections. I can store things, loop through them, sort them, slice them. Intuitive. Dictionaries? At first, the key-value pair concept felt abstract. The bug that got me today? I threw both strings and integers into the same list and tried to sort it. Python did not appreciate that. TypeError showed up like an old enemy. Day 5 done. 25 more to go! 👇 Lists vs dictionaries — when do you reach for one over the other? #Python #30DaysOfPython #DataStructures #StudentLife #AIML

Recursion confused me. So I built a visualizer for it. 🐍 Most beginners (including me) struggle with one thing: "What actually happens when a function calls itself?" So I wrote a Python program that shows you — step by step, with a delay so you can actually follow it. Watch it go DOWN the stack, hit the base case, then come back UP — adding numbers on the way. 👇 What I used: → Recursion — function calling itself → time.sleep() — to slow execution down visually → Print statements — to trace every step This isn't from a tutorial. I built this because I was confused. That's the best reason to build anything. 💡 Important: Dry run your code, It helps alot. #Python #Recursion #LearningInPublic #DataAnalytics #BBA #BuildInPublic