Exploring AI, technology & digital growth. Building, learning & sharing ideas along the way. Open to opportunities, collaborations & meaningful connections.
Day 57/100 โ Pandas ๐ผ
Focused on Pivot Tables & Crosstab.
Practiced 8 exercises and built a region ร month revenue pivot table.
Key insight: Small mistakes are part of real learning.
#100DaysOfData#DataAnalyst
Week 8/14 โ Day 56/100 ๐
Focused on Concat in Pandas.
Practiced stacking DataFrames and handling schema mismatches by combining monthly CSVs into one yearly dataset.
Key insight: Combining data consistently is essential for reliable analysis.
#100DaysOfData#DataAnalyst
Day 55/100 โ Pandas ๐ผ
Focused on merging data.
Practiced inner, left, right & outer merges and combined orders, customers & products into one analysis-ready table.
Key insight: Connecting the right data reveals the bigger picture.
#100DaysOfData#DataAnalyst
Day 54/100 โ Pandas ๐ผ
Focused on GroupBy & aggregation.
Practiced single & multi-column grouping and calculated revenue by region and month.
Key insight: Grouping data turns raw numbers into business insights.
#100DaysOfData#DataAnalyst
Day 53/100 โ Pandas ๐ผ
Focused on date/time manipulation.
Practiced "to_datetime", ".dt" and resampling, then extracted year, month & weekday features.
Key insight: Dates can reveal patterns hidden in raw data.
#100DaysOfData#DataAnalyst
Day 51/100 โ Pandas ๐ผ
Focused on data types & memory optimization.
Practiced dtype casting and optimized my DataFrame with better data types.
Key insight: Analytics isn't just about numbers โ it's about understanding what they mean.
#100DaysOfData#DataAnalyst
Day 50/100 โ Pandas ๐ผ
Focused on duplicates today.
Practiced detecting & removing duplicates, then documented the rows removed and why.
Key insight: Clean data starts with clean records.
#100DaysOfData#DataAnalyst
Week 7/14 โ Day 49/100 ๐
Focused on missing values in Pandas.
Practiced detecting, dropping & imputing NaNs and cleaned a dataset column-wise.
Also practiced two-pointer problems.
Key insight: Clean data leads to better answers.
#100DaysOfData#DataAnalyst
Day 48/100 โ Pandas ๐ผ
Focused on loc, iloc & boolean filtering.
Solved 10 exercises and filtered data using different business conditions.
Key insight: Good filtering turns raw data into useful answers.
#100DaysOfData#DataAnalyst
Day 47/100 โ Pandas ๐ผ
Started with Series, DataFrames & read_csv.
Loaded a messy dataset and explored it using ".info()" and ".describe()".
Key insight: Good analysis starts with understanding the data.
#100DaysOfData#DataAnalyst
Day 46/100 โ NumPy ๐งฎ
Started NumPy: arrays, indexing & vectorized operations.
Solved 10 exercises and rebuilt 3 earlier tasks using NumPy.
Key insight: Vectorization makes data work faster and cleaner.
#100DaysOfData#DataAnalyst
Day 45/100 โ DSA ๐ง
Hit the DSA checkpoint: ~25 problems + Big O review.
Solved 5 more and revisited 2 earlier problems without old solutions.
Updated my GitHub DSA problem tracker.
Key insight: Real progress is solving what once felt difficult.
#100DaysOfData#DataAnalyst
Day 44/100 โ DSA ๐ง
Mixed review: arrays, strings & hash maps.
Solved 5 timed problems and revisited my slowest solution.
Key insight: Practice shows the gap. Review closes it.
#100DaysOfData#DataAnalyst
Day 43/100 โ DSA ๐ง
Focused on Hash Maps.
Solved 5 problems: Two Sum, duplicates, anagrams, unique characters & Subarray Sum = K.
Also compared brute force vs HashMap.
Key insight: The right data structure changes the approach.
#100DaysOfData#DataAnalyst
Week 6/14 โ Day 42/100 ๐
Focused on DSA: Strings.
Practiced palindromes, anagrams, frequency counting, reverse strings & longest common prefix.
Pushed Day 40โ42 solutions to GitHub.
Consistency โ better problem-solving.
#100DaysOfData#DataAnalyst
Day 41/100 โ DSA ๐ง
Solved Two Sum, Max Subarray, Missing Number, Move Zeroes & Merge Sorted Arrays.
Focused on clean logic + complexity.
Key insight: Getting stuck is part of learning.
#100DaysOfData#DataAnalyst
Day 40/100 โ DSA ๐ง
Started arrays + Big O
Solved 5 problems: max/min, reverse, rotate, linear search & binary search.
Also noted the time complexity of each solution
Key insight: Writing code is one thing. Understanding how it scales is another.
#100DaysOfData#DataAnalyst
Day 39/100 โ Git & GitHub ๐
Practiced branches, commits, PRs & ".gitignore".
Cleaned my repo structure and created a proper project index in the README.
Key insight: Good analytics work also needs good version control.
#100DaysOfData#DataAnalyst
Day 38/100 โ Python ๐
Practiced try/except & debugging with 8 exercises.
Added error handling + logging to my CSV-cleaning script for bad rows.
Key insight: Good code doesn't just handle the happy pathโit handles the unexpected.
#100DaysOfData#DataAnalyst